$TXT Created by ROWLANDS,ELMER at MNTVBB.FO-ALBANY.MED.VA.GOV (KIDS) on Thursday, 07/06/06 at 08:46 ============================================================================= Run Date: OCT 05, 2006 Designation: TIU*1*214 Package : TIU - TEXT INTEGRATION UTILITIES Priority: Mandatory Version : 1 SEQ #203 Status: Released Compliance Date: NOV 05, 2006 ============================================================================= Subject: REPORT OF MIS-MATCHED ID NOTES Category: - Routine Description: ============ This patch contains a routine that will Report/Fix Mis-matched ID notes. There are cases where a child ID note points to a parent ID and that parent ID note is for a different patient or do not exist. There are also cases where the "GDAD" cross reference links a child ID note to a parent ID note when in fact the child does not point to the parent. The report will also show child id notes that point to a note that may not be a parent ID. The cause of these situations is being addressed in patch TIU*1.0*217. The new routine will be found as option TIU MISMATCHED ID NOTES under the option TIU MAIN MENU MGR. When this report is run in either Report Only or in Report and Fix mode, an email will be sent to the PSI-06-030 mail group on Forum every time the option is accessed. This email message will print the Site, Date/Time, Report mode and results. No patient data of any kind is sent. The main purpose of the mail message is to track the extent of this problem. The child notes that point to a parent that is not a parent ID will not be included in these emails. ASSOCIATED NSR(S): ================= N/A ASSOCIATED REMEDY: ================== HD115818 - POC: TIM STRUNA 540-982-2463, X 2674..RESPIRATORY THERAPY NOTES (PARENT/CHILD NOTES) CROSSING OVER INTO OTHER PATIENT RECORDS. HD132342 - Need to unlink old interdisc notes from a parent title. Not sure how the notes got there. PARTICIPATING TEST SITES: ========================= Mountain Home,TN Palo Alto,CA Portland,OR San Diego,CA REMEDY OVERVIEW: =============== Problem: There are rare cases where a child ID note can point to a parent ID note for a different patient. There are also cases where the "GDAD" cross reference says a child ID note points to a parent ID note when in fact it does not. Solution: The root cause of the problem is being addressed in patch TIU*1.0*217. In the interim this patch contains a routine that will report on and clean up ID notes in the above cases. The link will be broken, the bad cross references deleted and a report will be generated. A list of child notes that point to a parent that may not be a parent ID note will also be generated, but it is informational for investigation and nothing will be done automatically. EXAMPLE OF REPORT ONLY: ----------------------- MISMATCHED INTERDISCIPLINARY NOTES CHILD DOCUMENT PARENT DOCUMENT --------------- -------------- Patient: TIUpatient,One (P1234) TIUpatient,Two (P5678) Title: INTERDISCIPLINARY PATIENT EDUCATI PM&R KT Entry DT: JAN 21, 1998@15:28:27 FEB 01, 1996@14:16:10 Author: LASTNANE,FIRSTNAME LASTNAME,FIRSTNAME Note IEN: 345678 123456 CHILD ID NOTES POINTING TO A NON-EXISTENT PARENT ID NOTE Patient: TIUpatient,Three (P9876) Title: CARDIAC REHAB DAILY Entry DT: APR 28, 2003@07:43:49 Author: LASTNAME,FIRSTNAME Child IEN: 3300852 Parent IEN: 3200408 CHILD ID NOTES POINTING TO A PARENT THAT MAY NOT BE AN ID NOTE ** NOTE: THIS IS AN INFORMATIONAL LIST FOR INVESTIGATION. NOTHING WILL BE FIXED ** Patient: TIUpatient,Nine (P5203) Parent Title: TELEPHONE CONTACT-IEN: 1734508 Parent Entry DT: JUN 23, 2006@09:29:35 Parent Author: FIRSTNAME,LASTNAME Child Title: ECU ADL SELF CARE PERFORMANCE SUMMARY-IEN: 1734509 TOTAL COUNTS FOR MISMATCHED ID NOTES ------------------------------------ 1173 CROSS REFERENCES CHECKED 1 MISS MATCHED NOTE(S) FOUND 1 NON EXISTENT PARENT NOTE(S) 1 PARENT MAY NOT BE AN ID NOTE EXAMPLE OF REPORT WITH FIX: --------------------------- MISMATCHED INTERDISCIPLINARY NOTES CHILD DOCUMENT PARENT DOCUMENT --------------- -------------- Patient: TIUpatient,One (P1234) TIUpatient,Two(P5678) Title: INTERDISCIPLINARY PATIENT EDUCATI PM&R KT Entry DT: JAN 21, 1998@15:28:27 FEB 01, 1996@14:16:10 Author: LASTNAME,FIRST NAME LASTNAME.FIRST NAME Note IEN: 345678 123456 ..... Removed pointer from child to parent. Patient: TIUpatient,Three (P4321) TIUpatient,Four (P8746) Title: PRIME CARE CLINIC PATIENT/FAMILY EDUCATION DOC Entry DT: FEB 04, 2003@10:33:48 Author: LASTNAME,FIRSTNAME Note IEN: 3100784 3000597 ... Child note did not point to parent. GDAD cross reference removed CHILD ID NOTES POINTING TO A NON-EXISTENT PARENT ID NOTE Patient: TIUpatient,One (P1234) Title: OTP DOSING NOTE Entry DT: APR 28, 2003@07:54:47 Author: LASTNAME,FIRSTNAME Child IEN: 3300864 Parent IEN: 3200349 ... Child note did not point to parent. GDAD cross reference removed. Patient: TIUpatient,Five (P4567) Title: PM&R PT DISCHARGE Entry DT: JAN 29, 2004@15:26:57 Author: LASTNAME,FIRSTNAME Child IEN: 4000224 Parent IEN: 4000522 ..... Removed pointer from child to parent removed. CHILD ID NOTES POINTING TO A PARENT THAT MAY NOT BE AN ID NOTE ** NOTE: THIS IS AN INFORMATIONAL LIST FOR INVESTIGATION. NOTHING WILL BE FIXED ** Patient: TIUpatient,Nine (P5203) Parent Title: TELEPHONE CONTACT-IEN: 1734508 Parent Entry DT: JUN 23, 2006@09:29:35 Parent Author: LASTNAME,FIRSTNAME Child Title: ECU ADL SELF CARE PERFORMANCE SUMMARY-IEN: 1734509 TOTAL COUNTS FOR MISMATCHED ID NOTES ------------------------------------ 1173 CROSS REFERENCES CHECKED 2 MISS MATCHED NOTE(S) FOUND 2 NON EXISTENT PARENT NOTE(S) 1 PARENT MAY NOT BE AN ID NOTE 1 POINTER(S) FIXED FOR MISMATCHED NOTES 1 XREF(S) FIXED FOR MISMATCHED NOTES 1 POINTER(S) FIXED FOR MISSING NOTES 1 XREF(S) FIXED FOR MISSING NOTES EXAMPLES OF EMAIL SENT TO PSI-06-030@FORUM.MED.GOV REPORT ONLY MODE: ----------------- 552^DAYTON MAR 31, 2006@15:24:09 1173 CROSS REFERENCES CHECKED 9 MISMATCHED NOTE(S) FOUND 7 NON EXISTENT PARENT NOTE(S) MODE - REPORT ONLY REPORT AND FIX MODE: -------------------- 552^DAYTON MAR 31, 2006@15:24:09 1173 CROSS REFERENCES CHECKED 9 MISMATCHED NOTE(S) FOUND 7 NON EXISTENT PARENT NOTE(S) MODE - REPORT AND FIX 5 POINTER(S) FIXED FOR MISMATCHED NOTES 4 XREF(S) FIXED FOR MISMATCHED NOTES 3 POINTER(S) FIXED FOR MISSING NOTES 4 XREF(S) FIXED FOR MISSING NOTES DOCUMENTATION DISTRIBUTION: =========================== Sites may retrieve the User Manual and Technical Manual directly via FTP (using BIN mode) from the ANONYMOUS.SOFTWARE directory at: Albany: ftp.fo-albany.med.va.gov Hines: ftp.fo-hines.med.va.gov Salt Lake City: ftp.fo-slc.med.va.gov Files available: tiutm.pdf tiuum.pdf The complete and updated manual will be posted to the VDL immediately after the release of the patch. INSTALLATION INSTRUCTIONS: ========================== This patch may be installed during working hours. Installation will take less than 5 minutes. Users do not have to be off the system 1. Use the INSTALL/CHECK MESSAGE option on the PackMan menu. [Note: TEXT PRINT/DISPLAY option in the PackMan menu still display the patch text only]. 2. From the Kernel Installation and Distribution System (KIDS) menu, select the Installation menu. 3. From this menu, you may elect to use the following options: (when prompted for INSTALL NAME enter TIU*1.0*214) a. Backup a Transport Global - this option will create a backup message of any routines exported with the patch. It will NOT backup any other changes such as DDs or templates. b. Compare Transport Global to Current System - this option will allow you to view all changes that will be made when the patch is installed. It compares all components of the patch (routines, DDs, 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. d. Print Transport Global - this option will allow you to view the components of the KIDS build. 4. Use the Install Package(s) option and select the package TIU*1.0*214. 5. If prompted: ' Want KIDS to Rebuild Menu Trees Upon Completion of Install? YES//' choose NO. 6. When prompted 'Want KIDS to INHIBIT LOGONs during the install? YES//', respond NO 7. When prompted 'Want to DISABLE Scheduled Options, Menu Options, and Protocols? YES//', respond NO. 8. 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// ROUTINE SUMMARY: ================ The following is a list of the routine(s) included in this patch. The second line of each of these routine(s) will look like: ;;1.0;Text Integration Utilities;**[patch list]**;Jun 20, 1997 CHECK^XTSUMBLD results Routine name Before Patch After Patch Patch List ============ ============ =========== ========== TIU214 N/A 18899801 214 Routine Information: ==================== The checksums below are new checksums, and can be checked with CHECK1^XTSUMBLD. Routine Name: TIU214 Before: n/a After: B79884250 **214** ============================================================================= User Information: Entered By : LUNDEN,JOHN Date Entered : MAR 09, 2006 Completed By: ILUSTRISIMO,LUCY Date Completed: SEP 27, 2006 Released By : BOYER,EDWARD Date Released : OCT 05, 2006 ============================================================================= Packman Mail Message: ===================== $END TXT