UIPL01-11a1.pdf

ETA Advisory File Text

Unemployment Insurance Data Validation Operations Guide ETA Operations Guide 411 U.S. Department of Labor Employment and Training Administration Office of Unemployment Insurance TABLE OF CONTENTS Chapter 1 ....................................................................... ...................................... 1 About This Operations Guide ....................................................................... ..... 1 Technical Support ........................................................................ ....................... 1 Software Training ........................................................................ ........................ 1 Typographic Conventions ....................................................................... ........... 1 Software Requirements ....................................................................... ............... 2 The Data Validation Program ....................................................................... ...... 2 Navigating the System ....................................................................... ................ 3 Definitions ....................................................................... .................................... 5 Chapter 2 ....................................................................... ...................................... 6 Logging On ....................................................................... ................................... 6 Chapter 3 ....................................................................... .................................... 10 Viewing the Record Layouts ....................................................................... ..... 10 Chapter 4 ....................................................................... .................................... 13 Importing an Extract File ....................................................................... ........... 13 Cancelling a Load ....................................................................... ........... 24 Chapter 5 ....................................................................... .................................... 26 Viewing Errors ........................................................................ ........................... 26 Viewing Duplicate Records ................................................................... 29 i TABLE OF CONTENTS Chapter 6 ....................................................................... .................................... 33 Viewing the Source Table ....................................................................... ......... 33 Chapter 7 ....................................................................... .................................... 37 Viewing Validation Counts ....................................................................... ........ 37 Chapter 8 ....................................................................... .................................... 40 Viewing the Report Validation Screen ............................................................ 40 Chapter 9 ....................................................................... .................................... 44 Viewing Samples ........................................................................ ....................... 44 Printing Sample Worksheets ................................................................. 48 Entering Validation Results for Non-random Samples Minimum Missing Subpopulations and Outliers ................................................. 53 Entering Validation Results for Random Samples .............................. 58 First Tier ....................................................................... ................. 58 Second Tier ....................................................................... ............ 60 Viewing the Data Element Validation Report ....................................... 63 Chapter 10 ....................................................................... .................................. 65 Viewing Data Element Sorts in Tax ................................................................. 65 Entering Data Element Sorts Results ................................................... 67 Query Screen ....................................................................... ......... 68 Frequency Distribution Screen ...................................................... 71 Chapter 11 ....................................................................... .................................. 75 Viewing the Wage Item Validation Screen in Tax ........................................... 75 Chapter 12 ....................................................................... .................................. 80 ii TABLE OF CONTENTS iii Submitting Results to DOL ....................................................................... ....... 80 Adding Comments ....................................................................... .......... 80 Transmitting Population Results .......................................................... 84 Transmitting Wage Item Validation Results ......................................... 91 APPENDIX A ....................................................................... ............................. A-1 APPENDIX B ....................................................................... ............................. B-1 APPENDIX C ....................................................................... ............................. C-1 APPENDIX D ....................................................................... ............................. D-1 Unemployment Insurance Data Validation Operations Guide Chapter 1 About This Operations Guide This guide explains how to navigate the Benefits and Tax applications of the Data Validation DV State Web Software Version 3.2.0. Technical Support If any problems are encountered with the software contact the Office of Unemployment Insurance OUI Technical Support Staff Hotline at 1-800-473- 0188 or send an email to hotline uis.doleta.gov . Software Training The Minnesota Training Center offers training on the Data Validation State Web Software. Check current offerings at http www.tc.state.mn.us calendar.html. You can register for courses online by email wanda.burth state.mn.us or by calling the training center at 651-297-3393. Typographic Conventions This document uses the following typographic conventions. Visual Cue Meaning 1 2 Sequenced steps to follow when completing a task Black bold type Button Blue type Box title Purple underlined type Links on the software that you can click on Blue underline type Web or email address Italics Documents screen names and menu options Indicates where to click on the software screen Note with additional information Tip 1 Unemployment Insurance Data Validation Operations Guide Software Requirements To use the Data Validation State Web Software you will need a computer with Internet Explorer Version 6.0 or later. You will also need a user name and a password which you should obtain from your system administrator. In order to perform data validation you need to load extract files into the software. Specifications on how to build these extract files are available in Appendix A UI Benefits Record Layouts and Appendix B UI Tax Record Layouts of this Operations Guide. All extract files to be loaded into the software must be copied to the opt dv data directory in your state SUN server. Extract file names must have a .txt extension and contain no spaces. The Data Validation Program Welcome to the world of data validation This operations guide is both an introduction to the Data Validation automated system and a reference source for continual use. States are required to file a series of standardized reports on their Unemployment Insurance UI operations with the Employment and Training Administration ETA of the U.S. Department of Labor DOL . Reports covered by the data validation program are required on a monthly or quarterly basis. These reports are used to establish the volume of activity conducted by state UI administrations and are a factor in establishing funding levels. They provide information about state compliance with UI requirements. They also provide information about the amount of benefits paid the number of claimants served and other information useful in measuring the U.S. economy and projecting trends. Since state programs differ significantly within established parameters and states utilize a variety of accounting and data processing arrangements the issue of the comparability among state reports has emerged. State reporting requirements are standardized but states use a variety of reporting procedures and must interpret reporting requirements within the context of their own laws and accounting conventions. The UI Data Validation DV program was established in an attempt to identify and address discrepancies in reported numbers. The program requires that states recreate reported numbers independently from their reporting process and compare these numbers with actual numbers reported to DOL. States must address any discrepancies found that exceed the established tolerance error 2 Unemployment Insurance Data Validation Operations Guide rate. The DV program also requires that states examine a sample of reported cases to verify that the correct information is being counted. The Data Validation State Web Software facilitates the validation process and generates standardized outputs which document the state data validation results. The data validation process is divided into two main validation processes Report Validation RV and Data Element Validation DEV . RV verifies that reported numbers in ETA reports are accurate i.e. that the process which the state uses to count transactions is correct. DEV refers to the investigation of samples of records to establish that the information in individual records is accurate and conforms to federal reporting requirements i.e. that the state is counting the right transactions. The Benefits application uses random missing minimum and outliers samples for the DEV process. The Tax application uses minimum samples formerly known as File Integrity Validation or FIV samples which consist of two records per sub-population within an extract file. The sample frame for each sample consists of a set of specific sub-populations within an extract file. Records included in a sample are displayed along with the data elements to be validated in a data entry screen. Investigators review each record identify any elements found to be erroneous and data-enter this information into the system. In Tax even one error causes a sample to fail. The Tax application also provides a sort utility for Populations 1 4 as part of the DEV process. It tests whether any secondary codes or Employer Account Number values support the primary codes such as A for Active or C for Contributory employers used to classify extracted transactions. Sorts pass if fewer than 2 of the sorted of the sorted transactions involve discrepancies. Tax Population 5 has no sort utility. The Tax application includes a Wage Item Validation component that requires validation of incoming information provided by employers pertaining to wages paid to individuals on a quarterly basis wage Records . This information is not included in extract files. Validation of wage record information requires a review of incoming information and a comparison of reported numbers included in ETA 581 Report count with re-constructed counts. This information is key-entered into the software and forwarded to DOL. Navigating the System The DV software is a web-based application with certain characteristics that the user should be aware of. 3 Unemployment Insurance Data Validation Operations Guide Multiple users. The software supports multiple concurrent users. However it was not designed to allow for example update of a single table by multiple users at the same time. Time Out. You will be automatically logged out from the application if you are inactive for more than 59 minutes. To maintain your session hit a keystroke or move your mouse. You should perform save operations frequently if there is a danger of work being lost due to inactivity. During the extract loading operation the time-out parameter is set to four hours to allow large extract files to be loaded without interruption. Exit from Screens. The user can exit from a secondary window within the application through use of the X in the upper right corner of the window. Be aware that the X at the extreme upper corner of the screen will exit the user from the entire application. This will require the user to sign on again and may result in lost data. Use of the Back button. The Internet browser has a Back button that allows the user to return to a previous screen. Users should be aware that use of this button may result in unexpected results. This problem can be avoided by using the links on the software screens that were designed to navigate to previous screens. For example the Home link at the bottom of a screen will take you back to the Benefits Selection Criteria screen. Control End and Control Home . Control End will take you immediately to the bottom of any screen and Control Home to the top. Print Function. To print screens use the print function on your browser or if available the print button at the bottom of the screen. Some screen sizes exceed the width of a portrait print. In this case try the landscape option on your printer. You can also try copying the screen to Word Excel or some other utility and print from there. System administrators should be able to assist you if you encounter problems. Save and Save As Functions. Use the Save button to save data in the DV application. Data for a given population saved using the Save button are overwritten when a new extract file for that population is loaded. The Save As button allows you to save a screen shot of the current software screen outside the DV software. Screen shots saved outside the application are not affected by loading new extract files. The Save As button can be used to save screen shots of summary reports and DEV worksheets to satisfy audit requirements. Help functions. The application has Help links on certain screens. Click on this link to display information relevant to the data or functions available on the screen. 4 Unemployment Insurance Data Validation Operations Guide 5 Definitions Certain terms used in the validation process have a specialized meaning within the context of the DV program 1. Extract Files. These files consist of information extracted from state production databases. Each state UI transaction is represented as a row of comma-separated data fields that allow it to be identified as a countable transaction and classified into the report cells being validated. The extract files are used as input for the DV software. 2. Record Layouts. These documents provide detailed information on how to build the extract files. They can be found in the software see Viewing the Record Layouts section or in Appendix A UI Benefits Record Layouts or Appendix B UI Tax Record Layouts of this guide. 3. Module 3. State-specific document used to map the data elements in the record layouts and samples to elements in individual state systems. 4. Populations. Populations are sets of unique non-overlapping types of transactions or statuses that relate to reportable benefits or tax operations. Benefits validation uses 15 such populations of which 12 are transactions during a reporting period e.g. Population 1 Weeks Claimed and three are statuses at the end of a reporting period e.g. Population 10 Age of Pending Lower Authority Appeals . Tax validation uses five populations. An extract file must be constructed for each population. Records in some populations may be used to validate counts from only one UI report e.g. Benefits Population 1 records validate only Weeks Claimed on the ETA 5159 report others are used to validate multiple reports e.g. Benefits Population 4 records validate parts of four benefits reports. 5. Subpopulation. Populations are divided into mutually exclusive subsets called subpopulations. Subpopulations are defined in such a way that they can be used to reconstruct report counts some are used in the reconstruction of more than one reported count. Each record from a population extract file can be assigned to only one subpopulation. For example in Benefits Population 1 UI weeks claimed records are assigned to Subpopulation 1.1 and UCFE weeks claimed records are assigned to Subpopulation 1.2. Unemployment Insurance Data Validation Operations Guide Chapter 2 Logging On To log on to the data validation software follow the next steps. 1 Go to your state Unemployment Insurance Applications Menu screen select Data Validation and then select Main Login . 2 On the Data Validation login screen enter your User Name. Example dv3 6 Unemployment Insurance Data Validation Operations Guide Screen shots in this operations guide might look different fonts and colors than your screen due to your desktop and browser settings. 3 Enter your Password. User name and password are assigned by your state system administrator. Passwords are case-sensitive i.e. the operator must use capital letters or special characters such as or if these are part of the password. 7 Unemployment Insurance Data Validation Operations Guide 4 Select the application you want to log on to i.e. Benefits or Tax Benefits is selected by default 5 Click on the Login button. The State Menu link at the bottom of the screen returns you to the state menu. The Feedback link accesses contact information for technical problems. The Help link accesses information on all available functions on the screen. 8 Unemployment Insurance Data Validation Operations Guide 6 You should see the Benefits Selection Criteria or the Tax Selection Criteria screen depending on the application you selected. The Login link at the bottom of the screen will take you back to the login screen. Click on Population and Choose Function for additional information on these parameters. 9 Unemployment Insurance Data Validation Operations Guide Chapter 3 Viewing the Record Layouts In order to use the data validation software you need to have an extract file which contains the required data for the reporting period you want to validate. The data in the file should be extracted from your state production system in accordance to the specifications described in Appendix A UI Benefits Record Layouts or Appendix B UI Tax Record Layouts of this guide. You will need 15 extract files one for each benefit population and 5 extract files one for each tax population. The record layouts i.e. the extract file specifications are also available in the software. To view them follow the next steps. 1 On the Benefits Selection Criteria or the Tax Selection Criteria screen click on the Population link. 10 Unemployment Insurance Data Validation Operations Guide 2 To see the record layout of a population click on the population s link. Benefits are used in the example Tax will list valid Tax populations. 11 Unemployment Insurance Data Validation Operations Guide The record layout for the population will be displayed. 12 Unemployment Insurance Data Validation Operations Guide Chapter 4 Importing an Extract File To use the data in an extract file to validate reported counts you first need to import the file into the software. To import an extract file follow these steps 1 Select a population from the Population drop down menu on the Benefits or the Tax Selection Criteria screen. 13 Unemployment Insurance Data Validation Operations Guide When you select a population on the lower left corner of the screen you will see the last date this population was imported and which user imported it. If you have never imported this population it will display Never . If you have already imported the population you will see the last day it was imported and the user that imported it. You will also see the last date when validation results were transmitted to DOL. If validation results have not been transmitted to DOL you will see Never . 2 Select Import Data from the Choose Function drop-down menu and click Go. When you select Import Data in Benefits the fields Period Start Date and Period End Date will be displayed. 14 Unemployment Insurance Data Validation Operations Guide You can click on Period Start Date and Period End Date for additional information on these parameters. When you select Import Data in Tax the fields Report Quarter and Year will be displayed. You can click on Report Quarter and Year for additional information on these parameters. If you are loading Tax Population 2 the Tax Selection Criteria screen will also display boxes for Contributory and Reimbursing Dates. These boxes do not display for other tax populations. 15 Unemployment Insurance Data Validation Operations Guide The report due date is a state-designated date after which the state assesses penalty or late charges to employers. The software allows separate dates for contributory and reimbursing reports because some states have different due dates for contributory and reimbursing reports. 3 Enter the reporting period you want to validate. In Benefits you need to enter the Period Start Date and Period End Date using MM DD YYYY format then click Go. For example January 1 st 2008 must be entered as 01 01 2008. You can also click on the calendar icons on the right to select start and end dates from a calendar. 16 Unemployment Insurance Data Validation Operations Guide 17 Use the double arrows on the calendar to scroll through years and the single arrows to scroll through months and then click on the day you wan t to use as start or end date. In Tax select the Report Quarter and insert Year corresponding to your extract file using the drop-down menu next to Report Quarter and type in year using YYYY format then click Go. Scroll years Scroll months Click on day you want to select Unemployment Insurance Data Validation Operations Guide For Tax Population 2 also enter report due dates using MM DD YYYY format before you click Go. You can also click on the calendar icon on the right of each due date to select the report due date from a calendar the same way you would select the reporting dates from the calendar in Benefits. The time period entered or selected should be the same used to construct the extract file you are going to load. 18 Unemployment Insurance Data Validation Operations Guide In Benefits the software allows you to load extract files that do not conform to actual reporting time periods. This option is included for diagnostic purposes only. You should only submit to DOL data validation results that correspond to time periods which match the time period covered by an actual report e.g. the ETA 5159 Report for January 1 31 2008 . The reporting dates are needed only for the import function. Once a population is loaded the user may choose any other function without entering these dates. 4 Enter the full path where the file is located and the name of the extract file into the Import From Extract File box example opt dv data pop1.txt . 19 Unemployment Insurance Data Validation Operations Guide The Clear Query button on the bottom of the screen will reset the Import From Extract File box. The Cancel button will take you back to the Benefits or Tax Selection Criteria screen. All extract files must be copied to the opt dv data directory hence the path name will always be opt dv data filename.txt. This directory was created on the Sun servers exclusively for data validation use. The software will only accept files in text format. File names cannot contain spaces and must end in .txt . 20 Unemployment Insurance Data Validation Operations Guide 5 Click on the Import button to load the extract file into the system. This will take you to the Import Messages screen for information on the loading procedure. On this screen you can see which user is loading the population the start and end times of the load the number of errors found in the file and the total number of rows processed including records in error . 21 Incoming extract files are subjected to various tests to identify 1 Syntax errors 2 logic errors and 3 duplicate records. Unemployment Insurance Data Validation Operations Guide For large files a new import message line will appear for each 5 000 records. Load times vary depending on the number of records in the extract file. The time-out parameter is set to 12 hours while the software is loading to allow ample time for loading large files. Load times are affected by the size of the file the population being loaded and the number of error conditions encountered during the load. The software allows different populations to be resident in the application at the same time but only one data set for each population. If the same population is loaded a second time the new data set will over-write the former. Re-loading the same extract file will produce identical results for report validation but different samples. While the file is loading you can go back to the Benefits or Tax Selection Criteria screen and access screens for other populations. You cannot however load another population or access any of the screens of the population being loaded. A message in red will appear on the screen letting you know that the population is being loaded and the user that is loading it. In addition the Population drop-down menu will not display the population being loaded and the Choose Function drop-down menu will not display the Import function. 22 Unemployment Insurance Data Validation Operations Guide To return to the Import Messages select View Import Messages from the Choose A Function drop-down menu on the Benefits Selection Criteria screen. You don t need to select a Population. Messages displayed on the Import Messages screen are available during the loading operation but are not available after the file has been loaded and the user has left this screen. Information about previous population loads is not available. Users have the option of printing this screen when it is displayed for future reference. To accurately validate Benefits Population 3 reported numbers i.e. RV the extract file for Benefits Population 3a must also be loaded on the software for the same reporting period. When the software generates the RV for Benefits Population 3 it retrieves validation counts for new and transitional claims from the Benefits Population 3 extract file and additional claim counts from the Benefits Population 3a extract file. For more information please refer to Appendix A UI Benefits Report Validation Specifications of the ETA Handbook 361- A Benefits. 23 Unemployment Insurance Data Validation Operations Guide Cancelling a Load To cancel a load in progress follow the next steps. 1 To cancel a load in progress click the Cancel Import button on the Import Messages screen. You should get a message saying that the load was cancelled and the time it was cancelled. 24 Unemployment Insurance Data Validation Operations Guide When you return to the Benefits or the Tax Selection Criteria screen using the Home link you will see a message in red indicating that the load was cancelled and the Last Import date will display Cancelled. When you cancel a load the only screen available for the population for which the load was cancelled is the Errors screen. If you are loading a large file and the number of errors is excessive you don t need to wait until the load finishes to check the type of errors you are getting. Instead cancel the load and check the Errors screen. You will be able to see the errors that were processed up to the point where you cancelled the load. 25 Unemployment Insurance Data Validation Operations Guide Chapter 5 Viewing Errors When extract files are loaded the software reads each record to ensure that all fields are valid with reference to specifications provided in the ETA Handbook 361 Benefits and 361 Tax. There are three kinds of error conditions detected during the import and loading process Syntax errors. This refers to records that are not formatted according to instructions in the population-specific record layouts. Example alpha characters in the social security number field or dollars field. Parsing errors. This refers to records that cannot be assigned to a subpopulation because the values in the fields do not match the required criteria for any of the subpopulations. Duplicate records. This refers to records that are found to be duplicates based on the criteria described in Appendix C UI Benefits Duplicate Detection Criteria or Appendix D UI Tax Duplicate Detection Criteria of this guide. All records with errors are loaded to the Errors table. Records in the Errors table are not included in any of the validation screens and hence cannot be validated. You should inspect these records and determine whether the extract file was not constructed correctly or there is a problem in the state database from which the data was extracted. If the extract file was not constructed correctly fix the file and load it again. If the problem is in your state database for example a field is not being captured your office needs to take steps to fix it. In your review you must try to distinguish between a incorrectly built records that represent countable transactions and b records that do not represent countable transactions. Examples of the latter are one of a set of two duplicate transactions and records with dates putting them out of range for validating the quarter you are trying to validate. Rebuild the file to correct errors of a type a you may eliminate errors of type b from the extract file or just ignore them as they do not enter into validation counts or appear in samples. The Errors screen allows the user to view the records that were found to have errors during the loading operation. To view the Errors screen follow the next steps. 26 Unemployment Insurance Data Validation Operations Guide 1 In the Benefits or Tax Selection Criteria screen select the Population for which you want to see the errors table. Benefits screens will be displayed in the following examples. 2 Select View Errors from the Choose Function drop-down menu and click Go. 27 Unemployment Insurance Data Validation Operations Guide The Errors screen displays records with errors along with an error message for each record. The Errors screen displays 100 records at a time. To see the next 100 records click on the Next link at the bottom of the screen. This link is visible only when there are more than 100 records. If the loaded file contains more than 1 000 errors only the first 1 000 can be viewed and the software will display a red message to inform you of this. 28 Unemployment Insurance Data Validation Operations Guide When a file with no errors is loaded the Errors screen displays No Rows Found in red. Viewing Duplicate Records Duplicate errors are displayed in the Errors screen along with all other errors but can be viewed separately by accessing the Duplicate Detection Report screen. To access this screen follow the steps below. 1 Click on the Duplicate Detection Report link at the bottom of the Errors screen. 29 Unemployment Insurance Data Validation Operations Guide The Duplicate Detection Report screen displays duplicates only. Like in the Errors screen the screen displays only 100 records at a time. To see the next 100 records click on the Next link at the bottom of the screen. This link is visible only when there are more than 100 records. If the loaded file contains more than 1 000 duplicates only the first 1 000 can be viewed and the software will display a red message to inform you of this. 30 Unemployment Insurance Data Validation Operations Guide To go back to the Errors screen click on the All Errors link at the bottom of the screen. When a file with no duplicates is loaded the Duplicate Detection Report screen displays No Rows Found in red. 31 Unemployment Insurance Data Validation Operations Guide 32 Unemployment Insurance Data Validation Operations Guide 32 Unemployment Insurance Data Validation Operations Guide Chapter 6 Viewing the Source Table The Source Table displays all the records that were successfully loaded to the application. To access the Source Table follow the steps below. 1 From the Benefits or Tax Selection Criteria screen select a Population that has been loaded. Benefits screens will be displayed in the following examples. 2 Select View Source Table from the Choose Function drop-down menu and click Go. 33 Unemployment Insurance Data Validation Operations Guide The Source Table screen contains all records parsed but displays only 100 records at a time. At the bottom of the Source Table screen you can see a count of the number of errors found during the loading process and the error rate. You can access the Errors screen from the Source Table screen by clicking on the Show Errors link at the bottom of the screen. You can sort records by any field by clicking at the field header. Click once to sort in ascending order and twice for descending. Applies only to Benefits 34 Unemployment Insurance Data Validation Operations Guide You can sort records by a field to quickly find records with outlier values. For example sort on Weekly Benefit Allowance WBA to find records with values exceeding the state established WBA. The Source Table screen displays 100 records at a time. To see the next 100 records click on the Next link at the bottom of the screen. This link is visible only when there are more than 100 records. If the table contains more than 1 000 records only the first 1 000 can be viewed. The Source Table screen shows the number of errors found during the loading process and the error rate at the bottom of the screen. You can access the Errors screen from the Source Table screen by clicking on the Show Errors link at the bottom of the screen. If no record was successfully loaded the Source Table screen displays a warning message in red. 35 Unemployment Insurance Data Validation Operations Guide Unemployment Insurance Data Validation Operations Guide 36 36 Unemployment Insurance Data Validation Operations Guide Chapter 7 Viewing Validation Counts The Validation Counts screen displays all the subpopulations in the population and the number of records from the extract file that were assigned to each subpopulation. To view the Validation Counts screen follow the next steps. 1 From the Benefits or Tax Selection Criteria screen select a Population that has been loaded. Benefits screens will be displayed in the following examples. 37 Unemployment Insurance Data Validation Operations Guide 2 Select View Validation Counts from the Choose Function drop- down menu and click on Go. The screen displays the subpopulations the report cells for which they are used the type of values expected for records in them and the number of records assigned to each. 38 Unemployment Insurance Data Validation Operations Guide 3 Click on the subpopulation number to view records that were parsed into that subpopulation. You can sort records by any field by clicking at the field header. Click once to sort in ascending order and twice for descending. You can print the screen by clicking on the Print button at the bottom of the screen. The screen displays 100 records at a time. To see the next 100 records click on the Next link at the bottom of the screen. This link is displayed only when there are more than 100 records. 4 Click on the X in the upper right hand corner of the screen to close the screen and return to the Validation Counts screen. 39 Unemployment Insurance Data Validation Operations Guide Chapter 8 Viewing the Report Validation Screen Report validation RV consists of establishing the extent to which reported numbers match report counts reproduced through the data validation process. This comparison process is automated and requires no additional input from state staff. The software retrieves reported numbers from the state UI database and compares them to the validation numbers derived from the extract files. In Benefits percent errors are displayed for each report cell but pass fail scores are displayed for groups. A group passes validation if the percent error is 2 or less except for groups which contain report cells that are used for Government Performance and Results Act GPRA measures which should have a percent error of 1 or less i.e. Groups 4.01 4.02 and 12.04 . If all groups pass the population passes report validation otherwise it fails except in Populations 10 and 11 where there are individual report cells that must also pass in addition to the groups. In Tax percent errors are displayed for each report cell. A report cell passes validation if the percent error is 2 or less except for cells which are used for Government Performance and Results Act GPRA measures which should have a percent error of 1 or less ETA 581 cells 11 and 61 . If all cells pass the population passes report validation otherwise it fails. The Report Validation screen displays the results of report validation. To display the screen follow the steps below. 40 Unemployment Insurance Data Validation Operations Guide 1 From the Benefits or Tax Selection Criteria screen select a Population that has been loaded. Tax screens will be displayed in the following examples unless otherwise noted. 2 Select View Report Validation from the Choose Function drop-down menu and click on Go. The Report Validation screen displays each report cell in the population its description validation count derived from the extract file reported count retrieved from the UI database count difference and percent difference cumulative counts for some groups of report cells and pass fail scores for items that are used to determine the score of RV. If any sco red item fails the RV fails. 41 Unemployment Insurance Data Validation Operations Guide In Benefits at the right bottom corner of the Report Validation screen you can see the Report Validation Status of the population. In Tax the failure of even one count shown on the table will result in the RV Status to Fail while in Benefits a failure in one group will result in the status to Fail. At the bottom of the screen there is a button to access the View Population Scores screen. Click on it to display the status of the RV and DEV which are the two components used to calculate the population score. In Tax DEV is composed of Sorts and Minimum samples and in Benefits it s composed of all random samples for the population. For more information on this screen see section on submitting results to DOL. 42 Unemployment Insurance Data Validation Operations Guide To save a screen shot of the Report Validation screen outside the software follow the next steps. 3 Select Save As from the drop-down menu File on the top left corner of your browser. 4 Select the location where you want to save the screen shot and write in the File Name box the name you want to give the file and click save. 43 Unemployment Insurance Data Validation Operations Guide Chapter 9 Viewing Samples Data element validation DEV consists of the investigation of samples drawn from extract files to verify that the information in the records is accurate. Four kinds of samples are drawn random missing subpopulations outliers and minimum Random. These samples are drawn from specific subpopulations within extract files. These were designed as two-tier samples so that the second tier of the sample does not have to be investigated if the results of the investigation of the first tier are conclusive. The samples are either 30 100 or 60 200 where the first number indicates the size of the first tier and the second number the size of the whole sample. So for example in a 30 100 sample 30 cases are investigated in the first tier and 70 on the second for a total of 100 records. These samples pass with an error rate of 5 or less. Missing subpopulations. These samples are dependant on the random samples. Each sample consists of one case from each subpopulation that is in the universe of the related random sample but was not selected in the random sample. Minimum. These samples consist of two cases from each subpopulation included in the sample frame. Outliers. These samples consist of 10 records with extreme values the five largest and five smallest values for the variable of interest in the data set. Benefits uses all four samples and Tax only uses minimum but Tax DEV also includes sorts. In Benefits only random samples are scored and submitted to DOL. The other samples in Benefits are included for diagnostic purposes but failure of a non-random sample does not require corrective action. States should investigate them and keep a record of their results for auditing purposes. Tax Data Element Validation DEV has two parts Minimum Samples previously known as File Integrity Validation FIV samples and Data Element Sorts validation refer to Chapter 10 for more information . The minimum samples are so small that in order to pass this aspect of DEV all sampled records must be free of errors. 44 Unemployment Insurance Data Validation Operations Guide For both Benefits and Tax the RV of a population is not valid unless the population passes all applicable DEV tests. To view the samples of a population follow the next steps. 1 From the Benefits or Tax Selection Criteria screen select a Population that has been loaded. Benefits screens will be displayed in the following examples. 2 Select View Samples from the Choose Function drop-down menu and click on Go. 45 Unemployment Insurance Data Validation Operations Guide The Sample ID number on the Samples screen identifies the specific sample. Sample Type describes it as one of the four types of samples described above random minimum outlier or missing subpopulations . Sample Description is a narrative explanation of the subpopulations included in the sample frame for each sample. 3 Click on the Sample ID of the sample you want to view. 46 Unemployment Insurance Data Validation Operations Guide The Sample Validation screen displays the records selected in the sample that are to be investigated. The number and description of the sample are displayed at the top of the screen. This screen is used to enter the results of the investigation. The step numbers on the headers of the columns refer to the steps in Module 3 of the data validation handbook. 47 Unemployment Insurance Data Validation Operations Guide Printing Sample Worksheets Before you start investigating each record in a sample it is recommended that you print the worksheets for all records. You can annotate validation results in these worksheets and later enter all results in the Sample Validation screen. To print the worksheets follow the next steps. Benefits screens will be displayed in the following examples. 1 Click the Print Worksheets button. This button is displayed at the top and bottom of the Sample Validation screen. Click on either button. 48 Unemployment Insurance Data Validation Operations Guide 2 Start Row and End Row boxes will be displayed at the bottom of the screen. Enter the range of rows that you want to print and click Go. For example enter 1 in Start Row and 4 in End Row and click Go to print sample worksheets for rows 1 to 4. To print the worksheet of only one record enter the row number of the record in the Start Row and End Row boxes. For example to print the record in the second row enter 2 in both the Start Row and End Row boxes. 49 Unemployment Insurance Data Validation Operations Guide The worksheets display the records with all fields and corresponding values in portrait orientation. 3 Scroll to the end of the screen and click on Print Preview. 50 Unemployment Insurance Data Validation Operations Guide If instead of printing you want to add more records to print click on Get More Rows. Start Row and End Row boxes will be displayed at the bottom of the screen. Enter the range of rows that you want to add and click Go. Then click on Print Preview. 51 Unemployment Insurance Data Validation Operations Guide 4 Click Print on the left top corner of the screen. 5 Select a printer and click Print. You can keep worksheets for samples you submit to the DOL as evidence of the work done in case you are subject to an Office of Inspector General OIG audit. 52 Unemployment Insurance Data Validation Operations Guide Entering Validation Results for Non-random Samples Minimum Missing Subpopulations and Outliers After you investigate each record you need to enter the results of the validation into the software. To enter results for non-random samples go to the Sample Validation screen of the sample you are investigating and follow the next steps. 1 For each data element go to the box next to it click on the drop-down menu and select pass or fail according to your findings. Tax screens will be displayed in the following examples unless otherwise noted. If all elements in a record have passed you don t have to enter results individually for each data element. You can instead click on the Pass Row box at the beginning of the row and all boxes for that row will be filled with Pass . 53 Unemployment Insurance Data Validation Operations Guide For a record that has only a few elements failed and the rest of the elements passed you can select Fail for the elements that failed and then check the Pass Row box at the beginning of the row to change the remaining blank boxes to Pass . If all of the records within the sample have passed all data elements you can select the Check All box on the top left corner of the table to change all blank boxes to Pass . You can enter Fail for the elements that have failed for the whole sample and then click the Check All box to change the remaining blank boxes to Pass . 2 Click Save to save all entered results. When you click Save the software will display a summary of your results at the bottom of the screen including the number of cases reviewed and the number of cases in error. The Save button will save your results in the software. You can use this button to save partial results if you need to log out from the software. When you return to this screen all results you have entered so far will be 54 Unemployment Insurance Data Validation Operations Guide displayed. for Taxes the Save button saves your data to your state s database . 3 When you finish validating all records click on the Save Final Validation Results only appears on Benefits screen button at the top or bottom of the screen to save your data in your state s database. Click OK. 55 Unemployment Insurance Data Validation Operations Guide Click OK. You can later access these data by querying your database but the data will be erased from the software when the population is reloaded. The Save As button displayed at the top and bottom of the screen can be used to save a screen shot of your results outside the software. To do this follow the next steps. 4 Click on Save As. 56 Unemployment Insurance Data Validation Operations Guide 5 Select the location where you want to save the screen shot and write in the File name box the name you want to give the file. Click on Save. 6 When you finish entering and saving your sample validation results close the Sample Validation screen by clicking the X in the upper right-hand corner. Click OK 57 Unemployment Insurance Data Validation Operations Guide Entering Validation Results for Random Samples When validating random samples Benefits you first have to validate records on the first tier of the sample. If the results are conclusive you don t need to validate the second tier rest of the sample . If results are inconclusive you need to go to the second tier and enter results for the rest of the sample. To enter results for random samples follow the next steps. First Tier 1 When you first open the Sample Validation screen for a random sample you will see the records in the first tier of the sample i.e. the firs t 30 records for a 30 100 sample or the first 60 records for a 60 200 sample. Enter validation results for all records on the screen by following the instructions described in Step 1 of the previous section for non-random samples. If the sample s universe size is less than 30 for 30 100 samples or 60 for 60 200 samples i.e. if the extract file has less than 30 or 60 records respectively from which to select that sample you will see all records selected for the sample on the screen and you will not have to complete a second tier. 58 Unemployment Insurance Data Validation Operations Guide 2 Click Save. If the results are conclusive the screen will display a summary of your results at the bottom of the page along with a pass or fail score. You have finished the validation and don t need to complete the second tier. If the sample universe is smaller than the 30- or 60-case tier one sample the results will be conclusive regardless of the number of errors. If the results are inconclusive clicking on Save will bring up the following pop-up window informing you that you need to go to the second tier. Click OK. If you need to exit the software before entering all your results click Save before you do so so that you don t lose any of your results. Also if you are inactive for more than 59 minutes the time-out limit save your work before to avoid losing your results. 59 Unemployment Insurance Data Validation Operations Guide Second Tier 3 To go to the second tier click on one of the Switch to Tier 2 buttons available at the top and bottom of the screen. The first tier s records are going to be disabled but still visible on the screen and the records for the second tier are going to be displayed. 60 Unemployment Insurance Data Validation Operations Guide If you want to edit results for any records on the first tier you can click on either of the Back to Tier 1 buttons available at the top and bottom of the screen. However if you had entered any results for records on the second tier you will lose them. The software will give you a warning before going back to tier 1. Click OK if you want to go to tier 1 or Cancel to return to Tier 2. Be aware that returning to tier 1 from tier 2 might take a long time. 4 Enter results for all records on the second tier the same way you entered results on the first tier. Follow the first tier instructions described under Step 1. 61 Unemployment Insurance Data Validation Operations Guide 5 When you finish entering results click Save. A summary of your results will be displayed at the bottom of the page along with a pass or fail score. 6 If you want to save a screen shot click Save As and follow the steps described in the previous section. 62 Unemployment Insurance Data Validation Operations Guide Viewing the Data Element Validation Report The Data Element Validation Report screen provides summary information about completed sample investigations for a given population. This report is for informational purposes only. It provides for example the number of cases in error and the derived percent of errors established through the sample investigation process. The report can be printed and or saved outside the application but there is no Transmit button for export to DOL. To access this screen follow the next steps. 1 Click on the link Data Element Validation Report screen located at the bottom of the Samples screen. 63 Unemployment Insurance Data Validation Operations Guide The screen will show results that you have entered for all samples. You can print this screen by clicking on Print and save it outside the software by clicking on Save As. 64 Unemployment Insurance Data Validation Operations Guide Chapter 10 Viewing Data Element Sorts in Tax The purpose of data element sorts validation is to determine whether the generic primary codes used to assign transactions e.g. C Contributory and R Reimbursing in Populations 1 and 2 are accurately supported by state-specific secondary codes or specific ranges of employer account numbers EANs . If a state s database does not have more than one state-specific code for a given generic code or does not use EAN ranges these tests do not apply. Also these tests do not apply to Population 5. A data element passes sort validation if no more than 2 of the sorted transactions include an incorrect state-specific code. For detailed information on data element sort validation check Module 2.3 of the tax handbook. The following table illustrates the relationship between tax populations sorts and sub-populations. The Test Data Element column identifies the data element used by the software to perform the sort. Tax Populations Sorts and Sub-populations Population Sort Subpopulations Examined Test Data Element 1 S1.1 1.1 Contributory Employers EAN 1 S1.2 1.2 Reimbursing Employers EAN 1 S1.3 1.1 1.2 All employers Employer Status Indicator 1 S1.4 1.1 Contributory Employers Employer Type Indicator 1 S1.5 1.2 Reimbursing Employers Employer Type Indicator 2 S2.1 2.1 2.8 Contributory Employers EAN 2 S2.2 2.9 2.16 Reimbursing Employers EAN 2 S2.3 2.1 2.8 Contributory Employers Employer Type Indicator 2 S2.4 2.9 2.16 Reimbursing Employers Employer Type Indicator 3 S3.1 3.1 3.3 New Status Det. Status Determination Type 3 S3.2 3.4 3.6 Successor Status Det. Status Determination Type 3 S3.3 3.7 Inactivation Det. Status Determination Type 3 S3.4 3.8 Termination Det. Status Determination Type 4 S4.1 4.1 4.9 Establishment Transaction Transaction Type Indicator 4 S4.2 4.2 4.10 Liquidation Transaction Transaction Type Indicator 4 S4.3 4.3 4.4 4.11 4.12 Uncollectible Transactions Transaction Type Indicator The software has two different sorting me thods to determine which employers or transactions are out of range query and frequency distribution. The query is available for EANs and the frequency distribution for all other data elements. The next sections will explain each method in detail. To access the Data Element Sorts screen follow the next steps. 65 Unemployment Insurance Data Validation Operations Guide 1 From the Tax Selection Criteria screen select a Population that has been loaded. 2 Select View Data Element Sorts from the Choose Function drop-down menu and click Go. The Data Element Sorts screen displays each data element to be sorted the corresponding step in Module 3 that is used to validate it and the number of cases to be validated. Each data element has a sort number 66 Unemployment Insurance Data Validation Operations Guide assigned to it e.g. S1.1. The sort numbers are displayed as links that take you to the sorting function. Entering Data Element Sorts Results To enter results for data element sorts follow the next steps. 1 If your state does not have secondary codes for the data element you cannot do sort validation for that data element. In that case click on the N A box next to the data element. The data element is disabled and the Status column displays N A . 67 Unemployment Insurance Data Validation Operations Guide 2 If your state has secondary codes for the data element or assigns EAN ranges to contributory and reimbursing employers click on the sort number link. For example click on S1.1 . If the data element is EAN you will get a query screen. For other data elements you will get a screen showing a frequency distribution of codes. Query Screen If your state assigns a certain range of EAN numbers to contributory employers and another range to reimbursing employers you can query against the EANs in your extract file to determine if there are any numbers out of range. Select the type of query you want to execute and the parameters for the query. The software offers three possible queries starts with ends with and is between. Starts with retrieves all employers whose EANs begin with the sequence you identify. For example to get all the records with an EAN starting with 3000 click the starts with option and enter 3000 in the first box. 68 Unemployment Insurance Data Validation Operations Guide Ends with retrieves all employers whose EAN ends with the sequence you identify. For example to get all the records with an EAN ending in 1230 click the ends with option and enter 1230 in the first box. Is between allows you to specify a range starting with an EAN value in the first box and an ending value in the second box. The query returns the set of employers that falls within the specified range. For example to get all the records with an EAN between 3000 and 502222 click the is between option enter 3000 in the first box and 502222 in the second box. You can save your parameters by clicking on Save Parameters. Click on the Query button. 69 Unemployment Insurance Data Validation Operations Guide The software displays a screen with all records that satisfy the query parameters. At the bottom of the screen the total number of records retrieved is displayed. If the number returned by the query exceeds 10 000 the software displays the first 10 000 beginning with the lowest EAN. If you query for valid values for example if your state s EANs always start with 4 and you query for those records then the records the software retrieves are all correct. In this case compare the number of records retrieved with the number of cases in the Data Element Sort screen. The difference between these numbers equals the number of records that have an incorrect EAN i.e. the number of errors. For example if you retrieved 4 correct records using the query and the number of cases is 12 then there are 8 records in error. If you query for invalid values for example if all EANs in your state can end in any digit but 9 and you query for all EANs ending in 9 then the total number of records retrieved equals the number of errors. In some cases you might want to execute multiple queries to find the number of errors. For example if the EANs in your state should be between 007900000 and 007999999 then you can query for records above the upper limit and below the lower limit of your state s EAN range i.e. run a query for records beginning with 000000000 and ending with 007899999 and another query for 008000000 and above. Add the number of records returned by both queries to get the total number of errors. 70 Unemployment Insurance Data Validation Operations Guide Frequency Distribution Screen If your state has multiple codes for active employers employer type or types of transactions you can determine which records have an incorrect code by looking at their frequency distribution of codes. 1 After you click on the sort number link of a data element that is not an EAN a window will come up showing a frequency distribution of all codes. Look at all the codes and determine whether these are correct. Add up all the counts of incorrect codes to determine the total number of errors for the data element you are validating. For example in the previous screen if you are validating Inactive codes and 315 and 316 are not Inactive codes in your state system then you have a total of 11 8 3 errors for Inactive. 2 To view all records that were counted for a code click on the code link . 71 Unemployment Insurance Data Validation Operations Guide The software can only display the first 10 000 records. After you determine how many errors you have for a data element either by querying or by using the codes frequency distribution enter that number in the Data Element Sorts screen. To do this follow the next steps. 3 Enter the number of records in error for the data element you are validating in the of Errors field on the Data Element Sorts screen. 72 Unemployment Insurance Data Validation Operations Guide 4 Click the Save button at the bottom of the screen. 5 You will get a pop up window confirming that you have saved the data. Click OK. The software calculates the percentage of errors and determines whether the data element passed sort validation. It also calculates the Data Element Sorts Status. 73 Unemployment Insurance Data Validation Operations Guide If you haven t completed all the sorts the status will display Incomplete . In order to submit results to the DOL you first need to complete all sorts by either entering the number of errors or checking the N A box and click Save. When you complete and save all sorts for a population the status field will display Pass or Fail. 74 Unemployment Insurance Data Validation Operations Guide Chapter 11 Viewing the Wage Item Validation Screen in Tax Wage item validation consists of reviewing counts of wage record transactions which appear on the ETA 581 report to verify their accuracy. A wage record is the listing of an individual s earnings in covered employment. Employers are required to provide this information to the Unemployment Insurance program four times per year. To validate wage items you need to compare counts from the ETA 581 with reconstructed counts produced under controlled conditions. You should test that every wage item is counted and that the count does not include corrections counted twice incomplete wage records or duplicate records. You can find a detailed explanation in Module 5 of the ETA Handbook 361- Tax. To enter wage item validation results into the software follow the next steps. 1 Select View Wage Item Validation from the Other Validations box on the Tax Selection Criteria screen and click View. When you select Wage Item Validation you will see the date results were last transmitted to the National Office at the bottom of the Other Validations box. If you have not transmitted any results the Last Transmitted field will display Never . 75 Unemployment Insurance Data Validation Operations Guide 2 Click on View to get to the Wage Item Validation screen. If you have never entered results before you might get a screen with no wage items. 3 Select the method used to select wage records i.e. Batch or Representative Time Periods. If you have previously entered results you will see them. Wage items do not get overwritten when you load extract files and are not dependant on any population. 76 Unemployment Insurance Data Validation Operations Guide 4 To add a wage item. Click on the Add Wage Item button located at the bottom of the screen. 5 In the Add Wage Items for Validation pop up window enter the information for the wage item you want to add and click Save. The Period field must be formatted as MM DD YYYY and must correspond to the period being validated. Enter the counts for the applicable time period that are reflected in a given ETA 581 Report in the Batch Count field. Enter the recount for that category in the Batch Recount field. 77 Unemployment Insurance Data Validation Operations Guide When you save the item the Wage Item Validation screen displays the item added and calculates the Difference between the Batch Count and Batch Recount fields the Total Errors the Percentage of Errors and whether the item Pass Fail validation. Information entered in the Missing ID Count Missing Amount Count and Double Count fields is for diagnostic purposes only and does not contribute to the percent of error calculations. Repeat this procedure to ensure that you have validated wage items for every mode your state s employers use to submit them. 6 To update any field of a wage item other than the Mode field click on the field box you want to edit and edit the field. Then click the Save button at the button of the screen to save your changes. You cannot update the Mode field. Instead you need to delete the wage item and add a new one with the correct Mode. 78 Unemployment Insurance Data Validation Operations Guide 7 To delete a wage item click on the Delete button next to the wage item located on the column Delete Wage Item A pop-up window will be displayed to confirm your request. Click OK to delete the item or Cancel if you don t want to delete it. 8 After you finish entering your validation results click the Save button at the bottom of the screen to save your work. 79 Unemployment Insurance Data Validation Operations Guide Chapter 12 Submitting Results to DOL Adding Comments You can add individual comments to your RV samples sorts and wage items results before transmitting them to DOL by using the Comments buttons on the Report Validation Sample Validation Data Element Sorts and Wage Item Validation screens. To add comments follow the steps below. Tax screens will be displayed in the following examples. 1 From the Benefits or Tax Selection Criteria screen select the Population for which you want to add comments. 80 Unemployment Insurance Data Validation Operations Guide 2 Select the screen for which results you want to add comments from the Choose Function drop-down menu and click on Go. For adding comments to wage item validation results select View Wage Item Validation from the Other Validations box on the Tax Selection Criteria screen and click View. 81 Unemployment Insurance Data Validation Operations Guide 3 Click on the Add Comments button. In the Report Validation screen the Add Comments button is located at the bottom of the screen. In the Sample Validation screen the Add Comments button is displayed at the top and bottom of the screen. Click on either one. 82 Unemployment Insurance Data Validation Operations Guide In the Data Element Sorts screen only available in Tax the Add Comments button is displayed at the bottom of the screen. In the Wage Item Validation screen the Add Comments button is displayed at the top and bottom of the screen. Click on either one. 83 Unemployment Insurance Data Validation Operations Guide 4 Write your comments in the comment box and click Save. You have a limit of 512 characters. Only saved comments will be transmitted. 5 Close the comments window by clicking on the X located on the top right corner of the window. The Clear button at the bottom of the Comments screen will erase the contents of the comment box. The Reset button will erase any additional comments written after the comments were last saved. Transmitting Population Results After you complete RV and DEV you can transmit the results to DOL with or without comments. Only completed and conclusive sample investigations can be transmitted. Results are transmitted jointly for RV and DEV samples. You may choose not to submit the results of a validation exercise but keep in mind that any results resident in the software for a given population will be lost when a new extract file for that population is imported it overwrites the prior data. 84 Unemployment Insurance Data Validation Operations Guide When you transmit results to DOL only summary information and comments are transmitted. Detailed information from individual records is not transmitted to DOL. This means that sensitive information such as SSNs stays at the state level. You can forward RV and DEV results to DOL using the Transmit button at the bottom of the Population Scores screen. Submissions are transferred to DOL overnight so they will be received the next day. To submit results along with comments saved if any follow the next steps. 1 From the Benefits or Tax Selection Criteria screen select the Population for which you want to submit results. 85 Unemployment Insurance Data Validation Operations Guide 2 Select View Population Scores from the Choose Function drop-down menu and click on Go. The Population Scores screen can also be accessed from the Report Validation Sample Validation or Data Element Sorts Tax only screens by clicking on the View Population Scores button. 86 Unemployment Insurance Data Validation Operations Guide In Benefits the Population Scores screen displays scores for the RV and all the random samples and an overall score for the population. It also displays the date when results for the population were last transmitted to the National Office. 87 Unemployment Insurance Data Validation Operations Guide In Tax he Population Scores screen displays scores for the RV minimum sample and sorts and an overall score for the population. It also displays the date when results for the population were last transmitted to the National Office. 3 Click on the Transmit button located at the bottom of the screen. 88 Unemployment Insurance Data Validation Operations Guide You can only transmit results if you have completed DEV. If you haven t you will get the following message. Click OK and complete all samples and sorts if applicable . After you complete all DEV return to the Population Scores screen. Click on the Transmit button to submit your results. 4 Click OK on the pop up window if you want to transmit the results. Click Cancel if you don t. You will get a message confirming that your results were submitted. Click OK. 89 Unemployment Insurance Data Validation Operations Guide In the Population Scores of Benefits or Tax Selection Criteria screens the Last Transmitted date should reflect the date when you last transmitted results for the population. If you have never submitted results the field would display Never . 90 Unemployment Insurance Data Validation Operations Guide Transmitting Wage Item Validation Results You submit wage item validation results to DOL using the Transmit button at the bottom of the Wage Item Validation screen. To transmit wage item validation results follow the next steps. 1 Click on the Transmit button. The Transmit button is located at the bottom of the Wage Item Validation screen. Clicking the transmit button multiple times or closing the application before the submission process is complete could cause problems with your submission. Click only one time and wait until you get the window saying Your data has been submitted successfully . 91 Unemployment Insurance Data Validation Operations Guide 2 Click OK on the pop up window if you want to transmit the results. Click Cancel if you don t. You will get a pop up window confirming your action. Click OK. When you return to the Tax Selection Criteria screen the Last Transmitted field at the bottom of the Other Validations box will be updated. 92 Unemployment Insurance Data Validation Operations Guide APPENDIX A A-1 Unemployment Insurance Data Validation Operations Guide EXPLANATION OF UI BENEFITS DATA FORMATS There are five types of data formats referred to in Appendix A. 1. Required. These fields cannot be blank. They may be mandatory dates and dollar values. 2. Text. These fields have text values that must be entered such as UI partial voluntary quit etc. All of the allowable generic text values for each field are listed in the record layout. The generic text values must be followed by a dash and the corresponding state-specific value. 3. Optional these fields are gray in Appendix A . The software does not look at these fields at all. Any values can be entered or they can be left blank. 4. Must be blank. These are text or date fields where the presence of data indicates an error. Therefore they must be left blank such as monetary date where the subpopulation is for a claim with no monetary determination or a UCFE amount for a UI only payment . 5. Must be blank or 0. These are numeric fields where the presence of data other than 0 indicates an error. Some values are abbreviated in the record layouts Appendix A but are shown in the report validation specifications Appendix A in their entirety for informational purposes. Notes For most steps referenced in Appendix A column headers Rule 1 is the indicator in the state system. However if a state does not maintain the indicator specified in Rule 1 then the state programmer must review the other rules in that step in order to develop the required validation logic. Unique ID is required for populations 2 4 6 7 8 9 10 and 11 and optional for populations 5 12 13 and 14 because not all states maintain the indicators for these four populations. There is no unique ID field for populations 1 and 3. Federal Wages are required in certain situations. In population 4 for Joint UI Federal payments UCFE amount and or UCX amount is required. In population 4 for UCFE or UCFE UCX payments UCX amount is only required for joint UCFE and UCX claims. In populations 12 13 and 14 federal amount is required for UI overpayments when there are also federal wages. A-1 8 Q H P S O R P H Q W Q V X U D Q F H D W D 9 D O L G D W L R Q 2 S H U D W L R Q V X L G H 3 3 1 5 2 5 2 8 7 1 7 6 5 2 5 2 8 7 2 5 3 2 3 8 7 2 1 7 K L V U H F R U G O D R X W S U R Y L G H V W K H I R U P D W I R U W K H Y D O L G D W L R Q H W U D F W I L O H 7 K H H W U D F W I L O H W S H P X V W E H 6 F R P P D G H O L P L W H G F R O X P Q V D W D P X V W E H L Q W K H R U G H U O L V W H G L Q W K H U H F R U G O D R X W 7 K H G D W D R U P D W F R O X P Q L Q G L F D W H V W K H J H Q H U L F Y D O X H V I R U W H W I L H O G V 7 K H V H P X V W E H I R O O R Z H G E D G D V K D Q G W K H V W D W H V S H F L I L F Y D O X H 7 K H 0 R G X O H U H I H U H Q F H L Q G L F D W H V W K H V W H S Z K H U H W K H V W D W H V S H F L I L F Y D O X H V D U H G R F X P H Q W H G D P S O H I W K H V W D W H V S H F L I L F F R G H I R U 8 3 U R J U D P 7 S H L V W K H Q W K H G D W D I R U P D W Z R X O G E H 8 1 R L H O G 1 D P H 0 R G X O H 5 H I H U H Q F H L H O G H V F U L S W L R Q D W D R U P D W D W D 7 S H R Q V W U D L Q W 2 6 6 W D W H D V V L J Q H G V H T X H Q W L D O X Q L T X H L G H Q W L I L H U I R U H D F K U H F R U G L Q W K H H W U D F W I L O H 1 X P E H U 5 H T X L U H G 1 7 5 1 2 7 1 8 O D L P H H N H Q G L Q J D W H 6 W H S 5 X O H 7 K H Z H H N H Q G L Q J G D W H R I W K H Z H H N F O D L P H G D W H 0 0 5 H T X L U H G 7 1 2 7 1 8 6 6 1 6 W H S 5 X O H 6 R F L D O 6 H F X U L W 1 X P E H U 1 X P E H U 5 H T X L U H G 5 1 2 7 1 8 7 S H R I 8 3 U R J U D P 5 H J X O D U 8 6 W H S 5 X O H 5 H J X O D U 8 F O D L P 7 H W 5 H J X O D U 8 5 H T X L U H G 5 1 2 7 1 8 3 U R J U D P 7 S H 8 6 W H S 5 X O H 8 6 W H S 5 X O H 8 6 W H S 5 X O H 8 8 R U 8 7 H W 8 8 8 5 H T X L U H G 5 1 2 7 1 8 Q W U D V W D W H Q W H U V W D W H Q W U D V W D W H 6 W H S 5 X O H V D Q G Q W H U V W D W H 5 H F H L Y H G D V L D E O H 6 W D W H 6 W H S 5 X O H V D Q G Q W H U V W D W H L O H G U R P J H Q W 6 W D W H 6 W H S 5 X O H V D Q G Q W U D V W D W H Q W H U V W D W H U H F H L Y H G D V O L D E O H V W D W H R U Q W H U V W D W H I L O H G I U R P D J H Q W V W D W H 7 H W Q W U D V W D W H Q W H U V W D W H O L D E O H Q W H U V W D W H D J H Q W 5 H T X L U H G 5 1 2 7 1 8 D W H H H N O D L P H G 6 W H S 5 X O H 7 K H G D W H W K H Z H H N Z D V F O D L P H G D W H 0 0 5 H T X L U H G 7 1 2 7 1 8 8 Q H P S O R P H Q W Q V X U D Q F H D W D 9 D O L G D W L R Q 2 S H U D W L R Q V X L G H 3 3 1 5 2 5 2 8 7 1 R L H O G 1 D P H 0 R G X O H 5 H I H U H Q F H L H O G H V F U L S W L R Q D W D R U P D W D W D 7 S H R Q V W U D L Q W 0 R Q H W D U L O O L J L E O H R U 3 H Q G L Q J 6 W H S 5 X O H O D L P D Q W L V P R Q H W D U L O H O L J L E O H I R U E H Q H I L W V Z K H Q W K H Z H H N Z D V F O D L P H G L I E H Q H I L W V K D Y H Q R W E H H Q H K D X V W H G R U P R Q H W D U H O L J L E L O L W L V S H Q G L Q J L H H O L J L E L O L W K D V Q R W E H H Q I L Q D O O G H W H U P L Q H G 7 H W O L J L E O H 3 H Q G L Q J 2 S W L R Q D O 5 D U Q L Q J V 6 W H S 5 X O H D U Q L Q J V I R U W K H Z H H N F O D L P H G H F H S W I R U L Q W H U V W D W H I L O H G I U R P D J H Q W V W D W H F O D L P V 1 X P E H U 5 H T X L U H G H F H S W R S W L R Q D O I R U Q W H U V W D W H I L O H G I U R P D J H Q W V W D W H F O D L P V 0 6 W H S 5 X O H H H N O E H Q H I L W D O O R Z D Q F H 1 X P E H U 5 H T X L U H G 0 1 2 7 1 8 8 V H U 8 V H U G H I L Q H G I L H O G D Q E H X V H G I R U D Q D G G L W L R Q D O G D W D H O H P H Q W 1 R W P D Q G D W R U 7 H W 2 S W L R Q D O 5 8 Q H P S O R P H Q W Q V X U D Q F H D W D 9 D O L G D W L R Q 2 S H U D W L R Q V X L G H 3 3 1 5 2 5 2 8 7 1 7 6 5 2 5 2 8 7 2 5 3 2 3 8 7 2 1 7 K L V U H F R U G O D R X W S U R Y L G H V W K H I R U P D W I R U W K H Y D O L G D W L R Q H W U D F W I L O H 7 K H H W U D F W I L O H W S H P X V W E H 6 F R P P D G H O L P L W H G F R O X P Q V D W D P X V W E H L Q W K H R U G H U O L V W H G L Q W K H U H F R U G O D R X W 7 K H G D W D R U P D W F R O X P Q L Q G L F D W H V W K H J H Q H U L F Y D O X H V I R U W H W I L H O G V 7 K H V H P X V W E H I R O O R Z H G E D G D V K D Q G W K H V W D W H V S H F L I L F Y D O X H 7 K H 0 R G X O H U H I H U H Q F H L Q G L F D W H V W K H V W H S Z K H U H W K H V W D W H V S H F L I L F Y D O X H V D U H G R F X P H Q W H G D P S O H I W K H V W D W H V S H F L I L F F R G H I R U 8 L V W K H Q W K H G D W D I R U P D W Z R X O G E H 8 1 R L H O G 1 D P H 0 R G X O H 5 H I H U H Q F H L H O G H V F U L S W L R Q D W D R U P D W D W D 7 S H R Q V W U D L Q W 2 6 6 H T X H Q W L D O Q X P E H U V W D U W D W 3 U R Y L G H V I R U D X Q L T X H L G H Q W L I L H U I R U H D F K U H F R U G L Q W K H H W U D F W I L O H 1 X P E H U 5 H T X L U H G 1 7 5 1 2 7 1 8 6 6 1 6 W H S 5 X O H 6 R F L D O 6 H F X U L W 1 X P E H U 1 X P E H U 5 H T X L U H G 5 1 2 7 1 8 K H F N 1 X P E H U 8 Q L T X H 6 W H S 5 X O H 7 K H F K H F N Q X P E H U R U R W K H U X Q L T X H 1 X P E H U 5 H T X L U H G 5 1 2 7 1 8 7 S H R I 8 3 U R J U D P 5 H J X O D U 8 6 W H S 5 X O H 5 H J X O D U 8 F O D L P 7 H W 5 H J X O D U 8 5 H T X L U H G 5 1 2 7 1 8 3 U R J U D P 7 S H 8 6 W H S 5 X O H 8 6 W H S 5 X O H 8 6 W H S 5 X O H 8 8 R U 8 7 H W 8 8 8 5 H T X L U H G 5 1 2 7 1 8 0 6 W H S D Q G 5 X O H 7 K H P D L P X P E H Q H I L W D O O R Z D Q F H 1 X P E H U 5 H T X L U H G 0 1 2 7 1 8 6 W H S 5 X O H V D Q G 7 K H Z H H N O E H Q H I L W D O O R Z D Q F H 1 X P E H U 5 H T X L U H G 0 1 2 7 1 8 F W X D O H H N V R I X U D W L R Q 6 W H S 5 X O H V D Q G 7 K H Q X P E H U R I D F W X D O Z H H N V R I G X U D W L R Q R I W K H F O D L P 1 X P E H U 5 H T X L U H G H F H S W R S W L R Q D O I R U 8 D Q G 8 F O D L P V 1 7 5 8 Q H P S O R P H Q W Q V X U D Q F H D W D 9 D O L G D W L R Q 2 S H U D W L R Q V X L G H 3 3 1 5 2 5 2 8 7 1 R L H O G 1 D P H 0 R G X O H 5 H I H U H Q F H L H O G H V F U L S W L R Q D W D R U P D W D W D 7 S H R Q V W U D L Q W 0 D L P X P H H N V R I X U D W L R Q 6 W H S V D Q G 5 X O H 7 K H Q X P E H U R I D F W X D O Z H H N V R I G X U D W L R Q D W W K H P D L P X P R U Q R W 7 H W 1 5 H T X L U H G H F H S W R S W L R Q D O I R U 8 D Q G 8 F O D L P V 5 0 D L O D W H R I L Q D O 3 D P H Q W 6 W H S 5 X O H 7 K H P D L O G D W H R I W K H I L Q D O S D P H Q W D W H 0 0 5 H T X L U H G 7 1 2 7 1 8 D O D Q F H 6 W H S 5 X O H 7 K H E D O D Q F H O H I W R Q W K H F O D L P D W W K H W L P H R I W K H I L Q D O S D P H Q W 1 X P E H U 5 H T X L U H G 0 1 2 7 1 8 8 V H U 8 V H U G H I L Q H G I L H O G D Q E H X V H G I R U D Q D G G L W L R Q D O G D W D H O H P H Q W 1 R W P D Q G D W R U 7 H W 2 S W L R Q D O 5 8 Q H P S O R P H Q W Q V X U D Q F H D W D 9 D O L G D W L R Q 2 S H U D W L R Q V X L G H 3 3 1 5 2 5 2 8 7 1 7 6 5 2 5 2 8 7 2 5 3 2 3 8 7 2 1 7 K L V U H F R U G O D R X W S U R Y L G H V W K H I R U P D W I R U W K H Y D O L G D W L R Q H W U D F W I L O H 7 K H H W U D F W I L O H W S H P X V W E H 6 F R P P D G H O L P L W H G F R O X P Q V D W D P X V W E H L Q W K H R U G H U O L V W H G L Q W K H U H F R U G O D R X W 7 K H G D W D R U P D W F R O X P Q L Q G L F D W H V W K H J H Q H U L F Y D O X H V I R U W H W I L H O G V 7 K H V H P X V W E H I R O O R Z H G E D G D V K D Q G W K H V W D W H V S H F L I L F Y D O X H 7 K H 0 R G X O H U H I H U H Q F H L Q G L F D W H V W K H V W H S Z K H U H W K H V W D W H V S H F L I L F Y D O X H V D U H G R F X P H Q W H G D P S O H I W K H V W D W H V S H F L I L F F R G H I R U 7 U D Q V L W L R Q D O F O D L P L V 7 W K H Q W K H G D W D I R U P D W Z R X O G E H 7 5 1 6 7 2 1 1 R L H O G 1 D P H 0 R G X O H 5 H I H U H Q F H L H O G H V F U L S W L R Q D W D R U P D W D W D 7 S H R Q V W U D L Q W 2 6 6 W D W H D V V L J Q H G V H T X H Q W L D O X Q L T X H L G H Q W L I L H U I R U H D F K U H F R U G L Q W K H H W U D F W I L O H 1 X P E H U 5 H T X L U H G 1 7 5 1 2 7 1 8 6 6 1 6 W H S 5 X O H 6 R F L D O 6 H F X U L W 1 X P E H U 1 X P E H U 5 H T X L U H G 5 1 2 7 1 8 D W H O D L P L O H G 6 H Q W 6 W H S 5 X O H V D Q G 6 W H S 5 X O H 7 K H G D W H W K H F O D L P Z D V I L O H G L Q S H U V R Q E P D L O R U W H O H S K R Q H R U E R W K H U P H D Q V D W H 0 0 5 H T X L U H G 7 1 2 7 1 8 7 S H R I 8 3 U R J U D P 5 H J X O D U 8 6 W H S 5 X O H 5 H J X O D U 8 F O D L P 7 H W 5 H J X O D U 8 5 H T X L U H G 5 1 2 7 1 8 8 Q H P S O R P H Q W Q V X U D Q F H D W D 9 D O L G D W L R Q 2 S H U D W L R Q V X L G H 3 3 1 5 2 5 2 8 7 1 R L H O G 1 D P H 0 R G X O H 5 H I H U H Q F H L H O G H V F U L S W L R Q D W D R U P D W D W D 7 S H R Q V W U D L Q W 7 S H R I O D L P 1 H Z 6 W H S 5 X O H 7 U D Q V L W L R Q D O 6 W H S 5 X O H Q W H U L Q J 6 H O I P S O R P H Q W 6 W H S 5 X O H G G L W L R Q D O 6 W H S 5 X O H 5 H R S H Q H G 6 W H S 5 X O H 1 H Z F O D L P 6 W H S 5 X O H 1 H Z F O D L P I L O H G L Q S U L R U T X D U W H U 6 W H S 5 X O H 1 H Z F O D L P I L O H G L Q S U L R U T X D U W H U 6 W H S 5 X O H 1 H Z F O D L P 7 U D Q V L W L R Q D O F O D L P Q W H U L Q J V H O I H P S O R P H Q W G G L W L R Q D O F O D L P 5 H R S H Q H G F O D L P 1 H Z F O D L P 1 H Z F O D L P I L O H G L Q D S U L R U T X D U W H U R U 1 H Z F O D L P I L O H G L Q D S U L R U T X D U W H U 7 H W 1 H Z 7 U D Q V L W L R Q D O Q W H U L Q J 6 H O I P S O R P H Q W G G L W L R Q D O 5 H R S H Q H G 1 H Z 3 U L R U 4 W U 1 H Z 3 U L R U 4 W U 1 H Z O D L P 5 H T X L U H G 5 1 2 7 1 8 3 U R J U D P 7 S H 8 6 W H S 5 X O H 8 6 W H S 5 X O H 8 6 W H S 5 X O H 8 8 R U 8 7 H W 8 8 8 5 H T X L U H G H F H S W R S W L R Q D O I R U D Q G H Q W H U L Q J V H O I H P S O R P H Q W S U R J U D P F O D L P V 5 8 Q H P S O R P H Q W Q V X U D Q F H D W D 9 D O L G D W L R Q 2 S H U D W L R Q V X L G H 3 3 1 5 2 5 2 8 7 1 R L H O G 1 D P H 0 R G X O H 5 H I H U H Q F H L H O G H V F U L S W L R Q D W D R U P D W D W D 7 S H R Q V W U D L Q W Q W U D V W D W H Q W H U V W D W H Q W U D V W D W H 6 W H S 5 X O H V D Q G Q W H U V W D W H 5 H F H L Y H G D V L D E O H 6 W D W H 6 W H S 5 X O H V D Q G Q W H U V W D W H 7 D N H Q D V J H Q W 6 W D W H 6 W H S 5 X O H V D Q G Q W H U V W D W H L O H G U R P J H Q W 6 W D W H 6 W H S 5 X O H V D Q G Q W U D V W D W H 6 W H S 5 X O H V D Q G Q W H U V W D W H 6 W H S 5 X O H V W K U R X J K Q W U D V W D W H Q W H U V W D W H U H F H L Y H G D V O L D E O H Q W H U V W D W H W D N H Q D V D J H Q W Q W H U V W D W H I L O H G I U R P D J H Q W V W D W H Q W U D V W D W H F R P E L Q H G Z D J H F O D L P R U Q W H U V W D W H F R P E L Q H G Z D J H F O D L P 7 H W Q W U D V W D W H Q W H U V W D W H O L D E O H Q W H U V W D W H W D N H Q Q W H U V W D W H D J H Q W Q W U D V W D W H Q W H U V W D W H 5 H T X L U H G H F H S W R S W L R Q D O I R U W U D Q V L W L R Q D O F O D L P V Q H Z F O D L P V I L O H G G X U L Q J D S U L R U T X D U W H U D Q G H Q W H U L Q J V H O I H P S O R P H Q W S U R J U D P F O D L P V 5 D W H R I 2 U L J L Q D O 0 R Q H W D U 6 W H S 5 X O H V D Q G 6 W H S 5 X O H D W H W K H R U L J L Q D O G H W H U P L Q D W L R Q Z D V P D G H R Q Z K H W K H U W K H F O D L P D Q W K D V V X I I L F L H Q W E D V H S H U L R G Z D J H V D Q G R U H P S O R P H Q W W R H V W D E O L V K D E H Q H I L W H D U D W H 0 0 5 H T X L U H G H F H S W P X V W E H E O D Q N I R U 1 R 0 R Q H W D U F O D L P D Q G F O D L P V Z L W K L Q V X I I L F L H Q W Z D J H V D Q G R S W L R Q D O I R U 8 8 L Q W H U V W D W H I L O H G I U R P D J H Q W V W D W H L Q W H U V W D W H W D N H Q D V D J H Q W V W D W H D Q G H Q W H U L Q J V H O I H P S O R P H Q W S U R J U D P F O D L P V 7 8 Q H P S O R P H Q W Q V X U D Q F H D W D 9 D O L G D W L R Q 2 S H U D W L R Q V X L G H 3 3 1 5 2 5 2 8 7 1 R L H O G 1 D P H 0 R G X O H 5 H I H U H Q F H L H O G H V F U L S W L R Q D W D R U P D W D W D 7 S H R Q V W U D L Q W 6 X I I L F L H Q W Q V X I I L F L H Q W R P E L Q H G D J H V 6 X I I L F L H Q W D J H V 1 H Z H Q H I L W H D U 6 W H S 5 X O H V D Q G 6 X I I L F L H Q W D J H V 1 R 1 H Z H Q H I L W H D U 6 W H S 5 X O H Q V X I I L F L H Q W D J H V 6 W H S 5 X O H 1 H Z D J H V 6 W H S 5 X O H 1 R 1 H Z D J H V 6 W H S 5 X O H V D Q G 7 K H V W D W X V R I W K H Q H Z 8 R U F O D L P D W W K H W L P H W K H U H S R U W Z D V U X Q 6 X I I L F L H Q W Q H Z E H Q H I L W H D U H V W D E O L V K H G 6 X I I L F L H Q W Q R Q H Z E H Q H I L W H D U H V W D E O L V K H G Q V X I I L F L H Q W 6 X I I L F L H Q W Q H Z E H Q H I L W H D U H V W D E O L V K H G 7 H W Q V X I I L F L H Q W 6 X I I L F L H Q W 1 H Z 6 X I I L F L H Q W 1 R 6 X I I L F L H Q W 1 H Z 5 H T X L U H G H F H S W P X V W E H E O D Q N I R U 1 R 0 R Q H W D U F O D L P D Q G R S W L R Q D O I R U 8 8 L Q W H U V W D W H I L O H G I U R P D J H Q W V W D W H L Q W H U V W D W H W D N H Q D V D J H Q W V W D W H D Q G H Q W H U L Q J V H O I H P S O R P H Q W S U R J U D P F O D L P V 5 6 W H S 5 X O H V D Q G H H N O E H Q H I L W D O O R Z D Q F H L V W K H P D L P X P R U O H V V W K D Q P D L P X P 7 H W 0 D L P X P H V V W K D Q 0 D L P X P 5 H T X L U H G H F H S W P X V W E H E O D Q N I R U L Q V X I I L F L H Q W V X I I L F L H Q W E X W Q R E H Q H I L W H D U D Q G 1 R 0 R Q H W D U F O D L P D Q G R S W L R Q D O I R U 8 8 L Q W H U V W D W H I L O H G I U R P D J H Q W V W D W H L Q W H U V W D W H W D N H Q D V D J H Q W V W D W H D Q G H Q W H U L Q J V H O I H P S O R P H Q W S U R J U D P F O D L P V 6 W D W H V V K R X O G L Q F O X G H W K H D I W H U W K H G D V K Z K L F K I R O O R Z V W K H J H Q H U L F I H G H U D O Y D O X H 5 8 Q H P S O R P H Q W Q V X U D Q F H D W D 9 D O L G D W L R Q 2 S H U D W L R Q V X L G H 3 3 1 5 2 5 2 8 7 1 R L H O G 1 D P H 0 R G X O H 5 H I H U H Q F H L H O G H V F U L S W L R Q D W D R U P D W D W D 7 S H R Q V W U D L Q W 0 6 W H S V D Q G 5 X O H 0 D L P X P E H Q H I L W D O O R Z D Q F H 1 X P E H U 5 H T X L U H G H F H S W P X V W E H E O D Q N R U I R U L Q V X I I L F L H Q W V X I I L F L H Q W E X W Q R E H Q H I L W H D U D Q G 1 R 0 R Q H W D U F O D L P D Q G R S W L R Q D O I R U 8 8 L Q W H U V W D W H I L O H G I U R P D J H Q W V W D W H L Q W H U V W D W H W D N H Q D V D J H Q W V W D W H D Q G H Q W H U L Q J V H O I H P S O R P H Q W S U R J U D P F O D L P V 0 3 R W H Q W L D O H H N V R I X U D W L R Q 6 W H S 5 X O H 7 K H Q X P E H U R I I X O O Z H H N V R I E H Q H I L W V I R U Z K L F K D F O D L P D Q W L V G H W H U P L Q H G W R E H H O L J L E O H Z L W K L Q D E H Q H I L W H D U 1 X P E H U 5 H T X L U H G H F H S W P X V W E H E O D Q N R U I R U L Q V X I I L F L H Q W V X I I L F L H Q W E X W Q R E H Q H I L W H D U D Q G 1 R 0 R Q H W D U F O D L P D Q G R S W L R Q D O I R U 8 8 L Q W H U V W D W H I L O H G I U R P D J H Q W V W D W H L Q W H U V W D W H W D N H Q D V D J H Q W V W D W H D Q G H Q W H U L Q J V H O I H P S O R P H Q W S U R J U D P F O D L P V 1 7 5 8 Q H P S O R P H Q W Q V X U D Q F H D W D 9 D O L G D W L R Q 2 S H U D W L R Q V X L G H 3 3 1 5 2 5 2 8 7 1 R L H O G 1 D P H 0 R G X O H 5 H I H U H Q F H L H O G H V F U L S W L R Q D W D R U P D W D W D 7 S H R Q V W U D L Q W 3 R W H Q W L D O H H N V 0 D L P X P X U D W L R Q 6 W H S 5 X O H V D Q G 7 K H G X U D W L R Q R I W K H E H Q H I L W H D U L V R U L V Q R W W K H P D L P X P I R U W K H 6 W D W H 7 H W 1 5 H T X L U H G H F H S W P X V W E H E O D Q N I R U L Q V X I I L F L H Q W V X I I L F L H Q W E X W Q R E H Q H I L W H D U D Q G 1 R 0 R Q H W D U F O D L P D Q G R S W L R Q D O I R U 8 8 L Q W H U V W D W H I L O H G I U R P D J H Q W V W D W H L Q W H U V W D W H W D N H Q D V D J H Q W V W D W H D Q G H Q W H U L Q J V H O I H P S O R P H Q W S U R J U D P F O D L P V 5 8 V H U 8 V H U G H I L Q H G I L H O G D Q E H X V H G I R U D Q D G G L W L R Q D O G D W D H O H P H Q W 1 R W P D Q G D W R U 7 H W 2 S W L R Q D O 5 8 Q H P S O R P H Q W Q V X U D Q F H D W D 9 D O L G D W L R Q 2 S H U D W L R Q V X L G H 3 3 1 5 2 5 2 8 7 1 7 6 5 2 5 2 8 7 2 5 3 2 3 8 7 2 1 D 7 K L V U H F R U G O D R X W S U R Y L G H V W K H I R U P D W I R U W K H Y D O L G D W L R Q H W U D F W I L O H 7 K H H W U D F W I L O H W S H P X V W E H 6 F R P P D G H O L P L W H G F R O X P Q V D W D P X V W E H L Q W K H R U G H U O L V W H G L Q W K H U H F R U G O D R X W 7 K H G D W D R U P D W F R O X P Q L Q G L F D W H V W K H J H Q H U L F Y D O X H V I R U W H W I L H O G V 7 K H V H P X V W E H I R O O R Z H G E D G D V K D Q G W K H V W D W H V S H F L I L F Y D O X H 7 K H 0 R G X O H U H I H U H Q F H L Q G L F D W H V W K H V W H S Z K H U H W K H V W D W H V S H F L I L F Y D O X H V D U H G R F X P H Q W H G D P S O H I W K H V W D W H V S H F L I L F F R G H I R U G G L W L R Q D O O D L P L V W K H Q W K H G D W D I R U P D W Z R X O G E H 7 2 1 1 R L H O G 1 D P H 0 R G X O H 5 H I H U H Q F H L H O G H V F U L S W L R Q D W D R U P D W D W D 7 S H R Q V W U D L Q W 2 6 6 W D W H D V V L J Q H G V H T X H Q W L D O X Q L T X H L G H Q W L I L H U I R U H D F K U H F R U G L Q W K H H W U D F W I L O H 1 X P E H U 5 H T X L U H G 1 7 5 1 2 7 1 8 6 6 1 6 W H S 5 X O H 6 R F L D O 6 H F X U L W 1 X P E H U 1 X P E H U 5 H T X L U H G 5 1 2 7 1 8 D W H O D L P L O H G 6 W H S 5 X O H 7 K H G D W H W K H F O D L P Z D V I L O H G L Q S H U V R Q E P D L O R U W H O H S K R Q H D W H 0 0 5 H T X L U H G 7 1 2 7 1 8 7 S H R I 8 3 U R J U D P 5 H J X O D U 8 6 W H S 5 X O H 5 H J X O D U 8 F O D L P 7 H W 5 H J X O D U 8 5 H T X L U H G 5 1 2 7 1 8 7 S H R I O D L P G G L W L R Q D O 6 W H S 5 X O H G G L W L R Q D O F O D L P 7 H W G G L W L R Q D O 5 H T X L U H G 5 1 2 7 1 8 3 U R J U D P 7 S H 8 6 W H S 5 X O H 8 6 W H S 5 X O H 8 6 W H S 5 X O H 3 U R J U D P W S H L V 8 8 R U 8 7 H W 8 8 8 5 H T X L U H G 5 1 2 7 1 8 Q W U D V W D W H Q W H U V W D W H Q W U D V W D W H 6 W H S 5 X O H V D Q G Q W H U V W D W H 5 H F H L Y H G D V L D E O H 6 W D W H 6 W H S 5 X O H V D Q G O D L P L V L Q W U D V W D W H R U L Q W H U V W D W H U H F H L Y H G D V O L D E O H 7 H W Q W U D V W D W H Q W H U V W D W H O L D E O H 5 H T X L U H G 5 1 2 7 1 8 8 Q H P S O R P H Q W Q V X U D Q F H D W D 9 D O L G D W L R Q 2 S H U D W L R Q V X L G H 3 3 1 5 2 5 2 8 7 1 R L H O G 1 D P H 0 R G X O H 5 H I H U H Q F H L H O G H V F U L S W L R Q D W D R U P D W D W D 7 S H R Q V W U D L Q W 8 Q F O D L P H G H H N 6 W H S 5 X O H 7 K H Z H H N H Q G L Q J G D W H R I W K H X Q F O D L P H G Z H H N S U L R U W R W K H D G G L W L R Q D O F O D L P D W H 0 0 2 S W L R Q D O 7 6 H S D U D W L R Q D W H 6 W H S 5 X O H 7 K H G D W H R I V H S D U D W L R Q I U R P D Q H P S O R H U V L Q F H W K H O D V W F O D L P Z D V I L O H G D W H 0 0 5 H T X L U H G 7 1 2 7 1 8 D V W P S O R H U 6 W H S 5 X O H 7 K H Q D P H R I W K H V H S D U D W L Q J H P S O R H U 7 H W 5 H T X L U H G 5 1 2 7 1 8 6 H S D U D W L R Q 5 H D V R Q 6 W H S 5 X O H 7 K H U H D V R Q I R U V H S D U D W L R Q 7 H W 5 H T X L U H G 5 1 2 7 1 8 8 V H U 8 V H U G H I L Q H G I L H O G D Q E H X V H G I R U D Q D G G L W L R Q D O G D W D H O H P H Q W 1 R W P D Q G D W R U 7 H W 2 S W L R Q D O 5 8 Q H P S O R P H Q W Q V X U D Q F H D W D 9 D O L G D W L R Q 2 S H U D W L R Q V X L G H 3 3 1 5 2 5 2 8 7 1 7 6 5 2 5 2 8 7 2 5 3 2 3 8 7 2 1 7 K L V U H F R U G O D R X W S U R Y L G H V W K H I R U P D W I R U W K H Y D O L G D W L R Q H W U D F W I L O H 7 K H H W U D F W I L O H W S H P X V W E H 6 F R P P D G H O L P L W H G F R O X P Q V D W D P X V W E H L Q W K H R U G H U O L V W H G L Q W K H U H F R U G O D R X W 7 K H G D W D R U P D W F R O X P Q L Q G L F D W H V W K H J H Q H U L F Y D O X H V I R U W H W I L H O G V 7 K H V H P X V W E H I R O O R Z H G E D G D V K D Q G W K H V W D W H V S H F L I L F Y D O X H 7 K H 0 R G X O H U H I H U H Q F H L Q G L F D W H V W K H V W H S Z K H U H W K H V W D W H V S H F L I L F Y D O X H V D U H G R F X P H Q W H G D P S O H I W K H V W D W H V S H F L I L F F R G H I R U G M X V W P H Q W S D P H Q W L V W K H Q W K H G D W D I R U P D W Z R X O G E H - 8 6 7 0 1 7 1 R L H O G 1 D P H 0 R G X O H 5 H I H U H Q F H L H O G H V F U L S W L R Q D W D R U P D W D W D 7 S H R Q V W U D L Q W 2 6 6 W D W H D V V L J Q H G V H T X H Q W L D O X Q L T X H L G H Q W L I L H U I R U H D F K U H F R U G L Q W K H H W U D F W I L O H 1 X P E H U 5 H T X L U H G 1 7 5 1 2 7 1 8 6 6 1 6 W H S 5 X O H 6 R F L D O 6 H F X U L W 1 X P E H U 1 X P E H U 5 H T X L U H G 5 1 2 7 1 8 K H F N 1 X P E H U 8 Q L T X H 6 W H S 5 X O H 7 K H F K H F N Q X P E H U R U R W K H U X Q L T X H F K H F N R U R I I V H W V D V V L J Q D X Q L T X H Q X P E H U 1 X P E H U 5 H T X L U H G 5 1 2 7 1 8 7 S H R I 8 3 U R J U D P 5 H J X O D U 8 6 W H S 5 X O H 5 H J X O D U 8 F O D L P 7 H W 5 H J X O D U 8 5 H T X L U H G 5 1 2 7 1 8 3 U R J U D P 7 S H 8 6 W H S 5 X O H 8 6 W H S 5 X O H 8 2 Q O 6 W H S 5 X O H 8 H G H U D O 6 W H S 5 X O H 6 H O I P S O R P H Q W 6 W H S 5 X O H 7 S H R I 3 U R J U D P L V 8 R Q O 8 8 8 8 R Q O - R L Q W 8 H G H U D O R U 6 H O I P S O R P H Q W 7 H W 8 2 Q O 8 2 Q O 8 8 8 2 Q O - R L Q W 8 H G H U D O 6 H O I H P S O R 5 H T X L U H G H F H S W R S W L R Q D O I R U S D P H Q W V 5 8 Q H P S O R P H Q W Q V X U D Q F H D W D 9 D O L G D W L R Q 2 S H U D W L R Q V X L G H 3 3 1 5 2 5 2 8 7 1 R L H O G 1 D P H 0 R G X O H 5 H I H U H Q F H L H O G H V F U L S W L R Q D W D R U P D W D W D 7 S H R Q V W U D L Q W Q W U D V W D W H Q W H U V W D W H Q W U D V W D W H 6 W H S 5 X O H Q W H U V W D W H 5 H F H L Y H G D V L D E O H 6 W D W H 6 W H S 5 X O H Q W U D V W D W H 6 W H S 5 X O H Q W H U V W D W H 6 W H S 5 X O H Q W U D V W D W H Q W H U V W D W H Q W U D V W D W H R U Q W H U V W D W H F O D L P 7 H W Q W H U V W D W H Q W U D V W D W H Q W U D V W D W H Q W H U V W D W H 5 H T X L U H G H F H S W R S W L R Q D O I R U 8 R Q O 8 8 D Q G 8 R Q O D G M X V W P H Q W V 5 7 S H R I R P S H Q V D W L R Q L U V W 6 W H S 5 X O H R Q W L Q X H G 6 W H S 5 X O H G M X V W P H Q W 6 W H S 5 X O H 3 U L R U H H N V R P S H Q V D W H G 6 W H S 5 X O H L U V W 3 D P H Q W R Q W L Q X H G 3 D P H Q W G M X V W P H Q W 6 H O I P S O R P H Q W 3 U L R U H H N V R P S H Q V D W H G 7 H W L U V W 3 D P H Q W R Q W L Q X H G 3 D P H Q W G M X V W P H Q W 6 H O I P S O R P H Q W 3 U L R U H H N V R P S H Q V D W H G 5 H T X L U H G 5 1 2 7 1 8 3 D U W L D O 7 R W D O H H N V R I 8 Q H P S O R P H Q W 3 D U W L D O 6 W H S 5 X O H 7 R W D O 6 W H S 5 X O H H H N R I S D U W L D O R U W R W D O X Q H P S O R P H Q W 7 H W 3 D U W L D O 7 R W D O 5 H T X L U H G H F H S W R S W L R Q D O I R U 8 R Q O 8 8 D Q G 8 R Q O D G M X V W P H Q W V D Q G I R U V H O I H P S O R P H Q W D Q G S D P H Q W V 5 D U Q L Q J V 6 W H S 5 X O H 6 W H S 5 X O H 7 K H H D U Q L Q J V I R U W K H Z H H N F O D L P H G 1 X P E H U 5 H T X L U H G H F H S W R S W L R Q D O I R U 8 R Q O 8 8 D Q G 8 R Q O D G M X V W P H Q W V D Q G V H O I H P S O R P H Q W D Q G S D P H Q W V 0 8 Q H P S O R P H Q W Q V X U D Q F H D W D 9 D O L G D W L R Q 2 S H U D W L R Q V X L G H 3 3 1 5 2 5 2 8 7 1 R L H O G 1 D P H 0 R G X O H 5 H I H U H Q F H L H O G H V F U L S W L R Q D W D R U P D W D W D 7 S H R Q V W U D L Q W 6 W H S 5 X O H 6 W H S 5 X O H 7 K H Z H H N O E H Q H I L W D O O R Z D Q F H 1 X P E H U 5 H T X L U H G H F H S W R S W L R Q D O I R U 8 R Q O 8 8 D Q G 8 R Q O D G M X V W P H Q W V D Q G V H O I H P S O R P H Q W D Q G S D P H Q W V 0 8 P R X Q W 6 W H S 5 X O H 7 K H D P R X Q W R I E H Q H I L W V S D L G I U R P 6 W D W H 8 Q H P S O R P H Q W X Q G V 1 X P E H U 5 H T X L U H G H F H S W P X V W E H E O D Q N R U I R U 8 R Q O 8 8 8 R Q O V H O I H P S O R P H Q W D Q G S D P H Q W V 0 8 P R X Q W 6 W H S 5 X O H 7 K H D P R X Q W R I E H Q H I L W V S D L G I U R P H G H U D O X Q G V 1 X P E H U 5 H T X L U H G I R U 8 R Q O - R L Q W 8 H G H U D O D Q G 8 8 S D P H Q W V P X V W E H E O D Q N R U I R U D O O R W K H U S D P H Q W W S H V 0 8 P R X Q W 6 W H S 5 X O H 7 K H D P R X Q W R I E H Q H I L W V S D L G I U R P P L O L W D U I X Q G V 1 X P E H U 5 H T X L U H G I R U 8 R Q O - R L Q W 8 H G H U D O D Q G 8 8 S D P H Q W V P X V W E H E O D Q N R U I R U D O O R W K H U S D P H Q W W S H V 0 8 Q H P S O R P H Q W Q V X U D Q F H D W D 9 D O L G D W L R Q 2 S H U D W L R Q V X L G H 3 3 1 5 2 5 2 8 7 1 R L H O G 1 D P H 0 R G X O H 5 H I H U H Q F H L H O G H V F U L S W L R Q D W D R U P D W D W D 7 S H R Q V W U D L Q W P R X Q W 6 W H S 5 X O H 7 K H D P R X Q W R I E H Q H I L W V S D L G I R U D F R P E L Q H G Z D J H F O D L P S D P H Q W 1 X P E H U 5 H T X L U H G I R U D O O S D P H Q W V P X V W E H E O D Q N R U I R U D O O R W K H U S D P H Q W W S H V 0 6 H O I P S O R P R X Q W 6 W H S 5 X O H 7 K H W R W D O G R O O D U V S D L G X Q G H U W K H 6 S U R J U D P 1 X P E H U 5 H T X L U H G I R U V H O I H P S O R P H Q W S D P H Q W V P X V W E H E O D Q N R U I R U D O O R W K H U S D P H Q W W S H V 0 H H N Q G D W H 6 W H S 5 X O H 7 K H Z H H N H Q G L Q J G D W H R I W K H Z H H N F R P S H Q V D W H G D W H 0 0 5 H T X L U H G H F H S W R S W L R Q D O I R U D G M X V W P H Q W V H O I H P S O R P H Q W D Q G D O O S D P H Q W V Z L W K W K H H F H S W L R Q R I I L U V W S D P H Q W V 7 0 D L O D W H 6 W H S 5 X O H 7 K H G D W H R Q Z K L F K W K H S D P H Q W L V D F W X D O O P D L O H G W R W K H F O D L P D Q W D W H 0 0 5 H T X L U H G 7 1 2 7 1 8 8 V H U 8 V H U G H I L Q H G I L H O G D Q E H X V H G I R U D Q D G G L W L R Q D O G D W D H O H P H Q W 1 R W P D Q G D W R U 7 H W 2 S W L R Q D O 5 8 Q H P S O R P H Q W Q V X U D Q F H D W D 9 D O L G D W L R Q 2 S H U D W L R Q V X L G H 3 3 1 5 2 5 2 8 7 1 7 6 5 2 5 2 8 7 2 5 3 2 3 8 7 2 1 7 K L V U H F R U G O D R X W S U R Y L G H V W K H I R U P D W I R U W K H Y D O L G D W L R Q H W U D F W I L O H 7 K H H W U D F W I L O H W S H P X V W E H 6 F R P P D G H O L P L W H G F R O X P Q V D W D P X V W E H L Q W K H R U G H U O L V W H G L Q W K H U H F R U G O D R X W 7 K H G D W D R U P D W F R O X P Q L Q G L F D W H V W K H J H Q H U L F Y D O X H V I R U W H W I L H O G V 7 K H V H P X V W E H I R O O R Z H G E D G D V K D Q G W K H V W D W H V S H F L I L F Y D O X H 7 K H 0 R G X O H U H I H U H Q F H L Q G L F D W H V W K H V W H S Z K H U H W K H V W D W H V S H F L I L F Y D O X H V D U H G R F X P H Q W H G D P S O H I W K H V W D W H V S H F L I L F F R G H I R U 8 3 U R J U D P 7 S H L V W K H Q W K H G D W D I R U P D W Z R X O G E H 8 1 R L H O G 1 D P H 0 R G X O H 5 H I H U H Q F H L H O G H V F U L S W L R Q D W D R U P D W D W D 7 S H R Q V W U D L Q W 2 6 6 W D W H D V V L J Q H G V H T X H Q W L D O X Q L T X H L G H Q W L I L H U I R U H D F K U H F R U G L Q W K H H W U D F W I L O H 1 X P E H U 5 H T X L U H G 1 7 5 1 2 7 1 8 6 6 1 6 W H S 5 X O H 6 R F L D O 6 H F X U L W 1 X P E H U 1 X P E H U 5 H T X L U H G 5 1 2 7 1 8 V V X H 1 X P E H U 8 Q L T X H 6 W H S 5 X O H 7 K H X Q L T X H L V V X H Q X P E H U R U R W K H U X Q L T X H Q X P E H U D V V L J Q H G W R W K H Q R Q P R Q H W D U G H W H U P L Q D W L R Q 1 X P E H U 5 H T X L U H G L I 6 W D W H P D L Q W D L Q V D X Q L T X H 5 7 S H R I 8 3 U R J U D P 5 H J X O D U 8 6 W H S 5 X O H R U N V K D U H 6 W H S 5 X O H 5 H J X O D U 8 F O D L P R U R U N V K D U H F O D L P 7 H W 5 H J X O D U 8 R U N V K D U H 5 H T X L U H G 5 1 2 7 1 8 3 U R J U D P 7 S H 8 6 W H S 5 X O H 8 6 W H S 5 X O H 8 6 W H S 5 X O H 8 8 R U 8 7 H W 8 8 8 5 H T X L U H G H F H S W R S W L R Q D O I R U P X O W L F O D L P D Q W V 5 8 Q H P S O R P H Q W Q V X U D Q F H D W D 9 D O L G D W L R Q 2 S H U D W L R Q V X L G H 3 3 1 5 2 5 2 8 7 1 R L H O G 1 D P H 0 R G X O H 5 H I H U H Q F H L H O G H V F U L S W L R Q D W D R U P D W D W D 7 S H R Q V W U D L Q W Q W U D V W D W H Q W H U V W D W H Q W U D V W D W H 6 W H S 5 X O H Q W H U V W D W H 5 H F H L Y H G D V L D E O H 6 W D W H 6 W H S 5 X O H Q W U D V W D W H R U L Q W H U V W D W H 7 H W Q W U D V W D W H Q W H U V W D W H 5 H T X L U H G H F H S W R S W L R Q D O I R U P X O W L F O D L P D Q W V 5 H W H U P L Q D W L R Q 5 H G H W H U P L Q D W L R Q 6 W H S 5 X O H 6 W H S 5 X O H 7 K H G H F L V L R Q P D G H E W K H D X W K R U L W R Q D Q L V V X H Z D V D G H W H U P L Q D W L R Q R U U H G H W H U P L Q D W L R Q 7 H W H W H U P L Q D W L R Q 5 H G H W H U P L Q D W L R Q 5 H T X L U H G 5 1 2 7 1 8 7 S H R I H W H U P L Q D W L R Q 6 W H S 5 X O H V D Q G 6 W H S 5 X O H 7 K H G H W H U P L Q D W L R Q Z D V E D V H G X S R Q I D F W V U H O D W H G W R D Q L Q G L Y L G X D O V L W X D W L R Q R U W R J U R X S V R I V L P L O D U O V L W X D W H G L Q G L Y L G X D O V 7 H W 6 L Q J O H 0 X O W L 5 H T X L U H G 5 1 2 7 1 8 8 Q H P S O R P H Q W Q V X U D Q F H D W D 9 D O L G D W L R Q 2 S H U D W L R Q V X L G H 3 3 1 5 2 5 2 8 7 1 R L H O G 1 D P H 0 R G X O H 5 H I H U H Q F H L H O G H V F U L S W L R Q D W D R U P D W D W D 7 S H R Q V W U D L Q W V V X H 7 S H V 9 6 W H S 5 X O H 0 6 W H S 5 X O H 6 H S 2 W K H U 6 W H S 5 X O H 6 W H S 5 X O H H G Q F R P H 6 W H S 5 X O H 6 X L W D E O H R U N 6 W H S 5 X O H 5 H S R U W L Q J 6 W H S 5 X O H 3 U R I L O L Q J 6 W H S 5 X O H 2 W K H U 1 R Q V H S 6 W H S 5 X O H D E R U L V S X W H 6 W H S - 5 X O H 2 W K H U 0 X O W L F O D L P D L Q W V V X H V 6 W H S . 5 X O H 7 K H V H S D U D W L Q J L V V X H Z D V Y R O X Q W D U O H D Y L Q J P L V F R Q G X F W R U R W K H U V H S D U D W L R Q L V V X H 7 K H Q R Q V H S D U D W L R Q L V V X H Z D V D E O H D Q G D Y D L O D E O H I R U Z R U N G H G X F W L E O H L Q F R P H V X L W D E O H Z R U N U H I X V D O U H S R U W L Q J U H T X L U H P H Q W V S U R I L O L Q J R W K H U Q R Q V H S D U D W L R Q L V V X H R U O D E R U G L V S X W H R U R W K H U P X O W L F O D L P D Q W L V V X H 7 H W 9 0 6 H S 2 W K H U H G Q F R P H 6 X L W D E O H R U N 5 H S R U W L Q J 3 U R I L O L Q J 2 W K H U 1 R Q V H S D E R U L V S X W H 2 W K H U 0 X O W L F O D L P D Q W 5 H T X L U H G 5 1 2 7 1 8 L U V W H H N I I H F W H G 6 W H S 5 X O H V D Q G 7 K H Z H H N H Q G L Q J G D W H R I W K H I L U V W Z H H N L Q D F O D L P V H U L H V W R Z K L F K D Q R W L F H R I Q R Q P R Q H W D U G H W H U P L Q D W L R Q D S S O L H V D W H 0 0 5 H T X L U H G H F H S W R S W L R Q D O I R U U H G H W H U P L Q D W L R Q V 7 H W H F W L R Q D W H 6 W H S 5 X O H 7 K H H D U O L H V W G D W H W K D W W K H D J H Q F L V L Q S R V V H V V L R Q R I L Q I R U P D W L R Q L Q G L F D W L Q J W K H H L V W H Q F H R I D Q R Q P R Q H W D U L V V X H D W H 0 0 5 H T X L U H G H F H S W R S W L R Q D O I R U U H G H W H U P L Q D W L R Q V 7 8 Q H P S O R P H Q W Q V X U D Q F H D W D 9 D O L G D W L R Q 2 S H U D W L R Q V X L G H 3 3 1 5 2 5 2 8 7 1 R L H O G 1 D P H 0 R G X O H 5 H I H U H Q F H L H O G H V F U L S W L R Q D W D R U P D W D W D 7 S H R Q V W U D L Q W 1 R W L F H D W H 6 W H S 5 X O H 7 K H G D W H W K H G H W H U P L Q D W L R Q Q R W L F H L V P D L O H G R U L I Q R Q R W L F H L V U H T X L U H G W K H G D W H S D P H Q W L V D X W K R U L H G Z D L W L Q J Z H H N F U H G L W L V J L Y H Q R U D Q R I I V H W L V D S S O L H G D W H 0 0 5 H T X L U H G 7 1 2 7 1 8 O O R Z R U H Q 6 W H S 5 X O H V D Q G 6 W H S 5 X O H V D Q G 7 K H R X W F R P H R I W K H Q R Q P R Q H W D U G H W H U P L Q D W L R Q Z D V D Q D O O R Z R U D G H Q 7 H W O O R Z H Q 5 H T X L U H G 5 1 2 7 1 8 8 V H U 8 V H U G H I L Q H G I L H O G D Q E H X V H G I R U D Q D G G L W L R Q D O G D W D H O H P H Q W 1 R W P D Q G D W R U 7 H W 2 S W L R Q D O 5 8 Q H P S O R P H Q W Q V X U D Q F H D W D 9 D O L G D W L R Q 2 S H U D W L R Q V X L G H 3 3 1 5 2 5 2 8 7 1 7 6 5 2 5 2 8 7 2 5 3 2 3 8 7 2 1 7 K L V U H F R U G O D R X W S U R Y L G H V W K H I R U P D W I R U W K H Y D O L G D W L R Q H W U D F W I L O H 7 K H H W U D F W I L O H W S H P X V W E H 6 F R P P D G H O L P L W H G F R O X P Q V D W D P X V W E H L Q W K H R U G H U O L V W H G L Q W K H U H F R U G O D R X W 7 K H G D W D R U P D W F R O X P Q L Q G L F D W H V W K H J H Q H U L F Y D O X H V I R U W H W I L H O G V 7 K H V H P X V W E H I R O O R Z H G E D G D V K D Q G W K H V W D W H V S H F L I L F Y D O X H 7 K H 0 R G X O H U H I H U H Q F H L Q G L F D W H V W K H V W H S Z K H U H W K H V W D W H V S H F L I L F Y D O X H V D U H G R F X P H Q W H G D P S O H I W K H V W D W H V S H F L I L F F R G H I R U 6 L Q J O H O D L P D Q W L V 1 W K H Q W K H G D W D I R U P D W Z R X O G E H 6 1 1 R L H O G 1 D P H 0 R G X O H 5 H I H U H Q F H L H O G H V F U L S W L R Q D W D R U P D W D W D 7 S H R Q V W U D L Q W 2 6 6 W D W H D V V L J Q H G V H T X H Q W L D O X Q L T X H L G H Q W L I L H U I R U H D F K U H F R U G L Q W K H H W U D F W I L O H 1 X P E H U 5 H T X L U H G 1 7 5 1 2 7 1 8 6 6 1 6 W H S 5 X O H 6 R F L D O 6 H F X U L W 1 X P E H U 1 X P E H U 5 H T X L U H G 5 1 2 7 1 8 R F N H W 1 X P E H U 8 Q L T X H 6 W H S 5 X O H 7 K H R F N H W 1 X P E H U R I W K H O R Z H U D X W K R U L W D S S H D O 1 X P E H U 5 H T X L U H G 5 1 2 7 1 8 S S H D O H Y H O 6 W H S 5 X O H 7 K H D S S H D O W S H Z D V D O R Z H U D X W K R U L W D S S H D O 7 H W R Z H U 5 H T X L U H G 5 1 2 7 1 8 7 S H R I S S H D O 6 L Q J O H R U 0 X O W L F O D L P D Q W 6 L Q J O H 6 W H S 5 X O H 0 X O W L 6 W H S 5 X O H 7 K H D S S H D O V F D V H L Q Y R O Y H V R Q H R U P R U H W K D Q R Q H F O D L P D Q W 7 H W 6 0 5 H T X L U H G 5 1 2 7 1 8 8 Q H P S O R P H Q W Q V X U D Q F H D W D 9 D O L G D W L R Q 2 S H U D W L R Q V X L G H 3 3 1 5 2 5 2 8 7 1 R L H O G 1 D P H 0 R G X O H 5 H I H U H Q F H L H O G H V F U L S W L R Q D W D R U P D W D W D 7 S H R Q V W U D L Q W 1 X P E H U R I O D L P D Q W V 6 W H S 5 X O H V D Q G 7 K H Q X P E H U R I F O D L P D Q W V L Q D P X O W L F O D L P D Q W D S S H D O I W K H 6 W D W H V W R U H V D V L Q J O H U H F R U G I R U D P X O W L F O D L P D Q W D S S H D O Z L W K D I L H O G I R U W K H Q X P E H U R I F O D L P D Q W V L Q V H U W W K H Q X P E H U L Q W K L V I L H O G I W K H 6 W D W H V W R U H V D U H F R U G I R U H D F K F O D L P D Q W L Q Y R O Y H G L Q D P X O W L F O D L P D Q W D S S H D O L Q F O X G H D O O R I W K H U H F R U G V L Q W K H I L O H D Q G L Q V H U W D L Q W K L V I L H O G 1 X P E H U 5 H T X L U H G I R U P X W L S O H F O D L P D Q W D S S H D O V R S W L R Q D O I R U V L Q J O H F O D L P D Q W D S S H D O V 1 7 5 L O H G D W H 6 W H S 5 X O H 7 K H G D W H R Q Z K L F K W K H D S S H D O Z D V I L O H G D W H 0 0 5 H T X L U H G 7 1 2 7 1 8 8 V H U 8 V H U G H I L Q H G I L H O G D Q E H X V H G I R U D Q D G G L W L R Q D O G D W D H O H P H Q W 1 R W P D Q G D W R U 7 H W 2 S W L R Q D O 5 8 Q H P S O R P H Q W Q V X U D Q F H D W D 9 D O L G D W L R Q 2 S H U D W L R Q V X L G H 3 3 1 5 2 5 2 8 7 1 7 6 5 2 5 2 8 7 2 5 3 2 3 8 7 2 1 7 K L V U H F R U G O D R X W S U R Y L G H V W K H I R U P D W I R U W K H Y D O L G D W L R Q H W U D F W I L O H 7 K H H W U D F W I L O H W S H P X V W E H 6 F R P P D G H O L P L W H G F R O X P Q V D W D P X V W E H L Q W K H R U G H U O L V W H G L Q W K H U H F R U G O D R X W 7 K H G D W D R U P D W F R O X P Q L Q G L F D W H V W K H J H Q H U L F Y D O X H V I R U W H W I L H O G V 7 K H V H P X V W E H I R O O R Z H G E D G D V K D Q G W K H V W D W H V S H F L I L F Y D O X H 7 K H 0 R G X O H U H I H U H Q F H L Q G L F D W H V W K H V W H S Z K H U H W K H V W D W H V S H F L I L F Y D O X H V D U H G R F X P H Q W H G D P S O H I W K H V W D W H V S H F L I L F F R G H I R U L J K H U X W K R U L W S S H D O L V W K H Q W K H G D W D I R U P D W Z R X O G E H L J K H U 1 R L H O G 1 D P H 0 R G X O H 5 H I H U H Q F H L H O G H V F U L S W L R Q D W D R U P D W D W D 7 S H R Q V W U D L Q W 2 6 6 W D W H D V V L J Q H G V H T X H Q W L D O X Q L T X H L G H Q W L I L H U I R U H D F K U H F R U G L Q W K H H W U D F W I L O H 1 X P E H U 5 H T X L U H G 1 7 5 1 2 7 1 8 6 6 1 6 W H S 5 X O H 6 R F L D O 6 H F X U L W 1 X P E H U 1 X P E H U 5 H T X L U H G 5 1 2 7 1 8 R F N H W 1 X P E H U 8 Q L T X H 6 W H S 5 X O H 7 K H R F N H W 1 X P E H U R I W K H K L J K H U D X W K R U L W D S S H D O 1 X P E H U 5 H T X L U H G 5 1 2 7 1 8 S S H D O H Y H O 6 W H S 5 X O H 7 K H D S S H D O W S H Z D V D K L J K H U D X W K R U L W D S S H D O 7 H W L J K H U 5 H T X L U H G 5 1 2 7 1 8 7 S H R I S S H D O 6 L Q J O H R U 0 X O W L F O D L P D Q W 6 L Q J O H 6 W H S 5 X O H 0 X O W L 6 W H S 5 X O H 7 K H D S S H D O V F D V H L Q Y R O Y H V R Q H R U P R U H W K D Q R Q H F O D L P D Q W 7 H W 6 0 5 H T X L U H G 5 1 2 7 1 8 8 Q H P S O R P H Q W Q V X U D Q F H D W D 9 D O L G D W L R Q 2 S H U D W L R Q V X L G H 3 3 1 5 2 5 2 8 7 1 R L H O G 1 D P H 0 R G X O H 5 H I H U H Q F H L H O G H V F U L S W L R Q D W D R U P D W D W D 7 S H R Q V W U D L Q W 1 X P E H U R I O D L P D Q W V 6 W H S 5 X O H V D Q G 7 K H Q X P E H U R I F O D L P D Q W V L Q D P X O W L F O D L P D Q W D S S H D O I W K H 6 W D W H V W R U H V D V L Q J O H U H F R U G I R U D P X O W L F O D L P D Q W D S S H D O Z L W K D I L H O G I R U W K H Q X P E H U R I F O D L P D Q W V L Q V H U W W K H Q X P E H U L Q W K L V I L H O G I W K H 6 W D W H V W R U H V D U H F R U G I R U H D F K F O D L P D Q W L Q Y R O Y H G L Q D P X O W L F O D L P D Q W D S S H D O L Q F O X G H D O O R I W K H U H F R U G V L Q W K H I L O H D Q G L Q V H U W D L Q W K L V I L H O G 1 X P E H U 5 H T X L U H G I R U P X W L S O H F O D L P D Q W D S S H D O V R S W L R Q D O I R U V L Q J O H F O D L P D Q W D S S H D O V 1 7 5 L O H G D W H 6 W H S 5 X O H 7 K H G D W H R Q Z K L F K W K H D S S H D O Z D V I L O H G D W H 0 0 5 H T X L U H G 7 1 2 7 1 8 8 V H U 8 V H U G H I L Q H G I L H O G D Q E H X V H G I R U D Q D G G L W L R Q D O G D W D H O H P H Q W 1 R W P D Q G D W R U 7 H W 2 S W L R Q D O 5 8 Q H P S O R P H Q W Q V X U D Q F H D W D 9 D O L G D W L R Q 2 S H U D W L R Q V X L G H 3 3 1 5 2 5 2 8 7 1 7 6 5 2 5 2 8 7 2 5 3 2 3 8 7 2 1 7 K L V U H F R U G O D R X W S U R Y L G H V W K H I R U P D W I R U W K H Y D O L G D W L R Q H W U D F W I L O H 7 K H H W U D F W I L O H W S H P X V W E H 6 F R P P D G H O L P L W H G F R O X P Q V D W D P X V W E H L Q W K H R U G H U O L V W H G L Q W K H U H F R U G O D R X W 7 K H G D W D R U P D W F R O X P Q L Q G L F D W H V W K H J H Q H U L F Y D O X H V I R U W H W I L H O G V 7 K H V H P X V W E H I R O O R Z H G E D G D V K D Q G W K H V W D W H V S H F L I L F Y D O X H 7 K H 0 R G X O H U H I H U H Q F H L Q G L F D W H V W K H V W H S Z K H U H W K H V W D W H V S H F L I L F Y D O X H V D U H G R F X P H Q W H G D P S O H I W K H V W D W H V S H F L I L F F R G H I R U 8 3 U R J U D P 7 S H L V W K H Q W K H G D W D I R U P D W Z R X O G E H 8 1 R L H O G 1 D P H 0 R G X O H 5 H I H U H Q F H L H O G H V F U L S W L R Q D W D R U P D W D W D 7 S H R Q V W U D L Q W 2 6 6 W D W H D V V L J Q H G V H T X H Q W L D O X Q L T X H L G H Q W L I L H U I R U H D F K U H F R U G L Q W K H H W U D F W I L O H 1 X P E H U 5 H T X L U H G 1 7 5 1 2 7 1 8 6 6 1 6 W H S 5 X O H 6 R F L D O 6 H F X U L W 1 X P E H U 1 X P E H U 5 H T X L U H G 5 1 2 7 1 8 R F N H W 1 X P E H U 8 Q L T X H 6 W H S 5 X O H 7 K H R F N H W 1 X P E H U R U R W K H U X Q L T X H D V V L J Q H G W R W K H D S S H D O 1 X P E H U 5 H T X L U H G 5 1 2 7 1 8 7 S H R I 8 3 U R J U D P 5 H J X O D U 8 6 W H S 5 X O H R U N V K D U H 6 W H S 5 X O H 5 H J X O D U 8 F O D L P R U R U N V K D U H F O D L P 7 H W 5 H J X O D U 8 R U N V K D U H 5 H T X L U H G 5 1 2 7 1 8 3 U R J U D P 7 S H 8 6 W H S 5 X O H 8 6 W H S 5 X O H 8 6 W H S 5 X O H 8 8 R U 8 7 H W 8 8 8 5 H T X L U H G 5 1 2 7 1 8 Q W U D V W D W H Q W H U V W D W H Q W U D V W D W H 6 W H S 5 X O H V D Q G Q W H U V W D W H 5 H F H L Y H G D V L D E O H 6 W D W H 6 W H S 5 X O H V D Q G Q W U D V W D W H R U Q W H U V W D W H 7 H W Q W U D V W D W H Q W H U V W D W H 5 H T X L U H G 5 1 2 7 1 8 S S H D O H Y H O 6 W H S 5 X O H 7 K H D S S H D O W S H L V D O R Z H U D X W K R U L W D S S H D O 7 H W R Z H U 5 H T X L U H G 5 1 2 7 1 8 8 Q H P S O R P H Q W Q V X U D Q F H D W D 9 D O L G D W L R Q 2 S H U D W L R Q V X L G H 3 3 1 5 2 5 2 8 7 1 R L H O G 1 D P H 0 R G X O H 5 H I H U H Q F H L H O G H V F U L S W L R Q D W D R U P D W D W D 7 S H R Q V W U D L Q W 7 S H R I S S H D O 6 L Q J O H R U 0 X O W L F O D L P D Q W 6 L Q J O H 6 W H S 5 X O H 0 X O W L 6 W H S 5 X O H 7 K H G H W H U P L Q D W L R Q L V E D V H G X S R Q I D F W V U H O D W H G W R D Q L Q G L Y L G X D O V L W X D W L R Q R U W R J U R X S V R I V L P L O D U O V L W X D W H G L Q G L Y L G X D O V 6 W D W H V Z K L F K P D L Q W D L Q D V L Q J O H U H F R U G I R U P X O W L F O D L P D Q W D S S H D O V Z L W K D I L H O G I R U W K H Q X P E H U R I F O D L P D Q W V L Q Y R O Y H G V K R X O G L Q V H U W D W H W S U H I L R I 0 I R U D P X O W L F O D L P D Q W D S S H D O Z L W K R Q O R Q H U H F R U G I R U W K H Z K R O H D S S H D O 6 W D W H V Z K L F K P D L Q W D L Q P X O W L S O H U H F R U G V R Q H I R U H D F K F O D L P D Q W I R U D P X O W L F O D L P D Q W D S S H D O V K R X O G G H V L J Q D W H R Q H R I W K H U H F R U G V D V W K H O H D G F O D L P D Q W 6 W D W H V V K R X O G L Q V H U W D W H W S U H I L R I 0 H D G L Q W K L V I L H O G I R U W K H O H D G F O D L P D Q W U H F R U G R W K R I W K H V H W S H V R I U H F R U G V Z L O O E H D V V L J Q H G W R V X E S R S X O D W L R Q V W R O R Z H U R U W R K L J K H U 6 W D W H V Z K L F K P D L Q W D L Q P X O W L S O H U H F R U G V V K R X O G L Q V H U W D S U H I L R I 0 1 R Q O H D G L Q W K H P X O W L F O D L P D Q W I L H O G I R U W K H Q R Q O H D G F O D L P D Q W V 7 K H V H U H F R U G V Z L O O E H D V V L J Q H G W R V X E S R S X O D W L R Q V O R Z H U R U K L J K H U 7 H W 6 0 0 H D G 0 1 R Q O H D G 5 H T X L U H G 5 1 2 7 1 8 8 Q H P S O R P H Q W Q V X U D Q F H D W D 9 D O L G D W L R Q 2 S H U D W L R Q V X L G H 3 3 1 5 2 5 2 8 7 1 R L H O G 1 D P H 0 R G X O H 5 H I H U H Q F H L H O G H V F U L S W L R Q D W D R U P D W D W D 7 S H R Q V W U D L Q W 1 X P E H U R I O D L P D Q W V L Q 0 X O W L F O D L P D Q W S S H D O 6 W H S 5 X O H V D Q G 7 K H Q X P E H U R I F O D L P D Q W V L Q Y R O Y H G L Q D P X O W L F O D L P D Q W D S S H D O F R X O G E H R Q H L I V H S D U D W H U H F R U G V D U H S U R Y L G H G I R U H D F K S D U W L F L S D W L Q J F O D L P D Q W 1 X P E H U 5 H T X L U H G I R U P X W L S O H F O D L P D Q W D S S H D O V P X V W E H E O D Q N R U I R U V L Q J O H F O D L P D Q W D S S H D O V 1 7 5 S S H O O D Q W O D L P D Q W 6 W H S 5 X O H P S O R H U 6 W H S 5 X O H 2 W K H U 6 W H S 5 X O H 7 K H D S S H O O D Q W L V W K H F O D L P D Q W H P S O R H U R U R W K H U W K D Q F O D L P D Q W R U H P S O R H U 7 H W O D L P D Q W P S O R H U 2 W K H U 5 H T X L U H G H F H S W R S W L R Q D O I R U 8 8 D Q G Q R Q O H D G P X O W L F O D L P D Q W F O D L P V 5 Q D Y R U R I S S H O O D Q W Q D Y R U 6 W H S 5 X O H 1 R W L Q D Y R U 6 W H S 5 X O H 7 K H G H F L V L R Q Z D V R U Z D V Q R W L Q I D Y R U R I W K H D S S H O O D Q W 7 H W 1 5 H T X L U H G H F H S W R S W L R Q D O I R U 8 8 D Q G Q R Q O H D G P X O W L F O D L P D Q W F O D L P V 5 L O H G D W H 6 W H S 5 X O H 7 K H G D W H R Q Z K L F K W K H D S S H D O Z D V I L O H G D W H 0 0 5 H T X L U H G 7 1 2 7 1 8 H F L V L R Q D W H 6 W H S 5 X O H 7 K H G D W H W K H G H F L V L R Q Z D V P D L O H G W R W K H L Q W H U H V W H G S D U W L H V F R Q F H U Q H G D W H 0 0 5 H T X L U H G 7 1 2 7 1 8 L V S R V H G R I E H F L V L R Q H F L V L R Q 6 W H S 5 X O H 1 R W E H F L V L R Q 6 W H S 5 X O H 7 K H D S S H D O V F D V H Z D V G L V S R V H G R I E D Z U L W W H Q U X O L Q J 7 H W 1 2 S W L R Q D O 5 8 Q H P S O R P H Q W Q V X U D Q F H D W D 9 D O L G D W L R Q 2 S H U D W L R Q V X L G H 3 3 1 5 2 5 2 8 7 1 R L H O G 1 D P H 0 R G X O H 5 H I H U H Q F H L H O G H V F U L S W L R Q D W D R U P D W D W D 7 S H R Q V W U D L Q W V V X H R G H 9 6 W H S 5 X O H 0 6 W H S 5 X O H 6 X L W 6 W H S 5 X O H 6 W H S 5 X O H 2 W K H U 6 W H S 5 X O H D E R U L V S 6 W H S 5 X O H 7 K H L V V X H F R G H R I W K H D S S H D O Z D V Y R O X Q W D U O H D Y L Q J P L V F R Q G X F W U H I X V D O R I V X L W D E O H Z R U N D E O H D Q G D Y D L O D E O H W R Z R U N R W K H U L V V X H V R U O D E R U G L V S X W H 7 H W 9 0 6 X L W 2 W K H U D E R U L V S 5 H T X L U H G H F H S W R S W L R Q D O I R U 8 D Q G 8 F O D L P V 5 8 V H U 8 V H U G H I L Q H G I L H O G D Q E H X V H G I R U D Q D G G L W L R Q D O G D W D H O H P H Q W 1 R W P D Q G D W R U 7 H W 2 S W L R Q D O 5 8 Q H P S O R P H Q W Q V X U D Q F H D W D 9 D O L G D W L R Q 2 S H U D W L R Q V X L G H 3 3 1 5 2 5 2 8 7 1 7 6 5 2 5 2 8 7 2 5 3 2 3 8 7 2 1 7 K L V U H F R U G O D R X W S U R Y L G H V W K H I R U P D W I R U W K H Y D O L G D W L R Q H W U D F W I L O H 7 K H H W U D F W I L O H W S H P X V W E H 6 F R P P D G H O L P L W H G F R O X P Q V D W D P X V W E H L Q W K H R U G H U O L V W H G L Q W K H U H F R U G O D R X W 7 K H G D W D R U P D W F R O X P Q L Q G L F D W H V W K H J H Q H U L F Y D O X H V I R U W H W I L H O G V 7 K H V H P X V W E H I R O O R Z H G E D G D V K D Q G W K H V W D W H V S H F L I L F Y D O X H 7 K H 0 R G X O H U H I H U H Q F H L Q G L F D W H V W K H V W H S Z K H U H W K H V W D W H V S H F L I L F Y D O X H V D U H G R F X P H Q W H G D P S O H I W K H V W D W H V S H F L I L F F R G H I R U Q D Y R U 2 I L V W K H Q W K H G D W D I R U P D W Z R X O G E H 1 R L H O G 1 D P H 0 R G X O H 5 H I H U H Q F H L H O G H V F U L S W L R Q D W D R U P D W D W D 7 S H R Q V W U D L Q W 2 6 6 W D W H D V V L J Q H G V H T X H Q W L D O X Q L T X H L G H Q W L I L H U I R U H D F K U H F R U G L Q W K H H W U D F W I L O H 1 X P E H U 5 H T X L U H G 1 7 5 1 2 7 1 8 6 6 1 6 W H S 5 X O H 6 R F L D O 6 H F X U L W 1 X P E H U 1 X P E H U 5 H T X L U H G 5 1 2 7 1 8 R F N H W 1 X P E H U 8 Q L T X H 6 W H S 5 X O H 7 K H R F N H W R U R W K H U X Q L T X H Q X P E H U D V V L J Q H G W R W K H D S S H D O 1 X P E H U 5 H T X L U H G 5 1 2 7 1 8 7 S H R I 8 3 U R J U D P 5 H J X O D U 8 6 W H S 5 X O H R U N V K D U H 6 W H S 5 X O H 5 H J X O D U 8 F O D L P R U R U N V K D U H F O D L P 7 H W 5 H J X O D U 8 R U N V K D U H 5 H T X L U H G 5 1 2 7 1 8 3 U R J U D P 7 S H 8 6 W H S 5 X O H 8 6 W H S 5 X O H 8 6 W H S 5 X O H 8 8 R U 8 7 H W 8 8 8 5 H T X L U H G 5 1 2 7 1 8 Q W U D V W D W H Q W H U V W D W H Q W U D V W D W H 6 W H S 5 X O H V D Q G Q W H U V W D W H 5 H F H L Y H G D V L D E O H 6 W D W H 6 W H S 5 X O H V D Q G Q W U D V W D W H R U L Q W H U V W D W H 7 H W Q W U D V W D W H Q W H U V W D W H 5 H T X L U H G H F H S W R S W L R Q D O I R U Q R Q O H D G F O D L P D Q W P X O W L F O D L P D Q W D S S H D O V 5 S S H D O H Y H O 6 W H S 5 X O H 7 K H D S S H D O L V D K L J K H U D X W K R U L W D S S H D O 7 H W L J K H U 5 H T X L U H G 5 1 2 7 1 8 8 Q H P S O R P H Q W Q V X U D Q F H D W D 9 D O L G D W L R Q 2 S H U D W L R Q V X L G H 3 3 1 5 2 5 2 8 7 1 R L H O G 1 D P H 0 R G X O H 5 H I H U H Q F H L H O G H V F U L S W L R Q D W D R U P D W D W D 7 S H R Q V W U D L Q W 7 S H R I S S H D O 6 L Q J O H R U 0 X O W L F O D L P D Q W 6 L Q J O H 6 W H S 5 X O H 0 X O W L 6 W H S 5 X O H 7 K H G H W H U P L Q D W L R Q L V E D V H G X S R Q I D F W V U H O D W H G W R D Q L Q G L Y L G X D O V L W X D W L R Q R U W R J U R X S V R I V L P L O D U O V L W X D W H G L Q G L Y L G X D O V 6 W D W H V Z K L F K P D L Q W D L Q D V L Q J O H U H F R U G I R U P X O W L F O D L P D Q W D S S H D O V Z L W K D I L H O G I R U W K H Q X P E H U R I F O D L P D Q W V L Q Y R O Y H G V K R X O G L Q V H U W D W H W S U H I L R I 0 I R U D P X O W L F O D L P D Q W D S S H D O Z L W K R Q O R Q H U H F R U G I R U W K H Z K R O H D S S H D O 6 W D W H V Z K L F K P D L Q W D L Q P X O W L S O H U H F R U G V R Q H I R U H D F K F O D L P D Q W I R U D P X O W L F O D L P D Q W D S S H D O V K R X O G G H V L J Q D W H R Q H R I W K H U H F R U G V D V W K H O H D G F O D L P D Q W 6 W D W H V V K R X O G L Q V H U W D W H W S U H I L R I 0 H D G L Q W K L V I L H O G I R U W K H O H D G F O D L P D Q W U H F R U G R W K R I W K H V H W S H V R I U H F R U G V Z L O O E H D V V L J Q H G W R V X E S R S X O D W L R Q V W R O R Z H U R U W R K L J K H U 6 W D W H V Z K L F K P D L Q W D L Q P X O W L S O H U H F R U G V V K R X O G L Q V H U W D S U H I L R I 0 1 R Q O H D G L Q W K H P X O W L F O D L P D Q W I L H O G I R U W K H Q R Q O H D G F O D L P D Q W V 7 K H V H U H F R U G V Z L O O E H D V V L J Q H G W R V X E S R S X O D W L R Q V O R Z H U R U K L J K H U 7 H W 6 0 0 H D G 0 1 R Q O H D G 5 H T X L U H G 5 1 2 7 1 8 8 Q H P S O R P H Q W Q V X U D Q F H D W D 9 D O L G D W L R Q 2 S H U D W L R Q V X L G H 3 3 1 5 2 5 2 8 7 1 R L H O G 1 D P H 0 R G X O H 5 H I H U H Q F H L H O G H V F U L S W L R Q D W D R U P D W D W D 7 S H R Q V W U D L Q W 1 X P E H U R I O D L P D Q W V L Q 0 X O W L F O D L P D Q W S S H D O 6 W H S 5 X O H V D Q G 7 K H Q X P E H U R I F O D L P D Q W V L Q Y R O Y H G L Q D P X O W L F O D L P D Q W D S S H D O F R X O G E H R Q H L I V H S D U D W H U H F R U G V D U H S U R Y L G H G I R U H D F K S D U W L F L S D W L Q J F O D L P D Q W 1 X P E H U 5 H T X L U H G I R U P X O W L S O H F O D L P D Q W D S S H D O V P X V W E H E O D Q N R U I R U V L Q J O H F O D L P D Q W D S S H D O V 1 7 5 S S H O O D Q W O D L P D Q W 6 W H S 5 X O H P S O R H U 6 W H S 5 X O H 2 W K H U 6 W H S 5 X O H 7 K H D S S H O O D Q W L V W K H F O D L P D Q W H P S O R H U R U R W K H U W K D Q F O D L P D Q W R U H P S O R H U 7 H W O D L P D Q W P S O R H U 2 W K H U 5 H T X L U H G H F H S W R S W L R Q D O I R U 8 D Q G 8 F O D L P V D Q G Q R Q O H D G P X O W L F O D L P D Q W D S S H D O V 5 Q D Y R U R I S S H O O D Q W Q D Y R U 6 W H S 5 X O H 1 R W L Q D Y R U 6 W H S 5 X O H 7 K H G H F L V L R Q Z D V R U Z D V Q R W L Q I D Y R U R I W K H D S S H O O D Q W 7 H W 1 5 H T X L U H G H F H S W R S W L R Q D O I R U 8 D Q G 8 F O D L P V D Q G Q R Q O H D G P X O W L F O D L P D Q W D S S H D O V 5 L O H G D W H 6 W H S 5 X O H 7 K H G D W H R Q Z K L F K W K H D S S H D O Z D V I L O H G D W H 0 0 5 H T X L U H G 7 1 2 7 1 8 H F L V L R Q D W H 6 W H S 5 X O H 7 K H G D W H W K H G H F L V L R Q Z D V P D L O H G W R W K H L Q W H U H V W H G S D U W L H V F R Q F H U Q H G D W H 0 0 5 H T X L U H G 7 1 2 7 1 8 L V S R V H G R I E H F L V L R Q H F L V L R Q 6 W H S 5 X O H 1 R W E H F L V L R Q 6 W H S 5 X O H 7 K H D S S H D O V F D V H Z D V G L V S R V H G R I E D Z U L W W H Q U X O L Q J 7 H W 1 2 S W L R Q D O 5 8 Q H P S O R P H Q W Q V X U D Q F H D W D 9 D O L G D W L R Q 2 S H U D W L R Q V X L G H 3 3 1 5 2 5 2 8 7 1 R L H O G 1 D P H 0 R G X O H 5 H I H U H Q F H L H O G H V F U L S W L R Q D W D R U P D W D W D 7 S H R Q V W U D L Q W 8 V H U 8 V H U G H I L Q H G I L H O G D Q E H X V H G I R U D Q D G G L W L R Q D O G D W D H O H P H Q W 1 R W P D Q G D W R U 7 H W 2 S W L R Q D O 5 8 Q H P S O R P H Q W Q V X U D Q F H D W D 9 D O L G D W L R Q 2 S H U D W L R Q V X L G H 3 3 1 5 2 5 2 8 7 1 7 6 5 2 5 2 8 7 2 5 3 2 3 8 7 2 1 7 K L V U H F R U G O D R X W S U R Y L G H V W K H I R U P D W I R U W K H Y D O L G D W L R Q H W U D F W I L O H 7 K H H W U D F W I L O H W S H P X V W E H 6 F R P P D G H O L P L W H G F R O X P Q V D W D P X V W E H L Q W K H R U G H U O L V W H G L Q W K H U H F R U G O D R X W 7 K H G D W D R U P D W F R O X P Q L Q G L F D W H V W K H J H Q H U L F Y D O X H V I R U W H W I L H O G V 7 K H V H P X V W E H I R O O R Z H G E D G D V K D Q G W K H V W D W H V S H F L I L F Y D O X H 7 K H 0 R G X O H U H I H U H Q F H L Q G L F D W H V W K H V W H S Z K H U H W K H V W D W H V S H F L I L F Y D O X H V D U H G R F X P H Q W H G D P S O H I W K H V W D W H V S H F L I L F F R G H I R U R Z H U X W K R U L W S S H D O L V W K H Q W K H G D W D I R U P D W Z R X O G E H 2 5 1 R L H O G 1 D P H 0 R G X O H 5 H I H U H Q F H L H O G H V F U L S W L R Q D W D R U P D W D W D 7 S H R Q V W U D L Q W 2 6 6 W D W H D V V L J Q H G V H T X H Q W L D O X Q L T X H L G H Q W L I L H U I R U H D F K U H F R U G L Q W K H H W U D F W I L O H 1 X P E H U 5 H T X L U H G 1 7 5 1 2 7 1 8 6 6 1 6 W H S 5 X O H 6 R F L D O 6 H F X U L W 1 X P E H U 1 X P E H U 5 H T X L U H G 5 1 2 7 1 8 R F N H W 1 X P E H U 8 Q L T X H 6 W H S 5 X O H 7 K H R F N H W 1 X P E H U R U R W K H U X Q L T X H Q X P E H U D V V L J Q H G W R W K H D S S H D O 1 X P E H U 5 H T X L U H G 5 1 2 7 1 8 S S H D O H Y H O 6 W H S 5 X O H 7 K H D S S H D O Z D V D O R Z H U D X W K R U L W D S S H D O 7 H W R Z H U 5 H T X L U H G 5 1 2 7 1 8 S S H D O 3 H Q G L Q J 6 W H S 5 X O H 1 R G H F L V L R Q K D V E H H Q P D G H R Q D Q D S S H D O 7 H W 1 R H F L V L R Q 2 S W L R Q D O 5 L O H G D W H 6 W H S 5 X O H 7 K H G D W H R Q Z K L F K W K H D S S H D O Z D V I L O H G D W H 0 0 5 H T X L U H G 7 1 2 7 1 8 8 V H U 8 V H U G H I L Q H G I L H O G D Q E H X V H G I R U D Q D G G L W L R Q D O G D W D H O H P H Q W 1 R W P D Q G D W R U 7 H W 2 S W L R Q D O 5 8 Q H P S O R P H Q W Q V X U D Q F H D W D 9 D O L G D W L R Q 2 S H U D W L R Q V X L G H 3 3 1 5 2 5 2 8 7 1 7 6 5 2 5 2 8 7 2 5 3 2 3 8 7 2 1 7 K L V U H F R U G O D R X W S U R Y L G H V W K H I R U P D W I R U W K H Y D O L G D W L R Q H W U D F W I L O H 7 K H H W U D F W I L O H W S H P X V W E H 6 F R P P D G H O L P L W H G F R O X P Q V D W D P X V W E H L Q W K H R U G H U O L V W H G L Q W K H U H F R U G O D R X W 7 K H G D W D R U P D W F R O X P Q L Q G L F D W H V W K H J H Q H U L F Y D O X H V I R U W H W I L H O G V 7 K H V H P X V W E H I R O O R Z H G E D G D V K D Q G W K H V W D W H V S H F L I L F Y D O X H 7 K H 0 R G X O H U H I H U H Q F H L Q G L F D W H V W K H V W H S Z K H U H W K H V W D W H V S H F L I L F Y D O X H V D U H G R F X P H Q W H G D P S O H I W K H V W D W H V S H F L I L F F R G H I R U L J K H U X W K R U L W S S H D O L V W K H Q W K H G D W D I R U P D W Z R X O G E H L J K H U 1 R L H O G 1 D P H 0 R G X O H 5 H I H U H Q F H L H O G H V F U L S W L R Q D W D R U P D W D W D 7 S H R Q V W U D L Q W 2 6 6 W D W H D V V L J Q H G V H T X H Q W L D O X Q L T X H L G H Q W L I L H U I R U H D F K U H F R U G L Q W K H H W U D F W I L O H 1 X P E H U 5 H T X L U H G 1 7 5 1 2 7 1 8 6 6 1 6 W H S 5 X O H 6 R F L D O 6 H F X U L W 1 X P E H U 1 X P E H U 5 H T X L U H G 5 1 2 7 1 8 R F N H W 1 X P E H U 8 Q L T X H 6 W H S 5 X O H 7 K H R F N H W 1 X P E H U R U R W K H U X Q L T X H Q X P E H U D V V L J Q H G W R W K H D S S H D O 1 X P E H U 5 H T X L U H G 5 1 2 7 1 8 S S H D O H Y H O 6 W H S 5 X O H 7 K H D S S H D O Z D V D K L J K H U D X W K R U L W D S S H D O 7 H W L J K H U 5 H T X L U H G 5 1 2 7 1 8 S S H D O 3 H Q G L Q J 6 W H S 5 X O H 1 R G H F L V L R Q K D V E H H Q P D G H R Q D Q D S S H D O 7 H W 1 R H F L V L R Q 2 S W L R Q D O 5 L O H G D W H 6 W H S 5 X O H 7 K H G D W H R Q Z K L F K W K H D S S H D O Z D V I L O H G D W H 0 0 5 H T X L U H G 7 1 2 7 1 8 8 V H U 8 V H U G H I L Q H G I L H O G D Q E H X V H G I R U D Q D G G L W L R Q D O G D W D H O H P H Q W 1 R W P D Q G D W R U 7 H W 2 S W L R Q D O 5 8 Q H P S O R P H Q W Q V X U D Q F H D W D 9 D O L G D W L R Q 2 S H U D W L R Q V X L G H 3 3 1 5 2 5 2 8 7 1 7 6 5 2 5 2 8 7 2 5 3 2 3 8 7 2 1 7 K L V U H F R U G O D R X W S U R Y L G H V W K H I R U P D W I R U W K H Y D O L G D W L R Q H W U D F W I L O H 7 K H H W U D F W I L O H W S H P X V W E H 6 F R P P D G H O L P L W H G F R O X P Q V D W D P X V W E H L Q W K H R U G H U O L V W H G L Q W K H U H F R U G O D R X W 7 K H G D W D R U P D W F R O X P Q L Q G L F D W H V W K H J H Q H U L F Y D O X H V I R U W H W I L H O G V 7 K H V H P X V W E H I R O O R Z H G E D G D V K D Q G W K H V W D W H V S H F L I L F Y D O X H 7 K H 0 R G X O H U H I H U H Q F H L Q G L F D W H V W K H V W H S Z K H U H W K H V W D W H V S H F L I L F Y D O X H V D U H G R F X P H Q W H G D P S O H I W K H V W D W H V S H F L I L F F R G H I R U U D X G L V W K H Q W K H G D W D I R U P D W Z R X O G E H 5 8 1 R L H O G 1 D P H 0 R G X O H 5 H I H U H Q F H L H O G H V F U L S W L R Q D W D R U P D W D W D 7 S H R Q V W U D L Q W 2 6 6 W D W H D V V L J Q H G V H T X H Q W L D O X Q L T X H L G H Q W L I L H U I R U H D F K U H F R U G L Q W K H H W U D F W I L O H 1 X P E H U 5 H T X L U H G 1 7 5 1 2 7 1 8 6 6 1 6 W H S 5 X O H 6 R F L D O 6 H F X U L W 1 X P E H U 1 X P E H U 5 H T X L U H G 5 1 2 7 1 8 8 Q L T X H 6 W H S 5 X O H 7 K H X Q L T X H R I W K H R Y H U S D P H Q W 1 X P E H U 5 H T X L U H G L I 6 W D W H P D L Q W D L Q V D X Q L T X H 5 3 U R J U D P 7 S H 8 6 W H S 5 X O H 8 6 W H S 5 X O H 8 6 W H S 5 X O H 7 S H R I S U R J U D P L V 8 8 R U 8 7 H W 8 8 8 5 H T X L U H G 5 1 2 7 1 8 7 S H R I 2 Y H U S D P H Q W U D X G 6 W H S 5 X O H 1 R Q I U D X G 6 W H S 5 X O H 3 H Q D O W 6 W H S 5 X O H 7 K H W S H R I R Y H U S D P H Q W L V U D X G 1 R Q I U D X G R U 3 H Q D O W 7 H W U D X G 1 R Q I U D X G 3 H Q D O W 5 H T X L U H G 5 1 2 7 1 8 8 Q H P S O R P H Q W Q V X U D Q F H D W D 9 D O L G D W L R Q 2 S H U D W L R Q V X L G H 3 3 1 5 2 5 2 8 7 1 R L H O G 1 D P H 0 R G X O H 5 H I H U H Q F H L H O G H V F U L S W L R Q D W D R U P D W D W D 7 S H R Q V W U D L Q W D X V H R I 2 Y H U S D P H Q W 0 X O W L O D L P D Q W 6 F K H P H 6 W H S 5 X O H 5 H Y H U V D O - 9 6 W H S 5 X O H 6 6 6 W H S 5 X O H P S O R H U 6 W H S 5 X O H O D L P D Q W 6 W H S 5 X O H 2 W K H U 6 W H S 5 X O H V D Q G 3 H Q D O W 6 W H S 5 X O H 7 K H F D X V H R I W K H R Y H U S D P H Q W Z D V 0 X O W L O D L P D Q W 6 F K H P H V 5 H Y H U V D O V 6 6 U U R U V P S O R H U U U R U V O D L P D Q W U U R U V R U R W K H U U D X G R U 1 R Q I U D X G F D X V H V 7 H W 0 X O W L F O D L P D Q W 5 H Y H U V D O V 6 6 P S O R H U O D L P D Q W 2 W K H U 5 H T X L U H G H F H S W R S W L R Q D O I R U S H Q D O W L H V 5 H W H F W L R Q 7 S H D J H H Q H I L W U R V V P D W F K 6 W H S 5 X O H U R V V P D W F K 6 W H S 5 X O H 1 H Z L U H V 6 V W H P 6 W H S 5 X O H 0 X O W L O D L P D Q W 6 F K H P H 6 V W H P V 6 W H S 5 X O H 6 S H F L D O 3 U R M H F W 6 W H S 5 X O H 2 W K H U R Q W U R O O D E O H 6 W H S 5 X O H 1 R Q F R Q W U R O O D E O H 6 W H S 5 X O H 7 K H G H W H F W L R Q W S H X V H G W R H V W D E O L V K W K H R Y H U S D P H Q W Z D V D J H H Q H I L W U R V V P D W F K U R V V P D W F K 1 H Z L U H V 6 V W H P V 0 X O W L O D L P D Q W 6 F K H P H 6 V W H P V 6 S H F L D O 3 U R M H F W 2 W K H U R Q W U R O O D E O H R U 1 R Q F R Q W U R O O D E O H D F W L Y L W 7 H W D J H U R V V P D W F K U R V V P D W F K 1 H Z L U H V 0 X O W L F O D L P D Q W 6 S H F L D O 2 W K H U R Q W U R O O D E O H 1 R Q F R Q W U R O O D E O H 5 H T X L U H G 5 1 2 7 1 8 D W H V W D E O L V K H G 6 W H S 5 X O H 7 K H G D W H W K D W W K H R Y H U S D P H Q W Z D V H V W D E O L V K H G D W H 0 0 5 H T X L U H G 7 1 2 7 1 8 8 Q H P S O R P H Q W Q V X U D Q F H D W D 9 D O L G D W L R Q 2 S H U D W L R Q V X L G H 3 3 1 5 2 5 2 8 7 1 R L H O G 1 D P H 0 R G X O H 5 H I H U H Q F H L H O G H V F U L S W L R Q D W D R U P D W D W D 7 S H R Q V W U D L Q W 8 P R X Q W 6 W H S 5 X O H 7 K H D P R X Q W R I E H Q H I L W V S D L G I U R P 6 W D W H 8 Q H P S O R P H Q W X Q G V 1 X P E H U 5 H T X L U H G I R U 8 F O D L P V P X V W E H E O D Q N R U I R U 8 R U 8 F O D L P V 0 H G H U D O P R X Q W 6 W H S 5 X O H 7 K H D P R X Q W R I E H Q H I L W V S D L G I U R P H G H U D O X Q G V 1 X P E H U 5 H T X L U H G I R U 8 8 R U M R L Q W F O D L P V P X V W E H E O D Q N R U I R U 8 F O D L P V 0 8 V H U 8 V H U G H I L Q H G I L H O G D Q E H X V H G I R U D Q D G G L W L R Q D O G D W D H O H P H Q W 1 R W P D Q G D W R U 7 H W 2 S W L R Q D O 5 8 Q H P S O R P H Q W Q V X U D Q F H D W D 9 D O L G D W L R Q 2 S H U D W L R Q V X L G H 3 3 1 5 2 5 2 8 7 1 7 6 5 2 5 2 8 7 2 5 3 2 3 8 7 2 1 7 K L V U H F R U G O D R X W S U R Y L G H V W K H I R U P D W I R U W K H Y D O L G D W L R Q H W U D F W I L O H 7 K H H W U D F W I L O H W S H P X V W E H 6 F R P P D G H O L P L W H G F R O X P Q V D W D P X V W E H L Q W K H R U G H U O L V W H G L Q W K H U H F R U G O D R X W 7 K H G D W D R U P D W F R O X P Q L Q G L F D W H V W K H J H Q H U L F Y D O X H V I R U W H W I L H O G V 7 K H V H P X V W E H I R O O R Z H G E D G D V K D Q G W K H V W D W H V S H F L I L F Y D O X H 7 K H 0 R G X O H U H I H U H Q F H L Q G L F D W H V W K H V W H S Z K H U H W K H V W D W H V S H F L I L F Y D O X H V D U H G R F X P H Q W H G D P S O H I W K H V W D W H V S H F L I L F F R G H I R U 5 H F R Y H U H G D V K L V W K H Q W K H G D W D I R U P D W Z R X O G E H 6 1 R L H O G 1 D P H 0 R G X O H 5 H I H U H Q F H L H O G H V F U L S W L R Q D W D R U P D W D W D 7 S H R Q V W U D L Q W 2 6 6 W D W H D V V L J Q H G V H T X H Q W L D O X Q L T X H L G H Q W L I L H U I R U H D F K U H F R U G L Q W K H H W U D F W I L O H 1 X P E H U 5 H T X L U H G 1 7 5 1 2 7 1 8 6 6 1 6 W H S 5 X O H 6 R F L D O 6 H F X U L W 1 X P E H U 1 X P E H U 5 H T X L U H G 5 1 2 7 1 8 8 Q L T X H 6 W H S 5 X O H 7 K H X Q L T X H R I W K H R Y H U S D P H Q W 1 X P E H U 5 H T X L U H G L I 6 W D W H P D L Q W D L Q V D X Q L T X H 5 3 U R J U D P 7 S H 8 6 W H S 5 X O H 8 6 W H S 5 X O H 8 6 W H S 5 X O H 7 K H S U R J U D P W S H L V 8 8 R U 8 7 H W 8 8 8 5 H T X L U H G 5 1 2 7 1 8 7 S H R I 2 Y H U S D P H Q W V U D X G 6 W H S 5 X O H 1 R Q I U D X G 6 W H S 5 X O H 7 K H W S H R I R Y H U S D P H Q W L V U D X G R U 1 R Q I U D X G 7 H W U D X G 1 R Q I U D X G 5 H T X L U H G 5 1 2 7 1 8 8 Q H P S O R P H Q W Q V X U D Q F H D W D 9 D O L G D W L R Q 2 S H U D W L R Q V X L G H 3 3 1 5 2 5 2 8 7 1 R L H O G 1 D P H 0 R G X O H 5 H I H U H Q F H L H O G H V F U L S W L R Q D W D R U P D W D W D 7 S H R Q V W U D L Q W 7 S H R I 5 H F R Q F L O L D W L R Q F W L Y L W 5 H F R Y H U H G D V K 6 W H S 5 X O H 5 H F R Y H U H G 2 I I V H W 6 W H S 5 X O H 6 W D W H Q F R P H 7 D 2 I I V H W 6 W H S 5 X O H 2 W K H U 6 W D W H V 6 W H S 5 X O H U L W W H Q 2 I I 6 W H S 5 X O H D L Y H G 6 W H S 5 X O H G G L W L R Q V 6 W H S 5 X O H 6 X E W U D F W L R Q V 6 W H S 5 X O H 2 W K H U 6 W H S 5 X O H 7 K H U H F R Q F L O L D W L R Q D F W L Y L W Z D V F D V K E H Q H I L W R I I V H W V W D W H L Q F R P H W D R I I V H W R I I V H W R W K H U V W D W H V Z U L W H R I I D G G L W L R Q R U V X E W U D F W L R Q 7 H W D V K H Q H I L W 2 I I V H W 7 D 2 I I V H W 2 W K H U 6 W D W H U L W H R I I D L Y H G G G L W L R Q 6 X E W U D F W L R Q 2 W K H U 5 H T X L U H G 5 1 2 7 1 8 D W H R I 5 H F R Q F L O L D W L R Q F W L Y L W 6 W H S 5 X O H Q G L F D W H W K H G D W H R I W K H 2 Y H U S D P H Q W F W L Y L W D W H 0 0 5 H T X L U H G 7 1 2 7 1 8 8 5 H F R Q F L O L D W L R Q P R X Q W 6 W H S 5 X O H 7 K H U H F R Q F L O H G D P R X Q W R I 6 W D W H 8 Q H P S O R P H Q W X Q G V 1 X P E H U 5 H T X L U H G I R U 8 F O D L P V P X V W E H E O D Q N R U I R U 8 R U 8 F O D L P V 0 H G H U D O 5 H F R Q F L O L D W L R Q P R X Q W 6 W H S 5 X O H 7 K H U H F R Q F L O H G D P R X Q W R I H G H U D O X Q G V 1 X P E H U 5 H T X L U H G I R U 8 8 R U M R L Q W F O D L P V P X V W E H E O D Q N R U I R U 8 F O D L P V 0 8 Q H P S O R P H Q W Q V X U D Q F H D W D 9 D O L G D W L R Q 2 S H U D W L R Q V X L G H 3 3 1 5 2 5 2 8 7 1 R L H O G 1 D P H 0 R G X O H 5 H I H U H Q F H L H O G H V F U L S W L R Q D W D R U P D W D W D 7 S H R Q V W U D L Q W 8 V H U 8 V H U G H I L Q H G I L H O G D Q E H X V H G I R U D Q D G G L W L R Q D O G D W D H O H P H Q W 1 R W P D Q G D W R U 7 H W 2 S W L R Q D O 5 8 Q H P S O R P H Q W Q V X U D Q F H D W D 9 D O L G D W L R Q 2 S H U D W L R Q V X L G H 3 3 1 5 2 5 2 8 7 1 7 6 5 2 5 2 8 7 2 5 3 2 3 8 7 2 1 7 K L V U H F R U G O D R X W S U R Y L G H V W K H I R U P D W I R U W K H Y D O L G D W L R Q H W U D F W I L O H 7 K H H W U D F W I L O H W S H P X V W E H 6 F R P P D G H O L P L W H G F R O X P Q V D W D P X V W E H L Q W K H R U G H U O L V W H G L Q W K H U H F R U G O D R X W 7 K H G D W D R U P D W F R O X P Q L Q G L F D W H V W K H J H Q H U L F Y D O X H V I R U W H W I L H O G V 7 K H V H P X V W E H I R O O R Z H G E D G D V K D Q G W K H V W D W H V S H F L I L F Y D O X H 7 K H 0 R G X O H U H I H U H Q F H L Q G L F D W H V W K H V W H S Z K H U H W K H V W D W H V S H F L I L F Y D O X H V D U H G R F X P H Q W H G D P S O H I W K H V W D W H V S H F L I L F F R G H I R U 1 R Q I U D X G L V 1 W K H Q W K H G D W D I R U P D W Z R X O G E H 1 2 1 5 8 1 1 R L H O G 1 D P H 0 R G X O H 5 H I H U H Q F H L H O G H V F U L S W L R Q D W D R U P D W D W D 7 S H R Q V W U D L Q W 2 6 6 W D W H D V V L J Q H G V H T X H Q W L D O X Q L T X H L G H Q W L I L H U I R U H D F K U H F R U G L Q W K H H W U D F W I L O H 1 X P E H U 5 H T X L U H G 1 7 5 1 2 7 1 8 6 6 1 6 W H S 5 X O H 6 R F L D O 6 H F X U L W 1 X P E H U 1 X P E H U 5 H T X L U H G 5 1 2 7 1 8 8 Q L T X H 6 W H S 5 X O H 7 K H X Q L T X H R I W K H R Y H U S D P H Q W 1 X P E H U 5 H T X L U H G L I 6 W D W H P D L Q W D L Q V D X Q L T X H 5 D W H V W D E O L V K H G 6 W H S 5 X O H 7 K H G D W H W K H R Y H U S D P H Q W Z D V H V W D E O L V K H G D W H 0 0 5 H T X L U H G 7 1 2 7 1 8 3 U R J U D P 7 S H 8 6 W H S 5 X O H 8 6 W H S 5 X O H 8 6 W H S 5 X O H 7 K H S U R J U D P W S H L V 8 8 R U 8 7 H W 8 8 8 5 H T X L U H G 5 1 2 7 1 8 2 X W V W D Q G L Q J 2 Y H U S D P H Q W 6 W H S 5 X O H 7 K H R Y H U S D P H Q W L V R X W V W D Q G L Q J 7 H W 1 2 S W L R Q D O 5 8 Q H P S O R P H Q W Q V X U D Q F H D W D 9 D O L G D W L R Q 2 S H U D W L R Q V X L G H 3 3 1 5 2 5 2 8 7 1 R L H O G 1 D P H 0 R G X O H 5 H I H U H Q F H L H O G H V F U L S W L R Q D W D R U P D W D W D 7 S H R Q V W U D L Q W F W L Y H R O O H F W L R Q H V R U E O D Q N 6 W H S 5 X O H 1 R 6 W H S 5 X O H U R S S H G 6 W H S 5 X O H Q G L F D W H L I R Y H U S D P H Q W L V L Q S U R F H V V R I U H F R Y H U X V H 1 L I R Y H U S D P H Q W L V Q R O R Q J H U L Q S U R F H V V R I U H F R Y H U X V H L I W K H H V W D E O L V K H G G D W H L V S U L R U W R Q L Q H T X D U W H U V S U L R U W R W K H U H S R U W T X D U W H U D Q G W K H R Y H U S D P H Q W Z D V L Q S U R F H V V R I U H F R Y H U L Q W K H S U L R U T X D U W H U E X W U H F R Y H U Z D V G U R S S H G L Q W K H U H S R U W T X D U W H U 7 H W 1 5 H T X L U H G I R U R Y H U S D P H Q W V Z L W K E D O D Q F H V P R U H W K D Q G D V S D V W G X H R S W L R Q D O I R U R W K H U R Y H U S D P H Q W E D O D Q F H V 5 7 S H R I 2 Y H U S D P H Q W V U D X G 6 W H S 5 X O H 1 R Q I U D X G 6 W H S 5 X O H 7 K H W S H R I R Y H U S D P H Q W L V U D X G R U 1 R Q I U D X G 7 H W U D X G 1 R Q I U D X G 5 H T X L U H G I R U R Y H U S D P H Q W V Z L W K E D O D Q F H V P R U H W K D Q T X D U W H U V S D V W G X H R S W L R Q D O I R U R W K H U R Y H U S D P H Q W E D O D Q F H V 5 8 D O D Q F H D W Q G R I 4 W U 6 W H S 5 X O H 7 K H 6 W D W H 8 Q H P S O R P H Q W I X Q G V R Y H U S D P H Q W E D O D Q F H D W W K H H Q G R I W K H T X D U W H U 1 X P E H U 5 H T X L U H G I R U 8 F O D L P V P X V W E H E O D Q N R U I R U 8 D Q G 8 F O D L P V 0 H G H U D O D O D Q F H D W W K H Q G R I 4 W U 6 W H S 5 X O H 7 K H H G H U D O I X Q G V R Y H U S D P H Q W E D O D Q F H D W W K H H Q G R I W K H T X D U W H U 1 X P E H U 5 H T X L U H G I R U 8 8 D Q G M R L Q W F O D L P V P X V W E H E O D Q N R U I R U 8 F O D L P V 0 8 Q H P S O R P H Q W Q V X U D Q F H D W D 9 D O L G D W L R Q 2 S H U D W L R Q V X L G H 3 3 1 5 2 5 2 8 7 1 R L H O G 1 D P H 0 R G X O H 5 H I H U H Q F H L H O G H V F U L S W L R Q D W D R U P D W D W D 7 S H R Q V W U D L Q W 8 V H U 8 V H U G H I L Q H G I L H O G D Q E H X V H G I R U D Q D G G L W L R Q D O G D W D H O H P H Q W 1 R W P D Q G D W R U 7 H W 2 S W L R Q D O 5 Unemployment Insurance Data Validation Operations Guide APPENDIX B B-1 Unemployment Insurance Data Validation Operations Guide B-2 EXPLANATION OF UI TAX DATA FORMATS There are 6 types of data formats referred to in Appendix B. 1. Required. These fields cannot be blank. They may be mandatory codes dates or dollar values. Required cells in Appendix A tables indicate the required code date or dollar value parameters or display the word Required. Required text fields have code values that must be entered such as A C R etc. All of the allowable generic values for each field are listed in the Data Type Format column on the record layout. The generic values must be followed by a dash and the corresponding state-specific value. 2. Conditionally required. Data are included in these fields if the data are present in the state s system. Applies to date and wages fields. 3. Optional. These fields are gray in Appendix B and the word Optional is displayed. The software does not look at these fields at all. Any values can be entered or they can be left blank. 4. Must be blank. These are text or date fields where the presence of data indicates an error. Therefore they must be left blank such as population 4 transaction date for balance subpopulations 4.7 4.8 4.15 and 4.16 . 5. Must be blank or 0. These are numeric fields where the presence of data other than 0 indicates an error. In tax these are primarily wages fields in populations 4 and 5. 6. System generated. These fields are generated by the DV software and data should not be placed in these fields in the extract files. These fields are primarily time lapse and age fields. Notes For most steps referenced in Appendix B column headers Rule 1 is the indicator in the state system. However if a state does not maintain the indicator specified in Rule 1 then the state programmer must review the other rules in that step in order to develop the required validation logic. The extract file type is ASCII comma delimited. Data must be in the order listed in the record layouts. Unemployment Insurance Data Validation Operations Guide TAX RECORD LAYOUT FOR POPULATION 1 The record layout provides the format for the validation extract file. The extract file type must be ASCII comma delimited columns. Data must be in the order listed in the record layout. The Data Format column indicates the generic values for text fields. These must be followed by a dash and the state-specific value. The Module 3 reference indicates the step where the state-specific values are documented. Example If the state-specific code for an Active Employer is 01 then the data format would be A-01. No. Field Name Module 3 Reference Field Description Data Format Data Type Constraint 1 OBS Assign to each record. Use sequential numbers starting at 1. Number - 00000000 Required INTEGER NOT NULL 2 EAN Step 1A Employer Account Number Number - 000000000 Required CHAR 20 NOT NULL 3 Employer Status Indicator Step 3A Indicate that the employer is an active employer. Text - A Required CHAR 20 NOT NULL 4 Employer Type Step 2A Step 2B Indicate whether the employer type is contributory or reimbursable. Text C R Required CHAR 20 NOT NULL 5 Liability Date Met Threshold Step 14 Indicate the most recent date on which the employing unit met the State law definition of a newly established or successor employer. Date - MM DD YYYY Required DATE NOT NULL APPENDIX B RECORD LAYOUT B-3 Unemployment Insurance Data Validation Operations Guide APPENDIX B RECORD LAYOUT B-4 No. Field Name Module 3 Reference Field Description Data Format Data Type Constraint 6 Reactivation Processing Date Step 16 Indicate the date on which an employer account was updated on the State s system to reflect the reactivation of a previously inactivated or terminated employer. Date - MM DD YYYY DATE 7 Inactive Terminated as of Date Step 5 Indicate the effective date for the termination or inactivation status of the employer. Date - MM DD YYYY DATE 8 Activation Processing Date Step 15 Indicate the date on which an account was established on the State s system for an employer under the State unemployment compensation law. Date - MM DD YYYY Required DATE NOT NULL Unemployment Insurance Data Validation Operations Guide APPENDIX B RECORD LAYOUT B-5 No. Field Name Module 3 Reference Field Description Data Format Data Type Constraint 9 Number of Liable Quarters Step 7B Indicate the number of consecutive quarters between the date the employer was activated or reactivated on the State s system and the quarter prior to the report quarter being validated. If the number of liable quarters is eight or more the value should be reported as eight. If the employer was activated or reactivated during the report quarter then the number of liable quarters is zero. Number 0 1 2 3 4 5 6 7 8 Required INTEGER NOT NULL 10 Wages in Quarter 1 Step 7A Total wages for the employer in the quarter prior to the report quarter. Enter 0.00 for either zero wage reports or reports that weren t filed. Number- 0000000000000.00 Conditionally Required DECIMAL 15 2 11 Wages in Quarter 2 Step 7A Total wages for the employer in the second quarter prior to the report quarter. Enter 0.00 for either zero wage reports or reports that weren t filed. Number- 0000000000000.00 Conditionally Required DECIMAL 15 2 Unemployment Insurance Data Validation Operations Guide APPENDIX B RECORD LAYOUT B-6 No. Field Name Module 3 Reference Field Description Data Format Data Type Constraint 12 Wages in Quarter 3 Step 7A Total wages for the employer in the third quarter prior to the report quarter. Enter 0.00 for either zero wage reports or reports that weren t filed. Number - 0000000000000.00 Conditionally Required DECIMAL 15 2 13 Wages in Quarter 4 Step 7A Total wages for the employer in the fourth quarter prior to the report quarter. Enter 0.00 for either zero wage reports or reports that weren t filed. Number - 0000000000000.00 Conditionally Required DECIMAL 15 2 14 Wages in Quarter 5 Step 7A Total wages for the employer in the fifth quarter prior to the report quarter. Enter 0.00 for either zero wage reports or reports that weren t filed. Number - 0000000000000.00 Conditionally Required DECIMAL 15 2 15 Wages in Quarter 6 Step 7A Total wages for the employer in the sixth quarter prior to the report quarter. Enter 0.00 for either zero wage reports or reports that weren t filed. Number - 0000000000000.00 Conditionally Required DECIMAL 15 2 Unemployment Insurance Data Validation Operations Guide APPENDIX B RECORD LAYOUT B-7 No. Field Name Module 3 Reference Field Description Data Format Data Type Constraint 16 Wages in Quarter 7 Step 7A Total wages for the employer in the seventh quarter prior to the report quarter. Enter 0.00 for either zero wage reports or reports that weren t filed. Number - 0000000000000.00 Conditionally Required DECIMAL 15 2 17 Wages in Quarter 8 Step 7A Total wages for the employer in the eighth quarter prior to the report quarter. Enter 0.00 for either zero wage reports or reports that weren t filed. Number - 0000000000000.00 Conditionally Required DECIMAL 15 2 18 User Field User defined field. Can be used for any additional data element. Text Optional CHAR 100 Unemployment Insurance Data Validation Operations Guide TAX RECORD LAYOUT FOR POPULATION 2 The record layout provides the format for the validation extract file. The extract file type must be ASCII comma delimited columns. Data must be in the order listed in the record layout. The Data Format column indicates the generic values for text fields. These must be followed by a dash and the state-specific value. The Module 3 reference indicates the step where the state-specific values are documented. Example If the state-specific code for Contributory Employer Type is A then the data format would be C-A. No. Field Name Module 3 Reference Field Description Data Format Data Type Constraint 1 OBS Sequential number start at 1 Number - 00000000 Required INTEGER NOT NULL 2 EAN Step 1B Employer Account Number Number - 000000000 Required CHAR 20 NOT NULL 3 Employer Report Quarter ERQ Step 1B Indicate the calendar quarter of business activity covered by an employer s contributions report. Number - YYYYQQ Required CHAR 6 NOT NULL 4 Employer Type Step 2A Step 2B Indicate whether the employer type is contributory or reimbursable. Text C R Required CHAR 20 NOT NULL 5 Received Date Step 9 Indicate the date of receipt by the agency of the contributions report from a subject employer. Date - MM DD YYYY Conditionally Required DATE 6 Final Assessment Date Step 10 Indicate the date a final assessment becomes legally due and collectible. Date - MM DD YYYY Conditionally Required DATE APPENDIX B RECORD LAYOUT B-8 Unemployment Insurance Data Validation Operations Guide APPENDIX B RECORD LAYOUT B-9 No. Field Name Module 3 Reference Field Description Data Format Data Type Constraint 7 Liability Date Initial or Reopen Step 4A Step 4B Indicate the date on which an employing unit meets the State s legal definition of an employer and is registered and required to file reports. Date - MM DD YYYY Conditionally Required DATE 8 Liability Date Met Threshold Step 14 Indicate the most recent date on which the employing unit met the State law definition of a newly established or successor employer. Date - MM DD YYYY Conditionally Required DATE 9 Inactive Terminated as of Date Step 5 Indicate the effective date for termination or inactivation status of the employer. Date - MM DD YYYY Conditionally Required DATE 10 Suspended as of Quarter Step 5 Indicate the specific ERQ for which the State has suspended the employer s report filing requirement. Number - YYYYQQ CHAR 6 11 Inactivation Termination Processing Date Step 6A Step 6B Step 6C Indicate the processing date for the inactivation or termination status of the employer. Date - MM DD YYYY Conditionally Required DATE 12 User Field User defined field. Can be used for any additional data element. Text Optional CHAR 100 Unemployment Insurance Data Validation Operations Guide TAX RECORD LAYOUT FOR POPULATION 3 The record layout provides the format for the validation extract file. The extract file type must be ASCII comma delimited columns. Data must be in the order listed in the record layout. The Data Format column indicates the generic values for text fields. These must be followed by a dash and the state-specific value. The Module 3 reference indicates the step where the state-specific values are documented. Example If the state-specific code for New Status Determination is NEW then the data format would be N-NEW. No. Field Name Module 3 Reference Field Description Data Format Data Type Constraint 1 OBS Sequential number start at 1 Number - 00000000 Required INTEGER NOT NULL 2 EAN Step 1C Employer Account Number Number - 000000000 Required CHAR 20 NOT NULL 3 Employer Type Step 2A Step 2B Indicate whether the employer type is contributory or reimbursable. Text C R Required CHAR 20 NOT NULL 4 Status Determination Type Indicator Step 11A Step 11B Step 11C Step 11D Indicate status determination type by New Successor Inactivation or Termination. Text N S I T Required CHAR 10 NOT NULL 5 Time Lapse Step 12 Place a zero 0 in this field. Software generates the time lapse Number 0 INTEGER APPENDIX B RECORD LAYOUT B-10 Unemployment Insurance Data Validation Operations Guide APPENDIX B RECORD LAYOUT B-11 No. Field Name Module 3 Reference Field Description Data Format Data Type Constraint 6 Status Determination Date Step 13 Indicate the date of any recorded administrative action that establishes modifies changes inactivates or terminates an employing unit s liability as an employer. Date - MM DD YYYY Required DATE NOT NULL 7 Liability Date Met Threshold Step 14 Indicate the most recent date on which the employing unit met the State law definition of a newly established or successor employer. Date - MM DD YYYY Required DATE NOT NULL 8 End of Liable Quarter Step 14 Indicate the last day of the quarter in which the employing unit met the State law definition of a newly established or successor employer. States that do not have this should leave the field blank the value will then be calculated by the software. Date - MM DD YYYY Conditionally Required DATE 9 Activation Processing Date Step 15 Indicate the date on which an account was established on the State s system for an employer under the State unemployment compensation law. Date - MM DD YYYY DATE Unemployment Insurance Data Validation Operations Guide APPENDIX B RECORD LAYOUT B-12 No. Field Name Module 3 Reference Field Description Data Format Data Type Constraint 10 Reactivation Processing Date Step 16 Indicate the date on which an employer account was updated on the State s system to reflect the reactivation of a previously inactivated or terminated employer. Date - MM DD YYYY DATE 11 Successorship Processing Date Step 17 Indicate the date on which an employer account was established or updated to reflect an acquisition by the employer which met the State law definition of successorship. Date - MM DD YYYY DATE 12 Predecessor Account Number Step 18 Indicate the account number for an employing unit that has been acquired by another employer. Number - 000000000 CHAR 20 13 Inactivation Processing Date Step 6A or Step 6B Indicate the processing date for the inactivation status of the employer. Date - MM DD YYYY DATE 14 Termination Processing Date Step 6A or Step 6C Indicate the processing date for the termination status of the employer. Date - MM DD YYYY DATE Unemployment Insurance Data Validation Operations Guide APPENDIX B RECORD LAYOUT B-13 No. Field Name Module 3 Reference Field Description Data Format Data Type Constraint 15 User Field User defined field. Can be used for any additional data element. Text Optional CHAR 100 Unemployment Insurance Data Validation Operations Guide TAX RECORD LAYOUT FOR POPULATION 4 The record layout provides the format for the validation extract file. The extract file type must be ASCII comma delimited columns. Data must be in the order listed in the record layout. The Data Format column indicates the generic values for text fields. These must be followed by a dash and the state-specific value. The Module 3 reference indicates the step where the state-specific values are documented. Example If the state-specific code for Receivables Established is R then the data format would be E-R. No. Field Name Module 3 Reference Field Description Data Format Data Type Constraint 1 OBS Sequential number start at 1 Number - 00000000 Required INTEGER NOT NULL 2 EAN Step 1D Employer Account Number Number - 000000000 Required CHAR 20 NOT NULL 3 Employer Type Step 2A Step 2B Indicate whether the employer type is contributory or reimbursable. Text C R Required CHAR 20 NOT NULL 4 Transaction Date Step 19A Indicate the date that a transaction was entered into the system. Date - MM DD YYYY DATE 5 Established Q Date Step 19B Indicate the date that a past due contribution was entered into the system. Date - MM DD YYYY Required DATE NOT NULL 6 Employer Report Quarter ERQ Step 1D Indicate the calendar quarter of business activity covered by an employer s contributions report. Number - YYYYQQ CHAR 6 7 Due Date Step 20 Indicate the date after which the State imposes interest and penalty for late payment. Date - MM DD YYYY DATE APPENDIX B RECORD LAYOUT B-14 Unemployment Insurance Data Validation Operations Guide APPENDIX B RECORD LAYOUT B-15 No. Field Name Module 3 Reference Field Description Data Format Data Type Constraint 8 Transaction Type Indicator Step 21A Step 21B Step 21C Indicate the transaction type code for receivables established liquidated declared uncollectible or removed. Use a code of B for records of account balances at the end of the RQ. Text E L U R B Required CHAR 20 NOT NULL 9 Amount Established in RQ Step 22 Indicate the amount of contributions or payments determined to be past due during the report quarter. Number - 0000000000000.00 DECIMAL 15 2 10 Amount Liquidated Step 23 Indicate the amount of receivables liquidated during the report quarter. Number - 0000000000000.00 DECIMAL 15 2 11 Amount Uncollectible Step 24 Indicate the amount of receivables declared uncollectible during the report quarter. Number - 0000000000000.00 DECIMAL 15 2 12 Amount Removed Step 25 Indicate the amount of receivables removed during the report quarter. Number - 0000000000000.00 DECIMAL 15 2 Unemployment Insurance Data Validation Operations Guide APPENDIX B RECORD LAYOUT B-16 No. Field Name Module 3 Reference Field Description Data Format Data Type Constraint 13 Balance at End of RQ Step 26 Indicate the total amount of past due contributions as of the last day of the report quarter being validated. For aging States should capture a separate record for each employer report quarter that has a balance rather than an aggregate balance. Number - 0000000000000.00 DECIMAL 15 2 14 Age of Receivable Step 27A Step 27B Indicate the age of receivable in days for receivable balances at the end of the report quarter. Number 0000000000000 Optional INTEGER 15 User Field User defined field. Can be used for any additional data element. Text Optional CHAR 100 Unemployment Insurance Data Validation Operations Guide TAX RECORD LAYOUT FOR POPULATION 5 The record layout provides the format for the validation extract file. The extract file type must be ASCII comma delimited columns. Data must be in the order listed in the record layout. The Data Format column indicates the generic values for text fields. These must be followed by a dash and the state-specific value. The Module 3 reference indicates the step where the state-specific values are documented. Example If the state-specific code for a Large Employer is Y then the data format would be L-Y. No. Field Name Module 3 Reference Field Description Data Format Data Type Constraint 1 OBS Sequential number start at 1 Number - 00000000 Required INTEGER NOT NULL 2 EAN Step 1E Employer Account Number Number - 000000000 Required CHAR 20 NOT NULL 3 Audit ID Step 1E Indicate the audit identification number. Number - 00000000 Required CHAR 20 NOT NULL 4 Employer Size Step 28A Step 28B Indicate whether the employer size is large or small. Text L S Required CHAR 20 NOT NULL 5 Change Audit Step 29A Step 29B Indicate whether an audit resulted in a discovery of wages contributions or employees not previously reported. Text Y N If field is blank software will determine if record has value not equal to 0 in any one of record layout fields 9 10 14 15 19 20. Software will then place a Y-DVWS in field. CHAR 20 6 Audit Completion Date Step 30 Indicate the date the audit was completed and recorded or posted as such. Date - MM DD YYYY Required DATE NOT NULL APPENDIX B RECORD LAYOUT B-17 Unemployment Insurance Data Validation Operations Guide APPENDIX B RECORD LAYOUT B-18 No. Field Name Module 3 Reference Field Description Data Format Data Type Constraint 7 Total Wages Pre-Audit Step 31A Indicate the full amount of pre-audit total wages reported for quarters audited. Number - 0000000000000.00 Required DECIMAL 15 2 NOT NULL 8 Total Wages Post-Audit Step 31B Indicate the full amount of total wages recorded in audit summaries for audited quarters. Number - 0000000000000.00 Required DECIMAL 15 2 NOT NULL 9 Total Wages Under- Reported Step 31C Indicate the full amount of under reported total wages discovered as a result of the audit. Number - 0000000000000.00 DECIMAL 15 2 10 Total Wages Over-Reported Step 31D Indicate the full amount of over reported total wages discovered as a result of the audit. Number - 0000000000000.00 DECIMAL 15 2 11 Total Wages Reconciliation Amount Step 31E Place a zero 0 in this field. Software generates amount Number 0 DECIMAL 15 2 12 Taxable Wages Pre-Audit Step 32A Indicate the full amount of pre-audit taxable wages reported for quarters audited. Number - 0000000000000.00 Optional DECIMAL 15 2 13 Taxable Wages Post-Audit Step 32B Indicate the full amount of post-audit taxable wages for quarters audited. Number - 0000000000000.00 Optional DECIMAL 15 2 14 Taxable Wages Under-Reported Step 32C Indicate the full amount of under reported taxable wages discovered as a result of the audit. Number - 0000000000000.00 DECIMAL 15 2 Unemployment Insurance Data Validation Operations Guide APPENDIX B RECORD LAYOUT B-19 No. Field Name Module 3 Reference Field Description Data Format Data Type Constraint 15 Taxable Wages Over-Reported Step 32D Indicate the full amount of over reported taxable wages discovered as a result of the audit. Number - 0000000000000.00 DECIMAL 15 2 16 Taxable Wages Reconciliation Amount Step 32E Place a zero 0 in this field. Software generates amount Number 0 DECIMAL 15 2 17 Contributions Pre-Audit Step 33A Indicate the full amount of pre-audit contributions reported for quarters audited. Number - 0000000000000.00 Optional DECIMAL 15 2 18 Contributions Post-Audit Step 33B Indicate the full amount of post-audit contributions reported for quarters audited. Number - 0000000000000.00 Optional DECIMAL 15 2 19 Contributions Under-Reported Step 33C Indicate the full amount of under reported contributions discovered as a result of the audit. Number - 0000000000000.00 DECIMAL 15 2 20 Contributions Over-Reported Step 33D Indicate the full amount of over reported contributions discovered as a result of the audit. Number - 0000000000000.00 DECIMAL 15 2 21 Contributions Reconciliation Amount Step 33E Place a zero 0 in this field. Software generates amount Number 0 DECIMAL 15 2 22 User Field User defined field. Can be used for any additional data element. Text Optional CHAR 100 Unemployment Insurance Data Validation Operations Guide C-1 APPENDIX C Unemployment Insurance Data Validation Operations Guide BENEFITS DUPLICATE DETECTION CRITERIA Population Reporting Rule Relevant Data Elements from Extract file Duplicate Detection Criteria Comments 1. Weeks Claimed The same week of unemployment can only be claimed once. SSN Claim Week-Ending Date Field 2 Remove as duplicates all multiple records with the same SSN and Claim Week Ending Date. 2. Final Payments A Benefit Year normally has only one final payment unless wages were added returned after initial exhaustion. SSN Mail Date Check Unique ID Remove as duplicates all multiple records with the same SSN check number unique ID and mail date. The mail date criterion would falsely reject the unlikely but legitimate case of two Final Payments for separate claims that exhaust on the same day. In such a case the validator can append an extra unique character to the Unique ID field value e.g. -1 -2 -3 to each of the valid records so that the software will not reject them. APPENDIX C DUPLICATE DETECTION CRITERIA C-2 Unemployment Insurance Data Validation Operations Guide Population Reporting Rule Relevant Data Elements from Extract file Duplicate DetectionCriteria Comments 3. Claims Report each legitimate claim once. Most claim types will be reportable only once in a quarter. Multiple UI New or Transitional claims may be legitimate however there can be only one claim with a sufficient monetary per SSN within the same quarter. Although there can be more than one with an insufficient monetary none may follow a sufficient claim. SSN Date Claim Filed Program Type Claim Type Sufficient Insufficient Field 9 1. For all Claim Type and Program Type combinations Remove as duplicates all multiple records with the same SSN Date Claim Filed and Claim Type. 2. For UI New and Transitional Claims Remove as duplicates all multiple records for which SSN and Claim Type are the same for multiple records where Field 9 Sufficient and all records for the same SSN and Claim type with Field 9 Insufficient with a Claim Filed Date later than the same SSN and Claim Type with Field 9 Sufficient. The duplicate detection function in Population 3 must distinguish a multiple claims that may be legitimately counted from b multiple instances of claims that may be counted only once true duplicates . Situation a arises mostly for UI New and Transitional claims. To define legitimate UI New and Transitional claims the decision was made to allow only one Sufficient determination in the same quarter for the same claim type and not to allow an Insufficient claim to follow a Sufficient claim for the same SSN and claim type. APPENDIX C DUPLICATE DETECTION CRITERIA C-3 Unemployment Insurance Data Validation Operations Guide Population Reporting Rule Relevant Data Elements from Extract file Duplicate DetectionCriteria Comments 3.a Additional Claims Every additional claim is associated with a week of unemployment and involves at least a 1-week break in the claims series due to intervening employment and separation from an employer. SSN Date Claim Filed Separation Date Remove as duplicates all multiple records with the same SSN Date Claim Filed and Separation Date. SSN plus Separation Date represent hard or definitive criteria for duplicates. SSN and Date Claim Filed could be used as soft duplicate detection criteria that identi fy potential instances of duplication. If used the validator must manually determine which claims are countable taking a sample of all records of multiple instances of the same SSN and Date Claim Filed if the number of cases is considerably large. APPENDIX C DUPLICATE DETECTION CRITERIA C-4 Unemployment Insurance Data Validation Operations Guide Population Reporting Rule Relevant Data Elements from Extract file Duplicate DetectionCriteria Comments 4. Payments There can only be one countable regular week compensated for a given week. Where there is a CWC payment there is a separate count of one CWC payment per week. There is no rule limiting the number of adjustment checks. SSN Intra In terstate Week-End Date Field 16 Mail Date Field 17 1. For all but CWC payments and adjustments i.e. for subpops 4.1-4.32 and 4.43 Remove as duplicates all multiple records where SSN Intra Interstate Mail Date and Week End Date are the same. 2. For CWC only Remove as duplicates all multiple records where SSN and Week End Date are the same. 3. For Adjustment Payments No duplicate check A week compensated cannot be counted twice for the same week ending date. Since the week can be counted both as a regular week and a CWC week the software performs the check separately for both groups. Because states may issue multiple adjustment checks as needed to correct a claimant s prior benefits no duplicate detection is needed for multiple adjustments. APPENDIX C DUPLICATE DETECTION CRITERIA C-5 Unemployment Insurance Data Validation Operations Guide Population Reporting Rule Relevant Data Elements from Extract file Duplicate DetectionCriteria Comments 5. Nonmonetary Determinations Count every monetary determination once. SSN Unique ID Issue Type Field 9 Notice Data Field 12 . Remove as duplicates all multiple records with the same SSN Unique ID Issue Code and Mail Date. When state has Unique ID this will definitively identify duplicate records. When Unique ID is null validator must manually remove duplicates from the extract file assign a Unique ID e.g. 1 2 and 3 to each legitimate multiple transaction in the file and then reload it into the software. Records with the same SSNs Issue Code and Mail Date but no Unique ID should be manually checked to determine whether they are duplicates. 6. Lower Authority Appeals Filed Count every appeal once. SSN Docket Unique IDRemove as duplicates all multiple records with the same SSN and Docket Number Unique ID. If the same SSN and docket number appears more than once only one record should be included in the extract file. 7. Higher Authority Appeals Filed Count every appeal once. SSN Docket Unique IDRemove as duplicates all multiple records with the same SSN and Docket Number Unique ID. If the same SSN and docket number appears more than once only one record should be included in the extract file. APPENDIX C DUPLICATE DETECTION CRITERIA C-6 Unemployment Insurance Data Validation Operations Guide Population Reporting Rule Relevant Data Elements from Extract file Duplicate DetectionCriteria Comments 8. Lower Authority Appeals Decisions Count every appeal once. SSN Docket Unique IDRemove as duplicates all multiple records with the same SSN and Docket Number Unique ID. If the same SSN and docket number appears more than once only one record should be included in the extract file. 9. Higher Authority Appeals Decisions Count every appeal once. SSN Docket Unique IDRemove as duplicates all multiple records with the same SSN and Docket Number Unique ID. If the same SSN and docket number appears more than once only one record should be included in the extract file. 10. Lower Authority Appeals Case Aging Count every appeal once. SSN Docket Unique IDRemove as duplicates all multiple records with the same SSN and Docket Number Unique ID. If the same SSN and docket number appears more than once only one record should be included in the extract file. 11. Higher Authority Appeals Case Aging Count every appeal once. SSN Docket Unique IDRemove as duplicates all multiple records with the same SSN and Docket Number Unique ID. If the same SSN and docket number appears more than once only one record should be included in the extract file. APPENDIX C DUPLICATE DETECTION CRITERIA C-7 Unemployment Insurance Data Validation Operations Guide Population Reporting Rule Relevant Data Elements from Extract file Duplicate DetectionCriteria Comments 12. Overpayments Established Count each overpayment only once. SSN Date Overpayment Established Unique ID Remove as duplicates all multiple records with the same SSN Date Overpayment Established and Unique ID. If state has Unique ID this definitively identifies duplicates. If Unique ID is null validator must manually remove duplicates from the extract file assign a Unique ID e.g. 1 2 and 3 to each legitimate multiple transaction in the file and then reload it into the software. Records with the same SSN and Date Overpayment Established but no Unique ID should be manually checked to determine whether they are duplicates. APPENDIX C DUPLICATE DETECTION CRITERIA C-8 Unemployment Insurance Data Validation Operations Guide Population Reporting Rule Relevant Data Elements from Extract file Duplicate DetectionCriteria Comments 13. Overpayment Reconciliation Count each transaction only once. SSN Unique ID Activity Type Date of Activity Remove as duplicates all multiple records with the same SSN Unique ID Date of Activity and Activity Type. If state has Unique ID this definitively identifies duplicates. If Unique ID is null validator must manually remove duplicates from the extract file and assign a Unique ID e.g. 1 2 and 3 to each legitimate multiple transaction in the file and then reload it into the software. Records with the same SSN Date of Activity and Activity Type but no Unique ID should be manually checked to determine whether they are duplicates. APPENDIX C DUPLICATE DETECTION CRITERIA C-9 Unemployment Insurance Data Validation Operations Guide APPENDIX C DUPLICATE DETECTION CRITERIA C-10 Population Reporting Rule Relevant Data Elements from Extract file Duplicate DetectionCriteria Comments 14. Overpayments Case Aging Count each overpayment once. SSN Unique ID Remove as duplicates all multiple records with the same SSN and Unique ID. If state has Unique ID this definitively identifies duplicates. If Unique ID is null validator must manually remove duplicates from the extract file and assign a Unique ID e.g. 1 2 and 3 to each legitimate multiple transaction in the file and then reload it into the software. Records with the same SSN but no Unique ID should be manually checked to determine whether they are duplicates. Unemployment Insurance Data Validation Operations Guide APPENDIX D Unemployment Insurance Data Validation Operations Guide TAX DUPLICATE DETECTION CRITERIA Population ETA 581 Reporting Rule Relevant Data Elements from Extract File by Field Number Data Validation Duplicate Detection Rule Applied to Extract File Comments 1. Active Employers Count each employer once. Multi- unit employers are counted as one employer. 2. Employer Account Number EAN If the EAN is identical in two or more records all of those records are rejected. As long as EANs are only assigned at the parent level this should identify units from the same multi-unit employer. 2. Report Filing Each employer owes only one report for each employer report quarter ERQ . This report is counted a maximum of 3 times timely secured and resolved. If an employer submits reports for multiple ERQs at the same time only the report for the ERQ immediately preceding the report quarter RQ is countable as timely if applicable and secured. Only the report for the ERQ two quarters prior to the RQ is countable as resolved. Reports from multi-unit employers are counted as one report. 2. EAN 3. Employer Report Quarter ERQ If the EAN and ERQ are identical in two or more records all of those records are rejected. As long as EANs are only assigned at the parent level this should identify units from the same multi-unit employer. APPENDIX D DUPLICATE DETECTION CRITERIA D-2 Unemployment Insurance Data Validation Operations Guide Population ETA 581 Reporting Rule Relevant Data Elements from Extract File by Field Number Data Validation Duplicate Detection Rule Applied to Extract File Comments 3. Status Determinations Each status determination transaction should be counted only once. Individual EANs may appear more than once. For example there might be two transactions listed for a single EAN if an employer acquires two businesses at different times during the quarter resulting in tw o successorship determinations. Multiple determinations may be legitimate as long as they do not reflect clerical errors. 2. EAN 4. Status Determination Type Indicator 6. Status Determination Date 12. Predecessor Account Number If the status determination type indicator is NEW subpops 3.1 3.3 and the EAN and status determination date are identical in two or more records all of those records are rejected. SUCCESSOR subpops 3.4 3.6 and the EAN and status determination date and predecessor account number are identical in two or more records all of those records are rejected. INACTIVATION or TERMINATION subpops 3.7 and 3.8 and the EAN and status determination date are identical in two or more records all of those records are rejected. APPENDIX D DUPLICATE DETECTION CRITERIA D-3 Unemployment Insurance Data Validation Operations Guide Population ETA 581 Reporting Rule Relevant Data Elements from Extract File by Field Number Data Validation Duplicate Detection Rule Applied to Extract File Comments 4. Accounts Receivable No transaction should be listed more than once. 2. EAN 4. Transaction Date 5. Established Date 6. Employer Report Quarter cont. 7. Due Date reimb. 8. Transaction Type 9. Transaction Amount established 10. Transaction Amount liquidated 11. Transaction Amount uncollectible 12. Removed Amount 13. Balance at End of Report Quarter If the transaction type is E subpops 4.1 and 4.9 and the EAN transaction date established date ERQ cont. or Due Date reimb. and amount established are identical in two or more records all of those records are rejected. L or U subpops 4.2-4.4 and 4.10-4.12 and the EAN transaction date ERQ cont. or Due Date reimb. transaction type and transaction amount are identical in two or more records all of those records are rejected. R subpops 4.5-4.6 4.13-4.14 and the EAN ERQ cont. or Due Date reimb. and removed amount are identical in two or more records all of those records are rejected. B subpop 4.7-4.8 4.15-4.16 and the EAN ERQ cont. or Due Date reimb. and balance are identical in two or more records all of those records are rejected. Currently the UI Tax DVWS does not check for duplicates in Population 4. State IT staff now is responsible for ensuring that the extract file does not include duplicate transactions. DVWS 1.1 will be modified to include the new duplicate detection criteria. APPENDIX D DUPLICATE DETECTION CRITERIA D-4 Unemployment Insurance Data Validation Operations Guide APPENDIX D DUPLICATE DETECTION CRITERIA D-5 Population ETA 581 Reporting Rule Relevant Da ta Elements from Extract File by Field Number Data Validation Duplicate Detection Rule Applied to Extract File Comments 5. Field Audits Each field audit should be counted once. 2. EAN 3. Audit ID Number If the EAN and Audit ID Number are identical in two or more records all of those records are rejected.