$TXT Created by RUTHERFORD,JERRY at DEVCUR.FO-SLC.MED.VA.GOV (KIDS) on THURSDAY, 07/18/02 at 10:06 ============================================================================= Run Date: AUG 28, 2002 Designation: GMRC*3*27 Package : GMRC - CONSULT/REQUEST TRACKING Priority: Mandatory Version : 3 SEQ #25 Status: Released ============================================================================= Associated patches: (v)GMRC*3*22 <<= must be installed BEFORE `GMRC*3*27' Subject: Misc. report corrections Category: - Routine - Data Dictionary Description: ============ This patch corrects several problems reported when using various Consult related reports. Problem 1: When running the Consults Brief Health Summary Component, occasionally you will see an UNKNOWN in the Action Date column. This is most often due to an activity being entered without a time for the activity. This problem is corrected by this patch. If the problem is not due to a date format problem, the problem will not be resolved until the release of GMTS*2.7*58. Problem 2: If a VA Fileman sort is done on the REQUEST/CONSULTATION file, sorting on the DATE OF REQUEST field, sometimes when choosing from a certain date to LAST, dates will show up at the end that are logically before the date chosen to start with. This is caused by dates with trailing zeroes being committed to the database and indexed as strings instead of numeric dates. A post-install included in this patch will locate any dates stored as such and will correct them to be stored as numeric dates/times. This will correct any future sorts on the DATE OF REQUEST field. Problem 3: When using the Service Consults Pending Resolution option, if one chooses the Service action to select a different service, the list of choices may not scroll correctly if there are more than 2 partial matches for the input. This patch corrects this problem by allowing scrolling to show all choices listed. NOIS calls addressed: ===================== BUT-0701-20825 WPB-0202-31624 CPH-0302-40541 DAY-0502-41853 PUG-0602-51270 E3R's addressed: ================ E3R #16981, UNCOMPLETED CONSULTS COMPONENTS INCLUDED: ==================== This patch exports the Data Dictionary for two fields in the REQUEST/CONSULTATION (#123) file. The following fields within the REQUEST PROCESSING ACTIVITY multiple are modified: .01 DATE/TIME OF ACTION ENTRY 2 DATE/TIME OF ACTUAL ACTIVITY The patch also includes the following protocols: GMRC COMP STAT SELECT SERVICE GMRC OUTSTD CONSLTS SELECT SERVICE GMRC QC SELECT SERVICE POST-INSTALLATION: ================== This patch includes a post-install routine that will detect and correct dates/times stored incorrectly in the DATE OF REQUEST field in the REQUEST/CONSULTATION (#123) file. The post-install should not be lengthy although the time needed to run is dependent on the number of errant entries being corrected. The post-install routine (GMRCYP27) may be deleted after successful installation. INSTALLATION INSTRUCTIONS: ========================== This patch should be installed at non-peak hours due to the high volume use of the routines included. Installation should take less than 5 minutes but due to the post-install, it may take longer. 1. Use the INSTALL/CHECK MESSAGE option on the PackMan menu. 2. Review your mapped set. If any of the routines listed in the ROUTINE SUMMARY section are mapped, they should be removed from the mapped set at this time. 3. From the Kernel Installation and Distribution System Menu, select the Installation menu. 4. From this menu, you may elect to use the following options (when prompted for INSTALL NAME, enter GMRC*3.0*27): a. Backup a Transport Global b. Compare Transport Global to Current System c. Verify Checksums in Transport Global 5. Use the Install Package(s) option and select the package GMRC*3.0*27. 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. 8. If routines were unmapped as part of step 2, they should be returned to the mapped set once the installation has run to completion. ROUTINE SUMMARY: ================ The following is a list of the routine(s) included in this patch. The second line of each of these routine(s) will look like: ;;3.0;CONSULT/REQUEST TRACKING;**[patch list]**;DEC 27, 1997 CHECK^XTSUMBLD results Routine name Before Patch After Patch Patch List ============ ============ =========== ========== GMRCP 6275190 6261586 1,4,17,22,27 GMRCTIU 5204542 6776454 1,4,12,18,15,17,22,27 GMRCYP27 N/A 414563 27 Routine Information: ==================== Routine Name: - GMRCTIU Routine Checksum: Routine Name: - GMRCYP27 Routine Checksum: Routine Name: - GMRCP Routine Checksum: ============================================================================= User Information: Entered By : RUTHERFORD,JERALD F Date Entered : JUL 05, 2002 Completed By: GREEN,JOANN Date Completed: AUG 27, 2002 Released By : KREUZ,SHERI B Date Released : AUG 28, 2002 ============================================================================= Packman Mail Message: ===================== $END TXT