--select * from hib.datasource

Delete from hib.datasource


SET IDENTITY_INSERT  hib.datasource  ON


--; Original  NDS workflow
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (1,'CDW','CDW (Extract - includes DSS NDE and Medical SAS)','CDW','http://www.cnn.com/','gov.va.vinci.dart.rule.CDWDocumentRuleEvaluator', 1)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (2,'MCA (formerly DSS) NDE','MCA (formerly DSS) NDE','DSS','http://www.yahoo.com/','gov.va.vinci.dart.rule.DSSNDEDocumentRuleEvaluator', 1)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (3,'Vital Status File Real SSN Crosswalk File','Vital Status File Real SSN Crosswalk File','Vital Status','http://www.msnbc.com/','gov.va.vinci.dart.rule.CDWDSSNDEDocumentRuleEvaluator', 1)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (4,'Med SAS Access (Real SSN)','Medical SAS Data Sets with Real SSNs (Mainframe...','Med SAS','http://www.cnn.com/','gov.va.vinci.dart.rule.MedSASDocumentRuleEvaluator', 1)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (6,'Vital Status Files with Scrambled SSN','Vital Status Files with Scrambled SSN','Vital Status','NULL','gov.va.vinci.dart.rule.VitalStatusScrambledDocumentRuleEvaluator', 1)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (7,'BIRLS Real SSN (110JJ02)','BIRLS Real SSN (110JJ02)','BIRLS','NULL','gov.va.vinci.dart.rule.BIRLSDocumentRuleEvaluator', 1)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (8,'MCA (formerly DSS) Web Reports','MCA (formerly DSS) Web Reports','DSS','NULL','gov.va.vinci.dart.rule.BIRLSDocumentRuleEvaluator', 1)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (9,'OEF/OIF (Real SSN)','OEF/OIF Roster File with Real SSNs','OEF/OIF','NULL','gov.va.vinci.dart.rule.OEFOIFRealDocumentRuleEvaluator', 1)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (10,'OEF/OIF (Scrambled SSN)','OEF/OIF Roster File with Scrambled SSNs','OEF/OIF','NULL','gov.va.vinci.dart.rule.OEFOIFRealDocumentRuleEvaluator', 1)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (11,'Vital Status File Real SSN Crosswalk File (110TT20)','Vital Status File Real SSN Crosswalk File (110TT20)','Vital Status','NULL','gov.va.vinci.dart.rule.BIRLSDocumentRuleEvaluator', 1)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (12,'Vital Status Files with Scrambled SSN (110NN06)','Vital Status Files with Scrambled SSN (110NN06)','Vital Status','NULL','gov.va.vinci.dart.rule.VitalStatusMainframeScrambledDocumentRuleEvaluator', 1)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (13,'VSSC Web Reports','VSSC Web Reports','VSSC','NULL','gov.va.vinci.dart.rule.BIRLSDocumentRuleEvaluator', 1)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (1001,'CAPRI/VistAWeb','CAPRI/VistAWeb (Requires Real SSN Approval)','VistA','NULL','gov.va.vinci.dart.rule.CapriDocumentRuleEvaluator', 1)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (1002,'VistAWeb','VistAWeb','VistA','NULL','gov.va.vinci.dart.rule.CapriDocumentRuleEvaluator', 1)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (1003,'Basic Read Access','Basic Read Access (Includes Production and Raw Domains)','CDW; SQL Format',null,'gov.va.vinci.dart.rule.OperationalDocumentRuleEvaluator', 1)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (1004,'Privileged Read Access','Privileged Read Access (Provides access to SPatient Schema)','CDW; SQL Format',null,'gov.va.vinci.dart.rule.OperationalDocumentRuleEvaluator', 1)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (1005,'SStaff Schema','SStaff (Provides access to SStaff Schema includes Staff Real SSN)','CDW; SQL Format',null,'gov.va.vinci.dart.rule.OperationalDocumentRuleEvaluator', 1)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (1006, 'CDW MCA (formerly DSS) NDE','CDW MCA (formerly DSS) NDE','CDW; SQL Format',null,'gov.va.vinci.dart.rule.OperationalDocumentRuleEvaluator', 1)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (1007, 'Vital Status','Vital Status','CDW; SQL Format',null,'gov.va.vinci.dart.rule.OperationalDocumentRuleEvaluator', 1)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (1008, 'BIRLS Real SSN','BIRLS Real SSN ','CDW; SAS',null,'gov.va.vinci.dart.rule.OperationalDocumentRuleEvaluator', 1)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (1009, 'MCA (formerly DSS) NDE SAS (legacy files)','MCA (formerly DSS) NDE SAS (legacy files)','CDW; SAS',null,'gov.va.vinci.dart.rule.OperationalDocumentRuleEvaluator', 1)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (1010, 'MedSAS Files including VetsNet Files','MedSAS Files including VetsNet Files','CDW; SAS',null,'gov.va.vinci.dart.rule.OperationalDocumentRuleEvaluator', 1)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (1011, 'Vital Status Files with Scrambled SSN','Vital Status Files with Scrambled SSN','CDW; SAS',null,'gov.va.vinci.dart.rule.OperationalDocumentRuleEvaluator', 1)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (1012, 'Vital Status File Real SSN Crosswalk File','Vital Status File Real SSN Crosswalk File','CDW; SAS',null,'gov.va.vinci.dart.rule.OperationalDocumentRuleEvaluator', 1)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (1013, 'BIRLS Real SSN (110JJ02)','BIRLS Real SSN (110JJ02)','Mainframe',null,'gov.va.vinci.dart.rule.OperationalDocumentRuleEvaluator', 1)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (1014, 'MedSAS Files including VetsNet Files National Level Real SSN (1100TT01)','MedSAS Files including VetsNet Files National Level Real SSN (1100TT01)','Mainframe',null,'gov.va.vinci.dart.rule.OperationalDocumentRuleEvaluator', 1)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (1015, 'MedSAS Files VISN Level Real SSN (1100TT05)','MedSAS Files VISN Level Real SSN (1100TT05)','Mainframe',null,'gov.va.vinci.dart.rule.OperationalDocumentRuleEvaluator', 1)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (1016, 'Vital Status Files with Scrambled SSN (110NN06)','Vital Status Files with Scrambled SSN (110NN06)','Mainframe',null,'gov.va.vinci.dart.rule.OperationalDocumentRuleEvaluator', 1)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (1017, 'Vital Status File Real SSN Crosswalk File (110TT20)','Vital Status File Real SSN Crosswalk File (110TT20)','Mainframe',null,'gov.va.vinci.dart.rule.OperationalDocumentRuleEvaluator', 1)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (1018, 'MCA (formerly DSS) Web Reports','MCA (formerly DSS) Web Reports','Other Data',null,'gov.va.vinci.dart.rule.OperationalDocumentRuleEvaluator', 1)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (1019, 'OEF/OIF Roster File','OEF/OIF Roster File','Other Data',null,'gov.va.vinci.dart.rule.OperationalDocumentRuleEvaluator', 1)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (1020, 'VSSC Web Reports','VSSC Web Reports','Other Data',null,'gov.va.vinci.dart.rule.OperationalDocumentRuleEvaluator', 1)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (1021, 'Use of the SAS Grid','Use of the SAS Grid','Data Access Systems and Tools',null,'gov.va.vinci.dart.rule.OperationalDocumentRuleEvaluator', 1)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (1022,'CDW Production Domains','CDW Production Domains','CDW; SQL Format',null,'gov.va.vinci.dart.rule.CDWDocumentRuleEvaluator', 1)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (1023,'CDW Raw Domains','CDW Raw Domains','CDW; SQL Format',null,'gov.va.vinci.dart.rule.CDWDocumentRuleEvaluator', 1)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (1024,'CDW MCA (formerly DSS) NDE','CDW MCA (formerly DSS) NDE','CDW; SQL Format',null,'gov.va.vinci.dart.rule.CDWDSSNDEDocumentRuleEvaluator', 1)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (1025,'TIU Text Notes','TIU Text Notes (Requires Real SSN Approval)','CDW; SQL Format',null,'gov.va.vinci.dart.rule.CDWDSSNDEDocumentRuleEvaluator', 1)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (1026,'Vital Status','Vital Status Files (includes BIRLS)','CDW; SQL Format',null,'gov.va.vinci.dart.rule.VitalStatusSQLFormatRealDocumentRuleEvaluator', 1)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (1027,'BIRLS','BIRLS','CDW; SAS',null,'gov.va.vinci.dart.rule.CDWDSSNDEDocumentRuleEvaluator', 1)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (1028,'MCA (formerly DSS) NDE (legacy)','MCA (formerly DSS) NDE (legacy)','CDW; SAS',null,'gov.va.vinci.dart.rule.CDWDSSNDEDocumentRuleEvaluator', 1)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (1029,'MedSAS Files including VetsNet Files','MedSAS Files including VetsNet Files','CDW; SAS',null,'gov.va.vinci.dart.rule.CDWDSSNDEDocumentRuleEvaluator', 1)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (1030,'MedSAS including VetsNet Files for National Level Real SSN (1100TT01)','MedSAS including VetsNet Files for National Level Real SSN (1100TT01)','Mainframe',null,'gov.va.vinci.dart.rule.BIRLSDocumentRuleEvaluator', 1)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (1031,'MedSAS Files for VISN Level Real SSN (1100TT05)','MedSAS Files for VISN Level Real SSN (1100TT05)','Mainframe',null,'gov.va.vinci.dart.rule.BIRLSDocumentRuleEvaluator', 1)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (1032,'Legacy Data Warehouses (i.e. VISN 21)','Legacy Data Warehouses (i.e. VISN 21)','Other',null,'gov.va.vinci.dart.rule.CDWDocumentRuleEvaluator', 1)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (1033,'OEF/OIF Roster File','OEF/OIF Roster File (DUA required for internal data distribution/use)','Other',null,'gov.va.vinci.dart.rule.OEFOIFRealDocumentRuleEvaluator', 9)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (1034,'Surgery Quality Data Users Group (SQDUG)','Surgery Quality Data Users Group (SQDUG)','Other',null,'gov.va.vinci.dart.rule.SQDUGDocumentRuleEvaluator', 11)    --CDWDocumentRuleEvaluator
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (1035, 'SAS Grid','SAS Grid','Data Access Systems',null,'gov.va.vinci.dart.rule.SASGridDocumentRuleEvaluator', 1)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (1036,'Homeless Registry','Homeless Registry','Other',null,'gov.va.vinci.dart.rule.CDWDSSNDEDocumentRuleEvaluator', 1)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (1037,'Health Economics Resource Center (HERC) Average Cost Data','Health Economics Resource Center (HERC) Average Cost Data','Other',null,'gov.va.vinci.dart.rule.CDWDocumentRuleEvaluator', 1)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (1038,'Health Economics Resource Center (HERC) V21 and Nosos Risk Scores Data','Health Economics Resource Center (HERC) V21 and Nosos Risk Scores Data','Other',null,'gov.va.vinci.dart.rule.CDWDocumentRuleEvaluator', 1)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (1039,'Patient Aligned Care Team (PACT) Implementation Index (Pi2)','Patient Aligned Care Team (PACT) Implementation Index (Pi2)','Other',null,'gov.va.vinci.dart.rule.CDWDocumentRuleEvaluator', 1)
INSERT INTO hib.datasource (id, name, description, domainname, infosite, evaluator, groupid)VALUES (1040,'Care Assessment Need (CAN) Score (Requires Scrambled SSN Level Access)','Care Assessment Need (CAN) Score (Requires Scrambled SSN Level Access)','Other',null,'gov.va.vinci.dart.rule.CDWDocumentRuleEvaluator', 1)

SET IDENTITY_INSERT  hib.datasource  OFF