Produced by Araxis Merge on 4/7/2019 7:13:41 PM Eastern Daylight Time. See www.araxis.com for information about Merge. This report uses XHTML and CSS2, and is best viewed with a modern standards-compliant browser. For optimum results when printing this report, use landscape orientation and enable printing of background images and colours in your browser.
# | Location | File | Last Modified |
---|---|---|---|
1 | MHLTH_CLOZ_MOD _SRC.zip\MHLTH_CLOZ_MOD _SRC\Releases\ClozMod_Build5_.zip\Va.Gov.Nccc.Data.Sql\Scripts | InitialDatabaseSeedData.sql | Mon Mar 4 20:33:52 2019 UTC |
2 | MHLTH_CLOZ_MOD _SRC.zip\MHLTH_CLOZ_MOD _SRC\Releases\ClozMod_Build5_.zip\Va.Gov.Nccc.Data.Sql\Scripts | InitialDatabaseSeedData.sql | Thu Apr 4 19:01:02 2019 UTC |
Description | Between Files 1 and 2 |
|
---|---|---|
Text Blocks | Lines | |
Unchanged | 2 | 928 |
Changed | 1 | 2 |
Inserted | 0 | 0 |
Removed | 0 | 0 |
Whitespace | |
---|---|
Character case | Differences in character case are significant |
Line endings | Differences in line endings (CR and LF characters) are ignored |
CR/LF characters | Not shown in the comparison detail |
No regular expressions were active.
1 | -- 05/08/2 018 Add da ta for loo kup table Monitoring Frequency | |
2 | -- 05/07/2 018 Add da ta for loo kup tables RecentClo zapineUsag es, Durati onUnits | |
3 | -- 04/13/2 018 v0.2.4 .5 -- | |
4 | -- 07/03/2 017 v0.3.8 .2 Stop Co des, Permi ssions for Registrat ions, Spec ial Condit ions, Revi ews, Conta cts, Commu nications | |
5 | -- 08/28/2 018 v0.3.1 1.1 Remove communica tions perm issions | |
6 | -- 12/13/2 018 v0.5.1 6.1 Added data for O verrideCod es and Pre scriberOve rrideCodes | |
7 | -- 12/14/2 018 Correc t logic fo r adding L ogEntryIns ert | |
8 | ||
9 | SET IDENTI TY_INSERT RegistryUs ers ON | |
10 | INSERT INT O Registry Users (Id, UserName, RegistryU serName_Fi rst, Regis tryUserNam e_Last, Cr eated, Act ive, LastM odified, C reatedBy, EmailAddre ss) | |
11 | VALUES (1, PII ', 'Clozap ine', 'Adm in', GETDA TE(), 1, G ETDATE(), NULL, PII ') | |
12 | SET IDENTI TY_INSERT RegistryUs ers OFF | |
13 | ||
14 | ||
15 | SET IDENTI TY_INSERT RegistryPe rmissions ON | |
16 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 1, 'Read R oles', 'Ro les can be viewed') | |
17 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 2, 'Write Roles', 'R oles can b e created and update d') | |
18 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 3, 'Delete Roles', ' Roles can be deleted ') | |
19 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 4, 'Read U sers', 'Us ers can be viewed') | |
20 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 5, 'Write Users', 'U sers can b e created and update d') | |
21 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 6, 'Delete Users', ' Users can be deleted ') | |
22 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 7, 'Read P atients', 'Patients can be vie wed') | |
23 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 8, 'Write Patients', 'Patients can be cr eated and updated') | |
24 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 9, 'Delete Patients' , 'Patient s can be d eleted') | |
25 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 10, 'Read Facilities ', 'Facili ties can b e viewed') | |
26 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 11, 'Write Facilitie s', 'Facil ities can be created and updat ed') | |
27 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 12, 'Delet e Faciltie s', 'Facil ities can be deleted ') | |
28 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 13, 'Read Pharmacies ', 'Pharma cies can b e viewed') | |
29 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 14, 'Write Pharmacie s', 'Pharm acies can be created and updat ed') | |
30 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 15, 'Delet e Pharmaci es', 'Phar macies can be delete d') | |
31 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 16, 'Read Master Lis t Items', 'Master li st items c an viewed' ) | |
32 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 17, 'Write Master Li st Items', 'Master l ist items can be cre ated and u pdated') | |
33 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 18, 'Delet e Master L ist Items' , 'Master list items can be de leted') | |
34 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 19, 'Read Prescriber s', 'Presc ribers can be viewed ') | |
35 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 20, 'Write Prescribe rs', 'Pres cribers ca n be creat ed and upd ated') | |
36 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 21, 'Delet e Prescrib ers', 'Pre scribers c an be dele ted') | |
37 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 22, 'Read Prescripti ons', 'Pre scriptions can be vi ewed') | |
38 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 23, 'Write Prescript ions', 'Pr escription s can be c reated and updated') | |
39 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 24, 'Delet e Prescrip tions', 'P rescriptio ns can be deleted') | |
40 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 25, 'Read Test Resul ts', 'Test Results c an be view ed') | |
41 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 26, 'Write Test Resu lts', 'Tes t Results can be cre ated and u pdated') | |
42 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 27, 'Delet e Test Res ults', 'Te st Results can be de leted') | |
43 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 28, 'Read VA Applica tions', 'V A Clozapin e Applicat ions can b e viewed') | |
44 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 29, 'Write VA Applic ations', ' VA Clozapi ne Applica tions can be created and updat ed') | |
45 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 30, 'Delet e VA Appli cations', 'VA Clozap ine Applic ations can be delete d') | |
46 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 31, 'Read Clozapine Treatment' , 'Clozapi ne Treatme nt can be viewed') | |
47 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 32, 'Write Clozapine Treatment ', 'Clozap ine Treatm ent can be created a nd updated ') | |
48 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 33, 'Delet e Clozapin e Treatmen t', 'Cloza pine Treat ment can b e deleted' ) | |
49 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 34, 'Read Special Co nditions', 'Special Conditions can be vi ewed') | |
50 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 35, 'Write Special C onditions' , 'Special Condition s can be c reated and updated') | |
51 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 36, 'Delet e Special Conditions ', 'Specia l Conditio ns can be deleted') | |
52 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 37, 'Read Contacts', 'Contacts can be vi ewed') | |
53 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 38, 'Write Contacts' , 'Contact s can be c reated and updated') | |
54 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 39, 'Delet e Contacts ', 'Contac ts can be deleted') | |
55 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 40, 'Read Director R eviews', ' Director R eviews can be viewed ') | |
56 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 41, 'Write Director Reviews', 'Director Reviews ca n be creat ed and upd ated') | |
57 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 42, 'Delet e Director Reviews', 'Director Reviews c an be dele ted') | |
58 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 43, 'Read System Log s', 'Log E ntries can be viewed ') | |
59 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 44, 'Read Settings', 'Settings can be vi ewed') | |
60 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 45, 'Write Settings' , 'Setting s can be u pdated') | |
61 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 46, 'Read Override C odes', 'Ov erride Cod es can be viewed') | |
62 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 47, 'Read Security E vents', 'S ecurity Ev ents can b e viewed') | |
63 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 48, 'Read HL7 Messag es', 'HL7 Messages c an be view ed') | |
64 | ||
65 | SET IDENTI TY_INSERT RegistryPe rmissions OFF | |
66 | ||
67 | ||
68 | SET IDENTI TY_INSERT Roles ON | |
69 | insert int o Roles (I d, RoleNam e, [Descri ption], Cr eated, Cre atedBy_Id, LastModif ied, IsFa cilityRole ) VALUES ( 1, 'Super Administra tor', 'A u ser who is allowed f ull access to the sy stem','201 8-01-10 00 :00:00.000 ', 1, '000 1-01-01 00 :00:00.000 ', 1) | |
70 | INSERT INT O Roles (I d, RoleNam e, [Descri ption], Cr eated, Cre atedBy_Id, LastModif ied, IsFa cilityRole ) VALUES ( 2, 'Staff' , 'A user who is all owed limit ed access to the sys tem','2018 -01-10 00: 00:00.000' , 1, '0001 -01-01 00: 00:00.000' , 0) | |
71 | INSERT INT O Roles (I d, RoleNam e, [Descri ption], Cr eated, Cre atedBy_Id, LastModif ied, IsFac ilityRole) VALUES (3 , 'Facilit y Manager' , 'A user who is all owed manag e the faci lities','2 018-01-10 00:00:00.0 00', 1, '0 001-01-01 00:00:00.0 00', 0) | |
72 | ||
73 | SET IDENTI TY_INSERT Roles OFF | |
74 | ||
75 | ||
76 | DECLARE @i int = 0 | |
77 | WHILE @i < 45 | |
78 | BEGIN | |
79 | SET @i = @i + 1 | |
80 | in sert into RoleRegist ryPermissi ons (Role_ Id, Regist ryPermissi on_Id) val ues (1, @i ) | |
81 | END | |
82 | ||
83 | insert int o RoleRegi stryPermis sions (Rol e_Id, Regi stryPermis sion_Id) v alues (2, 1) | |
84 | insert int o RoleRegi stryPermis sions (Rol e_Id, Regi stryPermis sion_Id) v alues (2, 4) | |
85 | insert int o RoleRegi stryPermis sions (Rol e_Id, Regi stryPermis sion_Id) v alues (2, 7) | |
86 | insert int o RoleRegi stryPermis sions (Rol e_Id, Regi stryPermis sion_Id) v alues (2, 10) | |
87 | insert int o RoleRegi stryPermis sions (Rol e_Id, Regi stryPermis sion_Id) v alues (2, 13) | |
88 | insert int o RoleRegi stryPermis sions (Rol e_Id, Regi stryPermis sion_Id) v alues (2, 16) | |
89 | insert int o RoleRegi stryPermis sions (Rol e_Id, Regi stryPermis sion_Id) v alues (2, 19) | |
90 | insert int o RoleRegi stryPermis sions (Rol e_Id, Regi stryPermis sion_Id) v alues (2, 22) | |
91 | insert int o RoleRegi stryPermis sions (Rol e_Id, Regi stryPermis sion_Id) v alues (2, 25) | |
92 | insert int o RoleRegi stryPermis sions (Rol e_Id, Regi stryPermis sion_Id) v alues (2, 28) | |
93 | insert int o RoleRegi stryPermis sions (Rol e_Id, Regi stryPermis sion_Id) v alues (2, 31) | |
94 | insert int o RoleRegi stryPermis sions (Rol e_Id, Regi stryPermis sion_Id) v alues (2, 34) | |
95 | insert int o RoleRegi stryPermis sions (Rol e_Id, Regi stryPermis sion_Id) v alues (2, 37) | |
96 | insert int o RoleRegi stryPermis sions (Rol e_Id, Regi stryPermis sion_Id) v alues (2, 40) | |
97 | ||
98 | ||
99 | ||
100 | insert int o Registry UserRoles (RegistryU ser_Id, Ro le_Id) val ues (1, 1) | |
101 | ||
102 | ||
103 | SET IDENTI TY_INSERT Genders ON | |
104 | INSERT INT O Genders (Id, Gende rName, [De scription] ) VALUES ( 1, 'Male', 'Male') | |
105 | INSERT INT O Genders (Id, Gende rName, [De scription] ) VALUES ( 2, 'Female ', 'Female ') | |
106 | SET IDENTI TY_INSERT Genders OF F | |
107 | ||
108 | ||
109 | SET IDENTI TY_INSERT TreatmentS tatus ON | |
110 | INSERT INT O Treatmen tStatus (I d, Treatme ntStatusNa me, [Descr iption]) V ALUES (1, 'Active',' Active') | |
111 | INSERT INT O Treatmen tStatus (I d, Treatme ntStatusNa me, [Descr iption]) V ALUES (2, 'Discontin ued','Disc ontinued') | |
112 | SET IDENTI TY_INSERT TreatmentS tatus OFF | |
113 | ||
114 | SET IDENTI TY_INSERT FacilityTy pes ON | |
115 | INSERT INT O Facility Types (Id, FacilityT ypeName, [ Descriptio n]) VALUES (1,'CBOC' ,'COMMUNIT Y BASED OU TPATIENT C LINIC') | |
116 | INSERT INT O Facility Types (Id, FacilityT ypeName, [ Descriptio n]) VALUES (2,'D','D OMICILIARY ') | |
117 | INSERT INT O Facility Types (Id, FacilityT ypeName, [ Descriptio n]) VALUES (3,'M&ROC ','MEDICAL AND REGIO NAL OFFFIC E CENTER') | |
118 | INSERT INT O Facility Types (Id, FacilityT ypeName, [ Descriptio n]) VALUES (4,'MC(M& D)','MEDIC AL CENTER (MEDICAL A ND DOMICIL IARY)') | |
119 | INSERT INT O Facility Types (Id, FacilityT ypeName, [ Descriptio n]) VALUES (5,'OC',' OUTPATIENT CLINIC (I NDEPENDENT )') | |
120 | INSERT INT O Facility Types (Id, FacilityT ypeName, [ Descriptio n]) VALUES (6,'OCS', 'OUTPATIEN T CLINIC S UBSTATION' ) | |
121 | INSERT INT O Facility Types (Id, FacilityT ypeName, [ Descriptio n]) VALUES (7,'OPC', 'OUT PATIE NT CLINIC' ) | |
122 | INSERT INT O Facility Types (Id, FacilityT ypeName, [ Descriptio n]) VALUES (8,'ORC', 'OUTREACH CLINIC') | |
123 | INSERT INT O Facility Types (Id, FacilityT ypeName, [ Descriptio n]) VALUES (9,'RO-OC ','REGIONA L OFFICE - OUTPATIEN T CLINIC') | |
124 | INSERT INT O Facility Types (Id, FacilityT ypeName, [ Descriptio n]) VALUES (10,'SOC' ,'SATELLIT E OUTPATIE NT CLINIC' ) | |
125 | INSERT INT O Facility Types (Id, FacilityT ypeName, [ Descriptio n]) VALUES (11,'VAMC ','VA MEDI CAL CENTER ') | |
126 | SET IDENTI TY_INSERT FacilityTy pes OFF | |
127 | ||
128 | ||
129 | SET IDENTI TY_INSERT PhoneNumbe rTypes ON | |
130 | INSERT INT O PhoneNum berTypes ( Id, PhoneN umberTypeN ame, [Desc ription]) Values (0, 'Office', 'Office') | |
131 | INSERT INT O PhoneNum berTypes ( Id, PhoneN umberTypeN ame, [Desc ription]) Values (1, 'Mobile', 'Mobile') | |
132 | INSERT INT O PhoneNum berTypes ( Id, PhoneN umberTypeN ame, [Desc ription]) Values (2, 'Pager', 'Pager') | |
133 | INSERT INT O PhoneNum berTypes ( Id, PhoneN umberTypeN ame, [Desc ription]) Values (3, 'Fax', 'F ax') | |
134 | INSERT INT O PhoneNum berTypes ( Id, PhoneN umberTypeN ame, [Desc ription]) Values (4, 'Home', ' Home') | |
135 | INSERT INT O PhoneNum berTypes ( Id, PhoneN umberTypeN ame, [Desc ription]) Values (5, 'Other', 'Other') | |
136 | SET IDENTI TY_INSERT PhoneNumbe rTypes OFF | |
137 | ||
138 | SET IDENTI TY_INSERT DeaVerific ationStatu s ON | |
139 | INSERT INT O DeaVerif icationSta tus (Id, V erificatio n, [Descri ption]) VA LUES (0, ' Unknown',' Unknown') | |
140 | INSERT INT O DeaVerif icationSta tus (Id, V erificatio n, [Descri ption]) VA LUES (1, ' Verified N ational DE A','Verifi ed with NT IS Databas e') | |
141 | INSERT INT O DeaVerif icationSta tus (Id, V erificatio n, [Descri ption]) VA LUES (2, ' Verified V A DEA','Ve rified wit h VA') | |
142 | INSERT INT O DeaVerif icationSta tus (Id, V erificatio n, [Descri ption]) VA LUES (3, ' Not Found' ,'Not Foun d') | |
143 | SET IDENTI TY_INSERT DeaVerific ationStatu s OFF | |
144 | ||
145 | SET IDENTI TY_INSERT Ethnicitie s ON | |
146 | INSERT INT O Ethnicit ies (Id, E thnicityNa me, [Descr iption]) V ALUES (0, 'N','Not H ispanic or Latino') | |
147 | INSERT INT O Ethnicit ies (Id, E thnicityNa me, [Descr iption]) V ALUES (1, 'H','Hispa nic or Lat ino') | |
148 | INSERT INT O Ethnicit ies (Id, E thnicityNa me, [Descr iption]) V ALUES (2, 'D','Decli ned to Ans wer') | |
149 | INSERT INT O Ethnicit ies (Id, E thnicityNa me, [Descr iption]) V ALUES (3, 'U','Unkno wn') | |
150 | SET IDENTI TY_INSERT Ethnicitie s OFF | |
151 | ||
152 | SET IDENTI TY_INSERT Races ON | |
153 | INSERT INT O Races (I d, RaceNam e, [Descri ption]) VA LUES (0, ' W','White' ) | |
154 | INSERT INT O Races (I d, RaceNam e, [Descri ption]) VA LUES (1, ' B','Black or African American' ) | |
155 | INSERT INT O Races (I d, RaceNam e, [Descri ption]) VA LUES (2, ' A','Asian' ) | |
156 | INSERT INT O Races (I d, RaceNam e, [Descri ption]) VA LUES (3, ' H','Native Hawaiian or Other P acific Isl ander') | |
157 | INSERT INT O Races (I d, RaceNam e, [Descri ption]) VA LUES (4, ' I','Americ an Indian or Alaska Native') | |
158 | INSERT INT O Races (I d, RaceNam e, [Descri ption]) VA LUES (5, ' P','Unknow n By Patie nt') | |
159 | INSERT INT O Races (I d, RaceNam e, [Descri ption]) VA LUES (6, ' D','Declin ed To Answ er') | |
160 | SET IDENTI TY_INSERT Races OFF | |
161 | ||
162 | SET IDENTI TY_INSERT CodeSets O N | |
163 | INSERT INT O CodeSets (Id, Code SetName, [ Descriptio n]) VALUES (0, 'None ','None') | |
164 | INSERT INT O CodeSets (Id, Code SetName, [ Descriptio n]) VALUES (1, 'ICD- 10','Inter national C lassificat ion of Dis eases 10') | |
165 | INSERT INT O CodeSets (Id, Code SetName, [ Descriptio n]) VALUES (2, 'SNOM ED-CT','Sy stemitized Nomenclat ure of Med icine - Cl inical Ter minology') | |
166 | INSERT INT O CodeSets (Id, Code SetName, [ Descriptio n]) VALUES (3, 'LOIN C','Logica l Observat ion Identi fiers Name s and Code s') | |
167 | INSERT INT O CodeSets (Id, Code SetName, [ Descriptio n]) VALUES (4, 'NCCC ','NCCC Di agnosis Ca tegories') | |
168 | SET IDENTI TY_INSERT CodeSets O FF | |
169 | ||
170 | SET IDENTI TY_INSERT DiagnosisC odes ON | |
171 | INSERT INT O Diagnosi sCodes (Id , CodeSet_ Id, Code, [Descripti on], Creat ed, LastMo dified, Cr eatedBy_Id ) VALUES ( 1, 4, '1' ,'Schizoph renia',GET DATE(), '0 1/01/0001 00:00:00.0 00', 1) | |
172 | INSERT INT O Diagnosi sCodes (Id , CodeSet_ Id, Code, [Descripti on], Creat ed, LastMo dified, Cr eatedBy_Id ) VALUES ( 2, 4, '2' ,'Schizoaf fective Di sorder',GE TDATE(), ' 01/01/0001 00:00:00. 000', 1) | |
173 | INSERT INT O Diagnosi sCodes (Id , CodeSet_ Id, Code, [Descripti on], Creat ed, LastMo dified, Cr eatedBy_Id ) VALUES ( 3, 4, '3' ,'Major De pressive D isorder',G ETDATE(), '01/01/000 1 00:00:00 .000', 1) | |
174 | INSERT INT O Diagnosi sCodes (Id , CodeSet_ Id, Code, [Descripti on], Creat ed, LastMo dified, Cr eatedBy_Id ) VALUES ( 4, 4, '4' ,'Bipolar Affective Disorder', GETDATE(), '01/01/00 01 00:00:0 0.000', 1) | |
175 | INSERT INT O Diagnosi sCodes (Id , CodeSet_ Id, Code, [Descripti on], Creat ed, LastMo dified, Cr eatedBy_Id ) VALUES ( 5, 4, '5' ,'Dementia ',GETDATE( ), '01/01/ 0001 00:00 :00.000', 1) | |
176 | INSERT INT O Diagnosi sCodes (Id , CodeSet_ Id, Code, [Descripti on], Creat ed, LastMo dified, Cr eatedBy_Id ) VALUES ( 6, 4, '6' ,'Movement Disorders ',GETDATE( ), '01/01/ 0001 00:00 :00.000', 1) | |
177 | INSERT INT O Diagnosi sCodes (Id , CodeSet_ Id, Code, [Descripti on], Creat ed, LastMo dified, Cr eatedBy_Id ) VALUES ( 7, 4, '7' ,'Drug Ind uced Psych osis',GETD ATE(), '01 /01/0001 0 0:00:00.00 0', 1) | |
178 | INSERT INT O Diagnosi sCodes (Id , CodeSet_ Id, Code, [Descripti on], Creat ed, LastMo dified, Cr eatedBy_Id ) VALUES ( 8, 4, '8' ,'Other',G ETDATE(), '01/01/000 1 00:00:00 .000', 1) | |
179 | INSERT INT O Diagnosi sCodes (Id , CodeSet_ Id, Code, [Descripti on], Creat ed, LastMo dified, Cr eatedBy_Id ) VALUES ( 9, 4, '9' ,'Schizo/S A Suicidal ',GETDATE( ), '01/01/ 0001 00:00 :00.000', 1) | |
180 | SET IDENTI TY_INSERT DiagnosisC odes OFF | |
181 | ||
182 | --SET IDEN TITY_INSER T TestType s ON | |
183 | --INSERT I NTO TestTy pes (Id, L ookupName, [Descript ion]) Valu es (0, 'AN C', 'Absol ute Neutro phil Count ') | |
184 | --INSERT I NTO TestTy pes (Id, L ookupName, [Descript ion]) Valu es (1, 'WB C', 'White Blood Cel l Count') | |
185 | --SET IDEN TITY_INSER T TestType s OFF | |
186 | ||
187 | --SET IDEN TITY_INSER T Prescrip tionStatus ON | |
188 | --INSERT I NTO Prescr iptionStat us (Id, St atusName, [Descripti on]) Value s (0, 'Unk nown', 'Un known Stat us') | |
189 | --INSERT I NTO Prescr iptionStat us (Id, St atusName, [Descripti on]) Value s (1, 'Act ive', 'Act ive') | |
190 | --INSERT I NTO Prescr iptionStat us (Id, St atusName, [Descripti on]) Value s (2, 'On Hold', 'On Hold') | |
191 | --INSERT I NTO Prescr iptionStat us (Id, St atusName, [Descripti on]) Value s (3, 'Can celled', ' Cancelled' ) | |
192 | --INSERT I NTO Prescr iptionStat us (Id, St atusName, [Descripti on]) Value s (4, 'Com pleted', ' Completed' ) | |
193 | --INSERT I NTO Prescr iptionStat us (Id, St atusName, [Descripti on]) Value s (5, 'Ent ered In Er ror', 'Ent ered In Er ror') | |
194 | --INSERT I NTO Prescr iptionStat us (Id, St atusName, [Descripti on]) Value s (6, 'Sto pped', 'St opped') | |
195 | --INSERT I NTO Prescr iptionStat us (Id, St atusName, [Descripti on]) Value s (7, 'Dra ft', 'Draf t') | |
196 | --SET IDEN TITY_INSER T Prescrip tionStatus OFF | |
197 | ||
198 | SET IDENTI TY_INSERT DurationUn its ON | |
199 | INSERT INT O Duration Units (Id, UnitName, [Descript ion]) VALU ES (0, 'Da ys', 'Days ') | |
200 | INSERT INT O Duration Units (Id, UnitName, [Descript ion]) VALU ES (1, 'We eks', 'Wee ks') | |
201 | INSERT INT O Duration Units (Id, UnitName, [Descript ion]) VALU ES (2, 'Mo nths', 'Mo nths') | |
202 | INSERT INT O Duration Units (Id, UnitName, [Descript ion]) VALU ES (3, 'Ye ars', 'Yea rs') | |
203 | SET IDENTI TY_INSERT DurationUn its OFF | |
204 | ||
205 | SET IDENTI TY_INSERT ClozapineU sageHistor ies ON | |
206 | INSERT INT O Clozapin eUsageHist ories (Id, UsageName , [Descrip tion]) VAL UES (0, 'N ew Patient ', 'New Pa tient') | |
207 | INSERT INT O Clozapin eUsageHist ories (Id, UsageName , [Descrip tion]) VAL UES (1, 'A ctive Othe r VA', 'Ac tive at an other VA f acility') | |
208 | INSERT INT O Clozapin eUsageHist ories (Id, UsageName , [Descrip tion]) VAL UES (2, 'A ctive Non- VA', 'Acti ve at a No n-VA facil ity') | |
209 | INSERT INT O Clozapin eUsageHist ories (Id, UsageName , [Descrip tion]) VAL UES (3, 'I nactive < 30d', 'Ina ctive less than 30 d ays') | |
210 | INSERT INT O Clozapin eUsageHist ories (Id, UsageName , [Descrip tion]) VAL UES (4, 'I nactive > 30d', 'Ina ctive more than 30 d ays') | |
211 | INSERT INT O Clozapin eUsageHist ories (Id, UsageName , [Descrip tion]) VAL UES (5, 'I nactive > 1y', 'Inac tive more than 1 yea r') | |
212 | SET IDENTI TY_INSERT ClozapineU sageHistor ies OFF | |
213 | ||
214 | SET IDENTI TY_INSERT Monitoring Frequencie s ON | |
215 | INSERT INT O Monitori ngFrequenc ies (Id, L ookupName, [Descript ion]) VALU ES (0, '7 Days', '7 Days') | |
216 | INSERT INT O Monitori ngFrequenc ies (Id, L ookupName, [Descript ion]) VALU ES (1, '14 Days', '1 4 Days') | |
217 | INSERT INT O Monitori ngFrequenc ies (Id, L ookupName, [Descript ion]) VALU ES (2, '28 Days', '2 8 Days') | |
218 | SET IDENTI TY_INSERT Monitoring Frequencie s OFF | |
219 | ||
220 | SET IDENTI TY_INSERT Brands ON | |
221 | INSERT INT O Brands ( Id, BrandN ame, [Desc ription]) VALUES (1, 'Accord', 'Accord H ealthcare Inc.') | |
222 | INSERT INT O Brands ( Id, BrandN ame, [Desc ription]) VALUES (2, 'Actavis' , 'Actavis Pharma, I nc.') | |
223 | INSERT INT O Brands ( Id, BrandN ame, [Desc ription]) VALUES (3, 'Aurobind o', 'Aurob indo Pharm a Limited' ) | |
224 | INSERT INT O Brands ( Id, BrandN ame, [Desc ription]) VALUES (4, 'Avera', 'Avera McK ennan Hosp ital') | |
225 | INSERT INT O Brands ( Id, BrandN ame, [Desc ription]) VALUES (5, 'Cardinal ', 'Cardin al Health' ) | |
226 | INSERT INT O Brands ( Id, BrandN ame, [Desc ription]) VALUES (6, 'GSMS', ' GSMS, Inco rporated') | |
227 | INSERT INT O Brands ( Id, BrandN ame, [Desc ription]) VALUES (7, 'Mayne', 'Mayne Pha rma') | |
228 | INSERT INT O Brands ( Id, BrandN ame, [Desc ription]) VALUES (8, 'Mylan In st', 'Myla n Institut ional Inc. ') | |
229 | INSERT INT O Brands ( Id, BrandN ame, [Desc ription]) VALUES (9, 'Mylan Ph arm', 'Myl an Pharmac euticals I nc.') | |
230 | INSERT INT O Brands ( Id, BrandN ame, [Desc ription]) VALUES (10 , 'Sandoz' , 'Sandoz Inc.') | |
231 | INSERT INT O Brands ( Id, BrandN ame, [Desc ription]) VALUES (11 , 'Sun', ' Sun Pharma ceutical I ndustries, Inc.') | |
232 | INSERT INT O Brands ( Id, BrandN ame, [Desc ription]) VALUES (12 , 'Teva', 'Teva Phar maceutical s USA, Inc .') | |
233 | SET IDENTI TY_INSERT Brands OFF | |
234 | ||
235 | SET IDENTI TY_INSERT StopCodes ON | |
236 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (1, '0', 'Unknown' , 'Unknown Reason / Under Inve stigation' , '', '') | |
237 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (2, '111 ', 'Drowse Sedate', ' Drowsiness / Sedatio n', 'Side Effects', 'Central N ervous Sys tem') | |
238 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (3, '112 ', 'DizzVe rt', 'Dizz iness / Ve rtigo', 'S ide Effect s', 'Centr al Nervous System') | |
239 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (4, '113 ', 'Seizur es', 'Seiz ures', 'Si de Effects ', 'Centra l Nervous System') | |
240 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (5, '114 ', 'ConfDe lirium', ' Confusion / Delirium ', 'Side E ffects', ' Central Ne rvous Syst em') | |
241 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (6, '115 ', 'Apnea' , 'Apnea', 'Side Eff ects', 'Ce ntral Nerv ous System ') | |
242 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (7, '116 ', 'NeuroM align', 'N euroleptic Malignant Syndrome (NMS)', 'S ide Effect s', 'Centr al Nervous System') | |
243 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (8, '117 ', 'Tardiv eDyski', ' Tardive Dy skinesia', 'Side Eff ects', 'Ce ntral Nerv ous System ') | |
244 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (9, '121 ', 'Saliva tion', 'Sa livation', 'Side Eff ects', 'Au tonomic Ne rvous Syst em') | |
245 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (10, '12 2', 'Sweat ing', 'Swe ating', 'S ide Effect s', 'Auton omic Nervo us System' ) | |
246 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (11, '12 3', 'Visua lDistur', 'Visual Di sturbances ', 'Side E ffects', ' Autonomic Nervous Sy stem') | |
247 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (12, '12 4', 'Priap ism', 'Pri apism', 'S ide Effect s', 'Auton omic Nervo us System' ) | |
248 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (13, '13 1', 'LeukN eutroRe', 'Leukopeni a / Neutro penia, Rec hallengeab le', 'Side Effects', 'Hemato / Lymphatic System') | |
249 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (14, '13 2', 'WBCUn der2k', 'W BC Count < 2000, Not Rechallen geable', ' Side Effec ts', 'Hema to / Lymph atic Syste m') | |
250 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (15, '13 3', 'Granu Under2k', 'Granulocy te Count < 1000, Not Rechallen geable', ' Side Effec ts', 'Hema to / Lymph atic Syste m') | |
251 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (16, '13 4', 'Agran ulocy', 'A granulocyt osis', 'Si de Effects ', 'Hemato / Lymphat ic System' ) | |
252 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (17, '13 5', 'Agran ulocy', 'E levated Eo sinophil C ount', 'Si de Effects ', 'Hemato / Lymphat ic System' ) | |
253 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (18, '13 6', 'HighE osinoph', 'Elevated Eosinophil Count', ' Side Effec ts', 'Hema to / Lymph atic Syste m') | |
254 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (19, '13 7', 'HighW BC', 'Elev ated WBC C ount', 'Si de Effects ', 'Hemato / Lymphat ic System' ) | |
255 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (20, '13 8', 'HighP latelet', 'Elevated Platelet C ount', 'Si de Effects ', 'Hemato / Lymphat ic System' ) | |
256 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (21, '14 1', 'Tachy cardia', ' Tachycardi a', 'Side Effects', 'Cardiovas cular Syst em') | |
257 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (22, '14 2', 'Hypot ension', ' Hypotensio n', 'Side Effects', 'Cardiovas cular Syst em') | |
258 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (23, '14 3', 'Hyper tension', 'Hypertens ion', 'Sid e Effects' , 'Cardiov ascular Sy stem') | |
259 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (24, '14 4', 'EKGCh anges', 'E KG Changes ', 'Side E ffects', ' Cardiovasc ular Syste m') | |
260 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (25, '14 5', 'ChPai nAngina', 'Chest Pai n / Angina ', 'Side E ffects', ' Cardiovasc ular Syste m') | |
261 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (26, '15 1', 'Const ipation', 'Constipat ion', 'Sid e Effects' , 'Digesti ve System' ) | |
262 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (27, '15 2', 'Nause aVomit', ' Nausea, Vo miting', ' Side Effec ts', 'Dige stive Syst em') | |
263 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (28, '15 3', 'HighL iverTst', 'Elevated Liver Func tion Tests ', 'Side E ffects', ' Digestive System') | |
264 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (29, '19 1', 'Fever ', 'Fever' , 'Side Ef fects', 'M iscellaneo us') | |
265 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (30, '19 2', 'Weigh tGain', 'W eight Gain ', 'Side E ffects', ' Miscellane ous') | |
266 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (31, '19 3', 'Aller gyReact', 'Allergic Reaction', 'Side Eff ects', 'Mi scellaneou s') | |
267 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (32, '19 4', 'DrugH yperGly', 'Drug-Indu ced Hyperg lycemia', 'Side Effe cts', 'Mis cellaneous ') | |
268 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (33, '19 5', 'Incon tinence', 'Incontine nce', 'Sid e Effects' , 'Miscell aneous') | |
269 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (34, '22 1', 'MoreV iolent', ' Increased Violent Be havior / A gitation', 'Side Eff ects', 'Be havior Con trol') | |
270 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (35, '22 2', 'Subst anceAbu', 'Substance Abuse', ' Side Effec ts', 'Beha vior Contr ol') | |
271 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (36, '22 3', 'DenyB lood', 'Re fusal to a ccept bloo d draw', ' Side Effec ts', 'Beha vior Contr ol') | |
272 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (37, '23 1', 'Disch arged', 'D ischarge f rom Inpati ent Servic e, Outpati ent Unavai lable', 'S ide Effect s', 'VA / VA Facilit y Restrict ions') | |
273 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (38, '23 2', 'FarDi stance', ' Distance f rom Home t o VA Too G reat for W eekly Visi ts', 'Side Effects', 'VA / VA Facility R estriction s') | |
274 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (39, '23 3', 'Trans ferToVA', 'Transfer to another VA--Not a Registere d Clozapin e Site', ' Side Effec ts', 'VA / VA Facili ty Restric tions') | |
275 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (40, '24 1', 'Priva teFacil', 'Transfer to Private Facility of Service ', 'Side E ffects', ' Patient Tr ansfer') | |
276 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (41, '24 2', 'State Run', 'Tra nsfer to S tate-Run F acility', 'Side Effe cts', 'Pat ient Trans fer') | |
277 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (42, '24 3', 'SendT oNewFed', 'Transfer to another Federal f acility', 'Side Effe cts', 'Pat ient Trans fer') | |
278 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (43, '25 1', 'Regis tNoCloz', 'Registere d, Clozapi ne Never S tarted', ' Side Effec ts', 'Othe r Administ rative Pro blems') | |
279 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (44, '25 2', 'Disco ntinued', 'Discontin ued at the Discretio n of Treat ing Psychi atrist', ' Side Effec ts', 'Othe r Administ rative Pro blems') | |
280 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (45, '25 3', 'Study Start', 'E nrolled in Drug Stud y, Alterna te Medicat ion', 'Sid e Effects' , 'Other A dministrat ive Proble ms') | |
281 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (46, '25 4', 'Study Finish', ' Drug Study Completed ', 'Side E ffects', ' Other Admi nistrative Problems' ) | |
282 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (47, '25 5', 'RegEr ror', 'No Change Nee ded, Regis tered in E rror', 'Si de Effects ', 'Other Administra tive Probl ems') | |
283 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (48, '25 6', 'Start Generic', 'Switch fr om Brand t o Generic' , 'Side Ef fects', 'O ther Admin istrative Problems') | |
284 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (49, '31 1', 'Respo nse<8', 'P oor Respon se, Trial Less Than 8 Weeks', 'Treatment ', 'Drug R esponse') | |
285 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (50, '31 2', 'Respo nse>8', 'P oor Respon se, Trial Greater Th an 8 Weeks ', 'Treatm ent', 'Dru g Response ') | |
286 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (51, '32 1', 'Tegre tol', 'Teg retol', 'T reatment', 'Drug Int eraction') | |
287 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (52, '32 2', 'Dilan tin', 'Dil antin', 'T reatment', 'Drug Int eraction') | |
288 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (53, '32 3', 'Lithi um', 'Lith ium', 'Tre atment', ' Drug Inter action') | |
289 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (54, '32 4', 'Benzo diazep', ' Benzodiaze pines', 'T reatment', 'Drug Int eraction') | |
290 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (55, '32 5', 'Tagam et', 'Taga met', 'Tre atment', ' Drug Inter action') | |
291 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (56, '32 6', 'Capto pril', 'Ca ptopril', 'Treatment ', 'Drug I nteraction ') | |
292 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (57, '41 1', 'Infec tPara', 'I nfectious or Parasit ic Disease ', 'Medica l', 'Conco mitant Ill ness') | |
293 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (58, '41 2', 'Neopl asm', 'Neo plasm', 'M edical', ' Concomitan t Illness' ) | |
294 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (59, '41 3', 'Disor der', 'End ocrine, Nu tritional, or Metabo lic Disord er', 'Medi cal', 'Con comitant I llness') | |
295 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (60, '41 4', 'Blood Disease', 'Blood or Blood Form ing Organ Disease', 'Medical', 'Concomit ant Illnes s') | |
296 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (61, '41 5', 'NervS ysDis', 'N ervous Sys tem Diseas e', 'Medic al', 'Conc omitant Il lness') | |
297 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (62, '41 6', 'CircD isease', ' Circulator y Disease' , 'Medical ', 'Concom itant Illn ess') | |
298 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (63, '41 7', 'PulmD isease', ' Pulmonary Disease', 'Medical', 'Concomit ant Illnes s') | |
299 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (64, '41 8', 'DigDi sease', 'D igestive S ystem Dise ase', 'Med ical', 'Co ncomitant Illness') | |
300 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (65, '41 9', 'Genit oUrin', 'G enito-Urin ary System Disease', 'Medical' , 'Concomi tant Illne ss') | |
301 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (66, '42 0', 'Muscu loskel', ' Musculoske letal Syst em Disease ', 'Medica l', 'Conco mitant Ill ness') | |
302 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (67, '42 1', 'SkinD isease', ' Skin and S ubcutaneou s Tissue D isease', ' Medical', 'Concomita nt Illness ') | |
303 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (68, '42 2', 'Injur ePoison', 'Injury an d Poisonin g', 'Medic al', 'Conc omitant Il lness') | |
304 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (69, '43 1', 'Pregn ancy', 'Pr egnancy', 'Medical', 'Other Ph ysical Con ditions') | |
305 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (70, '51 1', 'Secon dAgranu', 'Secondary to Agranu locytosis' , 'Death', 'Resultin g From Ill ness') | |
306 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (71, '51 2', 'Secon dCNS', 'Se condary to CNS Disea se', 'Deat h', 'Resul ting From Illness') | |
307 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (72, '51 3', 'Secon dCard', 'S econdary t o Cardiac Disease', 'Death', ' Resulting From Illne ss') | |
308 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (73, '51 4', 'Secon dGastro', 'Secondary to Gastro intestinal Disease', 'Death', 'Resulting From Illn ess') | |
309 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (74, '51 5', 'Secon dRenal', ' Secondary to Renal D isease', ' Death', 'R esulting F rom Illnes s') | |
310 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (75, '51 6', 'Secon dPulmon', 'Secondary to Pulmon ary Diseas e', 'Death ', 'Result ing From I llness') | |
311 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (76, '51 7', 'Secon dInfect', 'Secondary to Infect ion', 'Dea th', 'Resu lting From Illness') | |
312 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (77, '51 8', 'Secon dNeopl', ' Secondary to Neoplas m', 'Death ', 'Result ing From I llness') | |
313 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (78, '51 9', 'Secon dRespri', 'Secondary to Respir atory Dise ase', 'Dea th', 'Resu lting From Illness') | |
314 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (79, '52 0', 'Secon dMetabo', 'Secondary to Metabo lic or End ocrine Dis ease', 'De ath', 'Res ulting Fro m Illness' ) | |
315 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (80, '52 1', 'Deadl yInjury', 'Accidenta l Injury r esulting i n Death', 'Death', ' Not Result ing From I llness') | |
316 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (81, '52 2', 'Suici de', 'Suic ide', 'Dea th', 'Not Resulting From Illne ss') | |
317 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (82, '52 3', 'Sudde nDeath', ' Sudden Dea th - Etiol ogy Unknow n', 'Death ', 'Not Re sulting Fr om Illness ') | |
318 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (83, '21 1a', 'Refu seMeds', ' Refusal of Medicatio n', 'Admin istration' , 'Patient Noncompli ance') | |
319 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (84, '21 1b', 'Misu seMeds', ' Misuse of Medication ', 'Admini stration', 'Patient Noncomplia nce') | |
320 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (85, '21 1c', 'Fail ToMeet', ' Failure to Meet Outp atient', ' Administra tion', 'Pa tient Nonc ompliance' ) | |
321 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (86, '21 1d', 'Elop ed', 'Elop ed from In patient Se rvice', 'A dministrat ion', 'Pat ient Nonco mpliance') | |
322 | INSERT INT O StopCode s (Id, Cod e, [Name], [Descript ion], Prob lem, Categ ory) VALUE S (87, '21 1e', 'Disc ontinue', 'Discontin ue Request ed by Pati ent--No Re ason Given ', 'Admini stration', 'Patient Noncomplia nce') | |
323 | SET IDENTI TY_INSERT StopCodes OFF | |
324 | ||
325 | SET IDENTI TY_INSERT ContactTyp es ON | |
326 | INSERT INT O ContactT ypes (Id, LookupName , [Descrip tion]) VAL UES (1, 'C linical Ph armacy Spe cialist', 'Clinical Pharmacy S pecialist' ) | |
327 | INSERT INT O ContactT ypes (Id, LookupName , [Descrip tion]) VAL UES (2, 'C linical Ph armacist', 'Clinical Pharmacis t') | |
328 | INSERT INT O ContactT ypes (Id, LookupName , [Descrip tion]) VAL UES (3, 'P harmacy In formaticis t', 'Pharm acy Inform aticist') | |
329 | INSERT INT O ContactT ypes (Id, LookupName , [Descrip tion]) VAL UES (4, 'P hysician', 'Physicia n') | |
330 | INSERT INT O ContactT ypes (Id, LookupName , [Descrip tion]) VAL UES (5, 'P hysician A ssistant', 'Physicia n Assistan t') | |
331 | INSERT INT O ContactT ypes (Id, LookupName , [Descrip tion]) VAL UES (6, 'N urse Clini cian', 'Nu rse Clinic ian') | |
332 | INSERT INT O ContactT ypes (Id, LookupName , [Descrip tion]) VAL UES (7, 'C lozapine M edical Lea d', 'Cloza pine Medic al Lead') | |
333 | INSERT INT O ContactT ypes (Id, LookupName , [Descrip tion]) VAL UES (8, 'C lozapine A dministrat ive Lead', 'Clozapin e Administ rative Lea d') | |
334 | INSERT INT O ContactT ypes (Id, LookupName , [Descrip tion]) VAL UES (9, 'A dministrat ive Suppor t', 'Admin istrative Support') | |
335 | INSERT INT O ContactT ypes (Id, LookupName , [Descrip tion]) VAL UES (10, ' Other', 'O ther') | |
336 | SET IDENTI TY_INSERT ContactTyp es OFF | |
337 | ||
338 | SET IDENTI TY_INSERT FileLocati ons ON | |
339 | INSERT INT O FileLoca tions (Id, FileLocat ionName, [ Descriptio n]) VALUES (0, 'Digi tized', 'D igitized') | |
340 | INSERT INT O FileLoca tions (Id, FileLocat ionName, [ Descriptio n]) VALUES (1, 'Pape r File', ' Paper File ') | |
341 | INSERT INT O FileLoca tions (Id, FileLocat ionName, [ Descriptio n]) VALUES (2, 'Arch ived', 'Ar chived') | |
342 | INSERT INT O FileLoca tions (Id, FileLocat ionName, [ Descriptio n]) VALUES (3, 'Unkn own (TBD)' , 'Unknown (TBD)') | |
343 | SET IDENTI TY_INSERT FileLocati ons OFF | |
344 | ||
345 | SET IDENTI TY_INSERT OverrideCo des ON | |
346 | INSERT INT O Override Codes (Id, OverrideN ame, Activ e, [Descri ption]) VA LUES (1, ' No WBC In Last 7 Day s', 0, 'No WBC In La st 7 Days' ) | |
347 | INSERT INT O Override Codes (Id, OverrideN ame, Activ e, [Descri ption]) VA LUES (2, ' No Verifie d WBC', 0, 'No Verif ied WBC') | |
348 | INSERT INT O Override Codes (Id, OverrideN ame, Activ e, [Descri ption]) VA LUES (3, ' Last WBC R esult < 35 00', 0, 'L ast WBC Re sult < 350 0') | |
349 | INSERT INT O Override Codes (Id, OverrideN ame, Activ e, [Descri ption]) VA LUES (4, ' 3 Seq. WBC Decrease' , 0, '3 Se q. WBC Dec rease') | |
350 | INSERT INT O Override Codes (Id, OverrideN ame, Activ e, [Descri ption]) VA LUES (5, ' Last ANC R esult < 20 00', 0, 'L ast ANC Re sult < 200 0') | |
351 | INSERT INT O Override Codes (Id, OverrideN ame, Activ e, [Descri ption]) VA LUES (6, ' 3 Seq. ANC Decrease' , 0, '3 Se q. ANC Dec rease') | |
352 | INSERT INT O Override Codes (Id, OverrideN ame, Activ e, [Descri ption]) VA LUES (7, ' NCCC Autho rized', 1, 'NCCC Aut horized') | |
353 | INSERT INT O Override Codes (Id, OverrideN ame, Activ e, [Descri ption]) VA LUES (8, ' Register N on-Duty Ho urs/Weeken d (Max4Day ) Prescrib er Approve d', 1, 'Re gister Non -Duty Hour s/Weekend (Max4Day) Prescriber Approved' ) | |
354 | INSERT INT O Override Codes (Id, OverrideN ame, Activ e, [Descri ption]) VA LUES (9, ' Prescriber Approved 4 Day Supp ly', 1, 'P rescriber Approved 4 Day Suppl y') | |
355 | INSERT INT O Override Codes (Id, OverrideN ame, Activ e, [Descri ption]) VA LUES (10, 'Mild Neut ropenia Pr escriber A pproved', 1, 'Mild N eutropenia Prescribe r Approved ') | |
356 | SET IDENTI TY_INSERT OverrideCo des OFF | |
357 | ||
358 | SET IDENTI TY_INSERT dbo.Prescr iberOverri deCodes ON | |
359 | INSERT INT O Prescrib erOverride Codes (Id, Prescribe rOverrideN ame, [Desc ription]) VALUES (1, 'Weather Related Co ndition', 'Weather R elated Con dition') | |
360 | INSERT INT O Prescrib erOverride Codes (Id, Prescribe rOverrideN ame, [Desc ription]) VALUES (2, 'Mail Ord er Delay', 'Mail Ord er Delay') | |
361 | INSERT INT O Prescrib erOverride Codes (Id, Prescribe rOverrideN ame, [Desc ription]) VALUES (3, 'Inpatien t Going On Leave', ' Inpatient Going On L eave') | |
362 | INSERT INT O Prescrib erOverride Codes (Id, Prescribe rOverrideN ame, [Desc ription]) VALUES (4, 'Inpatien t Order Ov erride wit h Outside Lab Result s', 'Inpat ient Order Override with Outsi de Lab Res ults') | |
363 | SET IDENTI TY_INSERT dbo.Prescr iberOverri deCodes OF F | |
364 | ||
365 | ||
366 | SET IDENTI TY_INSERT [Credentia ls] ON | |
367 | INSERT INT O [Credent ials] (Id, Credentia lName, [De scription] ) VALUES ( 1, 'M.D.', 'Doctor o f Medicine ') | |
368 | INSERT INT O [Credent ials] (Id, Credentia lName, [De scription] ) VALUES ( 2, 'D.O.', 'Doctor o f Osteopat hy') | |
369 | INSERT INT O [Credent ials] (Id, Credentia lName, [De scription] ) VALUES ( 3, 'R.Ph.' , 'Registe red Pharma cist') | |
370 | INSERT INT O [Credent ials] (Id, Credentia lName, [De scription] ) VALUES ( 4, 'N.P.', 'Nurse Pr actitioner ') | |
371 | INSERT INT O [Credent ials] (Id, Credentia lName, [De scription] ) VALUES ( 5, 'P.A.', 'Physicia n Assistan t') | |
372 | INSERT INT O [Credent ials] (Id, Credentia lName, [De scription] ) VALUES ( 6, 'Pharm. D.', 'Doct or of Phar macy') | |
373 | SET IDENTI TY_INSERT [Credentia ls] OFF | |
374 | ||
375 | SET IDENTI TY_INSERT [Clozapine SettingNam es] ON | |
376 | INSERT INT O [Clozapi neSettingN ames](Id,S ettingName ,[Descript ion]) VALU ES(1,'Down time Notif ication Me ssage','Th e downtime notificat ion messag e is displ ayed on th e Sign-In page whene ver the sy stem is pl anned to b e down for maintenan ce or upgr ades.') | |
377 | INSERT INT O [Clozapi neSettingN ames](Id,S ettingName ,[Descript ion]) VALU ES(2,'VA S ecurity No tice Sign- In Message ','The VA Security N otice mess age is dis played on the Sign-I n page.') | |
378 | ||
379 | SET IDENTI TY_INSERT [Clozapine SettingNam es] OFF | |
380 | ||
381 | SET IDENTI TY_INSERT [Clozapine Settings] ON | |
382 | INSERT INT O [dbo].[C lozapineSe ttings](Id ,[SettingV alue],[Cre ated],[Las tModified] ,[CreatedB y_Id],[Fac ility_Id] ,[LastModi fiedBy_Id] ,[Setting Name_Id])V ALUES (1,N ull,Getdat e(),Getdat e(),1,Null ,1,1) | |
383 | INSERT INT O [dbo].[C lozapineSe ttings](Id ,[SettingV alue],[Cre ated],[Las tModified] ,[CreatedB y_Id],[Fac ility_Id] ,[LastModi fiedBy_Id] ,[Setting Name_Id])V ALUES (2,' VA SECURIT Y NOTICE: This site is intende d to be us ed by auth orized VA network us ers for vi ewing and retrieving informati on only, e xcept as o therwise e xplicitly authorized VA inform ation resi des on and transmits through c omputer sy stems and networks f unded by V A. All use is consid ered to be with an u nderstandi ng and acc eptance th at there i s no reaso nable expe ctation of privacy f or any dat a or trans missions o n Governme nt Intrane t or Extra net(non-pu blic) netw orks or sy stems. all transacti ons that o ccur on th is system other than the viewi ng and dow nloading o f Web site informati on and all data tran smitted th rough this system ae subject t o review a nd action including( but not li mited to)m onitoring, recording , retrievi ng, copyin g, auditin g, inspect ing, inves tigating, restrictin g access, blocking, tracking, disclosing to author ized perso nnel, or a ny other a uthorized actions by all autho rized VA a nd law enf orcement p ersonnel. All use of this syst em constit ues unders tanding an d uncondit ional acce ptance of these term s. Unautho zired atte mpts or ac ts to eith er (1)acce ss, upload , change, or delete informatio n on this system, (2 )modify th is system, (3)deny a ccess to t his system or (4)acc rus resour ces for un authorized use on th is system are strict ly prohibi ted. Such attempts o r acts are subject t o action t hat may re sult in cr iminal, ci vil, or ad ministrati ve penalti es.',Getda te(),Getda te(),1,Nul l,1,2) | |
384 | SET IDENTI TY_INSERT [Clozapine Settings] OFF | |
385 | ||
386 | SET IDENTI TY_INSERT [SecurityE ventTypes] ON | |
387 | INSERT INT O [Securit yEventType s](Id, Eve ntType, [D escription ]) VALUES( 1, 'UserCr eated', 'U ser Create d') | |
388 | INSERT INT O [Securit yEventType s](Id, Eve ntType, [D escription ]) VALUES( 2, 'UserEd ited', 'Us er Edited' ) | |
389 | INSERT INT O [Securit yEventType s](Id, Eve ntType, [D escription ]) VALUES( 3, 'RoleCr eated', 'R ole Create d') | |
390 | INSERT INT O [Securit yEventType s](Id, Eve ntType, [D escription ]) VALUES( 4, 'RoleEd ited', 'Ro le Edited' ) | |
391 | INSERT INT O [Securit yEventType s](Id, Eve ntType, [D escription ]) VALUES( 5, 'RoleDe leted', 'R ole Delete d') | |
392 | INSERT INT O [Securit yEventType s](Id, Eve ntType, [D escription ]) VALUES( 6, 'Access Requested' , 'Access Requested' ) | |
393 | SET IDENTI TY_INSERT [SecurityE ventTypes] OFF | |
394 | ||
395 | ||
396 | SET IDENTI TY_INSERT [RegistryU serStatus] ON | |
397 | INSERT INT O [Registr yUserStatu s](Id, [Re gistryUser Status], [ Descriptio n]) VALUES (1, 'New', 'Access R equested') | |
398 | INSERT INT O [Registr yUserStatu s](Id, [Re gistryUser Status], [ Descriptio n]) VALUES (2, 'Denie d', 'Acces s Denied') | |
399 | INSERT INT O [Registr yUserStatu s](Id, [Re gistryUser Status], [ Descriptio n]) VALUES (3, 'Activ e', 'Acces s Approved and Activ e') | |
400 | INSERT INT O [Registr yUserStatu s](Id, [Re gistryUser Status], [ Descriptio n]) VALUES (4, 'Inact ive', 'Acc ess Approv ed but Ina ctive') | |
401 | SET IDENTI TY_INSERT [RegistryU serStatus] OFF | |
402 | ||
403 | ||
404 | ||
405 | IF EXISTS (SELECT * FROM sys.o bjects WHE RE object_ id = OBJEC T_ID(N'[Lo gEntryInse rt]') AND type in (N 'P', N'PC' )) | |
406 | BEGIN | |
407 | DR OP PROCEDU RE LogEntr yInsert | |
408 | PR INT 'LogEn tryInsert stored pro cedure alr eady exist s!'; | |
409 | END | |
410 | ||
411 | Go | |
412 | ||
413 | CREATE PRO CEDURE [db o].[LogEnt ryInsert] | |
414 | @l evel varch ar(5), | |
415 | @l ogged date time, | |
416 | @c ontroller nvarchar(1 00), | |
417 | @a ction nvar char(100), | |
418 | @r equestMeth od nvarcha r(10), | |
419 | @r emoteAddre ss nvarcha r(100), | |
420 | @e xecutableV ersion nva rchar(10), | |
421 | @u rl nvarcha r(2000), | |
422 | @f acility nv archar(100 ), | |
423 | @u ser nvarch ar(100), | |
424 | @m ethod nvar char(max), | |
425 | @m essage nva rchar(max) , | |
426 | @e lapsed big int, | |
427 | @r esultData nvarchar(m ax), | |
428 | @e xceptionDe tails nvar char(max) | |
429 | AS | |
430 | BEGIN | |
431 | IN SERT INTO [dbo].[Log Entries] ( | |
432 | [L evel], | |
433 | [L ogged], | |
434 | [C ontroller] , | |
435 | [A ction], | |
436 | [R equestMeth od], | |
437 | [R emoteAddre ss], | |
438 | [E xecutableV ersion], | |
439 | [U rl], | |
440 | [F acility], | |
441 | [U ser], | |
442 | [M ethod], | |
443 | [M essage], | |
444 | [E lapsed], | |
445 | [R esultData] , | |
446 | [E xceptionDe tails] | |
447 | ) VALUES ( | |
448 | @l evel, | |
449 | @l ogged, | |
450 | @c ontroller, | |
451 | @a ction, | |
452 | @r equestMeth od, | |
453 | @r emoteAddre ss, | |
454 | @e xecutableV ersion, | |
455 | @u rl, | |
456 | @f acility, | |
457 | @u ser, | |
458 | @m ethod, | |
459 | @m essage, | |
460 | @e lapsed, | |
461 | @r esultData, | |
462 | @e xceptionDe tails | |
463 | ); | |
464 | END | |
465 |
Araxis Merge (but not the data content of this report) is Copyright © 1993-2016 Araxis Ltd (www.araxis.com). All rights reserved.