$TXT Created by BAKKE,ANDREW at DEVCUR.FO-SLC.MED.VA.GOV (KIDS) on Wednesday, 07/26/06 at 11:47 ============================================================================= Run Date: JUL 27, 2006 Designation: TIU*1*218 Package : TIU - TEXT INTEGRATION UTILITIES Priority: Mandatory Version : 1 SEQ #199 Status: Released Compliance Date: AUG 27, 2006 ============================================================================= Subject: TIU ACTIVE TITLE CLEANUP REPORT v2 Category: - Routine - Other Description: ============ This patch provides a report and automated cleanup utility to assist the Data Standardization's efforts to clean and standardize TIU Document Titles. TIU*1*218 is an enhancement to TIU*1*209 that clears up some confusion with the first version of the report. This version has a more detailed header and uses a VA FileMan Database Server (DBA) API to update file #8925.1 instead of a direct set of the global. *** If sites have already inactivated their unused document titles using *** TIU*1*209, this report does NOT need to be run again. This patch is an important precursor to TIU*1*211, which maps local document titles to Standard Titles in preparation for the upcoming unified Clinical Data Repository/Health Data Repository of computable patient data. Using this report and the automatic cleanup feature that comes with it will greatly simplify the work required for document title mapping. The report and cleanup utility will analyze the TIU DOCUMENT DEFINITION file (#8925.1) and provide an automated process to inactivate the appropriate TIU titles. Details for invoking the routine and option associated with this patch can be found in the post-installation instructions below. Option: ====== There is one new option being exported with this patch. It will be attached to the TIU Maintenance Menu [TIU IRM MAINTENANCE MENU]: Active Title Cleanup Report [TIU ACTIVE TITLE CLEANUP] Associated Remedy Tickets: ========================= HD0000000144884 HD0000000144315 HD0000000144022 HD0000000143911 HD0000000143657 HD0000000143656 HD0000000143189 HD0000000143052 HD0000000142729 HD0000000142170 HD0000000141846 HD0000000141769 HD0000000141209 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 ============ ============ =========== ========== TIUPS209 19354820 23418182 209,218 Documentation: ============== The TIU Technical Manual has been updated to reflect the enhancements provided by this patch. The updated documentation is available in the form of a (.PDF) file, as follows: TIUTM.PDF TIU Technical Manual This file can be retrieved in BINARY format by FTP. The preferred method is to FTP the files from download.vista.med.va.gov which will transmit the files from the first available FTP server. The files may also be downloaded directly from a particular FTP location at the following locations: CIO FIELD OFFICE FTP ADDRESS DIRECTORY ---------------- ------------------------- -------------------- Albany ftp.fo-albany.med.va.gov [anonymous.software] Hines ftp.fo-hines.med.va.gov [anonymous.software] Salt Lake City ftp.fo-slc.med.va.gov [anonymous.software] The documentation can also be found on the System Design and Development Web page: (http://www.va.gov/vdl). Installation Instructions: ========================= This patch may be installed with users on the system; however, it should be installed at a non-peak time to minimize disruption to the users. Installation of this patch should take less than 1 minute. 1. Use the INSTALL/CHECK MESSAGE option on the Packman Menu. 2. From the Kernel Installation and Distribution System (KIDS) Menu, select the Installation menu. 3. From the Installation menu, you may select to use the following options (when prompted for INSTALL NAME, enter TIU*1.0*218): a. Backup a Transport Global b. Compare Transport Global to Current System c. Verify Checksums in Transport Global 4. Use the Install Package(s) option and select the package TIU*1.0*218. 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 Scheduled Options, Menu Options, and Protocols? YES//', respond NO. Post Install Instructions: ========================= This report can be run using the new menu option, Active Title Cleanup Report [TIU ACTIVE TITLE CLEANUP], on the TIU Maintenance Menu [TIU IRM MAINTENANCE MENU], or directly from the programmer prompt by entering D EN^TIUPS209. When running the routine, the following recommendations are made: - Users may be on the system - The job should be run at a time that does not conflict with a system backup - Processing times for this task will vary considerably, depending on the load on your system and the number of entries processed in the TIU DOCUMENT FILE (#8925) and TIU DOCUMENT DEFINITION FILE (#8925.1). This routine should not be deleted after it is initially used. The report can be run as often as needed to track the frequency of usage for TIU Document Definitions and periodic inactivation of unused titles. The report will display all currently ACTIVE titles along with the number of instances that title has been used in the previous 365 days, the last day that title has been used, along with the last AUTHOR/DICTATOR of that entry. INACTIVE titles will only appear on the report if that title has been used in the previous 365 days. DOCUMENT TITLES (#8925.1) that have an invalid #.01 Field will have the IEN displayed at the end of the report. ACTIVE titles that have a document type field that points to a document (in File #8925.1) type other than TITLE [DOC] will have the IEN, NAME, & TYPE displayed at the end of the report. ACTIVE titles that contain a 0 (zero) or NULL #.01 field will have the DOCUMENT IEN displayed at the end of the report. All ACTIVE titles with a count of 0 (zero) will be selected for automatic inactivation ONLY AFTER USER INTERVENTION DURING THE REPORT PROCESS. No changes will be made to file #8925.1 without consent from the user. Specific titles may be selected that will NOT be INACTIVATED even if their usage count for the last year is 0. Sample output of the report is as shown below: PLEASE NOTE: The count "# of Docs Incorrect .01 Field" in the header may be larger than the details at the end of the report. The end of the report will ONLY show the entries with errors; there may be several documents pointing to the same erroneous title, but that title will only be listed ONCE. To verify the results use the example below. --------------------- (HEADER indicates 10 documents) # of Docs Incorrect .01 Field : 10 (See End of Report) (End of Report indicates ONLY 2 entries from 8925.1) The following IENs from File #8925.1 have an incorrect #.04 Field. 569 GENERIC NOTE [CLASS] 557 UROLOGY CONSULT [DOCUMENT CLASS] (Add the document counts from the report...10 documents) GENERIC NOTE 2 Mar 06, 2006 USER8,TIU UROLOGY CONSULT 8 Jan 03, 2006 USER1,TIU --------------------- Inactivate the unused Document Titles at this time? NO// ? Entering 'YES' will inactivate all titles unused in the past year; their STATUS will be changed to INACTIVE. Entering 'NO' will create the report without making any changes. Inactivate the unused Document Titles at this time? NO// YES All active titles that have not been used in the previous 365 days will be set to INACTIVE. You may select individual DOCUMENT TITLES that will NOT be set to INACTIVE by this cleanup. Are you sure you want to change their status to INACTIVE? NO// ? Entering 'YES' will inactivate all titles unused in the past year; their STATUS will be changed to INACTIVE. Entering 'NO' will create the report without making any changes. Are you sure you want to change their status to INACTIVE? NO// DEVICE: HOME// TCP Elapsed Time: 0 minute(s) 31 second(s) # of Used Titles : 27 # of Unused Titles : 1319 # of Invalid Titles : 1 (See End of Report) ---------- # of Total Titles : 1347 # of Docs : 293 # of Docs Incorrect .01 Field : 10 (See End of Report) # of Docs Zero/Null .01 Field : 2 (See End of Report) ---------- # of Total Docs Searched : 305 Current User: USER,DEFAULT Current Date: Jun 01, 2006@11:41:41 Date range searched: Jun 01, 2005 - Jun 01, 2006 # of Document Title Docs Last DT Used Author/Dictator -------------- ---- ------------ --------------- 410 S PROGRESS NOTE 15 Nov 04, 2005 USER1,TIU ADDENDUM 37 Mar 29, 2006 USER1,TIU ADVANCE DIRECTIVE RESCINDED 1 May 23, 2006 USER2,TIU ADVERSE REACTION/ALLERGY 55 May 25, 2006 USER3,TIU ANDREWS TEST NOTE 5 May 16, 2006 USER1,TIU AUDIOLOGY CONSULT RESULT 1 Feb 23, 2006 USER1,TIU C&P EXAM NOTE 5 Oct 12, 2005 USER4,TIU CARDIAC POST-PROCEDURE NOTE 1 Jan 10, 2006 USER5,TIU CARE COORDINATION HOME TELEHEALTH 5 May 17, 2006 USER1,TIU EVALUATION TREATMENT PLAN CARE COORDINATION HOME TELEHEALTH 11 Apr 24, 2006 USER6,TIU SCREENING CONSULT CARE COORDINATION HOME TELEHEALTH 2 Mar 01, 2006 USER7,TIU SUBSEQUENT EVAL CNSLT 2 [Inactive] CARE COORDINATION HOME TELEHEALTH 3 Mar 03, 2006 USER7,TIU SUBSEQUENT EVAL CONSULT CARE COORDINATION HOME TELEHEALTH 21 Mar 03, 2006 USER7,TIU SUMMARY OF EPISODE CONSULT CARE COORDINATION HOME TELEHEALTH 1 Nov 09, 2005 USER8,TIU TELEPHONE ENCOUNTER NOTE DERMATOLOGY CONSULT RESULT [Inactive] 3 Mar 28, 2006 USER1,TIU DIABETIC INPATIENT FOLLOW UP 1 Dec 09, 2005 USER1,TIU DISCHARGE SUMMARY 25 Mar 16, 2006 USER1,TIU GENERIC NOTE 2 Mar 06, 2006 USER8,TIU IMMUNIZATION PROGRESS NOTE 10 Oct 27, 2005 USER9,TIU NURSE INTRAOPERATIVE REPORT 17 Feb 15, 2006 USER1,TIU OPERATION REPORT 19 Feb 08, 2006 USER10,TIU PM&R CONSULT RESULTS 14 Jan 31, 2006 USER1,TIU PODIATRY CONSULT RESULT 8 May 31, 2006 USER1,TIU PRIME CARE CLINIC 1 Oct 11, 2005 USER11,TIU PROGRESS NOTE [Inactive] 27 May 16, 2006 USER1,TIU RESCINDED ADVANCE DIRECTIVE 1 May 23, 2006 USER2,TIU SURGICAL SERVICE PROVIDER NOTE 4 Dec 01, 2005 USER1,TIU UROLOGY CONSULT 8 Jan 03, 2006 USER1,TIU The following IENs from File #8925.1 have an invalid #.01 Field. 1199 The following IENs from File #8925.1 have an incorrect #.04 Field. 569 GENERIC NOTE [CLASS] 557 UROLOGY CONSULT [DOCUMENT CLASS] The following DOCUMENT IENs have an incorrect (null or zero) #.01 Field. 4957690 4957697 Routine Information: ==================== The checksums below are new checksums, and can be checked with CHECK1^XTSUMBLD. Routine Name: TIUPS209 Before: B52105626 After: B67761530 **209,218** ============================================================================= User Information: Entered By : BAKKE,ANDREW J Date Entered : MAY 31, 2006 Completed By: MERRILL,DAVID P Date Completed: JUL 26, 2006 Released By : SAUNDERS,TOM Date Released : JUL 27, 2006 ============================================================================= Packman Mail Message: ===================== $END TXT