============================================================================= Run Date: DEC 21, 2001 Designation: ECX*3*39 Package : ECX - DSS EXTRACTS Priority: Mandatory Version : 3 SEQ #39 Status: Released ============================================================================= Associated patches: (v)ECX*3*37 <<= must be installed BEFORE `ECX*3*39' (v)ECX*3*38 <<= must be installed BEFORE `ECX*3*39' Subject: DSS FY2002 UPDATE Category: - Data Dictionary - Routine - Enhancement (Mandatory) Description: ============ General Description: ==================== ********************* IMPORTANT NOTE *************************** This patch ONLY applies to DSS sites that have installed DSS EXTRACTS V3.0 (dated DEC 22,1997 on the second line of routines) and are prepared to begin extracts for FY2002 data. Please insure that the DSS Site Manager obtains a copy of this patch description. Warning: Do not attempt to install this patch until you have received specific approval from the local DSS Site Manager to do so. **************************************************************** Please note: Patch ECX*3*39 is the FY2002 Update for DSS EXTRACTS v3.0. Sites should ensure that all FY2001 extracts have been generated, transmitted to Austin, and processed in DSS. After this has been accomplished, sites should contact the Help Desk at the Bedford Technical Services Office (BTSO) to request the KIDS Distribution file for ECX*3*39. Call (781) 275-9175. The documentation is available on the following CIO Field Offices' ANONYMOUS.SOFTWARE directories. All sites are encouraged to use their FTP capability to obtain these files. The documentation files can be used on a PC with the Adobe Acrobat Reader browser program. The .PDF files are binary files so you must make sure, when using the file transfer mechanism, to move these files to your VISTA machines and/or PC's using the appropriate commands for binary file transfer. Some commonly used transfer protocols may not transfer .PDF files intact. IRM FIELD OFFICE FTP ADDRESS DIRECTORY Hines 152.129.1.110 ANONYMOUS.SOFTWARE Albany 152.127.1.5 ANONYMOUS.SOFTWARE Salt Lake 152.131.2.1 ANONYMOUS.SOFTWARE DSS_3_FY2002_EF.PDF;1 Extract Format & Data Definitions Guide DSS_3_FY2002_TM.PDF;1 Technical Manual DSS_3_FY2002_UM.PDF;1 User Manual If your site encounters technical difficulty with obtaining these files, you may contact the OCIO National Help Desk for assistance at 1-888-596-4357. Technical Description: ====================== 1) NEW FIELDS IN EXISTING FILES A large number of new fields are being added to existing DSS EXTRACTS files in this update. A summary of added/modified fields for FY2002 has been provided below. Please consult the Extract Format & Data Definitions Guide for a complete description of updated field definitions. Summary of added/modified fields for FY2002: Field Extract Modified/ ===== ======= Added ========= Agent Orange Location CLI, ADM, NOS, ECQ, PRO, Added SUR, ECS, MTL, PRE Note: Agent Orange Location data is not available until patch DG*5.3*342 has been released (scheduled for 2002). Cancelled SUR Modified Clinic Name NOS Added CNH/SH Status ECS, ECQ, PRO, PRE Added (Contract Nursing Home/State Home) Contract Start Date ECS, ECQ Added Contract End Date ECS, ECQ Added Contract Type ECS, ECQ Added Discharge PC Team MOV Added Discharge PC Provider MOV Added Discharge Assoc PC MOV Added Provider Encounter Number All (Except PAI) Added In Out Patient All (Except PAI) Modified Indicator Observation Patient All (Except PAI) Modified Indicator (This was an existing field (Extended Outpatient Indicator) which was renamed) Ordering Stop Code RAD, IVP, LAB, PRE Added Ordering Physician IVP, PRE Added Ordering Division ECS, ECQ Added Ordering Date RAD, IVP, LAB, PRE Added Patient Birth Date MTL Added Provider PRE Modified Purple Heart Indicator NOS Added Requesting Physician IVP Added Quantity PRO Modified 2) MODIFIED FILES a) The file DOM PRRTP SAARTP ETC (#727.831) has been renamed to the DSS TREATING SPECIALTY TRANSLATION file and contains the following new fields: FIELD NAME: OBSERVATION PAT INDICATOR NODE,PIECE: [0,4] DESCRIPTION: This field contains the observation patient indicator which is based on the treating specialty and inpat/outpat code values of the record. FIELD NAME: INPAT/OUTPAT CODE NODE,PIECE: [0,5] DESCRIPTION: This field contains the inpatient/outpatient status which is based on the treating specialty value of the record. It replaces the IN/OUT CODE field (#3) of this file. FIELD NAME: OBSERVATION STOP CODE NODE,PIECE: [0,6] DESCRIPTION: This field contains the observation stop code which is based on the treating specialty value of the record. b) The IN OUT PATIENT INDICATOR field (#7) of any extract file which was a pointer to the LOCATION TYPE file (#40.9) has been converted to a one character free text field. This was done to accomodate the "I" designation for Inpatient and "O" designation for Outpatient. 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;DSS EXTRACTS;**[patch list]**;Dec 22, 1997 CHECK^XTSUMBLD results Routine name Before Patch After Patch Patch List ============ ============ =========== ========== ECXADM 4719989 5092095 1,4,11,8,13 24,33,39 ECXAPRO2 6316428 6324104 9,21,39 ECXARAD 11164517 11263803 8,33,39 ECXDENT 3064645 3429985 11,8,13,24,33 39 ECXEC 6359261 7034981 11,8,13,24,27 33,39 ECXKILL 12138651 3750621 9,8,21,24,31 39 ECXKILL1 N/A 3694251 39 ECXLABN 5956052 6941109 1,11,8,13,28 24,30,31,32,33 39 ECXLABR 4156065 4832349 8,24,33,37,39 ECXMOV 3833544 4956998 8,24,33,39 ECXMTL 5027538 5829410 24,30,33,39 ECXNURS 8649928 9692581 8,14,22,24,33 39 ECXOPRX 14795678 15764141 10,11,8,13,24 33,39 ECXPIVDN 9768370 12035104 10,11,8,13,24 33,39 ECXPRO 5851107 6543982 9,13,15,21,24 33,39 ECXPRO1 4416981 4454693 9,11,13,15,21 24,33,37,39 ECXQSR 10216345 10862123 11,8,13,26,24 34,33,35,39 ECXRAD 6839454 8199388 11,8,13,16,24 33,39 ECXSCNS 7290237 7960576 11,8,13,20,24 30,33,37,39 ECXSCX2 N/A 2735059 39 ECXSCXN 14727749 18525964 24,27,29,30,31 32,33,39 ECXSURG 7129943 7597930 1,11,8,13,25 24,33,39 ECXTRT 11132137 13199747 1,8,17,24,33 35,39 ECXUD 4463689 4787357 10,8,24,33,39 ECXUTL2 10796515 10898479 8,13,23,24,33 35,39 ECXUTL3 8017968 8178777 11,24,32,33,35 37,39 ECXUTL4 N/A 6664314 39 INSTALLATION INSTRUCTIONS: ========================== This patch can be loaded with users on the system, but coordinate with DSS Extract users to prevent use of options until installation has been completed. If you are running the install interactively and not rebuilding user menus, installation will take less than 5 minutes. Note: If you are not running the installation interactively and intend to allow KIDS to start the rebuild of user menus upon completion of the install, then please queue the install for a period of low system activity. No harm to your database will occur if the installation is performed more than once. 1. Use the 'Load a Distribution' option within the KIDS Installation menu to unload the KIDS distribution. The host file is named: ECX_30_P39.KID 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. (Skip this step if already in the Installation menu) 4. From this menu, you may elect to use the following options (when prompted for INSTALL NAME, enter ECX*3.0*39): 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 allow you to ensure the integrity of the routines that are in the transport global. 5. Use the Install Package(s) option and select the package ECX*3.0*39. 6. When prompted 'Want to DISABLE Scheduled Options, Menu Options, and Protocols? YES//', respond YES. When prompted to select the options you would like to place out of order, enter the following: Extract Manager's Options [ECXMGR] 7. If routines were unmapped as part of step 2, they should be returned to the mapped set once the installation has run to completion. SAMPLE INSTALLATION: ==================== Select Installation Option: INStall Package(s) Select INSTALL NAME: ECX*3.0*39 Loaded from Distribution 12/14/01@12:47:55 => ECX*3.0*39 - DSS FY2002 ;Created on Dec 14, 2001@12:39:34 This Distribution was loaded on Dec 14, 2001@12:47:55 with header of ECX*3.0*39 - DSS FY2002 ;Created on Dec 14, 2001@12:39:34 It consisted of the following Install(s): ECX*3.0*39 Checking Install for Package ECX*3.0*39 Install Questions for ECX*3.0*39 Incoming Files: 727.802 ADMISSION EXTRACT Note: You already have the 'ADMISSION EXTRACT' File. 727.804 CLINIC NOSHOW EXTRACT Note: You already have the 'CLINIC NOSHOW EXTRACT' File. 727.805 NURSING EXTRACT Note: You already have the 'NURSING EXTRACT' File. 727.806 DENTAL EXTRACT Note: You already have the 'DENTAL EXTRACT' File. 727.808 PHYSICAL MOVEMENT EXTRACT Note: You already have the 'PHYSICAL MOVEMENT EXTRACT' File. 727.809 UNIT DOSE LOCAL EXTRACT Note: You already have the 'UNIT DOSE LOCAL EXTRACT' File. 727.81 PRESCRIPTION EXTRACT Note: You already have the 'PRESCRIPTION EXTRACT' File. 727.811 SURGERY EXTRACT Note: You already have the 'SURGERY EXTRACT' File. 727.812 MENTAL HEALTH EXTRACT Note: You already have the 'MENTAL HEALTH EXTRACT' File. 727.813 LABORATORY EXTRACT Note: You already have the 'LABORATORY EXTRACT' File. 727.814 RADIOLOGY EXTRACT Note: You already have the 'RADIOLOGY EXTRACT' File. 727.815 EVENT CAPTURE LOCAL EXTRACT Note: You already have the 'EVENT CAPTURE LOCAL EXTRACT' File. 727.817 TREATING SPECIALTY CHANGE EXTRACT Note: You already have the 'TREATING SPECIALTY CHANGE EXTRACT' File. 727.819 IV DETAIL EXTRACT Note: You already have the 'IV DETAIL EXTRACT' File. 727.824 LAB RESULTS EXTRACT Note: You already have the 'LAB RESULTS EXTRACT' File. 727.825 QUASAR EXTRACT Note: You already have the 'QUASAR EXTRACT' File. 727.826 PROSTHETICS EXTRACT Note: You already have the 'PROSTHETICS EXTRACT' File. 727.827 CLINIC EXTRACT Note: You already have the 'CLINIC EXTRACT' File. 727.831 DSS TREATING SPECIALTY TRANSLATION (including data) *BUT YOU ALREADY HAVE 'DOM PRRTP SAARTP ETC' AS FILE #727.831! Shall I write over your DOM PRRTP SAARTP ETC File? YES// YES I will OVERWRITE your data with mine. Want KIDS to INHIBIT LOGONs during the install? YES// NO Want to DISABLE Scheduled Options, Menu Options, and Protocols? YES// YES Enter options you wish to mark as 'Out Of Order': ECXMGR Extract Manager's Options Enter options you wish to mark as 'Out Of Order': Enter protocols you wish to mark as 'Out Of Order': Delay Install (Minutes): (0-60): 0// Enter the Device you want to print the Install messages. You can queue the install by enter a 'Q' at the device prompt. Enter a '^' to abort the install. DEVICE: HOME// ;PK-DEC UCX/TELNET Install Started for ECX*3.0*39 : Dec 14, 2001@12:48:59 Build Distribution Date: Dec 14, 2001 Installing Routines:............................ Dec 14, 2001@12:49:01 Installing Data Dictionaries: .................... Dec 14, 2001@12:49:23 Installing Data: Dec 14, 2001@12:49:23 Updating Routine file.... The following Routines were created during this install: ECX802 ECX8021 ECX8022 ECX804 ECX8041 ECX8042 ECX805 ECX8051 ECX8052 ECX806 ECX8061 ECX8062 ECX808 ECX8081 ECX8082 ECX809 ECX8091 ECX8092 ECX810 ECX8101 ECX8102 ECX811 ECX8111 ECX8112 ECX813 ECX8131 ECX8132 ECX814 ECX8141 ECX8142 ECX815 ECX8151 ECX8152 ECX817 ECX8171 ECX8172 ECX819 ECX8191 ECX8192 ECX824 ECX8241 ECX8242 ECX825 ECX8251 ECX8252 ECX826 ECX8261 ECX8262 ECX827 ECX8271 ECX8272.. Updating KIDS files....... ECX*3.0*39 Installed. Dec 14, 2001@12:49:25 Install Message sent #355650 Routine Information: ==================== Routine Name: - ECXADM Routine Checksum: Routine Name: - ECXDENT Routine Checksum: Routine Name: - ECXEC Routine Checksum: Routine Name: - ECXKILL Routine Checksum: Routine Name: - ECXKILL1 Routine Checksum: Routine Name: - ECXLABN Routine Checksum: Routine Name: - ECXLABR Routine Checksum: Routine Name: - ECXMOV Routine Checksum: Routine Name: - ECXMTL Routine Checksum: Routine Name: - ECXNURS Routine Checksum: Routine Name: - ECXOPRX Routine Checksum: Routine Name: - ECXPIVDN Routine Checksum: Routine Name: - ECXPRO Routine Checksum: Routine Name: - ECXPRO1 Routine Checksum: Routine Name: - ECXQSR Routine Checksum: Routine Name: - ECXRAD Routine Checksum: Routine Name: - ECXSCNS Routine Checksum: Routine Name: - ECXSCX2 Routine Checksum: Routine Name: - ECXSCXN Routine Checksum: Routine Name: - ECXSURG Routine Checksum: Routine Name: - ECXTRT Routine Checksum: Routine Name: - ECXUD Routine Checksum: Routine Name: - ECXUTL2 Routine Checksum: Routine Name: - ECXUTL3 Routine Checksum: Routine Name: - ECXUTL4 Routine Checksum: Routine Name: - ECXARAD Routine Checksum: Routine Name: - ECXAPRO2 Routine Checksum: ============================================================================= User Information: Entered By : DEFIBAUGH,ELIZABETH Date Entered : NOV 21, 2001 Completed By: DOWNING,TODD Date Completed: DEC 14, 2001 Released By : COOPER,SAMANTHA Date Released : DEC 21, 2001 ============================================================================= Packman Mail Message: ===================== No routines included