Index: pharmacy-utils/drug-file-cleanup/README.txt =================================================================== --- pharmacy-utils/drug-file-cleanup/README.txt (revision 1402) +++ pharmacy-utils/drug-file-cleanup/README.txt (revision 1403) @@ -1,5 +1,195 @@ -All documentation for using the Drug File updating utility can be found in VWPSSXPD.m. +Documentation for using the Drug File updating utility can be found in VWPSSXPD.m. KIDS file contains this routine plus a sample drug file to be installed into a destination system. --- Sam Habiel +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) + +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 )-> | | + ------------------------------- +