============================================================================= Run Date: SEP 02, 1998 Designation: XU*999*3 Package : XU - KERNEL Priority: Mandatory Version : 999 SEQ #2 Status: Released ============================================================================= Subject: VISTA STATE file (#5) Information patch Category: - Database Description: ============ OVERVIEW The VISTA STATE file (#5) and the Austin Automation Center's (AAC) edit table are not fully synchronized. This problem is causing VISTA reporting mechanisms to fail. Most recently, Outpatient Workload reporting for Ambulatory Care has in some cases NOT been passing the standard edit checks, both locally at the sites and at Austin. The VISTA STATE file and the AAC edit table MUST be synchronized to enable sites to receive their workload credit. This is an informational patch providing instructions for synchronizing the VISTA STATE file (#5) and the AAC edit table. These recommended modifications will standardize State and County entries across all Veterans Affairs Medical Centers and with the Austin Automation Center. Following the general instructions, below, you will find step-by-step instructions (with examples) for making the changes to the VISTA STATE file. GENERAL INSTRUCTIONS 1) Use the VA FileMan option ENTER OR EDIT FILE ENTRIES to make all recommended modifications to the VISTA STATE file (#5). 2) Should you require additional help using VA FileMan, see the VA FileMan User Manual, Version 21.0, Chapter 4 - How to Enter or Change Data. 3) The following Immunology Case Registry security keys should be temporarily assigned to the IRM personnel responsible for making these modifications to the VISTA STATE file: 1. IMRMGR 2. IMRA These keys are necessary to update pointers in the ICR SITE PARAMETERS file (#158.9). 4) Sample screen captures are provided to help illustrate recommended procedures. 5) You must be in programmer mode to make these modifications. 6) All entries to the VISTA STATE file must be made in UPPER CASE and typed exactly as shown. 7) The Return or Enter key is illustrated by the symbol . It is displayed in screen captures of computer dialogue when this keystroke must be entered. 8) It is understood that the repointing of FileMan entries may take some time based on the number of entries involved. In fact it may take all night to complete just one step depending on the number of repointed entries, and it may take several nights to complete all of the parts of this patch. The steps have been made to run sequentially but do not have to be run all at one time. YOU MUST FOLLOW THESE INSTRUCTIONS TO EDIT YOUR LOCAL VISTA STATE FILE: PART 1: Assign yourself the IMRMGR and IMRA Security Keys. PART 2: Use the VA FileMan option ENTER OR EDIT FILE ENTRIES to correct the following errors in the VISTA STATE file. (Be advised that some or all of these entries may not be in your local VISTA STATE file. If you do not have any one particular entry in your STATE file, do nothing. Skip to the next instructions.) 1) EDIT STATE FILE ENTRY: FOREIGN COUNTRY If you currently have FOREIGN COUNTRY as a State entry in your STATE file, follow these instructions otherwise go on to Step 2. a. Using the FileMan "Enter or Edit File Entries" option delete the State entry FOREIGN COUNTRY and update all pointers by re-pointing to the State entry OTHER. b. Exit option ENTER OR EDIT FILE ENTRIES to allow the pointers to automatically update. NOTE: VA FileMan automatically generates a report displaying file entries in which, pointers have been changed. You can send this report to a local printer or to your terminal screen. This automatic report generation will take a few minutes. THE FOLLOWING EXAMPLE ILLUSTRATES HOW TO DO THIS: -------------------------------------------------------------------- D P^DI VA FileMan 21.0 Select OPTION: 1 ENTER OR EDIT FILE ENTRIES INPUT TO WHAT FILE: STATE// (80 entries) EDIT WHICH FIELD: ALL// Select STATE NAME: FOREIGN COUNTRY NAME: FOREIGN COUNTRY// @ SURE YOU WANT TO DELETE THE ENTIRE 'FOREIGN COUNTRY' STATE? Y (Yes) SINCE THE DELETED ENTRY MAY HAVE BEEN 'POINTED TO' BY ENTRIES IN THE 'PATIENT' FILE, ETC., DO YOU WANT THOSE POINTERS UPDATED (WHICH COULD TAKE QUITE A WHILE)? No// Y (Yes) WHICH DO YOU WANT TO DO? -- 1) DELETE ALL SUCH POINTERS 2) CHANGE ALL SUCH POINTERS TO POINT TO A DIFFERENT 'STATE' ENTRY CHOOSE 1) OR 2): 2 THEN PLEASE INDICATE WHICH ENTRY SHOULD BE POINTED TO Select STATE NAME: OTHER (RE-POINTING WILL OCCUR WHEN YOU LEAVE 'ENTER/EDIT' OPTION) ************* you must now exit VA FileMan to ************* ************* allow re-pointing to take place ************* ******************* before you continue ******************* -------------------------------------------------------------------- 2) EDIT STATE FILE ENTRY: OTHER a. Using the Fileman "Enter or Edit File Entries" option change the State NAME entry from OTHER to FOREIGN COUNTRY. b. Change the State ABBREVIATION entry from XX to FG. c. Change the VA STATE CODE from 98 to 90. d. Add one County sub-entry ALL OTHER FOREIGN with a VA COUNTY CODE of 999. THE FOLLOWING EXAMPLE ILLUSTRATES HOW TO DO THIS: ------------------------------------------------------------------- Select OPTION: ENTER OR EDIT FILE ENTRIES INPUT TO WHAT FILE: STATE// EDIT WHICH FIELD: ALL// Select STATE NAME: OTHER NAME: OTHER// FOREIGN COUNTRY (change name) ABBREVIATION: XX// FG (change abbreviation) VA STATE CODE: 98// 90 (change VA State code) Select COUNTY: ALL OTHER FOREIGN (add new county entry) Are you adding 'ALL OTHER FOREIGN' as a new COUNTY (the 1ST for this STATE)? No// y (Yes) COUNTY VA COUNTY CODE: 999 (add VA county code) ABBREVIATION: VA COUNTY CODE: 999// CATCHMENT CODE: Select ZIP CODE: Select COUNTY: CAPITAL: ------------------------------------------------------------------ 3) EDIT STATE FILE ENTRY: CANAL ZONE a. Using the Fileman "Enter or Edit File Entries" option delete the State entry CANAL ZONE and update the pointers by re-pointing to the State entry FOREIGN COUNTRY. THIS PROCEDURE IS SIILIAR TO STEP 1. NO EXAMPLE CAPTURE INCLUDED FOR THIS ONE. 4) EDIT STATE FILE ENTRY: QUEBEC If you do not currently have QUEBEC as a State entry, do nothing. Skip to the next step. (You will be adding the Canadian Province of QUEBEC later in these instructions.) a. Using the Fileman "Enter or Edit File Entries" enter a "placeholder" entry for QUEBEC followed by two asterisks (i.e., QUEBEC**). b. Enter an ABBREVIATION of QC. c. Enter a VA STATE CODE of 80. d. Delete the current State entry QUEBEC and update all all pointers by re-pointing to the "placeholder" State entry QUEBEC**. e. Exit option ENTER OR EDIT FILE ENTRIES to allow the pointers to automatically update. [For more information see the advisory NOTE in STEP 1, line item 1)] THE FOLLOWING EXAMPLE ILLUSTRATES HOW TO CORRECT THE STATE ENTRY FOR QUEBEC: ------------------------------------------------------------------ D P^DI VA FileMan 21.0 Select OPTION: 1 ENTER OR EDIT FILE ENTRIES INPUT TO WHAT FILE: STATE// (80 entries) EDIT WHICH FIELD: ALL// Select STATE NAME: QUEBEC** (adding new entry) Are you adding 'QUEBEC**' as a new STATE (the 80TH)? No// Y (Yes) STATE NUMBER: 98// STATE VA STATE CODE: 80 ABBREVIATION: QC VA STATE CODE: 80// Select COUNTY: CAPITAL: Select STATE NAME: QUEBEC (deleting old Quebec) 1 QUEBEC 2 QUEBEC** CHOOSE 1-2: 1 QUEBEC NAME: QUEBEC// @ SURE YOU WANT TO DELETE THE ENTIRE 'QUEBEC' STATE? Y (Yes) SINCE THE DELETED ENTRY MAY HAVE BEEN 'POINTED TO' BY ENTRIES IN THE 'PATIENT' FILE, ETC., DO YOU WANT THOSE POINTERS UPDATED (WHICH COULD TAKE QUITE A WHILE)? No// Y (Yes) WHICH DO YOU WANT TO DO? -- 1) DELETE ALL SUCH POINTERS 2) CHANGE ALL SUCH POINTERS TO POINT TO A DIFFERENT 'STATE' ENTRY CHOOSE 1) OR 2): 2 THEN PLEASE INDICATE WHICH ENTRY SHOULD BE POINTED TO Select STATE NAME: QUEBEC** (RE-POINTING WILL OCCUR WHEN YOU LEAVE 'ENTER/EDIT' OPTION) *********** You must now exit VA FileMan to allow *********** ************* re-pointing to take place before ************** ************ continuing with these instructions. ************ ------------------------------------------------------------------ 5) EDIT STATE FILE ENTRY: QUEBEC** a. Once you've done this, use the option ENTER OR EDIT FILE ENTRIES to go back in and remove the asterisks from the State entry QUEBEC**. THE FOLLOWING EXAMPLE ILLUSTRATES HOW TO CORRECT THE STATE ENTRY FOR QUEBEC**: -------------------------------------------------------------------- P^DI VA FileMan 21.0 Select OPTION: ENTER OR EDIT FILE ENTRIES INPUT TO WHAT FILE: STATE// EDIT WHICH FIELD: ALL// Select STATE NAME: QUEBEC** NAME: QUEBEC**// QUEBEC ABBREVIATION: QC// VA STATE CODE: 80// Select COUNTY: QUEBEC Are you adding 'QUEBEC' as a new COUNTY (the 1ST for this STATE)? No// Y (Yes) ABBREVIATION: VA COUNTY CODE: 260 CATCHMENT CODE: Select ZIP CODE: Select County: CAPITAL: ------------------------------------------------------------------ 6) EDIT STATE FILE ENTRY: JOHNSTON ATOLL a. Using the Fileman "Enter or Edit File Entries" Option Rename the State NAME from JOHNSTON ATOLL to U.S. MINOR OUTLYING ISLANDS. b. Change its State ABBREVIATION from ZZ to UM. THE FOLLOWING EXAMPLE ILLUSTRATES HOW TO DO THIS: ----------------------------------------------------------------- D P^DI VA FileMan 21.0 Select OPTION: 1 ENTER OR EDIT FILE ENTRIES INPUT TO WHAT FILE: STATE// (80 entries) EDIT WHICH FIELD: ALL// Select STATE NAME: JOHNSTON ATOLL NAME: JOHNSTON ATOLL// U.S. MINOR OUTLYING ISLANDS ABBREVIATION: ZZ// UM VA STATE CODE: 74// Select COUNTY: ALL OTHER// COUNTY: ALL OTHER//^ ----------------------------------------------------------------- PART 3: Use the VA FileMan option ENTER OR EDIT FILE ENTRIES to delete the following County entries in the VISTA STATE file. (Be advised that some or all of these entries may not be in your local VISTA STATE file. If you do not have any one particular entry in your STATE file, do nothing. Skip to the next instruction.) 1) EDIT STATE FILE COUNTY CODES a. Under the State entry "AMERICAN SAMOA" delete the county entry "ALL OTHER". b. Under the State entry "GUAM" delete the county entry "999". c. Under the State entry "PALAU (TERRITORY)" delete the county entry "NGAREMLENGUI". d. Under the State entry "PUERTO RICO" delete the county entry "999". e. Under the State entry "U.S. MINOR OUTLYING ISLANDS" delete the county entry "ALL OTHER". (NOTE: Remember, this State entry was renamed from "JOHNSTON ATOLL" to "US MINOR OUTLYING ISLANDS" earlier in these instructions.) f. Under the State entry "VIRGIN ISLANDS" delete the county entries "ALL OTHER" and "999". g. Under the State entry "MEXICO" delete the county entries "260 CANADA" and "260". THE FOLLOWING EXAMPLE ILLUSTRATES HOW TO DO THIS USING THE COUNTY ENTRY "ALL OTHER" UNDER THE STATE ENTRY "AMERICAN SAMOA" AS AN EXAMPLE: ------------------------------------------------------------------- D P^DI VA FileMan 21.0 Select OPTION: 1 ENTER OR EDIT FILE ENTRIES INPUT TO WHAT FILE: STATE// (80 entries) EDIT WHICH FIELD: ALL// Select STATE NAME: AMERICAN SAMOA NAME: AMERICAN SAMOA// ABBREVIATION: AS// VA STATE CODE: 60// Select COUNTY: ALL OTHER// @ SURE YOU WANT TO DELETE THE ENTIRE 'ALL OTHER' COUNTY? Y (Yes) Select COUNTY: WESTERN// ^ ---------------------------------------------------------------------- PART 4: 1) Discontinue using the current entry for CANADA. Use the appropriate Canadian Province instead, as listed below. 2) Use the VA FileMan option ENTER OR EDIT FILE ENTRIES to add the following US Postal Service codes as State entries in the VISTA STATE file: STATE and COUNTY NAME STATE VA STATE VA COUNTY ABBREVIATION CODE CODE ALBERTA AB 58 260 BRITISH COLUMBIA BC 59 260 MANITOBA MB 61 260 NEW BRUNSWICK NB 62 260 NEWFOUNDLAND NF 63 260 NOVA SCOTIA NS 65 260 NORTHWEST TERRITORIES NT 73 260 ONTARIO ON 75 260 PRINCE EDWARD ISLAND PE 77 260 SASKATCHEWAN SK 82 260 YUKON TERRITORY YT 83 260 ARMED FORCES AMER (EXC CANADA) AA 85 260 ARMD FORCES EURO,M-EAST,CANADA AE 87 260 ARMED FORCES PACIFIC AP 88 260 Note: ARMD FORCES EURO,M-EAST,CANADA is to be types exactly as shown. Do not correct spelling of ARMD. Additionally, If you do not have QUEBEC as a current entry in your STATE file, add it now. (Otherwise, if QUEBEC is a current entry in your STATE file, by now you should have modified it using the instructions in STEP 1, line item 3.) STATE and COUNTY NAME STATE VA STATE VA COUNTY ABBREVIATION CODE CODE QUEBEC QC 80 260 THE FOLLOWING EXAMPLE ILLUSTRATES HOW TO DO THIS USING THE STATE AND COUNTY ENTRY "ALBERTA" AS THE EXAMPLE: ---------------------------------------------------------------- D P^DI VA FileMan 21.0 Select OPTION: 1 ENTER OR EDIT FILE ENTRIES INPUT TO WHAT FILE: STATE// EDIT WHICH FIELD: ALL// Select STATE NAME: ALBERTA Are you adding 'ALBERTA' as a new STATE (the 69TH)? No// Y (Yes) STATE NUMBER: 75// STATE VA STATE CODE: 58 ABBREVIATION: AB VA STATE CODE: 58// Select COUNTY: ALBERTA Are you adding 'ALBERTA' as a new COUNTY (the 1ST for this STATE)? No// Y (Yes) COUNTY VA COUNTY CODE: 260 ABBREVIATION: VA COUNTY CODE: 260// CATCHMENT CODE: Select ZIP CODE: Select COUNTY: CAPITAL: --------------------------------------------------------------------- Note: In all of the above cases the State name and the county name are the same and should be entered as such. This completes the updates of the State File as required by this patch. PART 5: Deallocate the IMRMGR and IMRA Security Keys from your profile. This completes all of the parts of this patch. Routine Information: ==================== ============================================================================= User Information: Entered By : STRACK,SUSAN Date Entered : JUN 10, 1998 Completed By: MURPHY,MINAO J. Date Completed: SEP 02, 1998 Released By : GIBBONS,JOE Date Released : SEP 02, 1998 ============================================================================= Packman Mail Message: ===================== No routines included