Changeset 1410
- Timestamp:
- Apr 16, 2012, 3:20:47 PM (13 years ago)
- Location:
- pharmacy-utils/drug-file-cleanup
- Files:
-
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
pharmacy-utils/drug-file-cleanup/README.txt
r1405 r1410 1 Documentation for using the Drug File updating utility WITH and WITHOUT KIDS can be found in VWPSSXPD.m. 2 3 KIDS file contains this routine plus a sample drug file to be installed into a destination system. 4 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 ---- 5 42 License is AGPL. 6 43 7 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. 8 49 9 50 Remarks on Broken Pointers in Destination Systems as a result of using this package: … … 20 61 - IFCAP ITEM NUMBER:ITEM NUMBER (field not used currently) 21 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). 22 65 23 66 For Pharmacy Orderable Item File: … … 25 68 26 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 ============================================================================== 27 108 28 109 See detailed analysis below. -
pharmacy-utils/drug-file-cleanup/VWPSSXPD.m
r1409 r1410 1 VWPSSXPD ; VW/SMH - Update the Drug File and friends... ; Wed Apr 13 2012 ; 4/16/12 11:02am1 VWPSSXPD ; VW/SMH - Update the Drug File and friends... ; 4/16/12 12:15pm 2 2 ;;1.0;WorldVista Modifications;;;Build 5 3 3 ; (C) Sam Habiel … … 26 26 ; On the Origin System: 27 27 ; - Create a KIDS build that calls the follwing: 28 ; 1. ENVis the Environment Check for the Build28 ; 1. This Routine Name to call from top is the Environment Check for the Build 29 29 ; 2. TRAN is the Pre-Transport Routine for your originating system drug data 30 30 ; 3. PRE is the Pre-Init for the Destination System 31 31 ; 4. POST is the Post-Init for the Destination System 32 ; - Generate the KIDS Build 32 ; - Generate the KIDS Build. The file will have all the Drug Data from the Origin 33 ; System. 33 34 ; On the Destination System: 34 35 ; - Install the KIDS Build … … 55 56 ; 56 57 ; KIDS EPs: 57 ; ENV -> Environment Check (call the routine from the top) 58 ; TRAN -> Pre-Transport Routine (to get data from original system) 58 ; Top EP Fall through -> Environment Check (call the routine from the top) 59 59 ; PRE -> Pre-Init for the Destination System 60 60 ; POST -> Post-Init for the Destination System 61 ; TRAN -> Pre-Transport Routine (to get data from original system) 61 62 ; 62 63 ; KIDS EPs call PEPs to do their work.
Note:
See TracChangeset
for help on using the changeset viewer.