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 | DeveloperSampleDataScript.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 | DeveloperSampleDataScript.sql | Thu Apr 4 19:00:57 2019 UTC |
Description | Between Files 1 and 2 |
|
---|---|---|
Text Blocks | Lines | |
Unchanged | 11 | 1478 |
Changed | 10 | 20 |
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 | GO | |
2 | ||
3 | --PlEASE N OTE : Run InitialDat abaseSeedD ata.sql fi rst | |
4 | ||
5 | -- these d elete stat sments wil l remove a ll your ex isting dat a | |
6 | ||
7 | Delete fro m PatientD iagnosis | |
8 | Delete fro m Patients | |
9 | Delete fro m ContactF acilities | |
10 | Delete fro m ContactP harmacies | |
11 | Delete fro m Pharmaci sts | |
12 | Delete fro m Facility PhoneNumbe rs | |
13 | Delete fro m Contacts | |
14 | Delete fro m PhoneNum bers | |
15 | Delete fro m Pharmaci es | |
16 | Delete fro m Deas | |
17 | Delete fro m Medicati ons | |
18 | Delete fro m Prescrib erFaciliti es | |
19 | Delete fro m Prescrib ers | |
20 | Delete fro m SpecialC onditions | |
21 | Delete fro m Prescrip tions | |
22 | Delete fro m Faciliti es | |
23 | Delete fro m TestResu lts | |
24 | Delete fro m Treatmen tContinuat ions | |
25 | Delete fro m VaApplic ations | |
26 | Delete fro m Clozapin eTreatment s | |
27 | Delete fro m Treatmen tRationale s | |
28 | Delete fro m ReleaseN otes | |
29 | --DELETE F ROM Regist ryUsers WH ERE id >2 | |
30 | --DELETE F ROM Regist ryUserRole s WHERE Re gistryUser _Id>2 | |
31 | ||
32 | --5 Facili ties (2 Pa rents, 3 C hildren) | |
33 | SET IDENTI TY_INSERT [dbo].[Fa cilities] ON | |
34 | INSERT INT O Faciliti es (Id,Sta tionName , ShortName ,StationNu mber,Suffi x,Visn,Reg ion,Addres s_Line1,Ad dress_Line 2,Address_ City,Addre ss_State,A ddress_Zip Code | |
35 | ,Created ,LastModif ied,Create dBy_Id ,Fa cilityType _Id,LastMo difiedBy_I d ,Parent_ Id) | |
36 | VALUE S | |
37 | (1,'Paren t Facility 1 Station Name','Par ent Facili ty 1 Short Name',900, 'P1Suf','P 1Vis','Reg P1','Paren t Faility1 Address_L ine1', | |
38 | 'Parent F aility 1 A ddress_Lin e2','Paren t Faility 1 Address_ City','Par ent Failit y 1 Addres s_State',' Parent Fai lity1 Addr ess_ZipCod e', | |
39 | getdate() ,getdate() ,1,1,1,Nul l) | |
40 | ||
41 | ||
42 | INSERT INT O Faciliti es (Id,Sta tionName , ShortName ,StationNu mber,Suffi x,Visn,Reg ion,Addres s_Line1,Ad dress_Line 2,Address_ City,Addre ss_State,A ddress_Zip Code | |
43 | ,Created ,LastModif ied,Create dBy_Id ,Fa cilityType _Id,LastMo difiedBy_I d ,Parent_ Id) | |
44 | VALUE S | |
45 | (2,'Paren t Facility 2 Station Name','Par ent Facili ty2 ShortN ame',800,' P2Suf','P2 Vis','RegP 2','Parent Faility2 Address_Li ne1', | |
46 | 'Parent F aility2 Ad dress_Line 2','Parent Faility2 Address_Ci ty','Paren t Faility2 Address_S tate','Par ent Failit y2 Address _ZipCode', | |
47 | getdate() ,getdate() ,1,2,1,Nul l) | |
48 | ||
49 | INSERT INT O Faciliti es (Id,Sta tionName , ShortName ,StationNu mber,Suffi x,Visn,Reg ion,Addres s_Line1,Ad dress_Line 2,Address_ City,Addre ss_State,A ddress_Zip Code | |
50 | ,Created ,LastModif ied,Create dBy_Id ,Fa cilityType _Id,LastMo difiedBy_I d ,Parent_ Id) | |
51 | VALUE S | |
52 | (3,'Chlid Facility 1 StationN ame','Chli d Facility 1 ShortNa me',901,'C 1Suf','C1V is','RegC1 ','Chlid F aility1 Ad dress_Line 1', | |
53 | 'Chlid Fa ility 1 Ad dress_Line 2','Chlid Faility 1 Address_Ci ty','Chlid Faility 1 Address_S tate','Chl id Faility 1 Address_ ZipCode', | |
54 | getdate() ,getdate() ,1,3,1,1) | |
55 | ||
56 | INSERT INT O Faciliti es (Id,Sta tionName , ShortName ,StationNu mber,Suffi x,Visn,Reg ion,Addres s_Line1,Ad dress_Line 2,Address_ City,Addre ss_State,A ddress_Zip Code | |
57 | ,Created ,LastModif ied,Create dBy_Id ,Fa cilityType _Id,LastMo difiedBy_I d ,Parent_ Id) | |
58 | VALUE S | |
59 | (4,'Chlid Facility 2 StationN ame','Chli d Facility 2 ShortNam e',801,'C2 Suf','C2Vi s','RegC2' ,'Chlid Fa ility2 Add ress_Line1 ', | |
60 | 'Chlid Fa ility2 Add ress_Line2 ','Chlid F aility2 Ad dress_City ','Chlid F aility2 Ad dress_Stat e','Chlid Faility2 A ddress_Zip Code', | |
61 | getdate() ,getdate() ,1,4,1,2) | |
62 | ||
63 | ||
64 | INSERT INT O Faciliti es (Id,Sta tionName , ShortName ,StationNu mber,Suffi x,Visn,Reg ion,Addres s_Line1,Ad dress_Line 2,Address_ City,Addre ss_State,A ddress_Zip Code | |
65 | ,Created ,LastModif ied,Create dBy_Id ,Fa cilityType _Id,LastMo difiedBy_I d ,Parent_ Id) | |
66 | VALUE S | |
67 | (5,'Chlid Facility 3 StationN ame','Chli d Facility 3 ShortNam e',802,'C3 Suf','C3Vi s','RegC3' ,'Chlid Fa ility3 Add ress_Line1 ', | |
68 | 'Chlid Fa ility3 Add ress_Line2 ','Chlid F aility3 Ad dress_City ','Chlid F aility3 Ad dress_Stat e','Chlid Faility3 A ddress_Zip Code', | |
69 | getdate() ,getdate() ,1,5,1,2) | |
70 | SET IDENTI TY_INSERT [dbo].[Fac ilities] O FF | |
71 | ||
72 | -- 5 conta cts | |
73 | SET IDENTI TY_INSERT [dbo].[Con tacts] ON | |
74 | ||
75 | INSERT INT O [dbo].[C ontacts]([ Id],[Conta ctName_Fir st],[Conta ctName_Las t],[Contac tName_Midd le] | |
76 | ,[Active] ,[Pharmacy SecurityKe yPsoClozLo ck],[Pharm acySecurit yKeyYsclAu thorize] | |
77 | ,[Contact TypeOtherD escription ],[Comment s],[Create d],[LastMo dified] | |
78 | ,[Contact Type_Id],[ CreatedBy_ Id],[LastM odifiedBy_ Id]) | |
79 | VALUE S | |
80 | (1,'Conta ctName_Fir st 1','Con tactName_L ast 1','Co ntactName_ Middle 1', | |
81 | 1,0,0,'Co ntactTypeO therDescri ption 1',' Contact Co mments 1', getdate(), getdate(), 1,1,1) | |
82 | ||
83 | ||
84 | INSERT INT O [dbo].[C ontacts]([ Id],[Conta ctName_Fir st],[Conta ctName_Las t],[Contac tName_Midd le] | |
85 | ,[Active] ,[Pharmacy SecurityKe yPsoClozLo ck],[Pharm acySecurit yKeyYsclAu thorize] | |
86 | ,[Contact TypeOtherD escription ],[Comment s],[Create d],[LastMo dified] | |
87 | ,[Contact Type_Id],[ CreatedBy_ Id],[LastM odifiedBy_ Id]) | |
88 | VALUE S | |
89 | (2,'Conta ctName_Fir st 2','Con tactName_L ast 2','Co ntactName_ Middle 2', | |
90 | 1,0,0,'Co ntactTypeO therDescri ption 2',' Contact Co mments 2', getdate(), getdate(), 2,1,1) | |
91 | ||
92 | INSERT INT O [dbo].[C ontacts]([ Id],[Conta ctName_Fir st],[Conta ctName_Las t],[Contac tName_Midd le] | |
93 | ,[Active] ,[Pharmacy SecurityKe yPsoClozLo ck],[Pharm acySecurit yKeyYsclAu thorize] | |
94 | ,[Contact TypeOtherD escription ],[Comment s],[Create d],[LastMo dified] | |
95 | ,[Contact Type_Id],[ CreatedBy_ Id],[LastM odifiedBy_ Id]) | |
96 | VALUE S | |
97 | (3,'Conta ctName_Fir st 3','Con tactName_L ast 3','Co ntactName_ Middle 3', | |
98 | 1,0,0,'Co ntactTypeO therDescri ption 3',' Contact Co mments 3', getdate(), getdate(), 3,1,1) | |
99 | ||
100 | INSERT INT O [dbo].[C ontacts]([ Id],[Conta ctName_Fir st],[Conta ctName_Las t],[Contac tName_Midd le] | |
101 | ,[Active] ,[Pharmacy SecurityKe yPsoClozLo ck],[Pharm acySecurit yKeyYsclAu thorize] | |
102 | ,[Contact TypeOtherD escription ],[Comment s],[Create d],[LastMo dified] | |
103 | ,[Contact Type_Id],[ CreatedBy_ Id],[LastM odifiedBy_ Id]) | |
104 | VALUE S | |
105 | (4,'Conta ctName_Fir st 4','Con tactName_L ast 4','Co ntactName_ Middle 4', | |
106 | 1,0,0,'Co ntactTypeO therDescri ption 4',' Contact Co mments 4', getdate(), getdate(), 4,1,1) | |
107 | ||
108 | INSERT INT O [dbo].[C ontacts]([ Id],[Conta ctName_Fir st],[Conta ctName_Las t],[Contac tName_Midd le] | |
109 | ,[Active] ,[Pharmacy SecurityKe yPsoClozLo ck],[Pharm acySecurit yKeyYsclAu thorize] | |
110 | ,[Contact TypeOtherD escription ],[Comment s],[Create d],[LastMo dified] | |
111 | ,[Contact Type_Id],[ CreatedBy_ Id],[LastM odifiedBy_ Id]) | |
112 | VALUE S | |
113 | (5,'Conta ctName_Fir st 5','Con tactName_L ast 5','Co ntactName_ Middle 5', | |
114 | 1,0,0,'Co ntactTypeO therDescri ption 5',' Contact Co mments 5', getdate(), getdate(), 5,1,1) | |
115 | ||
116 | SET IDENTI TY_INSERT [dbo].[Con tacts] OFF | |
117 | ||
118 | ||
119 | --3 Pharma cies | |
120 | ||
121 | SET IDENTI TY_INSERT [dbo].[Pha rmacies] O N | |
122 | INSERT INT O Pharmaci es(Id,DbaN ame ,Addre ss_Line1,A ddress_Lin e2,Address _City,Addr ess_State | |
123 | ,Address_ ZipCode,Np i,Ncpdp,Ac tive,Inact iveDate,Co mment,Crea ted,LastMo dified | |
124 | ,CreatedB y_Id,LastM odifiedBy_ Id,ParentF acility_Id ) | |
125 | VALUE S | |
126 | (1,'Pharm acies1 Dba Name','Pha rmacies1 A ddress_Lin e1','Pharm acies1 Add ress_Line2 ', | |
127 | 'Pharmaci es1 Addres s_City','P harmacies1 Address_S tate','Pha rmacies1 A ddress_Zip Code', | |
128 | '12345678 90','Ncpdp 1',1,'0001 -01-01 00: 00:00.0000 000','Phar macies1 Co mment',get date(),get date(),1,1 ,1) | |
129 | ||
130 | INSERT INT O Pharmaci es(Id,DbaN ame ,Addre ss_Line1,A ddress_Lin e2,Address _City,Addr ess_State | |
131 | ,Address_ ZipCode,Np i,Ncpdp,Ac tive,Inact iveDate,Co mment,Crea ted,LastMo dified | |
132 | ,CreatedB y_Id,LastM odifiedBy_ Id,ParentF acility_Id ) | |
133 | VALUE S | |
134 | (2,'Pharm acies2 Dba Name','Pha rmacies2 A ddress_Lin e1','Pharm acies2 Add ress_Line2 ', | |
135 | 'Pharmaci es2 Addres s_City','P harmacies2 Address_S tate','Pha rmacies2 A ddress_Zip Code', | |
136 | '12345678 90','Ncpdp 2',1,'0001 -01-01 00: 00:00.0000 000','Phar macies2 Co mment',get date(),get date(),1,1 ,2) | |
137 | ||
138 | INSERT INT O Pharmaci es(Id,DbaN ame ,Addre ss_Line1,A ddress_Lin e2,Address _City,Addr ess_State | |
139 | ,Address_ ZipCode,Np i,Ncpdp,Ac tive,Inact iveDate,Co mment,Crea ted,LastMo dified | |
140 | ,CreatedB y_Id,LastM odifiedBy_ Id,ParentF acility_Id ) | |
141 | VALUE S | |
142 | (3,'Pharm acies3 Dba Name','Pha rmacies3 A ddress_Lin e1','Pharm acies3 Add ress_Line2 ', | |
143 | 'Pharmaci es3 Addres s_City','P harmacies3 Address_S tate','Pha rmacies3 A ddress_Zip Code', | |
144 | '12345678 90','Ncpdp 3',1,'0001 -01-01 00: 00:00.0000 000','Phar macies3 Co mment',get date(),get date(),1,1 ,2) | |
145 | ||
146 | INSERT INT O Pharmaci es(Id,DbaN ame ,Addre ss_Line1,A ddress_Lin e2,Address _City,Addr ess_State | |
147 | ,Address_ ZipCode,Np i,Ncpdp,Ac tive,Inact iveDate,Co mment,Crea ted,LastMo dified | |
148 | ,CreatedB y_Id,LastM odifiedBy_ Id,ParentF acility_Id ) | |
149 | VALUE S | |
150 | (4,'Pharm acies4 Dba Name','Pha rmacies4 A ddress_Lin e1','Pharm acies4 Add ress_Line2 ', | |
151 | 'Pharmaci es4 Addres s_City','P harmacies4 Address_S tate','Pha rmacies4 A ddress_Zip Code', | |
152 | '12345678 90','Ncpdp 4',1,'0001 -01-01 00: 00:00.0000 000','Phar macies4 Co mment',get date(),get date(),1,1 ,1) | |
153 | ||
154 | ||
155 | INSERT INT O Pharmaci es(Id,DbaN ame ,Addre ss_Line1,A ddress_Lin e2,Address _City,Addr ess_State | |
156 | ,Address_ ZipCode,Np i,Ncpdp,Ac tive,Inact iveDate,Co mment,Crea ted,LastMo dified | |
157 | ,CreatedB y_Id,LastM odifiedBy_ Id,ParentF acility_Id ) | |
158 | VALUE S | |
159 | (5,'Pharm acies5 Dba Name','Pha rmacies5 A ddress_Lin e1','Pharm acies5 Add ress_Line2 ', | |
160 | 'Pharmaci es45 Addre ss_City',' Pharmacies 5 Address_ State','Ph armacies5 Address_Zi pCode', | |
161 | '12345678 90','Ncpdp 5',1,'0001 -01-01 00: 00:00.0000 000','Phar macies5 Co mment',get date(),get date(),1,1 ,2) | |
162 | ||
163 | ||
164 | SET IDENTI TY_INSERT [dbo].[Pha rmacies] O FF | |
165 | ||
166 | --? Me dications (copy from NDC Medic ations scr ipt) | |
167 | ||
168 | SET IDENTI TY_INSERT [dbo].[Med ications] ON | |
169 | GO | |
170 | declare @m inDate as DateTime2; | |
171 | set @minDa te = CAST( N'0001-01- 01T00:00:0 0.0000000' AS DateTi me2); | |
172 | ||
173 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 6, N'55154 -8285-0', N'Clozapin e', CAST(N '2018-02-2 1T14:36:11 .8100000' AS DateTim e2), CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), 1, N ULL, N'100 mg/1', N' TABLET', N 'Cardinal Health', N '10 BLISTE R PACK in 1 BAG (551 54-8285-0) > 1 TABL ET in 1 BL ISTER PACK ', CAST(N' 2010-02-12 T00:00:00. 0000000' A S DateTime 2), CAST(N '0001-01-0 1T00:00:00 .0000000' AS DateTim e2), 1, @m inDate) | |
174 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 7, N'69189 -0463-1', N'CLOZAPIN E', CAST(N '2018-02-2 1T14:36:11 .8100000' AS DateTim e2), CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), 1, N ULL, N'100 mg/1', N' TABLET', N 'Avera McK ennan Hosp ital', N'1 TABLET in 1 DOSE PA CK (69189- 0463-1)', CAST(N'201 6-01-08T00 :00:00.000 0000' AS D ateTime2), CAST(N'00 01-01-01T0 0:00:00.00 00000' AS DateTime2) , 1, @minD ate) | |
175 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 8, N'51862 -271-01', N'Clozapin e', CAST(N '2018-02-2 1T14:36:11 .8100000' AS DateTim e2), CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), 1, N ULL, N'25 mg/1', N'T ABLET', N' Mayne Phar ma', N'100 TABLET in 1 BOTTLE (51862-271 -01)', CAS T(N'2016-0 8-03T00:00 :00.000000 0' AS Date Time2), CA ST(N'0001- 01-01T00:0 0:00.00000 00' AS Dat eTime2), 1 , @minDate ) | |
176 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 9, N'51862 -271-05', N'Clozapin e', CAST(N '2018-02-2 1T14:36:11 .8100000' AS DateTim e2), CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), 1, N ULL, N'25 mg/1', N'T ABLET', N' Mayne Phar ma', N'500 TABLET in 1 BOTTLE (51862-271 -05)', CAS T(N'2016-0 8-03T00:00 :00.000000 0' AS Date Time2), CA ST(N'0001- 01-01T00:0 0:00.00000 00' AS Dat eTime2), 1 , @minDate ) | |
177 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 10, N'5186 2-272-01', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'50 mg/1', N' TABLET', N 'Mayne Pha rma', N'10 0 TABLET i n 1 BOTTLE (51862-27 2-01)', CA ST(N'2017- 10-26T00:0 0:00.00000 00' AS Dat eTime2), C AST(N'0001 -01-01T00: 00:00.0000 000' AS Da teTime2), 1, @minDat e) | |
178 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 11, N'5186 2-272-05', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'50 mg/1', N' TABLET', N 'Mayne Pha rma', N'50 0 TABLET i n 1 BOTTLE (51862-27 2-05)', CA ST(N'2017- 10-26T00:0 0:00.00000 00' AS Dat eTime2), C AST(N'0001 -01-01T00: 00:00.0000 000' AS Da teTime2), 1, @minDat e) | |
179 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 12, N'5186 2-273-01', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'10 0 mg/1', N 'TABLET', N'Mayne Ph arma', N'1 00 TABLET in 1 BOTTL E (51862-2 73-01)', C AST(N'2016 -08-03T00: 00:00.0000 000' AS Da teTime2), CAST(N'000 1-01-01T00 :00:00.000 0000' AS D ateTime2), 1, @minDa te) | |
180 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 13, N'5186 2-273-05', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'10 0 mg/1', N 'TABLET', N'Mayne Ph arma', N'5 00 TABLET in 1 BOTTL E (51862-2 73-05)', C AST(N'2016 -08-03T00: 00:00.0000 000' AS Da teTime2), CAST(N'000 1-01-01T00 :00:00.000 0000' AS D ateTime2), 1, @minDa te) | |
181 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 14, N'5186 2-274-01', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'20 0 mg/1', N 'TABLET', N'Mayne Ph arma', N'1 00 TABLET in 1 BOTTL E (51862-2 74-01)', C AST(N'2017 -10-26T00: 00:00.0000 000' AS Da teTime2), CAST(N'000 1-01-01T00 :00:00.000 0000' AS D ateTime2), 1, @minDa te) | |
182 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 15, N'5186 2-274-05', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'20 0 mg/1', N 'TABLET', N'Mayne Ph arma', N'5 00 TABLET in 1 BOTTL E (51862-2 74-05)', C AST(N'2017 -10-26T00: 00:00.0000 000' AS Da teTime2), CAST(N'000 1-01-01T00 :00:00.000 0000' AS D ateTime2), 1, @minDa te) | |
183 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 16, N'5766 4-211-88', N'CLOZAPI NE', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'20 0 mg/1', N 'TABLET', N'Sun Phar maceutical Industrie s, Inc.', N'100 TABL ET in 1 BO TTLE (5766 4-211-88)' , CAST(N'2 017-11-08T 00:00:00.0 000000' AS DateTime2 ), CAST(N' 0001-01-01 T00:00:00. 0000000' A S DateTime 2), 1, @mi nDate) | |
184 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 17, N'5766 4-211-13', N'CLOZAPI NE', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'20 0 mg/1', N 'TABLET', N'Sun Phar maceutical Industrie s, Inc.', N'500 TABL ET in 1 BO TTLE (5766 4-211-13)' , CAST(N'2 017-11-08T 00:00:00.0 000000' AS DateTime2 ), CAST(N' 0001-01-01 T00:00:00. 0000000' A S DateTime 2), 1, @mi nDate) | |
185 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 18, N'0378 -0825-01', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'25 mg/1', N' TABLET', N 'Mylan Pha rmaceutica ls Inc.', N'100 TABL ET in 1 BO TTLE, PLAS TIC (0378- 0825-01)', CAST(N'19 99-07-08T0 0:00:00.00 00000' AS DateTime2) , CAST(N'0 001-01-01T 00:00:00.0 000000' AS DateTime2 ), 1, @min Date) | |
186 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 19, N'0378 -0860-01', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'10 0 mg/1', N 'TABLET', N'Mylan Ph armaceutic als Inc.', N'100 TAB LET in 1 B OTTLE, PLA STIC (0378 -0860-01)' , CAST(N'1 999-07-08T 00:00:00.0 000000' AS DateTime2 ), CAST(N' 0001-01-01 T00:00:00. 0000000' A S DateTime 2), 1, @mi nDate) | |
187 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 20, N'0378 -0860-05', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'10 0 mg/1', N 'TABLET', N'Mylan Ph armaceutic als Inc.', N'500 TAB LET in 1 B OTTLE, PLA STIC (0378 -0860-05)' , CAST(N'1 999-07-08T 00:00:00.0 000000' AS DateTime2 ), CAST(N' 0001-01-01 T00:00:00. 0000000' A S DateTime 2), 1, @mi nDate) | |
188 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 21, N'0378 -0972-01', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'50 mg/1', N' TABLET', N 'Mylan Pha rmaceutica ls Inc.', N'100 TABL ET in 1 BO TTLE, PLAS TIC (0378- 0972-01)', CAST(N'20 10-04-20T0 0:00:00.00 00000' AS DateTime2) , CAST(N'0 001-01-01T 00:00:00.0 000000' AS DateTime2 ), 1, @min Date) | |
189 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 22, N'0378 -0973-01', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'20 0 mg/1', N 'TABLET', N'Mylan Ph armaceutic als Inc.', N'100 TAB LET in 1 B OTTLE, PLA STIC (0378 -0973-01)' , CAST(N'2 010-04-20T 00:00:00.0 000000' AS DateTime2 ), CAST(N' 0001-01-01 T00:00:00. 0000000' A S DateTime 2), 1, @mi nDate) | |
190 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 23, N'5766 4-241-13', N'CLOZAPI NE', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'50 mg/1', N' TABLET', N 'Sun Pharm aceutical Industries , Inc.', N '500 TABLE T in 1 BOT TLE (57664 -241-13)', CAST(N'20 05-08-19T0 0:00:00.00 00000' AS DateTime2) , CAST(N'0 001-01-01T 00:00:00.0 000000' AS DateTime2 ), 1, @min Date) | |
191 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 24, N'5766 4-241-88', N'CLOZAPI NE', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'50 mg/1', N' TABLET', N 'Sun Pharm aceutical Industries , Inc.', N '100 TABLE T in 1 BOT TLE (57664 -241-88)', CAST(N'20 05-08-19T0 0:00:00.00 00000' AS DateTime2) , CAST(N'0 001-01-01T 00:00:00.0 000000' AS DateTime2 ), 1, @min Date) | |
192 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 25, N'0591 -2528-01', N'CLOZAPI NE', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'25 mg/1', N' TABLET', N 'Actavis P harma, Inc .', N'100 TABLET in 1 BOTTLE ( 0591-2528- 01)', CAST (N'2015-12 -22T00:00: 00.0000000 ' AS DateT ime2), CAS T(N'0001-0 1-01T00:00 :00.000000 0' AS Date Time2), 1, @minDate) | |
193 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 26, N'0591 -2528-05', N'CLOZAPI NE', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'25 mg/1', N' TABLET', N 'Actavis P harma, Inc .', N'500 TABLET in 1 BOTTLE ( 0591-2528- 05)', CAST (N'2015-12 -22T00:00: 00.0000000 ' AS DateT ime2), CAS T(N'0001-0 1-01T00:00 :00.000000 0' AS Date Time2), 1, @minDate) | |
194 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 27, N'0591 -2528-10', N'CLOZAPI NE', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'25 mg/1', N' TABLET', N 'Actavis P harma, Inc .', N'1000 TABLET in 1 BOTTLE (0591-2528 -10)', CAS T(N'2015-1 2-22T00:00 :00.000000 0' AS Date Time2), CA ST(N'0001- 01-01T00:0 0:00.00000 00' AS Dat eTime2), 1 , @minDate ) | |
195 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 28, N'0591 -2528-30', N'CLOZAPI NE', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'25 mg/1', N' TABLET', N 'Actavis P harma, Inc .', N'30 T ABLET in 1 BOTTLE (0 591-2528-3 0)', CAST( N'2015-12- 22T00:00:0 0.0000000' AS DateTi me2), CAST (N'0001-01 -01T00:00: 00.0000000 ' AS DateT ime2), 1, @minDate) | |
196 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 29, N'0591 -2529-01', N'CLOZAPI NE', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'10 0 mg/1', N 'TABLET', N'Actavis Pharma, In c.', N'100 TABLET in 1 BOTTLE (0591-2529 -01)', CAS T(N'2015-1 2-22T00:00 :00.000000 0' AS Date Time2), CA ST(N'0001- 01-01T00:0 0:00.00000 00' AS Dat eTime2), 1 , @minDate ) | |
197 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 30, N'0591 -2529-05', N'CLOZAPI NE', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'10 0 mg/1', N 'TABLET', N'Actavis Pharma, In c.', N'500 TABLET in 1 BOTTLE (0591-2529 -05)', CAS T(N'2015-1 2-22T00:00 :00.000000 0' AS Date Time2), CA ST(N'0001- 01-01T00:0 0:00.00000 00' AS Dat eTime2), 1 , @minDate ) | |
198 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 31, N'0591 -2529-10', N'CLOZAPI NE', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'10 0 mg/1', N 'TABLET', N'Actavis Pharma, In c.', N'100 0 TABLET i n 1 BOTTLE (0591-252 9-10)', CA ST(N'2015- 12-22T00:0 0:00.00000 00' AS Dat eTime2), C AST(N'0001 -01-01T00: 00:00.0000 000' AS Da teTime2), 1, @minDat e) | |
199 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 32, N'0591 -2529-30', N'CLOZAPI NE', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'10 0 mg/1', N 'TABLET', N'Actavis Pharma, In c.', N'30 TABLET in 1 BOTTLE ( 0591-2529- 30)', CAST (N'2015-12 -22T00:00: 00.0000000 ' AS DateT ime2), CAS T(N'0001-0 1-01T00:00 :00.000000 0' AS Date Time2), 1, @minDate) | |
200 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 33, N'5107 9-212-04', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'25 mg/1', N' TABLET, OR ALLY DISIN TEGRATING' , N'Mylan Institutio nal Inc.', N'40 BLIS TER PACK i n 1 BOX, U NIT-DOSE ( 51079-212- 04) > 1 T ABLET, ORA LLY DISINT EGRATING i n 1 BLISTE R PACK (51 079-212-01 )', CAST(N '2017-03-2 3T00:00:00 .0000000' AS DateTim e2), CAST( N'0001-01- 01T00:00:0 0.0000000' AS DateTi me2), 1, @ minDate) | |
201 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 34, N'5766 4-345-13', N'CLOZAPI NE', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'25 mg/1', N' TABLET', N 'Sun Pharm aceutical Industries , Inc.', N '500 TABLE T in 1 BOT TLE (57664 -345-13)', CAST(N'20 02-11-15T0 0:00:00.00 00000' AS DateTime2) , CAST(N'0 001-01-01T 00:00:00.0 000000' AS DateTime2 ), 1, @min Date) | |
202 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 35, N'5766 4-345-88', N'CLOZAPI NE', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'25 mg/1', N' TABLET', N 'Sun Pharm aceutical Industries , Inc.', N '100 TABLE T in 1 BOT TLE (57664 -345-88)', CAST(N'20 02-11-15T0 0:00:00.00 00000' AS DateTime2) , CAST(N'0 001-01-01T 00:00:00.0 000000' AS DateTime2 ), 1, @min Date) | |
203 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 36, N'5766 4-347-13', N'CLOZAPI NE', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'10 0 mg/1', N 'TABLET', N'Sun Phar maceutical Industrie s, Inc.', N'500 TABL ET in 1 BO TTLE (5766 4-347-13)' , CAST(N'2 002-11-15T 00:00:00.0 000000' AS DateTime2 ), CAST(N' 0001-01-01 T00:00:00. 0000000' A S DateTime 2), 1, @mi nDate) | |
204 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 37, N'5766 4-347-88', N'CLOZAPI NE', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'10 0 mg/1', N 'TABLET', N'Sun Phar maceutical Industrie s, Inc.', N'100 TABL ET in 1 BO TTLE (5766 4-347-88)' , CAST(N'2 002-11-15T 00:00:00.0 000000' AS DateTime2 ), CAST(N' 0001-01-01 T00:00:00. 0000000' A S DateTime 2), 1, @mi nDate) | |
205 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 38, N'6042 9-989-01', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'25 mg/1', N' TABLET', N 'GSMS, Inc orporated' , N'100 TA BLET in 1 BOTTLE (60 429-989-01 )', CAST(N '2018-01-1 2T00:00:00 .0000000' AS DateTim e2), CAST( N'0001-01- 01T00:00:0 0.0000000' AS DateTi me2), 1, @ minDate) | |
206 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 39, N'6042 9-990-01', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'10 0 mg/1', N 'TABLET', N'GSMS, In corporated ', N'100 T ABLET in 1 BOTTLE (6 0429-990-0 1)', CAST( N'2018-01- 12T00:00:0 0.0000000' AS DateTi me2), CAST (N'0001-01 -01T00:00: 00.0000000 ' AS DateT ime2), 1, @minDate) | |
207 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 40, N'6042 9-990-05', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'10 0 mg/1', N 'TABLET', N'GSMS, In corporated ', N'500 T ABLET in 1 BOTTLE (6 0429-990-0 5)', CAST( N'2018-01- 12T00:00:0 0.0000000' AS DateTi me2), CAST (N'0001-01 -01T00:00: 00.0000000 ' AS DateT ime2), 1, @minDate) | |
208 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 41, N'0093 -3010-01', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'10 0 mg/1', N 'TABLET, O RALLY DISI NTEGRATING ', N'Teva Pharmaceut icals USA Inc', N'10 0 TABLET, ORALLY DIS INTEGRATIN G in 1 BOT TLE (0093- 3010-01)', CAST(N'20 12-08-30T0 0:00:00.00 00000' AS DateTime2) , CAST(N'0 001-01-01T 00:00:00.0 000000' AS DateTime2 ), 1, @min Date) | |
209 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 42, N'0093 -3010-84', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'10 0 mg/1', N 'TABLET, O RALLY DISI NTEGRATING ', N'Teva Pharmaceut icals USA Inc', N'48 BLISTER P ACK in 1 C ARTON (009 3-3010-84) > 1 TABL ET, ORALLY DISINTEGR ATING in 1 BLISTER P ACK (0093- 3010-19)', CAST(N'20 12-08-30T0 0:00:00.00 00000' AS DateTime2) , CAST(N'0 001-01-01T 00:00:00.0 000000' AS DateTime2 ), 1, @min Date) | |
210 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 43, N'0093 -3011-01', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'12 .5 mg/1', N'TABLET, ORALLY DIS INTEGRATIN G', N'Teva Pharmaceu ticals USA Inc', N'1 00 TABLET, ORALLY DI SINTEGRATI NG in 1 BO TTLE (0093 -3011-01)' , CAST(N'2 012-08-30T 00:00:00.0 000000' AS DateTime2 ), CAST(N' 0001-01-01 T00:00:00. 0000000' A S DateTime 2), 1, @mi nDate) | |
211 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 44, N'0093 -3012-01', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'25 mg/1', N' TABLET, OR ALLY DISIN TEGRATING' , N'Teva P harmaceuti cals USA I nc', N'100 TABLET, O RALLY DISI NTEGRATING in 1 BOTT LE (0093-3 012-01)', CAST(N'201 2-08-30T00 :00:00.000 0000' AS D ateTime2), CAST(N'00 01-01-01T0 0:00:00.00 00000' AS DateTime2) , 1, @minD ate) | |
212 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 45, N'0093 -3012-84', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'25 mg/1', N' TABLET, OR ALLY DISIN TEGRATING' , N'Teva P harmaceuti cals USA I nc', N'48 BLISTER PA CK in 1 CA RTON (0093 -3012-84) > 1 TABLE T, ORALLY DISINTEGRA TING in 1 BLISTER PA CK (0093-3 012-19)', CAST(N'201 2-08-30T00 :00:00.000 0000' AS D ateTime2), CAST(N'00 01-01-01T0 0:00:00.00 00000' AS DateTime2) , 1, @minD ate) | |
213 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 46, N'1672 9-141-01', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'25 mg/1', N' TABLET', N 'Accord He althcare I nc.', N'10 0 TABLET i n 1 BOTTLE (16729-14 1-01)', CA ST(N'2017- 04-10T00:0 0:00.00000 00' AS Dat eTime2), C AST(N'0001 -01-01T00: 00:00.0000 000' AS Da teTime2), 1, @minDat e) | |
214 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 47, N'1672 9-141-16', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'25 mg/1', N' TABLET', N 'Accord He althcare I nc.', N'50 0 TABLET i n 1 BOTTLE (16729-14 1-16)', CA ST(N'2017- 04-10T00:0 0:00.00000 00' AS Dat eTime2), C AST(N'0001 -01-01T00: 00:00.0000 000' AS Da teTime2), 1, @minDat e) | |
215 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 48, N'1672 9-142-01', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'10 0 mg/1', N 'TABLET', N'Accord H ealthcare Inc.', N'1 00 TABLET in 1 BOTTL E (16729-1 42-01)', C AST(N'2017 -04-10T00: 00:00.0000 000' AS Da teTime2), CAST(N'000 1-01-01T00 :00:00.000 0000' AS D ateTime2), 1, @minDa te) | |
216 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 49, N'1672 9-142-16', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'10 0 mg/1', N 'TABLET', N'Accord H ealthcare Inc.', N'5 00 TABLET in 1 BOTTL E (16729-1 42-16)', C AST(N'2017 -04-10T00: 00:00.0000 000' AS Da teTime2), CAST(N'000 1-01-01T00 :00:00.000 0000' AS D ateTime2), 1, @minDa te) | |
217 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 50, N'0378 -3813-01', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'25 mg/1', N' TABLET, OR ALLY DISIN TEGRATING' , N'Mylan Pharmaceut icals Inc. ', N'100 T ABLET, ORA LLY DISINT EGRATING i n 1 BOTTLE , PLASTIC (0378-3813 -01)', CAS T(N'2015-1 1-02T00:00 :00.000000 0' AS Date Time2), CA ST(N'0001- 01-01T00:0 0:00.00000 00' AS Dat eTime2), 1 , @minDate ) | |
218 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 51, N'0378 -3815-01', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'10 0 mg/1', N 'TABLET, O RALLY DISI NTEGRATING ', N'Mylan Pharmaceu ticals Inc .', N'100 TABLET, OR ALLY DISIN TEGRATING in 1 BOTTL E, PLASTIC (0378-381 5-01)', CA ST(N'2015- 11-02T00:0 0:00.00000 00' AS Dat eTime2), C AST(N'0001 -01-01T00: 00:00.0000 000' AS Da teTime2), 1, @minDat e) | |
219 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 52, N'6586 2-844-01', N'CLOZAPI NE', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'25 mg/1', N' TABLET', N 'Aurobindo Pharma Li mited', N' 100 TABLET in 1 BOTT LE (65862- 844-01)', CAST(N'201 6-11-29T00 :00:00.000 0000' AS D ateTime2), CAST(N'00 01-01-01T0 0:00:00.00 00000' AS DateTime2) , 1, @minD ate) | |
220 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 53, N'6586 2-844-05', N'CLOZAPI NE', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'25 mg/1', N' TABLET', N 'Aurobindo Pharma Li mited', N' 500 TABLET in 1 BOTT LE (65862- 844-05)', CAST(N'201 6-11-29T00 :00:00.000 0000' AS D ateTime2), CAST(N'00 01-01-01T0 0:00:00.00 00000' AS DateTime2) , 1, @minD ate) | |
221 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 54, N'6586 2-844-78', N'CLOZAPI NE', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'25 mg/1', N' TABLET', N 'Aurobindo Pharma Li mited', N' 10 BLISTER PACK in 1 CARTON (6 5862-844-7 8) > 10 T ABLET in 1 BLISTER P ACK (65862 -844-10)', CAST(N'20 16-11-29T0 0:00:00.00 00000' AS DateTime2) , CAST(N'0 001-01-01T 00:00:00.0 000000' AS DateTime2 ), 1, @min Date) | |
222 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 55, N'6586 2-845-01', N'CLOZAPI NE', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'50 mg/1', N' TABLET', N 'Aurobindo Pharma Li mited', N' 100 TABLET in 1 BOTT LE (65862- 845-01)', CAST(N'201 6-11-29T00 :00:00.000 0000' AS D ateTime2), CAST(N'00 01-01-01T0 0:00:00.00 00000' AS DateTime2) , 1, @minD ate) | |
223 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 56, N'6586 2-845-05', N'CLOZAPI NE', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'50 mg/1', N' TABLET', N 'Aurobindo Pharma Li mited', N' 500 TABLET in 1 BOTT LE (65862- 845-05)', CAST(N'201 6-11-29T00 :00:00.000 0000' AS D ateTime2), CAST(N'00 01-01-01T0 0:00:00.00 00000' AS DateTime2) , 1, @minD ate) | |
224 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 57, N'6586 2-845-78', N'CLOZAPI NE', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'50 mg/1', N' TABLET', N 'Aurobindo Pharma Li mited', N' 10 BLISTER PACK in 1 CARTON (6 5862-845-7 8) > 10 T ABLET in 1 BLISTER P ACK (65862 -845-10)', CAST(N'20 16-11-29T0 0:00:00.00 00000' AS DateTime2) , CAST(N'0 001-01-01T 00:00:00.0 000000' AS DateTime2 ), 1, @min Date) | |
225 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 58, N'6586 2-846-01', N'CLOZAPI NE', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'10 0 mg/1', N 'TABLET', N'Aurobind o Pharma L imited', N '100 TABLE T in 1 BOT TLE (65862 -846-01)', CAST(N'20 16-11-29T0 0:00:00.00 00000' AS DateTime2) , CAST(N'0 001-01-01T 00:00:00.0 000000' AS DateTime2 ), 1, @min Date) | |
226 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 59, N'6586 2-846-05', N'CLOZAPI NE', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'10 0 mg/1', N 'TABLET', N'Aurobind o Pharma L imited', N '500 TABLE T in 1 BOT TLE (65862 -846-05)', CAST(N'20 16-11-29T0 0:00:00.00 00000' AS DateTime2) , CAST(N'0 001-01-01T 00:00:00.0 000000' AS DateTime2 ), 1, @min Date) | |
227 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 60, N'6586 2-846-78', N'CLOZAPI NE', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'10 0 mg/1', N 'TABLET', N'Aurobind o Pharma L imited', N '10 BLISTE R PACK in 1 CARTON ( 65862-846- 78) > 10 TABLET in 1 BLISTER PACK (6586 2-846-10)' , CAST(N'2 016-11-29T 00:00:00.0 000000' AS DateTime2 ), CAST(N' 0001-01-01 T00:00:00. 0000000' A S DateTime 2), 1, @mi nDate) | |
228 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 61, N'6586 2-847-01', N'CLOZAPI NE', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'20 0 mg/1', N 'TABLET', N'Aurobind o Pharma L imited', N '100 TABLE T in 1 BOT TLE (65862 -847-01)', CAST(N'20 16-11-29T0 0:00:00.00 00000' AS DateTime2) , CAST(N'0 001-01-01T 00:00:00.0 000000' AS DateTime2 ), 1, @min Date) | |
229 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 62, N'6586 2-847-05', N'CLOZAPI NE', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'20 0 mg/1', N 'TABLET', N'Aurobind o Pharma L imited', N '500 TABLE T in 1 BOT TLE (65862 -847-05)', CAST(N'20 16-11-29T0 0:00:00.00 00000' AS DateTime2) , CAST(N'0 001-01-01T 00:00:00.0 000000' AS DateTime2 ), 1, @min Date) | |
230 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 63, N'6586 2-847-78', N'CLOZAPI NE', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'20 0 mg/1', N 'TABLET', N'Aurobind o Pharma L imited', N '10 BLISTE R PACK in 1 CARTON ( 65862-847- 78) > 10 TABLET in 1 BLISTER PACK (6586 2-847-10)' , CAST(N'2 016-11-29T 00:00:00.0 000000' AS DateTime2 ), CAST(N' 0001-01-01 T00:00:00. 0000000' A S DateTime 2), 1, @mi nDate) | |
231 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 64, N'5107 9-288-04', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'10 0 mg/1', N 'TABLET, O RALLY DISI NTEGRATING ', N'Mylan Instituti onal Inc.' , N'40 BLI STER PACK in 1 BOX, UNIT-DOSE (51079-288 -04) > 1 TABLET, OR ALLY DISIN TEGRATING in 1 BLIST ER PACK (5 1079-288-0 1)', CAST( N'2016-09- 26T00:00:0 0.0000000' AS DateTi me2), CAST (N'0001-01 -01T00:00: 00.0000000 ' AS DateT ime2), 1, @minDate) | |
232 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 65, N'5107 9-749-20', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'20 0 mg/1', N 'TABLET', N'Mylan In stitutiona l Inc.', N '100 BLIST ER PACK in 1 CARTON (51079-749 -20) > 1 TABLET in 1 BLISTER PACK (5107 9-749-01)' , CAST(N'2 010-07-06T 00:00:00.0 000000' AS DateTime2 ), CAST(N' 0001-01-01 T00:00:00. 0000000' A S DateTime 2), 1, @mi nDate) | |
233 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 66, N'5107 9-921-20', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'25 mg/1', N' TABLET', N 'Mylan Ins titutional Inc.', N' 100 BLISTE R PACK in 1 CARTON ( 51079-921- 20) > 1 T ABLET in 1 BLISTER P ACK (51079 -921-01)', CAST(N'19 99-11-15T0 0:00:00.00 00000' AS DateTime2) , CAST(N'0 001-01-01T 00:00:00.0 000000' AS DateTime2 ), 1, @min Date) | |
234 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 67, N'5107 9-922-20', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'10 0 mg/1', N 'TABLET', N'Mylan In stitutiona l Inc.', N '100 BLIST ER PACK in 1 CARTON (51079-922 -20) > 1 TABLET in 1 BLISTER PACK (5107 9-922-01)' , CAST(N'1 999-11-15T 00:00:00.0 000000' AS DateTime2 ), CAST(N' 0001-01-01 T00:00:00. 0000000' A S DateTime 2), 1, @mi nDate) | |
235 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 68, N'0093 -3086-01', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'15 0 mg/1', N 'TABLET, O RALLY DISI NTEGRATING ', N'Teva Pharmaceut icals USA Inc', N'10 0 TABLET, ORALLY DIS INTEGRATIN G in 1 BOT TLE (0093- 3086-01)', CAST(N'20 15-05-05T0 0:00:00.00 00000' AS DateTime2) , CAST(N'0 001-01-01T 00:00:00.0 000000' AS DateTime2 ), 1, @min Date) | |
236 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 69, N'0093 -3086-19', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'15 0 mg/1', N 'TABLET, O RALLY DISI NTEGRATING ', N'Teva Pharmaceut icals USA Inc', N'1 TABLET, OR ALLY DISIN TEGRATING in 1 BLIST ER PACK (0 093-3086-1 9)', CAST( N'2015-05- 05T00:00:0 0.0000000' AS DateTi me2), CAST (N'0001-01 -01T00:00: 00.0000000 ' AS DateT ime2), 1, @minDate) | |
237 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 70, N'0093 -3086-84', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'15 0 mg/1', N 'TABLET, O RALLY DISI NTEGRATING ', N'Teva Pharmaceut icals USA Inc', N'48 TABLET, O RALLY DISI NTEGRATING in 1 CART ON (0093-3 086-84)', CAST(N'201 5-05-05T00 :00:00.000 0000' AS D ateTime2), CAST(N'00 01-01-01T0 0:00:00.00 00000' AS DateTime2) , 1, @minD ate) | |
238 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 71, N'0093 -3087-01', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'20 0 mg/1', N 'TABLET, O RALLY DISI NTEGRATING ', N'Teva Pharmaceut icals USA Inc', N'10 0 TABLET, ORALLY DIS INTEGRATIN G in 1 BOT TLE (0093- 3087-01)', CAST(N'20 15-05-05T0 0:00:00.00 00000' AS DateTime2) , CAST(N'0 001-01-01T 00:00:00.0 000000' AS DateTime2 ), 1, @min Date) | |
239 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 72, N'0093 -3087-19', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'20 0 mg/1', N 'TABLET, O RALLY DISI NTEGRATING ', N'Teva Pharmaceut icals USA Inc', N'1 TABLET, OR ALLY DISIN TEGRATING in 1 BLIST ER PACK (0 093-3087-1 9)', CAST( N'2015-05- 05T00:00:0 0.0000000' AS DateTi me2), CAST (N'0001-01 -01T00:00: 00.0000000 ' AS DateT ime2), 1, @minDate) | |
240 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 73, N'0093 -3087-84', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'20 0 mg/1', N 'TABLET, O RALLY DISI NTEGRATING ', N'Teva Pharmaceut icals USA Inc', N'48 TABLET, O RALLY DISI NTEGRATING in 1 CART ON (0093-3 087-84)', CAST(N'201 5-05-05T00 :00:00.000 0000' AS D ateTime2), CAST(N'00 01-01-01T0 0:00:00.00 00000' AS DateTime2) , 1, @minD ate) | |
241 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 74, N'0093 -4359-01', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'25 mg/1', N' TABLET', N 'Teva Phar maceutical s USA, Inc .', N'100 TABLET in 1 BOTTLE ( 0093-4359- 01)', CAST (N'2007-05 -10T00:00: 00.0000000 ' AS DateT ime2), CAS T(N'0001-0 1-01T00:00 :00.000000 0' AS Date Time2), 1, @minDate) | |
242 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 75, N'0093 -4359-05', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'25 mg/1', N' TABLET', N 'Teva Phar maceutical s USA, Inc .', N'500 TABLET in 1 BOTTLE ( 0093-4359- 05)', CAST (N'2007-05 -10T00:00: 00.0000000 ' AS DateT ime2), CAS T(N'0001-0 1-01T00:00 :00.000000 0' AS Date Time2), 1, @minDate) | |
243 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 76, N'0093 -4359-93', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'25 mg/1', N' TABLET', N 'Teva Phar maceutical s USA, Inc .', N'100 BLISTER PA CK in 1 BO X, UNIT-DO SE (0093-4 359-93) > 1 TABLET in 1 BLIST ER PACK (0 093-4359-1 9)', CAST( N'2007-05- 10T00:00:0 0.0000000' AS DateTi me2), CAST (N'0001-01 -01T00:00: 00.0000000 ' AS DateT ime2), 1, @minDate) | |
244 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 77, N'0093 -4404-01', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'50 mg/1', N' TABLET', N 'Teva Phar maceutical s USA, Inc .', N'100 TABLET in 1 BOTTLE ( 0093-4404- 01)', CAST (N'2007-03 -19T00:00: 00.0000000 ' AS DateT ime2), CAS T(N'0001-0 1-01T00:00 :00.000000 0' AS Date Time2), 1, @minDate) | |
245 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 78, N'0093 -4404-05', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'50 mg/1', N' TABLET', N 'Teva Phar maceutical s USA, Inc .', N'500 TABLET in 1 BOTTLE ( 0093-4404- 05)', CAST (N'2007-03 -19T00:00: 00.0000000 ' AS DateT ime2), CAS T(N'0001-0 1-01T00:00 :00.000000 0' AS Date Time2), 1, @minDate) | |
246 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 79, N'0093 -4404-93', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'50 mg/1', N' TABLET', N 'Teva Phar maceutical s USA, Inc .', N'100 BLISTER PA CK in 1 BO X, UNIT-DO SE (0093-4 404-93) > 1 TABLET in 1 BLIST ER PACK (0 093-4404-1 9)', CAST( N'2007-03- 19T00:00:0 0.0000000' AS DateTi me2), CAST (N'0001-01 -01T00:00: 00.0000000 ' AS DateT ime2), 1, @minDate) | |
247 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 80, N'0093 -4405-01', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'20 0 mg/1', N 'TABLET', N'Teva Pha rmaceutica ls USA, In c.', N'100 TABLET in 1 BOTTLE (0093-4405 -01)', CAS T(N'2007-0 5-15T00:00 :00.000000 0' AS Date Time2), CA ST(N'0001- 01-01T00:0 0:00.00000 00' AS Dat eTime2), 1 , @minDate ) | |
248 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 81, N'0093 -4405-05', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'20 0 mg/1', N 'TABLET', N'Teva Pha rmaceutica ls USA, In c.', N'500 TABLET in 1 BOTTLE (0093-4405 -05)', CAS T(N'2007-0 5-15T00:00 :00.000000 0' AS Date Time2), CA ST(N'0001- 01-01T00:0 0:00.00000 00' AS Dat eTime2), 1 , @minDate ) | |
249 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 82, N'0093 -4405-93', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'20 0 mg/1', N 'TABLET', N'Teva Pha rmaceutica ls USA, In c.', N'100 BLISTER P ACK in 1 B OX, UNIT-D OSE (0093- 4405-93) > 1 TABLET in 1 BLIS TER PACK ( 0093-4405- 19)', CAST (N'2007-05 -15T00:00: 00.0000000 ' AS DateT ime2), CAS T(N'0001-0 1-01T00:00 :00.000000 0' AS Date Time2), 1, @minDate) | |
250 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 83, N'0093 -5417-01', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'25 mg/1', N' TABLET, OR ALLY DISIN TEGRATING' , N'Teva P harmaceuti cals USA, Inc.', N'1 00 TABLET, ORALLY DI SINTEGRATI NG in 1 BO TTLE (0093 -5417-01)' , CAST(N'2 017-07-25T 00:00:00.0 000000' AS DateTime2 ), CAST(N' 0001-01-01 T00:00:00. 0000000' A S DateTime 2), 1, @mi nDate) | |
251 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 84, N'0093 -5417-84', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'25 mg/1', N' TABLET, OR ALLY DISIN TEGRATING' , N'Teva P harmaceuti cals USA, Inc.', N'4 8 BLISTER PACK in 1 CARTON (00 93-5417-84 ) > 1 TAB LET, ORALL Y DISINTEG RATING in 1 BLISTER PACK (0093 -5417-19)' , CAST(N'2 017-07-25T 00:00:00.0 000000' AS DateTime2 ), CAST(N' 0001-01-01 T00:00:00. 0000000' A S DateTime 2), 1, @mi nDate) | |
252 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 85, N'0093 -5419-01', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'10 0 mg/1', N 'TABLET, O RALLY DISI NTEGRATING ', N'Teva Pharmaceut icals USA, Inc.', N' 100 TABLET , ORALLY D ISINTEGRAT ING in 1 B OTTLE (009 3-5419-01) ', CAST(N' 2017-07-25 T00:00:00. 0000000' A S DateTime 2), CAST(N '0001-01-0 1T00:00:00 .0000000' AS DateTim e2), 1, @m inDate) | |
253 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 86, N'0093 -5419-84', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'10 0 mg/1', N 'TABLET, O RALLY DISI NTEGRATING ', N'Teva Pharmaceut icals USA, Inc.', N' 48 BLISTER PACK in 1 CARTON (0 093-5419-8 4) > 1 TA BLET, ORAL LY DISINTE GRATING in 1 BLISTER PACK (009 3-5419-19) ', CAST(N' 2017-07-25 T00:00:00. 0000000' A S DateTime 2), CAST(N '0001-01-0 1T00:00:00 .0000000' AS DateTim e2), 1, @m inDate) | |
254 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 87, N'0093 -7772-01', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'10 0 mg/1', N 'TABLET', N'Teva Pha rmaceutica ls USA, In c.', N'100 TABLET in 1 BOTTLE (0093-7772 -01)', CAS T(N'2009-0 9-18T00:00 :00.000000 0' AS Date Time2), CA ST(N'0001- 01-01T00:0 0:00.00000 00' AS Dat eTime2), 1 , @minDate ) | |
255 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 88, N'0093 -7772-05', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'10 0 mg/1', N 'TABLET', N'Teva Pha rmaceutica ls USA, In c.', N'500 TABLET in 1 BOTTLE (0093-7772 -05)', CAS T(N'2009-0 9-18T00:00 :00.000000 0' AS Date Time2), CA ST(N'0001- 01-01T00:0 0:00.00000 00' AS Dat eTime2), 1 , @minDate ) | |
256 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 89, N'0093 -7772-93', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'10 0 mg/1', N 'TABLET', N'Teva Pha rmaceutica ls USA, In c.', N'100 BLISTER P ACK in 1 B OX, UNIT-D OSE (0093- 7772-93) > 1 TABLET in 1 BLIS TER PACK ( 0093-7772- 19)', CAST (N'2009-09 -18T00:00: 00.0000000 ' AS DateT ime2), CAS T(N'0001-0 1-01T00:00 :00.000000 0' AS Date Time2), 1, @minDate) | |
257 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 90, N'0781 -5989-01', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'25 mg/1', N' TABLET', N 'Sandoz In c.', N'100 TABLET in 1 BOTTLE (0781-5989 -01)', CAS T(N'2016-0 5-06T00:00 :00.000000 0' AS Date Time2), CA ST(N'0001- 01-01T00:0 0:00.00000 00' AS Dat eTime2), 1 , @minDate ) | |
258 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 91, N'0781 -5992-01', N'Clozapi ne', CAST( N'2018-02- 21T14:36:1 1.8100000' AS DateTi me2), CAST (N'2018-02 -21T14:36: 11.8100000 ' AS DateT ime2), 1, NULL, N'10 0 mg/1', N 'TABLET', N'Sandoz I nc.', N'10 0 TABLET i n 1 BOTTLE (0781-599 2-01)', CA ST(N'2016- 05-06T00:0 0:00.00000 00' AS Dat eTime2), C AST(N'0001 -01-01T00: 00:00.0000 000' AS Da teTime2), 1, @minDat e) | |
259 | INSERT [db o].[Medica tions] ([I d], [NdcPa ckageCode] , [Proprie taryName], [Created] , [LastMod ified], [C reatedBy_I d], [LastM odifiedBy_ Id], [Stre ngth], [Do sageForm], [LabelerN ame], [Pac kageDescri ption], [S tartMarket ingDate], [EndMarket ingDate], [Imported] , [Certifi edThrough] ) VALUES ( 92, N'6918 9-7772-1', N'Clozapi ne (U)', C AST(N'2018 -02-21T14: 36:11.8100 000' AS Da teTime2), CAST(N'201 8-02-21T14 :36:11.810 0000' AS D ateTime2), 1, NULL, N' ', N' ' , N'Avera McKennan H ospital', N' ', CAST (N'0001-01 -01T00:00: 00.0000000 ' AS DateT ime2), CAS T(N'0001-0 1-01T00:00 :00.000000 0' AS Date Time2), 1, @minDate) | |
260 | SET IDENTI TY_INSERT [dbo].[Med ications] OFF | |
261 | ||
262 | --5 Prescr ibers | |
263 | ||
264 | ||
265 | SET IDENTI TY_INSERT [dbo].[Pre scribers] ON | |
266 | INSERT INT O Prescrib ers (Id,Pr escriberNa me_First,P rescriberN ame_Last,P rescriberN ame_Middle ,Npi | |
267 | ,RemsId,D ateRegiste red,Commen ts,Created ,LastModif ied,Create dBy_Id,Cre dentials_I d,LastModi fiedBy_Id) | |
268 | VALUE S | |
269 | (1,'Presc riberName_ First 1',' Prescriber Name_Last 1','Prescr iberName_M iddle 1', | |
270 | '12345678 90','Presc ribers Rem sId1', get Date(),'Pr escriber C omments', getDate(), | |
271 | getdate() , 1, 1, 1) | |
272 | ||
273 | INSERT INT O Prescrib ers (Id,Pr escriberNa me_First,P rescriberN ame_Last,P rescriberN ame_Middle ,Npi | |
274 | ,RemsId,D ateRegiste red,Commen ts,Created ,LastModif ied,Create dBy_Id,Cre dentials_I d,LastModi fiedBy_Id) | |
275 | VALUE S | |
276 | (2,'Presc riberName_ First 2',' Prescriber Name_Last 2','Prescr iberName_M iddle 2', | |
277 | '12345678 90','Presc ribers Rem sId2', get Date(),'Pr escriber C omments 2' , getDate( ), | |
278 | getdate() , 1, 2, 1) | |
279 | ||
280 | INSERT INT O Prescrib ers (Id,Pr escriberNa me_First,P rescriberN ame_Last,P rescriberN ame_Middle ,Npi | |
281 | ,RemsId,D ateRegiste red,Commen ts,Created ,LastModif ied,Create dBy_Id,Cre dentials_I d,LastModi fiedBy_Id) | |
282 | VALUE S (3,'Pres criberName _First 3', 'Prescribe rName_Last 3','Presc riberName_ Middle 3', '123456789 0','Prescr ibers Rems Id3', getD ate(),'Pre scriber Co mments 3', getDate() ,getdate() , 1, 3, 1) | |
283 | ||
284 | INSERT INT O Prescrib ers (Id,Pr escriberNa me_First,P rescriberN ame_Last,P rescriberN ame_Middle ,Npi,RemsI d,DateRegi stered,Com ments,Crea ted,LastMo dified,Cre atedBy_Id, Credential s_Id,LastM odifiedBy_ Id) | |
285 | VALUE S (4,'Pres criberName _First 4', 'Prescribe rName_Last 4','Presc riberName_ Middle 4', '123456789 0','Prescr ibers Rems Id4', getD ate(),'Pre scriber Co mments 4', getDate() , | |
286 | getdate() , 1, 4, 1) | |
287 | ||
288 | INSERT INT O Prescrib ers (Id,Pr escriberNa me_First,P rescriberN ame_Last,P rescriberN ame_Middle ,Npi,RemsI d,DateRegi stered,Com ments,Crea ted,LastMo dified,Cre atedBy_Id, Credential s_Id,LastM odifiedBy_ Id) | |
289 | VALUE S (5,'Pres criberName _First 5', 'Prescribe rName_Last 5','Presc riberName_ Middle 5', '123456789 0','Prescr ibers Rems Id5', getD ate(),'Pre scriber Co mments 5', getDate() , getdate( ), 1, 5, 1 ) | |
290 | ||
291 | SET IDENTI TY_INSERT [dbo].[Pre scribers] OFF | |
292 | ||
293 | ||
294 | SET IDENTI TY_INSERT [dbo].[Pre scriberFac ilities] O N | |
295 | INSERT INT O Prescrib erFaciliti es(Id,Acti ve,Facilit y_Id,Presc riber_Id) VALUES (1, 1,1,1) | |
296 | INSERT INT O Prescrib erFaciliti es(Id,Acti ve,Facilit y_Id,Presc riber_Id) VALUES (2, 1,2,2) | |
297 | INSERT INT O Prescrib erFaciliti es(Id,Acti ve,Facilit y_Id,Presc riber_Id) VALUES (3, 1,3,3) | |
298 | INSERT INT O Prescrib erFaciliti es(Id,Acti ve,Facilit y_Id,Presc riber_Id) VALUES (4, 1,4,4) | |
299 | INSERT INT O Prescrib erFaciliti es(Id,Acti ve,Facilit y_Id,Presc riber_Id) VALUES (5, 1,5,5) | |
300 | ||
301 | SET IDENTI TY_INSERT [dbo].[Pre scriberFac ilities] O FF | |
302 | ||
303 | ||
304 | ||
305 | SET IDENTI TY_INSERT [dbo].[Dea s] ON | |
306 | --The seco nd letter of the DEA Number do es not mat ch the fir st letter in the Pre scribers l ast name | |
307 | INSERT INT O [dbo].[D eas]([Id], [Number],[ Expiration ],[Verifie dOn],[Comm ent],[Crea ted] | |
308 | ,[LastMod ified],[Cr eatedBy_Id ],[LastMod ifiedBy_Id ],[Pharmac y_Id],[Pre scriber_Id ],[Verific ation_Id] | |
309 | ,[Facilit y_Id]) | |
310 | VALUE S (1,'PP3K 5L7J91',ge tdate()+ 3 0,getdate( ),'DEA Com ment 1',ge tdate(),ge tdate(),1, 1,1,1,2,1) | |
311 | ||
312 | INSERT INT O [dbo].[D eas]([Id], [Number],[ Expiration ],[Verifie dOn],[Comm ent],[Crea ted] | |
313 | ,[LastMod ified],[Cr eatedBy_Id ],[LastMod ifiedBy_Id ],[Pharmac y_Id],[Pre scriber_Id ],[Verific ation_Id] | |
314 | ,[Facilit y_Id]) | |
315 | VALUE S (2,'PP3K 5L7J92',ge tdate()+ 3 0,getdate( ),'DEA Com ment 1',ge tdate(),ge tdate(),1, 1,2,2,2,2) | |
316 | ||
317 | INSERT INT O [dbo].[D eas]([Id], [Number],[ Expiration ],[Verifie dOn],[Comm ent],[Crea ted] | |
318 | ,[LastMod ified],[Cr eatedBy_Id ],[LastMod ifiedBy_Id ],[Pharmac y_Id],[Pre scriber_Id ],[Verific ation_Id] | |
319 | ,[Facilit y_Id]) | |
320 | VALUE S (3,'PP3K 5L7J93',ge tdate()+ 3 0,getdate( ),'DEA Com ment 1',ge tdate(),ge tdate(),1, 1,3,3,2,3) | |
321 | ||
322 | INSERT INT O [dbo].[D eas]([Id], [Number],[ Expiration ],[Verifie dOn],[Comm ent],[Crea ted] | |
323 | ,[LastMod ified],[Cr eatedBy_Id ],[LastMod ifiedBy_Id ],[Pharmac y_Id],[Pre scriber_Id ],[Verific ation_Id] | |
324 | ,[Facilit y_Id]) | |
325 | VALUE S (4,'PP3K 5L7J94',ge tdate()+ 3 0,getdate( ),'DEA Com ment 1',ge tdate(),ge tdate(),1, 1,4,4,2,4) | |
326 | ||
327 | INSERT INT O [dbo].[D eas]([Id], [Number],[ Expiration ],[Verifie dOn],[Comm ent],[Crea ted] | |
328 | ,[LastMod ified],[Cr eatedBy_Id ],[LastMod ifiedBy_Id ],[Pharmac y_Id],[Pre scriber_Id ],[Verific ation_Id] | |
329 | ,[Facilit y_Id]) | |
330 | VALUE S (5,'PP3K 5L7J95',ge tdate()+ 3 0,getdate( ),'DEA Com ment 1',ge tdate(),ge tdate(),1, 1,4,5,2,5) | |
331 | SET IDENTI TY_INSERT [dbo].[Dea s] OFF | |
332 | ||
333 | declare @P honeNumber Type_Id in t | |
334 | SELECT @Ph oneNumberT ype_Id= Id FROM Pho neNumberTy pes where PhoneNumbe rTypeName= 'Office' | |
335 | ||
336 | SET IDENTI TY_INSERT [dbo].[Pho neNumbers] ON | |
337 | INSERT INT O [dbo].[P honeNumber s] ([Id],[ Number],[E xtension], [Created], [LastModif ied] | |
338 | ,[Prescri ber_Id],[C ontact_Id] ,[CreatedB y_Id],[Las tModifiedB y_Id],[Pha rmacy_Id] | |
339 | ,[PhoneNu mberType_I d]) | |
340 | VALUE S | |
341 | (1,'12312 31234','12 3',getdate (),getdate (),1,1,1,1 ,1,@PhoneN umberType_ Id) | |
342 | ||
343 | INSERT INT O [dbo].[P honeNumber s] ([Id],[ Number],[E xtension], [Created], [LastModif ied] | |
344 | ,[Prescri ber_Id],[C ontact_Id] ,[CreatedB y_Id] | |
345 | ,[LastMod ifiedBy_Id ] | |
346 | ,[Pharmac y_Id] | |
347 | ,[PhoneNu mberType_I d]) | |
348 | VALUE S | |
349 | (2,'12312 31234','12 3',getdate (),getdate (),2,2,1,1 ,2,@PhoneN umberType_ Id) | |
350 | ||
351 | SET IDENTI TY_INSERT [dbo].[Pho neNumbers] OFF | |
352 | ||
353 | ||
354 | INSERT INT O [dbo].[F acilityPho neNumbers] ([Facilit y_Id] ,[Ph oneNumber_ Id]) VALUE S (1,1) | |
355 | INSERT INT O [dbo].[F acilityPho neNumbers] ([Facilit y_Id] ,[Ph oneNumber_ Id]) VALUE S (2,1) | |
356 | INSERT INT O [dbo].[F acilityPho neNumbers] ([Facilit y_Id] ,[Ph oneNumber_ Id]) VALUE S (3,1) | |
357 | INSERT INT O [dbo].[F acilityPho neNumbers] ([Facilit y_Id] ,[Ph oneNumber_ Id]) VALUE S (4,1) | |
358 | INSERT INT O [dbo].[F acilityPho neNumbers] ([Facilit y_Id] ,[Ph oneNumber_ Id]) VALUE S (5,1) | |
359 | ||
360 | ||
361 | ||
362 | INSERT INT O [dbo].[C ontactPhar macies]([C ontact_Id] ,[Pharmac y_Id], [Is Authorized Representa tive], [Is Deleted]) VALUES (1 ,1,0,0) | |
363 | INSERT INT O [dbo].[C ontactPhar macies]([C ontact_Id] ,[Pharmac y_Id], [Is Authorized Representa tive], [Is Deleted]) VALUES (3 ,3,0,0) | |
364 | INSERT INT O [dbo].[C ontactPhar macies]([C ontact_Id] ,[Pharmac y_Id], [Is Authorized Representa tive], [Is Deleted]) VALUES (4 ,4,0,0) | |
365 | INSERT INT O [dbo].[C ontactPhar macies]([C ontact_Id] ,[Pharmac y_Id], [Is Authorized Representa tive], [Is Deleted]) VALUES (5 ,5,0,0) | |
366 | ||
367 | ||
368 | INSERT INT O [dbo].[C ontactFaci lities]([C ontact_Id] ,[Facility _Id]) VALU ES (1,1) | |
369 | INSERT INT O [dbo].[C ontactFaci lities]([C ontact_Id] ,[Facility _Id]) VALU ES (2,2) | |
370 | INSERT INT O [dbo].[C ontactFaci lities]([C ontact_Id] ,[Facility _Id]) VALU ES (3,3) | |
371 | INSERT INT O [dbo].[C ontactFaci lities]([C ontact_Id] ,[Facility _Id]) VALU ES (4,4) | |
372 | INSERT INT O [dbo].[C ontactFaci lities]([C ontact_Id] ,[Facility _Id]) VALU ES (5,5) | |
373 | ||
374 | -- 5 Patients | |
375 | SET IDENTI TY_INSERT [dbo].[Pat ients] ON | |
376 | ||
377 | INSERT INT O [dbo].[P atients]([ Id],[Ssn], [PatientNa me_First], [PatientNa me_Last] | |
378 | ,[Patient Name_Middl e],[Race], [Ethnicity ],[DateOfB irth],[Zip Code],[ICN ], [DFN],[ Created],[ LastModifi ed],[Creat edBy_Id],[ FileLocati on_Id],[Ge nder_Id] | |
379 | ,[LastMod ifiedBy_Id ],[Treatme ntStatus_I d],DateOfD eath) | |
380 | VALUE S (1,'1234 56789','Pa tientName_ First 1',' PatientNam e_Last 1', 'PatientNa me_Middle 1' | |
381 | ,'Decline d To Answe r','Declin ed To Answ er','1971/ 12/12','75 968',1,2,g etdate(),g etdate(),1 ,0,1,1,1,' 0001-01-01 00:00:00. 0000000') | |
382 | ||
383 | INSERT INT O [dbo].[P atients]([ Id],[Ssn], [PatientNa me_First], [PatientNa me_Last] | |
384 | ,[Patient Name_Middl e],[Race], [Ethnicity ],[DateOfB irth],[Zip Code],[ICN ], [DFN],[ Created],[ LastModifi ed],[Creat edBy_Id],[ FileLocati on_Id],[Ge nder_Id] | |
385 | ,[LastMod ifiedBy_Id ],[Treatme ntStatus_I d],DateOfD eath) | |
386 | VALUE S (2,'1234 56785','Pa tientName_ First 2',' PatientNam e_Last 2', 'PatientNa me_Middle 2' | |
387 | ,'Decline d To Answe r','Declin ed To Answ er','1971/ 12/12','75 968',2,3,g etdate(),g etdate(),1 ,0,1,1,1,' 0001-01-01 00:00:00. 0000000') | |
388 | ||
389 | INSERT INT O [dbo].[P atients]([ Id],[Ssn], [PatientNa me_First], [PatientNa me_Last] | |
390 | ,[Patient Name_Middl e],[Race], [Ethnicity ],[DateOfB irth],[Zip Code],[ICN ], [DFN],[ Created],[ LastModifi ed],[Creat edBy_Id],[ FileLocati on_Id],[Ge nder_Id] | |
391 | ,[LastMod ifiedBy_Id ],[Treatme ntStatus_I d],DateOfD eath) | |
392 | VALUE S (3,'1234 56786','Pa tientName_ First 3',' PatientNam e_Last 3', 'PatientNa me_Middle 3' | |
393 | ,'Decline d To Answe r','Declin ed To Answ er','1971/ 12/12','75 968',3,4,g etdate(),g etdate(),1 ,0,1,1,1,' 0001-01-01 00:00:00. 0000000') | |
394 | ||
395 | INSERT INT O [dbo].[P atients]([ Id],[Ssn], [PatientNa me_First], [PatientNa me_Last] | |
396 | ,[Patient Name_Middl e],[Race], [Ethnicity ],[DateOfB irth],[Zip Code],[ICN ], [DFN],[ Created],[ LastModifi ed],[Creat edBy_Id],[ FileLocati on_Id],[Ge nder_Id] | |
397 | ,[LastMod ifiedBy_Id ],[Treatme ntStatus_I d],DateOfD eath) | |
398 | VALUE S (4,'1234 56787','Pa tientName_ First 4',' PatientNam e_Last 4', 'PatientNa me_Middle 4' | |
399 | ,'Decline d To Answe r','Declin ed To Answ er','1971/ 12/12','75 968',4,5,g etdate(),g etdate(),1 ,0,1,1,1,' 0001-01-01 00:00:00. 0000000') | |
400 | ||
401 | INSERT INT O [dbo].[P atients]([ Id],[Ssn], [PatientNa me_First], [PatientNa me_Last] | |
402 | ,[Patient Name_Middl e],[Race], [Ethnicity ],[DateOfB irth],[Zip Code],[ICN ], [DFN],[ Created],[ LastModifi ed],[Creat edBy_Id],[ FileLocati on_Id],[Ge nder_Id] | |
403 | ,[LastMod ifiedBy_Id ],[Treatme ntStatus_I d],DateOfD eath) | |
404 | VALUE S (5,'1234 56788','Pa tientName_ First 5',' PatientNam e_Last 5', 'PatientNa me_Middle 5' | |
405 | ,'Decline d To Answe r','Declin ed To Answ er','1971/ 12/12','75 968',5,6,g etdate(),g etdate(),1 ,0,1,1,2,' 0001-01-01 00:00:00. 0000000') | |
406 | ||
407 | SET IDENT ITY_INSERT [dbo].[Pa tients] OF F | |
408 | ||
409 | -- 5 Diagnoses | |
410 | SET IDENTI TY_INSERT [dbo].[Pat ientDiagno sis] ON | |
411 | ||
412 | INSERT INT O [dbo].[P atientDiag nosis]([Id ],[Diagnos isDate] ,[ Active] ,[ Created] , [LastModif ied] | |
413 | ,[OtherDe scription] ,[Code_Id] ,[Created By_Id],[Di agnosedBy_ Id] ,[Last ModifiedBy _Id] | |
414 | ,[Patient _Id]) | |
415 | VALUE S | |
416 | (1,getdat e(),1,getd ate(),getd ate(),'Oth erDescript ion 1',1,1 ,1,1,1) | |
417 | INSERT INT O [dbo].[P atientDiag nosis]([Id ],[Diagnos isDate] ,[ Active] ,[ Created] , [LastModif ied] | |
418 | ,[OtherDe scription] ,[Code_Id] ,[Created By_Id],[Di agnosedBy_ Id] ,[Last ModifiedBy _Id] | |
419 | ,[Patient _Id]) | |
420 | VALUE S | |
421 | (2,getdat e(),1,getd ate(),getd ate(),'Oth erDescript ion 2',2,1 ,1,1,1) | |
422 | ||
423 | INSERT INT O [dbo].[P atientDiag nosis]([Id ],[Diagnos isDate] ,[ Active] ,[ Created] , [LastModif ied] | |
424 | ,[OtherDe scription] ,[Code_Id] ,[Created By_Id],[Di agnosedBy_ Id] ,[Last ModifiedBy _Id] | |
425 | ,[Patient _Id]) | |
426 | VALUE S | |
427 | (3,getdat e(),1,getd ate(),getd ate(),'Oth erDescript ion 1',3,1 ,1,1,1) | |
428 | ||
429 | ||
430 | INSERT INT O [dbo].[P atientDiag nosis]([Id ],[Diagnos isDate] ,[ Active] ,[ Created] , [LastModif ied] | |
431 | ,[OtherDe scription] ,[Code_Id] ,[Created By_Id],[Di agnosedBy_ Id] ,[Last ModifiedBy _Id] | |
432 | ,[Patient _Id]) | |
433 | VALUE S | |
434 | (4,getdat e(),1,getd ate(),getd ate(),'Oth erDescript ion 1',4,1 ,1,1,1) | |
435 | ||
436 | INSERT INT O [dbo].[P atientDiag nosis]([Id ],[Diagnos isDate] ,[ Active] ,[ Created] , [LastModif ied] | |
437 | ,[OtherDe scription] ,[Code_Id] ,[Created By_Id],[Di agnosedBy_ Id] ,[Last ModifiedBy _Id] | |
438 | ,[Patient _Id]) | |
439 | VALUE S (5,getd ate(),1,ge tdate(),ge tdate(),'O therDescri ption 1',5 ,1,1,1,1) | |
440 | ||
441 | SET IDENTI TY_INSERT [dbo].[Pat ientDiagno sis] OFF | |
442 | ||
443 | ||
444 | -- 5 Special Co nditions | |
445 | SET IDENTI TY_INSERT [dbo].[Spe cialCondit ions] ON | |
446 | INSERT INT O [dbo].[S pecialCond itions]([I d],[Condit ionDate],[ Descriptio n],[Active ],[Created ] | |
447 | ,[LastMod ified],[Cr eatedBy_Id ],[LastMod ifiedBy_Id ] ,[Patien t_Id]) | |
448 | VALUE S (1,getda te(),'Chem otherapy', 1,getdate( ),getdate( ),1,1,1) | |
449 | ||
450 | INSERT INT O [dbo].[S pecialCond itions]([I d],[Condit ionDate],[ Descriptio n],[Active ],[Created ] | |
451 | ,[LastMod ified],[Cr eatedBy_Id ],[LastMod ifiedBy_Id ] ,[Patien t_Id]) | |
452 | VALUE S (2,getda te(),'Hosp ice',1,get date(),get date(),1,1 ,1) | |
453 | ||
454 | INSERT INT O [dbo].[S pecialCond itions]([I d],[Condit ionDate],[ Descriptio n],[Active ],[Created ] | |
455 | ,[LastMod ified],[Cr eatedBy_Id ],[LastMod ifiedBy_Id ] ,[Patien t_Id]) | |
456 | VALUE S (3,getda te(),'Beni gn Ethnic Neutropeni a',1,getda te(),getda te(),1,1,1 ) | |
457 | ||
458 | INSERT INT O [dbo].[S pecialCond itions]([I d],[Condit ionDate],[ Descriptio n],[Active ],[Created ] | |
459 | ,[LastMod ified],[Cr eatedBy_Id ],[LastMod ifiedBy_Id ] ,[Patien t_Id]) | |
460 | VALUE S (4,getda te(),'Desc ription_sp ecial',1,g etdate(),g etdate(),1 ,1,1) | |
461 | ||
462 | INSERT INT O [dbo].[S pecialCond itions]([I d],[Condit ionDate],[ Descriptio n],[Active ],[Created ] | |
463 | ,[LastMod ified],[Cr eatedBy_Id ],[LastMod ifiedBy_Id ] ,[Patien t_Id]) | |
464 | VALUE S (5,getda te(),'Spec ial Condit ion Descri ption 2',1 ,getdate() ,getdate() ,1,1,1) | |
465 | ||
466 | ||
467 | SET IDENTI TY_INSERT [dbo].[Spe cialCondit ions] OFF | |
468 | ||
469 | -- 5 Prescripti ons | |
470 | SET IDENTI TY_INSERT [dbo].[Pha rmacists] ON | |
471 | INSERT INT O [dbo].[P harmacists ]([Id],[Ph armacistNa me_First], [Pharmacis tName_Last ] | |
472 | ,[Pharmac istName_Mi ddle],[Cre ated],[Las tModified] ,[CreatedB y_Id] | |
473 | ,[Dea_Id] ,[LastModi fiedBy_Id] ,[Pharmacy _Id]) | |
474 | VALUE S | |
475 | (1,'Pharm acistName_ First 1',' Pharmacist Name_Last 1','Pharma cistName_M iddle 1',g etdate(), | |
476 | getdate() ,1,1,1,1) | |
477 | ||
478 | INSERT INT O [dbo].[P harmacists ]([Id],[Ph armacistNa me_First], [Pharmacis tName_Last ] | |
479 | ,[Pharmac istName_Mi ddle],[Cre ated],[Las tModified] ,[CreatedB y_Id] | |
480 | ,[Dea_Id] ,[LastModi fiedBy_Id] ,[Pharmacy _Id]) | |
481 | VALUE S | |
482 | (2,'Pharm acistName_ First 2',' Pharmacist Name_Last 2','Pharma cistName_M iddle 2',g etdate(), | |
483 | getdate() ,1,2,1,2) | |
484 | ||
485 | INSERT INT O [dbo].[P harmacists ]([Id],[Ph armacistNa me_First], [Pharmacis tName_Last ] | |
486 | ,[Pharmac istName_Mi ddle],[Cre ated],[Las tModified] ,[CreatedB y_Id] | |
487 | ,[Dea_Id] ,[LastModi fiedBy_Id] ,[Pharmacy _Id]) | |
488 | VALUE S | |
489 | (3,'Pharm acistName_ First 3',' Pharmacist Name_Last 3','Pharma cistName_M iddle 3',g etdate(),g etdate(),1 ,3,1,3) | |
490 | SET IDENTI TY_INSERT [dbo].[Pha rmacists] OFF | |
491 | ||
492 | ||
493 | SET IDENTI TY_INSERT [dbo].[Pre scriptions ] ON | |
494 | ||
495 | INSERT INT O [dbo].[P rescriptio ns] ([Id], [Prescript ionDate],[ DailyDose] ,[Dispense dOn],[Crea ted],[Last Modified] | |
496 | ,[Created By_Id],[Di spensedAt_ Id] ,[Disp ensedBy_Id ] ,[Facili ty_Id],[La stModified By_Id] | |
497 | ,[Medicat ion_Id],[O verrideCod e_Id],[Pre scriber_Id ] ,[Prescr iberOverri deCode_Id] ,[Patient _Id]) | |
498 | VALUE S(1,getdat e(), 34,ge tdate()+50 0, getdate (),getdate (),1,1,1,1 ,1,6,1,1,1 ,1) | |
499 | ||
500 | INSERT INT O [dbo].[P rescriptio ns] ([Id], [Prescript ionDate],[ DailyDose] ,[Dispense dOn],[Crea ted],[Last Modified] | |
501 | ,[Created By_Id],[Di spensedAt_ Id] ,[Disp ensedBy_Id ] ,[Facili ty_Id],[La stModified By_Id] | |
502 | ,[Medicat ion_Id],[O verrideCod e_Id],[Pre scriber_Id ] ,[Prescr iberOverri deCode_Id] ,[Patient _Id]) | |
503 | VALUE S(2,getdat e(), 34,ge tdate()+50 0, getdate (),getdate (),1,2,2,2 ,1,7,2,2,2 ,1) | |
504 | ||
505 | INSERT INT O [dbo].[P rescriptio ns] ([Id], [Prescript ionDate],[ DailyDose] ,[Dispense dOn],[Crea ted],[Last Modified] | |
506 | ,[Created By_Id],[Di spensedAt_ Id] ,[Disp ensedBy_Id ] ,[Facili ty_Id],[La stModified By_Id] | |
507 | ,[Medicat ion_Id],[O verrideCod e_Id],[Pre scriber_Id ] ,[Prescr iberOverri deCode_Id] ,[Patient _Id]) | |
508 | VALUE S(3,getdat e(), 34,ge tdate()+50 0, getdate (),getdate (),1,2,2,2 ,1,8,3,3,3 ,1) | |
509 | ||
510 | INSERT INT O [dbo].[P rescriptio ns] ([Id], [Prescript ionDate],[ DailyDose] ,[Dispense dOn],[Crea ted],[Last Modified] | |
511 | ,[Created By_Id],[Di spensedAt_ Id] ,[Disp ensedBy_Id ] ,[Facili ty_Id],[La stModified By_Id] | |
512 | ,[Medicat ion_Id],[O verrideCod e_Id],[Pre scriber_Id ] ,[Prescr iberOverri deCode_Id] ,[Patient _Id]) | |
513 | VALUE S(4,getdat e(), 34,ge tdate()+50 0, getdate (),getdate (),1,1,1,1 ,1,7,4,4,4 ,1) | |
514 | ||
515 | INSERT INT O [dbo].[P rescriptio ns] ([Id], [Prescript ionDate],[ DailyDose] ,[Dispense dOn],[Crea ted],[Last Modified] | |
516 | ,[Created By_Id],[Di spensedAt_ Id] ,[Disp ensedBy_Id ] ,[Facili ty_Id],[La stModified By_Id] | |
517 | ,[Medicat ion_Id],[O verrideCod e_Id],[Pre scriber_Id ] ,[Prescr iberOverri deCode_Id] ,[Patient _Id]) | |
518 | VALUE S(5,getdat e(), 34,ge tdate()+50 0, getdate (),getdate (),1,1,1,1 ,1,9,3,5,3 ,1) | |
519 | ||
520 | SET ID ENTITY_INS ERT [dbo]. [Prescript ions] OFF | |
521 | ||
522 | --5 test r esults | |
523 | SET IDEN TITY_INSER T [dbo].[T estResults ] ON | |
524 | INSERT INT O [dbo].[T estResults ]([Id],[Co llectionDa te],[Creat ed],[LastM odified],[ CreatedBy_ Id] | |
525 | ,[LastMod ifiedBy_Id ],[Patient _Id],[AncR esult],[Wb cResult] , [Facility_ Id]) | |
526 | VALUE S (1,getd ate(),getd ate(),getd ate(),1,1, 1,500,500, 1) | |
527 | ||
528 | INSERT INT O [dbo].[T estResults ]([Id],[Co llectionDa te],[Creat ed],[LastM odified],[ CreatedBy_ Id] | |
529 | ,[LastMod ifiedBy_Id ],[Patient _Id],[AncR esult],[Wb cResult] , [Facility_ Id]) | |
530 | VALUE S (2,getd ate(),getd ate(),getd ate(),1,1, 2,600,600, 2) | |
531 | ||
532 | INSERT INT O [dbo].[T estResults ]([Id],[Co llectionDa te],[Creat ed],[LastM odified],[ CreatedBy_ Id] | |
533 | ,[LastMod ifiedBy_Id ],[Patient _Id],[AncR esult],[Wb cResult] , [Facility_ Id]) | |
534 | VALUE S (3,getd ate(),getd ate(),getd ate(),1,1, 1,550,600, 2) | |
535 | ||
536 | INSERT INT O [dbo].[T estResults ]([Id],[Co llectionDa te],[Creat ed],[LastM odified],[ CreatedBy_ Id] | |
537 | ,[LastMod ifiedBy_Id ],[Patient _Id],[AncR esult],[Wb cResult] , [Facility_ Id]) | |
538 | VALUE S (4,getd ate(),getd ate(),getd ate(),1,1, 3,550,600, 1) | |
539 | ||
540 | INSERT INT O [dbo].[T estResults ]([Id],[Co llectionDa te],[Creat ed],[LastM odified],[ CreatedBy_ Id] | |
541 | ,[LastMod ifiedBy_Id ],[Patient _Id],[AncR esult],[Wb cResult] , [Facility_ Id]) | |
542 | VALUE S (5,getd ate(),getd ate(),getd ate(),1,1, 1,550,700, 3) | |
543 | SET IDEN TITY_INSER T [dbo].[T estResults ] OFF | |
544 | ||
545 | ||
546 | SET IDENTI TY_INSERT [dbo].[Tre atmentCont inuations] ON | |
547 | INSERT INT O [dbo].[T reatmentCo ntinuation s]([Id],[L ookupName] ,[Descript ion]) | |
548 | VALUE S(1,'Treat mentContin uations na me 1','Tre atmentCont inuations Descriptio n 1') | |
549 | ||
550 | INSERT INT O [dbo].[T reatmentCo ntinuation s]([Id],[L ookupName] ,[Descript ion]) | |
551 | VALUE S(2,'Treat mentContin uations na me 2','Tre atmentCont inuations Descriptio n 2') | |
552 | SET IDENTI TY_INSERT [dbo].[Tre atmentCont inuations] OFF | |
553 | ||
554 | SET IDENTI TY_INSERT [dbo].[Tre atmentRati onales] ON | |
555 | INSERT INT O [dbo].[T reatmentRa tionales]( [Id],[Look upName],[D escription ]) | |
556 | VALUE S (1,'Trea tmentRatio nales name 1','Treatm entRationa les Descri ption 1') | |
557 | ||
558 | INSERT INT O [dbo].[T reatmentRa tionales]( [Id],[Look upName],[D escription ]) | |
559 | VALUE S (2,'Trea tmentRatio nales name 2','Treatm entRationa les Descri ption 2') | |
560 | SET IDENTI TY_INSERT [dbo].[Tre atmentRati onales] OF F | |
561 | ||
562 | ||
563 | -- 6 Applicatio ns (2 In-P rogress, 4 Completed ) | |
564 | ||
565 | SET IDENTI TY_INSERT [dbo].[VaA pplication s] ON | |
566 | declare @P atientName _First nva rchar(50), @PatientNa me_Last nv archar(50) , | |
567 | @PatientN ame_Middle nvarchar( 50), @Pati entSsn nva rchar(10), | |
568 | @PatientR ace nvarch ar(max), @ PatientEth nicity nva rchar(max) , | |
569 | @PatientD ateOfBirth datetime2 (7),@Patie ntZipCode nvarchar(m ax) | |
570 | ||
571 | select @Pa tientName_ First=Pati entName_Fi rst,@Patie ntName_Las t=PatientN ame_Last, | |
572 | @PatientNa me_Middle= PatientNam e_Middle,@ PatientSsn =Ssn,@Pati entRace=Ra ce, | |
573 | @PatientEt hnicity=Et hnicity,@P atientDate OfBirth=Da teOfBirth, @PatientZi pCode=ZipC ode | |
574 | from Patie nts where Id=1 | |
575 | INSERT INT O [dbo].[V aApplicati ons]([Id], [CompleteD ate],[Pati entName_Fi rst],[Pati entName_La st] | |
576 | ,[Patient Name_Middl e] ,[Patie ntSsn],[Pa tientRace] ,[PatientE thnicity] ,[PatientD ateOfBirth ] | |
577 | ,[Patient ZipCode],[ DailyDose] ,[Historic alStartDat e],[Histor icalDurati on],[Histo ricalStopR eason] | |
578 | ,[TestRes ultDate],[ TestResult Wbc],[Test ResultAnc] ,[SpecialC onditionHo spice] | |
579 | ,[Special ConditionC hemotherap y],[Specia lCondition BenignEthn icNeutrope nia] | |
580 | ,[Special ConditionO ther],[Ncc cId],[Crea ted],[Last Modified] | |
581 | ,[Brand_I d],[Clozap ineHistory _Id],[Crea tedBy_Id], [Facility_ Id] | |
582 | ,[Histori calDuratio nUnits_Id] ,[Historic alFacility _Id] ,[Las tModifiedB y_Id] | |
583 | ,[Monitor ingFrequen cy_Id],[Pa tient_Id], [PatientSe x_Id],[Pre scriber_Id ],[Primary Diagnosis_ Id] | |
584 | ,[Selecte dDea_Id],[ DirectorRe viewed]) | |
585 | VALUE S | |
586 | (1,'0001- 01-01 00:0 0:00.00000 00',@Patie ntName_Fir st,@Patien tName_Last ,@PatientN ame_Middle ,@PatientS sn,@Patien tRace, | |
587 | @PatientE thnicity,@ PatientDat eOfBirth,@ PatientZip Code,34,ge tdate()+2, 8,'Complet ed' | |
588 | ,getdate( )+2,500,60 0,1,1,1,nu ll,'RM001' ,getdate() ,getdate( ),1,1,1,1, 1,1,1,1,1, 1,1,1,1,'0 001-01-01 00:00:00.0 000000') | |
589 | ||
590 | select @Pa tientName_ First=Pati entName_Fi rst,@Patie ntName_Las t=PatientN ame_Last, | |
591 | @PatientNa me_Middle= PatientNam e_Middle,@ PatientSsn =Ssn,@Pati entRace=Ra ce, | |
592 | @PatientEt hnicity=Et hnicity,@P atientDate OfBirth=Da teOfBirth, @PatientZi pCode=ZipC ode | |
593 | from Patie nts where Id=2 | |
594 | INSERT INT O [dbo].[V aApplicati ons]([Id], [CompleteD ate],[Pati entName_Fi rst],[Pati entName_La st] | |
595 | ,[Patient Name_Middl e] ,[Patie ntSsn],[Pa tientRace] ,[PatientE thnicity] ,[PatientD ateOfBirth ] | |
596 | ,[Patient ZipCode],[ DailyDose] ,[Historic alStartDat e],[Histor icalDurati on],[Histo ricalStopR eason] | |
597 | ,[TestRes ultDate],[ TestResult Wbc],[Test ResultAnc] ,[SpecialC onditionHo spice] | |
598 | ,[Special ConditionC hemotherap y],[Specia lCondition BenignEthn icNeutrope nia] | |
599 | ,[Special ConditionO ther],[Ncc cId],[Crea ted],[Last Modified] | |
600 | ,[Brand_I d],[Clozap ineHistory _Id],[Crea tedBy_Id], [Facility_ Id] | |
601 | ,[Histori calDuratio nUnits_Id] ,[Historic alFacility _Id] ,[Las tModifiedB y_Id] | |
602 | ,[Monitor ingFrequen cy_Id],[Pa tient_Id], [PatientSe x_Id],[Pre scriber_Id ],[Primary Diagnosis_ Id] | |
603 | ,[Selecte dDea_Id],[ DirectorRe viewed]) | |
604 | VALUE S | |
605 | (2,'0001- 01-01 00:0 0:00.00000 00',@Patie ntName_Fir st,@Patien tName_Last ,@PatientN ame_Middle ,@PatientS sn,@Patien tRace, | |
606 | @PatientE thnicity,@ PatientDat eOfBirth,@ PatientZip Code,34,ge tdate()+2, 8,'Complet ed00' | |
607 | ,getdate( )+2,500,60 0,1,1,1,nu ll,'RM002' ,getdate() ,getdate( ),2,1,1,2, 1,1,1,2,2, 2,2,2,2,'0 001-01-01 00:00:00.0 000000') | |
608 | ||
609 | select @Pa tientName_ First=Pati entName_Fi rst,@Patie ntName_Las t=PatientN ame_Last, | |
610 | @PatientNa me_Middle= PatientNam e_Middle,@ PatientSsn =Ssn,@Pati entRace=Ra ce, | |
611 | @PatientEt hnicity=Et hnicity,@P atientDate OfBirth=Da teOfBirth, @PatientZi pCode=ZipC ode | |
612 | from Patie nts where Id=3 | |
613 | INSERT INT O [dbo].[V aApplicati ons]([Id], [CompleteD ate],[Pati entName_Fi rst],[Pati entName_La st] | |
614 | ,[Patient Name_Middl e] ,[Patie ntSsn],[Pa tientRace] ,[PatientE thnicity] ,[PatientD ateOfBirth ] | |
615 | ,[Patient ZipCode],[ DailyDose] ,[Historic alStartDat e],[Histor icalDurati on],[Histo ricalStopR eason] | |
616 | ,[TestRes ultDate],[ TestResult Wbc],[Test ResultAnc] ,[SpecialC onditionHo spice] | |
617 | ,[Special ConditionC hemotherap y],[Specia lCondition BenignEthn icNeutrope nia] | |
618 | ,[Special ConditionO ther],[Ncc cId],[Crea ted],[Last Modified] | |
619 | ,[Brand_I d],[Clozap ineHistory _Id],[Crea tedBy_Id], [Facility_ Id] | |
620 | ,[Histori calDuratio nUnits_Id] ,[Historic alFacility _Id] ,[Las tModifiedB y_Id] | |
621 | ,[Monitor ingFrequen cy_Id],[Pa tient_Id], [PatientSe x_Id],[Pre scriber_Id ],[Primary Diagnosis_ Id] | |
622 | ,[Selecte dDea_Id],[ DirectorRe viewed],[D irectorRev iewedBy_Id ]) | |
623 | VALUE S | |
624 | (3,getdat e(),@Patie ntName_Fir st,@Patien tName_Last ,@PatientN ame_Middle ,@PatientS sn,@Patien tRace, | |
625 | @PatientE thnicity,@ PatientDat eOfBirth,@ PatientZip Code,34,ge tdate()+2, 8,'Complet ed00' | |
626 | ,getdate( )+2,500,60 0,1,1,1,nu ll,'RM003' ,getdate() ,getdate( ),2,1,1,2, 1,1,1,2,2, 2,2,2,2,ge tdate(),1) | |
627 | ||
628 | ||
629 | select @Pa tientName_ First=Pati entName_Fi rst,@Patie ntName_Las t=PatientN ame_Last, | |
630 | @PatientNa me_Middle= PatientNam e_Middle,@ PatientSsn =Ssn,@Pati entRace=Ra ce, | |
631 | @PatientEt hnicity=Et hnicity,@P atientDate OfBirth=Da teOfBirth, @PatientZi pCode=ZipC ode | |
632 | from Patie nts where Id=1 | |
633 | INSERT INT O [dbo].[V aApplicati ons]([Id], [CompleteD ate],[Pati entName_Fi rst],[Pati entName_La st] | |
634 | ,[Patient Name_Middl e] ,[Patie ntSsn],[Pa tientRace] ,[PatientE thnicity] ,[PatientD ateOfBirth ] | |
635 | ,[Patient ZipCode],[ DailyDose] ,[Historic alStartDat e],[Histor icalDurati on],[Histo ricalStopR eason] | |
636 | ,[TestRes ultDate],[ TestResult Wbc],[Test ResultAnc] ,[SpecialC onditionHo spice] | |
637 | ,[Special ConditionC hemotherap y],[Specia lCondition BenignEthn icNeutrope nia] | |
638 | ,[Special ConditionO ther],[Ncc cId],[Crea ted],[Last Modified] | |
639 | ,[Brand_I d],[Clozap ineHistory _Id],[Crea tedBy_Id], [Facility_ Id] | |
640 | ,[Histori calDuratio nUnits_Id] ,[Historic alFacility _Id] ,[Las tModifiedB y_Id] | |
641 | ,[Monitor ingFrequen cy_Id],[Pa tient_Id], [PatientSe x_Id],[Pre scriber_Id ],[Primary Diagnosis_ Id] | |
642 | ,[Selecte dDea_Id],[ DirectorRe viewed],[D irectorRev iewedBy_Id ]) | |
643 | VALUE S | |
644 | (4,getdat e(),@Patie ntName_Fir st,@Patien tName_Last ,@PatientN ame_Middle ,@PatientS sn,@Patien tRace, | |
645 | @PatientE thnicity,@ PatientDat eOfBirth,@ PatientZip Code,34,ge tdate()+2, 8,'Complet ed00' | |
646 | ,getdate( )+2,500,60 0,1,1,1,nu ll,'RM004' ,getdate() ,getdate( ),2,1,1,2, 1,1,1,2,2, 2,2,2,2,ge tdate(),1) | |
647 | ||
648 | ||
649 | ||
650 | select @Pa tientName_ First=Pati entName_Fi rst,@Patie ntName_Las t=PatientN ame_Last, | |
651 | @PatientNa me_Middle= PatientNam e_Middle,@ PatientSsn =Ssn,@Pati entRace=Ra ce, | |
652 | @PatientEt hnicity=Et hnicity,@P atientDate OfBirth=Da teOfBirth, @PatientZi pCode=ZipC ode | |
653 | from Patie nts where Id=4 | |
654 | INSERT INT O [dbo].[V aApplicati ons]([Id], [CompleteD ate],[Pati entName_Fi rst],[Pati entName_La st] | |
655 | ,[Patient Name_Middl e] ,[Patie ntSsn],[Pa tientRace] ,[PatientE thnicity] ,[PatientD ateOfBirth ] | |
656 | ,[Patient ZipCode],[ DailyDose] ,[Historic alStartDat e],[Histor icalDurati on],[Histo ricalStopR eason] | |
657 | ,[TestRes ultDate],[ TestResult Wbc],[Test ResultAnc] ,[SpecialC onditionHo spice] | |
658 | ,[Special ConditionC hemotherap y],[Specia lCondition BenignEthn icNeutrope nia] | |
659 | ,[Special ConditionO ther],[Ncc cId],[Crea ted],[Last Modified] | |
660 | ,[Brand_I d],[Clozap ineHistory _Id],[Crea tedBy_Id], [Facility_ Id] | |
661 | ,[Histori calDuratio nUnits_Id] ,[Historic alFacility _Id] ,[Las tModifiedB y_Id] | |
662 | ,[Monitor ingFrequen cy_Id],[Pa tient_Id], [PatientSe x_Id],[Pre scriber_Id ],[Primary Diagnosis_ Id] | |
663 | ,[Selecte dDea_Id],[ DirectorRe viewed],[D irectorRev iewedBy_Id ]) | |
664 | VALUE S | |
665 | (5,getdat e(),@Patie ntName_Fir st,@Patien tName_Last ,@PatientN ame_Middle ,@PatientS sn,@Patien tRace, | |
666 | @PatientE thnicity,@ PatientDat eOfBirth,@ PatientZip Code,34,ge tdate()+2, 8,'Complet ed00' | |
667 | ,getdate( )+2,500,60 0,1,1,1,nu ll,'RM005' ,getdate() ,getdate( ),2,1,1,2, 1,1,1,2,2, 2,2,2,2,ge tdate(),1) | |
668 | ||
669 | ||
670 | select @Pa tientName_ First=Pati entName_Fi rst,@Patie ntName_Las t=PatientN ame_Last, | |
671 | @PatientNa me_Middle= PatientNam e_Middle,@ PatientSsn =Ssn,@Pati entRace=Ra ce, | |
672 | @PatientEt hnicity=Et hnicity,@P atientDate OfBirth=Da teOfBirth, @PatientZi pCode=ZipC ode | |
673 | from Patie nts where Id=5 | |
674 | INSERT INT O [dbo].[V aApplicati ons]([Id], [CompleteD ate],[Pati entName_Fi rst],[Pati entName_La st] | |
675 | ,[Patient Name_Middl e] ,[Patie ntSsn],[Pa tientRace] ,[PatientE thnicity] ,[PatientD ateOfBirth ] | |
676 | ,[Patient ZipCode],[ DailyDose] ,[Historic alStartDat e],[Histor icalDurati on],[Histo ricalStopR eason] | |
677 | ,[TestRes ultDate],[ TestResult Wbc],[Test ResultAnc] ,[SpecialC onditionHo spice] | |
678 | ,[Special ConditionC hemotherap y],[Specia lCondition BenignEthn icNeutrope nia] | |
679 | ,[Special ConditionO ther],[Ncc cId],[Crea ted],[Last Modified] | |
680 | ,[Brand_I d],[Clozap ineHistory _Id],[Crea tedBy_Id], [Facility_ Id] | |
681 | ,[Histori calDuratio nUnits_Id] ,[Historic alFacility _Id] ,[Las tModifiedB y_Id] | |
682 | ,[Monitor ingFrequen cy_Id],[Pa tient_Id], [PatientSe x_Id],[Pre scriber_Id ],[Primary Diagnosis_ Id] | |
683 | ,[Selecte dDea_Id],[ DirectorRe viewed],[D irectorRev iewedBy_Id ]) | |
684 | VALUE S | |
685 | (6,getdat e(),@Patie ntName_Fir st,@Patien tName_Last ,@PatientN ame_Middle ,@PatientS sn,@Patien tRace, | |
686 | @PatientE thnicity,@ PatientDat eOfBirth,@ PatientZip Code,34,ge tdate()+2, 8,'Complet ed00' | |
687 | ,getdate( )+2,500,60 0,1,1,1,nu ll,'RM006' ,getdate() ,getdate( ),2,1,1,2, 1,1,1,2,2, 2,2,2,2,ge tdate(),1) | |
688 | ||
689 | SET IDEN TITY_INSER T [dbo].[V aApplicati ons] OFF | |
690 | ||
691 | -- 2 Clozapine Treatments | |
692 | SET IDENTI TY_INSERT [dbo].[Clo zapineTrea tments] ON | |
693 | INSERT INT O [dbo].[C lozapineTr eatments] ([Id],[Dai lyDose],[M onitoringF requencyDa te],[Conti nueTreatme ntUntilDat e] | |
694 | ,[StartDa te],[StopD ate],[Stop Descriptio n],[NcccId ],[Created ],[LastMod ified],[Ap plication_ Id] | |
695 | ,[Created By_Id],[Fa cility_Id] ,[LastModi fiedBy_Id] ,[Monitori ngFrequenc y_Id] ,[Pr escriber_I d] | |
696 | ,[Primary Diagnosis_ Id],[StopC ode_Id],[T reatmentCo ntinuation _Id],[Trea tmentRatio nale_Id] | |
697 | ,[Treatme ntStatus_I d] ,[Patie nt_Id]) | |
698 | VALUE S | |
699 | (1,34,get date(),get date()+10, getdate()+ 5,getdate( )+20,'Comp leted','RM 1000',getd ate(),getd ate(),1,1, 1,1,1,1,1, 2,1,1,1,1) | |
700 | INSERT INT O [dbo].[C lozapineTr eatments] ([Id],[Dai lyDose],[M onitoringF requencyDa te],[Conti nueTreatme ntUntilDat e] | |
701 | ,[StartDa te],[StopD ate],[Stop Descriptio n],[NcccId ],[Created ],[LastMod ified],[Ap plication_ Id] | |
702 | ,[Created By_Id],[Fa cility_Id] ,[LastModi fiedBy_Id] ,[Monitori ngFrequenc y_Id] ,[Pr escriber_I d] | |
703 | ,[Primary Diagnosis_ Id],[StopC ode_Id],[T reatmentCo ntinuation _Id],[Trea tmentRatio nale_Id] | |
704 | ,[Treatme ntStatus_I d] ,[Patie nt_Id]) | |
705 | VALUE S | |
706 | (2,44,get date(),get date()+12, getdate()+ 7,getdate( )+25,'Comp leted','RM 2000',getd ate(),getd ate(),2,1, 2,1,1,1,1, 2,2,2,1,2) | |
707 | ||
708 | SET IDENTI TY_INSERT [dbo].[Clo zapineTrea tments] OF F | |
709 | ||
710 | SET IDENTI TY_INSERT [dbo].[Rel easeNotes] ON | |
711 | ||
712 | INSERT INT O [dbo].[R eleaseNote s] (Id,[De scription] ,[VersionN o] ,[Creat ed],[LastM odified],[ CreatedBy_ Id] ,[Last ModifiedBy _Id] ,[Rel easeNoteNa me] ,[Rele aseDate]) | |
713 | VALUE S (1,'User s with Rea d only acc ess can vi ew overrid e code on prescripti on detail page','1.0 ',getdate( ),getdate( ),1,1,'Pre scription' ,getdate() ) | |
714 | ||
715 | INSERT INT O [dbo].[R eleaseNote s] (Id,[De scription] ,[VersionN o] ,[Creat ed],[LastM odified],[ CreatedBy_ Id] ,[Last ModifiedBy _Id] ,[Rel easeNoteNa me] ,[Rele aseDate]) | |
716 | VALUE S (2,'Phar macy State Location is added t o the phar amacy page ','1.0',ge tdate(),ge tdate(),1, 1,'Prescri ption',get date()) | |
717 | ||
718 | INSERT INT O [dbo].[R eleaseNote s] (Id,[De scription] ,[VersionN o] ,[Creat ed],[LastM odified],[ CreatedBy_ Id] ,[Last ModifiedBy _Id] ,[Rel easeNoteNa me] ,[Rele aseDate]) | |
719 | VALUE S (3,'Fac ility dash board is a vailiable to manage faciliites ' ,'1.0',g etdate(),g etdate(),1 ,1,'Facili ty',getdat e()) | |
720 | ||
721 | SET IDENTI TY_INSERT [dbo].[Rel easeNotes] OFF | |
722 | ||
723 | ||
724 | --SET IDEN TITY_INSER T [dbo].[R egistryUse rs] ON | |
725 | ||
726 | --INSERT I NTO Regist ryUsers (I d,UserName , Registry UserName_F irst, Regi stryUserNa me_Last, C reated, Ac tive, Last Modified, CreatedBy) | |
727 | --VALUES PII ', 'Clozap ine1', 'Us er1', GETD ATE(), 1, '01/01/000 1 00:00:00 .000', 'Sy stem Gener ated') | |
728 | --INSERT I NTO Regist ryUsers (I d,UserName , Registry UserName_F irst, Regi stryUserNa me_Last, C reated, Ac tive, Last Modified, CreatedBy) | |
729 | --VALUES PII ', 'Clozap ine2', 'Us er2', GETD ATE(), 1, '01/01/000 1 00:00:00 .000', 'Sy stem Gener ated') | |
730 | --INSERT I NTO Regist ryUsers (I d,UserName , Registry UserName_F irst, Regi stryUserNa me_Last, C reated, Ac tive, Last Modified, CreatedBy) | |
731 | --VALUES PII ', 'Clozap ine3', 'Us er3', GETD ATE(), 1, '01/01/000 1 00:00:00 .000', 'Sy stem Gener ated') | |
732 | --INSERT I NTO Regist ryUsers (I d,UserName , Registry UserName_F irst, Regi stryUserNa me_Last, C reated, Ac tive, Last Modified, CreatedBy) | |
733 | --VALUES PII ', 'Clozap ine4', 'Us er4', GETD ATE(), 1, '01/01/000 1 00:00:00 .000', 'Sy stem Gener ated') | |
734 | --INSERT I NTO Regist ryUsers (I d,UserName , Registry UserName_F irst, Regi stryUserNa me_Last, C reated, Ac tive, Last Modified, CreatedBy) | |
735 | --VALUES PII ', 'Clozap ine5', 'Us er5', GETD ATE(), 1, '01/01/000 1 00:00:00 .000', 'Sy stem Gener ated') | |
736 | --INSERT I NTO Regist ryUsers (I d,UserName , Registry UserName_F irst, Regi stryUserNa me_Last, C reated, Ac tive, Last Modified, CreatedBy) | |
737 | --VALUES PII ', 'Clozap ine6', 'Us er6', GETD ATE(), 1, '01/01/000 1 00:00:00 .000', 'Sy stem Gener ated') | |
738 | --INSERT I NTO Regist ryUsers (I d,UserName , Registry UserName_F irst, Regi stryUserNa me_Last, C reated, Ac tive, Last Modified, CreatedBy) | |
739 | --VALUES PII ', 'Clozap ine7', 'Us er7', GETD ATE(), 1, '01/01/000 1 00:00:00 .000', 'Sy stem Gener ated') | |
740 | --INSERT I NTO Regist ryUsers (I d,UserName , Registry UserName_F irst, Regi stryUserNa me_Last, C reated, Ac tive, Last Modified, CreatedBy) | |
741 | --VALUES PII ', 'Clozap ine8', 'Us er8', GETD ATE(), 1, '01/01/000 1 00:00:00 .000', 'Sy stem Gener ated') | |
742 | --INSERT I NTO Regist ryUsers (I d,UserName , Registry UserName_F irst, Regi stryUserNa me_Last, C reated, Ac tive, Last Modified, CreatedBy) | |
743 | --VALUES PII ', 'Clozap ine9', 'Us er9', GETD ATE(), 1, '01/01/000 1 00:00:00 .000', 'Sy stem Gener ated') | |
744 | --INSERT I NTO Regist ryUsers (I d,UserName , Registry UserName_F irst, Regi stryUserNa me_Last, C reated, Ac tive, Last Modified, CreatedBy) | |
745 | --VALUES PII ', 'Clozap ine10', 'U ser10', GE TDATE(), 1 , '01/01/0 001 00:00: 00.000', ' System Gen erated') | |
746 | ||
747 | --SET IDEN TITY_INSER T [dbo].[R egistryUse rs] OFF | |
748 | ||
749 | --GO |
Araxis Merge (but not the data content of this report) is Copyright © 1993-2016 Araxis Ltd (www.araxis.com). All rights reserved.