$TXT Created by TAS-EPAY-HFD.AAC.DOMAIN.EXT (KIDS) on Friday, 12/02/22 at 07:39 ============================================================================= Run Date: JAN 10, 2023 Designation: PRCA*4.5*371 Package : PRCA - ACCOUNTS RECEIVABLE Priority: Mandatory Version : 4.5 SEQ #356 Status: Released Compliance Date: FEB 09, 2023 ============================================================================= Associated patches: (v)PRCA*4.5*238<<= must be installed BEFORE `PRCA*4.5*371' (v)PRCA*4.5*241<<= must be installed BEFORE `PRCA*4.5*371' (v)PRCA*4.5*302<<= must be installed BEFORE `PRCA*4.5*371' (v)PRCA*4.5*367<<= must be installed BEFORE `PRCA*4.5*371' (v)PRCA*4.5*375<<= must be installed BEFORE `PRCA*4.5*371' (v)PRCA*4.5*377<<= must be installed BEFORE `PRCA*4.5*371' (v)PRCA*4.5*380<<= must be installed BEFORE `PRCA*4.5*371' (v)PRCA*4.5*381<<= must be installed BEFORE `PRCA*4.5*371' Subject: MCCF EDI TAS EPAYMENTS RELEASE 18 Category: - Routine - Enhancement (Mandatory) - Data Dictionary Description: ============ Below is a list of all the applications involved in this patch along with their patch number: APPLICATION/VERSION PATCH ------------------------------------------------- ACCOUNTS RECEIVABLE (PRCA) V. 4.5 PRCA*4.5*371 The purpose of this patch is to meet the requirements of the Medical Care Collection Fund (MCCF) Electronic Data Interchange (EDI) Transaction Application Suite (TAS) Phase 1 project as related to Accounts Receivable(PRCA). This project ensures the Department of Veterans Affairs (VA) compliance with Electronic Funds Transfer (EFT) and Electronic Remittance Advice (ERA) Operating Rules, and enables VA to more effectively use ERA data, resulting in better revenue and cash flow management. It will provide the infrastructure foundation for electronic exchange of claim payment information and promotes an inter operable system. It will reduce the time elapsed between receipt of the EDI 835 Electronic Remittance Advice Transaction and receipt of the Cash Concentration or Disbursement (CCD+) transactions. It will ensure that trace numbers between payments and remittances can be used by VA, reducing the level of open accounts receivable, allow claim denials to be more quickly addressed and standardizes Electronic Funds Transfer (EFT) and ERA enrollment to reduce workload burden on VA staff. This patch contains changes to the ePayments (835 and EFT) program area to ensure compliance. Specifically, enhancements to the Veterans Health Information Systems and Technology Architecture (VistA) Third Party EDI Lockbox module to increase timely and accurate processing of payments for electronic claims in compliance with Health Insurance Portability and Accountability Act (HIPAA) and Veterans Health Administration (VHA) Fiscal Accounting policies. The ePayments system is used by Accounts Receivable (AR) staff to process payments from third party payers for both medical and pharmacy claims. The following features of the PRCA software will be affected by this patch: 1. An option has been added to the Unapplied EFT Deposits Report [RCDPE UNAPPLIED EFT DEP REPORT] to allow a user to choose "Grand Totals" only. This will print the total amount of unapplied deposits in their VistA system (known as the 8NZZ account). 2. To allow quick access to recently changed electronic remittance advice (ERA) and electronic funds transfer (EFT) data, several date/time fields, indexes, and cross references were added to Vista to facilitate reporting in future releases. New date/time fields were added to the top-level ELECTRONIC REMITTANCE ADVICE file (#344.4, 9) and EDI THIRD PARTY EFT DETAIL file (#344.31, 9). Whole file cross references ('MCCF') were created for each file. To allow Vista access to only changed detail lines within an ERA, a date/time field was added to the ERA DETAIL sub-file (#344.41, 9.02), along with an associated sub-file cross reference ('MCCF'). Updates to the #344.41 sub-file will in-turn update the whole file 'MCCF' cross references. A date/time field was also added to the AR BATCH PAYMENT file (#344, 9) to track receipt data changes. Additionally, MUMPS record type cross references were created to update the MCCF date/time fields in the #344.4, #344.41, #344.31, and #344 files if any of the report data fields within these files change. 3. Widened the Selection Number column of the Identify Payers [RCDPE PAYER IDENTIFY] menu option of the EDI Lockbox (ePayments) [RCDPE EDI LOCKBOX MENU] so it can accurately show selection numbers for payers when the total number of payers is in the thousands. 4. The EFT Transaction Audit Report [RCDPE EFT TRANSACTION AUD REP] (ETA) on the Audit Reports [RCDPE EDI LOCKBOX AUDIT RPRTS] sub-menu of the EDI Lockbox (ePayments) Reports menu [RCDPE EDI LOCKBOX REPORTS MENU] was modified. This report can be run in either summary or detail mode. When run in detail mode, the user can choose an EFT to display by either Deposit Number, Deposit Date, Receipt Number, or Trace Number. Prior to this enhancement the report was exited after the EFT was displayed. Now the user will be returned to the Deposit Number, Deposit Date, Receipt Number, or Trace Number prompt so that they can select another EFT. 5. The ERA Unmatched Aging Report [RCDPE ERA AGING REPORT] (ERA) was modified to remove all Electronic Explanation of Benefits (EEOB) detail lines from being displayed so that unmatched Electronic Remittance Advice (ERAs) can be researched more easily. 6. Modified the Remove ERA from Active Worklist Audit Report [RCDPE REMOVED ERA AUDIT] (REMR) to include a column for Trace number. 7. Modified Receipt Processing [RCDP RECEIPT PROCESSING] (RP) to prevent blank spaces in a receipt number when either creating a new receipt or using the Edit Receipt action when editing an existing receipt. 8. Fixed an issue that resulted in one Electronic Fund Transfer (EFT) being matched to multiple receipts. The issued occurred when the user enters the Receipt Processing [RCDP RECEIPT PROCESSING] (RP) menu option to edit an open receipt with a payment type of EDI LOCKBOX and performs the following steps: a) The user selects the Edit Receipt action and switches the EFT attached to the receipt. b) The user selects a different receipt to edit without exiting all the way back to the menu option prompt. c) When the second receipt, having no deposit number, is processed, the following occurs: The EFT from the first receipt is associated with the second receipt The EFT that was associated with the second receipt is unmatched. 9. Fixed an issue that caused the system to erroneously prompt the user for a deposit number when a receipt with a payment type of EDI LOCKBOX was processed in Receipt Processing [RCDP RECEIPT PROCESSING] (RP) using the Process Receipt action. 10. Fixed an issue for CHAMPVA receipts that was preventing users from entering a receipt total that was greater than 99999.99 dollars. Patch Components ================ Files & Fields Associated: File Name (Number) Field Name (Number) New/Modified/Deleted Sub-file Name (#) ------------------------ ------------------------- -------------------- ELECTRONIC REMITTANCE ADVICE (#344.4) ENTRY (#.01) MODIFIED MCCF DATE/TIME (#9) NEW ERA DETAIL SUB-FILE (#344.41) SEQUENCE # (#.01) MODIFIED MCCF DATE/TIME (#9.02) NEW EDI THIRD PARTY EFT DETAIL (#344.31) MCCF DATE/TIME (#9) NEW RECEIPT # (#.09) MODIFIED AR BATCH PAYMENT (#344) MCCF DATE/TIME (#9) NEW DATE/TIME PROCESSED (#.08) MODIFIED RECEIPT TOTAL (#.22) MODIFIED EDI LOCKBOX EOB WORKLIST (#344.49) SEQUENCE # SUB-FILE (#344.491) CLAIM # (#.02) MODIFIED RCDPE AUTO-PAY EXCLUSION (#344.6) PHARMACY PAYER (#.09) MODIFIED AR FMS DOCUMENT (#347) DATE LAST UPDATED (#.05) MODIFIED ACCOUNTS RECEIVEABLE(#430) CURRENT STATUS (#8) MODIFIED AR TRANSACTION (#433) ERA (#95) MODIFIED //------------------------------------------------------------------------ Bulletins Associated: Bulletin Name New/Modified/Deleted ------------- -------------------- N/A Dialogs Associated: Dialog Name New/Modified/Deleted ----------- -------------------- N/A Forms Associated: Form Name File Number New/Modified/Deleted --------- ----------- -------------------- N/A Mail Groups Associated: Mail Group Name New/Modified/Deleted --------------- -------------------- N/A Options Associated: Option Name Type New/Modified/Deleted ----------- ---- -------------------- N/A Protocols Associated: Protocol Name New/Modified/Deleted ------------- -------------------- N/A Security Keys Associated: Security Key Name ----------------- N/A Templates Associated: Template Name Type File Name (Number) New/Modified/Deleted ------------- ---- ------------------ -------------------- RCDPE MISC REPORTS WIDE LIST LIST TEMPLATE (#409.61) MODIFIED RCDPE PAYER FLAGS LIST LIST TEMPLATE (#409.61) MODIFIED Remote Procedures Associated: Remote Procedure Name New/Modified/Deleted --------------------- -------------------- N/A Parameter Definitions Associated: Parameter Name New/Modified/Deleted -------------- -------------------- N/A Additional Information: ----------------------- New Service Requests (NSRs): N/A Patient Safety Issues (PSIs): N/A Defect Tracking System Ticket(s) & Overview: N/A Test Sites: ---------- WILKES-BARRE VAMC (WILKES-BARRE,PA) BOSTON HCS VAMC (BOSTON,MA) WILMINGTON VAMC (WILMINGTON,DE) Software and Documentation Retrieval Instructions: ---------------------------------------------------------- The software for this patch is being released in a PackMan message. Documentation describing the new functionality is included in this release. The documentation can be found in the VA Software Documentation Library at: http://www.domain.ext/vdl/ Documentation can also be obtained at: https://download.vista.domain.ext/index.html/SOFTWARE or /srv/vista/patches/SOFTWARE Documentation Title File Name --------------------------------------------------------------------- PRCA*4.5*371 Deployment, PRCA_4_5_P371_DIBR.PDF Installation, Back-out, and Rollback Guide Accounts Receivable Version EPAYMENTS_EDI_LOCKBOX_P371_UG.PDF Version 4.5 ePayments User Manual (EDI Lockbox) Accounts Receivable Version PRCA_4_5_P371_TM.PDF 4.5 Technical Manual/Security Guide Patch Installation: Pre/Post Installation Overview: ------------------------------- Do not install this patch while the "Accounts Receivable Nightly Process Background Job" [PRCA NIGHTLY PROCESS] is running. To avoid disruptions, this patch should be installed during non-peak hours when there is minimal activity on the system and there are no Accounts Receivable users on the system. Pre-Installation Instructions: ------------------------------ ************************************************************************** ** IMPORTANT: Do not install this patch while the "Accounts Receivable ** ** Nightly Process Background Job" [PRCA NIGHTLY PROCESS] is running ** ** ** ** To avoid disruptions, this patch should be installed during non-peak ** ** hours when there is minimal activity on the system and there are no ** ** Accounts Receivable users on the system. ** ************************************************************************** This patch may be installed with users on the system although it is recommended that it be installed during non-peak hours to minimize potential disruption to users. This patch should take less than 5 minutes to install. No menu options need to be disabled during installation of this patch. Installation Instructions: -------------------------- 1. Choose the PackMan message containing this build. Then select the INSTALL/CHECK MESSAGE PackMan option to load the build. 2. From the Kernel Installation & Distribution System Menu, select the Installation Menu. From this menu, you may select to use the following options. When prompted for the INSTALL NAME, enter the patch PRCA*4.5*371: A. Verify Checksums in Transport Global option to confirm the integrity of the routines that are in the transport global. When prompted for the INSTALL NAME enter the patch or build name. (ex. or XXXXX BUILD X.X) B. Select the Backup a Transport Global option to create a backup message for PRCA*4.5*371. You must use this option and specify what to backup; the entire Build or just Routines. The backup message can be used to restore the routines and components of the build to the pre-patch condition. i. At the Installation option menu, select Backup a Transport Global. ii. At the Select INSTALL NAME prompt, enter your build PRCA*4.5*371 iii. When prompted for the following, enter "R" for Routines or "B" for Build. Select one of the following: B Build R Routines Enter response: Build iv. When prompted "Do you wish to secure your build? NO//", press and take the default response of "NO". v. When prompted with, "Send mail to: Last name, First Name", press to take default recipient. Add any additional recipients. vi. When prompted with "Select basket to send to: IN//", press and take the default IN mailbox or select a different mailbox. C. You may also elect to use the following options: i. Print Transport Global - This option will allow you to view the components of the KIDS build. ii. 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 of the components of this patch, such as routines, DDs, templates, etc. D. Select the Install Package(s) option and choose the patch to install. i. If prompted 'Want KIDS to Rebuild Menu Trees Upon Completion of Install? NO//', answer . ii. When prompted 'Want KIDS to INHIBIT LOGONs during the install? NO//', answer . iii. When prompted 'Want to DISABLE Scheduled Options, Menu Options, and Protocols? NO//', answer . Post-Installation Instructions: ------------------------------- None for installer. The automated post install process will re-compile the ACCOUNTS RECEIVABLE (#430) input templates to make use of the new AMCCF index. Back-out/Roll Back Plan: ------------------------ The Backout Procedure of this patch will be performed only with the concurrence and participation of the appropriate VA site/region personnel. The decision to back out the patch will be a joint decision between VA site/region personnel and other appropriate VA personnel. For Routine Information: ==================== The second line of each of these routines now looks like: V ;;4.5;Accounts Receivable;**[Patch List]**;Mar 20, 1995;Build 29 The checksums below are new checksums, and can be checked with CHECK1^XTSUMBLD. Routine Name: PRCACLM Before: B15529290 After: B15777958 **371** Routine Name: PRCAEIN Before: B23427681 After: B24977135 **57,67,153,371** Routine Name: PRCAEXM Before: B15833991 After: B16588932 **67,103,196,301,318,315,332, 381,371** Routine Name: PRCARFD1 Before: B32465290 After: B32802452 **21,36,90,104,141,190,204,203, 207,220,238,371** Routine Name: PRCAUDT1 Before: B11997062 After: B15674205 **1,173,371** Routine Name: PRCAWO1 Before: B21521636 After: B21766554 **67,68,153,315,377,371** Routine Name: PRCAWREA Before: B22227628 After: B22640964 **16,49,153,315,377,371** Routine Name: PRCAX Before: B19662938 After: B20557656 **68,371** Routine Name: RCBEADJ Before:B106126105 After:B107827126 **169,172,204,173,208,233,298, 301,315,326,338,371** Routine Name: RCBEUBIL Before: B20763062 After: B21068584 **153,226,276,371** Routine Name: RCDPE8NZ Before:B128118614 After:B149037157 **173,212,208,269,276,283,293, 298,317,318,326,375,371** Routine Name: RCDPEAR1 Before:B185349630 After:B141454382 **173,269,276,284,293,298,321, 326,371** Routine Name: RCDPEM3 Before:B208058844 After:B241436317 **276,284,298,326,375,371** Routine Name: RCDPEP Before:B154349379 After:B159913929 **321,326,332,371** Routine Name: RCDPESR9 Before: B71991491 After: B71991491 **173,252,269,302,371** Routine Name: RCDPRPL3 Before: B91916740 After: B92189818 **114,148,153,173,301,326,367,371** Routine Name: RCDPTAR Before:B216913861 After:B262874172 **303,321,326,380,371** Routine Name: RCDPUREC Before:B160265491 After:B160734451 **114,148,169,173,208,222,293, 298,321,326,380,367,371** Routine Name: RCDPURED Before: B79685245 After: B81367572 **114,169,174,196,202,244,268, 271,304,301,312,319,321,375, 371** Routine Name: RCKATPD Before: B7389792 After: B8110122 **241,371** Routine Name: RCP371 Before: n/a After: B1913199 **371** Routine Name: RCTAS10I Before: n/a After: B4532289 **371** Routine list of preceding patches: 238, 241, 302, 338, 367, 375, 377, 381 ============================================================================= User Information: Entered By : Date Entered : MAY 29, 2020 Completed By: Date Completed: JAN 10, 2023 Released By : Date Released : JAN 10, 2023 ============================================================================= Packman Mail Message: ===================== $END TXT