============================================================================= Run Date: OCT 06, 2005 Designation: GMPL*2*32 Package : GMPL - PROBLEM LIST Priority: Mandatory Version : 2 SEQ #29 Status: Released Compliance Date: NOV 06, 2005 ============================================================================= Subject: GMPL*2*31 INFORMATIONAL FOLLOW_UP Category: - Informational Description: ============ Included in patch GMPL*2*31 was a clean up routine GMPL31P. This routine searched out bad ICD9 (file 81) pointers in the PROBLEM LIST file and PROBLEM LIST AUDIT entries. For pointers that included the "~", the "~" was removed and the remaining value was left. If a "-1" was found the pointer to the default ICD9 code 799.99 was put in the place of the "-1". ASSOCIATED E3R(s): ================= N/A ASSOCIATED REMEDY: ================= HD102791 PARTICIPATING TEST SITES: ======================== Loma Linda,CA Huntington,WV North Florida/South Georgia PROBLEM: ========= The concern is the CLINICAL REMINDERS Index which contains the same ICD9 pointer from the PROBLEM LIST. If a pointer was bad in the PROBLEM LIST this index may not exist or may have the same bad pointer. Following is the Fileman description of the index shown in the .01 field of the PROBLEM LIST file description. RECORD INDEX: ACR (#506) MUMPS IR ACTION Short Descr: Clinical Reminders index for ICD9 lookup. Description: This cross-reference builds two indexes, one for finding all patients with a particular ICD9 code and one for finding all the ICD9 codes a patient has. The indexes are stored in the Clinical Reminders index global as: ^PXRMINDX(9000011,"ISPP",ICD9,STATUS,PRIORITY,DFN,DLM,DAS) ^PXRMINDX(9000011,"PSPI",DFN,STATUS,PRIORITY,ICD9,DLM,DAS) respectively. STATUS can be "A" for active or "I" for inactive. PRIORITY can be "A" for acute or "C" for chronic. If PRIORITY is missing then a "U" will be stored in the index. For Problems whose PRIORITY is "C" Clinical Reminders uses today's date for the date of the Problem. In all other cases Clinical Reminders uses DLM where DLM is the date last modified. When Problems are "removed" then CONDITION is set to "H" for hidden. Hidden Problems are not indexed. For all the details, see the Clinical Reminders Index Technical Guide/Programmer's Manual. SOLUTION: ========= If the routine GMPL31P found bad pointers; it is suggested that the OPTION PXRM INDEX MANAGEMENT / IB Clinical Reminders Index Build, function be used to re-index the PROBLEM LIST index only. It is also suggested that the function of re-building the index be done in off hours. Listed below is included an example of the Clinical Reminders Index build option for the Problem List index and a re-posting of the clean-up instructions which are alredy documented in GMPL*2*31. DAYT17>D ^XUP Setting up programmer environment This is a TEST account. Terminal Type set to: C-VT100 You have 1 new message. Select OPTION NAME: PXRM INDEX MANAGEMENT PXRM INDEX MANAGEMENT IB Clinical Reminders Index Build IC Clinical Reminders Index Count Select PXRM INDEX MANAGEMENT Option: IB Clinical Reminders Index Build Which indexes do you want to (re)build? 1 - LABORATORY TEST (CH, Anatomic Path, Micro) 2 - MENTAL HEALTH 3 - ORDER 4 - PTF 5 - PHARMACY PATIENT 6 - PRESCRIPTION 7 - PROBLEM LIST 8 - RADIOLOGY 9 - V CPT 10 - V EXAM 11 - V HEALTH FACTORS 12 - V IMMUNIZATION 13 - V PATIENT ED 14 - V POV 15 - V SKIN TEST 16 - VITAL MEASUREMENT Enter your list: (1-16): 7 Do you want this to be tasked? Y// NO Building indexes PROBLEM LIST There are 335579 entries to process.... Processing entry 33557... Processing entry 67114.... Processing entry 100671... Processing entry 134228... Processing entry 167785.... Processing entry 201342... Processing entry 234899... Processing entry 268456.... Processing entry 302013... Processing entry 335570 326096 PROBLEM LIST results indexed. Elapsed time: 33 secs IB Clinical Reminders Index Build IC Clinical Reminders Index Count CLEAN UP INSTRUCTIONS FROM GMPL*2*31: ====================================== A clean up post routine GMPL31P is included. It will loop through the Problem list looking for ICD-9 pointers which contain a "~" or "-1". In the case "~' it will be removed. In the case of a "-1", it will be updated to point to the ICD-9 799.99. The routine writes to the screen what was found and modified. Following is an example of the output: >D EN^GMPL31P THE FOLLOWING PROBLEM LIST ENTRIES CONTAINED BAD ICD9 POINTERS AND HAVE BEEN MODIFIED WITH A CORRECTED POINTER PROBLEM IEN BAD POINTER CORRECTED POINTER ___________ ___________ _______________ 242 -1 5570 246 -1 5570 248 -1 5570 249 1499~ 1499 252 1080~ 1080 256 -1~NO CODE SELECTED 5570 TOTAL ITEMS WORKED = 289 TOTAL ITEMS ADJUSTED = 6 THE FOLLOWING PROBLEM LIST AUDIT ENTRIES CONTAINED BAD ICD9 POINTERS AND HAVE BEEN MODIFIED WITH A CORRECTED POINTER PROBLEM IEN BAD POINTER CORRECTED POINTER ___________ ___________ _______________ 188947 -1~NO CODE SELECTED 5570 195624 8782~ 8782 196557 1202~ 1202 199860 8782~ 8782 203296 -1 5570 203298 -1 5570 203302 -1 5570 204601 8827~ 8827 215756 8815~ 8815 222388 8827~ 8827 TOTAL AUDIT ITEMS WORKED = 109 TOTAL AUDIT ITEMS ADJUSTED = 10 AN ITEM IEN MAY APPEAR UP TO 2 TIMES ONE FOR EACH BAD PIECE AS THE FIFTH AND SIXTH PIECES ARE CHECKED NOTE: This routine is not automatically deleted and can be kept as a IRM tool or not. Routine Information: ==================== No routines included. ============================================================================= User Information: Entered By : HARTIN,JAMES Date Entered : JUL 20, 2005 Completed By: ILUSTRISIMO,LUCY Date Completed: OCT 06, 2005 Released By : BELSCHWINDER,MICHAEL Date Released : OCT 06, 2005 ============================================================================= Packman Mail Message: ===================== No routines included