$TXT Created by BECKWITH,RALPH at DEV.DEV.FO-HINES.MED.VA.GOV (KIDS) on Tuesday, 06/20/06 at 09:50 ============================================================================= Run Date: JUN 27, 2006 Designation: RMPR*3*124 Package : RMPR - PROSTHETICS Priority: Mandatory Version : 3 SEQ #98 Status: Released Compliance Date: JUL 28, 2006 ============================================================================= Subject: FILE 660 AND 664 DD NON-COMPLIANT FIELD LENGTH CLEANUP UTILITIES Category: - Routine Description: ============ DESCRIPTION: =========== Prosthetics GUI not adhering to Fileman Data Dictionary parameter length guidelines in RECORD OF PROS APPLIANCE/REPAIR (# 660) file for REMARKS (#16) field, LOT NUMBER (#21) field and DELIVER TO (#25) field as well as PROSTHETICS 1358 (# 664) file for fields: BRIEF DESCRIPTION (#02,1) field, REMARKS (#02,7) field, SERIAL NUMBER (#02,15) field, MANUFACTURER (#02,15.2) field, MODEL (#02,15.4) field, LOT #(#02,15.6) field, DELIVER TO (#19) field and DELIVER TO ATTENTION (#21.1) field. The data length is too large and is causing mail group messaging of Purchase Order information to error. This is preventing National Prosthetics Patient Database (NPPD) roll-up. ** A national alert was sent to all the Prosthetics sites warning them of this situation in GUI Purchasing to remind the user to stay within the field length constraints until a GUI patch is released controlling the data entry. ASSOCIATED E3R(s): ================= N/A ASSOCIATED REMEDY CALLS: ======================= HD126389 - HQ not receiving NPPD data due to corrupt RMPR Duplicates: HD126667 - Prosthetics GUI not adhering to FM DD HD127372 - HQ not receiving NPPD data due to corrupt RMPR TEST SITES: ========== Illiana HCS S. Texas HCS Ann Arbor, MI REMEDY OVERVIEW: ================ HD126389 - HQ not receiving NPPD data due to corrupt RMPR Duplicates: HD126667, HD127372) Problem: -------- Prosthetics GUI not adhering to Fileman Data Dictionary parameter length guidelines in RECORD OF PROS APPLIANCE/REPAIR (#660) file for REMARKS (#16) field, LOT NUMBER (#21) field, DELIVER TO (#25) field as well as PROSTHETICS 1358 (#664) file for BRIEF DESCRIPTION (#02,1) field, REMARKS (#02,7) field, SERIAL NUMBER (#02,15) field, MANUFACTURER (#02,15.2) field, MODEL (#02,15.4) field, LOT #(#02,15.6) field, DELIVER TO (#19) field and DELIVER TO ATTENTION (#21.1) field. This has caused errors in mail group messaging of Purchase Order information due to field length errors and preventing national NPPD roll-up. Resolution: ----------- This patch will create an option that will search and display fields in RECORD OF PROS APPLIANCE/REPAIR (#660) file and PROSTHETICS 1358 (#664) file that have a length error created by the GUI Purchase Order process. The new option added to the RMPR UTILITIES [UT Utilities] menu: [FCLN RMPR file cleansing for field lengths] This option will allow for ongoing cleansing until the GUI patch (RMPR*3*75) is completed to resolve the data length errors. Processing Instructions: ================== The option will compile using PROSTHETICS 1358 (#664) file, looking through each order/item for any field that exceeds the defined Vista Fileman length requirement. The 2nd process will allow a report by clerk to be printed for any field length errors. The 3rd process will allow entry of an internal key to find/display/correct associated field length errors. See example below of compile, print and error correction: Select OPTION NAME: RMPR OFFICIAL Prosthetic Official's Menu PU Purchasing ... DD Display/Print ... UT Utilities ... AM AMIS ... SU Suspense ... CO Correspondence ... SC Scheduled Meetings and Home/Liaison Visits ... PS Process Form 2529-3 ... EL Eligibility Inquiry ET PSC/Entitlement Records ... HO Home Oxygen Main Menu ... INV Pros Inventory Main ... ND NPPD Tools ... OC CoreFLS Order Control VR VERIFY/REPAIR PURCHASE CARD NUMBER Select Prosthetic Official's Menu Option: UT Utilities AP Add/Edit Patient to Prosthetics DIS Enter Prosthetic Disability Code to 2319 REM Delete Prosthetic Disability Code from 2319 EN Enter/Edit Prosthetic Item Master IF IFCAP Utilities ... PGE Purge Obsolete Data ... RC Flag Item as Returned/Condemned RE Edit Returned/Condemned Item FCLN RMPR file cleansing for field lengths SP Enter/Edit Site Parameters ... WD Display Prosthetic PO Information Select Utilities Option: FC RMPR file cleansing for field lengths ** THIS TEMPORARY PROCESS HAS BEEN PUT IN PLACE TO SCRUB (VIA USER ** ** INTERACTION) ANY FIELDS IN FILE #664 AND FILE#660 THAT MAY HAVE ** ** A FIELD LENGTH ERROR CAUSED BY THE GUI PROSTHETICS PURCHASING ** ** MODULE WHICH WAS ALLOWING DATA OUTSIDE THE FIELD DEFINED LENGTH ** ** LIMITATIONS. ** WANT TO PROCEED WITH CLEANSING PROCESS? Yes// (Yes) Select one of the following: 1 COMPILE LENGTH ERRORS 2 PRINT LENGTH ERROR REPORT 3 FIX LENGTH ERRORS Enter response: 1 COMPILE LENGTH ERRORS Last Build completed on MAR 12, 2006@16:24:17 This build contains 1 nodes to be fixed, 26 field length errors Do you wish to continue with NEW Build? ? NO// YES Requested Start Time: NOW// (MAR 13, 2006@06:27:37) Request Queued! Enter RETURN to continue: ** The user will get following mail message when compile complete: Subj: RMPR field length error cleanup...Build Completed.. [#132724] 03/13/06@06:27 2 lines From: POSTMASTER In 'IN' basket. Page 1 *New* -------------------------------------------------------------------------- ----- Compile for RMPR field length errors is complete and ready to report & fix. Start time: MAR 13, 2006@06:27:37 End time: MAR 13, 2006@06:28:17 AP Add/Edit Patient to Prosthetics DIS Enter Prosthetic Disability Code to 2319 REM Delete Prosthetic Disability Code from 2319 EN Enter/Edit Prosthetic Item Master IF IFCAP Utilities ... PGE Purge Obsolete Data ... RC Flag Item as Returned/Condemned RE Edit Returned/Condemned Item FCLN RMPR file cleansing for field lengths SP Enter/Edit Site Parameters ... WD Display Prosthetic PO Information Select Utilities Option: FC RMPR file cleansing for field lengths ** THIS TEMPORARY PROCESS HAS BEEN PUT IN PLACE TO SCRUB (VIA USER ** ** INTERACTION) ANY FIELDS IN FILE #664 AND FILE#660 THAT MAY HAVE ** ** A FIELD LENGTH ERROR CAUSED BY THE GUI PROSTHETICS PURCHASING ** ** MODULE WHICH WAS ALLOWING DATA OUTSIDE THE FIELD DEFINED LENGTH ** ** LIMITATIONS. ** WANT TO PROCEED WITH CLEANSING PROCESS? Yes// (Yes) Select one of the following: 1 COMPILE LENGTH ERRORS 2 PRINT LENGTH ERROR REPORT 3 FIX LENGTH ERRORS Enter response: 2 PRINT LENGTH ERROR REPORT DEVICE: HOME// TELNET ** or can be queued! File 664/660 Field Length Errors Page 1 Originator=>> PROSuser, One IEN Patient Name IFCAP ORDER 452 PROSpatient, One 499-A20012 Field: 660-16 (Remarks) Origin: *SHIPPING* LINK MIN: 0 MAX: 61 ERR LGTH: 374 0/1141 DATA: THIS IS A TEST OF THE WAY A LARGE DESCRIPTOR WILL BE HANDLED IF IT IS SENT FROM THE GUI PROCESS AND IS VERY LONG AND DOES NOT FIT THE PARAME TERS OF THE FIELD, HENCE WE WILL HAVE TO WORK AT MODIFYING THE DESCRIP TIONS THAT HAVE BEEN PLACES INCORRECTLYXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXX Field: 660-21 (Lot #) Origin: *SHIPPING* LINK MIN: 0 MAX: 20 ERR LGTH: 374 0/1141 Enter RETURN to continue or '^' to exit: File 664/660 Field Length Errors Page 2 Originator=>> PROSuser, One IEN Patient Name IFCAP ORDER 452 PROSpatient, One 499-A20012 DATA: THIS IS A TEST OF THE WAY A LARGE DESCRIPTOR WILL BE HANDLED IF IT IS SENT FROM THE GUI PROCESS AND IS VERY LONG AND DOES NOT FIT THE PARAME TERS OF THE FIELD, HENCE WE WILL HAVE TO WORK AT MODIFYING THE DESCRIP TIONS THAT HAVE BEEN PLACES INCORRECTLYXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXX Field: 660-24 (Brief Description) Origin: *SHIPPING* LINK MIN: 3 MAX: 60 ERR LGTH: 374 0/1141 DATA: THIS IS A TEST OF THE WAY A LARGE DESCRIPTOR WILL BE HANDLED IF IT IS SENT FROM THE GUI PROCESS AND IS VERY LONG AND DOES NOT FIT THE PARAME TERS OF THE FIELD, HENCE WE WILL HAVE TO WORK AT MODIFYING THE DESCRIP TIONS THAT HAVE BEEN PLACES INCORRECTLYXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX Enter RETURN to continue or '^' to exit: File 664/660 Field Length Errors Page 3 Originator=>> PROSuser, One IEN Patient Name IFCAP ORDER 452 PROSpatient, One 499-A20012 XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXX Field: 660-9 (Serial #) Origin: *SHIPPING* LINK MIN: 0 MAX: 20 ERR LGTH: 374 0/1141 DATA: THIS IS A TEST OF THE WAY A LARGE DESCRIPTOR WILL BE HANDLED IF IT IS SENT FROM THE GUI PROCESS AND IS VERY LONG AND DOES NOT FIT THE PARAME TERS OF THE FIELD, HENCE WE WILL HAVE TO WORK AT MODIFYING THE DESCRIP TIONS THAT HAVE BEEN PLACES INCORRECTLYXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXX Enter RETURN to continue or '^' to exit: File 664/660 Field Length Errors Page 4 Originator=>> PROSuser, One IEN Patient Name IFCAP ORDER 452 PROSpatient, One 499-A20012 Field: 660-91 (Manufacturer) Origin: *SHIPPING* LINK MIN: 0 MAX: 55 ERR LGTH: 374 0/1141 DATA: THIS IS A TEST OF THE WAY A LARGE DESCRIPTOR WILL BE HANDLED IF IT IS SENT FROM THE GUI PROCESS AND IS VERY LONG AND DOES NOT FIT THE PARAME TERS OF THE FIELD, HENCE WE WILL HAVE TO WORK AT MODIFYING THE DESCRIP TIONS THAT HAVE BEEN PLACES INCORRECTLYXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXX Field: 660-92 (Model) Origin: *SHIPPING* LINK MIN: 0 MAX: 55 ERR LGTH: 374 0/1141 Enter RETURN to continue or '^' to exit: ^ AP Add/Edit Patient to Prosthetics DIS Enter Prosthetic Disability Code to 2319 REM Delete Prosthetic Disability Code from 2319 EN Enter/Edit Prosthetic Item Master IF IFCAP Utilities ... PGE Purge Obsolete Data ... RC Flag Item as Returned/Condemned RE Edit Returned/Condemned Item FCLN RMPR file cleansing for field lengths SP Enter/Edit Site Parameters ... WD Display Prosthetic PO Information Select Utilities Option: FC RMPR file cleansing for field lengths ** THIS TEMPORARY PROCESS HAS BEEN PUT IN PLACE TO SCRUB (VIA USER ** ** INTERACTION) ANY FIELDS IN FILE #664 AND FILE#660 THAT MAY HAVE ** ** A FIELD LENGTH ERROR CAUSED BY THE GUI PROSTHETICS PURCHASING ** ** MODULE WHICH WAS ALLOWING DATA OUTSIDE THE FIELD DEFINED LENGTH ** ** LIMITATIONS. ** WANT TO PROCEED WITH CLEANSING PROCESS? Yes// (Yes) Select one of the following: 1 COMPILE LENGTH ERRORS 2 PRINT LENGTH ERROR REPORT 3 FIX LENGTH ERRORS Enter response: 3 FIX LENGTH ERRORS Enter record identifier from build list to be corrected RECORD IDENTIFIER: 452 452 / 1141 PCN: 1P1234 ITEM: *SHIPPING* LINK 1141 660-24 (Brief Description) THIS IS A TEST OF THE WAY A LARGE DESCRIPTOR WILL BE HANDLED IF IT IS SENT FROM THE GUI PROCESS AND IS VERY LONG AND DOES NOT FIT THE PARAMETERS OF THE FIELD, H ENCE WE WILL HAVE TO WORK AT MODIFYING THE DESCRIPTIONS THAT HAVE BEEN PLACES IN CORRECTLYXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX Field length must be 3-60 characters in length (Pros/Appliance Repair) Brief Description: BRIEF DESCRIPTION 1141 660-16 (Remarks) THIS IS A TEST OF THE WAY A LARGE DESCRIPTOR WILL BE HANDLED IF IT IS SENT FROM THE GUI PROCESS AND IS VERY LONG AND DOES NOT FIT THE PARAMETERS OF THE FIELD, H ENCE WE WILL HAVE TO WORK AT MODIFYING THE DESCRIPTIONS THAT HAVE BEEN PLACES IN CORRECTLYXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX Field length cannot exceed 61 characters (Pros/Appliance Repair) Remarks: ^ ** correct all/partial length errors ** REPAIR PROCESS TERMINATED BY USER ** < 1 FIELD LENGTH ERRORS CORRECTED > INSTALLATION INSTRUCTION: ======================== This patch was created with Kernel V8 KIDS and should be installed into your production UCI. It can be installed anytime and with users on the system. Complete installation will take 5 minutes or less. Installation procedures are the same for Cache. Follow these instructions: 1. Choose the PackMan message containing this patch and invoke the INSTALL/CHECK MESSAGE PackMan option. 2. On the KIDS menu, under the 'Installation' menu, use the option 'Verify Checksum in Transport Global' and verify that all routines have the correct checksums. 3. From the 'Installation' menu of KIDS, user the option 'Install Package(s)'. Select the package 'RMPR*3.0*124 and proceed with the install. 4. You may queue this patch for install. 5. When prompted 'Want KIDS to Rebuild Menu Trees Upon Completion of Install? YES//', respond NO. 6. When prompted 'Want KIDS to INHIBIT LOGONs during the install? YES//', respond NO. 7. When prompted 'Want to DISABLE Schedule Options, Menu Options and Protocols? YES//', respond NO. Routine Summary: =============== The following routines are included in this patch. The second line of the routines will look like: ;;3.0;PROSTHETICS;**[patch list]**;06/20/05 CHECK^XTSUMBLD results Routine Before Patch After Patch Patch List ------- ------------ ----------- ------------ RMPR124P **NEW** 8509308 124 RMPRFFIX **NEW** 14785147 124 RMPRFPRT **NEW** 3272898 124 Routine Information: ==================== The checksums below are new checksums, and can be checked with CHECK1^XTSUMBLD. Routine Name: RMPR124P Before: n/a After: B21830969 **124** Routine Name: RMPRFFIX Before: n/a After: B33824281 **124** Routine Name: RMPRFPRT Before: n/a After: B6320218 **124** ============================================================================= User Information: Entered By : BECKWITH,RALPH Date Entered : JAN 12, 2006 Completed By: TSAIMEUCHONG,BRENDA Date Completed: JUN 20, 2006 Released By : DIETRICH,JON Date Released : JUN 27, 2006 ============================================================================= Packman Mail Message: ===================== $END TXT