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

Last change on this file since 1408 was 1405, checked in by Sam Habiel, 13 years ago

updated readme; Worksheet of the 4 different drug files
File size: 17.9 KB
Line 
1Documentation for using the Drug File updating utility WITH and WITHOUT KIDS can be found in VWPSSXPD.m.
2
3KIDS file contains this routine plus a sample drug file to be installed into a destination system.
4
5License is AGPL.
6
7Author is Sam Habiel for WorldVistA.
8
9Remarks on Broken Pointers in Destination Systems as a result of using this package:
10Because many files point to the Pharmacy Orderable Item and Drug files, you practically cannot use this package on a database that contains pharmacy data since all data will be corrupted.
11When installing a new drug and pharmacy orderable item file, the following may be broken:
12For Drug File:
13- LAB TEST MONITOR field.
14- SPECIMEN TYPE field.
15- CLOZAPINE LAB TEST:LAB TEST MONITOR field
16- CLOZAPINE LAB TEST:SPECIMEN TYPE field
17- ATC CANISTER:WARD GROUP FOR CANISTER
18- ACTIVITY LOG:INITIATOR OF ACTIVITY (field not used currently)
19- NDC BY OUTPATIENT SITE:OUTPATIENT SITE
20- IFCAP ITEM NUMBER:ITEM NUMBER (field not used currently)
21- Custom UNIT DOSE MED ROUTE (field not used currently)
22
23For Pharmacy Orderable Item File:
24- MEDICATION ROUTES (additions are allowed, not deletions)
25
26The National Drug Files are Standardized. However, a system may be out of date. If you do not have the latest National Drug Files, you have will broken pointers if the source of your drug files has a more recent National Drug File. For best results, the source system and the destination system should have a commensurate NDF patch level.
27
28See detailed analysis below.
29
30 File/Package: PHARM ORD ITEM Date: APR 12,2012
31
32 FILE (#) POINTER (#) FILE
33 POINTER FIELD TYPE POINTER FIELD FILE POINTED TO
34------------------------------------------------------------------------------------------------------------------------------------
35 L=Laygo S=File not in set N=Normal Ref. C=Xref.
36 *=Truncated m=Multiple v=Variable Pointer
37
38 -------------------------------
39 DRUG (#50) | |
40 PHARMACY ORDERABLE ITEM ........................ (N S C L)-> | 50.7 PHARMACY ORDERABLE I* |
41 PRESCRIPTION (#52) | |
42 PHARMACY ORDERABLE ITEM ........................ (N S )-> | DOSAGE FORM |-> DOSAGE FORM (file locked down)
43 PENDING OUTPATIENT O (#52.41) | |
44 PHARMACY ORDERABLE ITEM ........................ (N S )-> | MED ROUTE |-> MEDICATION ROUTES (addable)
45 IV ADDITIVES (#52.6) | |
46 PHARMACY ORDERABLE ITEM ........................ (N S C )-> | m DIVISION/SI:DIVISION/SI* |-> OUTPATIENT SITE (not used)
47 IV SOLUTIONS (#52.7) | |
48 PHARMACY ORDERABLE ITEM ........................ (N S C L)-> | m OI-DRUG TEX:OI-DRUG TEX* |-> DRUG TEXT (used -- included)
49 NON-VERIFIED ORDERS (#53.1) | |
50 ORDERABLE ITEM ................................. (N S )-> | |
51 UNIT DOSE ORDER SET (#53.22) | |
52 ORDERABLE ITEM ................................. (N S )-> | |
53 PICK LIST (#53.52) | |
54 PATIENT:ORDER:ORDERABLE ITEM ................... (N S )-> | |
55 BCMA MEDICATION LOG (#53.79) | |
56 ADMINISTRATION MEDICATION ...................... (N S )-> | |
57 PHARMACY PATIENT (#55.01) | |
58 IV:ORDERABLE ITEM .............................. (N S )-> | |
59 NON-VA MEDS:ORDERABLE ITEM ..................... (N S )-> | |
60 UNIT DOSE:ORDERABLE ITEM ....................... (N S )-> | |
61 -------------------------------
62 File/Package: DRUG Date: APR 12,2012
63
64 FILE (#) POINTER (#) FILE
65 POINTER FIELD TYPE POINTER FIELD FILE POINTED TO
66------------------------------------------------------------------------------------------------------------------------------------
67 L=Laygo S=File not in set N=Normal Ref. C=Xref.
68 *=Truncated m=Multiple v=Variable Pointer
69
70 -------------------------------
71 DRUG (#50) | |
72 CORRESPONDING OUTPATIENT DRUG .................. (N )-> | 50 DRUG |
73 CORRESPONDING INPATIENT DRUG ................... (N )-> | PHARMACY ORDERABLE ITEM |-> PHARMACY ORDERABLE ITEM (inc)
74 FORMULARY ALTERNATIVE .......................... (N C )-> | ORDER UNIT |-> ORDER UNIT (only modifiable
75 from FM, possibly standard)
76 DUE QUESTIONNAIRE (#50.07301) | |
77 DRUG ........................................... (N S C )-> | LAB TEST MONITOR |-> LABORATORY TEST (possible brok pt)
78 DUE ANSWER SHEET (#50.0731) | |
79 DRUG ........................................... (N S C )-> | SPECIMEN TYPE |-> TOPOGRAPHY FIELD (possible break)
80 IV CATEGORY (#50.21) | |
81 IV DRUG:GENERIC DRUG ........................... (N S )-> | NATIONAL DRUG FILE ENTRY |-> VA GENERIC (standard)
82 DRUG COST (#50.9002) | |
83 PHYSICIAN DATA:DRUG ............................ (N S )-> | PSNDF VA PRODUCT NAME EN* |-> VA PRODUCT (standard)
84 DRUG DATA:DRUG ................................. (N S )-> | PACKAGE SIZE |-> PACKAGE SIZE (only mod from FM)
85 (possibly standard)
86 DIVISION DATA:DRUG DATA:DRUG ................... (N S )-> | PACKAGE TYPE |-> PACKAGE TYPE (only mod from FM)
87 (possibly standard)
88 PRESCRIPTION (#52) | |
89 DRUG ........................................... (N S C )-> | NATIONAL DRUG CLASS |-> VA DRUG CLASS (standard)
90 PENDING OUTPATIENT O (#52.41) | |
91 DRUG ........................................... (N S )-> | UNIT DOSE MED ROUTE |-> MEDICATION ROUTES (addable)
92 IV ADDITIVES (#52.6) | |
93 GENERIC DRUG ................................... (N S C )-> | CORRESPONDING OUTPATIENT* |-> DRUG (this file)
94 IV SOLUTIONS (#52.7) | |
95 GENERIC DRUG ................................... (N S C )-> | *PRIMARY DRUG |-> PRIMARY DRUG (not used)
96 NON-VERIFIED ORDERS (#53.1) | |
97 SOLUTION ....................................... (N S )-> | UNIT |-> DRUG UNITS (only mod from FM)
98 (possibly standard)
99 DISPENSE DRUG .................................. (N S )-> | CORRESPONDING INPATIENT * |-> DRUG (this file)
100 UNIT DOSE ORDER SET (#53.2102) | |
101 *DRUG:*DISPENSE DRUG ........................... (N S C )-> | *LAB TEST MONITOR |-> LABORATORY TEST (not used)
102 ORDERABLE ITEM:DISPENSE DRUG ................... (N S )-> | *SPECIMEN TYPE |-> TOPOGRAPHY FIELD (not used)
103 INPATIENT USER PARAM (#53.4502) | |
104 DISPENSE DRUG .................................. (N S C )-> | m CLOZAPINE L:LAB TEST MO* |-> LABORATORY TEST (broken)
105 BCMA MISSING DOSE RE (#53.68) | |
106 DRUG REQUESTED ................................. (N S )-> | CLOZAPINE L:SPECIMEN TY* |-> TOPOGRAPHY FIELD (broken)
107 BCMA UNABLE TO SCAN (#53.771) | |
108 DISPENSE DRUG .................................. (N S C )-> | m ATC CANISTE:WARD GROUP * |-> WARD GROUP (site specific)
109 BCMA MEDICATION VARI (#53.78) | |
110 DRUG SCANNED ................................... (N S )-> | ACTIVITY LO:INITIATOR O* |-> NEW PERSON (not used)
111 BCMA MEDICATION LOG (#53.795) | |
112 DISPENSE DRUG .................................. (N S C )-> | NDC BY OUTP:OUTPATIENT * |-> OUTPATIENT SITE (site specific)
113 PHARMACY PATIENT (#55.05) | |
114 NON-VA MEDS:DISPENSE DRUG ...................... (N S )-> | m DRUG TEXT E:DRUG TEXT E* |-> DRUG TEXT (included)
115 UNIT DOSE:*SOLUTION ............................ (N S )-> | m IFCAP ITEM :ITEM NUMBER* |-> ITEM MASTER (WV empty file)
116 UNIT DOSE:DISPENSE LOG:DISPENSE DRUG ........... (N S )-> | m FORMULARY A:FORMULARY A* |-> DRUG (this file)
117 UNIT DOSE:DISPENSE DRUG ........................ (N S )-> | |
118 UNIT DOSE PICK LIST (#57.63) | |
119 WARD:PROVIDER:DRUG ............................. (N S )-> | |
120 PHARMACY AOU STOCK (#58.11) | |
121 ITEM ........................................... (N S )-> | |
122 PHARMACY BACKORDER (#58.3) | |
123 ITEM ........................................... (N S C )-> | |
124 AR/WS STATS FILE (#58.52) | |
125 INPATIENT SITE:RECALCULATE AMIS:DRUG ........... (N S )-> | |
126 DRUG ACCOUNTABILITY (#58.8001) | |
127 DRUG ........................................... (N S C )-> | |
128 DRUG ACCOUNTABILITY (#58.81) | |
129 DRUG ........................................... (N S )-> | |
130 DRUG ACCOUNTABILITY (#58.81125) | |
131 INVOICE DATA:LINE ITEM DATA:DRUG ............... (N S )-> | |
132 CS WORKSHEET (#58.85) | |
133 DRUG ........................................... (N S )-> | |
134 CS DESTRUCTION (#58.86) | |
135 DRUG ........................................... (N S )-> | |
136 PRICE PER DISPENSE UNIT ........................ (N S )-> | |
137 CS CORRECTION LOG (#58.87) | |
138 DRUG ........................................... (N S )-> | |
139 OUTPATIENT SITE (#59) | |
140 METHADONE DRUG ................................. (N S )-> | |
141 PHARMACY SYSTEM (#59.7) | |
142 LAST DRUG CONVERTED ............................ (N S )-> | |
143 LAST DRUG LINKED ............................... (N S )-> | |
144 RAD/NUC MED PATIENT (#70.15) | |
145 REGISTERE:EXAMINATION:MEDICATIONS:MED ADMINIS* . (N S )-> | |
146 NUC MED EXAM DATA (#70.21) | |
147 RADIOPHARMACEUTICALS:RADIOPHARMACEUTICAL ....... (N S )-> | |
148 RAD/NUC MED PROCEDUR (#71.055) | |
149 DEFAULT MEDICATIONS:DEFAULT MEDICATION ......... (N S C )-> | |
150 DEFAULT RADIOPHARMACEU:DEFAULT RADIOPHARMACEUTI* (N S )-> | |
151 RADIOPHARMACEUTICAL (#71.9) | |
152 RADIOPHARM ..................................... (N S )-> | |
153 ORDER STATISTICS (#100.1) | |
154 NAME v ...........................................(N S C L)-> | |
155 PATIENT ALLERGIES (#120.8) | |
156 GMR ALLERGY v ....................................(N S L)-> | |
157 SURGERY (#130.33) | |
158 MEDICATIONS .................................... (N S )-> | |
159 ANESTHESIA TECHNIQUE:ANESTHESIA AGENTS ......... (N S )-> | |
160 ANESTHESIA TECHNIQUE:TEST DOSE ................. (N S )-> | |
161 FEE BASIS PHARMACY I (#162.11) | |
162 PRESCRIPTION NUMBER:GENERIC DRUG ............... (N S )-> | |
163 TRANSFER PRICING TRA (#351.61) | |
164 DRUG ........................................... (N S )-> | |
165 IB BILL/CLAIMS PRESC (#362.4) | |
166 DRUG ........................................... (N S )-> | |
167 SECLUSION/RESTRAINT (#615.23) | |
168 MEDICATIONS .................................... (N S )-> | |
169 MEDICATION (#695) | |
170 GENERIC NAME ................................... (N S C )-> | |
171 GENERALIZED PROCEDUR (#699.53) | |
172 MEDICATIONS .................................... (N S )-> | |
173 ENDOSCOPY/CONSULT (#699.74) | |
174 PRESCRIPTION GIVEN ............................. (N S )-> | |
175 UNIT DOSE LOCAL EXTR (#727.809) | |
176 BCMA DRUG DISPENSED ............................ (N S )-> | |
177 IV DETAIL EXTRACT (#727.819) | |
178 BCMA DRUG DISPENSED ............................ (N S )-> | |
179 IV EXTRACT DATA (#728.113) | |
180 DRUG ........................................... (N S )-> | |
181 UNIT DOSE EXTRACT DA (#728.904) | |
182 DRUG ........................................... (N S )-> | |
183 ROR REGISTRY PARAMET (#798.129) | |
184 LOCAL DRUG NAME ................................ (N S C )-> | |
185 REMINDER FINDING ITE (#801.43) | |
186 FINDING ITEM v ...................................(N S L)-> | |
187 REMINDER EXTRACT SUM (#810.31) | |
188 EXTRACT FINDINGS:FINDING ITEM v ..................(N S L)-> | |
189 LREPI FINDING TOTALS:FINDING ITEM v ..............(N S L)-> | |
190 REMINDER TERM (#811.52) | |
191 FINDINGS:FINDING ITEM v ..........................(N S L)-> | |
192 REMINDER DEFINITION (#811.902) | |
193 FINDINGS:FINDING ITEM v ..........................(N S C L)-> | |
194 APSP INTERVENTION (#9009032.4) | |
195 DRUG ........................................... (N S )-> | |
196 -------------------------------
197
Note: See TracBrowser for help on using the repository browser.