$TXT Created by HOLLOWAY,THOMAS J at MNTVBB.FO-ALBANY.MED.VA.GOV (KIDS) on Wednesday, 09/20/06 at 16:44 ============================================================================= Run Date: MAR 20, 2007 Designation: IB*2*356 Package : IB - INTEGRATED BILLING Priority: Mandatory Version : 2 SEQ #331 Status: Released Compliance Date: APR 20, 2007 ============================================================================= Associated patches: (v)IB*2*133 <<= must be installed BEFORE `IB*2*356' (v)IB*2*155 <<= must be installed BEFORE `IB*2*356' (v)IB*2*159 <<= must be installed BEFORE `IB*2*356' (v)IB*2*204 <<= must be installed BEFORE `IB*2*356' (v)IB*2*232 <<= must be installed BEFORE `IB*2*356' (v)IB*2*240 <<= must be installed BEFORE `IB*2*356' (v)IB*2*251 <<= must be installed BEFORE `IB*2*356' (v)IB*2*296 <<= must be installed BEFORE `IB*2*356' Subject: INTEGRATED BILLING MAINTENANCE UPDATE Q4-FY06 Category: - Routine - Data Dictionary Description: ============ This Integrated Billing Maintenance Update addresses 15 Remedy tickets representing 12 different issues. Each separate issue is described below. ASSOCIATED REMEDY TICKETS: ========================== 1) HD63676 - Non Providers Not Screened in Procedures Multiple 2) HD64317 - IB315 entry file 350.8/*232 3) HD64380 - Held Charges Report (PTH-1104-20448) 4) HD64425 - PROVIDER ID QUERY REPORT - TOTAL IS WRONG 5) HD64697 - ADD OUTSIDE LAB CHARGES TO MAP 6) HD64863 - IBJDF51 Spreadsheet (Trans # creates problem) 7) HD65904 - Problem with Miscellaneous Bills Follow-up Reports 8) HD117969 - CHAMPVA/TRICARE Follow-Up Report Detail vs. Summary problem 9) HD118376 - MRA Filing Error 123700 - Message storage errors on bill. 10) HD131138 - Missing Mail Group - CMOP transmissions fail. 11) HD134835 - Insurance Buffer Error 131701 - Error BR+1^DIE0 12) HD137911 - BULL1+5^IBTUBUL 145085 - Error Running Send Test Unbilled Amounts Bulletin option ASSOCIATED NSR(s): ================== N/A PARTICIPATING TEST SITES: ========================= BRONX, NY DUBLIN, GA MONTANA HCS REMEDY OVERVIEW: ================ 1) HD63676 Non Providers Not Screened in Procedures Multiple Problem: -------- The PROVIDER (#18) field in the PROCEDURES multiple (#399.0304) of the BILL/CLAIMS (#399) file points to the NEW PERSON (#200) file and allows selection of anyone in that file. If a user accidentally enters a non- provider in that field, the bill will not be paid and will have to be edited and resubmitted. Resolution: ----------- The data dictionary entry for the PROVIDER (#18) field will have a 'screen' applied which will limit acceptable entries to personnel who have been assigned a PERSON CLASS (#8932.1) field entry in the NEW PERSON (#200) file. The existence of the PERSON CLASS (#8932.1) field entry is an indicator that the person is a member of the medical staff. -------- -------------------- -------- 2) HD64317 IB315 entry file 350.8/*232 Problem: -------- The IB error code 'IB315' is no longer valid and was to be deleted from the IB ERROR (#350.8) file by patch IB*2.0*232. Due to a small oversight in that patch, the entry was not removed. This does not cause any actual problem in VistA but it is an extraneous entry in that file and might as well be cleaned up. Resolution: ----------- The pre-init routine will execute code which will delete the IB315 entry from the IB ERROR (#350.8) file. -------- -------------------- -------- 3) HD64380 Held Charges Report (PTH-1104-20448) Problem: -------- When a user runs the Held Charges Report [IB OUTPUT HELD CHARGES], requests that it be Queued for a later time, and indicates different printer parameters than the standard default for that printer, the output does not honor the parameter changes. Specifically, the printer is designated as an 80 character width device but the report requires 132 characters. Selecting the alternate width with a smaller font did not work if the report were queued. Resolution: ----------- The report program was not passing the alternate parameters to the queuing function. The routine IBOHLD1 is modified by this patch to pass three additional parameters - the terminal type, the margin width and the page length. -------- -------------------- -------- 4) HD64425 PROVIDER ID QUERY REPORT - TOTAL IS WRONG Problem: -------- When patch IB*2.0*232 was in development a special routine, ZQ232, was distributed to the sites to help clean up insurance data. Later, a slightly altered version of this function was released as option Provider ID Query [IBCE PROVIDER ID QUERY] using routine IBCEQ1. The new version has an incorrect value for TOTAL # OF ERRORS/WARNINGS: on the last page. The field always shows zero no matter how many errors were listed on the report although the earlier ZQ232 version had worked correctly. Resolution: ----------- The report program was missing a line of code to add up the errors and warnings. The code has been corrected and the summary now provides the same results as the ZQ232 version. -------- -------------------- -------- 5) HD64697 ADD OUTSIDE LAB CHARGES TO MAP Problem: -------- When patch IB*2.0*232 was being developed, a change was made to entry number 783 (TOTAL OUTSIDE LAB CHARGES) in the IB FORM SKELETON DEFINITION (#364.6) file to make the field no longer available for output on the 837 EDI extract for claims. This was an inadvertent change which needs to be fixed. The value for the CALCULATE ONLY OR OUTPUT (#.11) field should be changed from "CALCULATE ONLY" to "OUTPUT." Resolution: ----------- The pre-init routine will change the value of the CALCULATE ONLY OR OUTPUT (#.11) field in the designated record to "OUTPUT" as described above. -------- -------------------- -------- 6) HD64863 IBJDF51 Spreadsheet (Trans # creates problem) Problem: -------- When the number of entries in the AR TRANSACTION (#433) file exceeds 9,999,999 the CHAMPVA/TRICARE Follow-up Report no longer works correctly for the Excel spreadsheet version. Some records were being skipped. During the research on this issue it was discovered that a similar problem could exist in the FIRST PARTY FOLLOW-UP REPORT and in the MISCELLANEOUS BILLS FOLLOW-UP REPORT. Resolution: ----------- The routines which run the three reports mentioned above were modified to allow for 999,999,999 entries in the AR TRANSACTION file. -------- -------------------- -------- 7) HD65904 Problem with Miscellaneous Bills Follow-up Reports Problem: -------- When running the Miscellaneous Bills Follow-up Report [IBJD FOLLOW-UP MISC BILLS] a user noted that some bills were showing up in the wrong division when the report was sorted by Division. Resolution: ----------- An analysis of the code in routine IBJDF61 showed that the wrong function was being called to determine Division. A different function is available that returns the correct division in this situation. The report has been modified to use this alternate function ($$DIV^IBJDF51). -------- -------------------- -------- 8) HD117969 CHAMPVA/TRICARE Follow-Up Report Detail vs. Summary problem Problem: -------- It has been noticed that the summary section of the CHAMPVA/TRICARE Follow-up Report [IBJD FOLLOW-UP CHAMPVA/TRICARE] does not always include all of the detail lines when choosing the SHARING AGREEMENTS Detail version. The Summary lists the correct number of included records but not all of the detail lines were printed. Resolution: ----------- A small problem in the code was allowing the records to be totalled for the summary but causing some to be skipped in the printing process. This has been corrected and all of the detail lines that make up the totals are now printed. -------- -------------------- -------- 9) HD118376 - MRA Filing Error HD123700 - Message storage errors on bill. (Duplicate) Problem: -------- The application is assuming that the number of 'units' is coming in on the MRA 835 for anesthesia claims when, in fact, the number of 'minutes' is being returned. This change happened in late 2005 when Emdeon started sending the minutes to TrailBlazer in the claim. MRA's for anesthesia claims have not been able to be filed correctly since that time. Resolution: ----------- This patch will modify code in the routine IBCEOB1 to find matches using the anesthesia minutes in addition to the existing check using the number of units. Previously this routine was trying to match up number of units with the anesthesia minutes. -------- -------------------- -------- 10) HD131138 Missing Mail Group - CMOP transmissions fail. Problem: -------- A CMOP transmission failure can occur if the IB SITE PARAMETERS (#350.9) file is not configured correctly. The problem occurs if the USER ALERTS (#.14) field is set to YES, and the COPAY BACKGROUND ERROR GROUP (#.09) and COPAY EXEMPTION MAIL GROUP (#.13) fields are left blank. Resolution: ----------- This patch adds code that will default to the IB EDI SUPERVISOR mail group if the two COPAY groups mentioned above are left blank. This will provide a valid mail group and the CMOP transmissions will not fail. -------- -------------------- -------- 11) HD134835 Insurance Buffer Error. HD131701 Error BR+1^DIE0 (Duplicate) Problem: -------- Error generated when processing the Insurance Buffer. When using the Patient Policy Edit protocol and using the "^" to jump down to the Subscriber ID field the following error is generated: BR+1^DIE0. Resolution: ----------- The DIE call in the routine IBCNBEE will be modified to disallow "^" forward jumping. The jump was bypassing the setting of some required values and resulted in an error. The "^" will still be allowed for use to back out or exit. -------- -------------------- -------- 12) HD137911 BULL1+5^IBTUBUL HD145085 Error Running Send Test Unbilled Amounts Bulletin (Duplicate) Problem: -------- When users try to run the Send Test Unbilled Amounts Bulletin [IBT SEND TEST UNBILLED MESS] option they get an type error. Patch IB*2.0*155 added several new lines of data to the regular Unbilled Amounts Bulletin but did not add those same lines to the test version of that bulletin. Resolution: ----------- Several new variables needed to be initialized in routine IBTUBUL in order for the test version of the bulletin to supply the required data to the bulletin printing function. The test version will now match the real version line for line. -------- -------------------- -------- =================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. PCMM Team/Position Wait List (Sch/PCMM) Report [SD WAIT LIST PRM CARE/TEAM] Held Charges Report [IB OUTPUT HELD CHARGES] Provider ID Query [IBCE PROVIDER ID QUERY] CHAMPVA/TRICARE Follow-Up Report [IBJD FOLLOW-UP CHAMPVA/TRICARE] First Party Follow-Up Report [IBJD FOLLOW-UP FIRST PARTY] Miscellaneous Bills Follow-Up Report [IBJD FOLLOW-UP MISC BILLS] Send Test Unbilled Amounts Bulletin [IBT SEND TEST UNBILLED MESS] This patch can be installed with users on the system but since some items will be out of order, it is recommended that it be queued for non-peak hours. 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. 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 IB*2.0*356): 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. 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 (unless otherwise indicated) d. When prompted 'Enter options you wish to mark as 'Out Of Order':' Enter the following options: PCMM Team/Position Wait List (Sch/PCMM) Report [SD WAIT LIST PRM CARE/TEAM] Held Charges Report [IB OUTPUT HELD CHARGES] Provider ID Query [IBCE PROVIDER ID QUERY] CHAMPVA/TRICARE Follow-Up Report [IBJD FOLLOW-UP CHAMPVA/TRICARE] First Party Follow-Up Report [IBJD FOLLOW-UP FIRST PARTY] Miscellaneous Bills Follow-Up Report [IBJD FOLLOW-UP MISC BILLS] Send Test Unbilled Amounts Bulletin [IBT SEND TEST UNBILLED MESS] e. When prompted 'Enter protocols you wish to mark as 'Out Of Order':' press . ========================= INSTALLATION EXAMPLE =========================== Select INSTALL NAME: IB*2.0*356 Loaded from Distribution 9/20/06@15:55:58 => IB*2*356 This Distribution was loaded on Sep 20, 2006@15:55:58 with header of IB*2*356 It consisted of the following Install(s): IB*2.0*356 Checking Install for Package IB*2.0*356 Install Questions for IB*2.0*356 Incoming Files: 399 BILL/CLAIMS (Partial Definition) Note: You already have the 'BILL/CLAIMS' File. Want KIDS to INHIBIT LOGONs during the install? YES// NO Want to DISABLE Scheduled Options, Menu Options, and Protocols? YES// Enter options you wish to mark as 'Out Of Order': SD WAIT LIST PRM CARE/TEAM PCMM Team/Position Wait List (Sch/PCMM) Report Enter options you wish to mark as 'Out Of Order': Held Charges Report IB OUTPUT HELD CHARGES Held Charges Report Enter options you wish to mark as 'Out Of Order': IBCE PROVIDER ID QUERY P rovider ID Query Enter options you wish to mark as 'Out Of Order': IBJD FOLLOW-UP CHAMPVA/TRICARE Enter options you wish to mark as 'Out Of Order': IBJD FOLLOW-UP FIRST PARTY Enter options you wish to mark as 'Out Of Order': IBJD FOLLOW-UP MISC BILLS Enter options you wish to mark as 'Out Of Order': IBT SEND TEST UNBILLED MESS Send Test Unbilled Amounts Bulletin 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// TCP Install Started for IB*2.0*356 : Sep 20, 2006@16:01:19 Build Distribution Date: Sep 20, 2006 Installing Routines: Sep 20, 2006@16:01:19 Running Pre-Install Routine: EN^IB20P356 Deleting entry IB315 from IB ERROR file... IB315 error code removal complete. TOTAL OUTSIDE LAB CHARGES changing from CALCULATE ONLY to OUTPUT... TOTAL OUTSIDE LAB CHARGES change complete. Installing Data Dictionaries: . Sep 20, 2006@16:01:20 Updating Routine file... The following Routines were created during this install: IBXX IBXX1 IBXX10 IBXX11 IBXX12 IBXX13 IBXX14 IBXX15 IBXX16 IBXX17 IBXX18 IBXX19 IBXX2 IBXX20 IBXX21 IBXX22 IBXX23 IBXX24 IB*2.0*356 -------------------------------------------------------------------------------- IBXX25 IBXX26 IBXX27 IBXX28 IBXX3 IBXX4 IBXX5 IBXX6 IBXX7 IBXX8 IBXX9 Updating KIDS files... IB*2.0*356 Installed. Sep 20, 2006@16:01:21 Install Message sent #449533 -------------------------------------------------------------------------------- +------------------------------------------------------------+ 100% | 25 50 75 | Complete +------------------------------------------------------------+ Install Completed ========================================================================== 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]**;21-MAR-94 CHECK^XTSUMBLD results Routine Before Patch After Patch Patch List ------- ------------ ----------- ---------- IB20P356 N/A 845599 356 IBAERR3 9712468 9365677 356 IBCEOB1 17505231 17344051 137,135,155,296,356 IBCEQ1 9869244 10101189 232,356 IBCNBEE 14784093 14789132 82,184,252,251,356 IBJDF41 12829433 13035260 123,159,204,356 IBJDF51 12048274 12254122 123,185,240,356 IBJDF61 13428105 13637974 123,159,356 IBOHLD1 7174257 6315947 70,95,133,356 IBTUBUL 8852618 9064573 19,123,159,217,155,356 Total number of routines in patch: 10 Total number of modified routines: 9 Total number of new routines: 1 (IB20P356) Total number of deleted routines: 1 (IB20P356) The following is a list of fields included in this patch: Field Name (Number) Sub-File Name (Number) File Name (Number) ------------------- ---------------------- ------------------- PROVIDER (#18) |TAB|PROCEDURES (#399.0304) BILL/CLAIMS (#399) Routine Information: ==================== The checksums below are new checksums, and can be checked with CHECK1^XTSUMBLD. Routine Name: IB20P356 Before: n/a After: B1227219 **356** Routine Name: IBAERR3 Before: B25240845 After: B26662158 **356** Routine Name: IBCEOB1 Before: B67354030 After: B69145687 **137,135,155,296,356** Routine Name: IBCEQ1 Before: B30063077 After: B30688756 **232,356** Routine Name: IBCNBEE Before: B44049904 After: B44406839 **82,184,252,251,356** Routine Name: IBJDF41 Before: B64450752 After: B65120113 **123,159,204,356** Routine Name: IBJDF51 Before: B57252873 After: B57917669 **123,185,240,356** Routine Name: IBJDF61 Before: B54417699 After: B55100419 **123,159,356** Routine Name: IBOHLD1 Before: B18759714 After: B19222210 **70,95,133,356** Routine Name: IBTUBUL Before: B20146388 After: B21781134 **19,123,159,217,155,356** ============================================================================= User Information: Entered By : HOLLOWAY,THOMAS J Date Entered : JUL 12, 2006 Completed By: DAWSON,TIM Date Completed: MAR 20, 2007 Released By : BOTTINI,STEVE Date Released : MAR 20, 2007 ============================================================================= Packman Mail Message: ===================== $END TXT