USE $(DATA_BASE_NAME);
GO

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);

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);

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);

INSERT into hib.documenttemplate (id,name,description,location,participant,administrator,activitytype,principalinvestigator,sortorder)
VALUES (51,'Preparatory to Research Memorandum','Preparatory to Research Memorandum',0,0,0,'P',0,1);


SET IDENTITY_INSERT  hib.documenttemplate  OFF