$TXT Created by REDINGTON,PATRICK at DVF.FO-SLC.MED.VA.GOV (KIDS) on Monday, 03/06/06 at 08:58 Run Date: MAR 23, 2006 Designation: DG*5.3*690 Package : DG - REGISTRATION Priority: Mandatory Version : 5.3 SEQ #604 Status: Released Compliance Date: APR 23, 2006 ============================================================================= Associated patches: (v)DI*22*146 <<= must be installed BEFORE `DG*5.3*690' Subject: CROSS-REFERENCES FOR OEF/OIF Category: - Routine - Data Dictionary Description: ============ General Overview: ================= This patch adds four new cross-references that result in two new indexes to the PATIENT file (#2). These indexes are used for Operation Enduring Freedom/Operation Iraqi Freedom (OEF/OIF) reporting. Three of the cross-references are new-style compound cross-references on the SERVICE ENTRY DATE and SERVICE SEPARATION DATE. They are cross-references because there are three sets of these dates: LAST, NTL, and NNTL. The cross-references are named ASERLAST, ASERNTL, and ASERNNTL; the associated field numbers are shown in the following table: Cross-reference Field numbers ----------------------------- ASERLAST .326 .327 ASERNTL .3292 .3293 ASERNNTL .3297 .3298 These three cross-references create one index that has the form ^DPT("ASERVICE",SERVICE SEPARATION DATE,SERVICE ENTRY DATE,DA,TYPE), where TYPE has the value "LAST", "NTL", or "NNTL", as appropriate. The fourth cross-reference, named APTYPE, is on the TYPE field (#391) and it has the form ^DPT("APTYPE",TYPE,DA). The new routine DGSRVICE has a utility that will verify that the indexes are in synch with the data in the PATIENT file. It does this by checking all the entries in the PATIENT file to make sure they are indexed properly, and then checks all the entries in the indexes to make sure they match what is in the PATIENT file. Detailed information is in the Installation section of this patch narrative. This patch addresses the following New Service Request (NSR): ------------------------------------------------------------- There is no NSR associated with this patch. This patch addresses the following NOIS/Remedy ticket(s): --------------------------------------------------------- There are no NOIS/Remedy tickets associated with this patch. Test Sites: ----------- Salisbury Northern California Tampa Build Components: ================= Data Dictionary: ================ Four cross-references are added, see the description above. Routines: ========= The following is a list of the routines included in this patch. The second line of each routine looks like: ;;5.3;Registration;**[Patch List]**;Aug 13, 1993 The checksums are from CHECK1^XTSUMBLD. Routine Old Checksum New Checksum Patch List ======= ============ ============ ========== DG53690I N/A 18353842 690 DGSRVICE N/A 22073599 690 Installation: ============= This patch can be loaded with users on the system; however, since it populates the new indexes, install it during off hours. The installation time depends on the number of entries in the Patient file (#2). At a medium sized site with approximately 154,000 entries, installation took about 12 minutes. 1. On the PackMan menu, use the 'INSTALL/CHECK MESSAGE' option. 2. On the KIDS menu under the 'INSTALLATION' menu, use the following options, as desired: Print Transport Global Compare Transport Global to Current System Verify Checksums in Transport Global Backup a Transport Global 3. On the KIDS menu under the 'INSTALLATION' menu, use the following option to install the patch: Install Package(s) (DG*5.3*690) 4. When prompted "Want KIDS to INHIBIT LOGONs during the install? YES//", respond 'NO'. 5. When prompted "Want to DISABLE Scheduled Options, Menu Options, and Protocols? YES//," respond 'NO'. 6. After installation is complete, run a utility to verify that all PATIENT file entries are indexed and all entries in the indexes match the data in the PATIENT file: D VERIFY^DGSRVICE This verification took approximately 20 minutes to run at a site with about 154,000 entries in the PATIENT file. 7. Once the installation has successfully completed, you may delete the init routine DG53690I. Routine Information: ==================== The checksums below are new checksums, and can be checked with CHECK1^XTSUMBLD. Routine Name: DG53690I Before: After: B18353842 **690** Routine Name: DGSRVICE Before: After: B22073599 **690** ============================================================================= User Information: Entered By : REDINGTON,PATRICK Date Entered : NOV 21, 2005 Completed By: DESMOND,LINDA Date Completed: MAR 23, 2006 Released By : FRANCE,KATHI Date Released : MAR 23, 2006 ============================================================================= Packman Mail Message: ===================== $END TXT