--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)
values (1,'CDW','CDW (Extract - includes DSS NDE and Medical SAS)','CDW','http://www.cnn.com/','gov.va.vinci.dart.rule.CDWDocumentRuleEvaluator')

Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
values (2,'MCA (formerly DSS) NDE','MCA (formerly DSS) NDE','DSS','http://www.yahoo.com/','gov.va.vinci.dart.rule.DSSNDEDocumentRuleEvaluator')

Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
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')
--values (3,'Vital Status (Real SSN)','Vital Status Crosswalk file with Real SSN','Vital Status','http://www.msnbc.com/','gov.va.vinci.dart.rule.CDWDSSNDEDocumentRuleEvaluator')

Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
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')

Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
values (6,'Vital Status Files with Scrambled SSN','Vital Status Files with Scrambled SSN','Vital Status','NULL','gov.va.vinci.dart.rule.VitalStatusScrambledDocumentRuleEvaluator')
--values (6,'Vital Status (Scrambled SSN)','Vital Status File with Scrambled SSNs (SQL Server and SAS)','Vital Status','NULL','gov.va.vinci.dart.rule.VitalStatusScrambledDocumentRuleEvaluator')

Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
values (7,'BIRLS Real SSN (110JJ02)','BIRLS Real SSN (110JJ02)','BIRLS','NULL','gov.va.vinci.dart.rule.BIRLSDocumentRuleEvaluator')
--values (7,'BIRLS Death File','BIRLS Death File (Mainframe Access)','BIRLS','NULL','gov.va.vinci.dart.rule.BIRLSDocumentRuleEvaluator')

Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
values (8,'MCA (formerly DSS) Web Reports','MCA (formerly DSS) Web Reports','DSS','NULL','gov.va.vinci.dart.rule.BIRLSDocumentRuleEvaluator')

Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
values (9,'OEF/OIF (Real SSN)','OEF/OIF Roster File with Real SSNs','OEF/OIF','NULL','gov.va.vinci.dart.rule.OEFOIFRealDocumentRuleEvaluator')

Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
values (10,'OEF/OIF (Scrambled SSN)','OEF/OIF Roster File with Scrambled SSNs','OEF/OIF','NULL','gov.va.vinci.dart.rule.OEFOIFRealDocumentRuleEvaluator')

Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
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')
--values (11,'Vital Status (Mainframe - Real SSN)','Vital Status Crosswalk File with Real SSNs (Mainframe Access)','Vital Status','NULL','gov.va.vinci.dart.rule.BIRLSDocumentRuleEvaluator')

Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
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')
--values (12,'Vital Status (Mainframe - Scrambled SSN)','Vital Status with Scrambled SSN (Mainframe Access)','Vital Status','NULL','gov.va.vinci.dart.rule.VitalStatusMainframeScrambledDocumentRuleEvaluator')

Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
values (13,'VSSC Web Reports','VSSC Web Reports','VSSC','NULL','gov.va.vinci.dart.rule.BIRLSDocumentRuleEvaluator')

Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
values (1001,'CAPRI/VistAWeb','CAPRI/VistAWeb (Requires Real SSN Approval)','VistA','NULL','gov.va.vinci.dart.rule.CapriDocumentRuleEvaluator')
--values (1001,'CAPRI','CAPRI','VistA','NULL','gov.va.vinci.dart.rule.CapriDocumentRuleEvaluator')

Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
values (1002,'VistAWeb','VistAWeb','VistA','NULL','gov.va.vinci.dart.rule.CapriDocumentRuleEvaluator')


