$TXT Created by GINSBERG,ELIOT at MNTVLL.FO-ALBANY.MED.VA.GOV (KIDS) on Friday, 06/16/06 at 10:26 ============================================================================= Run Date: JUL 14, 2006 Designation: DG*5.3*694 Package : DG - REGISTRATION Priority: Mandatory Version : 5.3 SEQ #626 Status: Released Compliance Date: AUG 14, 2006 ============================================================================= Associated patches: (v)XU*8*378 <<= must be installed BEFORE `DG*5.3*694' Subject: INVALID STATE/INACTIVE COUNTY REPORT Category: - Routine Description: ============ This patch, DG*5.3*694, follows up on released patch XU*8.0*378 STATE & FOREIGN COUNTRY CLEAN UP by implementing the new report option 'Invalid State/Inactive County Report' [DG INVALID STATE/COUNTY REPORT] in the Registration application. Drawing on data from the PATIENT (#2) and STATE (#5) files, this report lists patient records whose address fields contain invalid states and/or inactive counties. The user may run the report for 1) US and US Possessions Only, 2) Foreign Addresses Only, or 3) Both. NOTE: Because this report is expected to take a long time to generate, it is recommended that you queue it to print at a later time. Here is a sample output from the report, which utilizes report criteria option 3) Both. ('AAC' stands for Austin Automation Center.) Report of States Not Recognized by AAC and Inactive Counties US and US Possessions Only PAGE: 1 NAME SSN FIELD STATE/COUNTY xxxx xxxxxxxxx Permanent Address - County ZZSANDOVAL xxxx xxxxxxxxx Temporary Address - County KENAI COOK I xxxx xxxxxxxxx Confidential Address - County 061 Total records reported: 3 Report of States Not Recognized by AAC and Inactive Counties Foreign Addresses Only PAGE: 1 NAME SSN FIELD STATE/COUNTY xxxx xxxxxxxxx Permanent Address - State ZMEXICO xxxx xxxxxxxxx Permanent Address - State CANADA xxxx xxxxxxxxx Temporary Address - State ZCANAL ZONE Total records reported: 3 A state is considered invalid and will appear on the report if the AAC RECOGNIZED field (#2.1) in the STATE file (#5) is set to 'No' or the first character of the state name is 'Z'. A county is considered inactive and will appear on the report if it has a date in the INACTIVE DATE field (#5) in the COUNTY sub-file (#5.01) of the STATE file (#5), or the county is in a state which is not recognized by the AAC (field #2.1 AAC RECOGNIZED in the STATE file (#5) is set to 'No'.) An address is considered a US or US Possession if the US STATE OR POSSESSION field (#2.2) in the STATE file (#5) is set to 'Yes'. An address is considered foreign if the US STATE OR POSSESSION field (#2.2) is set to 'No' or blank. NOTE: even if the address is considered foreign, it will appear on the report only if the AAC RECOGNIZED field (#2.1) in the STATE file (#5) is set to 'No' or blank. NOTE: If you run the report for the purpose of resolving the discrepancies it will display, be sure to use the appropriate resources to verify the correctness of the changes you wish to make. Edit the appropriate fields in the PATIENT file (#2) only, using the Load/Edit Patient Data option on the Registration Menu. PATIENT file (#2) fields reported at your site as containing incorrect state data should be edited only to states recognized by the AAC (see list below). PATIENT file (#2) fields reported as containing inactive counties should be edited only to counties that have no inactive date and are located in states that are recognized by the AAC. Once your site has installed both associated Kernel patch XU*8*378 and this patch (DG*5.3*694), you may run the new report option. You will be able to use entries from the table below to replace incorrect PATIENT file (#2) state field entries appearing on your report with the correct entries. Description Abbreviation Recognized by AAC US or US Territory ALABAMA AL Yes Yes ALASKA AK Yes Yes ALBERTA AB Yes No AMERICAN SAMOA AS Yes Yes ARIZONA AZ Yes Yes ARKANSAS AR Yes Yes ARMED FORCES AF,EU,ME,CA AE Yes Yes ARMED FORCES AMER (EXC CANADA) AA Yes Yes ARMED FORCES PACIFIC AP Yes Yes BRITISH COLUMBIA BC Yes No CALIFORNIA CA Yes Yes COLORADO CO Yes Yes CONNECTICUT CT Yes Yes DELAWARE DE Yes Yes DISTRICT OF COLUMBIA DC Yes Yes EUROPE EU Yes No FEDERATED STATES OF MICRONESIA FM Yes Yes FLORIDA FL Yes Yes FOREIGN COUNTRY FG Yes No GEORGIA GA Yes Yes GUAM GU Yes Yes HAWAII HI Yes Yes IDAHO ID Yes Yes ILLINOIS IL Yes Yes INDIANA IN Yes Yes IOWA IA Yes Yes KANSAS KS Yes Yes KENTUCKY KY Yes Yes LOUISIANA LA Yes Yes MAINE ME Yes Yes MANITOBA MB Yes No MARSHALL ISLANDS MH Yes Yes MARYLAND MD Yes Yes MASSACHUSETTS MA Yes Yes MEXICO MX Yes No MICHIGAN MI Yes Yes MINNESOTA MN Yes Yes MISSISSIPPI MS Yes Yes MISSOURI MO Yes Yes MONTANA MT Yes Yes NEBRASKA NE Yes Yes NEVADA NV Yes Yes NEW BRUNSWICK NB Yes No NEW HAMPSHIRE NH Yes Yes NEW JERSEY NJ Yes Yes NEW MEXICO NM Yes Yes NEW YORK NY Yes Yes NEWFOUNDLAND NF Yes No NORTH CAROLINA NC Yes Yes NORTH DAKOTA ND Yes Yes NORTHERN MARIANA ISLANDS MP Yes Yes NORTHWEST TERRITORIES NT Yes No NOVA SCOTIA NS Yes No NUNAVUT PROVINCE NU Yes No OHIO OH Yes Yes OKLAHOMA OK Yes Yes ONTARIO ON Yes No OREGON OR Yes Yes PALAU PW Yes Yes PENNSYLVANIA PA Yes Yes PHILIPPINES PH Yes No PRINCE EDWARD ISLAND PE Yes No PUERTO RICO PR Yes Yes QUEBEC QC Yes No RHODE ISLAND RI Yes Yes SASKATCHEWAN SK Yes No SOUTH CAROLINA SC Yes Yes SOUTH DAKOTA SD Yes Yes TENNESSEE TN Yes Yes TEXAS TX Yes Yes U.S. MINOR OUTLYING ISLANDS UM Yes Yes UTAH UT Yes Yes VERMONT VT Yes Yes VIRGIN ISLANDS VI Yes Yes VIRGINIA VA Yes Yes WASHINGTON WA Yes Yes WEST VIRGINIA WV Yes Yes WISCONSIN WI Yes Yes WYOMING WY Yes Yes YUKON TERRITORY YT Yes No The following table lists the PATIENT file (#2) fields included in the new report and the way each of these fields is identified in the 'FIELD' column of the report, for report options (1) and (2). For the report option to check 'US and US Possessions Only' (1): File #2 Field Number and Name Appears on the Report as .093 PLACE OF BIRTH [STATE] Place of Birth .115 STATE Permanent Address - State .117 COUNTY Permanent Address - County .1215 TEMPORARY STATE Temporary Address - State .12111 TEMPORARY COUNTY Temporary Address - County .1415 CONFIDENTIAL ADDRESS STATE Confidential Address - State .14111 CONFIDENTIAL ADDRESS COUNTY Confidential Address - County .1654 INELIGIBLE TWX STATE Ineligible TWX .1659 MISSING PERSON TWX STATE Missing Person TWX .217 K-STATE Next of Kin .2197 K2-STATE Next of Kin 2 .256 SPOUSE'S EMPLOYER'S STATE Spouse's Employer .2917 STATE (VA) VA Guardian .2927 STATE (CIVIL) Civil Guardian .3117 EMPLOYER STATE Employer .3317 E2-STATE Emergency Contact 2 .337 E-STATE Emergency Contact .347 D-STATE Designee 2.06 INS TYPE-EMPLOYER CLAIMS STATE Insurance Type - Emp Claims 3.09 INS TYPE-INSURED'S STATE Insurance Type - Insured's 13 INS TYPE-AGENT'S STATE Insurance Type - Agent's 35 INS TYPE-A-STATE Attorney For the report option to check 'Foreign Addresses Only' (2): File #2 Field Number and Name Appears on the Report as .115 STATE Permanent Address - State .1215 TEMPORARY STATE Temporary Address - State .1415 CONFIDENTIAL ADDRESS STATE Confidential Address - State On completion of the report, a summary MailMan message is sent to the user initiating the report. For the sample report above, the associated MailMan message looks like: Subj: Invalid State/Inactive County Report Summary [#66405] 06/08/06@12:07 19 lines From: POSTMASTER In 'IN' basket. Page 1 *New* -------------------------------------------------------------------------- The following counts have been found in the PATIENT file: US and US Possessions Only Confidential Address 1 Permanent Address - County 1 Temporary Address - County 1 Foreign Addresses Only Permanent Address - State 2 Temporary Address - State 1 Enter message action (in IN basket): Ignore// DOCUMENTATION RETRIEVAL ======================= Sites may retrieve the user documentation directly using FTP from the ANONYMOUS.SOFTWARE directory at the following OI Field Offices: Albany : ftp.fo-albany.med.va.gov Hines : ftp.fo-hines.med.va.gov Salt Lake City : ftp.fo-slc.med.va.gov First Available Server : download.vista.med.va.gov (preferred method) The following files will be available: File Name Description --------- ----------- DG_5_3_P694_ADTBE_UM.PDF Revised PIMS V. 5.3 Menus, Intro, Orientation, etc. User Manual DG_5_3_P694_REG_UM.PDF Revised PIMS V. 5.3 Registration Menu User Manual Note: Use Binary mode when transferring the .PDF files. The VistA Documentation Library [VDL] web site contains all end-user manuals. The address is http://www.va.gov/vdl/. This patch addresses the following New Service Request (NSR): ------------------------------------------------------------- There is no NSR associated with this patch. This patch addresses the following Remedy Tickets: --------------------------------------------------------- There are no Remedy tickets associated with this patch. Test Sites: ----------- Madison (Medium) West LA (Large) Puget Sound (Integrated) ================INSTALLATION INSTRUCTIONS ================= This patch can be loaded with users on the system. Install Time - less than 1 minute 1. LOAD TRANSPORT GLOBAL --------------------- Choose the PackMan message containing this patch and invoke the INSTALL/CHECK MESSAGE PackMan option. 2. COMPONENTS SENT WITH PATCH ------------------------ The following new OPTION is included with this patch. Invalid State/Inactive County Report [DG INVALID STATE/COUNTY REPORT] 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: ;;5.3;Registration;**[patch list]**;Aug 13, 1993 CHECK^XTSUMBLD results Routine Before Patch After Patch Patch List ======= ============ =========== ========== DGRSTBAD N/A 12887940 694 Number of routines in patch: 1 Number of new routines: 1 Number of routines changed: 0 CHECK1^XTSUMBLD (new method) results Routine Before Patch After Patch Patch List ======= ============ =========== ========== DGRSTBAD N/A 86893663 694 Number of routines in patch: 1 Number of new routines: 1 Number of routines changed: 0 3. START UP KIDS ------------- Start up the Kernel Installation and Distribution System Menu [XPD MAIN]: Edits and Distribution ... Utilities ... Installation ... Select Kernel Installation & Distribution System Option: INStallation --- Load a Distribution Print Transport Global Compare Transport Global to Current System Verify Checksums in Transport Global Install Package(s) Restart Install of Package(s) Unload a Distribution Backup a Transport Global Select Installation Option: 4. Select Installation Option: --------------------------- NOTE: The following are OPTIONAL - (When prompted for the INSTALL NAME, enter DG*5.3*694): a. Backup a Transport Global - This option will create a backup message of any routines exported with this patch. It will not backup any other changes such as DD's or templates. b. Compare Transport Global to Current System - This option will allow you to view all changes that will be made when this patch is installed. It compares all components of this patch (routines, DD's, 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. 5. Select Installation Option: Install Package(s) ---------------- **This is the step to start the installation of this KIDS patch: a. Choose the Install Package(s) option to start the patch install. b. When prompted 'Want KIDS to Rebuild Menu Trees Upon Completion of Install? YES//' answer NO. c. When prompted 'Want KIDS to INHIBIT LOGONs during the install? YES//' answer NO. d. When prompted 'Want to DISABLE Scheduled Options, Menu Options and Protocols? YES//' answer NO. =============POST INSTALLATION INSTRUCTIONS ================= Attach new option 'Invalid State/Inactive County Report' [DG INVALID STATE/COUNTY REPORT] to the Registration Menu [DG REGISTRATION MENU]. Routine Information: ==================== The checksums below are new checksums, and can be checked with CHECK1^XTSUMBLD. Routine Name: DGRSTBAD Before: n/a After: B86893663 **694** ============================================================================= User Information: Entered By : HAY,JAMES Date Entered : DEC 06, 2005 Completed By: HUA,PATRICK Date Completed: JUL 14, 2006 Released By : ALEXANDER,DIANNE Date Released : JUL 14, 2006 ============================================================================= Packman Mail Message: ===================== $END TXT