$TXT Created by NAM,ELLEN at MNTVBB.FO-ALBANY.MED.VA.GOV (KIDS) on Tuesday, 09/30/03 at 10:56 ============================================================================= Run Date: OCT 03, 2003 Designation: EN*7*78 Package : EN - ENGINEERING Priority: Mandatory Version : 7 SEQ #76 Status: Released Compliance Date: NOV 03, 2003 ============================================================================= Associated patches: (v)EN*7*74 <<= must be installed BEFORE `EN*7*78' Subject: DATA CLEANSING REPORTS FOR 6928.3 FILE Category: - Routine Description: ============ This patch exports a series of reports that will be used to prepare the data in the AEMS/MERS ENG BUILDING (#6928.3) file for conversion to the CoreFLS system. This patch adds a new menu option, Building File - 6928.3 [ENH BUILDING FILE], 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.3 SUMMARY REPORT] Required Fields Missing Data Report [ENH 6928.3 REQUIRED RPT] Lookup Fields w/ Invalid Data Report - N/A [ENH 6928.3 LOOKUP RPT] Non-Required Fields Missing Data Report [ENH 6928.3 NON-REQUIRED RPT] The reports examine the following seven fields: NAME (#.01) PROPERTY ADDRESS 1 (#5.3) PROPERTY ADDRESS 2 (#5.4) PROPERTY CITY (#5.5) PROPERTY STATE (#5.6) PROPERTY ZIP (#5.7) GROSS SQUARE FEET (#13.5) If any field is empty, 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 empty. 2. Required Fields Missing Data Report - lists each required field in the ENG BUILDING (#6928.3) 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 - does not apply to this file but is being exported for consistency with other Data Cleansing options. 4. Non-Required Fields Missing Data Report - lists each non-required field in the ENG BUILDING (#6928.3) 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 ------- ------------ ----------- ---------- ENH283 N/A 3755301 78 ENH283I N/A 17046301 78 ENH283L N/A 10900899 78 ENH283M N/A 15434093 78 ENH283P N/A 9861633 78 ENH283U N/A 1674643 78 Total number of routines - 6 Total number of new routines - 6 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*78): 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: - ENH283 This is a new routine and is the main driver for the Building File Data Cleansing Reports. Routine Checksum: Routine Name: - ENH283I This is a new routine and contains run-time instructions for the Summary and Required Fields Missing Data Reports. Routine Checksum: Routine Name: - ENH283L This is a new routine and is the looping routine to create data for the reports. Routine Checksum: Routine Name: - ENH283M This is a new routine and contains run-time instructions for the Lookup Fields with Invalid Data and Non-Required Fields Missing Data Reprots. Routine Checksum: Routine Name: - ENH283P This is a new routine and contains the printing programs for all Building File Data Cleansing Reports. Routine Checksum: Routine Name: - ENH283U This is a new routine and contains utilities for the Building File Data Cleansing Reports. Routine Checksum: ============================================================================= User Information: Entered By : NAM,ELLEN Date Entered : MAY 21, 2003 Completed By: WEBB,KATHY Date Completed: OCT 03, 2003 Released By : DIETRICH,JON Date Released : OCT 03, 2003 ============================================================================= Packman Mail Message: ===================== $END TXT