--select * from hib.documenttemplate

Delete from hib.documenttemplate


SET IDENTITY_INSERT  hib.documenttemplate  ON


Insert into hib.documenttemplate (id,name,description,location,participant,administrator,activitytype,principalinvestigator,sortorder)
values (4,'Research Request Memo',null,0,0,0,'R',0,9)

Insert into hib.documenttemplate (id,name,description,location,participant,administrator,activitytype,principalinvestigator,sortorder)
values (5,'Research Study Institutional Review Board (IRB) Approval Letter',null,0,0,0,'R',0,12)

Insert into hib.documenttemplate (id,name,description,location,participant,administrator,activitytype,principalinvestigator,sortorder)
values (6,'CDW-VINCI Rules of Behavior',null,0,0,0,'R',0,13)

Insert into hib.documenttemplate (id,name,description,location,participant,administrator,activitytype,principalinvestigator,sortorder)
values (7,'Sample Informed Consent and HIPAA Authorization',null,0,0,0,'R',0,14)

Insert into hib.documenttemplate (id,name,description,location,participant,administrator,activitytype,principalinvestigator,sortorder)
values (8,'VA Privacy Statement',null,0,0,0,'R',0,15)

Insert into hib.documenttemplate (id,name,description,location,participant,administrator,activitytype,principalinvestigator,sortorder)
values (9,'Research and Development (RD) Committee Approval Letter',null,0,0,0,'R',0,71)

Insert into hib.documenttemplate (id,name,description,location,participant,administrator,activitytype,principalinvestigator,sortorder)
values (10,'VA Form 9957',null,0,0,0,'R',0,72)

Insert into hib.documenttemplate (id,name,description,location,participant,administrator,activitytype,principalinvestigator,sortorder)
values (11,'DSS Non-Disclosure Agreement',null,0,0,0,'R',0,77)

Insert into hib.documenttemplate (id,name,description,location,participant,administrator,activitytype,principalinvestigator,sortorder)
values (12,'Data Use Agreement',null,0,0,0,'R',0,79)

Insert into hib.documenttemplate (id,name,description,location,participant,administrator,activitytype,principalinvestigator,sortorder)
values (13,'IRB Approval of Waiver of HIPAA-Compliant Authorization',null,0,0,0,'R',0,102)

Insert into hib.documenttemplate (id,name,description,location,participant,administrator,activitytype,principalinvestigator,sortorder)
values (14,'PI must submit the CDW ROB',null,0,0,0,'R',0,103)

Insert into hib.documenttemplate (id,name,description,location,participant,administrator,activitytype,principalinvestigator,sortorder)
values (15,'PI must submit the VA Privacy Statement',null,0,0,0,'R',0,104)

Insert into hib.documenttemplate (id,name,description,location,participant,administrator,activitytype,principalinvestigator,sortorder)
values (16,'Vital Status Rules of Behavior',null,0,0,0,'R',0,106)

Insert into hib.documenttemplate (id,name,description,location,participant,administrator,activitytype,principalinvestigator,sortorder)
values (17,'GEC (Geriatrics and Extended Care) Data Use Agreement (DUA)',null,0,0,0,'R',0,108)

Insert into hib.documenttemplate (id,name,description,location,participant,administrator,activitytype,principalinvestigator,sortorder)
values (18,'Research Protocol',null,0,0,0,'R',0,109)

Insert into hib.documenttemplate (id,name,description,location,participant,administrator,activitytype,principalinvestigator,sortorder)
values (19,'CDW-Domain Checklist',null,0,0,0,'R',0,149)

Insert into hib.documenttemplate (id,name,description,location,participant,administrator,activitytype,principalinvestigator,sortorder)
values (20,'VSSCS Data Use Agreement',null,0,0,0,'R',0,155)

Insert into hib.documenttemplate (id,name,description,location,participant,administrator,activitytype,principalinvestigator,sortorder)
values (21,'NDS Data Use Agreement',null,0,0,0,'R',0,162)

Insert into hib.documenttemplate (id,name,description,location,participant,administrator,activitytype,principalinvestigator,sortorder)
values (22,'CDW Rules of Behavior',null,0,0,0,'R',0,163)

Insert into hib.documenttemplate (id,name,description,location,participant,administrator,activitytype,principalinvestigator,sortorder)
values (23,'ORD 9957',null,0,0,0,'R',0,164)

Insert into hib.documenttemplate (id,name,description,location,participant,administrator,activitytype,principalinvestigator,sortorder)
values (24,'Research Privacy Review Checklist',null,0,0,0,'R',0,165)

Insert into hib.documenttemplate (id,name,description,location,participant,administrator,activitytype,principalinvestigator,sortorder)
values (25,'VSSC OEF/OIF Roster File DUA',null,0,0,0,'R',0,176)

Insert into hib.documenttemplate (id,name,description,location,participant,administrator,activitytype,principalinvestigator,sortorder)
values (26,'VHA Privacy Data Access Agreement',null,0,0,0,'R',0,177)

Insert into hib.documenttemplate (id,name,description,location,participant,administrator,activitytype,principalinvestigator,sortorder)
values (27,'VHA Privacy DAA',null,0,0,0,'R',0,178)

Insert into hib.documenttemplate (id,name,description,location,participant,administrator,activitytype,principalinvestigator,sortorder)
values (28,'Project Information and Authorization',null,0,0,0,'R',0,179)

