$TXT Created by ALEXANDER,DAVID M at ISCPNDF.FO-BIRM.MED.VA.GOV (KIDS) on Monday, 04/03/06 at 07:51 Run Date: APR 03, 2006 Designation: PSN*4*107 Package : PSN - NATIONAL DRUG FILE Priority: EMERGENCY Version : 4 SEQ #102 Status: Released Compliance Date: APR 05, 2006 ============================================================================= Associated patches: (v)PSN*4*105 <<= must be installed BEFORE `PSN*4*107' Subject: CLEAN UP INGREDIENTS AND INTERACTIONS Category: - Routine - Data Dictionary Description: ============ It has been noted that several sites have made local entries in the DRUG INGREDIENTS file (#50.416). This should not have been done. Patch PSN*4*89 changed the data dictionary of that file to prevent further additions. Some of these local entries may have already been overwritten by national entries. It has also been noted that some sites have added local entries in the DRUG INTERACTION file (#56) involving these locally added ingredients. If the locally added ingredients have been overwritten, these interactions will check for ingredients other than those indicated by the name of the interaction. This patch performs six functions. 1. It creates a new style cross-reference on the NAME field (#.01) and the PRIMARY INGREDIENT field (#2) of the DRUG INGREDIENTS file (#50.416). This new cross-reference replaces the old "P" cross-reference on the NAME field (#.01). The "P" cross reference was not working properly and included entries that should not have been referenced. This corrects the Patient Safety Issue PSI-05-008. 2. Any entries in the DRUG INGREDIENTS file (#50.416) with an internal entry number (IEN) greater than that of the last nationally entered ingredient will be deleted. These would be locally entered ingredients that would eventually be overwritten with national ingredients released with NDF Data Updates. 3. Any entries in the DRUG INTERACTIONS file (#56) which have ingredients pointing to these deleted locally entered ingredients will be deleted. 4. Any entries in the DRUG INTERACTIONS file (#56) which point to ingredients other than those indicated by the name will be deleted. These would be interactions created with a locally entered ingredient that was subsequently overwritten by a national ingredient. 5. A mail message with the subject INGREDIENTS AND INTERACTIONS DELETED will be sent from NDF MANAGER to members of the mail group NDF DATA, holders of the PSNMGR security key, and the person installing the patch. This message lists deleted ingredients, interactions deleted because they pointed to deleted ingredients, and interactions which pointed to ingredients other than those indicated in the name. In the last case, both the name (containing the original ingredients) and the current ingredients are displayed. 6. The GMR ALLERGY field (#1) and the DRUG INGREDIENT field (#.01) of the DRUG INGREDIENTS multiple field (#2) in the PATIENT ALLERGIES file (#120.8) and the DRUG INGREDIENT field (#.01) of the DRUG INGREDIENTS multiple field (#2) in the GMR ALLERGIES file (#120.82) point to the DRUG INGREDIENTS file (#50.416). Any entries in these fields that point to ingredients that were deleted as described in item 2 above will be deleted. In addition, the selection of drug ingredients in the PATIENT ALLERGIES file (#120.8) should allow the selection of only primary ingredients. Any entries that point to ingredients that are not primary ingredients will be repointed to the proper primary ingredient. Associated Remedy Tickets: ========================== HD067711 HD068104 HD068614 HD087725 HD097594 HD101720 HD112912 Test Sites: =========== Cheyenne, WY Chillicothe, OH Heartland-East, MO Hines, IL Puget Sound HCS, WA West Palm Beach, FL Routine Summary: ================ The following routines are included in this patch. The second line of this routine reads: ;;4.0; NATIONAL DRUG FILE;**[patch list]**; 30 Oct 98 CHECK^XTSUMBLD results Routine Name Before Patch After Patch Patch List ============ ============ =========== ========== PSN107E N/A 634172 107 PSNCLING N/A 31475614 107 Note: The environment check routine PSN107E and the post-install routine PSNCLING will be automatically deleted from your system upon completion of the installation. Installation Instructions: ========================== Installation time depends on the size of the PATIENT ALLERGIES file (#120.8). On test systems, installation took about thirty minutes. This patch should be installed during non-peak requirement hours. No options need to be placed out of order. Users may remain on the system. 1. Use the INSTALL/CHECK MESSAGES option on the PackMan menu. 2. All components of this patch are new, so there are no mapping issues. 3. From the Kernel Installation & Distribution System menu, select the Installation menu. 4. From this menu, you may choose to use the option Verify Checksums in Transport Global. When prompted, select PSN*4.0*107. All components of this patch are new, so the option Backup a Transport Global and the option Compare Transport Global to Current System do not have to be invoked. 5. Use the Install Package(s) option and select PSN*4.0*107. 6. When prompted "Want KIDS to INHIBIT LOGONs during the install? YES//" respond NO. 7. When prompted "Want to DISABLE Scheduled Options, Menu Options, and Protocols? YES//" respond NO. Routine Information: ==================== The checksums below are new checksums, and can be checked with CHECK1^XTSUMBLD. Routine Name: PSN107E Before: After: B664156 **107** Routine Name: PSNCLING Before: After: B84044539 **107** ============================================================================= User Information: Entered By : ALEXANDER,DAVID Date Entered : MAR 28, 2005 Completed By: GREER,MIKE Date Completed: APR 03, 2006 Released By : BARRON,LUANNE Date Released : APR 03, 2006 ============================================================================= Packman Mail Message: ===================== $END TXT