$TXT Created by GINSBERG,ELIOT at MNTVLL.FO-ALBANY.MED.VA.GOV  (KIDS) on Monday, 09/18/06 at 14:42
=============================================================================
Run Date: OCT 11, 2006                     Designation: DG*5.3*656
Package : DG - REGISTRATION                   Priority: Mandatory
Version : 5.3       SEQ #638                    Status: Released
                  Compliance Date: NOV 11, 2006
=============================================================================

Associated patches: (v)DG*5.3*665  <<= must be installed BEFORE `DG*5.3*656'
                    (v)DG*5.3*705  <<= must be installed BEFORE `DG*5.3*656'

Subject: ADD FIELD TRIGGERS FOR ORU~Z07s

Category: 
  - Routine
  - Data Dictionary

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

 Issue
 -----
 As part of the Enrollment Vista Changes Enrollment Systems Redesign
 (EVC ESR) project, 106 fields from ten files were identified that would
 need to trigger an Enrollment Transmission (as part of an ORU~Z07 Full
 Data Transmission) to the Health Eligibility Center (HEC). Additionally,
 five fields from the PATIENT file (#2) were identified that already
 contained the trigger but no longer needed it and therefore should have 
 the trigger be deleted.
  
 Solution
 --------
 Each of the fields listed below in the File Summary section of this patch
 description was checked to see if either of two triggers (EVENT^IVMPLOG or
 AUTOUPD^DGENA2) was in the data dictionary for that field. If not, then a
 traditional cross-reference trigger was added. One hundred and six such
 fields were identified. 
  
 If a trigger was present on a field but not needed, it was deleted. Five
 such fields were found, and are identified in the File Summary table by
 means of a "Yes" in the "Trigger Deleted" column. The triggers are no
 longer needed on these fields because whenever they are edited, a PATIENT
 (#2) file field that contains the trigger (ADDRESS CHANGE DATE/TIME
 (#.118)) is automatically updated and the trigger fired.
  
 In addition, the data in the following 3 fields were set to be
 write-protected from being updated independently via FileMan.
  
 File #2 PATIENT
 TEMPORARY ADDRESS CHANGE DT/TM (field # .12113)
 CONFIDENTIAL ADDR CHANGE DT/TM (field # .14112)
  
 File #408.31 ANNUAL MEANS TEST
 DATE/TIME TEST LAST EDITED (field # 2.02)
  
 These fields are automatically updated as a result of changes to any of
 the Temporary Address or Confidential Address fields in the PATIENT file
 (#2) or any of the fields in the ANNUAL MEANS TEST file (#408.31),
 respectively.
  
  
 This patch addresses the following New Service Request (NSR):
 -------------------------------------------------------------
 There is no NSR associated with this patch.
  
 This patch addresses the following NOIS/Remedy Ticket(s):
 ---------------------------------------------
 There are no NOIS/Remedy tickets associated with this patch.
  
  
 DOCUMENTATION RETRIEVAL
 =======================
 Sites may retrieve the user documentation directly using FTP from the
 ANONYMOUS.SOFTWARE directory at the following OI Field Offices:
    
                 Albany   : ftp.fo-albany.med.va.gov
                 Hines    : ftp.fo-hines.med.va.gov
           Salt Lake City : ftp.fo-slc.med.va.gov
   First Available Server : download.vista.med.va.gov (preferred method)
   
                                                                          
 The following file will be available:
    
       File Name                     Description
       ---------                     -----------      
 DG_5_3_P656_IVM_TM.PDF              Revised IVM V. 2.0 Technical Manual 
  
  
   Note:  Use Binary mode when transferring the .PDF files.
   
 The VistA Documentation Library [VDL] web site contains all end-user 
 manuals. The address is http://www.va.gov/vdl/.
  
  
  
 Components Sent With Patch
 --------------------------
 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:
  
      <tab>;;5.3;Registration;**[patch list]**;Aug 13, 1994
  
                              CHECK^XTSUMBLD results
  Routine       Before Patch   After Patch              Patch List
  =======       ============   ===========              ==========
  DGRTRIG                N/A        869468                  656
  
 Number of routines in patch:           1
      Number of new routines:           1
  Number of routines changed:           0 
            
  
 File Summary 
 ------------
 The following is a list of files and fields included in this patch. Only
 the specific Data Dictionary elements that apply to the listed fields are
 being sent, not the entire Data Dictionary.
  
                                      UP    SEND  DATA                
                                      DATE  SEC.  COMES    
 FILE #  NAME                         DD    CODE  W/FILE 
 -------------------------------------------------------
 2       PATIENT                      YES   NO    NO
  
                                                                  Trigger
       FIELD                                  SUB-FILE #          Deleted
       -----                                  ----------          -------
  
 ADDRESS CHANGE DT/TM (#.118)                 
 APPOINTMENT REQUEST DATE (#1010.1511)        
 APPOINTMENT REQUEST ON 1010EZ (#1010.159)    
 BAD ADDRESS INDICATOR (#.121)                
 CITY (#.114)                                                     Yes
 *CLAIM FOLDER LOCATION (#.312)                
 CLAIM NUMBER (#.313)                         
 CONFIDENTIAL ADDR CHANGE DT/TM (#.14112)     
 CONFIDENTIAL ADDRESS COUNTY (#.14111)        
 COVERED BY HEALTH INSURANCE? (#.3192)        
 CURRENT PURPLE HEART REMARKS (#.533)         
 CURRENT PURPLE HEART STATUS (#.532)          
 DATE MEDICAID LAST ASKED (#.382)             
 DATE OF DEATH LAST UPDATED (#.354)           
 DATE OF DECISION (#.392)                     
 DECIDED BY (#.391)                           
 ELIGIBILITY STATUS (#.3611)                  
 ELIGIBILITY STATUS DATE (#.3612)             
 ELIGIBILITY VERIF. METHOD (#.3615)           
 EMPLOYER NAME (#.3111)                       
 EMPLOYMENT STATUS (#.31115)                  
 FACILITY MAKING DETERMINATION (#.393)        
 INELIGIBLE REASON (#.307)                    
 INELIGIBLE VARO DECISION (#.1656)            
 INTEGRATED CONTROL NUMBER (#991.01)          
 MARITAL STATUS (#.05)                        
 METHOD OF DETERMINATION (#.395)              
 P&T (#.304)                                  
 PERIOD OF SERVICE (#.323)                    
 PRIMARY NOK CHANGE DATE/TIME (#.21012)       
 RATED INCOMPETENT? (#.293)                   
 RECEIVING VA DISABILITY? (#.3025)            
 REVIEW DATE (#.394)                          
 SOURCE OF NOTIFICATION (#.353)               
 STATE (#.115)                                                    Yes
 STREET ADDRESS [LINE 1] (#.111)                                  Yes
 STREET ADDRESS [LINE 2] (#.112)                                  Yes
 TEMPORARY ADDRESS CHANGE DT/TM (#.12113)     
 TEMPORARY ADDRESS COUNTY (#.12111)           
 TEMPORARY PHONE NUMBER (#.1219)              
 USER ENROLLEE SITE (#.3618)                  
 USER ENROLLEE VALID THROUGH (#.3617)         
 ZIP+4 (#.1112)                                                   Yes
  
 DISABILITY % (#2)                            RATED DISABILITIES
                                              (#.3721)
 RATED DISABILITIES (VA) (#.01)               RATED DISABILITIES
                                              (#.3721)
 SERVICE CONNECTED (#3)                       RATED DISABILITIES
                                              (#.3721)
  
 *GROUP NUMBER (#2)                           INSURANCE TYPE
                                              (#.3121)
 EFFECTIVE DATE OF POLICY (#8)                INSURANCE TYPE
                                              (#.3121)
 GROUP PLAN (#.18)                            INSURANCE TYPE
                                              (#.3121)
 INSURANCE EXPIRATION DATE (#3)               INSURANCE TYPE
                                              (#.3121)
 INSURANCE TYPE (#.01)                        INSURANCE TYPE
                                              (#.3121)
 NAME OF INSURED (#17)                        INSURANCE TYPE
                                              (#.3121)
 SUBSCRIBER ID (#1)                           INSURANCE TYPE
                                              (#.3121)
 WHOSE INSURANCE (#6)                         INSURANCE TYPE
                                              (#.3121)
  
 CD STATUS DIAGNOSES (#.01)                   CD STATUS DIAGNOSES
                                              (#.396)
  
 AFFECTED EXTREMITY (#1)                      CD STATUS PROCEDURES
                                              (#.397)
 CD STATUS PROCEDURES (#.01)                  CD STATUS PROCEDURES
                                              (#.397)
  
 CD STATUS CONDITIONS (#.01)                  CD STATUS CONDITIONS
                                              (#.398)
 PERMANENT INDICATOR (#2)                     CD STATUS CONDITIONS
                                              (#.398)
 SCORE (#1)                                   CD STATUS CONDITIONS
                                              (#.398)
  
 Note:  Unless the "Trigger Deleted" column is set to Yes, the trigger 
        will be added to the data dictionary for that field.
  
 # of fields where trigger was added to this file:             55
 # of fields where trigger was deleted from this file:          5
  
                                      UP    SEND  DATA                
                                      DATE  SEC.  COMES    
 FILE #  NAME                         DD    CODE  W/FILE 
 -------------------------------------------------------
 27.11   PATIENT ENROLLMENT           YES   NO    NO
  
       FIELD                                 
       -----                                
 EFFECTIVE DATE (#.08)                        
 ENROLLMENT APPLICATION DATE (#.01)           
 ENROLLMENT DATE (#.1)                        
 ENROLLMENT END DATE (#.11)                   
 ENROLLMENT PRIORITY (#.07)                   
 ENROLLMENT STATUS (#.04)                     
 ENROLLMENT SUBGROUP (#.12)                  
 FACILITY RECEIVED (#.06)                     
 SOURCE OF ENROLLMENT (#.03)                  
                                              
 # of fields where trigger was added to this file:              9
  
                                      UP    SEND  DATA                
                                      DATE  SEC.  COMES    
 FILE #  NAME                         DD    CODE  W/FILE 
 -------------------------------------------------------
 29.11   MST HISTORY                  YES   NO    NO
  
       FIELD                               
       -----                               
 MST CHANGE STATUS DATE (#.01)                
 MST STATUS (#3)                              
 SITE DETERMINING STATUS (#6)                 
  
 # of fields where trigger was added to this file:              3
  
                                      UP    SEND  DATA                
                                      DATE  SEC.  COMES    
 FILE #  NAME                         DD    CODE  W/FILE 
 -------------------------------------------------------
 354     BILLING PATIENT              YES   NO    NO
  
       FIELD
       -----
 COPAY INCOME EXEMPTION STATUS (#.04)
  
 # of fields where trigger was added to this file:              1
  
                                      UP    SEND  DATA                
                                      DATE  SEC.  COMES    
 FILE #  NAME                         DD    CODE  W/FILE 
 -------------------------------------------------------
 392.2   BENEFICIARY TRAVEL
         CERTIFICATION                YES   NO    NO
  
       FIELD
       -----
 DATE CERTIFIED (#.01)             
  
 # of fields where trigger was added to this file:              1
  
                                      UP    SEND  DATA                
                                      DATE  SEC.  COMES    
 FILE #  NAME                         DD    CODE  W/FILE 
 -------------------------------------------------------
 408.12  PATIENT RELATION             YES   NO    NO
  
       FIELD                           SUB-FILE #
       -----                           ----------
 RELATIONSHIP (#.02)                    
                                             
  
 EFFECTIVE DATE (#.01)                 EFFECTIVE DATE
                                       (#75)
  
  
 # of fields where trigger was added to this file:              2
  
                                      UP    SEND  DATA                
                                      DATE  SEC.  COMES    
 FILE #  NAME                         DD    CODE  W/FILE 
 -------------------------------------------------------
 408.13  INCOME PERSON                YES   NO    NO
  
       FIELD
       -----
 DATE OF BIRTH (#.03)                         
 MAIDEN NAME (#1.1)                           
 NAME (#.01)                                  
 SEX (#.02)                                   
 SOCIAL SECURITY NUMBER (#.09)               
  
 # of fields where trigger was added to this file:              5    
  
                                      UP    SEND  DATA                
                                      DATE  SEC.  COMES    
 FILE #  NAME                         DD    CODE  W/FILE 
 -------------------------------------------------------
 408.21  INDIVIDUAL ANNUAL INCOME     YES   NO    NO
  
       FIELD
       -----
 ALL OTHER INCOME (#.17)         
 CASH, AMOUNTS IN BANK ACCOUNTS (#2.01)       
 DEBTS (#2.05)                                
 EDUCATIONAL EXPENSES (#1.03)                
 FUNERAL AND BURIAL EXPENSES (#1.02)          
 INTEREST, DIVIDEND, OR ANNUITY (#.15)       
 MEDICAL EXPENSES (#1.01)                    
 MILITARY RETIREMENT (#.11)                   
 OTHER PROPERTY OR ASSETS (#2.04)             
 OTHER RETIREMENT (#.13)                   
 REAL PROPERTY (#2.03)                        
 SOCIAL SECURITY (NOT SSI) (#.08)             
 STOCKS AND BONDS (#2.02)                     
 TOTAL INCOME FROM EMPLOYMENT (#.14)        
 U.S. CIVIL SERVICE (#.09)                    
 U.S. RAILROAD RETIREMENT (#.1)               
 UNEMPLOYMENT COMPENSATION (#.12)             
 WORKERS COMP. OR BLACK LUNG (#.16)           
 YEAR (#.01)                                  
  
 # of fields where trigger was added to this file:             19
  
                                      UP    SEND  DATA                
                                      DATE  SEC.  COMES    
 FILE #  NAME                         DD    CODE  W/FILE 
 -------------------------------------------------------
 408.22  INCOME RELATION              YES   NO    NO
  
       FIELD
       -----
 AMOUNT CONTRIBUTED TO SPOUSE (#.07)         
 CHILD 18-23 IN SCHOOL (#.18)                
 CHILD HAD INCOME (#.11)                      
 CONTRIBUTED TO SUPPORT (#.1)                 
 DEPENDENT CHILDREN (#.08)                   
 INCAPABLE OF SELF-SUPPORT (#.09)             
 INCOME AVAILABLE TO YOU (#.12)               
 LIVED WITH PATIENT (#.06)                    
 MARRIED LAST CALENDAR YEAR (#.05)           
 NUMBER OF DEPENDENT CHILDREN (#.13)         
  
 # of fields where trigger was added to this file:             10
  
                                      UP    SEND  DATA                
                                      DATE  SEC.  COMES    
 FILE #  NAME                         DD    CODE  W/FILE 
 -------------------------------------------------------
 408.31  ANNUAL MEANS TEST            YES   NO    NO
  
       FIELD
       -----
 DATE/TIME TEST LAST EDITED (#2.02)
  
 # of fields where trigger was added to this file:              1
                                                              ___
  
 Total # of fields across all files where trigger was added:  106
 Total # of fields across all files where trigger was deleted:  5
  
  
 Test Sites:
 -----------
 Bronx (Large)
 Puget Sound (Integrated)
 Tucson (Large) 
  
  
        ================INSTALLATION INSTRUCTIONS =================
  
 NOTE: THIS PATCH MUST BE INSTALLED DURING OFF HOURS. Keeping system
 usage to a minimum during patch installation will prevent potential
 errors due to the large number of options that access the fields 
 whose DDs are being changed by this patch.
  
 You should also stop the HL7 filers prior to the install to prevent
 possible 'No Source Errors' from occurring. No transmissions will be 
 lost if the filers are stopped first; they will be picked up once 
 the filers are restarted.
  
 If you have set up any of the above fields for site-specific auditing, 
 the install of the patch will overwrite the audit flag. Because of this,
 the audit flag for those fields should be turned on again after the patch
 has been installed.
  
 Install Time - less than 5 minutes (unless otherwise indicated)
  
 ***********************************************************
  
 1.  LOAD TRANSPORT GLOBAL 
     ---------------------
     Choose the PackMan message containing this patch and invoke the 
     INSTALL/CHECK MESSAGE PackMan option.  
              
 2.  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: 
    
 3.  Select Installation Option: 
     ---------------------------
     NOTE:  The following are OPTIONAL - (When prompted for the INSTALL
            NAME, enter DG*5.3*656):
       
     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.
      
 4.  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.
  
         When prompted 'Want KIDS to Rebuild Menu Trees Upon Completion of
         Install? YES//' answer NO. 
  
     b.  When prompted 'Want KIDS to INHIBIT LOGONs during the install? 
         YES//' answer NO.
     c.  When prompted 'Want to DISABLE Scheduled Options, Menu 
         Options, and Protocols? YES//' answer YES.
     d.  When prompted 'Enter options you wish to mark as 'Out Of
         Order':' enter the following option:
                 
           IVM BACKGROUND JOB [IVM BACKGROUND JOB]
  
  
 When the installation is complete, be sure to re-start the filers 
 if you chose to stop them. 

Routine Information:
====================
The checksums below are new checksums, and
 can be checked with CHECK1^XTSUMBLD.

Routine Name: DGRTRIG
    Before:       n/a  After:  B3817226  **656**

=============================================================================
User Information:
Entered By  : MULLER,RICHARD                Date Entered  : MAR 15, 2005
Completed By: RUDINGER,NANCY L.             Date Completed: OCT 04, 2006
Released By : HEUER,CINDY                   Date Released : OCT 11, 2006
=============================================================================


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

$END TXT