$TXT Created by NAM,ELLEN at MNTVBB.FO-ALBANY.MED.VA.GOV (KIDS) on Wednesday, 10/01/03 at 15:18 ============================================================================= Run Date: OCT 02, 2003 Designation: EN*7*77 Package : EN - ENGINEERING Priority: Mandatory Version : 7 SEQ #75 Status: Released Compliance Date: NOV 02, 2003 ============================================================================= Associated patches: (v)EN*7*74 <<= must be installed BEFORE `EN*7*77' Subject: DATA CLEANSING REPORTS FOR 6928 FILE Category: - Routine Description: ============ This patch exports a series of reports that will be used to prepare the data in the AEMS/MERS ENG SPACE (#6928) file for conversion to the CoreFLS system. This patch adds a new menu option, Engineering Space - 6928 [ENH ENGINEERING SPACE], to the CoreFLS AEMS/MERS Data Cleansing Reports [ENH DATA CLEANSING] menu. This menu option requires the security key ENH DATA CLEANSING and contains the following options: Summary Report [ENH 6928 SUMMARY REPORT] Required Fields Missing Data Report [ENH 6928 REQUIRED RPT] Lookup Fields w/ Invalid Data Report [ENH 6928 LOOKUP RPT] Non-Required Fields Missing Data Report [ENH 6928 NON-REQUIRED RPT] The reports examine the following eight fields: ROOM NUMBER (#.01) BUILDING FILE POINTER (#.51) SERVICE (#1.5) KEY (#2) FUNCTION (#2.6) NET SQ.FT. (#4.5) H-08-9 CRITERIA (#4.9) UTILITIES (Multiple) (#6928.01,1) If any field is empty or has invalid data, it is included on one of the reports. This patch includes four reports, one summary and three detailed: 1. Summary Report - lists all the fields examined and a count of how many times each field is either empty or contains invalid data. 2. Required Fields Missing Data Report - lists each required field in the ENG SPACE (#6928) file that is empty. (A field is defined as required when the empty field causes functionality problems for CoreFLS.) 3. Lookup Fields with Invalid Data Report - lists each field in the ENG SPACE (#6928) file that contains invalid data. 4. Non-Required Fields Missing Data Report - lists each non-required field in the ENG SPACE (#6928) file that is empty. Because the fields are not required, they may be left empty, but populating these fields with data will improve functionality after conversion to CoreFLS. This patch addresses the following E3R(s): ------------------------------------------ There are no E3Rs associated with this patch This patch addresses the following NOIS message(s): --------------------------------------------------- There are no NOIS messages associated with this patch Test Sites: ----------- Bay Pines and VISN 2 ================INSTALLATION INSTRUCTIONS ================= ********************************** IRM NOTE ****************************** Install this patch within the usual time frame. Your site will receive an "Action Request" from the CoreFLS Project Office, which contains instructions about assigning the security key. You may assign the security key at any time prior to receiving the Action Request. ************************************************************************** If installed during the normal workday, it is recommended that the following menu options (File #19) and all of their descendants be disabled to prevent possible conflicts while running the KIDS Install. Other VISTA users will not be affected. CoreFLS AEMS/MERS Data Cleansing Reports [ENH DATA CLEANSING] Install Time - Less than 5 minutes 1. LOAD TRANSPORT GLOBAL --------------------- Choose the PackMan message containing this patch and invoke the INSTALL/CHECK MESSAGE PackMan option. 2. DISABLE ROUTINE MAPPING (DSM for Open VMS sites only) ----------------------- Disable routine mapping on all systems for the routines listed in step 3 below. NOTE: If the routines included in this patch are not currently in your mapped routine set, please skip this step. 3. COMPONENTS SENT WITH PATCH ------------------------ The following is a list of the routines included in this patch. The second line of each of these routines now looks like: ;;7.0;ENGINEERING;**[patch list]**;August 17, 1993 CHECK^XTSUMBLD results Routine Before Patch After Patch Patch List ------- ------------ ----------- ---------- ENH6928 N/A 3298749 77 ENH6928H N/A 4905404 77 ENH6928I N/A 11322912 77 ENH6928L N/A 14562111 77 ENH6928M N/A 21195173 77 ENH6928P N/A 6893074 77 ENH6928U N/A 13297439 77 Total number of routines - 7 Total number of new routines - 7 4. START UP KIDS ------------- Start up the Kernel Installation and Distribution System Menu [XPD MAIN]: Edits and Distribution ... Utilities ... Installation ... Select Kernel Installation & Distribution System Option: INStallation --- Load a Distribution Print Transport Global Compare Transport Global to Current System Verify Checksums in Transport Global Install Package(s) Restart Install of Package(s) Unload a Distribution Backup a Transport Global Select Installation Option: 5. Select Installation Option: -------------------------- NOTE: The following are OPTIONAL - (When prompted for the INSTALL NAME, enter EN*7.0*77): a. Backup a Transport Global - This option will create a backup message of any routines exported with this patch. It will not backup any other changes such as DD's or templates. b. Compare Transport Global to Current System - This option will allow you to view all changes that will be made when this patch is installed. It compares all components of this patch (routines, DD's, templates, etc.). c. Verify Checksums in Transport Global - This option will allow you to ensure the integrity of the routines that are in the transport global. 6. Select Installation Option: Install Package(s) ---------------- **This is the step to start the installation of this KIDS patch: a. Choose the Install Package(s) option to start the patch install. b. When prompted 'Want KIDS to Rebuild Menu Trees Upon Completion of Install? YES//' answer NO c. When prompted 'Want KIDS to INHIBIT LOGONs during the install? YES//' answer NO d. When prompted 'Want to DISABLE Scheduled Options, Menu Options, and Protocols? YES//' answer YES e. When prompted 'Enter options you wish to mark as 'Out of Order':' Enter the following option: CoreFLS AEMS/MERS Data Cleansing Reports [ENH DATA CLEANSING] f. When prompted 'Enter protocols you wish to mark as 'Out of Order':' press . 7. REBUILD MAPPED ROUTINE(S) (DSM for Open VMS sites only) ------------------------- Optional - Include the routines distributed with this patch in the mapped routine set. NOTE: This step is only necessary if you performed step 2 or if you wish to include the routines in your mapped set. Routine Information: ==================== Routine Name: - ENH6928 This is a new routine and is the main driver for the Engineering Space Data Cleansing Reports. Routine Checksum: Routine Name: - ENH6928I This is a new routine and contains run-time instructions for the Summary and Required Fields Missing Data Reports. Routine Checksum: Routine Name: - ENH6928L This new routine compiles into ^TMP("ENH6928") information about records with Data Cleansing issues to be resolved by the user. Routine Checksum: Routine Name: - ENH6928M This is a new routine and contains run-time instructions for the Lookup Fields with Invalid Data and Non-Required Fields Missing Data Reports. Routine Checksum: Routine Name: - ENH6928P This is a new routine and contains the printing programs for all the Engineering Space Data Cleansing reports. Routine Checksum: Routine Name: - ENH6928U This is a new routine and contains the utilities for the Engineering Space Data Cleansing Reports. Routine Checksum: Routine Name: - ENH6928H Contains all sub-headers for printing reports. Routine Checksum: ============================================================================= User Information: Entered By : NAM,ELLEN Date Entered : APR 03, 2003 Completed By: WEBB,KATHY Date Completed: OCT 02, 2003 Released By : DIETRICH,JON Date Released : OCT 02, 2003 ============================================================================= Packman Mail Message: ===================== $END TXT