$TXT Created by BAKKE,Andrew at DAYTDEV.FO-BAYPINES.MED.VA.GOV (KIDS) on Friday, 03/24/06 at 13:35 ============================================================================= Run Date: APR 20, 2006 Designation: TIU*1*209 Package : TIU - TEXT INTEGRATION UTILITIES Priority: Mandatory Version : 1 SEQ #194 Status: Released Compliance Date: MAY 21, 2006 ============================================================================= Subject: TIU ACTIVE TITLE CLEANUP REPORT 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. 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. Technical details and search criteria are also included in the post-install 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] 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 N/A 19354820 209 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://vista.med.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*209): 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*209. 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). An estimated processing time should be less than a minute. 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. ACTIVE titles that have a document type field that points to a document (in 8925.1) of type DOCUMENT CLASS or CLASS will have a *[DOCUMENT CLASS]* or *[CLASS]* tag appended to the title respectively. ACTIVE titles that contain a 0 (zero) or NULL document type field will be displayed as UNKNOWN *[missing]* on the report and the document IENs for these titles will be listed 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. The header of the report will also contain summaries of: - Elaspsed time to run the report - # of active, unused titles in the previous 365 days - # of active, used titles in the previous 365 days - total # of active titles - current user running the report - date of report (T) - date range searched (T-365) Sample output of the report is as shown: 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) 13 second(s) # of Records: Unused Titles 1321 Used Titles 24 Total Titles 1345 Current User: USER1,TIU Current Date: Feb 24, 2006@13:56:57 Date range searched: Feb 24, 2005 - Feb 24, 2006 # of Document Title Docs Last DT Used Author/Dictator -------------- ---- ------------ --------------- ACU NURSING NOTE 0 Dec 27, 2004 USER2,TIU NEUROLOGY EMG CONSULT RESULT 0 N/A N/A OTP MEDICATION NOTE 0 N/A N/A AUDIOLOGY CONSULT RESULT 1 Feb 23, 2006 N/A CARE COORDINATION HOME TELEHEALTH 1 Nov 09, 2005 USER4,TIU TELEPHONE ENCOUNTER NOTE DIABETIC INPATIENT FOLLOW UP 1 Dec 09, 2005 USER2,TIU DISCHARGE SUMMARY *[CLASS]* 16 Feb 23, 2006 USER2,TIU IMMUNIZATION PROGRESS NOTE 10 Oct 27, 2005 USER3,TIU NURSE INTRAOPERATIVE REPORT 19 Feb 15, 2006 USER,CPRS OPERATION REPORT *[DOCUMENT CLASS]* 19 Feb 08, 2006 USER5,TIU PM&R CONSULT RESULTS 16 Jan 31, 2006 USER2,TIU PODIATRY CONSULT RESULT 2 Feb 21, 2006 USER3,TIU PRIME CARE CLINIC 1 Oct 11, 2005 USER4,TIU PROGRESS NOTE [currently inactive] 22 Feb 15, 2006 USER1,TIU SURGICAL SERVICE PROVIDER NOTE 4 Dec 01, 2005 USER1,TIU UNKNOWN *[missing]* 1 Feb 21, 2006 USER5,TIU UROLOGY CONSULT 8 Jan 03, 2006 USER6,TIU WRIISC ASSESSMENT NOTE 3 Feb 22, 2006 USER7,TIU The following DOCUMENT IENs have an incorrect #.01 Field (DOCUMENT TYPE). 1438841 Routine Information: ==================== The checksums below are new checksums, and can be checked with CHECK1^XTSUMBLD. Routine Name: TIUPS209 Before: n/a After: B52105626 **209** ============================================================================= User Information: Entered By : CHUNG,TERESA L Date Entered : JAN 25, 2006 Completed By: SCHLEHUBER,PAM Date Completed: APR 20, 2006 Released By : SAUNDERS,TOM Date Released : APR 20, 2006 ============================================================================= Packman Mail Message: ===================== $END TXT