$TXT Created by THOMAS,GAIL at MNTVBB.FO-ALBANY.MED.VA.GOV  (KIDS) on Wednesday, 02/20/08 at 14:34
=============================================================================
Run Date: MAY 30, 2008                     Designation: ECX*3*111
Package : ECX - DSS EXTRACTS                  Priority: Mandatory
Version : 3       SEQ #100                      Status: Released
                  Compliance Date: JUN 30, 2008
=============================================================================

Associated patches: (v)ECX*3*49    <<= must be installed BEFORE `ECX*3*111'
                    (v)ECX*3*105   <<= must be installed BEFORE `ECX*3*111'

Subject: REMEDY TICKETS FIXES

Category: 
  - Routine

Description:
============

 This patch provides a fix to the ECX PROS COST Report, Pharmacy Extracts 
 Incomplete Feeder Key Report [ECX PHA FKEY],Surgery Unusual Volume Report
 and Nutrition (NUT) Extract Audit Report.
  
 ASSOCIATED REMEDY TICKETS:
 =========================
 1).  HD0000000219890 - ECX PROS COST report - not showing duplicate 660
                        records
 2).  HD0000000225935 - Undefined error during Pharmacy Extract.
 Duplicates:
 HD0000000227925 - RECORDING THAT AN ERROR OCCURRED
 HD0000000227863 - Error on prescription incomplete feeder key report
 HD0000000225910 - <UNDEFINED>PRE2+3^ECXDRUG2
 HD0000000226357 - Error Running Pharmacy Extracts Incomplete Feeder Key Report
 HD0000000226445 - Feeder Key report errors
 HD0000000226819 - Pharmacy Undefined Error
 HD0000000227250 - Pharmacy Extracts Incomplete Feeder Key
 HD0000000227637 - Error on prescription incomplete feeder key report
 HD0000000227717 - <UNDEFINED>PRE2+3~ECXDRUG2
 HD0000000228102 - MAR-UNDEFINED>PRE2+3^ECXDRUG2
 HD0000000228695 - $ZE= <UNDEFINED>PRE2+3^ECXDRUG2
 HD0000000230890 - <UNDEFINED>PRE2+3~ECXDRUG2 ~TMP
 HD0000000232638 - PHARMACY FEEDER KEY REPORT ERROR
 HD0000000233082 - $ZE= <UNDEFINED>PRE2+3^ECXDRUG2
  
 3).  HD0000000225781 - Pt Holding Times are negative numbers
 Duplicates:  HD0000000227298 - Surgical Unusual Volumes Report problem
              HD0000000232578 - DSS Report Problem
  
 4).  HD0000000226317 - (ECXNUT) not picking up the patient division
                        consistently.
  
 ASSOCIATED NSR(s):
 ==================
 N/A
  
 PARTICIPATING TEST SITES:
 =========================
 Upstate NY HCS
 Battle Creek, MI
 Central TX HCS
 El Paso, TX
  
 REMEDY OVERVIEW:
 ================
 1).  HD0000000219890 - ECX PROS COST report - not showing duplicate 660
                        records
  
 Problem:
 --------
 The REMEDY ticket is needed for the "Prosthetic Extract Unusual Cost Report 
 [ECX PRO COST]" option's failure to capture all pertinent data.
  
 Resolution:
 -----------
 Routines ECXUPRO and ECXUPRO1 were modified to capture all pertinent data for 
 the "Prosthetic Extract Unusual Cost Report [ECX PRO COST]".
  
 REMEDY OVERVIEW:
 ================
 2). HD0000000225935 -Undefined error during Pharmacy Extract.
  
 Problem:
 --------
 Pharmacy Extracts Incomplete Feeder Key Report [ECX PHA FKEY] getting an 
 UNDEFINED ERROR in ECXDRUG2.
  
  
 Resolution:
 -----------
 Routine ECXDRUG2 was modified to prevent the UNDEFINED ERROR in Pharmacy 
 Extracts Incomplete Feeder Key Report [ECX PHA FKEY].
  
  
 REMEDY OVERVIEW:
 ================
 3).  HD0000000225781 - Pt Holding Times are negative numbers
  
 Problem:
 --------
 Surgery Unusual Volume Report listing zeros for PT Holding time column.
  
  
 Resolution:
 -----------
 Routine ECXUSUR1 was modified to correct Surgery Unusual Volume Report listing 
 incorrect zeros for PT Holding time column. 
  
 REMEDY OVERVIEW:
 ================
 4).   HD0000000226317 - (ECXNUT) not picking up the patient division
                         consistently.
  
 Problem:
 --------
 The DSS Nutrition Extract (ECXNUT) is not picking up the patient division 
 consistently. When we run the Extract Audit Report (ECX NUT SOURCE AUDIT) 
 we get many entries with Patient Division Unknown. 
  
  
 Resolution:
 -----------
 Routine ECXANUT was modified to correct the Patient Division from 
 displaying Unknown on the detailed Nutrition Audit Report.
  
  
 INSTALLATION INSTRUCTIONS:
 ==========================
 This patch may be run with users on the system, but it is recommended
 that it be queued to run after normal business hours.
  
 Installation will take less than 5 minutes.
  
 Suggested time to install: non-peak requirement hours.
  
      1. Use the INSTALL/CHECK MESSAGE option on the PackMan menu.
  
      2. From the Kernel Installation & Distribution System menu, select
         the Installation menu.
  
      3. From this menu, you may select to use the following options
         (when prompted for INSTALL NAME, enter ECX*3.0*111)
        a. Backup a Transport Global - this option will create a backup
           message of any routines exported with the patch. It will NOT
           backup any other changes such as DDs or templates.
        b. Compare Transport Global to Current System - this option will
           allow you to view all changes that will be made when the patch
           is installed. It compares all components of the patch (routines,
           DDs, templates, etc.)
        c. Verify Checksums in Transport Global - this option will ensure
           the integrity of the routines that are in the transport global.
        d. Print Transport Global - this option will allow you to view the
           components of the KIDS build.
  
      4. Use the Install Package(s) option and select the package ECX*3.0*111.
  
      5. When prompted "Want KIDS to INHIBIT LOGONs during the install?
         YES//" respond NO.
  
      6. When prompted "Want to DISABLE Scheduled Options, Menu Options,
         and Protocols? YES//" respond NO.

Routine Information:
====================
The second line of each of these routines now looks like:
 ;;3.0;DSS EXTRACTS;**[Patch List]**;Dec 22, 1997;Build 4

The checksums below are new checksums, and
 can be checked with CHECK1^XTSUMBLD.

Routine Name: ECXANUT
    Before: B53849197   After: B56020770  **105,111**
Routine Name: ECXDRUG2
    Before: B16714262   After: B17371737  **40,68,84,105,111**
Routine Name: ECXUPRO
    Before: B23072481   After: B23782854  **49,111**
Routine Name: ECXUPRO1
    Before:  B6816358   After:  B6892004  **49,111**
Routine Name: ECXUSUR1
    Before: B13707019   After: B13707004  **49,71,105,111**
 
Routine list of preceding patches: 105

=============================================================================
User Information:
Entered By  : THOMAS,GAIL                   Date Entered  : JAN 07, 2008
Completed By: TSAIMEUCHONG,BRENDA           Date Completed: MAY 30, 2008
Released By : STRICKLAND,JOAN C             Date Released : MAY 30, 2008
=============================================================================


Packman Mail Message:
=====================

$END TXT