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