| 1 |
|
|---|
| 2 | --- KIDS TEXT ----
|
|---|
| 3 | Created by Sam Habiel on Thursday 12 April 2011 for WorldVistA.
|
|---|
| 4 |
|
|---|
| 5 | --- WARNING ---
|
|---|
| 6 | If you install the KIDS build produced by this tool on a production system
|
|---|
| 7 | containing pharmacy patient data, you will cause database corruption and
|
|---|
| 8 | jeopardize patient safety.
|
|---|
| 9 | --- WARNING ---
|
|---|
| 10 |
|
|---|
| 11 | This KIDS Build transports the following files from a source system to a
|
|---|
| 12 | destination 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 |
|
|---|
| 20 | Workflow (using KIDS):
|
|---|
| 21 | ; On the Origin System:
|
|---|
| 22 | ; - Create a KIDS build that calls the follwing:
|
|---|
| 23 | ; 1. This Routine Name to call from top is the Environment Check for the Build
|
|---|
| 24 | ; 2. TRAN is the Pre-Transport Routine for your originating system drug data
|
|---|
| 25 | ; 3. PRE is the Pre-Init for the Destination System
|
|---|
| 26 | ; 4. POST is the Post-Init for the Destination System
|
|---|
| 27 | ; - Generate the KIDS Build. The file will have all the Drug Data from the
|
|---|
| 28 | ; Origin System.
|
|---|
| 29 | ; On the Destination System:
|
|---|
| 30 | ; - Install the KIDS Build
|
|---|
| 31 |
|
|---|
| 32 | The entry points in the attached routine (VWPSSXPD) can be used by
|
|---|
| 33 | themselves to remove an old drug file and add a new one.
|
|---|
| 34 |
|
|---|
| 35 | Documentation for using the Drug File updating utility WITH and WITHOUT KIDS
|
|---|
| 36 | can be found in VWPSSXPD.m.
|
|---|
| 37 |
|
|---|
| 38 | KIDS file contains this routine plus a sample drug file to be installed
|
|---|
| 39 | into a destination system.
|
|---|
| 40 |
|
|---|
| 41 | --- KIDS TEXT ----
|
|---|
| 42 | License is AGPL.
|
|---|
| 43 |
|
|---|
| 44 | Author is Sam Habiel for WorldVistA.
|
|---|
| 45 |
|
|---|
| 46 | Limitations/Ideas for Future Development:
|
|---|
| 47 | - Not sure if the MEDICATION ROUTES should be transmitted or not. While additions are allowed, they are by my experience uncommon.
|
|---|
| 48 | - Many reference files (e.g. PACKAGE SIZE or DRUG UNITS) are not part of the NDF, yet they are not user modifiable. Yet, they are referenced almost exclusively from the National Drug Files; which means that they cannot be changed without corrupting the NDF data. I am trying to find documentation to say that they are standard.
|
|---|
| 49 |
|
|---|
| 50 | Remarks on Broken Pointers in Destination Systems as a result of using this package:
|
|---|
| 51 | Because 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.
|
|---|
| 52 | When installing a new drug and pharmacy orderable item file, the following may be broken:
|
|---|
| 53 | For Drug File:
|
|---|
| 54 | - LAB TEST MONITOR field.
|
|---|
| 55 | - SPECIMEN TYPE field.
|
|---|
| 56 | - CLOZAPINE LAB TEST:LAB TEST MONITOR field
|
|---|
| 57 | - CLOZAPINE LAB TEST:SPECIMEN TYPE field
|
|---|
| 58 | - ATC CANISTER:WARD GROUP FOR CANISTER
|
|---|
| 59 | - ACTIVITY LOG:INITIATOR OF ACTIVITY (field not used currently)
|
|---|
| 60 | - NDC BY OUTPATIENT SITE:OUTPATIENT SITE
|
|---|
| 61 | - IFCAP ITEM NUMBER:ITEM NUMBER (field not used currently)
|
|---|
| 62 | - Custom UNIT DOSE MED ROUTE (field not used currently)
|
|---|
| 63 | - NATIONAL DRUG FILE ENTRY (if you don't have a recently patched NDF)
|
|---|
| 64 | - PSNDF VA PRODUCT NAME ENTRY (if you don't have a recently patched NDF).
|
|---|
| 65 |
|
|---|
| 66 | For Pharmacy Orderable Item File:
|
|---|
| 67 | - MEDICATION ROUTES (additions are allowed, not deletions)
|
|---|
| 68 |
|
|---|
| 69 | The 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.
|
|---|
| 70 |
|
|---|
| 71 | To check for broken pointer, use the VERIFY FIELDs option in Fileman.
|
|---|
| 72 | Here is an example of a drug file from a patched system installed on a system
|
|---|
| 73 | that is not patched:
|
|---|
| 74 |
|
|---|
| 75 | ==============================================================================
|
|---|
| 76 | GTM>D P^DI
|
|---|
| 77 |
|
|---|
| 78 |
|
|---|
| 79 | VA FileMan 22.0
|
|---|
| 80 |
|
|---|
| 81 |
|
|---|
| 82 | Select OPTION: UTILITY FUNCTIONS
|
|---|
| 83 | Select UTILITY OPTION: VERIFY FIELDS
|
|---|
| 84 |
|
|---|
| 85 | MODIFY WHAT FILE: DRUG//
|
|---|
| 86 | VERIFY WHICH FIELD: PSNDF VA PRODUCT NAME ENTRY
|
|---|
| 87 |
|
|---|
| 88 | DEVICE: HOME//
|
|---|
| 89 |
|
|---|
| 90 | VERIFY FIELDS REPORT
|
|---|
| 91 | DRUG FILE (#50) APR 16, 2012 12:40 PAGE 1
|
|---|
| 92 | -------------------------------------------------------------------------------
|
|---|
| 93 | POINTER
|
|---|
| 94 | (CANNOT CHECK CROSS-REFERENCE)
|
|---|
| 95 |
|
|---|
| 96 | ENTRY# GENERIC NAME ERROR
|
|---|
| 97 | 148 GUANFACINE 1MG TAB ER No '21739' in pointed-to File
|
|---|
| 98 | 149 GUANFACINE 2MG TAB ER No '21740' in pointed-to File
|
|---|
| 99 | 168 LURASIDONE 40MG TAB No '22028' in pointed-to File
|
|---|
| 100 | 169 LURASIDONE 80MG TAB No '22030' in pointed-to File
|
|---|
| 101 | 221 LEVONORGESTREL 1.5MG TAB No '21157' in pointed-to File
|
|---|
| 102 | 450 LIDOCAINE 5% PATCH No '22004' in pointed-to File
|
|---|
| 103 | 456 NEOMYCIN/POLYMYXIN/BACITRACIN OINT No '21497' in pointed-to File
|
|---|
| 104 | 485 MICONAZOLE 4% VAGINAL CREAM No '22325' in pointed-to File
|
|---|
| 105 | 585 PALIPERIDONE 234MG INJ SUSP PFSNo '21021' in pointed-to File
|
|---|
| 106 | 586 PALIPERIDONE 156MG INJ SUSP PFSNo '21022' in pointed-to File
|
|---|
| 107 | ==============================================================================
|
|---|
| 108 |
|
|---|
| 109 | See detailed analysis below.
|
|---|
| 110 |
|
|---|
| 111 | File/Package: PHARM ORD ITEM Date: APR 12,2012
|
|---|
| 112 |
|
|---|
| 113 | FILE (#) POINTER (#) FILE
|
|---|
| 114 | POINTER FIELD TYPE POINTER FIELD FILE POINTED TO
|
|---|
| 115 | ------------------------------------------------------------------------------------------------------------------------------------
|
|---|
| 116 | L=Laygo S=File not in set N=Normal Ref. C=Xref.
|
|---|
| 117 | *=Truncated m=Multiple v=Variable Pointer
|
|---|
| 118 |
|
|---|
| 119 | -------------------------------
|
|---|
| 120 | DRUG (#50) | |
|
|---|
| 121 | PHARMACY ORDERABLE ITEM ........................ (N S C L)-> | 50.7 PHARMACY ORDERABLE I* |
|
|---|
| 122 | PRESCRIPTION (#52) | |
|
|---|
| 123 | PHARMACY ORDERABLE ITEM ........................ (N S )-> | DOSAGE FORM |-> DOSAGE FORM (file locked down)
|
|---|
| 124 | PENDING OUTPATIENT O (#52.41) | |
|
|---|
| 125 | PHARMACY ORDERABLE ITEM ........................ (N S )-> | MED ROUTE |-> MEDICATION ROUTES (addable)
|
|---|
| 126 | IV ADDITIVES (#52.6) | |
|
|---|
| 127 | PHARMACY ORDERABLE ITEM ........................ (N S C )-> | m DIVISION/SI:DIVISION/SI* |-> OUTPATIENT SITE (not used)
|
|---|
| 128 | IV SOLUTIONS (#52.7) | |
|
|---|
| 129 | PHARMACY ORDERABLE ITEM ........................ (N S C L)-> | m OI-DRUG TEX:OI-DRUG TEX* |-> DRUG TEXT (used -- included)
|
|---|
| 130 | NON-VERIFIED ORDERS (#53.1) | |
|
|---|
| 131 | ORDERABLE ITEM ................................. (N S )-> | |
|
|---|
| 132 | UNIT DOSE ORDER SET (#53.22) | |
|
|---|
| 133 | ORDERABLE ITEM ................................. (N S )-> | |
|
|---|
| 134 | PICK LIST (#53.52) | |
|
|---|
| 135 | PATIENT:ORDER:ORDERABLE ITEM ................... (N S )-> | |
|
|---|
| 136 | BCMA MEDICATION LOG (#53.79) | |
|
|---|
| 137 | ADMINISTRATION MEDICATION ...................... (N S )-> | |
|
|---|
| 138 | PHARMACY PATIENT (#55.01) | |
|
|---|
| 139 | IV:ORDERABLE ITEM .............................. (N S )-> | |
|
|---|
| 140 | NON-VA MEDS:ORDERABLE ITEM ..................... (N S )-> | |
|
|---|
| 141 | UNIT DOSE:ORDERABLE ITEM ....................... (N S )-> | |
|
|---|
| 142 | -------------------------------
|
|---|
| 143 | File/Package: DRUG Date: APR 12,2012
|
|---|
| 144 |
|
|---|
| 145 | FILE (#) POINTER (#) FILE
|
|---|
| 146 | POINTER FIELD TYPE POINTER FIELD FILE POINTED TO
|
|---|
| 147 | ------------------------------------------------------------------------------------------------------------------------------------
|
|---|
| 148 | L=Laygo S=File not in set N=Normal Ref. C=Xref.
|
|---|
| 149 | *=Truncated m=Multiple v=Variable Pointer
|
|---|
| 150 |
|
|---|
| 151 | -------------------------------
|
|---|
| 152 | DRUG (#50) | |
|
|---|
| 153 | CORRESPONDING OUTPATIENT DRUG .................. (N )-> | 50 DRUG |
|
|---|
| 154 | CORRESPONDING INPATIENT DRUG ................... (N )-> | PHARMACY ORDERABLE ITEM |-> PHARMACY ORDERABLE ITEM (inc)
|
|---|
| 155 | FORMULARY ALTERNATIVE .......................... (N C )-> | ORDER UNIT |-> ORDER UNIT (only modifiable
|
|---|
| 156 | from FM, possibly standard)
|
|---|
| 157 | DUE QUESTIONNAIRE (#50.07301) | |
|
|---|
| 158 | DRUG ........................................... (N S C )-> | LAB TEST MONITOR |-> LABORATORY TEST (possible brok pt)
|
|---|
| 159 | DUE ANSWER SHEET (#50.0731) | |
|
|---|
| 160 | DRUG ........................................... (N S C )-> | SPECIMEN TYPE |-> TOPOGRAPHY FIELD (possible break)
|
|---|
| 161 | IV CATEGORY (#50.21) | |
|
|---|
| 162 | IV DRUG:GENERIC DRUG ........................... (N S )-> | NATIONAL DRUG FILE ENTRY |-> VA GENERIC (standard)
|
|---|
| 163 | DRUG COST (#50.9002) | |
|
|---|
| 164 | PHYSICIAN DATA:DRUG ............................ (N S )-> | PSNDF VA PRODUCT NAME EN* |-> VA PRODUCT (standard)
|
|---|
| 165 | DRUG DATA:DRUG ................................. (N S )-> | PACKAGE SIZE |-> PACKAGE SIZE (only mod from FM)
|
|---|
| 166 | (possibly standard)
|
|---|
| 167 | DIVISION DATA:DRUG DATA:DRUG ................... (N S )-> | PACKAGE TYPE |-> PACKAGE TYPE (only mod from FM)
|
|---|
| 168 | (possibly standard)
|
|---|
| 169 | PRESCRIPTION (#52) | |
|
|---|
| 170 | DRUG ........................................... (N S C )-> | NATIONAL DRUG CLASS |-> VA DRUG CLASS (standard)
|
|---|
| 171 | PENDING OUTPATIENT O (#52.41) | |
|
|---|
| 172 | DRUG ........................................... (N S )-> | UNIT DOSE MED ROUTE |-> MEDICATION ROUTES (addable)
|
|---|
| 173 | IV ADDITIVES (#52.6) | |
|
|---|
| 174 | GENERIC DRUG ................................... (N S C )-> | CORRESPONDING OUTPATIENT* |-> DRUG (this file)
|
|---|
| 175 | IV SOLUTIONS (#52.7) | |
|
|---|
| 176 | GENERIC DRUG ................................... (N S C )-> | *PRIMARY DRUG |-> PRIMARY DRUG (not used)
|
|---|
| 177 | NON-VERIFIED ORDERS (#53.1) | |
|
|---|
| 178 | SOLUTION ....................................... (N S )-> | UNIT |-> DRUG UNITS (only mod from FM)
|
|---|
| 179 | (possibly standard)
|
|---|
| 180 | DISPENSE DRUG .................................. (N S )-> | CORRESPONDING INPATIENT * |-> DRUG (this file)
|
|---|
| 181 | UNIT DOSE ORDER SET (#53.2102) | |
|
|---|
| 182 | *DRUG:*DISPENSE DRUG ........................... (N S C )-> | *LAB TEST MONITOR |-> LABORATORY TEST (not used)
|
|---|
| 183 | ORDERABLE ITEM:DISPENSE DRUG ................... (N S )-> | *SPECIMEN TYPE |-> TOPOGRAPHY FIELD (not used)
|
|---|
| 184 | INPATIENT USER PARAM (#53.4502) | |
|
|---|
| 185 | DISPENSE DRUG .................................. (N S C )-> | m CLOZAPINE L:LAB TEST MO* |-> LABORATORY TEST (broken)
|
|---|
| 186 | BCMA MISSING DOSE RE (#53.68) | |
|
|---|
| 187 | DRUG REQUESTED ................................. (N S )-> | CLOZAPINE L:SPECIMEN TY* |-> TOPOGRAPHY FIELD (broken)
|
|---|
| 188 | BCMA UNABLE TO SCAN (#53.771) | |
|
|---|
| 189 | DISPENSE DRUG .................................. (N S C )-> | m ATC CANISTE:WARD GROUP * |-> WARD GROUP (site specific)
|
|---|
| 190 | BCMA MEDICATION VARI (#53.78) | |
|
|---|
| 191 | DRUG SCANNED ................................... (N S )-> | ACTIVITY LO:INITIATOR O* |-> NEW PERSON (not used)
|
|---|
| 192 | BCMA MEDICATION LOG (#53.795) | |
|
|---|
| 193 | DISPENSE DRUG .................................. (N S C )-> | NDC BY OUTP:OUTPATIENT * |-> OUTPATIENT SITE (site specific)
|
|---|
| 194 | PHARMACY PATIENT (#55.05) | |
|
|---|
| 195 | NON-VA MEDS:DISPENSE DRUG ...................... (N S )-> | m DRUG TEXT E:DRUG TEXT E* |-> DRUG TEXT (included)
|
|---|
| 196 | UNIT DOSE:*SOLUTION ............................ (N S )-> | m IFCAP ITEM :ITEM NUMBER* |-> ITEM MASTER (WV empty file)
|
|---|
| 197 | UNIT DOSE:DISPENSE LOG:DISPENSE DRUG ........... (N S )-> | m FORMULARY A:FORMULARY A* |-> DRUG (this file)
|
|---|
| 198 | UNIT DOSE:DISPENSE DRUG ........................ (N S )-> | |
|
|---|
| 199 | UNIT DOSE PICK LIST (#57.63) | |
|
|---|
| 200 | WARD:PROVIDER:DRUG ............................. (N S )-> | |
|
|---|
| 201 | PHARMACY AOU STOCK (#58.11) | |
|
|---|
| 202 | ITEM ........................................... (N S )-> | |
|
|---|
| 203 | PHARMACY BACKORDER (#58.3) | |
|
|---|
| 204 | ITEM ........................................... (N S C )-> | |
|
|---|
| 205 | AR/WS STATS FILE (#58.52) | |
|
|---|
| 206 | INPATIENT SITE:RECALCULATE AMIS:DRUG ........... (N S )-> | |
|
|---|
| 207 | DRUG ACCOUNTABILITY (#58.8001) | |
|
|---|
| 208 | DRUG ........................................... (N S C )-> | |
|
|---|
| 209 | DRUG ACCOUNTABILITY (#58.81) | |
|
|---|
| 210 | DRUG ........................................... (N S )-> | |
|
|---|
| 211 | DRUG ACCOUNTABILITY (#58.81125) | |
|
|---|
| 212 | INVOICE DATA:LINE ITEM DATA:DRUG ............... (N S )-> | |
|
|---|
| 213 | CS WORKSHEET (#58.85) | |
|
|---|
| 214 | DRUG ........................................... (N S )-> | |
|
|---|
| 215 | CS DESTRUCTION (#58.86) | |
|
|---|
| 216 | DRUG ........................................... (N S )-> | |
|
|---|
| 217 | PRICE PER DISPENSE UNIT ........................ (N S )-> | |
|
|---|
| 218 | CS CORRECTION LOG (#58.87) | |
|
|---|
| 219 | DRUG ........................................... (N S )-> | |
|
|---|
| 220 | OUTPATIENT SITE (#59) | |
|
|---|
| 221 | METHADONE DRUG ................................. (N S )-> | |
|
|---|
| 222 | PHARMACY SYSTEM (#59.7) | |
|
|---|
| 223 | LAST DRUG CONVERTED ............................ (N S )-> | |
|
|---|
| 224 | LAST DRUG LINKED ............................... (N S )-> | |
|
|---|
| 225 | RAD/NUC MED PATIENT (#70.15) | |
|
|---|
| 226 | REGISTERE:EXAMINATION:MEDICATIONS:MED ADMINIS* . (N S )-> | |
|
|---|
| 227 | NUC MED EXAM DATA (#70.21) | |
|
|---|
| 228 | RADIOPHARMACEUTICALS:RADIOPHARMACEUTICAL ....... (N S )-> | |
|
|---|
| 229 | RAD/NUC MED PROCEDUR (#71.055) | |
|
|---|
| 230 | DEFAULT MEDICATIONS:DEFAULT MEDICATION ......... (N S C )-> | |
|
|---|
| 231 | DEFAULT RADIOPHARMACEU:DEFAULT RADIOPHARMACEUTI* (N S )-> | |
|
|---|
| 232 | RADIOPHARMACEUTICAL (#71.9) | |
|
|---|
| 233 | RADIOPHARM ..................................... (N S )-> | |
|
|---|
| 234 | ORDER STATISTICS (#100.1) | |
|
|---|
| 235 | NAME v ...........................................(N S C L)-> | |
|
|---|
| 236 | PATIENT ALLERGIES (#120.8) | |
|
|---|
| 237 | GMR ALLERGY v ....................................(N S L)-> | |
|
|---|
| 238 | SURGERY (#130.33) | |
|
|---|
| 239 | MEDICATIONS .................................... (N S )-> | |
|
|---|
| 240 | ANESTHESIA TECHNIQUE:ANESTHESIA AGENTS ......... (N S )-> | |
|
|---|
| 241 | ANESTHESIA TECHNIQUE:TEST DOSE ................. (N S )-> | |
|
|---|
| 242 | FEE BASIS PHARMACY I (#162.11) | |
|
|---|
| 243 | PRESCRIPTION NUMBER:GENERIC DRUG ............... (N S )-> | |
|
|---|
| 244 | TRANSFER PRICING TRA (#351.61) | |
|
|---|
| 245 | DRUG ........................................... (N S )-> | |
|
|---|
| 246 | IB BILL/CLAIMS PRESC (#362.4) | |
|
|---|
| 247 | DRUG ........................................... (N S )-> | |
|
|---|
| 248 | SECLUSION/RESTRAINT (#615.23) | |
|
|---|
| 249 | MEDICATIONS .................................... (N S )-> | |
|
|---|
| 250 | MEDICATION (#695) | |
|
|---|
| 251 | GENERIC NAME ................................... (N S C )-> | |
|
|---|
| 252 | GENERALIZED PROCEDUR (#699.53) | |
|
|---|
| 253 | MEDICATIONS .................................... (N S )-> | |
|
|---|
| 254 | ENDOSCOPY/CONSULT (#699.74) | |
|
|---|
| 255 | PRESCRIPTION GIVEN ............................. (N S )-> | |
|
|---|
| 256 | UNIT DOSE LOCAL EXTR (#727.809) | |
|
|---|
| 257 | BCMA DRUG DISPENSED ............................ (N S )-> | |
|
|---|
| 258 | IV DETAIL EXTRACT (#727.819) | |
|
|---|
| 259 | BCMA DRUG DISPENSED ............................ (N S )-> | |
|
|---|
| 260 | IV EXTRACT DATA (#728.113) | |
|
|---|
| 261 | DRUG ........................................... (N S )-> | |
|
|---|
| 262 | UNIT DOSE EXTRACT DA (#728.904) | |
|
|---|
| 263 | DRUG ........................................... (N S )-> | |
|
|---|
| 264 | ROR REGISTRY PARAMET (#798.129) | |
|
|---|
| 265 | LOCAL DRUG NAME ................................ (N S C )-> | |
|
|---|
| 266 | REMINDER FINDING ITE (#801.43) | |
|
|---|
| 267 | FINDING ITEM v ...................................(N S L)-> | |
|
|---|
| 268 | REMINDER EXTRACT SUM (#810.31) | |
|
|---|
| 269 | EXTRACT FINDINGS:FINDING ITEM v ..................(N S L)-> | |
|
|---|
| 270 | LREPI FINDING TOTALS:FINDING ITEM v ..............(N S L)-> | |
|
|---|
| 271 | REMINDER TERM (#811.52) | |
|
|---|
| 272 | FINDINGS:FINDING ITEM v ..........................(N S L)-> | |
|
|---|
| 273 | REMINDER DEFINITION (#811.902) | |
|
|---|
| 274 | FINDINGS:FINDING ITEM v ..........................(N S C L)-> | |
|
|---|
| 275 | APSP INTERVENTION (#9009032.4) | |
|
|---|
| 276 | DRUG ........................................... (N S )-> | |
|
|---|
| 277 | -------------------------------
|
|---|
| 278 |
|
|---|
