Produced by Araxis Merge on 9/25/2018 2:34:30 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\Va.Gov.Nccc.Data.Sql\Scripts | InitialDatabaseSeedData.sql | Tue Aug 14 18:03:08 2018 UTC |
2 | MHLTH_CLOZ_MOD _SRC.zip\MHLTH_CLOZ_MOD _SRC\Va.Gov.Nccc.Data.Sql\Scripts | InitialDatabaseSeedData.sql | Tue Sep 25 15:32:48 2018 UTC |
Description | Between Files 1 and 2 |
|
---|---|---|
Text Blocks | Lines | |
Unchanged | 2 | 624 |
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 | ||
6 | SET IDENTI TY_INSERT RegistryUs ers ON | |
7 | INSERT INT O Registry Users (Id, UserName, RegistryU serName_Fi rst, Regis tryUserNam e_Last, Cr eated, Act ive, LastM odified, C reatedBy) | |
8 | VALUES (1, PII ', 'Clozap ine', 'Adm in', GETDA TE(), 1, ' 01/01/0001 00:00:00. 000', 'Sys tem Genera ted') | |
9 | SET IDENTI TY_INSERT RegistryUs ers OFF | |
10 | GO | |
11 | ||
12 | SET IDENTI TY_INSERT RegistryPe rmissions ON | |
13 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 1, 'Read R oles', 'Ro les can be viewed') | |
14 | 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') | |
15 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 3, 'Delete Roles', ' Roles can be deleted ') | |
16 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 4, 'Read U sers', 'Us ers can be viewed') | |
17 | 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') | |
18 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 6, 'Delete Users', ' Users can be deleted ') | |
19 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 7, 'Read P atients', 'Patients can be vie wed') | |
20 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 8, 'Write Patients', 'Patients can be cr eated and updated') | |
21 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 9, 'Delete Patients' , 'Patient s can be d eleted') | |
22 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 10, 'Read Facilities ', 'Facili ties can b e viewed') | |
23 | 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') | |
24 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 12, 'Delet e Faciltie s', 'Facil ities can be deleted ') | |
25 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 13, 'Read Pharmacies ', 'Pharma cies can b e viewed') | |
26 | 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') | |
27 | 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') | |
28 | 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' ) | |
29 | 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') | |
30 | 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') | |
31 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 19, 'Read Prescriber s', 'Presc ribers can be viewed ') | |
32 | 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') | |
33 | 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') | |
34 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 22, 'Read Prescripti ons', 'Pre scriptions can be vi ewed') | |
35 | 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') | |
36 | 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') | |
37 | 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') | |
38 | 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') | |
39 | 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') | |
40 | 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') | |
41 | 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') | |
42 | 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') | |
43 | 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') | |
44 | 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 ') | |
45 | 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' ) | |
46 | 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') | |
47 | 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') | |
48 | 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') | |
49 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 37, 'Read Contacts', 'Contacts can be vi ewed') | |
50 | 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') | |
51 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 39, 'Delet e Contacts ', 'Contac ts can be deleted') | |
52 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 40, 'Read Communicat ions', 'Co mmunicatio ns can be viewed') | |
53 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 41, 'Write Communica tions', 'C ommunicati ons can be created a nd updated ') | |
54 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 42, 'Delet e Communic ations', ' Communicat ions can b e deleted' ) | |
55 | INSERT INT O Registry Permission s (Id, Reg istryPermi ssionName, RegistryP ermissionD escription ) VALUES ( 43, '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 ( 44, '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 ( 45, 'Delet e Director Reviews', 'Director Reviews c an be dele ted') | |
58 | SET IDENTI TY_INSERT RegistryPe rmissions OFF | |
59 | GO | |
60 | ||
61 | SET IDENTI TY_INSERT Roles ON | |
62 | insert int o Roles (I d, RoleNam e, [Descri ption], Cr eated, Cre atedBy_Id, LastModif ied) value s (1, 'Adm inistrator ', 'A user who is al lowed full access to the syste m','2018-0 1-10 00:00 :00.000', 1, '0001-0 1-01 00:00 :00.000') | |
63 | insert int o Roles (I d, RoleNam e, [Descri ption], Cr eated, Cre atedBy_Id, LastModif ied) value s (2, 'Sta ff', 'A us er who is allowed li mited acce ss to the system','2 018-01-10 00:00:00.0 00', 1, '0 001-01-01 00:00:00.0 00') | |
64 | SET IDENTI TY_INSERT Roles OFF | |
65 | GO | |
66 | ||
67 | DECLARE @i int = 0 | |
68 | WHILE @i < 45 | |
69 | BEGIN | |
70 | SET @i = @i + 1 | |
71 | in sert into RoleRegist ryPermissi ons (Role_ Id, Regist ryPermissi on_Id) val ues (1, @i ) | |
72 | END | |
73 | ||
74 | insert int o RoleRegi stryPermis sions (Rol e_Id, Regi stryPermis sion_Id) v alues (2, 1) | |
75 | insert int o RoleRegi stryPermis sions (Rol e_Id, Regi stryPermis sion_Id) v alues (2, 4) | |
76 | insert int o RoleRegi stryPermis sions (Rol e_Id, Regi stryPermis sion_Id) v alues (2, 7) | |
77 | insert int o RoleRegi stryPermis sions (Rol e_Id, Regi stryPermis sion_Id) v alues (2, 10) | |
78 | insert int o RoleRegi stryPermis sions (Rol e_Id, Regi stryPermis sion_Id) v alues (2, 13) | |
79 | insert int o RoleRegi stryPermis sions (Rol e_Id, Regi stryPermis sion_Id) v alues (2, 16) | |
80 | insert int o RoleRegi stryPermis sions (Rol e_Id, Regi stryPermis sion_Id) v alues (2, 19) | |
81 | insert int o RoleRegi stryPermis sions (Rol e_Id, Regi stryPermis sion_Id) v alues (2, 22) | |
82 | insert int o RoleRegi stryPermis sions (Rol e_Id, Regi stryPermis sion_Id) v alues (2, 25) | |
83 | insert int o RoleRegi stryPermis sions (Rol e_Id, Regi stryPermis sion_Id) v alues (2, 28) | |
84 | insert int o RoleRegi stryPermis sions (Rol e_Id, Regi stryPermis sion_Id) v alues (2, 31) | |
85 | insert int o RoleRegi stryPermis sions (Rol e_Id, Regi stryPermis sion_Id) v alues (2, 34) | |
86 | insert int o RoleRegi stryPermis sions (Rol e_Id, Regi stryPermis sion_Id) v alues (2, 37) | |
87 | insert int o RoleRegi stryPermis sions (Rol e_Id, Regi stryPermis sion_Id) v alues (2, 40) | |
88 | insert int o RoleRegi stryPermis sions (Rol e_Id, Regi stryPermis sion_Id) v alues (2, 43) | |
89 | GO | |
90 | ||
91 | insert int o Registry UserRoles (RegistryU ser_Id, Ro le_Id) val ues (1, 1) | |
92 | GO | |
93 | ||
94 | SET IDENTI TY_INSERT Genders ON | |
95 | INSERT INT O Genders (Id, Gende rName, [De scription] ) VALUES ( 1, 'Male', 'Male') | |
96 | INSERT INT O Genders (Id, Gende rName, [De scription] ) VALUES ( 2, 'Female ', 'Female ') | |
97 | SET IDENTI TY_INSERT Genders OF F | |
98 | GO | |
99 | ||
100 | SET IDENTI TY_INSERT TreatmentS tatus ON | |
101 | INSERT INT O Treatmen tStatus (I d, Treatme ntStatusNa me, [Descr iption]) V ALUES (1, 'Active',' Active') | |
102 | INSERT INT O Treatmen tStatus (I d, Treatme ntStatusNa me, [Descr iption]) V ALUES (2, 'Discontin ued','Disc ontinued') | |
103 | SET IDENTI TY_INSERT TreatmentS tatus OFF | |
104 | GO | |
105 | ||
106 | INSERT INT O Facility Types (Fac ilityTypeN ame, [Desc ription]) VALUES ('C BOC','COMM UNITY BASE D OUTPATIE NT CLINIC' ) | |
107 | INSERT INT O Facility Types (Fac ilityTypeN ame, [Desc ription]) VALUES ('D ','DOMICIL IARY') | |
108 | INSERT INT O Facility Types (Fac ilityTypeN ame, [Desc ription]) VALUES ('M &ROC','MED ICAL AND R EGIONAL OF FFICE CENT ER') | |
109 | INSERT INT O Facility Types (Fac ilityTypeN ame, [Desc ription]) VALUES ('M C(M&D)','M EDICAL CEN TER (MEDIC AL AND DOM ICILIARY)' ) | |
110 | INSERT INT O Facility Types (Fac ilityTypeN ame, [Desc ription]) VALUES ('O C','OUTPAT IENT CLINI C (INDEPEN DENT)') | |
111 | INSERT INT O Facility Types (Fac ilityTypeN ame, [Desc ription]) VALUES ('O CS','OUTPA TIENT CLIN IC SUBSTAT ION') | |
112 | INSERT INT O Facility Types (Fac ilityTypeN ame, [Desc ription]) VALUES ('O PC','OUT P ATIENT CLI NIC') | |
113 | INSERT INT O Facility Types (Fac ilityTypeN ame, [Desc ription]) VALUES ('O RC','OUTRE ACH CLINIC ') | |
114 | INSERT INT O Facility Types (Fac ilityTypeN ame, [Desc ription]) VALUES ('R O-OC','REG IONAL OFFI CE - OUTPA TIENT CLIN IC') | |
115 | INSERT INT O Facility Types (Fac ilityTypeN ame, [Desc ription]) VALUES ('S OC','SATEL LITE OUTPA TIENT CLIN IC') | |
116 | INSERT INT O Facility Types (Fac ilityTypeN ame, [Desc ription]) VALUES ('V AMC','VA M EDICAL CEN TER') | |
117 | GO | |
118 | ||
119 | SET IDENTI TY_INSERT PhoneNumbe rTypes ON | |
120 | INSERT INT O PhoneNum berTypes ( Id, PhoneN umberTypeN ame, [Desc ription]) Values (0, 'None', ' None') | |
121 | INSERT INT O PhoneNum berTypes ( Id, PhoneN umberTypeN ame, [Desc ription]) Values (1, 'Home', ' Home') | |
122 | INSERT INT O PhoneNum berTypes ( Id, PhoneN umberTypeN ame, [Desc ription]) Values (2, 'Office', 'Office') | |
123 | INSERT INT O PhoneNum berTypes ( Id, PhoneN umberTypeN ame, [Desc ription]) Values (3, 'Mobile', 'Mobile') | |
124 | INSERT INT O PhoneNum berTypes ( Id, PhoneN umberTypeN ame, [Desc ription]) Values (4, 'Fax', 'F ax') | |
125 | INSERT INT O PhoneNum berTypes ( Id, PhoneN umberTypeN ame, [Desc ription]) Values (5, 'Other', 'Other') | |
126 | SET IDENTI TY_INSERT PhoneNumbe rTypes OFF | |
127 | ||
128 | SET IDENTI TY_INSERT DeaVerific ationStatu s ON | |
129 | INSERT INT O DeaVerif icationSta tus (Id, V erificatio n, [Descri ption]) VA LUES (0, ' Unknown',' Unknown') | |
130 | 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') | |
131 | INSERT INT O DeaVerif icationSta tus (Id, V erificatio n, [Descri ption]) VA LUES (2, ' Verified V A DEA','Ve rified wit h VA') | |
132 | INSERT INT O DeaVerif icationSta tus (Id, V erificatio n, [Descri ption]) VA LUES (3, ' Not Found' ,'Not Foun d') | |
133 | SET IDENTI TY_INSERT DeaVerific ationStatu s OFF | |
134 | ||
135 | SET IDENTI TY_INSERT Ethnicitie s ON | |
136 | INSERT INT O Ethnicit ies (Id, E thnicityNa me, [Descr iption]) V ALUES (0, 'N','Not H ispanic or Latino') | |
137 | INSERT INT O Ethnicit ies (Id, E thnicityNa me, [Descr iption]) V ALUES (1, 'H','Hispa nic or Lat ino') | |
138 | INSERT INT O Ethnicit ies (Id, E thnicityNa me, [Descr iption]) V ALUES (2, 'D','Decli ned to Ans wer') | |
139 | INSERT INT O Ethnicit ies (Id, E thnicityNa me, [Descr iption]) V ALUES (3, 'U','Unkno wn') | |
140 | SET IDENTI TY_INSERT Ethnicitie s OFF | |
141 | ||
142 | SET IDENTI TY_INSERT Races ON | |
143 | INSERT INT O Races (I d, RaceNam e, [Descri ption]) VA LUES (0, ' W','White' ) | |
144 | INSERT INT O Races (I d, RaceNam e, [Descri ption]) VA LUES (1, ' B','Black or African American' ) | |
145 | INSERT INT O Races (I d, RaceNam e, [Descri ption]) VA LUES (2, ' A','Asian' ) | |
146 | INSERT INT O Races (I d, RaceNam e, [Descri ption]) VA LUES (3, ' H','Native Hawaiian or Other P acific Isl ander') | |
147 | INSERT INT O Races (I d, RaceNam e, [Descri ption]) VA LUES (4, ' I','Americ an Indian or Alaska Native') | |
148 | INSERT INT O Races (I d, RaceNam e, [Descri ption]) VA LUES (5, ' P','Unknow n By Patie nt') | |
149 | INSERT INT O Races (I d, RaceNam e, [Descri ption]) VA LUES (6, ' D','Declin ed To Answ er') | |
150 | SET IDENTI TY_INSERT Races OFF | |
151 | ||
152 | SET IDENTI TY_INSERT CodeSets O N | |
153 | INSERT INT O CodeSets (Id, Code SetName, [ Descriptio n]) VALUES (0, 'None ','None') | |
154 | INSERT INT O CodeSets (Id, Code SetName, [ Descriptio n]) VALUES (1, 'ICD- 10','Inter national C lassificat ion of Dis eases 10') | |
155 | 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') | |
156 | INSERT INT O CodeSets (Id, Code SetName, [ Descriptio n]) VALUES (3, 'LOIN C','Logica l Observat ion Identi fiers Name s and Code s') | |
157 | INSERT INT O CodeSets (Id, Code SetName, [ Descriptio n]) VALUES (4, 'NCCC ','NCCC Di agnosis Ca tegories') | |
158 | SET IDENTI TY_INSERT CodeSets O FF | |
159 | ||
160 | SET IDENTI TY_INSERT DiagnosisC odes ON | |
161 | 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) | |
162 | 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) | |
163 | 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) | |
164 | 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) | |
165 | 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) | |
166 | 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) | |
167 | 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) | |
168 | 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) | |
169 | 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) | |
170 | SET IDENTI TY_INSERT DiagnosisC odes OFF | |
171 | ||
172 | SET IDENTI TY_INSERT TestTypes ON | |
173 | INSERT INT O TestType s (Id, Loo kupName, [ Descriptio n]) Values (0, 'ANC' , 'Absolut e Neutroph il Count') | |
174 | INSERT INT O TestType s (Id, Loo kupName, [ Descriptio n]) Values (1, 'WBC' , 'White B lood Cell Count') | |
175 | SET IDENTI TY_INSERT TestTypes OFF | |
176 | ||
177 | --SET IDEN TITY_INSER T Prescrip tionStatus ON | |
178 | --INSERT I NTO Prescr iptionStat us (Id, St atusName, [Descripti on]) Value s (0, 'Unk nown', 'Un known Stat us') | |
179 | --INSERT I NTO Prescr iptionStat us (Id, St atusName, [Descripti on]) Value s (1, 'Act ive', 'Act ive') | |
180 | --INSERT I NTO Prescr iptionStat us (Id, St atusName, [Descripti on]) Value s (2, 'On Hold', 'On Hold') | |
181 | --INSERT I NTO Prescr iptionStat us (Id, St atusName, [Descripti on]) Value s (3, 'Can celled', ' Cancelled' ) | |
182 | --INSERT I NTO Prescr iptionStat us (Id, St atusName, [Descripti on]) Value s (4, 'Com pleted', ' Completed' ) | |
183 | --INSERT I NTO Prescr iptionStat us (Id, St atusName, [Descripti on]) Value s (5, 'Ent ered In Er ror', 'Ent ered In Er ror') | |
184 | --INSERT I NTO Prescr iptionStat us (Id, St atusName, [Descripti on]) Value s (6, 'Sto pped', 'St opped') | |
185 | --INSERT I NTO Prescr iptionStat us (Id, St atusName, [Descripti on]) Value s (7, 'Dra ft', 'Draf t') | |
186 | --SET IDEN TITY_INSER T Prescrip tionStatus OFF | |
187 | ||
188 | SET IDENTI TY_INSERT DurationUn its ON | |
189 | INSERT INT O Duration Units (Id, UnitName, [Descript ion]) VALU ES (0, 'Da ys', 'Days ') | |
190 | INSERT INT O Duration Units (Id, UnitName, [Descript ion]) VALU ES (1, 'We eks', 'Wee ks') | |
191 | INSERT INT O Duration Units (Id, UnitName, [Descript ion]) VALU ES (2, 'Mo nths', 'Mo nths') | |
192 | INSERT INT O Duration Units (Id, UnitName, [Descript ion]) VALU ES (3, 'Ye ars', 'Yea rs') | |
193 | SET IDENTI TY_INSERT DurationUn its OFF | |
194 | ||
195 | SET IDENTI TY_INSERT ClozapineU sageHistor ies ON | |
196 | INSERT INT O Clozapin eUsageHist ories (Id, UsageName , [Descrip tion]) VAL UES (0, 'N ew Patient ', 'New Pa tient') | |
197 | 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') | |
198 | 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') | |
199 | INSERT INT O Clozapin eUsageHist ories (Id, UsageName , [Descrip tion]) VAL UES (3, 'I nactive < 30d', 'Ina ctive less than 30 d ays') | |
200 | INSERT INT O Clozapin eUsageHist ories (Id, UsageName , [Descrip tion]) VAL UES (4, 'I nactive > 30d', 'Ina ctive more than 30 d ays') | |
201 | INSERT INT O Clozapin eUsageHist ories (Id, UsageName , [Descrip tion]) VAL UES (5, 'I nactive > 1y', 'Inac tive more than 1 yea r') | |
202 | SET IDENTI TY_INSERT ClozapineU sageHistor ies OFF | |
203 | ||
204 | SET IDENTI TY_INSERT Monitoring Frequencie s ON | |
205 | INSERT INT O Monitori ngFrequenc ies (Id, L ookupName, [Descript ion]) VALU ES (0, 'We ekly', 'We ekly') | |
206 | INSERT INT O Monitori ngFrequenc ies (Id, L ookupName, [Descript ion]) VALU ES (1, 'Ev ery Two We eks', 'Eve ry Two Wee ks') | |
207 | INSERT INT O Monitori ngFrequenc ies (Id, L ookupName, [Descript ion]) VALU ES (2, 'Ev ery Four W eeks', 'Ev ery Four W eeks') | |
208 | SET IDENTI TY_INSERT Monitoring Frequencie s OFF | |
209 | ||
210 | SET IDENTI TY_INSERT Brands ON | |
211 | INSERT INT O Brands ( Id, BrandN ame, [Desc ription]) VALUES (1, 'Accord', 'Accord H ealthcare Inc.') | |
212 | INSERT INT O Brands ( Id, BrandN ame, [Desc ription]) VALUES (2, 'Actavis' , 'Actavis Pharma, I nc.') | |
213 | INSERT INT O Brands ( Id, BrandN ame, [Desc ription]) VALUES (3, 'Aurobind o', 'Aurob indo Pharm a Limited' ) | |
214 | INSERT INT O Brands ( Id, BrandN ame, [Desc ription]) VALUES (4, 'Avera', 'Avera McK ennan Hosp ital') | |
215 | INSERT INT O Brands ( Id, BrandN ame, [Desc ription]) VALUES (5, 'Cardinal ', 'Cardin al Health' ) | |
216 | INSERT INT O Brands ( Id, BrandN ame, [Desc ription]) VALUES (6, 'GSMS', ' GSMS, Inco rporated') | |
217 | INSERT INT O Brands ( Id, BrandN ame, [Desc ription]) VALUES (7, 'Mayne', 'Mayne Pha rma') | |
218 | INSERT INT O Brands ( Id, BrandN ame, [Desc ription]) VALUES (8, 'Mylan In st', 'Myla n Institut ional Inc. ') | |
219 | INSERT INT O Brands ( Id, BrandN ame, [Desc ription]) VALUES (9, 'Mylan Ph arm', 'Myl an Pharmac euticals I nc.') | |
220 | INSERT INT O Brands ( Id, BrandN ame, [Desc ription]) VALUES (10 , 'Sandoz' , 'Sandoz Inc.') | |
221 | INSERT INT O Brands ( Id, BrandN ame, [Desc ription]) VALUES (11 , 'Sun', ' Sun Pharma ceutical I ndustries, Inc.') | |
222 | INSERT INT O Brands ( Id, BrandN ame, [Desc ription]) VALUES (12 , 'Teva', 'Teva Phar maceutical s USA, Inc .') | |
223 | SET IDENTI TY_INSERT Brands OFF | |
224 | ||
225 | SET IDENTI TY_INSERT StopCodes ON | |
226 | 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' , '', '') | |
227 | 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') | |
228 | 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') | |
229 | 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') | |
230 | 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') | |
231 | 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 ') | |
232 | 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') | |
233 | 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 ') | |
234 | 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') | |
235 | 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' ) | |
236 | 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') | |
237 | 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' ) | |
238 | 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') | |
239 | 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') | |
240 | 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') | |
241 | 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' ) | |
242 | 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' ) | |
243 | 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') | |
244 | 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' ) | |
245 | 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' ) | |
246 | 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') | |
247 | 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') | |
248 | 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') | |
249 | 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') | |
250 | 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') | |
251 | 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' ) | |
252 | 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') | |
253 | 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') | |
254 | 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') | |
255 | 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') | |
256 | 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') | |
257 | 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 ') | |
258 | 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') | |
259 | 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') | |
260 | 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') | |
261 | 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') | |
262 | 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') | |
263 | 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') | |
264 | 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') | |
265 | 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') | |
266 | 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') | |
267 | 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') | |
268 | 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') | |
269 | 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') | |
270 | 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') | |
271 | 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' ) | |
272 | 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') | |
273 | 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') | |
274 | 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') | |
275 | 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 ') | |
276 | 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') | |
277 | 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') | |
278 | 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') | |
279 | 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') | |
280 | 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') | |
281 | 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 ') | |
282 | 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') | |
283 | 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' ) | |
284 | 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') | |
285 | 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') | |
286 | 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') | |
287 | 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') | |
288 | 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') | |
289 | 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') | |
290 | 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') | |
291 | 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') | |
292 | 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 ') | |
293 | 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') | |
294 | 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') | |
295 | 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') | |
296 | 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') | |
297 | 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') | |
298 | 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') | |
299 | 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') | |
300 | 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') | |
301 | 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') | |
302 | 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') | |
303 | 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') | |
304 | 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' ) | |
305 | 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') | |
306 | 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') | |
307 | 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 ') | |
308 | 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') | |
309 | 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') | |
310 | 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' ) | |
311 | 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') | |
312 | 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') | |
313 | SET IDENTI TY_INSERT StopCodes OFF |
Araxis Merge (but not the data content of this report) is Copyright © 1993-2016 Araxis Ltd (www.araxis.com). All rights reserved.