Insert into hib.documenttemplate (id,name,description,location,participant,administrator,activitytype,principalinvestigator,sortorder)
values (29,'Agreement To Provide Secure Data Storage At Terminal',null,0,0,0,'R',0,180)

Insert into hib.documenttemplate (id,name,description,location,participant,administrator,activitytype,principalinvestigator,sortorder)
values (30,'Data Security Compliance Checklist',null,0,0,0,'R',0,181)

Insert into hib.documenttemplate (id,name,description,location,participant,administrator,activitytype,principalinvestigator,sortorder)
values (31,'IRB Continuing Review Approval Letter',null,0,0,0,'R',0,182)

Insert into hib.documenttemplate (id,name,description,location,participant,administrator,activitytype,principalinvestigator,sortorder)
values (32,'Data Description',null,0,0,0,'R',0,183)

Insert into hib.documenttemplate (id,name,description,location,participant,administrator,activitytype,principalinvestigator,sortorder)
values (33,'VA/CMS Rules of Behavior',null,0,0,0,'R',0,184)

Insert into hib.documenttemplate (id,name,description,location,participant,administrator,activitytype,principalinvestigator,sortorder)
values (34,'VIReC Data Use Agreement',null,0,0,0,'R',0,185)

Insert into hib.documenttemplate (id,name,description,location,participant,administrator,activitytype,principalinvestigator,sortorder)
values (35,'DAC Review Checklist',null,0,0,0,'R',0,186)

Insert into hib.documenttemplate (id,name,description,location,participant,administrator,activitytype,principalinvestigator,sortorder)
values (36,'Completeness Review Checklist',null,0,0,0,'R',0,187)

Insert into hib.documenttemplate (id,name,description,location,participant,administrator,activitytype,principalinvestigator,sortorder)
values (37,'TD Initial Review Checklist',null,0,0,0,'R',0,188)

Insert into hib.documenttemplate (id,name,description,location,participant,administrator,activitytype,principalinvestigator,sortorder)
values (38,'TD Initial Release Checklist',null,0,0,0,'R',0,189)

Insert into hib.documenttemplate (id,name,description,location,participant,administrator,activitytype,principalinvestigator,sortorder)
values (39,'Internal Document Review Checklist',null,0,0,0,'R',0,190)

Insert into hib.documenttemplate (id,name,description,location,participant,administrator,activitytype,principalinvestigator,sortorder)
values (40,'Signed VIReC DUA',null,0,0,0,'R',0,191)

Insert into hib.documenttemplate (id,name,description,location,participant,administrator,activitytype,principalinvestigator,sortorder)
values (41,'Data Transfer for Temporary Storage (Required)',null,0,0,0,'R',0,192)

Insert into hib.documenttemplate (id,name,description,location,participant,administrator,activitytype,principalinvestigator,sortorder)
values (42,'OEF-OIF Data Use Agreement',null,0,0,0,'R',0,155)

Insert into hib.documenttemplate (id,name,description,location,participant,administrator,activitytype,principalinvestigator,sortorder)
values (43,'EHR Access Request Form','EHR Access Request Form',0,0,0,'R',0,200)


--; CDW Operations workflow
Insert into hib.documenttemplate (id,name,description,location,participant,administrator,activitytype,principalinvestigator,sortorder)
values (44,'CDW Justification Memo',null,0,0,0,'O',0,1)
--; The one Operational workflow document to rule them all as of 4/25/2013
Insert into hib.documenttemplate (id,name,description,location,participant,administrator,activitytype,principalinvestigator,sortorder)
values (45,'VHA NDS Health Operations',null,0,0,0,'O',0,2)


--; Real SSN Access Request, new as of Aug. 13, 2014
Insert into hib.documenttemplate (id,name,description,location,participant,administrator,activitytype,principalinvestigator,sortorder)
values (46,'Real SSN Access Request','Real SSN Access Request',0,0,0,'R',0,201)


--SQDUG documents
Insert into hib.documenttemplate (id,name,description,location,participant,administrator,activitytype,principalinvestigator,sortorder)
values (47,'Surgery Data Research Proposal','Surgery Data Research Proposal',0,0,0,'R',0,202)

Insert into hib.documenttemplate (id,name,description,location,participant,administrator,activitytype,principalinvestigator,sortorder)
values (48,'VASQIP Variable Checklist(s) (Cardiac/Non-Cardiac, Ophthalmology, and/or Transplant)','VASQIP Variable Checklist(s) (Cardiac/Non-Cardiac, Ophthalmology, and/or Transplant)',0,0,0,'R',0,203)
--values (48,'Surgery Variable Checklist(s)','Surgery Variable Checklist(s)',0,0,0,'R',0,203)

Insert into hib.documenttemplate (id,name,description,location,participant,administrator,activitytype,principalinvestigator,sortorder)
values (49,'National Surgery Office (NSO) Data Use Agreement (DUA) Data Request and Security Information','National Surgery Office (NSO) Data Use Agreement (DUA) Data Request and Security Information',0,0,0,'R',0,204)
--values (49,'National Surgery Office (NSO) Data Use Agreement','National Surgery Office (NSO) Data Use Agreement',0,0,0,'R',0,204)

Insert into hib.documenttemplate (id,name,description,location,participant,administrator,activitytype,principalinvestigator,sortorder)
values (50,'Review Summary','Review Summary',0,0,0,'R',0,205)




SET IDENTITY_INSERT  hib.documenttemplate  OFF
