$TXT Created by ADES,ROBERT at MNTVBB.FO-ALBANY.MED.VA.GOV (KIDS) on Wednesday, 03/29/06 at 12:38 ============================================================================= Run Date: NOV 29, 2007 Designation: IB*2*165 Package : IB - INTEGRATED BILLING Priority: Mandatory Version : 2 SEQ #349 Status: Released Compliance Date: DEC 30, 2007 ============================================================================= Associated patches: (v)IB*2*118 <<= must be installed BEFORE `IB*2*165' Subject: BILLING LAG TIME REPORT MODIFICATIONS Category: - Routine Description: ============ This patch contains two modified Integrated Billing (IB) routines (IBJDB1, IBJDB11) that process and print the Billing Lag Time Report. Changes have been made to this report (as requested by the VHA CO Diagnostic Measures group). Associated Remedy ticket(s): ============================ 1. HD119316 BILLING LAG TIME REPORT MODIFICATIONS Also Original HD101370 BILLING LAG TIMES Duplicate HD170560 Lag time report discrepancy bdj Duplicate HD182393 Billing lag time is showing wrong check out date. Participating Test Sites: ========================= MARYLAND HCS PHOENIX, AZ TUCSON, AZ REMEDY OVERVIEW: ================ 1. HD119316 BILLING LAG TIME REPORT MODIFICATIONS ****Listed below are the issues resolved with this patch**** 1) Get most recent "Date of Check Out" ====================================== Problem ======= Currently the report is using the check out date of the last encounter to be checked in. However, the last encounter of the day may not have been the last encounter to be checked out. Resolution ========== Modified the software so it only keeps the check out date if it is greater than the previous date. This will ensure the most recent date is stored. 2) In determining "Date of Check Out" use only encounter clinics that match the clinic on the bill ===================================================================== Problem ======= When determining the check out date, it uses the bill encounter date to search through all encounters that day for that patient and return the last check out date. The problem is that it is sometimes using encounters that aren't related to the bill. Resolution ========== Use only encounters for clinics with procedures on the bill. This will screen out encounters not on the bill. 3) Exclude encounters checked out after the bill was Authorized =============================================================== Problem ======= The Central Business Office has determined that bill encounters that are checked out after the bill has been authorized should be excluded from the report. Resolution ========== Before using an encounter check out date, verify that it was checked out before the bill was authorized. In the case where the most recent check out date is after the bill was authorized, the last check out date before the bill was authorized will be used. 4) Get most recent "Date PTF Transmitted" ========================================= Problem ======= Currently the software gets the last date the Patient Treatment File (PTF) entry was "Released for Transmission", and using that date, it gets the date it was actually transmitted. The problem is that an earlier "Released for Transmission" date might have actually been transmitted more recently. Resolution ========== Modified the software to search through all of a PTF's entries "Released for Transmission" dates to find the most recent "Transmission Date". 5) Exclude PTF transmission dates that occur after the authorization date of the bill. ========================================================================= Problem ======= The Central Business Office has determined that the report will exclude PTF transmission dates that occur after the authorization of the bill. Resolution ========== Before using a PTF transmission date, verify it was transmitted before the bill was authorized. In the case where the most recent transmission date is after the bill was authorized, the last transmission date before the bill was authorized will be used. 6) Report Display ================= Problem ======= Currently when displaying a record with late insurance on the detailed report an "*" prints after the first date. Resolution ========== The Chief Business Office has determined the "*" should print after the bill number, not after the date. *********************************************************************** * NOTE: * * * * This report will not include encounters without check out dates. * * For Example, Lab and Radiology encounters have no actual check-out * * dates. * * * *********************************************************************** INSTALLATION INSTRUCTIONS: ========================== It is not necessary to disable any options. You may install these routines at any time without interruption to users. It should take less than 2 minutes to install this patch. 1. Choose the PackMan message containing this patch and invoke the INSTALL/CHECK MESSAGE PackMan option. 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 IB*2.0*165) a. Verify Checksums in Transport Global - This option will allow you to ensure the integrity of the routines that are in the transport global. b. Print Transport Global - This option will allow you to view the components of the KIDS build. c. 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.). d. 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. 4. Use the Install Package(s) option and select the package IB*2.0*165. 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 SUMMARY =============== 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]**;21-MAR-94 CHECK^XTSUMBLD results Routine Before After Patch List ======== ======== ======== ========== IBJDB1 8899886 8964551 69,80,100,118,165 IBJDB11 11112531 11700250 69,100,118,165 Number of Routines = 2 Routine Information: ==================== The checksums below are new checksums, and can be checked with CHECK1^XTSUMBLD. Routine Name: IBJDB1 Before: B26720805 After: B26861090 **69,80,100,118,165** Routine Name: IBJDB11 Before: B38226911 After: B43524742 **69,100,118,165** Routine list of preceding patches: 118 ============================================================================= User Information: Entered By : BATIE,RANDY Date Entered : OCT 24, 2001 Completed By: DAWSON,TIM Date Completed: NOV 19, 2007 Released By : GANUS,MAUNETTE Date Released : NOV 29, 2007 ============================================================================= Packman Mail Message: ===================== $END TXT