$TXT Created by ACORD,ARLIS L at DSI-ALPHA.DAOU.COM (KIDS) on Wednesday, 07/28/04 at 13:24 ============================================================================= Run Date: AUG 25, 2004 Designation: IB*2*233 Package : IB - INTEGRATED BILLING Priority: Mandatory Version : 2 SEQ #250 Status: Released Compliance Date: SEP 25, 2004 ============================================================================= Associated patches: (v)PRCA*4.5*201<<= must be installed BEFORE `IB*2*233' Subject: CBO AR DATA EXTRACT - IB SUPPORT Category: - Routine - Data Dictionary Description: ============ This patch requires the following patches: PRCA*4.5*201 As per Directive 2001-023, this patch should be installed into the legacy system unless they have not had any "active" or outstanding bills since prior to FY 01 in the AR system. **PLEASE NOTE** This patch must be installed into the primary production system before installing it into the legacy system(s). ************************** NOTE ************************************ *CoreFLS sites must coordinate the installation of this patch with the *AR-CoreFLS development team. ******************************************************************** Interface Overview ------------------ This document describes the design requirements for a software development project where the Veterans Health Administration (VHA) has established a new set of revenue metrics for use in monitoring the performance of the VHA revenue cycle at all VHA facilities. The desired metrics are industry-standard measures that are commonly used in other public and private health care institutions. VHA has an existing centralized data warehouse that calculated these metrics and provides results via a web-based performance metric site. This data warehouse is updated on a monthly basis. VHA's Chief Business Office (CBO) has identified the daily collection of this data as a high priority to support the metrics development process. CBO needs the daily collection of data to populate the centralized data warehouse (database) with billing and collections transactions from each VHA facility. The calculated metrics would be viewable to field and headquarters staff through an existing website. An automated daily VISTA extract would provide more timely and accurate data to this centralized data warehouse (database). Functional Description ---------------------- For the national implementation of this project, data will be triggered by normal user processing into a data queue file. This data will be formatted and placed in a flat file via a nightly process. This nightly process has been added to PRCA NIGHTLY PROCESS - Accounts Receivable Nightly Process Background Job. This nightly process will take any pending batches, format them and ftp them directly to the Boston Allocation Resource Center (ARC). This ftp process is an automated version of the existing manual FTP method employed by the MCCR Monthly Extract. If the FTP process fails, a mail message will be sent to the select Mail Group. If the ARC fails to acknowledge receipt and processing of the data files via an automated mail message, the nightly batch will automatically resend any data not successfully transmitted in previous attempts. Configuration Requirements -------------------------- This project will use the FTP transfer protocol to transmit data from the VISTA system. A standard defined directory will be utilized/created at each facility where the data files will be temporarily placed for the FTP process and will then be deleted immediately after the data is transmitted. Space requirements for the data file should not exceed 10 megabytes the maximum size for each batch. There are no long term space requirements due to the fact that the files are deleted after use. Installation Notes ------------------ This patch only includes the trigger point for the Bill/Claims File #399 and the program that sets this trigger point. The trigger point is a MUMPS cross-reference added to the STATUS DATE field. ^DD(399,.14,0) = STATUS DATE^RD^^0;14^S %DT="E" D ^%DT S X=Y K:Y<1 X ^DD(399,.14,1,0) = ^.1 ^DD(399,.14,1,1,0) = 399^AF^MUMPS ^DD(399,.14,1,1,1) = D BC^IBJVDEQ ^DD(399,.14,1,1,2) = Q ^DD(399,.14,1,1,"%D",0) = ^.101^2^2^3030826^^^ ^DD(399,.14,1,1,"%D",1,0) = This cross-reference sets the record into the nightly Data ^DD(399,.14,1,1,"%D",2,0) = Extract queue if it meets the criteria. ^DD(399,.14,1,1,"DT") = 3030826 ^DD(399,.14,3) = Enter the date of last status change. ^DD(399,.14,5,1,0) = 399^.13^1 ^DD(399,.14,21,0) = ^^1^1^2880831^ ^DD(399,.14,21,1,0) = This is the date of the last status change. ^DD(399,.14,"DT") = 3030826 This patch addresses the following New Service Request (NSR): ------------------------------------------------------------- Request 20030404 This patch addresses the following NOIS message(s): --------------------------------------------------- There are no NOIS messages associated with this patch. Overview of NOIS Message(s): ---------------------------- There are no NOIS messages associated with this patch. Test Sites: ----------- VISN 2 (DSM/VMS) Boston (DSM/VMS) Boise (Cache/VMS) Sioux Falls (Cache/NT) Hawaii (Cache/NT) ================INSTALLATION INSTRUCTIONS ================= If installed during the normal workday, it is recommended that the following selection(s) in the OPTION (#19) file, and all of their descendants be disabled to prevent possible conflicts while running the KIDS Install. Other VISTA users will not be affected. Any option that references the Bill/Claims File #399 [IB EDIT BILLING INFO] Install Time - less than 5 minutes 1. LOAD TRANSPORT GLOBAL --------------------- Choose the PackMan message containing this patch and invoke the INSTALL/CHECK MESSAGE PackMan option. 2. DISABLE ROUTINE MAPPING (DSM for Open VMS sites only) ----------------------- Disable routine mapping on all systems for the routines listed in step 3 below. NOTE: If the routines included in this patch are not currently in your mapped routine set, please skip this step. 3. COMPONENTS SENT WITH PATCH -------------------------- The following is a list of the routines included in this patch. The second line of each of these routines now looks like: ;;2.0;INTEGRATED BILLING;**[PATCH LIST,]233**;21-MAR-94 CHECK^XTSUMBLD results Routine Before Patch After Patch Patch List ------- ------------ ----------- ---------- IBJVDEQ N/A 3007835 233 Total number of routines - 1 The following is a list of fields included in this patch: Field Name (Number) File Name (Number) ------------------- ------------------ STATUS DATE (.14) BILL/CLAIMS (399) 4. 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: 5. Select Installation Option: --------------------------- NOTE: The following are OPTIONAL - (When prompted for the INSTALL NAME, enter IB*2.0*233): 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. 6. 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. 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 options: [IB EDIT BILLING INFO] e. When prompted 'Enter protocols you wish to mark as 'Out Of Order':' press . 7. REBUILD MAPPED ROUTINE(S) (DSM for Open VMS sites only) ------------------------- Optional - Include the routines distributed with this patch in the mapped routine set. NOTE: This step is only necessary if you performed step 2 or if you wish to include the routines in your mapped set. Routine Information: ==================== Routine Name: - IBJVDEQ Routine Checksum: ============================================================================= User Information: Entered By : MINARDI,CHRISTOPHER P Date Entered : JUL 23, 2003 Completed By: GOLDSMITH,JAMES H Date Completed: AUG 23, 2004 Released By : BATIE,NADINE Date Released : AUG 25, 2004 ============================================================================= Packman Mail Message: ===================== $END TXT