--; CDW Operations workflow
Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
values (1003,'Basic Read Access','Basic Read Access (Includes Production and Raw Domains)','CDW; SQL Format',null,'gov.va.vinci.dart.rule.OperationalDocumentRuleEvaluator')

Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
values (1004,'Privileged Read Access','Privileged Read Access (Provides access to SPatient Schema)','CDW; SQL Format',null,'gov.va.vinci.dart.rule.OperationalDocumentRuleEvaluator')

Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
values (1005,'SStaff Schema','SStaff (Provides access to SStaff Schema includes Staff Real SSN)','CDW; SQL Format',null,'gov.va.vinci.dart.rule.OperationalDocumentRuleEvaluator')

Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
values (1006, 'CDW MCA (formerly DSS) NDE','CDW MCA (formerly DSS) NDE','CDW; SQL Format',null,'gov.va.vinci.dart.rule.OperationalDocumentRuleEvaluator')

Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
values (1007, 'Vital Status','Vital Status','CDW; SQL Format',null,'gov.va.vinci.dart.rule.OperationalDocumentRuleEvaluator')



Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
values (1008, 'BIRLS Real SSN','BIRLS Real SSN ','CDW; SAS',null,'gov.va.vinci.dart.rule.OperationalDocumentRuleEvaluator')

Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
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')

Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
values (1010, 'MedSAS Files including VetsNet Files','MedSAS Files including VetsNet Files','CDW; SAS',null,'gov.va.vinci.dart.rule.OperationalDocumentRuleEvaluator')

Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
values (1011, 'Vital Status Files with Scrambled SSN','Vital Status Files with Scrambled SSN','CDW; SAS',null,'gov.va.vinci.dart.rule.OperationalDocumentRuleEvaluator')

Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
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')



Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
values (1013, 'BIRLS Real SSN (110JJ02)','BIRLS Real SSN (110JJ02)','Mainframe',null,'gov.va.vinci.dart.rule.OperationalDocumentRuleEvaluator')
--values (1013, 'BIRLS Real SSN (110JJ02)','BIRLS Real SSN (Mainframe Access)','Mainframe',null,'gov.va.vinci.dart.rule.OperationalDocumentRuleEvaluator')

Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
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')
--values (1014, 'MedSAS Files including VetsNet Files National Level Real SSN (1100TT01)','MedSAS Files National Level Real SSN (Mainframe Access)','Mainframe',null,'gov.va.vinci.dart.rule.OperationalDocumentRuleEvaluator')

Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
values (1015, 'MedSAS Files VISN Level Real SSN (1100TT05)','MedSAS Files VISN Level Real SSN (1100TT05)','Mainframe',null,'gov.va.vinci.dart.rule.OperationalDocumentRuleEvaluator')
--values (1015, 'MedSAS Files VISN Level Real SSN (1100TT05)','MedSAS Files VISN Level Real SSN (Mainframe Access)','Mainframe',null,'gov.va.vinci.dart.rule.OperationalDocumentRuleEvaluator')

Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
values (1016, 'Vital Status Files with Scrambled SSN (110NN06)','Vital Status Files with Scrambled SSN (110NN06)','Mainframe',null,'gov.va.vinci.dart.rule.OperationalDocumentRuleEvaluator')
--values (1016, 'Vital Status Files with Scrambled SSN (110NN06)','Vital Status File with Scrambled SSN (Mainframe Access)','Mainframe',null,'gov.va.vinci.dart.rule.OperationalDocumentRuleEvaluator')

Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
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')
--values (1017, 'Vital Status File Real SSN Crosswalk File (110TT20)','Vital Status File Real SSN Crosswalk File (Mainframe Access)','Mainframe',null,'gov.va.vinci.dart.rule.OperationalDocumentRuleEvaluator')



Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
values (1018, 'MCA (formerly DSS) Web Reports','MCA (formerly DSS) Web Reports','Other Data',null,'gov.va.vinci.dart.rule.OperationalDocumentRuleEvaluator')

Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
values (1019, 'OEF/OIF Roster File','OEF/OIF Roster File','Other Data',null,'gov.va.vinci.dart.rule.OperationalDocumentRuleEvaluator')

Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
values (1020, 'VSSC Web Reports','VSSC Web Reports','Other Data',null,'gov.va.vinci.dart.rule.OperationalDocumentRuleEvaluator')



Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
values (1021, 'Use of the SAS Grid','Use of the SAS Grid','Data Access Systems and Tools',null,'gov.va.vinci.dart.rule.OperationalDocumentRuleEvaluator')



