Documentation for using the Drug File updating utility WITH and WITHOUT KIDS can be found in VWPSSXPD.m. KIDS file contains this routine plus a sample drug file to be installed into a destination system. License is AGPL. Author is Sam Habiel for WorldVistA. Remarks on Broken Pointers in Destination Systems as a result of using this package: 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. When installing a new drug and pharmacy orderable item file, the following may be broken: For Drug File: - LAB TEST MONITOR field. - SPECIMEN TYPE field. - CLOZAPINE LAB TEST:LAB TEST MONITOR field - CLOZAPINE LAB TEST:SPECIMEN TYPE field - ATC CANISTER:WARD GROUP FOR CANISTER - ACTIVITY LOG:INITIATOR OF ACTIVITY (field not used currently) - NDC BY OUTPATIENT SITE:OUTPATIENT SITE - IFCAP ITEM NUMBER:ITEM NUMBER (field not used currently) - Custom UNIT DOSE MED ROUTE (field not used currently) For Pharmacy Orderable Item File: - MEDICATION ROUTES (additions are allowed, not deletions) 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. See detailed analysis below. File/Package: PHARM ORD ITEM Date: APR 12,2012 FILE (#) POINTER (#) FILE POINTER FIELD TYPE POINTER FIELD FILE POINTED TO ------------------------------------------------------------------------------------------------------------------------------------ L=Laygo S=File not in set N=Normal Ref. C=Xref. *=Truncated m=Multiple v=Variable Pointer ------------------------------- DRUG (#50) | | PHARMACY ORDERABLE ITEM ........................ (N S C L)-> | 50.7 PHARMACY ORDERABLE I* | PRESCRIPTION (#52) | | PHARMACY ORDERABLE ITEM ........................ (N S )-> | DOSAGE FORM |-> DOSAGE FORM (file locked down) PENDING OUTPATIENT O (#52.41) | | PHARMACY ORDERABLE ITEM ........................ (N S )-> | MED ROUTE |-> MEDICATION ROUTES (addable) IV ADDITIVES (#52.6) | | PHARMACY ORDERABLE ITEM ........................ (N S C )-> | m DIVISION/SI:DIVISION/SI* |-> OUTPATIENT SITE (not used) IV SOLUTIONS (#52.7) | | PHARMACY ORDERABLE ITEM ........................ (N S C L)-> | m OI-DRUG TEX:OI-DRUG TEX* |-> DRUG TEXT (used -- included) NON-VERIFIED ORDERS (#53.1) | | ORDERABLE ITEM ................................. (N S )-> | | UNIT DOSE ORDER SET (#53.22) | | ORDERABLE ITEM ................................. (N S )-> | | PICK LIST (#53.52) | | PATIENT:ORDER:ORDERABLE ITEM ................... (N S )-> | | BCMA MEDICATION LOG (#53.79) | | ADMINISTRATION MEDICATION ...................... (N S )-> | | PHARMACY PATIENT (#55.01) | | IV:ORDERABLE ITEM .............................. (N S )-> | | NON-VA MEDS:ORDERABLE ITEM ..................... (N S )-> | | UNIT DOSE:ORDERABLE ITEM ....................... (N S )-> | | ------------------------------- File/Package: DRUG Date: APR 12,2012 FILE (#) POINTER (#) FILE POINTER FIELD TYPE POINTER FIELD FILE POINTED TO ------------------------------------------------------------------------------------------------------------------------------------ L=Laygo S=File not in set N=Normal Ref. C=Xref. *=Truncated m=Multiple v=Variable Pointer ------------------------------- DRUG (#50) | | CORRESPONDING OUTPATIENT DRUG .................. (N )-> | 50 DRUG | CORRESPONDING INPATIENT DRUG ................... (N )-> | PHARMACY ORDERABLE ITEM |-> PHARMACY ORDERABLE ITEM (inc) FORMULARY ALTERNATIVE .......................... (N C )-> | ORDER UNIT |-> ORDER UNIT (only modifiable from FM, possibly standard) DUE QUESTIONNAIRE (#50.07301) | | DRUG ........................................... (N S C )-> | LAB TEST MONITOR |-> LABORATORY TEST (possible brok pt) DUE ANSWER SHEET (#50.0731) | | DRUG ........................................... (N S C )-> | SPECIMEN TYPE |-> TOPOGRAPHY FIELD (possible break) IV CATEGORY (#50.21) | | IV DRUG:GENERIC DRUG ........................... (N S )-> | NATIONAL DRUG FILE ENTRY |-> VA GENERIC (standard) DRUG COST (#50.9002) | | PHYSICIAN DATA:DRUG ............................ (N S )-> | PSNDF VA PRODUCT NAME EN* |-> VA PRODUCT (standard) DRUG DATA:DRUG ................................. (N S )-> | PACKAGE SIZE |-> PACKAGE SIZE (only mod from FM) (possibly standard) DIVISION DATA:DRUG DATA:DRUG ................... (N S )-> | PACKAGE TYPE |-> PACKAGE TYPE (only mod from FM) (possibly standard) PRESCRIPTION (#52) | | DRUG ........................................... (N S C )-> | NATIONAL DRUG CLASS |-> VA DRUG CLASS (standard) PENDING OUTPATIENT O (#52.41) | | DRUG ........................................... (N S )-> | UNIT DOSE MED ROUTE |-> MEDICATION ROUTES (addable) IV ADDITIVES (#52.6) | | GENERIC DRUG ................................... (N S C )-> | CORRESPONDING OUTPATIENT* |-> DRUG (this file) IV SOLUTIONS (#52.7) | | GENERIC DRUG ................................... (N S C )-> | *PRIMARY DRUG |-> PRIMARY DRUG (not used) NON-VERIFIED ORDERS (#53.1) | | SOLUTION ....................................... (N S )-> | UNIT |-> DRUG UNITS (only mod from FM) (possibly standard) DISPENSE DRUG .................................. (N S )-> | CORRESPONDING INPATIENT * |-> DRUG (this file) UNIT DOSE ORDER SET (#53.2102) | | *DRUG:*DISPENSE DRUG ........................... (N S C )-> | *LAB TEST MONITOR |-> LABORATORY TEST (not used) ORDERABLE ITEM:DISPENSE DRUG ................... (N S )-> | *SPECIMEN TYPE |-> TOPOGRAPHY FIELD (not used) INPATIENT USER PARAM (#53.4502) | | DISPENSE DRUG .................................. (N S C )-> | m CLOZAPINE L:LAB TEST MO* |-> LABORATORY TEST (broken) BCMA MISSING DOSE RE (#53.68) | | DRUG REQUESTED ................................. (N S )-> | CLOZAPINE L:SPECIMEN TY* |-> TOPOGRAPHY FIELD (broken) BCMA UNABLE TO SCAN (#53.771) | | DISPENSE DRUG .................................. (N S C )-> | m ATC CANISTE:WARD GROUP * |-> WARD GROUP (site specific) BCMA MEDICATION VARI (#53.78) | | DRUG SCANNED ................................... (N S )-> | ACTIVITY LO:INITIATOR O* |-> NEW PERSON (not used) BCMA MEDICATION LOG (#53.795) | | DISPENSE DRUG .................................. (N S C )-> | NDC BY OUTP:OUTPATIENT * |-> OUTPATIENT SITE (site specific) PHARMACY PATIENT (#55.05) | | NON-VA MEDS:DISPENSE DRUG ...................... (N S )-> | m DRUG TEXT E:DRUG TEXT E* |-> DRUG TEXT (included) UNIT DOSE:*SOLUTION ............................ (N S )-> | m IFCAP ITEM :ITEM NUMBER* |-> ITEM MASTER (WV empty file) UNIT DOSE:DISPENSE LOG:DISPENSE DRUG ........... (N S )-> | m FORMULARY A:FORMULARY A* |-> DRUG (this file) UNIT DOSE:DISPENSE DRUG ........................ (N S )-> | | UNIT DOSE PICK LIST (#57.63) | | WARD:PROVIDER:DRUG ............................. (N S )-> | | PHARMACY AOU STOCK (#58.11) | | ITEM ........................................... (N S )-> | | PHARMACY BACKORDER (#58.3) | | ITEM ........................................... (N S C )-> | | AR/WS STATS FILE (#58.52) | | INPATIENT SITE:RECALCULATE AMIS:DRUG ........... (N S )-> | | DRUG ACCOUNTABILITY (#58.8001) | | DRUG ........................................... (N S C )-> | | DRUG ACCOUNTABILITY (#58.81) | | DRUG ........................................... (N S )-> | | DRUG ACCOUNTABILITY (#58.81125) | | INVOICE DATA:LINE ITEM DATA:DRUG ............... (N S )-> | | CS WORKSHEET (#58.85) | | DRUG ........................................... (N S )-> | | CS DESTRUCTION (#58.86) | | DRUG ........................................... (N S )-> | | PRICE PER DISPENSE UNIT ........................ (N S )-> | | CS CORRECTION LOG (#58.87) | | DRUG ........................................... (N S )-> | | OUTPATIENT SITE (#59) | | METHADONE DRUG ................................. (N S )-> | | PHARMACY SYSTEM (#59.7) | | LAST DRUG CONVERTED ............................ (N S )-> | | LAST DRUG LINKED ............................... (N S )-> | | RAD/NUC MED PATIENT (#70.15) | | REGISTERE:EXAMINATION:MEDICATIONS:MED ADMINIS* . (N S )-> | | NUC MED EXAM DATA (#70.21) | | RADIOPHARMACEUTICALS:RADIOPHARMACEUTICAL ....... (N S )-> | | RAD/NUC MED PROCEDUR (#71.055) | | DEFAULT MEDICATIONS:DEFAULT MEDICATION ......... (N S C )-> | | DEFAULT RADIOPHARMACEU:DEFAULT RADIOPHARMACEUTI* (N S )-> | | RADIOPHARMACEUTICAL (#71.9) | | RADIOPHARM ..................................... (N S )-> | | ORDER STATISTICS (#100.1) | | NAME v ...........................................(N S C L)-> | | PATIENT ALLERGIES (#120.8) | | GMR ALLERGY v ....................................(N S L)-> | | SURGERY (#130.33) | | MEDICATIONS .................................... (N S )-> | | ANESTHESIA TECHNIQUE:ANESTHESIA AGENTS ......... (N S )-> | | ANESTHESIA TECHNIQUE:TEST DOSE ................. (N S )-> | | FEE BASIS PHARMACY I (#162.11) | | PRESCRIPTION NUMBER:GENERIC DRUG ............... (N S )-> | | TRANSFER PRICING TRA (#351.61) | | DRUG ........................................... (N S )-> | | IB BILL/CLAIMS PRESC (#362.4) | | DRUG ........................................... (N S )-> | | SECLUSION/RESTRAINT (#615.23) | | MEDICATIONS .................................... (N S )-> | | MEDICATION (#695) | | GENERIC NAME ................................... (N S C )-> | | GENERALIZED PROCEDUR (#699.53) | | MEDICATIONS .................................... (N S )-> | | ENDOSCOPY/CONSULT (#699.74) | | PRESCRIPTION GIVEN ............................. (N S )-> | | UNIT DOSE LOCAL EXTR (#727.809) | | BCMA DRUG DISPENSED ............................ (N S )-> | | IV DETAIL EXTRACT (#727.819) | | BCMA DRUG DISPENSED ............................ (N S )-> | | IV EXTRACT DATA (#728.113) | | DRUG ........................................... (N S )-> | | UNIT DOSE EXTRACT DA (#728.904) | | DRUG ........................................... (N S )-> | | ROR REGISTRY PARAMET (#798.129) | | LOCAL DRUG NAME ................................ (N S C )-> | | REMINDER FINDING ITE (#801.43) | | FINDING ITEM v ...................................(N S L)-> | | REMINDER EXTRACT SUM (#810.31) | | EXTRACT FINDINGS:FINDING ITEM v ..................(N S L)-> | | LREPI FINDING TOTALS:FINDING ITEM v ..............(N S L)-> | | REMINDER TERM (#811.52) | | FINDINGS:FINDING ITEM v ..........................(N S L)-> | | REMINDER DEFINITION (#811.902) | | FINDINGS:FINDING ITEM v ..........................(N S C L)-> | | APSP INTERVENTION (#9009032.4) | | DRUG ........................................... (N S )-> | | -------------------------------