source: pharmacy-utils/drug-file-cleanup/README.txt@ 1413

Last change on this file since 1413 was 1413, checked in by Sam Habiel, 12 years ago

updated README

File size: 28.4 KB
Line 
1
2 --- KIDS TEXT ----
3Created by Sam Habiel on Thursday 12 April 2011 for WorldVistA.
4
5 --- WARNING ---
6If you install the KIDS build produced by this tool on a production system
7containing pharmacy patient data, you will cause database corruption and
8jeopardize patient safety.
9 --- WARNING ---
10
11This KIDS Build transports the following files from a source system to a
12destination system and then syncs CPRS OE/RR files with the new files.
13 ; ^PSDRUG DRUG
14 ; ^PS(50.7) PHARMACY ORDERABLE ITEM
15 ; ^PS(51.7) DRUG TEXT
16 ; ^PS(52.6) IV ADDITIVES
17 ; ^PS(52.7) IV SOLUTIONS
18 ; ^PS(50.4) DRUG ELECTROLYTES
19
20Workflow (using KIDS):
21 ; On the Origin System:
22 ; - Create a KIDS build that calls the following:
23 ; 1. This Routine Name to call from top is the Environment Check for the
24 ; Build
25 ; 2. PRE is the Pre-Init for the Destination System
26 ; 3. POST is the Post-Init for the Destination System
27 ; 4. TRAN is the Pre-Transport Routine for your originating system drug data
28 ; - Generate the KIDS Build. The file will have all the Drug Data from the
29 ; Origin System.
30 ;
31 ; On the Destination System:
32 ; - Install the KIDS Build
33
34The entry points in the attached routine (VWPSSXPD) can be used by
35themselves to remove an old drug file and add a new one.
36
37Documentation for using the Drug File updating utility WITH and WITHOUT KIDS
38can be found in VWPSSXPD.m.
39
40KIDS file contains this routine plus a sample drug file to be installed
41into a destination system.
42
43 --- END KIDS TEXT ----
44License is AGPL.
45
46Author is Sam Habiel for WorldVistA.
47
48Limitations/Ideas for Future Development:
49- Not sure if the MEDICATION ROUTES should be transmitted or not. While
50 additions are allowed, they are by my experience uncommon.
51- Many reference files (e.g. PACKAGE SIZE or DRUG UNITS) are not part of the
52 NDF, yet they are not user modifiable. Yet, they are referenced almost
53 exclusively from the National Drug Files; which means that they cannot be
54 changed without corrupting the NDF data. I am trying to find documentation
55 to say that they are standard.
56- If the Administration Schedules from the originating system and destination
57 system don't match, you need to either change the schedules on the orderable
58 items, or make the schedules on the destination system the same as the
59 ones from incoming drug file, otherwise, the problems you run into is this:
60 - Orders do not calculate frequency correctly if the schedule is not present
61 in the destination system. This means that the proper number of pills
62 cannot be calculated.
63 - In Outpatient Pharmacy, Schedules do not expand into patient readable
64 instructions
65- If the National Drug Files are not up to date in the destination system,
66 there will be some broken pointers. All you have to do is update the NDF with
67 the latest patches.
68- If some drugs are linked with lab tests, these need to be re-linked.
69 Preferably, these should be removed prior to transporting the drug file.
70
71
72Remarks on Broken Pointers in Destination Systems as a result of using this
73package:
74Because many files point to the Pharmacy Orderable Item and Drug files, you
75practically cannot use this package on a database that contains patient-
76specific pharmacy data since all data will be corrupted.
77
78When installing a new drug and pharmacy orderable item file, the following may
79be broken:
80For Drug File:
81- LAB TEST MONITOR field.
82- SPECIMEN TYPE field.
83- CLOZAPINE LAB TEST:LAB TEST MONITOR field
84- CLOZAPINE LAB TEST:SPECIMEN TYPE field
85- ATC CANISTER:WARD GROUP FOR CANISTER
86- ACTIVITY LOG:INITIATOR OF ACTIVITY (field not used currently)
87- NDC BY OUTPATIENT SITE:OUTPATIENT SITE
88- IFCAP ITEM NUMBER:ITEM NUMBER (field not used currently)
89- Custom UNIT DOSE MED ROUTE (field not used currently)
90- NATIONAL DRUG FILE ENTRY (if you don't have a recently patched NDF)
91- PSNDF VA PRODUCT NAME ENTRY (if you don't have a recently patched NDF).
92
93For Pharmacy Orderable Item File:
94- MEDICATION ROUTES (additions are allowed, not deletions)
95
96The National Drug Files are Standardized. However, a system may be out of date.
97If you do not have the latest National Drug Files, you have will broken
98pointers if the source of your drug files has a more recent National Drug File.
99For best results, the source system and the destination system should have a
100commensurate NDF patch level.
101
102To check for broken pointers, use the VERIFY FIELDs option in Fileman.
103Here is an example of a drug file from a patched system installed on a system
104that is not patched:
105
106==============================================================================
107GTM>D P^DI
108
109
110VA FileMan 22.0
111
112
113Select OPTION: UTILITY FUNCTIONS
114Select UTILITY OPTION: VERIFY FIELDS
115
116MODIFY WHAT FILE: DRUG//
117VERIFY WHICH FIELD: PSNDF VA PRODUCT NAME ENTRY
118
119DEVICE: HOME//
120
121VERIFY FIELDS REPORT
122DRUG FILE (#50) APR 16, 2012 12:40 PAGE 1
123-------------------------------------------------------------------------------
124 POINTER
125(CANNOT CHECK CROSS-REFERENCE)
126
127ENTRY# GENERIC NAME ERROR
128148 GUANFACINE 1MG TAB ER No '21739' in pointed-to File
129149 GUANFACINE 2MG TAB ER No '21740' in pointed-to File
130168 LURASIDONE 40MG TAB No '22028' in pointed-to File
131169 LURASIDONE 80MG TAB No '22030' in pointed-to File
132221 LEVONORGESTREL 1.5MG TAB No '21157' in pointed-to File
133450 LIDOCAINE 5% PATCH No '22004' in pointed-to File
134456 NEOMYCIN/POLYMYXIN/BACITRACIN OINT No '21497' in pointed-to File
135485 MICONAZOLE 4% VAGINAL CREAM No '22325' in pointed-to File
136585 PALIPERIDONE 234MG INJ SUSP PFSNo '21021' in pointed-to File
137586 PALIPERIDONE 156MG INJ SUSP PFSNo '21022' in pointed-to File
138==============================================================================
139
140Below you will find the pointer relations of all the files that are transmitted in this KIDS build.
141
142 File/Package: DRUG Date: APR 12,2012
143
144 FILE (#) POINTER (#) FILE
145 POINTER FIELD TYPE POINTER FIELD FILE POINTED TO
146------------------------------------------------------------------------------------------------------------------------------------
147 L=Laygo S=File not in set N=Normal Ref. C=Xref.
148 *=Truncated m=Multiple v=Variable Pointer
149
150 -------------------------------
151 DRUG (#50) | |
152 CORRESPONDING OUTPATIENT DRUG .................. (N )-> | 50 DRUG |
153 CORRESPONDING INPATIENT DRUG ................... (N )-> | PHARMACY ORDERABLE ITEM |-> PHARMACY ORDERABLE ITEM (inc)
154 FORMULARY ALTERNATIVE .......................... (N C )-> | ORDER UNIT |-> ORDER UNIT (only modifiable
155 from FM, possibly standard)
156 DUE QUESTIONNAIRE (#50.07301) | |
157 DRUG ........................................... (N S C )-> | LAB TEST MONITOR |-> LABORATORY TEST (possible brok pt)
158 DUE ANSWER SHEET (#50.0731) | |
159 DRUG ........................................... (N S C )-> | SPECIMEN TYPE |-> TOPOGRAPHY FIELD (possible break)
160 IV CATEGORY (#50.21) | |
161 IV DRUG:GENERIC DRUG ........................... (N S )-> | NATIONAL DRUG FILE ENTRY |-> VA GENERIC (standard)
162 DRUG COST (#50.9002) | |
163 PHYSICIAN DATA:DRUG ............................ (N S )-> | PSNDF VA PRODUCT NAME EN* |-> VA PRODUCT (standard)
164 DRUG DATA:DRUG ................................. (N S )-> | PACKAGE SIZE |-> PACKAGE SIZE (only mod from FM)
165 (possibly standard)
166 DIVISION DATA:DRUG DATA:DRUG ................... (N S )-> | PACKAGE TYPE |-> PACKAGE TYPE (only mod from FM)
167 (possibly standard)
168 PRESCRIPTION (#52) | |
169 DRUG ........................................... (N S C )-> | NATIONAL DRUG CLASS |-> VA DRUG CLASS (standard)
170 PENDING OUTPATIENT O (#52.41) | |
171 DRUG ........................................... (N S )-> | UNIT DOSE MED ROUTE |-> MEDICATION ROUTES (addable)
172 IV ADDITIVES (#52.6) | |
173 GENERIC DRUG ................................... (N S C )-> | CORRESPONDING OUTPATIENT* |-> DRUG (this file)
174 IV SOLUTIONS (#52.7) | |
175 GENERIC DRUG ................................... (N S C )-> | *PRIMARY DRUG |-> PRIMARY DRUG (not used)
176 NON-VERIFIED ORDERS (#53.1) | |
177 SOLUTION ....................................... (N S )-> | UNIT |-> DRUG UNITS (only mod from FM)
178 (possibly standard)
179 DISPENSE DRUG .................................. (N S )-> | CORRESPONDING INPATIENT * |-> DRUG (this file)
180 UNIT DOSE ORDER SET (#53.2102) | |
181 *DRUG:*DISPENSE DRUG ........................... (N S C )-> | *LAB TEST MONITOR |-> LABORATORY TEST (not used)
182 ORDERABLE ITEM:DISPENSE DRUG ................... (N S )-> | *SPECIMEN TYPE |-> TOPOGRAPHY FIELD (not used)
183 INPATIENT USER PARAM (#53.4502) | |
184 DISPENSE DRUG .................................. (N S C )-> | m CLOZAPINE L:LAB TEST MO* |-> LABORATORY TEST (broken)
185 BCMA MISSING DOSE RE (#53.68) | |
186 DRUG REQUESTED ................................. (N S )-> | CLOZAPINE L:SPECIMEN TY* |-> TOPOGRAPHY FIELD (broken)
187 BCMA UNABLE TO SCAN (#53.771) | |
188 DISPENSE DRUG .................................. (N S C )-> | m ATC CANISTE:WARD GROUP * |-> WARD GROUP (site specific)
189 BCMA MEDICATION VARI (#53.78) | |
190 DRUG SCANNED ................................... (N S )-> | ACTIVITY LO:INITIATOR O* |-> NEW PERSON (not used)
191 BCMA MEDICATION LOG (#53.795) | |
192 DISPENSE DRUG .................................. (N S C )-> | NDC BY OUTP:OUTPATIENT * |-> OUTPATIENT SITE (site specific)
193 PHARMACY PATIENT (#55.05) | |
194 NON-VA MEDS:DISPENSE DRUG ...................... (N S )-> | m DRUG TEXT E:DRUG TEXT E* |-> DRUG TEXT (included)
195 UNIT DOSE:*SOLUTION ............................ (N S )-> | m IFCAP ITEM :ITEM NUMBER* |-> ITEM MASTER (WV empty file)
196 UNIT DOSE:DISPENSE LOG:DISPENSE DRUG ........... (N S )-> | m FORMULARY A:FORMULARY A* |-> DRUG (this file)
197 UNIT DOSE:DISPENSE DRUG ........................ (N S )-> | |
198 UNIT DOSE PICK LIST (#57.63) | |
199 WARD:PROVIDER:DRUG ............................. (N S )-> | |
200 PHARMACY AOU STOCK (#58.11) | |
201 ITEM ........................................... (N S )-> | |
202 PHARMACY BACKORDER (#58.3) | |
203 ITEM ........................................... (N S C )-> | |
204 AR/WS STATS FILE (#58.52) | |
205 INPATIENT SITE:RECALCULATE AMIS:DRUG ........... (N S )-> | |
206 DRUG ACCOUNTABILITY (#58.8001) | |
207 DRUG ........................................... (N S C )-> | |
208 DRUG ACCOUNTABILITY (#58.81) | |
209 DRUG ........................................... (N S )-> | |
210 DRUG ACCOUNTABILITY (#58.81125) | |
211 INVOICE DATA:LINE ITEM DATA:DRUG ............... (N S )-> | |
212 CS WORKSHEET (#58.85) | |
213 DRUG ........................................... (N S )-> | |
214 CS DESTRUCTION (#58.86) | |
215 DRUG ........................................... (N S )-> | |
216 PRICE PER DISPENSE UNIT ........................ (N S )-> | |
217 CS CORRECTION LOG (#58.87) | |
218 DRUG ........................................... (N S )-> | |
219 OUTPATIENT SITE (#59) | |
220 METHADONE DRUG ................................. (N S )-> | |
221 PHARMACY SYSTEM (#59.7) | |
222 LAST DRUG CONVERTED ............................ (N S )-> | |
223 LAST DRUG LINKED ............................... (N S )-> | |
224 RAD/NUC MED PATIENT (#70.15) | |
225 REGISTERE:EXAMINATION:MEDICATIONS:MED ADMINIS* . (N S )-> | |
226 NUC MED EXAM DATA (#70.21) | |
227 RADIOPHARMACEUTICALS:RADIOPHARMACEUTICAL ....... (N S )-> | |
228 RAD/NUC MED PROCEDUR (#71.055) | |
229 DEFAULT MEDICATIONS:DEFAULT MEDICATION ......... (N S C )-> | |
230 DEFAULT RADIOPHARMACEU:DEFAULT RADIOPHARMACEUTI* (N S )-> | |
231 RADIOPHARMACEUTICAL (#71.9) | |
232 RADIOPHARM ..................................... (N S )-> | |
233 ORDER STATISTICS (#100.1) | |
234 NAME v ...........................................(N S C L)-> | |
235 PATIENT ALLERGIES (#120.8) | |
236 GMR ALLERGY v ....................................(N S L)-> | |
237 SURGERY (#130.33) | |
238 MEDICATIONS .................................... (N S )-> | |
239 ANESTHESIA TECHNIQUE:ANESTHESIA AGENTS ......... (N S )-> | |
240 ANESTHESIA TECHNIQUE:TEST DOSE ................. (N S )-> | |
241 FEE BASIS PHARMACY I (#162.11) | |
242 PRESCRIPTION NUMBER:GENERIC DRUG ............... (N S )-> | |
243 TRANSFER PRICING TRA (#351.61) | |
244 DRUG ........................................... (N S )-> | |
245 IB BILL/CLAIMS PRESC (#362.4) | |
246 DRUG ........................................... (N S )-> | |
247 SECLUSION/RESTRAINT (#615.23) | |
248 MEDICATIONS .................................... (N S )-> | |
249 MEDICATION (#695) | |
250 GENERIC NAME ................................... (N S C )-> | |
251 GENERALIZED PROCEDUR (#699.53) | |
252 MEDICATIONS .................................... (N S )-> | |
253 ENDOSCOPY/CONSULT (#699.74) | |
254 PRESCRIPTION GIVEN ............................. (N S )-> | |
255 UNIT DOSE LOCAL EXTR (#727.809) | |
256 BCMA DRUG DISPENSED ............................ (N S )-> | |
257 IV DETAIL EXTRACT (#727.819) | |
258 BCMA DRUG DISPENSED ............................ (N S )-> | |
259 IV EXTRACT DATA (#728.113) | |
260 DRUG ........................................... (N S )-> | |
261 UNIT DOSE EXTRACT DA (#728.904) | |
262 DRUG ........................................... (N S )-> | |
263 ROR REGISTRY PARAMET (#798.129) | |
264 LOCAL DRUG NAME ................................ (N S C )-> | |
265 REMINDER FINDING ITE (#801.43) | |
266 FINDING ITEM v ...................................(N S L)-> | |
267 REMINDER EXTRACT SUM (#810.31) | |
268 EXTRACT FINDINGS:FINDING ITEM v ..................(N S L)-> | |
269 LREPI FINDING TOTALS:FINDING ITEM v ..............(N S L)-> | |
270 REMINDER TERM (#811.52) | |
271 FINDINGS:FINDING ITEM v ..........................(N S L)-> | |
272 REMINDER DEFINITION (#811.902) | |
273 FINDINGS:FINDING ITEM v ..........................(N S C L)-> | |
274 APSP INTERVENTION (#9009032.4) | |
275 DRUG ........................................... (N S )-> | |
276 -------------------------------
277
278 File/Package: PHARM ORD ITEM Date: APR 12,2012
279
280 FILE (#) POINTER (#) FILE
281 POINTER FIELD TYPE POINTER FIELD FILE POINTED TO
282------------------------------------------------------------------------------------------------------------------------------------
283 L=Laygo S=File not in set N=Normal Ref. C=Xref.
284 *=Truncated m=Multiple v=Variable Pointer
285
286 -------------------------------
287 DRUG (#50) | |
288 PHARMACY ORDERABLE ITEM ........................ (N S C L)-> | 50.7 PHARMACY ORDERABLE I* |
289 PRESCRIPTION (#52) | |
290 PHARMACY ORDERABLE ITEM ........................ (N S )-> | DOSAGE FORM |-> DOSAGE FORM (file locked down)
291 PENDING OUTPATIENT O (#52.41) | |
292 PHARMACY ORDERABLE ITEM ........................ (N S )-> | MED ROUTE |-> MEDICATION ROUTES (addable)
293 IV ADDITIVES (#52.6) | |
294 PHARMACY ORDERABLE ITEM ........................ (N S C )-> | m DIVISION/SI:DIVISION/SI* |-> OUTPATIENT SITE (not used)
295 IV SOLUTIONS (#52.7) | |
296 PHARMACY ORDERABLE ITEM ........................ (N S C L)-> | m OI-DRUG TEX:OI-DRUG TEX* |-> DRUG TEXT (used -- included)
297 NON-VERIFIED ORDERS (#53.1) | |
298 ORDERABLE ITEM ................................. (N S )-> | |
299 UNIT DOSE ORDER SET (#53.22) | |
300 ORDERABLE ITEM ................................. (N S )-> | |
301 PICK LIST (#53.52) | |
302 PATIENT:ORDER:ORDERABLE ITEM ................... (N S )-> | |
303 BCMA MEDICATION LOG (#53.79) | |
304 ADMINISTRATION MEDICATION ...................... (N S )-> | |
305 PHARMACY PATIENT (#55.01) | |
306 IV:ORDERABLE ITEM .............................. (N S )-> | |
307 NON-VA MEDS:ORDERABLE ITEM ..................... (N S )-> | |
308 UNIT DOSE:ORDERABLE ITEM ....................... (N S )-> | |
309 -------------------------------
310
311 File/Package: DRUG TEXT Date: APR 16,2012
312
313 FILE (#) POINTER (#) FILE
314 POINTER FIELD TYPE POINTER FIELD FILE POINTED TO
315------------------------------------------------------------------------------------------------------------------------------------
316 L=Laygo S=File not in set N=Normal Ref. C=Xref.
317 *=Truncated m=Multiple v=Variable Pointer
318
319 -------------------------------
320 DRUG (#50.037) | |
321 DRUG TEXT ENTRY ................................ (N S C )-> | 51.7 DRUG TEXT |
322 PHARMACY ORDERABLE I (#50.76) | |
323 OI-DRUG TEXT ENTRY ............................. (N S )-> | |
324 -------------------------------
325
326 File/Package: IV FILES Date: APR 16,2012
327
328 FILE (#) POINTER (#) FILE
329 POINTER FIELD TYPE POINTER FIELD FILE POINTED TO
330------------------------------------------------------------------------------------------------------------------------------------
331 L=Laygo S=File not in set N=Normal Ref. C=Xref.
332 *=Truncated m=Multiple v=Variable Pointer
333
334 -------------------------------
335 IV ADDITIVES (#52.62) | |
336 ELECTROYLTES:ELECTROLYTE ....................... (N )-> | 50.4 DRUG ELECTROLYTES |
337 IV SOLUTIONS (#52.702) | |
338 ELECTROLYTES ................................... (N )-> | |
339 -------------------------------
340 -------------------------------
341 IV CATEGORY (#50.2) | |
342 IV DRUG v ........................................(N S L)-> | 52.6 IV ADDITIVES |
343 IV DRUG v ........................................(N S L)-> | GENERIC DRUG |-> DRUG
344 NON-VERIFIED ORDERS (#53.157) | |
345 ADDITIVE ....................................... (N S C )-> | PHARMACY ORDERABLE ITEM |-> PHARMACY ORDERABLE ITEM
346 BCMA MISSING DOSE RE (#53.686) | |
347 ADDITIVES ...................................... (N S C )-> | *PRIMARY DRUG |-> PRIMARY DRUG
348 BCMA UNABLE TO SCAN (#53.7711) | |
349 ADDITIVE ....................................... (N S C )-> | QUICK CODE:USUAL IV SO* |-> IV SOLUTIONS
350 BCMA MEDICATION LOG (#53.796) | |
351 ADDITIVES ...................................... (N S C )-> | QUICK CODE:MED ROUTE |-> MEDICATION ROUTES
352 PHARMACY PATIENT (#55.02) | |
353 IV:ADDITIVE .................................... (N S )-> | m ELECTROYLTES:ELECTROLYTE |-> DRUG ELECTROLYTES
354 BCMA ID:ADDITIVE ............................... (N S )-> | |
355 PHARMACY QUICK ORDER (#57.17) | |
356 ADDITIVE ....................................... (N S )-> | |
357 -------------------------------
358 -------------------------------
359 IV CATEGORY (#50.2) | |
360 IV DRUG v ........................................(N S L)-> | 52.7 IV SOLUTIONS |
361 IV DRUG v ........................................(N S L)-> | GENERIC DRUG |-> DRUG
362 IV ADDITIVES (#52.61) | |
363 QUICK CODE:USUAL IV SOLUTION ................... (N )-> | PHARMACY ORDERABLE ITEM |-> PHARMACY ORDERABLE ITEM
364 NON-VERIFIED ORDERS (#53.158) | |
365 SOLUTION ....................................... (N S C )-> | *PRIMARY DRUG |-> PRIMARY DRUG
366 BCMA MISSING DOSE RE (#53.687) | |
367 SOLUTIONS ...................................... (N S C )-> | m ELECTROLYTES:ELECTROLYTES |-> DRUG ELECTROLYTES
368 BCMA UNABLE TO SCAN (#53.7712) | |
369 SOLUTIONS ...................................... (N S C )-> | |
370 BCMA MEDICATION LOG (#53.797) | |
371 SOLUTIONS ...................................... (N S C )-> | |
372 PHARMACY PATIENT (#55.1058) | |
373 BCMA ID:SOLUTION ............................... (N S )-> | |
374 IV:SOLUTION .................................... (N S )-> | |
375 PHARMACY QUICK ORDER (#57.18) | |
376 SOLUTION ....................................... (N S )-> | |
377 -------------------------------
378
Note: See TracBrowser for help on using the repository browser.