--; New NDS workflow
Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
values (1022,'CDW Production Domains','CDW Production Domains','CDW; SQL Format',null,'gov.va.vinci.dart.rule.CDWDocumentRuleEvaluator')
--values (1022,'CDW Production Domains','CDW Production Domains (includes HERC, CAN Scores, PACT Pi2)','CDW; SQL Format',null,'gov.va.vinci.dart.rule.CDWDocumentRuleEvaluator')
--values (1022,'CDW Production Domains','CDW Production Domains (Must complete CDW Production Domain Checklist)','CDW; SQL Format',null,'gov.va.vinci.dart.rule.CDWDocumentRuleEvaluator')
--values (1022,'CDW Production Domains (Must complete CDW Production Domain Checklist)','CDW Production Domains','CDW; SQL Format',null,'gov.va.vinci.dart.rule.CDWDocumentRuleEvaluator')

Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
values (1023,'CDW Raw Domains','CDW Raw Domains','CDW; SQL Format',null,'gov.va.vinci.dart.rule.CDWDocumentRuleEvaluator')
--values (1023,'CDW Raw Domains','CDW Raw Domains (Must complete CDW Raw Domain Checklist)','CDW; SQL Format',null,'gov.va.vinci.dart.rule.CDWDocumentRuleEvaluator')
--values (1023,'CDW Raw Domains (Must complete CDW Raw Domain Checklist)','CDW Raw Domains','CDW; SQL Format',null,'gov.va.vinci.dart.rule.CDWDocumentRuleEvaluator')

Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
values (1024,'CDW MCA (formerly DSS) NDE','CDW MCA (formerly DSS) NDE','CDW; SQL Format',null,'gov.va.vinci.dart.rule.CDWDSSNDEDocumentRuleEvaluator')

Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
values (1025,'TIU Text Notes','TIU Text Notes (Requires Real SSN Approval)','CDW; SQL Format',null,'gov.va.vinci.dart.rule.CDWDSSNDEDocumentRuleEvaluator')
--values (1025,'TIU Text Notes (Requires Real SSN Approval)','TIU Text Notes','CDW; SQL Format',null,'gov.va.vinci.dart.rule.CDWDSSNDEDocumentRuleEvaluator')

Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
values (1026,'Vital Status','Vital Status Files (includes BIRLS)','CDW; SQL Format',null,'gov.va.vinci.dart.rule.VitalStatusSQLFormatRealDocumentRuleEvaluator')
--values (1026,'Vital Status','Vital Status','CDW; SQL Format',null,'gov.va.vinci.dart.rule.VitalStatusSQLFormatRealDocumentRuleEvaluator')



Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
values (1027,'BIRLS','BIRLS','CDW; SAS',null,'gov.va.vinci.dart.rule.CDWDSSNDEDocumentRuleEvaluator')

Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
values (1028,'MCA (formerly DSS) NDE (legacy)','MCA (formerly DSS) NDE (legacy)','CDW; SAS',null,'gov.va.vinci.dart.rule.CDWDSSNDEDocumentRuleEvaluator')

Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
values (1029,'MedSAS Files including VetsNet Files','MedSAS Files including VetsNet Files','CDW; SAS',null,'gov.va.vinci.dart.rule.CDWDSSNDEDocumentRuleEvaluator')




Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
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')

Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
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')


Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
values (1032,'Legacy Data Warehouses (i.e. VISN 21)','Legacy Data Warehouses (i.e. VISN 21)','Other',null,'gov.va.vinci.dart.rule.CDWDocumentRuleEvaluator')
--values (1032,'Legacy Data Warehouses (i.e. VISN 21)','Legacy Data Warehouses','Other',null,'gov.va.vinci.dart.rule.CDWDocumentRuleEvaluator')


Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
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')


Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
values (1034,'Surgery Quality Data Users Group (SQDUG)','Surgery Quality Data Users Group (SQDUG)','Other',null,'gov.va.vinci.dart.rule.SQDUGDocumentRuleEvaluator')	--CDWDocumentRuleEvaluator



Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
values (1035, 'SAS Grid','SAS Grid','Data Access Systems',null,'gov.va.vinci.dart.rule.SASGridDocumentRuleEvaluator')
--   update [VINCI].[hib].[datasource] set evaluator='gov.va.vinci.dart.rule.SASGridDocumentRuleEvaluator' where id=1035



--Homeless Registry
Insert into hib.datasource (id, name, description, domainname, infosite, evaluator) 
values (1036,'Homeless Registry','Homeless Registry','Other',null,'gov.va.vinci.dart.rule.CDWDSSNDEDocumentRuleEvaluator')



Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
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')

Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
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')

Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
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')

Insert into hib.datasource (id, name, description, domainname, infosite, evaluator)
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')



SET IDENTITY_INSERT  hib.datasource  OFF