Download:
pdf |
pdf This page is intentionally left blank
U.S. Department of Labor
Employment and Training
Administration
OFFICE of WORKFORCE SECURITY
UNEMPLOYMENT INSURANCE REPORTS
USER MANUAL – WEB VERSION
ETA Handbook 402
Fifth Edition
May 2008
This page is intentionally left blank
UI REPORTS HANDBOOK NO. 402
CONTENTS
INTRODUCTION
What Is the Purpose of This Handbook? ........................................................ i
A Quick Tour of the Contents………………………………………………………ii
1. GETTING STARTED
Database Systems..……………………………………………………..………….I-1
Relational Database..…………………………………………………..………….. I-1
Informix-SQL (ISQL) ………………………………………………………………. I-1
Table Naming Conventions……………………………………………………….. I-1
Accessing the UIR Web-Based Menu..............................................................I-2
State Menu………………………………………………………………………….. I-3
UI Applications Menu……………………………………………………………….I-4
Login Screen………………………………………………………………………...I-5
Permissions / User Groups……………………………………………………….. I-5
Getting Help On-Line………………………………………………………………. I-5
National Office Technical Support………………………………………………...I-6
2. DATA ENTRY
Accessing Data Entry Application…………………………………………………II-1
Query/Add Screen……………………………………………………………….. II-2
Data Entry Screen…………………………………………………………………..II-4
Adding the Report Data…………………………………………………………….II-8
Updating the Report Data…………………………………………………………. II-8
Data Entry……………………………………………………………………………II-8
Validating the Report Data…………………………………………………………II-10
Report Output………………………………………………………………………. II-12
3. REPORT TIMELINESS
Accessing the Report Timeliness Application……………………………………III-1
Report Timeliness Screen ………………………………………………………... III-2
Report Timeliness Report Screen ……………………………………………….. III-4
4. MANAGE TRANSMITTAL
Accessing the Manage Transmittal Application ………………………………... IV-1
Manage Transmittal Utility Screen……………………………………………….. IV-2
Transmitting Reports to the National Office…………………………………….. IV-4
5. ASCII LOAD
Accessing the ASCII Load Application ………………………………………….. V-1
ASCII Load Utility Screen…………………………………………………………. V-2
Contents
5/2008
UI REPORTS HANDBOOK NO. 402
CONTENTS
6. QUALITY REPORTS
Accessing Quality Reports Application…………………………………………. VI-1
Manual Load………………………………………………………………………... VI-1
Validate………. ……………………………………………………………………..VI-7
Accessing the Evaluation Entry Application…………………………………….. VI-8
ETA 9056-Nonmonetary Determinations Quality Data Collection Instrument..VI-9
ETA 9057-Lower Authority Appeals Quality……………………………….VI-11
Transmit Quarterly Data…………………………………………………………….VI-13
Show Quarterly Scores……………………………………………………………..VI-14
7. REPORTS
Accessing the Reports…………………………………………………………….. VII-1
Report Query Screen……………………………………………………………….VII-2
Report Output Screen………………………………………………………………VII-4
APPENDICES
APPENDIX A: Report Forms with Data Maps ……….............…………………A1
APPENDIX B: ASCII File Format Specifications……….………………………..B1
APPENDIX C: Report Edit Specifications ………..……………………………...C1
Contents
5/2008
Introduction
5/7/2008
INTRODUCTION
This edition of the Unemployment Insurance Reports (UIR) User Manual - web Version reflects
UIR’s new web-based software. The conversion to a web-based design allows for easy access to
information and for faster data entry. The web-based design also allows for improved
performance and security measures. The functionality of these applications remains the same.
The UIR web applications can be accessed from the state’s UI SUN server.
All state workforce agencies (SWAs) regularly report data to the Office of Workforce Security
(OWS) in the U.S. Department of Labor. The National Office (NO) has developed a
sophisticated entry and reporting system in a web environment. This manual provides
instructions for operating the UIR web applications.
UIR data entry is important. The data entered into this system will be used in a variety of ways,
both nationally and state-wide. For example, the data will be used to:
monitor and evaluate the performance of state agencies;
reimburse states for administering their programs;
provide economic indicators; and
provide information to the public.
The UIR system provides the ability to report UI program data electronically. Users of the UIR
data include the SWAs, the ETA National and Regional Offices, Congress, Executive Branch
Agencies, the press, and the general public.
What Is the Purpose of This Handbook?
An automated system using web screens has been developed for the entry of program data. This
handbook explains the UIR system — what it is and how to use it.
i
Introduction
A Quick Tour of the Contents
The user's guide is divided into the following chapters:
Chapter 1 - Getting Started provides an introduction to the computer equipment needed to
run the data entry software and the software necessary to support the system.
Also described are the setups needed to allow users permission to enter data.
Instructions are given for global procedures — such as cursor movement, menus,
menu bars and the mouse — that are used in all data entry sessions.
Chapter 2 - Data Entry/ Query/Update/Output provides detailed instructions on how to add,
query, update, print, and transmit reports.
Chapter 3 - Report Timeliness provides information on how the state can keep track of the
timeliness status of reports submitted to the NO.
Chapter 4 - Automatic Transmittal provides further instructions on how to send reports from
the state’s database to the NO.
Chapter 5 - ASCII-Load provides information on how to electronically upload data from a
file to the UIR system eliminating the need to manually enter data.
Chapter 6 - Quality Reports provides detailed information on the UIR applications which
allow states to store and transmit electronically the results of quality reviews of
the nonmonetary determination process and lower authority appeals.
Chapter 7 - Reports provides the capability to generate reports without having to go through
the Data Entry application. After entering the query parameters, the UIR data is
displayed in a formatted report.
ii
Chapter 1
5/7/2008
1 GETTING STARTED
This chapter introduces you to the web-based UIR menu system. Information is provided about
the set up necessary to assign users permission to enter and transmit data. This first section is
general information about the databases.
Database Systems
Data are pieces of information. Data reside in files or tables. The file structure is a logical
way of storing data. Understanding this structure helps you find the data you need from the
database.
A database system is a collection of data stored in the computer in a logical and consistent
manner. Using this type of system allows the development of multiple applications using a
common database. Also, the database system allows the computer to store data efficiently
and it allows easy retrieval of data.
Relational Database
A relational database is a collection of data stored in two or more tables that share a common
column-name [key field] that joins the tables together in a single database. This key field
allows you to create relationships across tables when querying a database. You can look at
data stored in several tables as if they were a single table.
Informix-SQL (ISQL)
Informix is a commercial software product that was used to create the UI database (UIDB).
ISQL is the database management component of the UIDB. It organizes, stores, and retrieves
data. With custom Standard Query Language (SQL) statements you can create useful
programs and reports for yourself. However, writing custom SQL statements is beyond the
scope of this handbook.
An INFORMIX database has tables, rows, columns, screen forms, reports, and files. A table
organizes and stores data into rows and columns. A row is a record in the table containing all
the data fields. A column contains the data of a specific field for each record. A database file
or table is a collection of records or rows.
Table Naming Conventions
UIR data reside in tables. Understanding how data is stored will help you find the data you
need. Report tables store data reported by states and other sources. Each UIR table name
I-1
Getting Started
begins with the letter ‘a’, followed by another letter and usually three or four numbers.
The second letter in each report table is one of the following:
r - Regular program
e - Extended Benefits program
w - Work share version of the 5159, 9050 and 9051 reports
c - Emergency Unemployment Compensation
Example: “ar5159" is the table name that stores the regular program data of the ETA 5159,
Claims and Payment Activities Report.
A table can also have ending letters. For example, all reports have an associated version with
the ending letters of cmt to indicate the table holds comment information. Ending letters can
also be used to indicate a sub-grouping. For example, in ar9050p, p indicates a table on
“partial” claims; in ar9054h, h indicates a table on higher authority appeals; and in ar9054l, l
indicates a table on lower authority appeals.
The data in tables are generally stored in a series of consecutively named fields (or cells),
which are usually identified as c1, c2, etc. For a data map of the fields in each report table,
see Appendix A.
Accessing the UIR Web-Based Menu
URL
To access the UIR Web-Based Menu, use an Internet browser. In the address bar, enter
the URL as:
http://{fully qualified domainname}:8080/StateMenu
or
http://{IPaddress}:8080/StateMenu
Please contact your state’s System Administrator for the Domain name or IP Address.
I-2
Chapter 1
5/7/2008
State Menu
Upon entering the URL, the following main Applications Menu appears. (Figure 1.1)
Figure 1.1 Application Menu
•
Top Navigation Bar
The Navigation Bar displayed at the top of the menu screen helps the user to access one
of the following:
•
o
State Home: Link to the States’ website. The “State Home” page is maintained
by the State System Administrator.
o
Release Notes: Links to release notes for all applications.
o
Links: Additional links can be added by the State. The “Links” page is
maintained by the State System Administrator.
Bottom Navigation Bar
The Navigation Bar displayed at the bottom of the menu screen helps the user to access
one of the following:
I-3
Getting Started
o
Text Version: Link to an Americans with Disability Act (ADA) compliant “Text
Version” of the menu. ADA compliant software will allow UIR software access
to the users with disability.
o
Feedback: E-mail address to provide feedback.
o
Help: Information about the UI Applications Menu page.
UI Applications Menu
The main UI Applications Menu consists of 4 choices:
•
•
•
•
Data Validation
UIR (Unemployment Insurance Reports)
BAM (Benefits Accuracy Measurement)
TPS (Tax Performance System)
The arrow next to the menu options indicates that the menu will further expand when the link
is selected. When the link is clicked and the menu is expanded, the selected link arrow
changes from pointing to the link to pointing down.
Figure 1.2 Expanded Application Menu
icon next to the Application Menu provides Application Production Release information.
Clicking on the link again (or the down arrow) will compress the menu. Figure 1.2 shows an
expanded menu. The expanded menu may contain additional links to sub-menus. The links
with the web page icons
next to them are links to the applications.
I-4
Chapter 1
5/7/2008
Login Screen
For many menu options the user is required to login first. Login names and passwords are
initially set by the State Sun System Administrator. The Login screen is displayed as shown
in figure 1.3.
Figure 1.3 User Login Screen
Permissions / User Groups
Most UIR screens permit only authorized users to perform specific tasks. Users are
classified into two groups which are listed below. Your State SUN System Administrator
will place you in the appropriate group(s) and provide a user name and an initial password.
The user groups are:
•
•
Data entry group - uidbusr. This group can create reports, change data on reports,
obtain report status, and load ASCII files.
The approving official group - uidbapr. This group can sign off on reports and
transmit them to the National Office. Members of this group are usually also
members of the uidbusr group.
All other users with login access to the system can query the database through the Informix
Structured Query Language available on the state Sun system.
Getting Help On-Line
Each screen has a Help link on the bottom. Many screens also have a link to “Field Help.” If
I-5
Getting Started
your cursor is in a screen field, clicking the Field Help link will produce a small browser
window with context-sensitive help, which explains field information helpful to the user.
National Office Technical Support
If you have a problem or question about the UIR software, seek assistance from your state
Sun System Administrator (SSA). If your SSA cannot resolve the issue, the SSA will contact
the UI Technical Support staff at 1 (800) 473-0188 for help.
I-6
Chapter 2
2 DATA ENTRY
Accessing Data Entry Application
A data entry application allows you to:
• add new reports to the database
• query and update existing reports
• print reports
• transmit reports
To access a data entry application, choose the UIR option from the state Application Menu,
and then the Data Entry menu option. The Data Entry menu expands, displaying the UIR
reports categories, as shown in Figure 2.1:
Figure 2.1 UIR Menu
Each of these categories contains one or more individual reports. Choose one of these categories
to display individual report option(s). Click on the Report to open its data entry screen.
Note: Only authorized users can run these applications. If the user is not logged in already, then
an authorization screen will appear. Refer back to Chapter 1, Getting Started, on how to log into
and run the application. After logging in successfully, the user will be logged on the report data
entry query/add screen.
II-1
Data Entry
Query/Add Screen
A Query/Add screen is displayed, as shown in Figure 2.2.
Figure 2.2 Report Query/Add Screen
Users have the option of entering data for a new report or to query a previously entered
report. A Data Entry application query/add screen is comprised of the following:
•
Query Fields
A report can be selected or added by using the following query parameters:
o
Radio Buttons: You can use the radio buttons to either query report(s) or add a
new report. When you query the reports, the application retrieves the records
according to the report date you supply and orders them chronologically by the
report date, displaying the earliest one first.
o
Query Option: Click on the dropdown menu to choose one of the following
options and then enter a report date (example, 06/30/1996) in the text box next to
it:
EQUAL TO
Searches for reports with a Report Date equal to the date
II-2
Chapter 2
you enter (example, 06/30/1997).
o
GREATER THAN Searches for all reports in the database with Report
Date(s) occurs after the date you enter (example,
06/30/1997).
LESS THAN
Searches for all reports in the database with Report
Date(s) prior to the date you enter (example, 06/30/1997).
“Add” Option: Select the “Add” option to enter data for a new report. Enter a
Report date to specify the report period.
Report Date: The next due date for the report is automatically filled in for the
Add option. The user can change the date to enter the report data for some
other reporting period. The Report Date format is MM/DD/YYYY (for
example, 06/30/2007).
Note: The report date is the last day of the period to which a report pertains. Each
report has its own reporting period or cycle: weekly, monthly, quarterly, or annually.
•
•
Action Buttons
The query/add screen has the following action buttons:
o
Submit Query: Submits the user's request.
o
Clear Query: Resets all the fields to the default.
Navigation Bar
The Navigation Bar displayed at the bottom of the application screen helps the user to
access one of the following:
o
Home: Display the Applications Menu Page.
o
Feedback: Display the feedback contact information.
o
Help: Display the current application help.
II-3
Data Entry
Data Entry Screen
After entering query parameters, click the Submit Query button. A data entry screen appears,
as shown in Figure 2.3. Many reports require you to scroll down in order to complete the
entire report.
Figure 2.3 Data Entry Screen
A data entry screen is comprised of the following:
•
Record Navigation
When you query the reports, the application retrieves the records according to the report
date(s) you supply and orders them chronologically by the report date, displaying the
earliest one first. The following options help you browse the records.
o
First: Displays the first (earliest) record in the sequence.
II-4
Chapter 2
•
o
Prev: Displays the previous record in the sequence.
o
Next: Displays the next record in the sequence.
o
Last: Displays the last (most recent) record in the sequence.
Action Buttons
The following action buttons are displayed at both the top and bottom of the application
screen:
o
Query: Query one or more reports that have been saved to the Database. The
query/add screen will be displayed when you click on the query button.
o
Add: Add a new report to the Database. The query/add screen will be displayed when
you click on the add button.
o
Update: Make change(s) to the report. The data fields can be edited when you click
on the update button.
o
Save: Save the change(s) to the Database. The changes will be validated first, and the
review edit screen will be displayed if any errors or warnings are found. The changes
will not be saved to the Database if one or more fatal errors are found. However, if
only non-fatal error(s) or warning(s) are found, you will be provided with a
"Continue to Save" option. When the data has been saved into the database, the
message, “Record has been saved successfully” will be displayed.
o
Cancel: Cancel the change(s) that you have made. The data will revert to the value
you saved into the Database the last time you modified the record. A prompt, “Any
data that is not saved will be lost. Do you want to continue?” is displayed. The user
can click on the ‘OK’ button to exit out of data entry or click on the ‘Cancel’ button
to continue with data entry.
o
Validate: Check for any errors in the report. The review edit screen will be displayed
with the appropriate message(s).
o
Transmit: Send the report to the NO. The review edit screen will be displayed if any
errors/warnings are found. The report will not be sent to the NO if one or more errors
are found. However, if only warning(s) are found, you will be provided with a list of
the warnings and the "Continue to Transmit" option. The message, “Record has been
spooled successfully for transmission” is displayed when the report is ready for pickup by the NO.
o
Output: Display the report in a printable format.
o
Exit: Quit a Data Entry application. If the user is in ADD or UPDATE mode, a
prompt, “Any data that is not saved will be lost. Do you want to continue?” is
displayed. The user can click on the ‘OK’ button to exit data entry or click on the
‘Cancel’ button to continue with data entry. If you select “OK”, a prompt, “Are you
II-5
Data Entry
sure you want to exit?” is displayed. The user can click on the ‘OK’ button to exit out
of the application or click on the ‘Cancel’ button to continue with data entry.
The state of the action buttons varies according to the data entry process. For example,
Query, Add, Update, Transmit and Output buttons are disabled when you are updating
the report.
•
Header Section. Contains information identifying the report, such as:
o Title: Displays the full report title (example, ETA5159 Claims and Payment
Activities).
o Report for Period Ending: This date is always the last day of the report period.
o State: Displays your state.
o Region: Displays your Region.
o Creation Date: The date the report was created.
o Revision Date: The date the report was last updated.
o Transmit Date: The date the report was first sent to the NO.
•
Data Fields
The number and the names of the report's data fields vary by report. Please click on the
"Field Help" link for help information on each data field or refer to ET Handbook 401 for
detailed information. Data is entered or modified in each of the data field.
•
Field Help
Field Help is a link in the upper right corner of the application screen. It displays the help
information for the data field which is in focus.
•
Comments Field
Describe unusual fluctuations in this report, as compared to prior reports, that relate to
administrative, legal, or economic factors. Maximum size of the comments field is
approximately 150 words.
•
Last Value Saved
Last Value Saved is a checkbox that is displayed in the upper right corner of the
application screen only when you are updating the report. When the checkbox is checked,
you can browse through the report data fields to review the last saved values in the
II-6
Chapter 2
Database.
•
Navigation Bar
The Navigation Bar is displayed at the bottom of the application screen, which helps the
user to access one of the following:
o Home: Display the Applications Menu Page.
o Feedback: Display the feedback contact information.
o Help: Display the current application help.
•
Function Keys
You can navigate through these various sections of the Data Entry screen in several
ways:
o
Tab: Move cursor to the next field.
o
Arrow up/right: Move cursor to next field.
o
Arrow down/left: Move cursor to previous field.
o
[Alt]-S: Save the change(s).
o
[Alt]-C: Cancel the change(s).
o
[Alt]-V: Validate the report.
o
[Alt]-T: Transmit the report to the National Office (NO).
o
[Alt]-O: View, print, or save the report.
o
[Alt]-X: Exit the application.
II-7
Data Entry
Adding the Report Data
When a data entry screen appears, all numeric fields are defaulted to 0.
The Action Buttons, Query, Add, Update, Transmit, and Output are grayed out
o Replace the zeros with the correct values
o Validate the Report
o If errors are found, then correct the data
o If warnings are found, then review and correct data if necessary
o Save the Report
o Transmit the Report, if there are no errors.
o Exit the Application
Updating the Report Data
When a data entry screen appears, it will be filled with data that is currently stored in the
database.
The Action Buttons, Save and Cancel are grayed out
o You can either choose to Update, Validate, Transmit, or Output.
o Validate the Report
o If errors are found, then correct the data
o If warnings are found, then review and correct data if necessary
o Save the Report
o Transmit the Report
o Exit the Application
Data Entry
•
Report Fields:
To enter data in a field, you need to highlight it. It can be highlighted several ways:
o
o
o
•
Use the tab key to position the focus on a field.
Double-click on the field with the mouse button.
Press the Up/Down/Left/Right (↑↓←→) arrow keys to go through the fields.
Data Entry Field Help:
To get help about the information you need to enter in a specific data field, bring the focus
on that field and click on Field Help (located in the upper right corner of the screen). A help
screen is displayed, as shown in Figure 2.4.
II-8
Chapter 2
Figure 2.4 Help Screen
The help screen displays the database name, definition, data type, and the report edits of the
data entry field. At the bottom of the help screen there is a ‘Print’ button to print the help
and a ‘Top’ button to return to top of the scrolling help window.
•
Comments:
At the bottom of the data entry screen is a Comments text entry window, as shown in
Figure 2.5. This window enables you to enter or edit comments regarding a report.
Figure 2.5 Comments Screen
II-9
Data Entry
Validating the Report Data
The Validate option searches for errors and warnings in the currently displayed report. To
validate the data, click on the action button, Validate.
If there are any errors and/or warnings, a screen will be displayed listing them. The top
section of the screen displays the report’s table name, the state, and reporting date. The
middle section displays one or more of three types of errors — fatal errors, errors, and
warnings — and a description of them. Each type is described below:
•
Fatal errors: The system builds in safeguards to prevent fatal errors; nonetheless, the
system checks for them. Fatal errors will not allow a report to be saved. Example: If a
Michigan data entry user somehow entered Minnesota’s state abbreviation as the state
designation, a fatal error would occur.
•
Errors: These are generally math errors, but may also be impossible entries. Example:
Assume two fields are supposed to add to a third field. If the program checks the two
fields and finds they don’t add to the third field, this is an error.
Figure 2.6 List of Edit Errors
If there are errors, a message, “ERROR(S) exists. Record can be saved but cannot be
transmitted” appears on top of the screen, as shown in Figure 2.6.
II-10
Chapter 2
•
Warnings: Warnings occur when expected relationships between two or more items in a
report are not found. Example: The value in field c2 is usually less than the value in field
c1. Other edits compare the value of a field with:
o the value of the comparable field in the immediate prior period, and;
o the average value of the comparable fields for the same period in the previous three
years.
If there is a significant discrepancy, a message is generated.
Valid data generally pass these “reasonableness” tests, however, data can fail these tests.
When data fail an edit, a warning message appears, as shown in Figure 2.7.
Figure 2.7 List of Edit Warnings
When a warning message appears, check the numerical values. If the numbers are
correct, the report can still be sent to the NO.
Tip: If you send reports to the NO with warnings, an explanation in the Comments
Section will prevent unnecessary questioning of the data by the NO.
II-11
Data Entry
Report Output
The Output Action button allows you to view, print, or save the report. The output is
generated from the data that is saved in the database table. When you click on the Output
option, a report is displayed, as shown (partially) in Figure 2.8.
Figure 2.8 Report Output
The user can use the web browser File menu and choose:
o Print: To print the report
o Save As: To save the report
Tip: If you have added data or made changes to the report data, you should save the data
into the database before generating the output.
Use the Browser Back button to go back to the Data Entry screen. The user can exit the
application by closing the web browser.
II-12
Chapter 3
3 REPORT TIMELINESS
Accessing the Report Timeliness Application
The Report Timeliness application is a management tool that enables your state to keep track
of the timeliness status of reports submitted to the National Office. This application also
informs users which report(s) need to be entered and transmitted within selected time
periods.
To access the Report Timeliness application, choose the UIR option from the state
Application Menu. Choose the Report Timeliness menu option from the UIR menu as shown
in Figure 3.1.
Figure 3.1 UIR Menu
III-1
Report Timeliness
Report Timeliness Screen
The Report Timeliness query screen appears in a new window, as shown in Figure 3.2.
Figure 3.2 Report Timeliness Query Screen
The application query screen is comprised of four sections:
•
Query Fields
Query Fields allow users to select or enter the query parameters. All query input
parameters are validated for proper format and value. This application has the following
query fields:
o
Beginning/Ending DueDates, Beginning/Ending Period Ending Dates: Represents a
date range. Each report within UIR has a date identifier and is due within a fixed
time period. The Beginning Due Date / Beginning Period Ending Date sets the initial
time range for which the application will search and find reports which were
submitted promptly or late. In contrast, the Ending Due Date / Ending Period Ending
Date sets the ending time range for these same search criteria.
o
Report Name: This is a menu selection of the Report Names for all the required
reports submitted by the state workforce agencies. The default option is ‘All’.
III-2
Chapter 3
o
Report Option: Represents criteria for promptness. The options include the
following:
Missing: A report that has not been created, the system found no record.
Not Prompt: Displays timeliness information about report(s) within the range of
dates you specified that has been sent after the Report’s due date or that were
never sent. There are four status categories of reports which are not classified as
prompt:
1.
2.
3.
4.
Late, Sent - A report was sent late, after its due date.
Revised, Not Sent - A revised report was found, but has not been sent.
Not Sent - A report exists, but has not been sent, after its due date.
Missing - A report that has not been created, the system found no record.
Prompt: Displays timeliness information about report(s) due within the range of
dates you specified that have been sent on, or prior to, the report’s due date.
The default option is ‘Missing’.
•
Help Links
The query field names are the links to the respective field help. Clicking on the field
names will open a new window to view the information regarding the query field
name.
•
Action Buttons
The following buttons either process the user's query request or reset the query fields:
•
o
Submit Query: Processes the user’s query and generates the Report
Timeliness report for the selected report(s).
o
Clear Query: Resets all the fields to its default values.
Navigation Bar
The Navigation Bar displayed at the bottom of the application screen helps the user to
access one of the following:
o
Home: Display the applications menu page.
o
Feedback: Display the feedback contact information.
o
Help: Display the current application help
III-3
Report Timeliness
Report Timeliness Report Screen
When you click the Submit Query button after entering the query parameters, a report is
generated. A sample report is displayed in Figure 3.3.
Figure 3.3 Report Timeliness Report Screen
The user can use the browser File menu and choose:
•
Print: To print the report.
•
Save As: To save the report.
The user can exit the application by closing the web browser.
III-4
Chapter 4 1
4 MANAGE TRANSMITTAL
Accessing the Manage Transmittal Application
The Manage Transmittal application allows the state to send UIR reports from the state’s
database to the National Office (NO). The reports may contain warnings but must not
contain any errors. To transmit reports, you must belong to the approving official user group
(uidbapr).
To access the Manage Transmittal application, choose the UIR option from the state
Application Menu. Choose the Manage Transmittal menu option from the UIR menu, as
shown in Figure 4.1.
Figure 4.1 UIR Menu
IV-1
2Manage Transmittal
Manage Transmittal Utility Screen
The Transmittal Utility screen is displayed, as shown in Figure 4.2. It displays a list of all
reports that are available to be transmitted to the NO. The list includes new reports as well
as reports that have been revised after having been previously transmitted. Reports that have
been revised more than six months prior are automatically eliminated from this list.
Figure 4.2 Manage Transmittal Utility Screen
The application query screen is comprised of three sections:
•
Display Fields
The Transmittal Utility displays five columns:
o
Select: The radio buttons used to select the report.
IV-2
Chapter 4 3
o
Report Name: The name of the report that is available to be transmitted to the
NO.
o
Report Date: The date on which the report is due to the NO.
o
3rd Key: This is used to give a unique identity to reports that have multiple
reports/records within the same reporting period. While most reports require
only the state (first key) and date (second key) to make them unique, certain
reports have special features requiring an additional identifier - the third key to differentiate them from other reports. An example of a third key is banking
number for the ETA 8401 report.
o Status: The status of the transmission
•
New: A report has been created, but not transmitted to the NO.
Revised: The report has been revised since it was previously transmitted
to the NO. The revised report has not yet been transmitted.
Transmitted: The report has been successfully transmitted to the NO in
the current session.
Failed: An attempt was made in the current session to transmit the report
and the attempt failed.
Action Buttons
The following buttons either process the user's transmit request or reset the select
radio button:
•
o
Transmit: Transmit the report(s) to NO.
o
Reset: Resets the select radio button.
Navigation Bar
The Navigation Bar displayed at the bottom of the application screen helps the user to
access one of the following:
o
Home: Display the Applications Menu Page.
o
Feedback: Display the feedback contact information.
o
Help: Display the current application help.
IV-3
4Manage Transmittal
Transmitting Reports to the National Office
Select the report you want to send to the NO, and then click on the Transmit button. One of
the following three situations will occur.
Report with No Errors or Warnings
If the selected report does not have any errors or warnings, it will be successfully spooled
for transmission to the NO. Figure 4.3 shows an example of a successful spool for
transmission.
Figure 4.3 Successful Report Transmittal Screen
IV-4
Chapter 4 5
Report with Errors
If the selected report has any errors, then a list of edits will be displayed in a separate
window, as shown in Figure 4.4a.
Figure 4.4a List of Edits Screen
The List of Edits screen has the following links and buttons:
o Print: Sends the edits to the printer.
o Close: Closes the List of Edits window and places the user in Data Entry mode.
o Continue Transmittal: This option is not available if there are errors in the report.
o Cancel: Closes the List of Edits window and places the user in Data Entry mode.
If there are errors, upon closure of the List of Edits window, the data entry window of the
report, as shown in Figure 4.4b will be displayed so the user can use the Update button to
correct the error(s). Once the changes are made, choose the Save button to save the
corrected data to your state’s database. To transmit the corrected version of the report to
the NO, choose the Transmit button on the Data Entry screen. The system scans the
IV-5
6Manage Transmittal
report again for errors. If no errors or warnings are found, the report is successfully
spooled for transmission. For more details on data entry, see Chapter 2, Data Entry.
Figure 4.4b Report Data Entry Screen
Tip: If you do not wish to correct the errors at the moment, then click on the Exit button
to exit the Data Entry application. You will be returned to the Manage Transmittal
application.
IV-6
Chapter 4 7
Report with Warnings, but no Errors
If the selected report has warnings, but no errors, then the list of edits (warnings) will be
displayed in a separate window, as shown in Figure 4.5.
Figure 4.5 List of Edits Screen
The List of Edits screen has the following links and buttons:
o Print: Sends the edits to printer.
o Close: Closes the List of Edits window and places the user in Data Entry mode.
o Continue to Transmit: This option is available so you can transmit a report with
warnings to the NO without having to go back into Data Entry mode.
o Cancel: Closes the List of Edits window and returns the user in Data Entry mode.
The user can exit the application by closing the web browser.
IV-7
8Manage Transmittal
This page is intentionally left blank
IV-8
Chapter 5
5 ASCII LOAD
Accessing the ASCII Load Application
The purpose of the ASCII Load application is to allow a data file to be electronically
uploaded into the UIR system, thus eliminating the need to manually enter data. See
Appendix B for ASCII Load file specifications.
To access the ASCII Load application, choose the UIR option from the state Application
Menu. Choose the Load Report Data from ASCII File menu option from the UIR menu, as
shown in Figure 5.1.
Figure 5.1 UIRR Menu
V-1
ASCII Load
ASCII Load Utility Screen
The ASCII Load Utility screen appears in a new window, as shown in Figure 5.2. The
application automatically loads error-free data in UIR reports into the state's database from
ASCII files stored on the state’s Sun system or the user’s PC. This process eliminates the need
for extensive and time-consuming manual data entry.
Figure 5.2 ASCII Load Query Screen
The application screen has the following components:
•
Query Fields
The ASCII files can be loaded by using the following parameters:
o
Report Name: The name of the report whose data you want to enter into the
database. Enter a Report Name (example, ar218).
o
Report Date: The date of the report whose data you want to enter into the
database. Enter a Report Date (example, 06/30/2005 for a monthly report).
V-2
Chapter 5
•
o
File Name on Server: The full path name of the ASCII file (on the state’s Sun
system) containing the data of the report specified. Enter the data's path and file
name.
o
File Name on PC: The full path name of the ASCII file (on the state’s PC)
containing the data of the report specified. Enter the data's path and file name or
choose the Browse button to open a window which will allow you to browse
through your network drive and select the file.
Action Buttons
The query screen has the following buttons:
•
o
Load: Submits the user's request.
o
Clear: Resets all the fields.
Navigation Bar
The Navigation Bar displayed at the bottom of the application screen helps the user to
access one of the following:
o
Home: Display the Applications Menu Page.
o
Feedback: Display the feedback contact information.
o
Help: Display the current application help.
Enter the Report Name, Report Date, File Name, and then click on the Load button to
load the ASCII data. You have an option to load the file from a location on the Sun Unix
Server or the user’s PC. The data will be loaded to the state's database if it contains no
error(s). However, if the data contains one or more errors, a message will be displayed
and the data entry window of the report will be displayed. The Update option can be
then selected and corrections of error(s) can be made. For more details on updating the
report data, see Chapter 2, Data Entry.
The user can exit the application by closing the web browser.
V-3
ASCII Load
This page is intentionally left blank
V-4
Chapter 6
6 QUALITY REPORTS
Accessing Quality Reports Application
The automated benefits quality reports will allow states to store and electronically transmit
the results of quality reviews for the nonmonetary determinations process and lower
authority appeals.
Login to your Sun system using th eXceed software. Click on the UIS Application menu 2.0.
Then click on UI Required Reports (GUI Based) and choose Quality Reports option to access the
Quality Reports application.
Manual Load
When you choose the Manual Load option, you are required to:
type data in the skeleton fields using a Data Entry screen.
Run the Validation/Freeze module to check the validity of the sample and to freeze the
data in the sample.
Choose the Manual Load option. The Skeleton Data Entry screen is displayed, as shown in
Figure 6.1.
Figure 6.1 Skeleton Data Entry screen
VI-1
Quality Reports
The screen displays the following data fields:
Report Name: Choose to load from either the ar9056 Nonmonetary reports or from the
Report Date:
Action:
ar9057 Appeals reports.
Enter the date of the report whose data you want to enter into a database
(example: 03/31/1997).
Choose one of two options — Add New Records if your state does not extract
data from other systems, or Update Existing Records.
At the bottom of the Skeleton Data Entry screen are three Action Buttons — Ok, Exit, and Help.
Ok
Exit
Help
Displays a screen for the report you chose — ar9056 or ar9057 — so you can either
add data to a new report or update the data in an existing report. These options are
discussed below.
Exits the Manual Load Utility application.
Displays information about the Skeleton Data Entry screen.
VI-2
Chapter 6
Add Data to Nonmonetary Reports: When you choose Ok to add a Nonmonetary report, a
Skeleton Data Entry screen for Nonmonetary Determinations appears, as shown in Figure 6.2.
Figure 6.2 Add screen —Skeleton Data Entry Screen for Nonmonetary Determinations
To add a record, you must insert information into the proper data fields. To enter or edit data,
you must highlight a field by clicking on it with the mouse or using the keyboard to tab to it.
You must fill each data field consecutively. If you skip a field or leave it blank, you’ll receive
an error message.
When you finish entering data in the last field of a row, press “Z” to go to the first data field in
the next row. If you want to enter additional data after entering data displayed on the screen,
press “Z” on the last data field; an empty row appears for you to enter more data. Repeat this
step as often as desired.
VI-3
Quality Reports
To navigate through the fields, press the up/down (↑↓) arrows or the left/right (←→) arrows,
or drag the scrollbar (right side) with the mouse button or use the tab key.
The following information is required to enter data, or update data, in the reports:
Report Date
State
Case ID
Issue Code
W/C (Week Claimed)
Week Ending Date
Determination Date
Contains the ending date of the report period.
Your state’s two-letter abbreviation.
A maximum of five numbers (example: 00001,00002).
A two-character number.
Y[es] or N[o].
Week ending date of first affected week.
Date the nonmonetary determination was issued.
At the bottom of the screen are four Action Buttons — Save Data, Cancel, Delete row, and Help.
Save Data
Cancel
Delete row
Help
If the data is correct, it displays a message indicating that the data you added
or updated has been successfully saved to the database.
If the data is incorrect, a message window appears with a brief explanation of
the error. Click on OK to close the message window and return to the screen
to correct the error. Repeat this procedure with each error until all data is
correct.
Exits the current screen.
Deletes a row of skeleton data.
Displays information about the Nonmonetary Determination report screen.
VI-4
Chapter 6
Update Data in Nonmonetary Reports: When you choose Ok to update the data in one of the
Nonmonetary reports, a Skeleton Data Entry screen for Nonmonetary Determinations appears, as
shown in Figure 6.3.
Figure 6.3 Update screen — Skeleton Data Entry for Nonmonetary Determinations
The following data elements are required to update data:
Report Date
Contains the ending date of the report period.
State
Your state’s two-letter abbreviation.
Case ID
A maximum of five numbers (example: 00001,00002).
Issue Code
A two-character number.
W/C (Week Claimed) Y[es] or N[o].
Week Ending Date Week ending date of first affected week.
Determination Date Date the nonmonetary determination was issued.
VI-5
Quality Reports
At the bottom of the screen are four Action Buttons — Save Data, Cancel, Delete row, and Help.
Save Data
Cancel
Delete row
Help
If the data is correct, it displays a message indicating that the data you added
or updated has been successfully saved to the database.
If the data is incorrect, a message window appears with a brief explanation of
the error. Click on OK to close the message window and return to the screen.
to correct the error. Repeat this procedure with each error until all data is
correct.
Exits the current screen.
Deletes a row of skeleton data.
Displays information about the Nonmonetary Determination report screen.
VI-6
Chapter 6
Validate
When you load skeleton data manually, you need to validate the sample. To do this, choose the
Validation option in the Skeleton Load Menu. The Validate Skeleton Data screen appears, as
shown in Figure 6.4.
Figure 6.4 Validate/Freeze Skeleton Data screen
The screen displays three data fields:
Report Name:
Report Date:
Choose either the ar9056 Nonmonetary reports or the ar9057 Appeals
reports.
Enter the date of the report whose records you want to validate or freeze
(example: 12/31/2007).
At the bottom screen are three Action Buttons —Ok, Exit, and Help.
Ok
Exit
Help
Runs the sample validation program to compare the data in the skeleton fields
with permissible entries. If the sample data passes edits, the entries will be
saved.
Exits the current screen.
Displays brief information about the Validate Skeleton Data screen.
VI-7
Quality Reports
Accessing the Evaluation Entry Application
This application allows you to enter the results of each case evaluation into the sample records.
To access this application, choose the Evaluation Entry menu from the Quality Reports menu.
Two submenus appear:
9056 Nonmonetary Determinations Quality
9057 Lower Authority Appeals Quality
VI-8
Chapter 6
ETA 9056 - Nonmonetary Determinations Quality Data Collection Instrument
When you choose the 9056 Nonmonetary Determinations Quality option from the Evaluation
Entry Menu, the ETA 9056 - Nonmonetary Determinations Quality Data Collection Instrument
screen is displayed as shown (partially) in Figure 6.5. A message window also appears. To
close it, press Z or click on OK.
Figure 6.5 ETA 9056 – Nonmonetary Determinations Quality Data Collection Instrument
The screen displays the following data fields, some of which are required:
Report for Period Ending
State
Region
Creation Date
Revision Date
Transmit Date
This date will be the same as the report date you typed in the
previous screen.
Your state’s two letter abbreviation is displayed.
Your Region number is displayed .
Today’s date is displayed.
Today’s date is displayed.
This date remains blank until all data passes edits and the data
is actually transmitted.
VI-9
Quality Reports
Case ID
Issue Code
Example: 0001, 0002.
Example: 10.
To complete the case for transmittal, fill in the items that follow the data fields mentioned above.
When you do this, the system automatically assigns predetermined scores to each question.
When you’ve completed answering the questions, the system adds the total score and displays it
in the Total Points Scored field.
At the bottom of the screen is the Comments section, which enables you to enter any comments
about data fields where the quality reviewer’s response indicates a problem exists with an item
(example: item 21 is scored “I.” Begin your comment with the item number — 21 in this
example — followed by a brief comment, such as “Failed Minimum Reasonable Attempts
criteria.”
VI-10
Chapter 6
ETA 9057 - Lower Authority Appeals Quality
Instructions for the automated and manual downloading of information for the ETA 9057 are
identical to those for the ETA 9056 except that only three skeleton fields are used:
Case Identification Enter a maximum of five numbers (example: 00001, 00002) .
Decision Date
Enter the date the appeal decision was mailed.
Case Docket Number Example: A1234597
State Evaluation Score Sheet
When you choose the 9057 Lower Authority Appeals submenu option in the Evaluation
Entry Menu, the Score Sheet screen is displayed. This is partially shown below in Figure
6.6.
Figure 6.6 ETA 9057- Lower Authority Appeals Quality State Evaluation Score Sheet
The screen displays the following data fields, some of which are required:
Report [Date] for Period Ending The date must be the same as the report date in the
previous screen.
VI-11
Quality Reports
State
Region
Creation Date
Revision Date
Transmit Date
Case ID No.
Docket No.
Your state’s two-letter abbreviation is displayed.
Your Region number is displayed.
Today’s date is displayed.
Today’s date is displayed.
This date remains blank until all data passes edits
and the data is actually transmitted.
Enter a maximum of five digits (example: 00001,
00002).
Example: A1234597
After filling in this information, enter the 38 answers from the Data Collection Instrument.
At the bottom of the screen is the Comments section, which enables you to enter comments
about any unusual issue(s) about the case that was reviewed which may be useful in
interpreting how the evaluator scored or recorded the case on the Data Collection Instrument.
VI-12
Chapter 6
Transmit Quarterly Data
When the data in the reports/cases are validated, you can send them to the National Office.
When you select Transmit Reports from the Quarterly Reports menu. The Transmit Quarterly
Data screen appears, as shown in Figure 6.7.
Figure 6.7 Transmit Quarterly Data
The screen displays two data fields:
Report Name: Choose either the ar9056 Nonmonetary reports or the ar9057 Appeals
reports.
Enter the date of the cases whose data you want to send to the National
Office (example: 03/31/1997).
Report Date:
At the bottom of the screen are four Action Buttons — Transmit, Exit, and Help.
Transmit
Exit
Help
Transmit Report
Exits the current screen.
Displays information about the Transmit Quarterly Data screen.
VI-13
Quality Reports
Show Quarterly Scores
This option displays the SWA’S overall score for the quality of the review quarter’s
Nonmonetary Determination or Lower Authority Appeals. The system automatically calculates
this score after the report has been transmitted.
To display this screen, as shown in Figure 6.8, choose the Quarterly Score option from the
Quality Review menu.
Figure 6.8 Show Quarter Scores
The Show Quarter Scores screen displays two data fields:
Report Name: Choose either the ar9056 Nonmonetary Quality reports or the ar9057
Appeals Quality reports.
Enter the date of the report whose scores you want to query from the
database (example: 03/31/1997).
Report Date:
At the bottom of the screen are three Action Buttons — Show Score, Exit, and Help.
Show Score
Exit
Help
Displays a screen showing the scores for the date and report you chose, as
shown in Figures 6.9 and 6.10.
Exits the current screen.
Displays information about the Show Quarter Scores screen.
VI-14
Chapter 6
Figure 6.9 NonmonetaryDeterminationsQuarterly Scores
Figure 6.10 Lower Authority Appeals Quarterly Scores
VI-15
Quality Reports
This page is intentionally left blank
VI-16
Chapter 7
7 REPORTS
Accessing the Reports
The UI Reports application is designed to search the database for the data required for the UI
reports, while satisfying the query parameters entered and displaying the contents found in
the form of a formatted report.
The Reports menu option enables the state users to view the UI reports without having to use
the Data Entry application. Anyone who has access to the state application menu can view
the UI reports. To access the reports, choose the UIR option from the state Application
Menu. Choose the Reports menu option from the UIR menu, as shown in Figure 7.1. The
reports are divided into report categories.
Figure 7.1 UIRR - Reports Menu
VII-1
Reports
Report Query Screen
An example of a report query screen is shown in Figure 7.2.
Figure 7.2 Report Query Screen
The application query screen is comprised of four sections:
•
Query Fields
Query Fields allow the users to select or enter the query parameters. All the query input
parameters are validated for proper format and value. Below are some examples of the
query fields needed to generate a report:
o
Report Year: The Report Year is a query parameter which represents the year for
which the application will search and find records.
o
Report Quarter: The Report Quarter is a query parameter which represents the
quarter for which the application will search and find records.
o
Report Month: The Report Quarter is a query parameter which represents the
month for which the application will search and find records.
VII-2
Chapter 7
o
•
Report Week: The Report Quarter is a query parameter which represents the
week for which the application will search and find records.
Help Links
The query field names are the links to the respective field help files. Click on the field
names to view the information regarding the query field name.
•
Action Buttons
The following buttons either submit the user's query request to the application or clear
the selected query fields.
•
o
Submit Query: Processes the user’s query and generates the Report Timeliness
report for the selected report.
o
Clear Query: Resets all the fields.
Text Links
The text links displayed at the bottom of the application query screen help the user to
access additional actions:
o
Home: Display the applications menu page.
o
Feedback: Display the feedback contact information.
o
Help: Display the current application help.
VII-3
Reports
Report Output Screen
Clicking on the Submit Query button after entering the query parameters generates a report.
A sample report is displayed in Figure 7.3.
Figure 7.3 Report Output Screen
The user can use the browser File menu and choose:
•
Print: To print the report.
•
Save As: To save the report.
The user can exit the application by closing the web browser.
VII-4
Appendix A
APPENDIX A: Report Forms With Data Maps
Appendix A contains report forms on which cell names for data elements have been indicated.
This is useful when accessing data directly through Standard Query Language (SQL) or ACE
reports and when evaluating edit messages that refer to these cell designations.
Data tables for required reports generally contain some identical information on each record that
will not be specified on the Data Maps. Useful common data elements are:
Description Name
Description
Name
state FIPS
st
Last Day of the Report Period to Which the
Data Relate
rptdate
Date the Record was Created
crdate
Date the Record was Last Revised
revdate
Number of Times the Record was Revised
mods
Machine on Which the Record was Created or hostname
Last Revised
User ID of the Individual Who Created or Last user_id
Revised the Record
The statistical data items are stored using cell names c1 through cn where n is the highest
number required to report all data items. While most reports will have cell numbers in sequence
as displayed on the report form, reports that have been amended over time will not. When cells
have been combined, an alphabetic suffix might be used, example: c14a.
Each required report also has a comment table associated with it. These comment tables use the
same name as the associated data table but with a suffix of "cm" appended. These tables store
any information that was provided to explain unusual data or to report special information the
state wishes to provide or that was requested by the National Office.
A-1
Appendix A
TABLE ar191
ETA 191 STATEMENT OF EXPENDITURES & FINANCIAL ADJS OF FEDERAL
FUNDS FOR UC FOR UCFE-UCX
STATE
REGION
REPORT FOR PERIOD ENDING
st
g_states.region
rptdate
SECTION A: SUMMARY STATEMENT OF EXPENDITURES AND ADJUSTMENTS
UCFE
UCX
c1
c2
(a) Cancellations
c3
c4
(b) Restoration of Overpayments
c5
c6
(c) Other - Explain in Comments
c7
c8
3.
Total Assigned Expenditures
and Adjustments
(Items 1 and 2; these totals must match
the totals reported in Section B.)
c9
c10
4.
Expenditures and Adjustments
Not Assigned to Agencies:
(a) Penalties and Interest
c11
c12
(b) Other - Explain in Comment
c13
c14
5.
Total Expenditures and Adjustments
Not Assigned to Agencies
(Items 4a and 4b)
c15
c16
6.
Grand Total - All Expenditures
and Adjustments
(Items 3 and 5)
c17
c18
1.
Benefit Expenditures
2.
Adjustments Assigned to Agencies:
Comments:
A-2
Appendix A
TABLE ar191sb
ETA 191 STATEMENT OF EXPENDITURES & FINANCIAL ADJS OF FEDERAL
FUNDS FOR UC FOR UCFE-UCX
SECTION B: DETAILED STATEMENT OF EXPENDITURES AND ADJUSTMENTS BY FEDERAL
(CIVILIAN) AND MILITARY AGENCIES
Agency
Code
c1
Agency
Title
g_agency.agency_type
A-3
Expenditures and
Adjustments
UCFE
UCX
c2
c2
Appendix A
TABLE ar203
ETA 203 - CHARACTERISTICS OF THE INSURED UNEMPLOYED
STATE
REGION
REPORT FOR PERIOD ENDING
st
g_states.region
rptdate
SAMPLE/ POPULATION:
S
E
X
E
T
H
N
I
C
I
T
Y
R
A
C
E
A
G
E
I
N
D
U
S
T
R
Y
c1
Male
Female
INA
c2
c3
c4
Hispanic
or Latino
Not
Hispanic
or Latino
INA
c40
c41
c42
American
Indian
or Alaskan
Native
Asian
Black or
African
American
Native Hawaiian
or
Other Pacific
Islander
White
INA
c43
c44
c45
c46
c47
c48
< 22
22-24
25-34
35-44
45-54
55-59
60-64
c12
c13
c14
c15
c16
c17
c18
>=65
INA
c19
c20
Agriculture/
Forest/Fishing/
Hunting
Mining
Utilities
Construction
Manufacturing
Wholesale
Trade
Retail
Trade
c49
c50
c51
c52
c53
c54
c55
Real Estate,
Rental and
Leasing
Professional/
Scientific/
Technical
Services
Management
of
Companies
and
Enterprises
Administration and
Support/Waste
Management/
Remedial Services
Transportation
and
Warehouse
Information
Finance
and
Insurance
c56
c57
c58
c59
c60
c61
c62
Educational
Services
Healthcare
and Social
Assistance
Arts,
Entertainment
and Recreation
Accommodation
and Food
Services
Other Services
(except Public
Administration)
Public
Administration
INA
c63
c64
c65
c66
c67
c68
c69
A-4
Appendix A
TABLE ar203 (continued)
ETA 203 - CHARACTERISTICS OF THE INSURED UNEMPLOYED
O
C
C
U
P
A
T
I
O
N
Management
Business and
Financial
Operations
Computer
and Math
Architecture
and Engineering
Life, Physical
and Social
Sciences
Community and
Social Services
Legal
c70
c71
c72
c73
c74
c75
c76
Education,
Training
and Library
Arts, Design,
Entertainment
Sport and Media
Healthcare
Practitioner
and Technical
Healthcare
Support
Protective
Services
Food Preparation
and Serving
Related
Building and Grounds
Cleaning and
Maintenance
c77
c78
c79
c80
c81
c82
c83
Personal Care
and Services
Sales
and
Related
Office and
Administrative
Support
Farming,
Fishing
and Forestry
Construction
and
Extraction
Installation,
Maintenance
and Repair
Production
c84
c85
c86
c87
c88
c89
c90
Transportation
and Material
Moving
Military
Specific
INA
c91
c92
c93
Comments:
A-5
Appendix A
TABLE ar204
ETA 204 EXPERIENCE RATING
STATE
REGION
REPORT FOR PERIOD ENDING
st
g_states.region
rptdate
RATE YEAR ENDING
COMPUTATION DATE
RATING SYSTEM
c1
c2
c3
SECTION A. All SUBJECT ACCOUNTS: NUMBER & AMOUNTS OF TOTAL & TAXABLE PAYROLL
Number As Of
Payroll 12 Months Ending
c5
c4
Accounts
Total
Taxable
(1)
(2)
(3)
c7
c8
c10
c11
c14
Line No.
1.
2.
Taxable Accounts, Total
101
c6
a. Eligible
102
c9
b. Ineligible
103
c12
c13
Reimbursable Account
104
c15
c16
Subject Accounts (Positive Or Zero Balance)
201
c17
c18
c19
a. Eligible
202
c20
c21
c22
b. Ineligible
203
c23
c24
c25
Subject Accounts (Negative Balance)
204
c26
c27
c28
a. Eligible
205
c29
c30
c31
b. Ineligible
206
c32
c33
c34
RESERVE RATIO STATES ONLY:
3.
4.
SECTION B. SUMMARY OF BENEFITS PAID, CHARGED, AND NONCHARGED
5.
Total Benefits (Or Benefit Wages) Paid
During 12 Months Ending: c35
Line No.
Amount
301
c36
A-6
Appendix A
TABLE ar204 (cont’d)
ETA 204 EXPERIENCE RATING
6.
7.
Taxable Employer Accounts
302
c37
a. Charged
303
c38
1. Active
304
c39
2. Inactive
305
c40
b. Noncharged
306
c41
Reimbursable Employer Accounts
307
c42
a. Charged
308
c43
b. Noncharged
309
c44
Comments:
A-7
Appendix A
TABLE ar204b
ETA204, EXPERIENCE RATING REPORT
SECTION C: BENEFIT RATIO METHOD OF TAXATION
Experience Factor
More
Than
Equal to or Less Than
Average
Tax Rate
(1)
Number
of
Accounts
(2)
Total
Payroll
(000)
(3)
Taxable
payroll
(000)
(4)
Benefits
Charged
(000)
(5)
Est. Contributions
(000)
(6)
c4
c5
c6
c7
ELIGIBLE – REGULARLY RATED BY FACTOR
c1
0
0.1
0.2
0.3
0.4
0.5
0.6
0.7
0.8
0.9
1
1.1
1.2
1.3
1.4
1.5
1.6
1.7
1.8
1.9
2
2.1
2.2
2.3
2.4
2.5
2.6
2.7
2.8
2.9
3
3.1
3.2
3.3
3.4
3.5
3.6
3.7
3.8
3.9
4
4.1
c2
c3
0.1
0.2
0.3
0.4
0.5
0.6
0.7
0.8
0.9
1
1.1
1.2
1.3
1.4
1.5
1.6
1.7
1.8
1.9
2
2.1
2.2
2.3
2.4
2.5
2.6
2.7
2.8
2.9
3
3.1
3.2
3.3
3.4
3.5
3.6
3.7
3.8
3.9
4
4.1
4.2
A-8
Appendix A
TABLE ar204b (cont’d)
ETA204, EXPERIENCE RATING REPORT
SECTION C: BENEFIT RATIO METHOD OF TAXATION
4.2
4.3
4.4
4.5
4.6
4.7
4.8
4.9
5.0
5.1
5.2
5.3
5.4
5.5
5.6
5.7
5.8
5.9
6
6.1
6.2
6.3
6.4
6.5
6.6
6.7
6.8
6.9
7
7.1
4.3
4.4
4.5
4.6
4.7
4.8
4.9
5.0
5.1
5.2
5.3
5.4
5.5
5.6
5.7
5.8
5.9
6
6.1
6.2
6.3
6.4
6.5
6.6
6.7
6.8
6.9
7
7.1
7.2
7.2
7.3
7.3
7.4
7.5
7.6
7.7
7.8
7.9
8
8.5
9
9.5
10
10.5
11
11.5
12
7.4
7.5
7.6
7.7
7.8
7.9
8
8.5
9
9.5
10
10.5
11
11.5
12
12.5
12.5
13
13
13.5
14
14.5
15
+995
+996
+997
+998
+999
13.5
14
14.5
15
∞
Subtotal Eligible Regularly Rated
Eligible Special Rate
Total Eligible
Total Ineligible
Total All Subject Accounts
A-9
Appendix A
TABLE ar204r
ETA204, EXPERIENCE RATING REPORT
SECTION C: RESERVE RATIO METHOD OF TAXATION
Experience Factor
More Than
Equal to or Less Than
Average Tax Rate
(1)
Number of
Accounts
(2)
Total
Payroll
(000)
(3)
Taxable
payroll
(000)
(4)
Benefits
Charged
(000)
(5)
Est. Contributions
(000)
(6)
c3
c4
c5
c6
c7
ELIGIBLE – REGULARLY RATED BY FACTOR
c1
c2
-999
-80
-80
-60
-40
-20
-19
-18
-60
-40
-20
-19
-18
-17
-17
-16
-16
-15
-14
-13
-12
-11
-10
-9
-8
-7
-6
-5
-4.5
-4
-3.5
-3
-2.5
-2
-1.5
-1
-.0.5
0
0.5
1
1.5
2
2.5
3
3.5
4
4.5
5
5.5
6
6.5
7
7.5
8
8.5
9
-15
-14
-13
-12
-11
-10
-9
-8
-7
-6
-5
-4.5
-4
-3.5
-3
-2.5
-2
-1.5
-1
-0.5
0
0.5
1
1.5
2
2.5
3
3.5
4
4.5
5
5.5
6
6.5
7
7.5
8
8.5
9
9.5
A-10
Appendix A
TABLE ar204r
ETA204, EXPERIENCE RATING REPORT
SECTION C: RESERVE RATIO METHOD OF TAXATION
9.5
10
10.5
11
11.5
12
12.5
13
13.5
14
14.5
15
16
17
18
19
20
25
30
35
40
45
10
10.5
11
11.5
12
12.5
13
13.5
14
14.5
15
16
17
18
19
20
25
30
35
40
45
∞
+995
Subtotal Eligible
Regularly Rated
+996
Eligible Special Rate
+997
Total Eligible
+998
Total Ineligible
+999
Total All Subject
Accounts
A-11
Appendix A
TABLE arertx (ar205)
ETA 205 - AVERAGE EMPLOYER CONTRIBUTION RATES
STATE
REGION
REPORT FOR PERIOD ENDING
st
g_states.region
rptdate
Current Year
Prior Year
2nd Prior Year
Taxable
Total
Taxable
Total
Taxable
Total
c1
c2
prior_yr.c1
prior_yr.c2
2nd_prior_yr.c1
2nd_prior_yr.c2
Comments
A−12
Appendix A
TABLE ar207
ETA 207 – NONMONETARY DETERMINATION ACTIVITIES
STATE:
REGION:
REPORT FOR PERIOD ENDING:
st
g_states.region
rptdate
SECTION A. DETERMINATIONS, REDETERMINATIONS and DENIALS
Single Claimant Totals
Total
Determinations
and
Redeterminations
Line
No.
(1)
Item
Multi-Claimant Totals
Total
Total
MultiRedeterm- MultiTotal
Labor claimant
Determinations
inations claimant Dispute
Other
(2)
(3)
(4)
(5)
(6)
State Determinations
UI Denials
101
c1
c2
c3
c4
c5
c6
102
c7
c8
c9
c10
c11
c12
UCFE Determinations
No UI Denials
103
c13
104
c14
UCX Determinations
Only Denials
105
c15
106
c16
SECTION B. DETERMINATIONS INVOLVING SEPARATION ISSUES, SINGLE-CLAIMANT
Line
No.
Item
Total
Separation
Issues
Voluntary
Leaving
Discharge
Other
(7)
(8)
(9)
(10)
State
UI
Determinations
201
c17
c18
c19
c20
Denials
202
c21
c22
c23
c24
UCFE
No UI
Determinations
203
c25
c26
c27
c28
Denials
204
c29
c30
c31
c32
SECTION C. DETERMINATIONS INVOLVING NONSEPARATION ISSUES
Item
State Determinations
UI Denials
Total
Able,
Reporting
Other
Nonsep- Available, Disqualifying/ Refusal of Requirement Refusal (Aliens,
aration Actively
Deductible
Suitable Call-ins and Profiling Athlete
Income
Work
Referrals School)
Issues
Seeking
Other
Line
No.
(11)
(12)
(13)
(14)
(15)
(16)
(17)
301
c33
c34
c35
c36
c37
c45
c38
302
c39
c40
c41
c42
c43
c46
c44
A−13
Appendix A
TABLE ae207
ETA 207 - NONMONETARY DETERMINATION ACTIVITY (EB)
STATE
REGION
REPORT FOR PERIOD ENDING
st
g_states.region
rptdate
SECTION A. DETERMINATIONS, REDETERMINATIONS AND DENIALS
Single-Claimant Totals
Line
No.
Total
Determinations and
Redeterminations
(1)
Determinations
101
c1
Denials
102
c2
UCFE Determinations
No UI
Denials
103
c3
104
c4
Determinations
105
c5
Denials
106
c6
Item
State
UI
UCX
No UI
SECTION B. DETERMINATIONS INVOLVING SEPARATION ISSUES, SINGLE-CLAIMANT
State
UI
Item
Line
No.
Total
Separation
Issues
(7)
Voluntary
Leaving
(8)
Discharge
for
Misconduct
(9)
Other
(10)
Determinations
201
c7
c8
c9
c10
Denials
202
c11
c12
c13
c14
SECTION C. DETERMINATIONS INVOLVING NONSEPARATION ISSUES, SINGLE-CLAIMANT
Item
State Determinations
UI
Denials
Line
No.
Total
Nonseparation
Issues
(11)
Able,
Available,
Actively
Seeking
(12)
Refusal of
Suitable
Work
(14)
Other
(aliens,
athletes,
school)
(16)
301
c15
c16
c17
c18
302
c19
c20
c21
c22
Comments:
A−14
Appendix A
TABLE at207
ETA 207 - NONMONETARY DETERMINATION ACTIVITY (TEUC)
STATE
REGION
REPORT FOR PERIOD ENDING
st
g_states.region
rptdate
SECTION A. DETERMINATIONS, REDETERMINATIONS AND DENIALS
Single-Claimant Totals
Item
Line
No.
Total Determinations and Redeterminations
(1)
State
UI
Determinations
101
c1
Denials
102
c2
UCFE
No UI
Determinations
103
c3
Denials
104
c4
UCX
No UI
Determinations
105
c5
Denials
106
c6
SECTION B. DETERMINATIONS INVOLVING SEPARATION ISSUES, SINGLE-CLAIMANT
State
UI
Item
Line
No.
Total
Separation
Issues
(7)
Voluntary
Leaving
(8)
Discharge
for
Misconduct
(9)
Other
(10)
Determinations
201
c7
c8
c9
c10
Denials
202
c11
c12
c13
c14
SECTION C. DETERMINATIONS INVOLVING NONSEPARATION ISSUES, SINGLE-CLAIMANT
Line
No.
Total
Nonseparation
Issues
(11)
Able,
Available,
Actively
Seeking
(12)
Refusal of
Suitable
Work
(14)
Other
(aliens,
athletes,
school)
(16)
Determinations
301
c15
c16
c17
c18
Denials
302
c19
c20
c21
c22
Item
State
UI
Comments:
A−15
Appendix A
TABLE ar218
ETA 218 BENEFIT RIGHTS AND EXPERIENCE
STATE:
REGION:
REPORT FOR PERIOD ENDING:
st
g_states.region
rptdate
SECTION A. MONETARY DETERMINATIONS
NUMBER OF CLAIMANTS ESTABLISHING
BENEFIT YEARS
DETERMINATIONS
LINE
NO.
Total
(1)
Insufficient
Wage
Credits
(2)
100
c1
c2
Sufficient
Wage
Credits
(3)
c3
Total
(4)
Maximum
Weekly
Benefit
(5)
Maximum
Benefit and
Duration
(6)
c4
c5
c6
SECTION B. POTENTIAL DURATION FOR DETERMINATIONS ESTABLISHING BENEFIT YEARS
AND ACTUAL DURATION FOR CLAIMANTS WHO RECEIVED FINAL PAYMENTS
NUMBER BY WEEKS OF DURATION
LINE
NO.
ITEM
101
102
Total
(7)
Less 10
Weeks
(8)
10-14
Weeks
(9)
15-19
Weeks
(10)
20-21
Weeks
(11)
22-23
Weeks
(12)
24-25
Weeks
(13)
Potential
c9
c10
c11
c12
c13
c14
c15
Actual
c16
c17
c18
c19
c20
c21
c22
NUMBER BY WEEKS OF DURATION
LINE
NO.
Number at
34WKS& Maximum
Duration
Over
(19)
(18)
Average
Weeks
Duration
(20)
ITEM
26-27
Weeks
(14)
28-29
Weeks
(15)
30-31
Weeks
(16)
32-33
Weeks
(17)
103
Potential
c23
c24
c25
c26
c27
c28
c29
104
Actual
c30
c31
c32
c33
c34
c35
c36
Comments:
A−16
Appendix A
TABLE ae218
ETA 218 BENEFIT RIGHTS AND EXPERIENCE (EB)
STATE:
REGION:
st
REPORT FOR PERIOD ENDING:
g_states.region
rptdate
SECTION A. MONETARY DETERMINATIONS
DETERMINATIONS
TOTAL
WITH INSUFFICIENT
WAGE CREDITS
WITH SUFFICIENT
WAGE CREDITS
c1
c2
c3
A−17
Appendix A
TABLE ac218
ETA 218 BENEFIT RIGHTS AND EXPERIENCE (EUC)
STATE:
REGION:
st
REPORT FOR PERIOD ENDING:
g_states.region
rptdate
SECTION A. MONETARY DETERMINATIONS
DETERMINATIONS
TOTAL
WITH INSUFFICIENT
WAGE CREDITS
WITH SUFFICIENT
WAGE CREDITS
c1
c2
c3
A−18
Appendix A
TABLE ar227
ETA 227 OVERPAYMENT DETECTION/RECOVERY
STATE:
REGION:
REPORT FOR PERIOD ENDING:
st
g_states.region
rptdate
SECTION A. OVERPAYMENTS ESTABLISHED - CAUSES
Number of Cases
Number of
Schemes
(1)
Dollar Amounts
UI
(2)
UCFE/UCX
(3)
UI
(4)
UCFE/UCX
(5)
c1
c2
c3
c4
c184
c185
c186
c187
103
c27
c28
c29
c30
Reversals
104
c5
c6
c7
c8
SWA Errors
105
c9
c10
c11
c12
Employer Errors
106
c13
c14
c15
c16
Claimant Errors
107
c17
c18
c19
c20
Other
108
c23
c24
c25
c26
c21
c22
c33
c34
Cause
Fraud - Total
Line No.
101
Multi Claimant Schemes
Nonfraud - Total
c183
102
Penalty
109
Total - Fraud, Nonfraud and Penalty
110
c31
c32
SECTION B. OVERPAYMENTS ESTABLISHED - METHODS OF DETECTION
Method
Controllable - Total
Line No.
Number of
Cases
Investigated
(6)
201
Fraud
Nonfraud
Number of
Cases
(7)
Dollars
(8)
Number of
Cases
(9)
Dollars
(10)
c188
c189
c190
c191
Wage/Benefit Crossmatch
202
c75
c76
c77
c78
c79
IB Crossmatch
203
c159
c160
c161
c162
c163
New Hires Systems
204
c192
c193
c194
c195
c196
Multi-Claimant Scheme Systems
205
c164
c165
c166
Special Project
206
c197
c198
c199
c200
c201
Other
207
c116
c117
c118
c119
A−19
Appendix A
TABLE ar227 (cont’d)
ETA 227 OVERPAYMENT DETECTION/RECOVERY
Noncontrollable - Total
208
c202
c203
c204
c205
Total - Controllable and Noncontrollable
209
c131
c132
c133
c134
SECTION C. RECOVERY/RECONCILIATION
Dollar Amount
Fraud
Item
Nonfraud
Line No.
UI(11)
UCFE/UCX(12)
UI(13)
UCFE/UCX(14)
Outstanding at Beginning of Period
301
c35
c36
c37
c38
Recovered - Total
302
c206
c207
c208
c209
Cash
303
c39
c40
c41
c42
Benefit Offset
304
c43
c44
c45
c46
State Income Tax Offset
305
c210
c211
c212
c213
By Other States
306
c214
c215
c216
c217
Other
307
c218
c219
c220
c221
c49
c50
Waived
308
Written-Off
309
c55
c56
c57
c58
Additions
310
c59
c60
c61
c62
Subtractions
311
c67
c68
c69
c70
Receivables Removed at End of Period
312
c222
c223
c224
c225
Outstanding at End of Period
313
c71
c72
c73
c74
Recovered for Other States
321
c230
c231
c232
c233
SECTION D. CRIMINAL/CIVIL ACTIONS
Item
State/Local Courts
Line No.
UI
(15)
UCFE/UCX
(16)
Federal
(OIG)
(17)
Number of Fraud Cases Pending Prosecution at Beginning of Period
401
c135
c136
c137
Number of Fraud Cases Referred for Prosecution During Period
402
c138
c139
c138
A−20
Appendix A
TABLE ar227 (cont’d)
ETA 227 OVERPAYMENT DETECTION/RECOVERY
Number of Cases Prosecution Refused
403
c141
c142
c143
Number of Convictions Obtained
404
c144
c145
c146
Number of Cases Referred for Civil Action
405
c147
c148
Number of Civil Actions Obtained
406
c149
c150
SECTION E. AGING OF BENEFIT OVERPAYMENT ACCOUNTS
Dollar Amounts
Accounts Receivable
Line No.
UI(18)
UCFE/UCX(19)
90 days or less
501
c169
c170
91 - 180 days
502
c171
c172
181 - 270 days
503
c173
c174
271 - 360 days
504
c175
c176
361 - 450 days
505
c177
c178
451 days or more
506
c179
c180
Total Accounts Receivable
507
c181
c182
Comments:
A−21
Appendix A
TABLE ac227
ETA 227 OVERPAYMENT DETECTION/RECOVERY (EUC)
(EUC PROGRAM IS NO LONGER OPERATIONAL BUT HISTORICAL DATA IS AVAILABLE)
State:
Region Code:
Report for Period Ended:
st
g_states.region
rptdate
SECTION A: NUMBER AND AMOUNTS OF OVERPAYMENTS ESTABLISHED
Ln. No.
Item
Total Fraud overpayments
101
Reversals (JAVA)
102
SESA Errors
103
Nonfraud
Employer Errors
104
Overpayments
Claimant Errors
105
Admin. Penalty
106
Other
107
Total Nonfraud Overpayments
108
Total Fraud & Nonfraud Overpayments
109
Number of Cases
Dollar Amounts
UI
(1)
UCFE/X
(2)
UI
(3)
UCFE/X
(4)
c1
c2
c3
c4
c5
c6
c7
c8
SECTION B. RECONCILIATION OF OVERPAYMENT ACTIVITIES
Number of Cases
Item
Outstand.
Beg.
Recover.
Cash
Recover.
Off.
Waived
Ln.
No.
Fraud
UI
(5)
Dollar Amounts
Nonfraud
FE/X
(6)
FE/X
(10)
UI
(11)
FE/X
(12)
201
c9
c10
c11
c12
202
c13
c14
c15
c16
203
c17
c18
c19
c20
c23
c24
c22
c27
c28
c30
c31
c32
c33
c34
c35
c36
c41
c42
c43
c44
208
c45
c46
c47
c48
209
c49
c50
c51
c52
210
c53
c54
c55
c56
205
Additions
206
Subtractions
Outstand.
End.
Allow
Doubt.
Collectable
207
c37
c26
c21
c29
Written Off
c25
FE/X
(8)
Nonfraud
UI
(9)
204
UI
(7)
Fraud
c38
c39
c40
Comments:
A−22
Appendix A
TABLE at227
ETA 227 - OVERPAYMENT DETECTION AND RECOVERY (TEUC)
STATE
REGION
REPORT FOR PERIOD ENDING
st
g_states.region
rptdate
SECTION A. OVERPAYMENTS ESTABLISHED - CAUSES
Line
No.
Number of Cases
Number of
Schemes
(1)
Dollar Amounts
UI
(2)
UCFE/UCX
(3)
UI
(4)
UCFE/UCX
(5)
c1
c2
c3
c4
c184
c185
c186
c187
103
c27
c28
c29
c30
Reversals
104
c5
c6
c7
c8
SWA Errors
105
c9
c10
c11
c12
Employer Errors
106
c13
c14
c15
c16
Claimant Errors
107
c17
c18
c19
c20
Other
108
c23
c24
c25
c26
c21
c22
c33
c34
Cause
Fraud - Total
101
Multi Claimant Schemes
c183
102
Nonfraud - Total
Penalty
109
Total - Fraud, Nonfraud and Penalty
110
c31
c32
SECTION B. OVERPAYMENTS ESTABLISHED - METHODS OF DETECTION
Method
Controllable - Total
Line No.
Number of
Cases
Investigated
(6)
201
Fraud
Nonfraud
Number of
Cases
(7)
Dollars
(8)
Number of
Cases
(9)
Dollars
(10)
c188
c189
c190
c191
Wage/Benefit Crossmatch
202
c75
c76
c77
c78
c79
IB Crossmatch
203
c159
c160
c161
c162
c163
New Hires Systems
204
c192
c193
c194
c195
c196
Multi-Claimant Scheme
Systems
205
c164
c165
c166
Special Project
206
c197
c198
c199
c200
c201
Other
207
c116
c117
c118
c119
Noncontrollable - Total
208
c202
c203
c204
c205
Total - Controllable and
Noncontrollable
209
c131
c132
c133
c134
A−23
Appendix A
TABLE at227 (cont’d)
ETA 227 - OVERPAYMENT DETECTION AND RECOVERY (TEUC)
SECTION C. RECOVERY/RECONCILIATION
Dollar Amounts
Fraud
Item
Line No.
Nonfraud
UI(11)
UCFE/UCX(12)
UI(13)
UCFE/UCX(14)
Outstanding Beginning Period
301
c35
c36
c37
c38
Recovered - Total
302
c206
c207
c208
c209
Cash
303
c39
c40
c41
c42
Benefit Offset
304
c43
c44
c45
c46
State Income Tax Offset
305
c210
c211
c212
c213
By Other States
306
c214
c215
c216
c217
Other
307
c218
c219
c220
c221
c49
c50
Outstanding Beginning Period
308
Recovered - Total
309
c55
c56
c57
c58
Additions
310
c59
c60
c61
c62
Subtractions
311
c67
c68
c69
c70
Receivables Removed End Period
312
c222
c223
c224
c225
Outstanding End Period
313
c71
c72
c73
c74
Recovered for Other States
321
c230
c231
c232
c233
SECTION D. CRIMINAL/CIVIL ACTIONS
State/Local Courts
Item
Line No.
UI(15)
UCFE/UCX(16)
Federal(OIG)(17)
Fraud Cases Pending Prosecution Beginning Period
401
c135
c136
c137
Fraud Cases Referred Prosecution During Period
402
c138
c139
c138
Number Cases Prosecution Refused
403
c141
c142
c143
Number Convictions Obtained
404
c144
c145
c146
Number Cases Referred for Civil Actions
405
c147
c148
Number Civil Actions Obtained
406
c149
c150
A−24
Appendix A
TABLE at227 (cont’d)
ETA 227 - OVERPAYMENT DETECTION AND RECOVERY (TEUC)
SECTION E. AGING OF BENEFIT OVERPAYMENT ACCOUNTS
Dollar Amounts
Accounts Receivable
Line No.
UI
UCFE/UCX
(18)
(19)
90 days or less
501
c169
c170
91 - 180 days
502
c171
c172
181 - 270 days
503
c173
c174
271 - 360 days
504
c175
c176
361 - 450 days
505
c177
c178
451 days or more
506
c179
c180
Total Accounts Receivable
507
c181
c182
A−25
Appendix A
TABLE ar2112
ETA 2112 UI FINANCIAL TRANSACTION SUMMARY
STATE:
REGION:
REPORT FOR PERIOD ENDING:
st
g_states.region
rptdate
ITEM
LINE
NO
NET TOTALS
(Sum of Cols.
D, E & F)
CLEARING
ACCOUNT
UNEMPLOYMENT
TRUST FUND
ACCOUNT
BENEFIT
PAYMENT
ACCOUNT
A
B
C
D
E
F
01
c1
c2
c3
c4
Total Deposits
10
c5
c6
c7
c8
Net UI Contributions
11
c9
c10
Penalty/Interest
12
c11
c12
U.S. Treasury Interest Credits
13
c13
Title IX Amortization
14
c15
Title IX Distribution
15
c90
c91
Intra-Account Transfer
16
c17
c19
c20
Interstate Benefits
17
c21
c23
c24
UCX Advances/Reimbursements
18
c25
Reimb Local Govt/Indian Tribes
19
c27
c28
Reimbursements State Govt
20
c29
c30
Reimbursements Non-profit
21
c31
c32
Federal Share (EB)
22
c33
c34
Fed Emergency Compensation
23
c35
c36
UCFE Advances/Reimbursements
24
c37
c38
Other Sources #1
25
c39
c40
c41
c42
Other Sources #2
26
c43
c44
c45
c46
Other Sources #3
27
c104
c105
c106
c107
Other Sources #4
28
c108
c109
c110
c111
Other Sources #5
29
c112
c113
c114
c115
c48
c49
c50
Balance Forward
DEPOSITS
c14
c16
c22
c26
DISBURSEMENTS
Total Disbursements
30
c47
Net UI Benefits
31
c51
c52
Net State Share (EB)
32
c53
c54
A−26
Appendix A
TABLE ar2112 (cont’d)
ETA 2112 UI FINANCIAL TRANSACTION SUMMARY
Reimb. Local Govt/Indian Tribes
33
c55
c92
c56
Reimbursements State Govt
34
c57
c93
c58
Reimbursements Non-profit
35
c59
c94
c60
UCX Net Payments
36
c61
c62
Federal Share (Regular)
37
c63
c64
Federal Share (EB)
38
c65
c66
FSC Activity
39
c67
c68
EUC Activity
40
c98
c99
TEUC Activity
41
c100
c101
Fed Emergency Compensation
42
c102
c103
Interstate Benefits
43
c69
c89
Title IX (Reed)
44
c71
c72
To Special Funds
45
c73
UCFE Net Payments
46
c75
Intra-Account Transfer
47
c77
c78
c79
Other (Explain)
48
c81
c82
c83
c84
Balance Close Month
49
c85
c86
c87
c88
50
c95
c96
c97
c70
c74
c76
OTHER INFORMATION
Withholding
Comments:
A−27
Appendix A
TABLE ac2112
ETA 2112 UI FINANCIAL TRANSACTION SUMMARY (EUC)
STATE
REGION
REPORT FOR PERIOD ENDING
Alaska
06
05/31/2005
Benefits Paid for Initials Filed on or Before 7-4-1992
1.
Regular
c1
2.
UCFE
c2
3.
UCX
c3
4.
Other
c4
Benefits Paid for Initials Filed From 7-4-1992 Through 3-6-1993
5.
c5
Total
Benefits Paid for Initials Filed From 3-7-1993 Through 10-2-1993
6.
c6
Total
Benefits Paid for Initials Filed After 10-2-1993
7.
c7
Total
A−28
Appendix A
TABLE ar538
ETA 538 – ADVANCE WEEKLY INITIAL AND CONTINUED CLAIMS REPORT
STATE
REGION
REPORT FOR PERIOD ENDING
st
g_states.region
rptdate
Week Number:
c1
Reflected Week Ending:
c2
Initial Claims, Intrastate and Interstate Taken Directly:
c3
Intrastate Continued Weeks Claimed:
c4
Interstate Liable Continued Weeks Claimed:
c5
Comments:
A−29
Appendix A
TABLE ar539
ETA 539 - CLAIMS AND EXTENDED BENEFITS DATA
STATE
REGION
REPORT FOR PERIOD ENDING
st
g_states.region
rptdate
Week Number:
c1
Reflected Week Ending:
c2
IC:
c3
FIC:
c4
XIC:
c5
WSIC:
c6
WSEIC:
c7
CW:
c8
FCW:
c9
XCW:
c10
WSCW:
c11
WSECW:
c12
EBT:
c13
EBUI:
c14
ABT:
c15
ABUI:
c16
AT:
c17
CE:
c18
R:
c19
AR:
c20
P:
c21
STATUS:
c22
STATUS CHANGE DATE:
Comments:
A−30
c23
Appendix A
TABLE ar581
ETA 581 - CONTRIBUTION OPERATIONS
STATE
REGION
REPORT FOR PERIOD ENDING
st
g_states.region
rptdate
End Quarter Employers
Employer
Count
Line
101
Delinquency
Cutoff Date
Total Number Wage
Items Received
(3)
(4)
(5)
c3
c4
c14
Contributory
Reimbursement
Total
(1)
(2)
c1
c2
Contributory Employers
Employer
Reports for
Preceding
Quarters
Status
Determinations
201
301
Reimbursing Employers
Filing
Timely
Secured
Resolved
Filing
Timely
Secured
Resolved
(6)
(7)
(8)
(9)
(10)
(11)
c53
c54
c55
c56
c57
c58
Number Outstanding Quarters
Prior to Report Quarter
Total Estimated
Contributions Due
(12)
(13)
c13a
c13b
Newly Established Employers
Successor Employers
Number
Time
Lapse
<=90
Time
Lapse
<=180
Number
Time
Lapse
<=90
Time
Lapse
<=180
(14)
(15)
(16)
(17)
(18)
(19)
c11
c61
c62
c68
c59
c60
Declared
Uncollectible
Removed
End
Period
Total
End
Period
Inactivations/Terminations
(20)
c63
Total
Beginning
Period
Contributory
Employers
Receivables
401
Determined
Liquidated
Receivable
(21)
(22)
(23)
(24)
(25)
(26)
c14a
c15
c16
c17
c64
c18
Number Employers
Owing Receivables in (26)
(27)
c19
Age of
Contributory
Receivables
402
6
Months
or Less
9 Months
12 Months
15 Months
Over 15
Months
(28)
(29)
(30)
(31)
(32)
c43
c44
c45
c46
c47
A−31
Appendix A
TABLE ar581 (cont’d)
ETA 581 - CONTRIBUTION OPERATIONS
Reimbursing
Employers
Receivables
403
Total
Beginning
Period
Determined
Receivable
Liquidated
Declared
Uncollectible
Removed
End
Period
Total
End
Period
(33)
(34)
(35)
(36)
(37)
(38)
c19a
c20
c21
c22
c65
c23
Number Employers
Owing Receivables in (38)
(39)
c24
Age of
Reimbursing
Receivables
404
6 Months
or Less
9 Months
12 Months
15 Months
Over 15
Months
(40)
(41)
(42)
(43)
(44)
c48
c49
c50
c51
c52
Number of Audits
501
Large
Employers
Change Audits
Total Audits
Calendar
Quarters Audited
(45)
(46)
(47)
(48)
c25a
c28a
c25b
c26a
Hours Spent
Auditing
Employee Miscellaneous Independent Contributions
Total Wages Audited
Audit
Activity
Pre-Audit
Post-Audit
(49)
(50)
(51)
(52)
c66
c67
c29a
c69
Amount Underreported
502
Total Wages
Taxable Wages
Contributions
(53)
(54)
(55)
c37a
c38a
c39a
Amount Overreported
Total Wages
Taxable Wages
Contributions
(56)
(57)
(58)
c40a
c41a
c42a
Comments:
A−32
Appendix A
TABLE ar586
ETA 586 - INTERSTATE ARRANGEMENT-EMPLOYMENT AND WAGES
STATE
REGION
REPORT FOR PERIOD ENDING
st
g_states.region
rptdate
SECTION A. CLAIMS AND PAYMENT ACTIVITIES
Persons
Establishing
Benefit
Years
(2)
No. Combined
Wage
Claims
Withdrawn
(3)
Weeks
Compensated
(4)
Benefits
Paid
(5)
Prior Weeks
Compensated
(6)
Prior
Benefits
Paid
(7)
State
UI
Line
No.
New
Claims
(1)
Intrastate
101
c1
c2
c3
c4
c5
c31
c32
Interstate
Received
as Paying
State
102
c6
c7
c8
c9
c10
c33
c34
SECTION B. FIRST PAYMENT AND WAGE TRANSFER RESPONSES - TIME LAPSE
First Payment Time Lapse
Time Lapse in Days
Wage Requests Received
(10)
Time Lapse in Days
Responses
(11)
Total
c26
3 or less
c84
Intrastate
(8)
Interstate
(9)
Total
c35
c36
4-6
c85
7 or less
c37
c38
7 - 10
c39
8 - 14
c40
c41
11 - 14
c42
15 - 21
c43
c44
15 - 21
c45
22 - 28
c46
c47
22 - 28
c48
29 - 35
c49
c50
29 - 35
c51
36 - 42
c52
c53
36 - 42
c54
43 - 49
c55
c56
43 - 49
c57
50 - 56
c58
c59
50 - 56
c60
57 - 63
c61
c62
57 - 63
c63
64 - 70
c64
c65
64 - 70
c66
> 70
c67
c68
> 70
c69
A−33
Appendix A
TABLE ar586 (cont’d)
ETA 586 - INTERSTATE ARRANGEMENT-EMPLOYMENT AND WAGES
SECTION C. BILLING AND REIMBURSEMENT TIME LAPSE
Time Lapse in Days
Billing Time Lapse
(12)
Reimbursement Time Lapse
(13)
Total
c70
c71
14 or less
c72
c73
15 - 30
c74
c75
31 - 45
c76
c77
46 - 60
c78
c79
61 - 90
c80
c81
> 90
c82
c83
Comments:
A−34
Appendix A
TABLE ar5130
ETA 5130 - BENEFIT APPEALS REPORT
STATE
REGION
REPORT FOR PERIOD ENDING
st
g_states.region
rptdate
SECTION A. SINGLE and MULTICLAIMANT APPEALS CASE DECISIONS BY PROGRAM AND OTHER DISPPOSITION
UI DECISIONS
Line
No.
UCFE-NO UI DECISIONS
UCX ONLY DECISIONS
Other
Dispositions
Lower
Authority
Higher
Authority
Lower
Authority
Higher
Authority
Lower
Authority
Higher
Authority
(1)
(2)
(3)
(4)
(5)
(6)
(7)
c1
c2
c3
c4
c5
c6
c7
100
SECTION B. CLAIMANTS INVOLVED IN STATE UI APPEALS CASES BY STATUS OF APPEALS
SINGLE-CLAIMANT APPEALS
Line
No.
STATUS OF APPEALS
MULTI-CLAIMANT APPEALS
Lower
Authority
Higher
Authority
Lower
Authority
Higher
Authority
(8)
(9)
(10)
(11)
200
Filed During Month
c9
c10
c11
c12
210
Disposed of During Month
c13
c14
c15
c16
SECTION C. STATE UI APPEALS DECISIONS BY TYPE OF APPELLANT
ALL UI DECISIONS
Line
No.
APPEALS DECISIONS
CLAIMANT
EMPLOYER
OTHER
Lower
Higher
Lower
Higher
Lower
Higher
Lower
Higher
(12)
(13)
(14)
(15)
(16)
(17)
(18)
(19)
300
Total
c51
c52
c53
c54
c55
c56
c57
c58
310
In Favor of Appellant
c59
c60
c61
c62
c63
c64
c65
c66
SECTION D. NUMBER OF LOWER AUTHORITY STATE UI APPEALS DECISIONS BY TYPE OF ISSUE
Line
No.
400
TOTAL UI
DECISIONS
VOLUNTARY
QUIT
MISCONDUCT
REFUSAL OF
SUITABLE WORK
NOT ABLE or
AVAILABLE
LABOR
DISPUTE
OTHER
(20)
(21)
(22)
(23)
(24)
(25)
(26)
c67
c68
c69
c70
c71
c72
c73
Comments:
A−35
Appendix A
TABLE: ae5130
ETA 5130 - BENEFIT APPEALS (EB)
STATE
REGION
REPORT FOR PERIOD ENDING
st
g_states.region
rptdate
SECTION A. SINGLE CLAIMANT AND MULTICLAIMANT APPEAL DECISIONS BY PROGRAM AND OTHER
DISPOSITIONS
UI Decisions
UCFE-No UI Decisions
UCX Only Decisions
Line
No.
Lower
Authority
(1)
Higher
Authority
(2)
Lower
Authority
(3)
Higher
Authority
(4)
Lower
Authority
(5)
Higher
Authority
(6)
Other
Dispositions
(7)
100
c1
c2
c3
c4
c5
c6
c7
SECTION B. CLAIMANTS INVOLVED IN STATE UI APPEALS CASES BY STATUS OF APPEALS
Single-Claimant Appeals
Multi-Claimant Appeals
Status of Appeals
Lower
Authority
(8)
Higher
Authority
(9)
Lower
Authority
(10)
Higher
Authority
(11)
200
Filed During Month
c9
c10
c11
c12
210
Disposed of During Month
c13
c14
c15
c16
Line
No.
SECTION C. STATE UI APPEALS DECISIONS BY TYPE OF APPELLANT
All UI Decisions
Claimant
Employer
Other
Line
No.
Appeals
Decisions
Lower
Authority
(12)
Higher
Authority
(13)
Lower
Authority
(14)
Higher
Authority
(15)
Lower
Authority
(16)
Higher
Authority
(17)
Lower
Authority
(18)
Higher
Authority
(19)
300
Total
c51
c52
c53
c54
c55
c56
c57
c58
310
In Favor of
Appellant
c59
c60
c61
c62
c63
c64
c65
c66
SECTION D. NUMBER OF LOWER AUTHORITY STATE UI APPEALS DECISIONS BY ISSUE
Line
No.
Total UI
Decisions
(20)
Voluntary
Quit
(21)
Misconduct
(22)
Refusal of
Suitable
Work
(23)
Not Able
or
Available
(24)
Labor
Dispute
(25)
Other
(26)
400
c67
c68
c69
c70
c71
c72
C73
Comments:
A−36
Appendix A
TABLE: at5130
ETA 5130 - BENEFIT APPEALS (TEUC)
STATE
REGION
REPORT FOR PERIOD ENDING
st
g_states.region
rptdate
SECTION A. SINGLE CLAIMANT AND MULTICLAIMANT APPEAL DECISIONS BY PROGRAM AND OTHER
DISPOSITIONS
UI Decisions
UCFE-No UI Decisions
UCX Only Decisions
Line
No.
Lower
Authority
(1)
Higher
Authority
(2)
Lower
Authority
(3)
Higher
Authority
(4)
Lower
Authority
(5)
Higher
Authority
(6)
Other
Dispositions
(7)
100
c1
c2
c3
c4
c5
c6
c7
SECTION B. CLAIMANTS INVOLVED IN STATE UI APPEALS CASES BY STATUS OF APPEALS
Single-Claimant Appeals
Multi-Claimant Appeals
Status of Appeals
Lower
Authority
(8)
Higher
Authority
(9)
Lower
Authority
(10)
Higher
Authority
(11)
200
Filed During Month
c9
c10
c11
c12
210
Disposed of During Month
c13
c14
c15
c16
Line
No.
SECTION C. STATE UI APPEALS DECISIONS BY TYPE OF APPELLANT
All UI Decisions
Claimant
Employer
Other
Line
No.
Appeals
Decisions
Lower
Authority
(12)
Higher
Authority
(13)
Lower
Authority
(14)
Higher
Authority
(15)
Lower
Authority
(16)
Higher
Authority
(17)
Lower
Authority
(18)
Higher
Authority
(19)
300
Total
c51
c52
c53
c54
c55
c56
c57
c58
310
In Favor of
Appellant
c59
c60
c61
c62
c63
c64
c65
c66
SECTION D. NUMBER OF LOWER AUTHORITY STATE UI APPEALS DECISIONS BY ISSUE
Line
No.
Total UI
Decisions
(20)
Voluntary
Quit
(21)
Misconduct
(22)
Refusal of
Suitable
Work
(23)
Not Able
or
Available
(24)
Labor
Dispute
(25)
Other
(26)
400
c67
c68
c69
c70
c71
c72
C73
Comments:
A−37
Appendix A
TABLE ar5159
ETA 5159 – CLAIMS AND PAYMENT ACTIVITIES
STATE
REGION
REPORT FOR PERIOD ENDING
st
g_states.region
rptdate
SECTION A. CLAIMS ACTIVITIES
Initial Claims
Sum of
Total
Cols. 2-4
New
Intrastate
Excluding
Transitional
Additional
Intrastate
Interstate
Filed from
Agent
State
Interstate
Taken as
Agent
State
Transitional
Interstate Received as
Liable State
(1)
(2)
(3)
(4)
(5)
(6)
(7)
Program
Line
No.
State UI
101
c1
c2
c3
c4
c97
c5
c6
UCFE
No UI
102
c7
c8
c9
c10
c98
c11
c12
UCX Only
103
c13
c14
c15
c16
c99
c17
c18
Eligibility Reviews
Continued Weeks Claimed
Entering Self Employment,
All Programs
Intrastate
Interstate
Liable
Intrastate
Interstate Filed
From Agent
State
Interstate
Received as
Liable State
(8)
(9)
(10)
(11)
(12)
(13)
c94
State UI
201
c19
c20
c21
c22
c24
UCFE
No UI
202
c25
c26
c27
c28
c30
UCX Only
203
c31
c32
c33
c34
c36
SECTION B. PAYMENT ACTIVITIES
Weeks and Amounts Compensated
State UI Program
Item
UCFE and UCX Programs
Self Employment, All
Programs
All Weeks
Compensated
Total
Unemployment
Interstate
Total
UCFE
No UI
UCX Only
(14)
(15)
(16)
(17)
(18)
(19)
(20)
Number
301
c38
c39
c40
c41
c42
c43
c95
Amount
302
c45
c46
c47
c48
c49
c50
c96
Final Payments for All
Unemployment
First Payments for All Unemployment
UCFE and UCX
Programs
State UI Program
Number
303
State UI
Program
UCFE and UCX
Programs
Total
Intrastate
Interstate
UCFE
No UI
UCX Only
Total
UCFE
No UI
UCX
Only
(21)
(22)
(23)
(24)
(25)
(26)
(27)
(28)
c51
c52
c53
c54
c55
c56
c57
c58
Comments:
A−38
Appendix A
TABLE ae5159
ETA 5159 - CLAIMS AND PAYMENT ACTIVITIES (EB)
STATE
REGION
REPORT FOR PERIOD ENDING
st
g_states.region
rptdate
SECTION A. CLAIMS ACTIVITIES
Initial Claims
Program
Line No.
New Intrastate
Excluding
Transitional
(2)
Additional
Intrastate
(3)
Interstate
Filed from
Agent State
(4)
Interstate
Taken as
Agent State
(5)
Interstate
Received as
Liable State
(7)
State UI
101
c1
c46
c2
c49
c3
UCFE, No UI
102
c4
c47
c5
c50
c6
UCX Only
103
c7
c48
c8
c51
c9
Eligibility Reviews
Continued Weeks Claimed
Intrastate
(8)
Interstate
Liable
(9)
Intrastate
(10)
Interstate Filed from
Agent State
(11)
Interstate Received
as Liable State
(13)
State UI
201
c10
c11
c12
c13
c15
UCFE, No UI
202
c16
c17
c18
c19
c21
UCX Only
203
c22
c23
c24
c25
c27
SECTION B. PAYMENT ACTIVITIES
Weeks and Amounts Compensated
State UI Program
Item
UCFE and UCX Programs
All Weeks
Compensated
(15)
Total
Unemployment
(16)
Total
(18)
UCFE, No UI
(19)
UCX Only
(20)
Number
301
c29
c30
c31
c32
c33
Amount
302
c35
c36
c37
c38
c39
First Payments for All Unemployment
State UI Program
Number
303
Final Payments for All Unemployment
UCFE and UCX Programs
State UI Program
UCFE and UCX Programs
Total
(22)
UCFE, No UI
(25)
UCX Only
(26)
Total
(27)
UCFE, No UI
(28)
UCX Only
(29)
c40
c41
c42
c43
c44
c45
Comments:
A−39
Appendix A
TABLE at5159
ETA 5159 - CLAIMS AND PAYMENT ACTIVITIES (TEUC)
STATE
REGION
REPORT FOR PERIOD ENDING
st
g_states.region
rptdate
SECTION A. CLAIMS ACTIVITIES
Initial Claims
New Intrastate
Excluding
Transitional
(2)
Additional
Intrastate
(3)
Interstate
Filed from
Agent State
(4)
Interstate
Taken as
Agent State
(5)
Interstate
Received as
Liable State
(7)
Program
Line
No.
State UI
101
c1
c46
c2
c49
c3
UCFE, No UI
102
c4
c47
c5
c50
c6
UCX Only
103
c7
c48
c8
c51
c9
Eligibility Reviews
Continued Weeks Claimed
Intrastate
(8)
Interstate
Liable
(9)
Intrastate
(10)
Interstate
Filed From
Agent State
(11)
Interstate
Received as
Liable State
(12)
State UI
201
c10
c11
c12
c13
c15
UCFE, No UI
202
c16
c17
c18
c19
c21
UCX Only
203
c22
c23
c24
c25
c27
SECTION B. PAYMENT ACTIVITIES
Weeks and Amounts Compensated
State UI Program
Item
UCFE and UCX Programs
All Weeks Compensated
(14)
Total
Unemployment
(15)
Total
(17)
UCFE, No UI
(18)
UCX Only
(19)
Number
301
c29
c30
c31
c32
c33
Amount
302
c35
c36
c37
c38
c39
First Payments for All Unemployment
State UI Program
Number
303
Final Payments for All Unemployment
UCFE and UCX Programs
State UI Program
UCFE and UCX Programs
Total
(21)
UCFE, No UI
(24)
UCX Only
(25)
Total
(26)
UCFE, No UI
(27)
UCX Only
(28)
c40
c41
c42
c43
c44
c45
Comments:
A−40
Appendix A
TABLE aw5159
ETA 5159 - CLAIMS AND PAYMENT ACTIVITIES (WORKSHARE)
STATE
REGION
REPORT FOR PERIOD ENDING
st
g_states.region
rptdate
SECTION A. CLAIMS ACTIVITIES
Initial Claims
Program
101 | State UI
New Intrastate Excluding Transitional
(2)
Additional Intrastate
(3)
c1
c2
Continued Weeks Claimed
Items
201 | State UI
Intrastate
(9)
c3
SECTION B. PAYMENT ACTIVITIES
Weeks Compensated
Items
State UI Program
All Weeks Compensated
(14)
301 | Number
c4
302 | Amount
c5
303 | Number
First Payments for All Unemployment
State UI Program
Intrastate
(21)
Final Payment for All Unemployment
State UI
Total
(25)
c6
c7
SECTION C. FULL TIME EQUIVALENTS
Number
Equivalent Initials
Equivalent Weeks Claimed
c8
c9
Comments:
A−41
Appendix A
TABLE ar8401
ETA 8401 - MONTHLY ANALYSIS OF BENEFIT PAYMENT ACCOUNT
STATE
REGION
REPORT FOR PERIOD ENDING
st
g_states.region
rptdate
Bank Name:
c2
Bank City:
c3
Account Number:
c1
Commingled/Separate:
c4
LEDGER
1.
Beginning Balance
c5
2.
Total Deposits
c6
3.
Total Checks Issued
c7
4.
Ending Balance
c8
5.
Total of Daily Ledger Balances
c18
6.
Average Daily Balance
c9
7.
Percent Average Daily Balance to
Checks Issued
c10
DEPOSITS
8.
UI Trust Funds
c11
9.
Reimbursable Funds
c12
10.
Federal Funds
c13
11.
Refunds
c14
CHECKS ISSUED
12.
UI Trust Funds
c15
13.
Reimbursable Funds
c16
14.
Federal Funds
c17
Comments:
A−42
Appendix A
TABLE ar8405
ETA 8405 - MONTHLY ANALYSIS OF CLEARING ACCOUNT
STATE
REGION
REPORT FOR PERIOD ENDING
st
g_states.region
rptdate
Bank Name:
c2
Bank City:
c3
Account Number:
c1
Commingled/Separate:
c4
LEDGER
1.
Beginning Balance
c5
2.
Total Deposits
c6
3.
Total Transfers to Trust Fund
c7
4.
Total Deductions Other Purposes
c8
5.
Ending Balance
c9
6.
Total of Daily Ledger Balance
c16
7.
Average Daily Balance
c10
8.
Percent Average Daily Balance to Total Deposits
c11
DEDUCTIONS FOR OTHER PURPOSES
9.
Employer Refunds
c12
10.
Dishonored Checks
c13
11.
Interest and Penalty Fund
c14
12.
Other - Benefits
c15
Comments:
A−43
Appendix A
TABLE ar8413
ETA 8413 - INCOME-EXPENSE ANALYSIS, UNEMPLOYMENT COMPENSATION
FUND BENEFIT PAYMENT ACCOUNT
STATE
REGION
REPORT FOR PERIOD ENDING
st
g_states.region
rptdate
Bank Name:
c2
Account Number:
c1
Bank City:
c3
LEDGER
1.
Beginning Balance
c7
2.
Total Deposits
c5
3.
Total Withdrawals
c6
4.
Ending Balance
c8
INCOME ANALYSIS
5.
Total Daily Ledger Balance
c4
6.
Average Daily Ledger Balance
c5
7.
Average Daily Float
c10
8.
Average Daily Collected Balance (Line 6 - Line 7)
c11
9.
Reserves at
10.
Average Daily Loanable Balance (Line 8 - Line 9)
11.
Earning Value at
c12%
c13
c14
c15%
c16
EXPENSE ANALYSIS
12.
Checks Deposited: Number c17
at
c18
c19
13.
Checks on Account: Number c20
at
c21
c22
14.
Checks on Account: Number c23
at
c24
c25
15.
Checks on Account: Number
c26
at
c27
c28
16.
Other Costs
c29
17.
Other Costs
c30
18.
Other Costs
c31
19.
Total Costs (Line12 through Line 18)
c32
20.
NET PROFIT/LOSS
c33
Comments:
A−44
Appendix A
TABLE ar8414
ETA 8414 – INCOME -EXPENSE ANALYSIS UNEMPLOYMENT COMPENSATION
FUND CLEARING ACCOUNT
STATE
REGION
REPORT FOR PERIOD ENDING
st
g states.region
rptdate
Bank Name:
c2
Account Number:
c1
Bank City:
c3
LEDGER
1.
Beginning Balance
c7
2.
Total Deposits
c5
3.
Total Withdrawals
c6
4.
Ending Balance
c8
INCOME ANALYSIS
5.
Total Daily Ledger Balance
c4
6.
Average Daily Ledger Balance
c9
7.
Average Daily Float
c10
8.
Average Daily Collected Balance (Line 6 - Line 7)
c11
9.
Reserves at
10.
Average Daily Loanable Balance (Line 8 - Line 9)
c14
11.
Earning Value at
c16
c12%
c13
EXPENSE ANALYSIS
12.
Checks Deposited Local: Number
c17
at
c18
c19
13.
Checks Deposited Tran.: Number
c20
at
c21
c22
14.
Checks on Account:
Number
c23
at
c24
c25
15.
Checks on Account:
Number
c26
at
c27
c28
16.
Checks on Account:
Number
c29
at
c30
c31
17.
Other Costs
c32
18.
Other Costs
c33
19.
Other Costs
c34
20.
Total Costs (Line12 through Line 19)
c35
21.
NET PROFIT/LOSS
c36
Comments:
A−45
Appendix A
TABLE ar902
ETA 902 - DISASTER UNEMPLOYMENT ASSISTANCE ACTIVITY
STATE
REGION
REPORT FOR PERIOD ENDING
st
g_states.region
rptdate
FEMA Directive No.
Report Type
Declaration Date
Announcement Date
c1
c69
c2
c3
SECTION A. APPLICATION AND PAYMENT ACTIVITIES
Category
Line
No.
Initial
Appeals
Number of
Determined
Eligible
First
Payments
Weeks
Claimed
Weeks
Compensated
Amount
Compensated
1
2
3
4
5
6
c6
c21
c22
c23
Total
101
c4
c5
SelfEmployed
102
c57
c17
SECTION B. DENIAL AND APPEALS ACTIVITY
Category
Line
No.
Total
201
Self-Employed
202
Appeals Filed
Weeks of
DUA Denied
Appeals Disposed
Favor of Appellant
State
RA
State
RA
State
RA
7
8
9
10
11
12
13
c35
c58
c59
c33
c34
c60
c61
c62
c63
c45
c46
c64
c65
SECTION C. OVERPAYMENT ACTIVITY AND ADMINISTRATION
Overpayments
Category
Line
No.
Administrative Costs
Cases
Weeks
Amount
Personnel
NPS
AS&T
14
15
16
17
18
19
c66
c67
c68
Total
301
c49
c50
c51
Fraud
301
c53
c54
c55
Comments:
A−46
Appendix A
TABLE ar9000
ETA 9000 INTERNAL FRAUD ACTIVITIES
STATE:
REGION:
REPORT FOR PERIOD ENDING:
st
g_states.region
rptdate
SECTION A. BENEFIT FUNDS - UI EMPLOYEE
Number Cases
Dollar Amounts
Line
Number Cases
Employee Acted
Actual
(1)
Estimated
(2)
Actual
(3)
Estimated
(4)
Alone
(5)
With Others
(6)
Claimed Benefits after Returned to Work
101
c1
c2
c3
c4
c5
c6
Diverted Benefits Non-employee Claims
102
c7
c8
c9
c10
c11
c12
Established Claims with Bogus Wages
103
c13
c14
c15
c16
c17
c18
Authorized Improper Claims for Others
104
c19
c20
c21
c22
c23
c24
Appropriated Outgoing/Returned Checks
105
c25
c26
c27
c28
c29
c30
Pocketed Repayment by Overpaid Claimants
106
c31
c32
c33
c34
c35
c36
Extorted Money from Claimants
107
c37
c38
c39
c40
c41
c42
Miscellaneous
108
c43
c44
c45
c46
c47
c48
Totals
109
c49
c50
c51
c52
c53
c54
SECTION B. CONTRIBUTIONS - UI EMPLOYEE
Misused Confidential Employer Files
201
c55
c56
c57
c58
c59
c60
Misappropriated Monies Taxes, Penalty/Interest
Employers
202
c61
c62
c63
c64
c65
c66
Falsified Employer Records Reducing
Tax/Penalty/Interest
203
c67
c68
c69
c70
c71
c72
Misappropriated Refunds Due Employer
204
c73
c74
c75
c76
c77
c78
Generated False Refund Checks
205
c79
c80
c81
c82
c83
c84
Created Fictitious Employer Account
206
c85
c86
c87
c88
c89
c90
Extorted Money from Employer
207
c91
c92
c93
c94
c95
c96
Miscellaneous
208
c97
c98
c99
c100
c101
c102
Totals
209
c103
c104
c105
c106
c107
c108
A−47
Appendix A
TABLE ar9000 (cont’d)
ETA 9000 INTERNAL FRAUD ACTIVITIES
SECTION C. ADMINISTRATIVE FUNDS - UI EMPLOYEE
Number Cases
Number Cases
Employee Acted
Dollar Amounts
Line
Actual
(1)
Estimated
(2)
Actual
(3)
Estimated
(4)
Alone
(5)
With Others
(6)
Embezzled Administrative Funds
301
c109
c110
c111
c112
c113
c114
Misused Equipment or Supplies
302
c115
c116
c117
c118
c119
c120
Falsified Time and Attendance Records
303
c121
c122
c123
c124
c125
c126
Falsified Travel Voucher
304
c127
c128
c129
c130
c131
c132
Made Unauthorized Telephone Calls
305
c133
c134
c135
c136
c137
c138
Miscellaneous
306
c139
c140
c141
c142
c143
c144
307
c145
c146
c147
c148
c149
c150
Totals
SECTION D. DETECTION AND PREVENTION ACTIVITIES
Number Cases
Line
Actual
(7)
Dollar Amounts
Estimated
(8)
Actual
(9)
Estimated
(10)
Audits Conducted
401
c151
c152
Matching Systems
402
c153
c154
Communications
403
c155
c156
Controls Established
404
Miscellaneous
405
c159
c160
c161
c162
406
c163
c164
c165
c166
Totals
c157
c158
SECTION E. ACTION AGAINST EMPLOYEES - NUMBER EMPLOYEES
Criminal Actions
OIG Referral
Administrative Actions
Line
Charged
(11)
Arrested
(12)
Prosecuted
(13)
Convicted
(14)
Imprisoned
(15)
No Action
(16)
501
c167
c168
c169
c170
c171
c172
Charged
(17)
Arrested
(18)
Prosecuted
(19)
Convicted
(20)
Imprisoned
(21)
No Action
(22)
c179
c180
c181
c182
c183
c184
Reprimanded
(23)
Suspended
(24)
Demoted
(25)
Discharged
(26)
Resigned
(27)
No Action
(28)
c173
c174
c175
c176
c177
c178
502
503
Comments:
A−48
Appendix A
TABLE ar9016
ETA 9016 - ALIEN CLAIMS ACTIVITIES
STATE
REGION
REPORT FOR PERIOD ENDING
st
g_states.region
rptdate
1. Initial claims where claimant is not a citizen
2.
Number of claimants whose alien status was verified through the INS
primary system
c1
c2
3. Number of secondary verifications
c3
4. Nonmonetary determinations regarding alien status
c8
5. Denials attributable to alien status
c9
Comments:
A−49
Appendix A
TABLE ar9047
ETA 9047 - REEMPLOYMENT OF UI BENEFIT RECIPIENTS
STATE
REGION
REPORT FOR PERIOD ENDING
st
g_states.region
rptdate
Exemption Code
Number of
Claimants
Receiving 1st
Payment
Number of Intrastate
Crossmatch Hits:
YYYY.Q+1
Number of Interstate
Crossmatch Hits:
YYYY.Q+1
0 - Not Exempt
c1
c2
c3
1 - Exempt
c4
c5
c6
Comments:
A−50
Appendix A
TABLE ar9048
ETA 9048 PROFILING AND REEMPLOYMENT SERVICES
STATE:
REGION:
REPORT FOR PERIOD ENDING:
st
g_states.region
rptdate
SECTION A. PROFILED CLAIMANTS:
1.
Total Profiled
c1
2.
Number Put in Selection "Pool/Queue"
c2
3.
Number Referred to Services
c3
4.
Number Exempted from Mandatory
c4
SECTION B. PROFILED CLAIMANTS REFERRED TO AND REPORTING TO SERVICES:
1.
Number Reported to Services
c5
2.
Orientation
c6
3.
Assessment
c7
4.
Counseling
c8
5.
Job Placement Services and Referrals to Employers
c9
6.
Job Search Workshops or Job Clubs
c10
7.
Referral to Education and Training
c11
8.
Number Enrolled in Self-Employment Program
c12
SECTION C. PROFILED CLAIMANTS REFERRED TO AND COMPLETING SERVICES:
1.
Number Completed Services
c13
2.
Orientation
c14
3.
Assessment
c15
4.
Counseling
c16
5.
Job Placement Services and Referrals to Employers
c17
6.
Job Search Workshops or Job Clubs
c18
7.
Completed Education and Training
c19
8.
Completed Self-Employment Program
c20
Comments:
A−51
Appendix A
TABLE ar9049
ETA 9049 PROFILING AND REEMPLOYMENT SERVICES OUTCOMES
STATE:
REGION:
REPORT FOR PERIOD ENDING:
st
g_states.region
rptdate
SECTION A. CLAIMS EXPERIENCE FOR THOSE PROFILED AND REFERRED CLAIMANTS
WHO WERE FIRST REFERRED IN REPORT QUARTER:
1.
Number Exhausted
c1
2.
Average Compensated Duration
c2
3.
Average Benefits Paid
c3
4.
Base Period Wages
c4
SECTION B. EMPLOYMENT ACTIVITY FOR THOSE PROFILED CLAIMANTS WHO WERE
FISRT REFERRED IN THE REPORT QUARTER:
Quarter After Referral
1st
2nd Quarter 3rd Quarter 4th Quarter
Quarter
Quarter Ending
c5
c6
c7
c8
1.
Number Employed
c9
c10
c11
c12
2.
Base Period Wages
c13
c14
c15
c16
3.
Number Employed in Different Industry
c17
c18
c19
c20
4.
Wages Earned in Quarter
c21
c22
c23
c24
Comments:
A−52
Appendix A
TABLE ar9050
ETA 9050 - TIME LAPSE OF ALL FIRST PAYMENTS EXCEPT WORKSHARE
STATE
REGION
REPORT FOR PERIOD ENDING
st
g_states.region
rptdate
Time
Lapse
(Days)
Intra-State
Inter-State
Total
UI
UCFE
UCX
Total
UI
UCFE
UCX
Total
c1
c2
c3
c4
c5
c6
c7
c8
<=7
c9
c10
c11
c12
c13
c14
c15
c16
8-14
c17
c18
c19
c20
c21
c22
c23
c24
15-21
c25
c26
c27
c28
c29
c30
c31
c32
22-28
c33
c34
c35
c36
c37
c38
c39
c40
29-35
c41
c42
c43
c44
c45
c46
c47
c48
36-42
c49
c50
c51
c52
c53
c54
c55
c56
43-49
c57
c58
c59
c60
c61
c62
c63
c64
50-56
c65
c66
c67
c68
c69
c70
c71
c72
57-63
c73
c74
c75
c76
c77
c78
c79
c80
64-70
c81
c82
c83
c84
c85
c86
c87
c88
>70
c89
c90
c91
c92
c93
c94
c95
c96
A−53
Appendix A
TABLE ar9050p
ETA 9050 - TIME LAPSE OF PARTIAL/PART TOTAL FIRST PAYMENTS
STATE
REGION
REPORT FOR PERIOD ENDING
st
g_states.region
rptdate
Time
Lapse
(Days)
Total
UI
UCFE
UCX
Total
UI
UCFE
UCX
Total
c1
c2
c3
c4
c5
c6
c7
c8
<=7
c9
c10
c11
c12
c13
c14
c15
c16
8-14
c17
c18
c19
c20
c21
c22
c23
c24
15-21
c25
c26
c27
c28
c29
c30
c31
c32
22-28
c33
c34
c35
c36
c37
c38
c39
c40
29-35
c41
c42
c43
c44
c45
c46
c47
c48
36-42
c49
c50
c51
c52
c53
c54
c55
c56
43-49
c57
c58
c59
c60
c61
c62
c63
c64
50-56
c65
c66
c67
c68
c69
c70
c71
c72
57-63
c73
c74
c75
c76
c77
c78
c79
c80
64-70
c81
c82
c83
c84
c85
c86
c87
c88
>70
c89
c90
c91
c92
c93
c94
c95
c96
Intra-State
Inter-State
A−54
Appendix A
TABLE aw9050
ETA 9050 - FIRST PAYMENT TIME LAPSE (WORKSHARE)
STATE
REGION
REPORT FOR PERIOD ENDING
st
g_states.region
rptdate
Time Lapse (Days)
Workshare Claims
Total
c1
0-7
c2
8-14
c3
15-21
c4
22-28
c5
29-35
c6
36-42
c7
43-49
c8
50-56
c9
57-63
c10
64-70
c11
>70
c12
Comments:
A−55
Appendix A
TABLE ar9051
ETA 9051 - TIME LAPSE COUNTS FOR ALL CONTINUED WEEKS COMPENSATED
STATE
REGION
REPORT FOR PERIOD ENDING
st
g_states.region
rptdate
Time
Lapse
(Days)
Intra-State
Inter-State
Total
UI
UCFE
UCX
Total
UI
UCFE
UCX
Total
c1
c2
c3
c4
c5
c6
c7
c8
<=7
c9
c10
c11
c12
c13
c14
c15
c16
8-14
c17
c18
c19
c20
c21
c22
c23
c24
15-21
c25
c26
c27
c28
c29
c30
c31
c32
22-28
c33
c34
c35
c36
c37
c38
c39
c40
29-35
c41
c42
c43
c44
c45
c46
c47
c48
36-42
c49
c50
c51
c52
c53
c54
c55
c56
43-49
c57
c58
c59
c60
c61
c62
c63
c64
50-56
c65
c66
c67
c68
c69
c70
c71
c72
57-63
c73
c74
c75
c76
c77
c78
c79
c80
64-70
c81
c82
c83
c84
c85
c86
c87
c88
>70
c89
c90
c91
c92
c93
c94
c95
c96
A−56
Appendix A
TABLE ar9051p
ETA 9051 - TIME LAPSE FOR CONTINUED WEEKS: PARTIAL/PART TOTAL
PAYMENTS
STATE
REGION
REPORT FOR PERIOD ENDING
st
g_states.region
rptdate
Time
Lapse
(Days)
Intra-State
Inter-State
Total
UI
UCFE
UCX
Total
UI
UCFE
UCX
Total
c1
c2
c3
c4
c5
c6
c7
c8
<=7
c9
c10
c11
c12
c13
c14
c15
c16
8-14
c17
c18
c19
c20
c21
c22
c23
c24
15-21
c25
c26
c27
c28
c29
c30
c31
c32
22-28
c33
c34
c35
c36
c37
c38
c39
c40
29-35
c41
c42
c43
c44
c45
c46
c47
c48
36-42
c49
c50
c51
c52
c53
c54
c55
c56
43-49
c57
c58
c59
c60
c61
c62
c63
c64
50-56
c65
c66
c67
c68
c69
c70
c71
c72
57-63
c73
c74
c75
c76
c77
c78
c79
c80
64-70
c81
c82
c83
c84
c85
c86
c87
c88
>70
c89
c90
c91
c92
c93
c94
c95
c96
A−57
Appendix A
TABLE aw9051
ETA 9051 - CONTINUED CLAIMS TIME LAPSE (WORKSHARE)
STATE
REGION
REPORT FOR PERIOD ENDING
st
g_states.region
rptdate
Time Lapse (Days)
Workshare Claims
Total
c1
0-7
c2
8-14
c3
15-21
c4
22-28
c5
29-35
c6
36-42
c7
43-49
c8
50-56
c9
57-63
c10
64-70
c11
>70
c12
Comments:
A−58
Appendix A
TABLE ar9052
ETA 9052 - NONMONETARY DETERMINATION TIME LAPSE DETECTION DATE
STATE
REGION
REPORT FOR PERIOD ENDING
st
g_states.region
rptdate
SECTION A. SEPARATION ISSUES
Time
Lapse
(Days)
Intra-State
Inter-State
Total
UI
UCFE
UCX
Total
UI
UCFE
UCX
Total
c1
c2
c3
c4
c5
c6
c7
c8
<=7
c9
c10
c11
c12
c13
c14
c15
c16
8-14
c17
c18
c19
c20
c21
c22
c23
c24
15-21
c25
c26
c27
c28
c29
c30
c31
c32
22-28
c33
c34
c35
c36
c37
c38
c39
c40
29-35
c41
c42
c43
c44
c45
c46
c47
c48
36-42
c49
c50
c51
c52
c53
c54
c55
c56
43-49
c57
c58
c59
c60
c61
c62
c63
c64
50-56
c65
c66
c67
c68
c69
c70
c71
c72
57-63
c73
c74
c75
c76
c77
c78
c79
c80
64-70
c81
c82
c83
c84
c85
c86
c87
c88
>70
c89
c90
c91
c92
c93
c94
c95
c96
SECTION B. NON-SEPARATION ISSUES
Time
Lapse
(Days)
Intra-State
Inter-State
Total
UI
UCFE
UCX
Total
UI
UCFE
UCX
Total
c97
c98
c99
c100
c101
c102
c103
c104
<=7
c105
c106
c107
c108
c109
c110
c111
c112
8-14
c113
c114
c115
c116
c117
c118
c119
c120
15-21
c121
c122
c123
c124
c125
c126
c127
c128
22-28
c129
c130
c131
c132
c133
c134
c135
c136
29-35
c137
c138
c139
c140
c141
c142
c143
c144
A−59
Appendix A
TABLE ar9052 (cont’d)
ETA 9052 - NONMONETARY DETERMINATION TIME LAPSE DETECTION DATE
36-42
c145
c146
c147
c148
c149
c150
c151
c152
43-49
c153
c154
c155
c156
c157
c158
c159
c160
50-56
c161
c162
c163
c164
c165
c166
c167
c168
57-63
c169
c170
c171
c172
c173
c174
c175
c176
64-70
c177
c178
c179
c180
c181
c182
c183
c184
>70
c185
c186
c187
c188
c189
c190
c191
c192
SECTION C. MULTI-CLAIMANT ISSUES
Time Lapse (Days)
Total
Multi-claimant
Labor Disputes
Multi-claimant
"Other"
Total
c193
c194
c195
<=7
c196
c197
c198
8-14
c199
c200
c201
15-21
c202
c203
c204
22-28
c205
c206
c207
29-35
c208
c209
c210
36-42
c211
c212
c213
43-49
c214
c215
c216
50-56
c217
c218
c219
57-63
c220
c221
c222
64-70
c223
c224
c225
>70
c226
c227
c228
Comments:
A−60
Appendix A
TABLE ar9054l
ETA 9054L - LOWER AUTHORITY APPEALS TIME LAPSE
STATE
REGION
REPORT FOR PERIOD ENDING
st
g_states.region
rptdate
Time Lapse (Days)
Total
Intrastate
Interstate
Total
c1
c2
c3
<=30
c4
c5
c6
31-45
c7
c8
c9
45-60
c10
c11
c12
61-75
c13
c14
c15
76-90
c16
c17
c18
91-120
c19
c20
c21
>120
c22
c23
c24
A−61
Appendix A
TABLE ar9054h
ETA 9054H - HIGHER AUTHORITY APPEALS TIME LAPSE
STATE
REGION
REPORT FOR PERIOD ENDING
st
g_states.region
rptdate
Time Lapse (Days)
Total
Intrastate
Interstate
Total
c1
c2
c3
<=45
c4
c5
c6
46-60
c7
c8
c9
61-75
c10
c11
c12
76-90
c13
c14
c15
91-120
c16
c17
c18
121-150
c19
c20
c21
151-180
c22
c23
c24
181-210
c25
c26
c27
211-240
c28
c29
c30
241-270
c31
c32
c33
271-300
c34
c35
c36
301-330
c37
c38
c39
331-360
c40
c41
c42
>360
c43
c44
c45
Comments:
A−62
Appendix A
TABLE ar9055l
ETA 9055L - LOWER AUTHORITY APPEALS, CASE AGING
STATE
REGION
REPORT FOR PERIOD ENDING
st
g_states.region
rptdate
Time Lapse Days
Appeals
Total Pending Cases
c1
<=25
c2
26-40
c3
41-90
c4
91-120
c5
121-180
c6
181-360
c7
>360
c8
Time Lapse (Days)
Average Age
c9
Median Age
c10
Comments:
A−63
Appendix A
TABLE ar9055h
ETA 9055H - HIGHER AUTHORITY APPEALS, CASE AGING
STATE
REGION
REPORT FOR PERIOD ENDING
st
g_states.region
rptdate
Time Lapse Days
Appeals
Total Pending Cases
c1
<=40
c2
41-70
c3
71-120
c4
121-180
c5
181-360
c6
>360
c7
Time Lapse (Days)
Average Age
c8
Median Age
c9
Comments:
A−64
Appendix A
TABLE ar9056
ETA 9056 - NONMONETARY DETERMINATION QUALITY DATA COLLECTION
INSTRUMENT
STATE
st
REGION
g_states.region
REPORT FOR PERIOD ENDING
rptdate
1.
IDENTIFICATION #
c1
2.
ISSUE CODE
c2
3.
CASE MATERIAL FOUND?
4.
DATE ON DETERMINATION:
5.
CORRECT DATE ON DETERMINATION?
6.
CORRECTED DATE ON DETERMINATION:
7.
CORRECT ISSUE CODE?
8.
IF ITEM 7 IS N, ENTER THE CORRECT CODE FROM BELOW
c24
9.
c29
(Y/N)
c30
c3
(Y/N)
Separation
10 Quit
20 Discharge (MC)
c26
(Y/N)
(If no issue exists, enter ‘00’; if a nonmonetary redetermination, enter
‘01’)
Non-Separation
30 Able/Available
31 Reporting Requirements
40 Work Search
50 Disq/Ded Income
60 Refusal of Work; Failure to Apply/Accept
70 JS Registration
73 Profiling
INTRASTATE CLAIM?
c4
Multi-claimant
80 School Employee
81 Alien
82 Athlete
83 Unemployment Status
Referral 84 Seasonality
85 Removal of Disq.
86 Fraud Administrative
Penalty
90 Labor Dispute
99 Multi-Claimant
(Other)
c5
(Y/N)
10. PROGRAM TYPE:
UI
UCFE
11. NONMONETARY DETERMINATION OUTCOME:
(A) ALLOWED
(D) DENIED
12. OUTCOME REPORTED CORRECTLY?
(Y/N)
UCX
c28
c6
c7
13. SWA USE ONLY
c8
14. W/E DATE OF FIRST WEEK AFFECTED BY DETERMINATION:
c10
15. CORRECT WEEK ENDING DATE?
c11
(Y/N)
16. CORRECTED WEEK ENDING DATE: (blank if item 15 is “Y”)
c12
17. ISSUE DETECTION DATE:
c13
18. CORRECT ISSUE DETECTION DATE:
c14
(Y/N)
c15
19. CORRECTED ISSUE DETECTION DATE: (blank if item 18 is “Y”)
c16
20. CLAIMANT INFORMATION:
(A) Adequate
(I) Inadequate
(N) Not Obtained
21. EMPLOYER INFORMATION:
(A) Adequate
(I) Inadequate
(N) Not Obtained
(X) Not Applicable
c17
22. INFO/FACTSFROM OTHERS:
(A) Adequate
(I) Inadequate
(N) Not Obtained
(X) Not Applicable
c18
23. LAW/POLICY:
(M) Meets
(Q) Questionable
(W) Does Not Meet
c20
24. WRITTEN DETERMINATION:
(A) Adequate
(I) Inadequate
(W)Wrong (If "W", then Item 23 cannot be "M")
c21
c27
25. TOTAL POINTS SCORE:
COMMENTS:
A−65
Appendix A
TABLE ar9057
ETA 9057 - LOWER AUTHORITY APPEALS QUALITY REVIEW STATE
EVALUATION SCORE SHEET
STATE
REGION
REPORT FOR PERIOD ENDING
st
g_states.region
rptdate
Case Identification Number:
c1
Docket Number:
c39
Good
Fair
Unsatisfactory
Did Not Occur
Score
D
c4
1.
Explanation
G
F
U
2.
Opening Statement
G
F
U
3.
Exhibits
G
F
U
D
c6
4.
Witness Order
G
F
U
D
c7
5.
Order of Witnesses'Testimony
G
F
U
6.
Question Own Witness*
G
F
U
7.
Clear Language by H.O.
G
8.
Compound Questions
G
F
U
9.
Clarified Testimony
G
F
U
D
c12
10.
Confrontation*
G
F
U
D
c13
11.
Cross-Examination*
G
F
U
D
c14
12.
Repetitive Testimony
G
F
U
13.
Leading Questions
G
F
U
14.
Interruptions
G
F
U
D
c17
15.
"Off the Record"
G
F
U
D
c18
16.
Interpreters
G
U
D
c19
17.
Continuance
G
F
U
D
c20
18.
Conclusion of Hearing
G
F
U
c21
19.
Within Scope of Notice*
G
F
U
c22
20.
Gratuitous Comments
G
F
U
c23
21.
Attitude
G
F
U
c24
22.
Bias and Prejudice*
G
U
c25
23.
Obtain Available Evidence*
G
U
c26
24.
Issue Statement
G
U
c27
25.
Findings Supported by Evidence*
G
U
c28
26.
Findings of Fact*
G
U
c29
27.
Necessary Conclusions Included
G
U
c30
28.
Logical Reasoning
G
F
U
c31
29.
Form and Style
G
F
U
c32
30.
Decision States Legal Effect
G
F
U
c33
31.
Understandable Decision
G
F
U
c34
F
F
c9
c10
c11
c15
c16
c40
33.
Intent of Decision
A - Allow
D - Deny
34.
Effect on Appealed Determ.
A - Affirm
R - Reverse
c2
M - Modify
c3
c35
35. Date of Decision
c36
36. Date Implemented:
Case Material Status
c8
D
U
32. Percent Score:
37.
c5
OK - OK
TI - Tape Inaudible
TM - Tape Missing
DM - Documents Missing
IM - Tape Inaudible and Documents Missing
MM - Tape and Documents Missing
c37
c38
38. Time Required for Evaluation of Case in Minutes
Comments:
A−66
Appendix A
TABLE ar9128
ETA 9128 - Reemployment and Eligibility Assessment Workload
STATE
REGION
REPORT FOR PERIOD ENDING
st
g_states.region
rptdate
1.
Number of Claimants Scheduled for Their First REA
c1
2.
Number of All REAs Scheduled
c2
3.
Number of REAs Completed
c3
4.
Number Reporting to Reemployment Services or Training
c4
5.
Number Reporting to Reemployment Services
c5
6.
Number Reporting to Training
c6
7.
Number of Completed REAs Resulting in a Disqualification or Overpayment
c7
8.
Number Disqualified for a Separation Issue
c8
9.
Number Disqualified for an Able and Available Issue
c9
10.
Number Disqualifying/Deductible Income
c10
11.
Number Disqualified for Refusal of Suitable Work Issue
c11
12.
Number Disqualified for Issue(s) Other Than # 9 - 12
c12
13.
Number Resulting in an Overpayment
c13
14.
Dollar Amount of Overpayment Established
c14
15.
Number of REAs for Which the Claimant Failed to Appear
c15
16.
Number That Were Rescheduled Without Disqualification
c16
17.
Number Disqualified for Failure to Report Under Reporting Requirements
c17
18.
Number Disqualified for Failure to Report Under Issues Other Than Reporting
c18
19.
Number That Resulted in An Overpayment
c19
20.
Dollar Amount of Overpayment Established
c20
21.
Number of Claimants That Failed to Report with No Disqualifications
c21
22.
Number of Claimants That Returned to Work (If Available)
c22
Comments:
A−67
Appendix A
TABLE ar9129
ETA 9129 REEMPLOYMENT AND ELIGIBILITY ASSESSMENT OUTCOMES
STATE:
REGION:
REPORT FOR PERIOD ENDING:
st
g_states.region
rptdate
1. Claimants in the State-Defined Comparison Group
a.
Number Who Established a UI Benefit Year in the Report Quarter
c1
b.
Total Weeks Compensated
c2
c.
Total Benefits Paid
c3
d.
Number of Disqualifications
c4
e.
Number Exhausting Benefits
c5
f.
Number Reemployed
c6
g.
Average Weeks to Date of Reemployment
c7
h.
Amount of Overpayments Established
c8
2. Claimants Scheduled for at Least one REA During the Benefit Year
a.
Number Who Established a UI Benefit Year in the Report Quarter
c9
b.
Total Weeks Compensated
c10
c.
Total Benefits Paid
c11
d.
Number of Disqualifications
c12
e.
Number Exhausting
c13
f.
Number Reemployed
c14
g.
Average Weeks to Date of Reemployment
c15
h.
Amount of Overpayments Established
c16
Comments:
A−68
Appendix A
TABLE arui1
ETA UI1 - UI STAFF HOURS
STATE
REGION
REPORT FOR PERIOD ENDING
st
g_states.region
rptdate
ANNUAL HOURS PER STAFF YEAR AND QUARTERLY DISTRIBUTION
Hours Worked
c11
c12
c13
c14
c15
Hours Paid
c16
c17
c18
c19
c20
Comments:
A−69
Appendix A
TABLE arui3
ETA UI3 – REGULAR
STATE
REGION
REPORT FOR PERIOD ENDING
st
g_states.region
rptdate
VERSION:
c19
C20
ALREADY PAID?
SECTION A: UI PROGRAM STAFF-YEAR USAGE
SYW
SYP
YEAR TO
DATE
SYP
QUARTER
PROGRAM CATEGORY
1.
Claims Activities
c1
c2
c3
2.
Employer Activities
c4
c5
c6
3.
Quality Control
c7
c8
c9
4.
Support/AS&T
c10
c11
c12
5.
Trade
c13
c14
c15
6.
Other
c16
c17
c18
7.
Total Staff Years
c46
c47
c48
SECTION B: REGULAR CONTINGENCY ENTITLEMENT CERTIFICATION
Standard Hours: Quarterly
c49 Year to Date:
CLAIMS ACTIVITY
c50
Yearly:
c51
TOTAL WORKLOAD MPU SY WORKED/EARNED
8.
Initial Claims, Reg+EB+STC
c52
9.
Initial Claims, Third Tier
c24
10. Weeks Claimed, Reg+EB+STC
c55
11. Weeks Claimed, Third Tier
c26
12. Nonmon. Dets., Reg+EB+STC
c62
13. Nonmon. Dets., Third Tier
c29
A−70
c23
c53
c54
c25
c56
c57
c28
c63
c64
Appendix A
TABLE arui3 (cont’d)
ETA UI3 – REGULAR
14. Appeals, Reg+EB+STC
c65
c30
15. Appeals, Third Tier
c31
16. Appeals, Inter. Taken
c32
20.0
c68
17. Interstate Referrals
c82
15.0
c83
18. Appeals, Multi. Decisions
c35
19. Monetary Redeterminations
c71
c72
c73
20. SAVE
c44
c45
c74
c67
c36
c75
21. Total Staff years Worked/Earned (Lines 1 through 13)
22. Entitlement SY Worked, (Lines 14 - Base)
c66
c76
c77
23. Entitlement SY Paid, (Line 15 X Exper. Lv.)
c38
c78
24. PS/PB $ rate, Line 16 X
c39
c79
25. Support, Line 17 X
c40
c80
26. Other $ (Specify)
c41
27. Total Dollar costs, (Lines 17 + 18 + 19)
c81
28. Advance
c42
29. Net Dollar Entitlement (Lines 20 - 21)
c43
Comments:
A−71
Appendix A
TABLE abui3
ETA UI3 - ADDITIONAL BENEFITS
STATE
st
REGION
REPORT FOR PERIOD ENDING
g_states.region
rptdate
VERSION: c10
ALREADY PAID? c30
ABOVE BASE CLAIMS WORKLOAD CERTIFICATION fOR ADDITIONAL BENEFITS
Standard Hours: Quarterly c18
CLAIMS ACTIVITY
Year to Date c19
Yearly c20
TOTAL WORKLOAD
MPU
SY WORKED/EARNED
1.
Initial Claims
c1
c2
c21
2.
Weeks Claimed
c3
c4
c22
3.
Nonmonetary Determinations
c5
c6
c23
4.
Appeals
c7
c8
c24
5.
Monetary Redeterminations
c16
c17
c25
6.
Other Staff Years (Specify)
c9
7.
Total Staff Years Worked = Sum of Lines 1 thru 6
c26
COMPUTATION OF NET DOLLAR ENTITLEMENT
STATE REQUEST
8.
Exper. Leave (1.17)X Line 6
c11
c27
9.
PS/PB $ rate (16,024) X Line 8
c12
c28
10.
Support (19)% X Line 9
c13
c29
11.
Other $ (Explain in comments)
c14
12.
Total Dollar costs, Lines 9 + 10 + 11
c15
Comments:
A−72
Appendix A
TABLE asui3
ETA UI3 – SAVE
STATE
REGION
st
REPORT FOR PERIOD ENDING
g_states.region
VERSION:
c17
rptdate
ALREADY PAID?
c18
ABOVE BASE CLAIMS WORKLOAD CERTIFICATION FOR SAVE
Standard Hours: Quarterly c9
CLAIMS ACTIVITY
Year to Date c10
Yearly c11
TOTAL WORKLOAD
MPU
SY WORKED/EARNED
c1
c2
12
1.
Initial Claims
2.
Other Staff Years (Specify)
c3
3.
Total Staff Years Worked = Line 1 + Line 2
c13
COMPUTATION OF NET DOLLAR ENTITLEMENT
STATE REQUEST
4.
Exper. Leave (1.259) X Line 3
c14
5.
PS/PB $ rate (14,844) X Line 4
c15
6.
Support (19)% X Line 5
c16
7.
Other $ (Explain in comments)
c7
8.
Total Dollar costs, Lines 5 + 6 + 7
c8
Comments:
A−73
Appendix A
TABLE atui3
ETA UI3 - TRADE
STATE
st
REGION
REPORT FOR PERIOD ENDING
g_states.region
rptdate
VERSION: c10
ALREADY PAID? c30
ABOVE BASE CLAIMS WORKLOAD CERTIFICATION FOR TRADE
Standard Hours: Quarterly c18
CLAIMS ACTIVITY
Year to Date c19
Yearly c20
TOTAL WORKLOAD
MPU
SY WORKED/EARNED
1.
Initial Claims
c1
c2
c21
2.
Weeks Claimed
c3
c4
c22
3.
Nonmonetary Determinations
c5
c6
c23
4.
Appeals
c7
c8
c24
5.
Trade Redeterminations
c16
c17
c25
6.
Other Staff Years (Specify)
c9
7.
Total Staff Years Worked = Sum of Lines 1 thru 6
c26
COMPUTATION OF NET DOLLAR ENTITLEMENT
STATE REQUEST
8.
Exper. Leave (c11) X Line 6
c27
9.
PS/PB $ rate (c12) X Line 8
c28
10.
Support (c13)% X Line 9
c29
11.
Other $ (Explain in comments)
c14
12.
Total Dollar costs, Lines 9 + 10 + 11
c15
Comments:
A−74
Appendix A
TABLE arquick
Quick Response Report
STATE
REPORT DATE
st
Item 1:
Item 2:
Item 3:
Item 4:
Item 5:
Item 6:
Item 7:
Item 8:
Item 9:
Item 10:
Item 11:
Item 12:
rptdate
c1
c2
c3
c4
c5
c6
c7
c8
c9
c10
c11
c12
A−75
Appendix A
TABLE g_agency
FEDERAL AGENCIES USED WITH THE ETA REPORTS
Agency Code
Agency Type (UCFE/UCX)
Name Of Agency
Active Agency
code
agency_type
title
flag
(flag - 0 for active, 1 for abolished at least three years ago so activity is questionable)
A−76
Appendix A
TABLE All Comments Table
Report Date
State
First line of Comments
Second line of Comments
Third line of Comments
Fourth line of Comments
rptdate
st
cmline1
cmline2
cmline3
cmline4
Most data tables have associated comment tables. The names of the tables use the
same designation as the data table but with a "cm" suffix
A−77
Appendix A
This page is intentionally left blank
A−78
Appendix B
APPENDIX B: ASCII File Format Specifications
While the Unemployment Insurance Electronic Entry System allows for manual entry of data into
screen formats, it also allows users to upload a file containing data which was created on a
mainframe, PC or elsewhere. As long as the file conforms to the specifications shown below for
the given table and passes edits, the system will accept it. Following each UI report table name is
a list of expected data cells. The cell names are the same as those appearing on the report's table
and match those displayed in the manual entry screens though the ordering may be different. Do
not use leading zeros or commas in the entries. The five data types the system will accept: date,
smallint, integer, decimal, and character (char).
The date type is a numeric field in the form of mmddyyyy. The month, day, and year
components of the date field can be separated by slash (/), dash (-), or nothing. Each date
component must be a legitimate date (no month 13). When it is loaded into the entry system,
other edits will check that it is a legitimate date for the specified report.
The smallint data type is a numeric field with a permitted range of -32,768 to +32,768.
The integer data type has a permitted range of -2,147,483,648 to +2,147,483,648.
The decimal field is represented by decimal(m,n), where m is <=32 significant digits (the
precision) and n represents the number of digits to the right of the decimal point (the scale).
The decimal data type is a numeric field with a range up to 32 significant digits with exponents
in the range of -128 to +126. The decimal point must be included in the upload file.
Character is a letter or number represented by char(n), where n stands for the length of the
character field.
The first line of the ASCII file must contain the related report date.
EXCEPTIONS:
ETA 191. This report is different from the others because it is stored in two tables but uses only
one upload file. The data for Section B of the report follows immediately after the Section A data.
Section B consists of agency codes (c1) and expenditures for that agency (c2). As many pairs of c1
and c2 will be used as is necessary to record the data as indicated by the * shown in the file
specifications.
ETA 204. This report is also stored in multiple tables. The data for Sections A and B are on one
table and follow the general rules. The data for Section C is stored on one of two different tables
depending if the data represent a state with a benefit ratio system (ar204b) or a reserve ratio system
B-1
Appendix B
(ar204r) of taxing. Section C consists of reporting six elements, one on each line of the ASCII file,
and repeating these six elements for each category associated with the specific taxing system.
ETA 9056 and ETA 9057 Skeleton-Load File Layouts. The ETA 9056 and ETA 9057 reports are
also different because they require a subset of data (that is, skeleton data) loaded and verified
before the rest of the data may be entered. The following are the file layouts for skeleton data for
these reports. As the tables below show, the files must have at least two lines, each ending with a
carriage return. The data elements of each line are delimited by space.
Line 1. Contains the quarter end date of the quarter to which the data applies, followed by a space
and then the database table name, either ar9056 or ar9057 as appropriate.
Line 2 and all subsequent lines. Each line contains all the skeleton fields pertaining to a single
case in the quality sample for the appropriate report delimited by a space with a carriage return at
the end of each line.
Table: ar9056
Line 1
rptdate
rptname
Line 2
c1
Case ID
decimal (5,0)
c2
Issue Code
Char(2)
c10
Week End
Date
(mmddyyyy)
c24
Determination Date
(mmddyyyy)
Example: 12311996 ar9056
103 10 y 08311996 09061996
104 20 n 08311996 09061996
105 40 n 08311996 09061996
Table: ar9057
Line 1
rptdate
rptname
Line 2
c1
Case ID
decimal(5,0)
c35
Decision Date
(mmddyyyy)
Example: 12311996 ar9057
8 08311996 UT12345612a
9 08311996 UT12345612b
10 08311996 UT12345613a
B-2
c39
Case Docket Number
char(12)
Appendix B
TABLE ar191
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
trans_id char(8)
c1 decimal(12,2)
c2 decimal(12,2)
c3 decimal(12,2)
c4 decimal(12,2)
c5 decimal(12,2)
c6 decimal(12,2)
c7 decimal(12,2)
c8 decimal(12,2)
c9 decimal(12,2)
c10 decimal(12,2)
c11 decimal(12,2)
c12 decimal(12,2)
c13 decimal(12,2)
c14 decimal(12,2)
c15 decimal(12,2)
c16 decimal(12,2)
c17 decimal(12,2)
c18 decimal(12,2)
TABLE ar191sb
st char(2)
rptdate date
c1 char(3)
c2 decimal(12,2)
B-3
Appendix B
TABLE ar203
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
c1 char(1)
c2 integer
c3 integer
c4 integer
c12 integer
c13 integer
c14 integer
c15 integer
c16 integer
c17 integer
c18 integer
c19 integer
c20 integer
c40 integer
c41 integer
c42 integer
c43 integer
c44 integer
c45 integer
c46 integer
c47 integer
c48 integer
c49 integer
c50 integer
c51 integer
c52 integer
c53 integer
c54 integer
c55 integer
c56 integer
c57 integer
c58 integer
c59 integer
c60 integer
c61 integer
c62 integer
c63 integer
c64 integer
c65 integer
c66 integer
c67 integer
c68 integer
c69 integer
c70 integer
c71 integer
c72 integer
c73 integer
c74 integer
c75 integer
c76 integer
c77 integer
c78 integer
c79 integer
c80 integer
c81 integer
c82 integer
c83 integer
c84 integer
c85 integer
c86 integer
c87 integer
c88 integer
c89 integer
c90 integer
c91 integer
c92 integer
c93 integer
B-4
Appendix B
TABLE ar204
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
trans_id char(8)
c1 date
c2 date
c3 char(2)
c4 date
c5 date
c6 integer
c7 decimal(13,0)
c8 decimal(13,0)
c9 integer
c10 decimal(13,0)
c11 decimal(13,0)
c12 integer
c13 decimal(12,0)
c14 decimal(12,0)
c15 smallint
c16 decimal(13,0)
c17 integer
c18 decimal(13,0)
c19 decimal(13,0)
c20 integer
c21 decimal(13,0)
c22 decimal(13,0)
c23 integer
c24 decimal(12,0)
c25 decimal(12,0)
c26 integer
c27 decimal(13,0)
c28 decimal(12,0)
c29 integer
c30 decimal(13,0)
c31 decimal(12,0)
c32 smallint
c33 decimal(11,0)
c34 decimal(11,0)
c35 date
c36 decimal(13,2)
c37 decimal(13,2)
c38 decimal(13,2)
c39 decimal(13,2)
c40 decimal(12,2)
c41 decimal(12,2)
c42 decimal(12,2)
c43 decimal(12,2)
c44 decimal(11,2)
TABLE ar204b
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
trans_id char(8)
c1 decimal(4,1)
c2 decimal(5,2)
c3 integer
c4 decimal(14,0)
c5 decimal(14,0)
c6 integer
c7 integer
B-5
TABLE ar204r
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
trans_id char(8)
c1 decimal(4,1)
c2 decimal(5,2)
c3 integer
c4 decimal(14,0)
c5 decimal(14,0)
c6 integer
c7 integer
Appendix B
TABLE arertx
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
c1 decimal(4,2)
c2 decimal(4,2)
B-6
Appendix B
TABLE ar207
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
est char(1)
c1 integer
c2 integer
c3 integer
c4 integer
c5 integer
c6 integer
c7 integer
c8 integer
c9 integer
c10 integer
c11 integer
c12 integer
c13 integer
c14 integer
c15 integer
c16 integer
c17 integer
c18 integer
c19 integer
c20 integer
c21 integer
c22 integer
c23 integer
c24 integer
c25 integer
c26 integer
c27 integer
c28 integer
c29 integer
c30 integer
c31 integer
c32 integer
c33 integer
c34 integer
c35 integer
c36 integer
c37 integer
c38 integer
c39 integer
c40 integer
c41 integer
c42 integer
c43 integer
c44 integer
c45 integer
c46 integer
TABLE ae207
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
c1 integer
c2 integer
c3 integer
c4 integer
c5 integer
c6 integer
c7 integer
c8 integer
c9 integer
c10 integer
c11 integer
c12 integer
c13 integer
c14 integer
c15 integer
B-7
c16 integer
c17 integer
c18 integer
c19 integer
c20 integer
c21 integer
c22 integer
TABLE at207
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
c1 integer
c2 integer
c3 integer
c4 integer
c5 integer
c6 integer
c7 integer
c8 integer
c9 integer
c10 integer
c11 integer
c12 integer
c13 integer
c14 integer
c15 integer
c16 integer
c17 integer
c18 integer
c19 integer
c20 integer
c21 integer
c22 integer
Appendix B
c30 integer
c31 integer
c32 integer
c33 integer
c34 integer
c35 integer
c36 decimal(4,1)
TABLE ar218
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
trans_id char(8)
est char(1)
c1 integer
c2 integer
c3 integer
c4 integer
c5 integer
c6 integer
c9 integer
c10 integer
c11 integer
c12 integer
c13 integer
c14 integer
c15 integer
c16 integer
c17 integer
c18 integer
c19 integer
c20 integer
c21 integer
c22 integer
c23 integer
c24 integer
c25 integer
c26 integer
c27 integer
c28 integer
c29 decimal(4,1)
TABLE ae218
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
c1 integer
c2 integer
c3 integer
TABLE at218
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
c1 integer
c2 integer
c3 integer
B-8
Appendix B
TABLE ar227
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
c1 integer
c2 integer
c3 integer
c4 integer
c5 integer
c6 integer
c7 integer
c8 integer
c9 integer
c10 integer
c11 integer
c12 integer
c13 integer
c14 integer
c15 integer
c16 integer
c17 integer
c18 integer
c19 integer
c20 integer
c21 integer
c22 integer
c23 integer
c24 integer
c25 integer
c26 integer
c27 integer
c28 integer
c29 integer
c30 integer
c31 integer
c32 integer
c33 integer
c34 integer
c35 integer
c36 integer
c37 integer
c38 integer
c39 integer
c40 integer
c41 integer
c42 integer
c43 integer
c44 integer
c45 integer
c46 integer
c49 integer
c50 integer
c55 integer
c56 integer
c57 integer
c58 integer
c59 integer
c60 integer
c61 integer
c62 integer
c67 integer
c68 integer
c69 integer
c70 integer
c71 integer
c72 integer
c73 integer
c74 integer
c75 integer
c76 integer
c77 integer
c78 integer
c79 integer
c116 integer
B-9
c117 integer
c118 integer
c119 integer
c131 integer
c132 integer
c133 integer
c134 integer
c135 integer
c136 integer
c137 integer
c138 integer
c139 integer
c140 integer
c141 integer
c142 integer
c143 integer
c144 integer
c145 integer
c146 integer
c147 integer
c148 integer
c149 integer
c150 integer
c159 integer
c160 integer
c161 integer
c162 integer
c163 integer
c164 integer
c165 integer
c166 integer
c169 integer
c170 integer
c171 integer
c172 integer
c173 integer
c174 integer
c175 integer
c176 integer
c177 integer
Appendix B
TABLE ar227 cont’d
c178 integer
c179 integer
c180 integer
c181 integer
c182 integer
c183 integer
c184 integer
c185 integer
c186 integer
c187 integer
c188 integer
c189 integer
c190 integer
c191 integer
c192 integer
c193 integer
c194 integer
c195 integer
c196 integer
c197 integer
c198 integer
c199 integer
c200 integer
c201 integer
c202 integer
c203 integer
c204 integer
c205 integer
c206 integer
c207 integer
c208 integer
c209 integer
c210 integer
c211 integer
c212 integer
c213 integer
c214 integer
c215 integer
c216 integer
c217 integer
c218 integer
c219 integer
c220 integer
c221 integer
c222 integer
c223 integer
c224 integer
c225 integer
c230 integer
c231 integer
c232 integer
c233 integer
B-10
Appendix B
TABLE at227
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
c1 integer
c2 integer
c3 integer
c4 integer
c5 integer
c6 integer
c7 integer
c8 integer
c9 integer
c10 integer
c11 integer
c12 integer
c13 integer
c14 integer
c15 integer
c16 integer
c17 integer
c18 integer
c19 integer
c20 integer
c21 integer
c22 integer
c23 integer
c24 integer
c25 integer
c26 integer
c27 integer
c28 integer
c29 integer
c30 integer
c31 integer
c32 integer
c33 integer
c34 integer
c35 integer
c36 integer
c37 integer
c38 integer
c39 integer
c40 integer
c41 integer
c42 integer
c43 integer
c44 integer
c45 integer
c46 integer
c49 integer
c50 integer
c55 integer
c56 integer
c57 integer
c58 integer
c59 integer
c60 integer
c61 integer
c62 integer
c67 integer
c68 integer
c69 integer
c70 integer
c71 integer
c72 integer
c73 integer
c74 integer
c75 integer
c76 integer
c77 integer
c78 integer
c79 integer
c116 integer
B-11
c117 integer
c118 integer
c119 integer
c131 integer
c132 integer
c133 integer
c134 integer
c135 integer
c136 integer
c137 integer
c138 integer
c139 integer
c140 integer
c141 integer
c142 integer
c143 integer
c144 integer
c145 integer
c146 integer
c147 integer
c148 integer
c149 integer
c150 integer
c159 integer
c160 integer
c161 integer
c162 integer
c163 integer
c164 integer
c165 integer
c166 integer
c169 integer
c170 integer
c171 integer
c172 integer
c173 integer
c174 integer
c175 integer
c176 integer
c177 integer
Appendix B
TABLE at227 cont’d
c178 integer
c179 integer
c180 integer
c181 integer
c182 integer
c183 integer
c184 integer
c185 integer
c186 integer
c187 integer
c188 integer
c189 integer
c190 integer
c191 integer
c192 integer
c193 integer
c194 integer
c195 integer
c196 integer
c197 integer
c198 integer
c199 integer
c200 integer
c201 integer
c202 integer
c203 integer
c204 integer
c205 integer
c206 integer
c207 integer
c208 integer
c209 integer
c210 integer
c211 integer
c212 integer
c213 integer
c214 integer
c215 integer
c216 integer
c217 integer
c218 integer
c219 integer
c220 integer
c221 integer
c222 integer
c223 integer
c224 integer
c225 integer
c230 integer
c231 integer
c232 integer
c233 integer
B-12
Appendix B
TABLE ar2112
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
trans_id char(8)
c1 decimal(14,2)
c2 decimal(14,2)
c3 decimal(14,2)
c4 decimal(14,2)
c5 decimal(14,2)
c6 decimal(14,2)
c7 decimal(14,2)
c8 decimal(14,2)
c9 decimal(14,2)
c10 decimal(14,2)
c11 decimal(14,2)
c12 decimal(14,2)
c13 decimal(14,2)
c14 decimal(14,2)
c15 decimal(14,2)
c16 decimal(14,2)
c17 decimal(14,2)
c19 decimal(14,2)
c20 decimal(14,2)
c21 decimal(14,2)
c22 decimal(14,2)
c23 decimal(14,2)
c24 decimal(14,2)
c25 decimal(14,2)
c26 decimal(14,2)
c27 decimal(14,2)
c28 decimal(14,2)
c29 decimal(14,2)
c30 decimal(14,2)
c31 decimal(14,2)
c32 decimal(14,2)
c33 decimal(14,2)
c34 decimal(14,2)
c35 decimal(14,2)
c36 decimal(14,2)
c37 decimal(14,2)
c38 decimal(14,2)
c39 decimal(14,2)
c40 decimal(14,2)
c41 decimal(14,2)
c42 decimal(14,2)
c43 decimal(14,2)
c44 decimal(14,2)
c45 decimal(14,2)
c46 decimal(14,2)
c47 decimal(14,2)
c48 decimal(14,2)
c49 decimal(14,2)
c50 decimal(14,2)
c51 decimal(14,2)
c52 decimal(14,2)
c53 decimal(14,2)
c54 decimal(14,2)
c55 decimal(14,2)
c56 decimal(14,2)
c57 decimal(14,2)
c58 decimal(14,2)
c59 decimal(14,2)
c60 decimal(14,2)
c61 decimal(14,2)
c62 decimal(14,2)
c63 decimal(14,2)
c64 decimal(14,2)
c65 decimal(14,2)
c66 decimal(14,2)
c67 decimal(14,2)
c68 decimal(14,2)
c69 decimal(14,2)
c70 decimal(14,2)
c71 decimal(14,2)
c72 decimal(14,2)
c73 decimal(14,2)
c74 decimal(14,2)
B-13
c75 decimal(14,2)
c76 decimal(14,2)
c77 decimal(14,2)
c78 decimal(14,2)
c79 decimal(14,2)
c81 decimal(14,2)
c82 decimal(14,2)
c83 decimal(14,2)
c84 decimal(14,2)
c85 decimal(14,2)
c86 decimal(14,2)
c87 decimal(14,2)
c88 decimal(14,2)
c89 decimal(14,2)
c90 decimal(14,2)
c91 decimal(14,2)
c92 decimal(14,2)
c93 decimal(14,2)
c94 decimal(14,2)
c95 decimal(14,2)
c96 decimal(14,2)
c97 decimal(14,2)
c98 decimal(14,2)
c99 decimal(14,2)
c100 decimal(14,2)
c101 decimal(14,2)
c102 decimal(14,2)
c103 decimal(14,2)
c104 decimal(14,2)
c105 decimal(14,2)
c106 decimal(14,2)
c107 decimal(14,2)
c108 decimal(14,2)
c109 decimal(14,2)
c110 decimal(14,2)
c111 decimal(14,2)
c112 decimal(14,2)
c113 decimal(14,2)
c114 decimal(14,2)
c115 decimal(14,2)
Appendix B
TABLE ac2112
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
c1 decimal(11,2)
c2 decimal(11,2)
c3 decimal(11,2)
c4 decimal(11,2)
c5 decimal(11,2)
c6 decimal(11,2)
c7 decimal(11,2)
B-14
Appendix B
TABLE ar538
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
c1 smallint
c2 date
c3 integer
c4 integer
c5 integer
B-15
Appendix B
TABLE ar539
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
c1 smallint
c2 date
c3 integer
c4 integer
c5 smallint
c6 integer
c7 smallint
c8 integer
c9 integer
c10 integer
c11 integer
c12 smallint
c13 integer
c14 integer
c15 integer
c16 integer
c17 integer
c18 integer
c19 decimal(6,2)
c20 decimal(7,3)
c21 decimal(8,2)
c22 char(1)
c23 date
B-16
Appendix B
TABLE ar581
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
est char(1)
c1 integer
c2 integer
c3 integer
c4 date
c11 integer
c13a integer
c13b integer
c14a integer
c14 integer
c15 integer
c16 integer
c17 integer
c18 integer
c19a integer
c19 integer
c20 integer
c21 integer
c22 integer
c23 integer
c24 integer
c25b integer
c25a integer
c26a integer
c28a integer
c29a integer
c37a decimal(11,0)
c38a integer
c39a integer
c40a integer
c41a integer
c42a integer
c43 integer
c44 integer
c45 integer
c46 integer
c47 integer
c48 integer
c49 integer
c50 integer
c51 integer
c52 integer
c53 integer
c54 integer
c55 integer
c56 integer
c57 integer
c58 integer
c59 integer
c60 integer
c61 integer
c62 integer
c63 integer
c64 integer
c65 integer
c66 decimal(11,0)
c67 decimal(11,0)
c68 integer
c69 integer
B-17
Appendix B
TABLE ar586
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
trans_id char(8)
est char(1)
c1 smallint
c2 smallint
c3 smallint
c4 integer
c5 integer
c6 smallint
c7 smallint
c8 smallint
c9 smallint
c10 integer
c25 smallint
c26 smallint
c31 integer
c32 integer
c33 smallint
c34 integer
c35 smallint
c36 smallint
c37 smallint
c38 smallint
c39 smallint
c40 smallint
c41 smallint
c42 smallint
c43 smallint
c44 smallint
c45 smallint
c46 smallint
c47 smallint
c48 smallint
c49 smallint
c50 smallint
c51 smallint
c52 smallint
c53 smallint
c54 smallint
c55 smallint
c56 smallint
c57 smallint
c58 smallint
c59 smallint
c60 smallint
c61 smallint
c62 smallint
c63 smallint
c64 smallint
c65 smallint
c66 smallint
c67 smallint
c68 smallint
c69 smallint
c70 smallint
c71 smallint
c72 smallint
c73 smallint
c74 smallint
c75 smallint
c76 smallint
c77 smallint
c78 smallint
c79 smallint
c80 smallint
c81 smallint
c82 smallint
c83 smallint
c84 smallint
c85 smallint
B-18
Appendix B
TABLE ar5130
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
trans_id char(8)
est char(1)
c1 smallint
c2 smallint
c3 smallint
c4 smallint
c5 smallint
c6 smallint
c7 smallint
c9 smallint
c10 smallint
c11 integer
c12 integer
c13 integer
c14 smallint
c15 integer
c16 integer
c51 integer
c52 smallint
c53 integer
c54 smallint
c55 smallint
c56 smallint
c57 smallint
c58 smallint
c59 smallint
c60 smallint
c61 smallint
c62 smallint
c63 smallint
c64 smallint
c65 smallint
c66 smallint
c67 integer
c68 smallint
c69 smallint
c70 smallint
c71 smallint
c72 smallint
c73 smallint
TABLE ae5130
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
trans_id char(8)
c1 smallint
c2 smallint
c3 smallint
c4 smallint
c5 smallint
c6 smallint
c7 smallint
c9 smallint
c10 smallint
c11 integer
c12 integer
c13 integer
c14 smallint
c15 integer
c16 integer
c51 integer
c52 smallint
c53 integer
B-19
c54 smallint
c55 smallint
c56 smallint
c57 smallint
c58 smallint
c59 smallint
c60 smallint
c61 smallint
c62 smallint
c63 smallint
c64 smallint
c65 smallint
c66 smallint
c67 smallint
c68 smallint
c69 smallint
c70 smallint
c71 smallint
c72 smallint
c73 smallint
TABLE at5130
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
trans_id char(8)
c1 smallint
c2 smallint
c3 smallint
c4 smallint
c5 smallint
c6 smallint
c7 smallint
c9 smallint
c10 smallint
c11 integer
c12 integer
c13 integer
c14 smallint
c15 integer
c16 integer
c51 integer
c52 smallint
c53 integer
c54 smallint
c55 smallint
c56 smallint
c57 smallint
c58 smallint
c59 smallint
c60 smallint
c61 smallint
c62 smallint
c63 smallint
c64 smallint
c65 smallint
c66 smallint
c67 smallint
c68 smallint
c69 smallint
c70 smallint
c71 smallint
c72 smallint
c73 smallint
Appendix B
TABLE ar5159
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
trans_id char(8)
est char(1)
c1 integer
c2 integer
c3 integer
c4 smallint
c5 integer
c6 integer
c7 smallint
c8 smallint
c9 smallint
c10 smallint
c11 smallint
c12 smallint
c13 smallint
c14 smallint
c15 smallint
c16 smallint
c17 smallint
c18 smallint
c19 integer
c20 smallint
c21 integer
c22 integer
c24 integer
c25 smallint
c26 smallint
c27 integer
c28 integer
c30 integer
c31 integer
c32 integer
c33 integer
c34 integer
c36 integer
c38 integer
c39 integer
c40 integer
c41 integer
c42 integer
c43 integer
c45 integer
c46 integer
c47 integer
c48 integer
c49 integer
c50 integer
c51 integer
c52 integer
c53 integer
c54 smallint
c55 integer
c56 integer
c57 smallint
c58 smallint
c94 smallint
c95 integer
c96 integer
c97 smallint
c98 smallint
c99 smallint
TABLE ae5159
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
B-20
user_id char(8)
trans_id char(8)
c1 integer
c2 integer
c3 integer
c4 integer
c5 integer
c6 integer
c7 integer
c8 integer
c9 integer
c10 integer
c11 smallint
c12 integer
c13 integer
c15 integer
c16 integer
c17 smallint
c18 integer
c19 integer
c21 integer
c22 integer
c23 smallint
c24 integer
c25 integer
c27 integer
c29 integer
c30 integer
c31 integer
c32 integer
c33 integer
c35 integer
c36 integer
c37 integer
c38 integer
c39 integer
c40 integer
c41 smallint
c42 smallint
c43 integer
c44 integer
c45 integer
c46 integer
Appendix B
TABLE ae5159 cont’d
c46 integer
c47 integer
c48 integer
c49 smallint
c50 smallint
c51 smallint
TABLE at5159
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
trans_id char(8)
c1 integer
c2 integer
c3 integer
c4 integer
c5 integer
c6 integer
c7 integer
c8 integer
c9 integer
c10 integer
c11 smallint
c12 integer
c13 integer
c15 integer
c16 integer
c17 smallint
c18 integer
c19 integer
c21 integer
c22 integer
c23 smallint
c24 integer
c25 integer
c27 integer
c29 integer
c30 integer
c31 integer
c32 integer
c33 integer
c35 integer
c36 integer
c37 integer
c38 integer
c39 integer
c40 integer
c41 smallint
c42 smallint
c43 integer
c44 integer
c45 integer
c46 integer
c47 integer
c48 integer
c49 smallint
c50 smallint
c51 smallint
B-21
TABLE aw5159
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
c1 smallint
c2 integer
c3 integer
c4 integer
c5 integer
c6 smallint
c7 integer
c8 smallint
c9 integer
Appendix B
TABLE ar8401
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
c1 decimal(5,0)
c2 char(30)
c3 char(20)
c4 char(1)
c5 decimal(13,0)
c6 decimal(12,0)
c7 decimal(12,0)
c8 decimal(13,0)
c9 decimal(12,0)
c10 decimal(6,2)
c11 decimal(12,0)
c12 decimal(12,0)
c13 decimal(12,0)
c14 decimal(12,0)
c15 decimal(12,0)
c16 decimal(12,0)
c17 decimal(12,0)
c18 decimal(15,0)
B-22
Appendix B
TABLE ar8405
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
c1 decimal(5,0)
c2 char(30)
c3 char(20)
c4 char(1)
c5 decimal(13,0)
c6 decimal(12,0)
c7 decimal(12,0)
c8 decimal(12,0)
c9 decimal(13,0)
c10 decimal(12,0)
c11 decimal(6,2)
c12 decimal(12,0)
c13 decimal(12,0)
c14 decimal(12,0)
c15 decimal(12,0)
c16 decimal(15,0)
B-23
Appendix B
TABLE ar8413
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
c1 decimal(5,0)
c2 char(30)
c3 char(20)
c4 decimal(12,0)
c5 decimal(12,0)
c6 decimal(12,0)
c7 decimal(13,0)
c8 decimal(13,0)
c9 decimal(12,0)
c10 decimal(12,0)
c11 decimal(12,0)
c12 decimal(5,3)
c13 decimal(12,0)
c14 decimal(12,0)
c15 decimal(5,3)
c16 decimal(12,0)
c17 integer
c18 decimal(10,4)
c19 decimal(12,0)
c20 integer
c21 decimal(10,4)
c22 decimal(12,0)
c23 integer
c24 decimal(10,4)
c25 decimal(12,0)
c26 integer
c27 decimal(10,4)
c28 decimal(12,0)
c29 decimal(12,0)
c30 decimal(12,0)
c31 decimal(12,0)
c32 decimal(12,0)
c33 decimal(12,0)
B-24
Appendix B
TABLE ar8414
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
c1 decimal(5,0)
c2 char(30)
c3 char(20)
c4 decimal(13,0)
c5 decimal(12,0)
c6 decimal(12,0)
c7 decimal(13,0)
c8 decimal(13,0)
c9 decimal(12,0)
c10 decimal(12,0)
c11 decimal(12,0)
c12 decimal(5,3)
c13 decimal(12,0)
c14 decimal(12,0)
c15 decimal(5,3)
c16 decimal(12,0)
c17 integer
c18 decimal(10,4)
c19 decimal(12,0)
c20 integer
c21 decimal(10,4)
c22 decimal(12,0)
c23 integer
c24 decimal(10,4)
c25 decimal(12,0)
c26 integer
c27 decimal(10,4)
c28 decimal(12,0)
c29 integer
c30 decimal(10,4)
c31 decimal(12
c32 decimal(12
c33 decimal(12
c34 decimal(12
c35 decimal(12
c36 decimal(12
B-25
Appendix B
TABLE ar902
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
trans_id char(8)
c1 integer
c2 date
c3 date
c4 integer
c5 integer
c6 integer
c17 integer
c21 integer
c22 integer
c23 integer
c33 integer
c34 integer
c35 integer
c45 integer
c46 integer
c49 integer
c50 integer
c51 integer
c53 integer
c54 integer
c55 integer
c57 integer
c58 integer
c59 integer
c60 integer
c61 integer
c62 integer
c63 integer
c64 integer
c65 integer
c66 integer
c67 integer
c68 integer
c69 char(1)
B-26
Appendix B
TABLE ar9000
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
c1 smallint
c2 smallint
c3 integer
c4 integer
c5 smallint
c6 smallint
c7 smallint
c8 smallint
c9 integer
c10 integer
c11 smallint
c12 smallint
c13 smallint
c14 smallint
c15 integer
c16 integer
c17 smallint
c18 smallint
c19 smallint
c20 smallint
c21 integer
c22 integer
c23 smallint
c24 smallint
c25 smallint
c26 smallint
c27 integer
c28 integer
c29 smallint
c30 smallint
c31 smallint
c32 smallint
c33 integer
c34 integer
c35 smallint
c36 smallint
c37 smallint
c38 smallint
c39 integer
c40 integer
c41 smallint
c42 smallint
c43 smallint
c44 smallint
c45 integer
c46 integer
c47 smallint
c48 smallint
c49 smallint
c50 smallint
c51 integer
c52 integer
c53 smallint
c54 smallint
c55 smallint
c56 smallint
c57 integer
c58 integer
c59 smallint
c60 smallint
c61 smallint
c62 smallint
c63 integer
c64 integer
c65 smallint
c66 smallint
c67 smallint
c68 smallint
c69 integer
c70 integer
B-27
c71 smallint
c72 smallint
c73 smallint
c74 smallint
c75 integer
c76 integer
c77 smallint
c78 smallint
c79 smallint
c80 smallint
c81 integer
c82 integer
c83 smallint
c84 smallint
c85 smallint
c86 smallint
c87 integer
c88 integer
c89 smallint
c90 smallint
c91 smallint
c92 smallint
c93 integer
c94 integer
c95 smallint
c96 smallint
c97 smallint
c98 smallint
c99 integer
c100 integer
c101 smallint
c102 smallint
c103 smallint
c104 smallint
c105 integer
c106 integer
c107 smallint
c108 smallint
c109 smallint
c110 smallint
Appendix B
TABLE ar9000 cont’d
c111 integer
c112 integer
c113 smallint
c114 smallint
c115 smallint
c116 smallint
c117 integer
c118 integer
c119 smallint
c120 smallint
c121 smallint
c122 smallint
c123 integer
c124 integer
c125 smallint
c126 smallint
c127 smallint
c128 smallint
c129 integer
c130 integer
c131 smallint
c132 smallint
c133 smallint
c134 smallint
c135 integer
c136 integer
c137 smallint
c138 smallint
c139 smallint
c140 smallint
c141 integer
c142 integer
c143 smallint
c144 smallint
c145 smallint
c146 smallint
c147 integer
c148 integer
c149 smallint
c150 smallint
c151 smallint
c152 integer
c153 smallint
c154 integer
c155 smallint
c156 integer
c157 smallint
c158 integer
c159 smallint
c160 smallint
c161 integer
c162 integer
c163 smallint
c164 smallint
c165 integer
c166 integer
c167 smallint
c168 smallint
c169 smallint
c170 smallint
c171 smallint
c172 smallint
c173 smallint
c174 smallint
c175 smallint
c176 smallint
c177 smallint
c178 smallint
c179 smallint
c180 smallint
c181 smallint
c182 smallint
c183 smallint
c184 smallint
B-28
Appendix B
TABLE ar9016
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
c1 integer
c2 integer
c3 integer
c8 smallint
c9 smallint
B-29
Appendix B
TABLE ar9047
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
trans_id char(8)
c1 integer
c2 integer
c3 integer
c4 integer
c5 integer
c6 integer
B-30
Appendix B
TABLE ar9048
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
trans_id char(8)
c1 integer
c2 integer
c3 integer
c4 integer
c5 integer
c6 integer
c7 integer
c8 integer
c9 integer
c10 integer
c11 integer
c12 integer
c13 integer
c14 integer
c15 integer
c16 integer
c17 integer
c18 integer
c19 integer
c20 integer
B-31
Appendix B
TABLE ar9049
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
trans_id char(8)
c1 integer
c2 decimal(3,1)
c3 integer
c4 integer
c5 date
c6 date
c7 date
c8 date
c9 integer
c10 integer
c11 integer
c12 integer
c13 integer
c14 integer
c15 integer
c16 integer
c17 integer
c18 integer
c19 integer
c20 integer
c21 integer
c22 integer
c23 integer
c24 integer
B-32
Appendix B
TABLE ar9050
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
trans_id char(8)
c1 integer
c2 integer
c3 smallint
c4 smallint
c5 smallint
c6 smallint
c7 smallint
c8 smallint
c9 integer
c10 integer
c11 smallint
c12 smallint
c13 smallint
c14 smallint
c15 smallint
c16 smallint
c17 integer
c18 integer
c19 smallint
c20 smallint
c21 smallint
c22 smallint
c23 smallint
c24 smallint
c25 integer
c26 integer
c27 smallint
c28 smallint
c29 smallint
c30 smallint
c31 smallint
c32 smallint
c33 integer
c34 integer
c35 smallint
c36 smallint
c37 smallint
c38 smallint
c39 smallint
c40 smallint
c41 integer
c42 integer
c43 smallint
c44 smallint
c45 smallint
c46 smallint
c47 smallint
c48 smallint
c49 integer
c50 integer
c51 smallint
c52 smallint
c53 smallint
c54 smallint
c55 smallint
c56 smallint
c57 integer
c58 integer
c59 smallint
c60 smallint
c61 smallint
c62 smallint
c63 smallint
c64 smallint
c65 integer
c66 integer
c67 smallint
c68 smallint
c69 smallint
B-33
c70 smallint
c71 smallint
c72 smallint
c73 integer
c74 integer
c75 smallint
c76 smallint
c77 smallint
c78 smallint
c79 smallint
c80 smallint
c81 integer
c82 integer
c83 smallint
c84 smallint
c85 smallint
c86 smallint
c87 smallint
c88 smallint
c89 integer
c90 integer
c91 smallint
c92 smallint
c93 smallint
c94 smallint
c95 smallint
c96 smallint
Appendix B
TABLE ar9050p
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
trans_id char(8)
c1 integer
c2 integer
c3 smallint
c4 smallint
c5 smallint
c6 smallint
c7 smallint
c8 smallint
c9 integer
c10 integer
c11 smallint
c12 smallint
c13 smallint
c14 smallint
c15 smallint
c16 smallint
c17 integer
c18 integer
c19 smallint
c20 smallint
c21 smallint
c22 smallint
c23 smallint
c24 smallint
c25 integer
c26 integer
c27 smallint
c28 smallint
c29 smallint
c30 smallint
c31 smallint
c32 smallint
c33 integer
c34 integer
c35 smallint
c36 smallint
c37 smallint
c38 smallint
c39 smallint
c40 smallint
c41 integer
c42 integer
c43 smallint
c44 smallint
c45 smallint
c46 smallint
c47 smallint
c48 smallint
c49 integer
c50 integer
c51 smallint
c52 smallint
c53 smallint
c54 smallint
c55 smallint
c56 smallint
c57 integer
c58 integer
c59 smallint
c60 smallint
c61 smallint
c62 smallint
c63 smallint
c64 smallint
c65 integer
c66 integer
c67 smallint
c68 smallint
c69 smallint
B-34
c70 smallint
c71 smallint
c72 smallint
c73 integer
c74 integer
c75 smallint
c76 smallint
c77 smallint
c78 smallint
c79 smallint
c80 smallint
c81 integer
c82 integer
c83 smallint
c84 smallint
c85 smallint
c86 smallint
c87 smallint
c88 smallint
c89 integer
c90 integer
c91 smallint
c92 smallint
c93 smallint
c94 smallint
c95 smallint
c96 smallint
Appendix B
TABLE aw9050
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
trans_id char(8)
c1 smallint
c2 smallint
c3 smallint
c4 smallint
c5 smallint
c6 smallint
c7 smallint
c8 smallint
c9 smallint
c10 smallint
c11 smallint
c12 smallint
B-35
Appendix B
TABLE ar9051
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
trans_id char(8)
c1 integer
c2 integer
c3 integer
c4 integer
c5 integer
c6 integer
c7 smallint
c8 smallint
c9 integer
c10 integer
c11 integer
c12 integer
c13 integer
c14 integer
c15 smallint
c16 smallint
c17 integer
c18 integer
c19 integer
c20 integer
c21 integer
c22 integer
c23 smallint
c24 smallint
c25 integer
c26 integer
c27 integer
c28 integer
c29 integer
c30 integer
c31 smallint
c32 smallint
c33 integer
c34 integer
c35 integer
c36 integer
c37 integer
c38 integer
c39 smallint
c40 smallint
c41 integer
c42 integer
c43 integer
c44 integer
c45 integer
c46 integer
c47 smallint
c48 smallint
c49 integer
c50 integer
c51 integer
c52 integer
c53 integer
c54 integer
c55 smallint
c56 smallint
c57 integer
c58 integer
c59 integer
c60 integer
c61 integer
c62 integer
c63 smallint
c64 smallint
c65 integer
c66 integer
c67 integer
c68 integer
c69 integer
B-36
c70 integer
c71 smallint
c72 smallint
c73 integer
c74 integer
c75 integer
c76 integer
c77 integer
c78 integer
c79 smallint
c80 smallint
c81 integer
c82 integer
c83 integer
c84 integer
c85 integer
c86 integer
c87 smallint
c88 smallint
c89 integer
c90 integer
c91 integer
c92 integer
c93 integer
c94 integer
c95 smallint
c96 smallint
Appendix B
TABLE ar9051p
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
trans_id char(8)
c1 integer
c2 integer
c3 smallint
c4 smallint
c5 smallint
c6 smallint
c7 smallint
c8 smallint
c9 integer
c10 integer
c11 smallint
c12 smallint
c13 smallint
c14 smallint
c15 smallint
c16 smallint
c17 integer
c18 integer
c19 smallint
c20 smallint
c21 smallint
c22 smallint
c23 smallint
c24 smallint
c25 integer
c26 integer
c27 smallint
c28 smallint
c29 smallint
c30 smallint
c31 smallint
c32 smallint
c33 integer
c34 integer
c35 smallint
c36 smallint
c37 smallint
c38 smallint
c39 smallint
c40 smallint
c41 integer
c42 integer
c43 smallint
c44 smallint
c45 smallint
c46 smallint
c47 smallint
c48 smallint
c49 integer
c50 integer
c51 smallint
c52 smallint
c53 smallint
c54 smallint
c55 smallint
c56 smallint
c57 integer
c58 integer
c59 smallint
c60 smallint
c61 smallint
c62 smallint
c63 smallint
c64 smallint
c65 integer
c66 integer
c67 smallint
c68 smallint
c69 smallint
B-37
c70 smallint
c71 smallint
c72 smallint
c73 integer
c74 integer
c75 smallint
c76 smallint
c77 smallint
c78 smallint
c79 smallint
c80 smallint
c81 integer
c82 integer
c83 smallint
c84 smallint
c85 smallint
c86 smallint
c87 smallint
c88 smallint
c89 integer
c90 integer
c91 smallint
c92 smallint
c93 smallint
c94 smallint
c95 smallint
c96 smallint
Appendix B
TABLE aw9051
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
trans_id char(8)
c1 integer
c2 integer
c3 integer
c4 integer
c5 integer
c6 integer
c7 integer
c8 integer
c9 integer
c10 integer
c11 integer
c12 integer
B-38
Appendix B
TABLE ar9052
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
trans_id char(8)
c1 integer
c2 integer
c3 smallint
c4 smallint
c5 integer
c6 integer
c7 smallint
c8 smallint
c9 integer
c10 integer
c11 smallint
c12 smallint
c13 integer
c14 integer
c15 smallint
c16 smallint
c17 integer
c18 integer
c19 smallint
c20 smallint
c21 integer
c22 integer
c23 smallint
c24 smallint
c25 integer
c26 integer
c27 smallint
c28 smallint
c29 integer
c30 integer
c31 smallint
c32 smallint
c33 integer
c34 integer
c35 smallint
c36 smallint
c37 integer
c38 integer
c39 smallint
c40 smallint
c41 integer
c42 integer
c43 smallint
c44 smallint
c45 integer
c46 integer
c47 smallint
c48 smallint
c49 integer
c50 integer
c51 smallint
c52 smallint
c53 integer
c54 integer
c55 smallint
c56 smallint
c57 integer
c58 integer
c59 smallint
c60 smallint
c61 integer
c62 integer
c63 smallint
c64 smallint
c65 integer
c66 integer
c67 smallint
c68 smallint
c69 integer
B-39
c70 integer
c71 smallint
c72 smallint
c73 integer
c74 integer
c75 smallint
c76 smallint
c77 integer
c78 integer
c79 smallint
c80 smallint
c81 integer
c82 integer
c83 smallint
c84 smallint
c85 integer
c86 integer
c87 smallint
c88 smallint
c89 integer
c90 integer
c91 smallint
c92 smallint
c93 integer
c94 integer
c95 smallint
c96 smallint
c97 integer
c98 integer
c99 smallint
c100 smallint
c101 integer
c102 integer
c103 smallint
c104 smallint
c105 integer
c106 integer
c107 smallint
c108 smallint
c109 integer
Appendix B
TABLE ar9052 cont’d
c110 integer
c111 smallint
c112 smallint
c113 integer
c114 integer
c115 smallint
c116 smallint
c117 integer
c118 integer
c119 smallint
c120 smallint
c121 integer
c122 integer
c123 smallint
c124 smallint
c125 integer
c126 integer
c127 smallint
c128 smallint
c129 integer
c130 integer
c131 smallint
c132 smallint
c133 integer
c134 integer
c135 smallint
c136 smallint
c137 integer
c138 integer
c139 smallint
c140 smallint
c141 integer
c142 integer
c143 smallint
c144 smallint
c145 integer
c146 integer
c147 smallint
c148 smallint
c149 integer
c150 integer
c151 smallint
c152 smallint
c153 integer
c154 integer
c155 smallint
c156 smallint
c157 integer
c158 integer
c159 smallint
c160 smallint
c161 integer
c162 integer
c163 smallint
c164 smallint
c165 integer
c166 integer
c167 smallint
c168 smallint
c169 integer
c170 integer
c171 smallint
c172 smallint
c173 integer
c174 integer
c175 smallint
c176 smallint
c177 integer
c178 integer
c179 smallint
c180 smallint
c181 integer
c182 integer
c183 smallint
c184 smallint
c185 integer
c186 integer
c187 smallint
c188 smallint
c189 integer
B-40
c190 integer
c191 smallint
c192 smallint
c193 smallint
c194 smallint
c195 smallint
c196 smallint
c197 smallint
c198 smallint
c199 smallint
c200 smallint
c201 smallint
c202 smallint
c203 smallint
c204 smallint
c205 smallint
c206 smallint
c207 smallint
c208 smallint
c209 smallint
c210 smallint
c211 smallint
c212 smallint
c213 smallint
c214 smallint
c215 smallint
c216 smallint
c217 smallint
c218 smallint
c219 smallint
c220 smallint
c221 smallint
c222 smallint
c223 smallint
c224 smallint
c225 smallint
c226 smallint
c227 smallint
c228 smallint
Appendix B
TABLE ar9053
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
trans_id char(8)
c1 integer
c2 integer
c3 smallint
c4 smallint
c5 integer
c6 integer
c7 smallint
c8 smallint
c9 integer
c10 integer
c11 smallint
c12 smallint
c13 integer
c14 integer
c15 smallint
c16 smallint
c17 integer
c18 integer
c19 smallint
c20 smallint
c21 integer
c22 integer
c23 smallint
c24 smallint
c25 integer
c26 integer
c27 smallint
c28 smallint
c29 integer
c30 integer
c31 smallint
c32 smallint
c33 integer
c34 integer
c35 smallint
c36 smallint
c37 integer
c38 integer
c39 smallint
c40 smallint
c41 integer
c42 integer
c43 smallint
c44 smallint
c45 integer
c46 integer
c47 smallint
c48 smallint
c49 integer
c50 integer
c51 smallint
c52 smallint
c53 integer
c54 integer
c55 smallint
c56 smallint
c57 integer
c58 integer
c59 smallint
c60 smallint
c61 integer
c62 integer
c63 smallint
c64 smallint
c65 integer
c66 integer
c67 smallint
c68 smallint
c69 integer
B-41
c70 integer
c71 smallint
c72 smallint
c73 integer
c74 integer
c75 smallint
c76 smallint
c77 integer
c78 integer
c79 smallint
c80 smallint
c81 integer
c82 integer
c83 smallint
c84 smallint
c85 integer
c86 integer
c87 smallint
c88 smallint
c89 integer
c90 integer
c91 smallint
c92 smallint
c93 integer
c94 integer
c95 smallint
c96 smallint
c97 integer
c98 integer
c99 smallint
c100 smallint
c101 integer
c102 integer
c103 smallint
c104 smallint
c105 integer
c106 integer
c107 smallint
c108 smallint
c109 integer
Appendix B
TABLE ar9053 cont’d
c110 integer
c111 smallint
c112 smallint
c113 integer
c114 integer
c115 smallint
c116 smallint
c117 integer
c118 integer
c119 smallint
c120 smallint
c121 integer
c122 integer
c123 smallint
c124 smallint
c125 integer
c126 integer
c127 smallint
c128 smallint
c129 integer
c130 integer
c131 smallint
c132 smallint
c133 integer
c134 integer
c135 smallint
c136 smallint
c137 integer
c138 integer
c139 smallint
c140 smallint
c141 integer
c142 integer
c143 smallint
c144 smallint
c145 integer
c146 integer
c147 smallint
c148 smallint
c149 integer
c150 integer
c151 smallint
c152 smallint
c153 integer
c154 integer
c155 smallint
c156 smallint
c157 integer
c158 integer
c159 smallint
c160 smallint
c161 integer
c162 integer
c163 smallint
c164 smallint
c165 integer
c166 integer
c167 smallint
c168 smallint
c169 integer
c170 integer
c171 smallint
c172 smallint
c173 integer
c174 integer
c175 smallint
c176 smallint
c177 integer
c178 integer
c179 smallint
c180 smallint
c181 integer
c182 integer
c183 smallint
c184 smallint
c185 integer
c186 integer
c187 smallint
c188 smallint
c189 integer
B-42
c190 integer
c191 smallint
c192 smallint
c193 smallint
c194 smallint
c195 smallint
c196 smallint
c197 smallint
c198 smallint
c199 smallint
c200 smallint
c201 smallint
c202 smallint
c203 smallint
c204 smallint
c205 smallint
c206 smallint
c207 smallint
c208 smallint
c209 smallint
c210 smallint
c211 smallint
c212 smallint
c213 smallint
c214 smallint
c215 smallint
c216 smallint
c217 smallint
c218 smallint
c219 smallint
c220 smallint
c221 smallint
c222 smallint
c223 smallint
c224 smallint
c225 smallint
c226 smallint
c227 smallint
c228 smallint
Appendix B
TABLE ar9054h
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
trans_id char(8)
c1 integer
c2 integer
c3 smallint
c4 integer
c5 integer
c6 smallint
c7 integer
c8 integer
c9 smallint
c10 integer
c11 integer
c12 smallint
c13 integer
c14 integer
c15 smallint
c16 integer
c17 integer
c18 smallint
c19 integer
c20 integer
c21 smallint
c22 integer
c23 integer
c24 smallint
c25 integer
c26 integer
c27 smallint
TABLE ar9054l
c28 integer
c29 integer
c30 smallint
c31 integer
c32 integer
c33 smallint
c34 integer
c35 integer
c36 smallint
c37 integer
c38 integer
c39 smallint
c40 integer
c41 integer
c42 smallint
c43 integer
c44 integer
c45 smallint
B-43
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
trans_id char(8)
c1 integer
c2 integer
c3 integer
c4 integer
c5 integer
c6 integer
c7 integer
c8 integer
c9 integer
c10 integer
c11 integer
c12 integer
c13 integer
c14 integer
c15 integer
c16 integer
c17 integer
c18 integer
c19 integer
c20 integer
c21 integer
c22 integer
c23 integer
c24 integer
Appendix B
TABLE ar9055h
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
trans_id char(8)
c1 integer
c2 integer
c3 integer
c4 integer
c5 integer
c6 integer
c7 integer
c8 decimal(7,1)
c9 decimal(7,1)
TABLE ar9055l
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
trans_id char(8)
c1 integer
c2 integer
c3 integer
c4 integer
c5 integer
c6 integer
c7 integer
c8 integer
c9 decimal(7,1)
c10 decimal(7,1)
B-44
Appendix B
TABLE ar9056
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
trans_id char(8)
c1 decimal(5,0)
c2 char(2)
c3 char(1)
c4 char(2)
c5 char(1)
c6 char(1)
c7 char(1)
c8 char(4)
c10 date
c11 char(1)
c12 date
c13 date
c14 char(1)
c15 date
c16 char(1)
c17 char(1)
c18 char(1)
c20 char(1)
c21 char(1)
c24 date
c26 char(1)
c27 smallint
c28 char(4)
c29 char(1)
c30 date
TABLE ar9056t
st char(2)
rptdate date
user_id char(8)
lock_date date
samp_size smallint
load_type char(1)
seps_score decimal(5,2)
nonseps_score decimal(5,2)
weight_score decimal(5,2)
pop_seps integer
pop_nonseps integer
num_seps smallint
num_nonseps smallint
num_seps_nomat smallint
num_nonseps_nomat smallint
num_seps_noiss smallint
num_nonseps_noiss smallint
num_seps_redet smallint
num_nonseps_redet smallint
overall_flag char(1)
missing_flag char(1)
B-45
Appendix B
TABLE ar9057
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
trans_id char(8)
c1 decimal(5,0)
c2 char(1)
c3 char(1)
c4 char(1)
c5 char(1)
c6 char(1)
c7 char(1)
c8 char(1)
c9 char(1)
c10 char(1)
c11 char(1)
c12 char(1)
c13 char(1)
c14 char(1)
c15 char(1)
c16 char(1)
c17 char(1)
c18 char(1)
c19 char(1)
c20 char(1)
c21 char(1)
c22 char(1)
c23 char(1)
c24 char(1)
c25 char(1)
c26 char(1)
c27 char(1)
c28 char(1)
c29 char(1)
c30 char(1)
c31 char(1)
c32 char(1)
c33 char(1)
c34 char(1)
c35 date
c36 date
c37 char(2)
c38 smallint
c39 char(12)
c40 smallint
c41 char(1)
TABLE ar9057t
st char(2)
rptdate date
user_id char(8)
lock_date date
score decimal(5,2)
samp_size smallint
load_type char(1)
num_cases smallint
num_cases_unscored smallint
missing_flag char(1)
B-46
Appendix B
TABLE ar9128
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
trans_id char(8)
c1 integer
c2 integer
c3 integer
c4 integer
c5 integer
c6 integer
c7 integer
c8 integer
c9 integer
c10 integer
c11 integer
c12 integer
c13 integer
c14 decimal(12,0)
c15 integer
c16 integer
c17 integer
c18 integer
c19 integer
c20 decimal(12,0)
c21 integer
c22 integer
B-47
Appendix B
TABLE ar9129
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
trans_id char(8)
c1 integer
c2 integer
c3 decimal(12,0)
c4 integer
c5 integer
c6 integer
c7 decimal(10,1)
c8 decimal(12,0)
c9 integer
c10 integer
c11 decimal(12,0)
c12 integer
c13 integer
c14 integer
c15 decimal(10,1)
c16 decimal(12,0)
B-48
Appendix B
TABLE arui1
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
c11 decimal(7,2)
c12 decimal(6,2)
c13 decimal(6,2)
c14 decimal(6,2)
c15 decimal(6,2)
c16 decimal(7,2)
c17 decimal(6,2)
c18 decimal(6,2)
c19 decimal(6,2)
c20 decimal(6,2)
B-49
Appendix B
TABLE arui3
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
reg_id char(8)
reg_date char(12)
c1 decimal(7,2)
c2 decimal(7,2)
c3 decimal(7,2)
c4 decimal(6,2)
c5 decimal(6,2)
c6 decimal(6,2)
c7 decimal(5,2)
c8 decimal(5,2)
c9 decimal(6,2)
c10 decimal(7,2)
c11 decimal(7,2)
c12 decimal(7,2)
c13 decimal(5,2)
c14 decimal(6,2)
c15 decimal(6,2)
c16 decimal(7,2)
c17 decimal(7,2)
c18 decimal(7,2)
c19 decimal(5,0)
c20 char(1)
c23 decimal(6,3)
c24 integer
c25 decimal(6,3)
c26 integer
c28 decimal(6,3)
c29 integer
c30 decimal(10,3)
c31 integer
c32 integer
c35 smallint
c36 decimal(13,2)
c38 decimal(5,4)
c39 integer
c40 decimal(4,2)
c41 integer
c42 integer
c43 integer
c44 integer
c45 decimal(10,3)
c46 decimal(7,2)
c47 decimal(7,2)
c48 decimal(7,2)
c49 decimal(6,2)
c50 decimal(6,2)
c51 decimal(6,2)
c52 integer
c53 decimal(7,2)
c54 decimal(7,2)
c55 integer
c56 decimal(7,2)
c57 decimal(7,2)
c62 integer
c63 decimal(7,2)
c64 decimal(7,2)
c65 integer
c66 decimal(7,2)
c67 decimal(7,2)
c68 decimal(7,2)
c71 integer
c72 decimal(6,3)
c73 decimal(7,2)
c74 decimal(7,2)
c75 decimal(7,2)
c76 decimal(7,2)
c77 decimal(7,2)
c78 decimal(7,2)
c79 integer
c80 integer
c81 integer
c82 integer
c83 decimal(9,2)
B-50
Appendix B
TABLE abui3
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
reg_id char(8)
reg_date char(12)
c1 integer
c2 decimal(6,3)
c3 integer
c4 decimal(6,3)
c5 integer
c6 decimal(6,3)
c7 integer
c8 decimal(6,3)
c9 decimal(4,2)
c10 decimal(5,0)
c11 decimal(5,4)
c12 integer
c13 decimal(4,2)
c14 integer
c15 integer
c16 integer
c17 decimal(6,3)
c18 decimal(6,2)
c19 decimal(6,2)
c20 decimal(6,2)
c21 decimal(8,2)
c22 decimal(8,2)
c23 decimal(8,2)
c24 decimal(8,2)
c25 decimal(8,2)
c26 decimal(8,2)
c27 decimal(8,2)
c28 integer
c29 integer
c30 char(1)
TABLE asui3
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
reg_id char(8)
reg_date char(12)
c1 integer
c2 decimal(6,3)
c3 decimal(6,2)
c4 decimal(5,4)
c5 integer
c6 decimal(4,2)
c7 integer
c8 integer
c9 decimal(6,2)
c10 decimal(6,2)
c11 decimal(6,2)
c12 decimal(7,2)
c13 decimal(7,2)
c14 decimal(7,2)
c15 integer
c16 integer
c17 decimal(5,0)
c18 char(1)
B-51
TABLE atui3
st char(2)
rptdate date
mods smallint
crdate char(12)
revdate char(12)
mldate char(12)
mlflag char(1)
cm char(1)
hostname char(8)
user_id char(8)
reg_id char(8)
reg_date char(12)
c1 integer
c2 decimal(6,3)
c3 integer
c4 decimal(6,3)
c5 integer
c6 decimal(6,3)
c7 integer
c8 decimal(6,3)
c9 decimal(4,2)
c10 decimal(5,0)
c11 decimal(5,4)
c12 integer
c13 decimal(4,2)
c14 integer
c15 integer
c16 integer
c17 decimal(6,3)
c18 decimal(6,2)
c19 decimal(6,2)
c20 decimal(6,2)
c21 decimal(8,2)
c22 decimal(8,2)
c23 decimal(8,2)
c24 decimal(8,2)
c25 decimal(8,2)
c26 decimal(8,2)
c27 decimal(8,2)
c28 integer
c29 integer
c30 char(1)
Appendix B
This page is intentionally left blank
B-52
Appendix C
APPENDIX C: Report Edit Specifications
Data for each UI report, either hand entered or uploaded from an ASCII file, is put through edits
before saving to state files and again, before transmission to the National Office. Results of
these edits are displayed to the user and the opportunity to make corrections is given at both
times. Users should review the edits and make corrections as appropriate or explain in the
comments section of the report, that the data has been checked and is correct and why.
There are three different types of edits: fatal errors, errors, and warnings. These are discussed in
Chapter 2, Checking for Errors. It would be prudent, if possible, to edit data in the state system
before it is loaded onto the UIRR entry system, especially through ASCII upload, so that
transmission goes smoothly.
The following shows the edits performed by the system for most reports for which states would
prepare ASCII upload files. For each table name, the condition that should exist for certain cells
is shown. Deviations from these conditions will result in edit exceptions. Refer to the data maps
in Appendix A which give the cell names to understand the edits. To avoid edit errors in the
entry or upload process, states may choose to apply edits at the time that their own systems
create the data.
C-1
Appendix C
TABLE: ar191
Errors:
c1 through c6, c11, c12 >= 0
c9 = c1-c3-c5+c7
c9 = Sec.B, ar191sb sum c2 for UCFE
c9 != 0
c10 = c2-c4-c6+c8
c10 = Sec.B, ar191sb sum c2 for UCX
c10 != 0
c15 = c13-c11
c16 = c14-c12
c17 = c9+c15
c17 != 0
c18 = c10+c16
c18 != 0
TABLE: ar191sb
Errors:
c1 is defined on “g_agency” table
g_agency.flag != 2
c1 = “111” and st =“DC”, “VA”, “MD”
c1 = “668” and st =“DC”
c2 != NULL
c2 != 0
Warning:
g_agency flag != 1
C-2
Appendix C
TABLE: ar203
Errors:
c1 must be ‘s’ or ‘p’
c2+c3+c4 = c12+c13+c14+c15+c16+c17+c18+c19+c20
c2+c3+c4 = c49+c50+c51+c52+c53+c54+c55+c56+c57+c58+c59+c60+c61
+c62+c63+c64+c65+c66+c67+c68+c69
c2+c3+c4 = c70+c71+c72+c73+c74+c75+c76+c77+c78+c79+c80+c81+c82
+c83+c84+c85+c86+c87+c88+c89+c90+c91+c92+c93
Warnings:
c2+c3+c4 = ar539.c8+c12 (+/-2%) within the same rptdate period, that is the ar539.rptdate
containing the 19th of the same month
c2+c3+c4 = c40+c41+c42
c2+c3+c4 = c43+c44+c45+c46+c47+c48
C-3
Appendix C
TABLE: ar204
c18 = c21+c24
c18 >= c19
c1 != NULL
c19 ! = 0 or NULL
c1 > c2
c19 = c22+c25
c1 > c4
c20 != 0 or NULL
c1 > c5
c21 ! = 0 or NULL
c1 > c35
c21 >= c22
c2 ! = NULL
c22 != 0 or NULL
c2 cannot be < c1 – 2 year
c23 != 0 or NULL
c2 < c1 - 1 year
c24 != 0 or NULL
c2 must be either the first day of
c24 >= c25
the month or the last of the month
c25 != 0 or NULL
c3 != NULL
c26 != 0 or NULL
c3 = “BR”, “BW”, “RR”, or “PD”
c26 = c29+c32
c4 != NULL
c27 != 0 or NULL
c4 cannot be < c1 – 2 year
c27 = c30+c33
c5 != NULL
c27 >= c28
c5 cannot be < c1 – 2 year
c28 != 0 or NULL
c6 != 0
c28 = c31+c34
c6 = c9+c12
c29 != 0 or NULL
c7 != 0
c30 != 0 or NULL c30 >= c31
c7 = c10+c13
c31 != 0 or NULL
c7 >= c8
c32 != NULL
c8 != 0
c33 != NULL
c8 = c11+c14
c33 >= c34
c9 != 0
c34 != NULL
c10 ! = 0
c35 != NULL
c10 >= c11
c35 cannot be c1 -2 year
c11 != 0
c36 != 0 or NULL
c12 != 0
c36 = c37+c42
c13 != 0
c36 > 0.9 * (eta2112,c51 + eta2112,c53 +
c13 >= c14
eta2112,c55 + eta2112,c57 + eta2112,c59 +
c14 != 0
eta2112,c69 - eta2112,c21) for the previous
c15 != 0
12 months ending by c2 (skip if any of the
c16 != 0
months was missing or not transmitted)
If c3 not = “RR” then c17 through c34 are
c36 < 1.1 * (eta2112,c51 + eta2112,c53 +
null; else check the following conditions:
eta2112,c55 + eta2112,c57 + eta2112,c59 +
c17 != 0 or NULL
eta2112,c69 - eta2112,c21) for the previous
c17 = c20+c23
12 months ending by c2 (skip if any of the
c18 != or NULL
months was missing or not transmitted)
Errors:
C-4
Appendix C
TABLE: ar204 cont’d
c37 != 0
c37 = c38+c41
If State not = “AK” then
c38 != 0 or NULL
c38 = c39+c40
If State not = “AK” then
c39 != 0 or NULL
If State not = “AK” then
c40 != 0 or NULL
c41 != 0 or NULL
c42 != 0 or NULL
c42 = c43+c44
c43 != 0 or NULL
c44 != NULL
Warnings:
If st = TN, NH, NJ, or VT
then c1 = rptdate + 6 months.
If st not= TN, NH, NJ, or VT
then c1 = rptdate
If c3 = “RR” then c32 is usually not zero
If c3 = “RR” then c33 is usually not zero
If c3 = “RR” then c34 is usually not zero
c35 = c2
c36 > 0.95 * (eta2112,c51 + eta2112,c53 +
eta2112,c55 + eta2112,c57 + eta2112,c59 +
eta2112,c69 - eta2112,c21) for the previous
12 months ending by c2 (skip if any of the
months was missing or not transmitted)
c36 < 1.05 * (eta2112,c51 + eta2112,c53 +
eta2112,c55 + eta2112,c57 + eta2112,c59 +
eta2112,c69 - eta2112,c21) for the previous
12 months ending by c2 (skip if any of the
months was missing or not transmitted)
C-5
Appendix C
TABLE: ar204b
If ar204.c3 = RR, then use ar204r
If ar204.c3 = BW or BR then use ar204b
If ar204.c3 = PD or UR, do not use Sec C
Errors:
Warnings:
c2 is beyond ((c7 * 100) / c5) +/- 0.2
If c2(except row97)>0 then c4>0 and c5>0
If c2(except row97)=0 then c7=0
c2 cannot be negative
c3 (row 96) = the sum of c3 (row 1 - 95)
c3 (row 98) = the sum of c3 (row 96 - 97)
c3 (row 100) = the sum of c3 (row 98 - 99)
If c4(except row97)=0
then c5=0 and c7=0 and c2=0
c4(except row97)>= c5
c4 (row 96) = the sum of c4 (row 1 - 95)
c4 (row 98) = the sum of c4 (row 96 - 97)
c4 (row 100) = the sum of c4 (row 98 - 99)
If c5(except row97)=0
then c4=0 and c7=0 and c2 =0
c5 (row 96) = the sum of c5 (row 1 - 95)
c5 (row 98) = the sum of c5 (row 96 - 97)
c5 (row 100) = the sum of c5 (row 98 - 99)
c6 (row 96) = the sum of c6 (row 1 - 95)
c6 (row 98) = the sum of c6 (row 96 - 97)
c6 (row 100) = the sum of c6 (row 98 - 99)
c6 (row 100) > 0.00095 * ar204.c39
c6 (row 100) > 0.01 * ar204. c39,
then c6 > 0.95 * ar204.c39
c6 (row 100) < 1.05 * ar204.c39
c6 (row 100) < 0.1 * ar204. c39,
then c6 < .00105 * ar204.c39
If c7(except row97) = 0 then c2 = 0
c7 (row 96) = the sum of c7 (row 1 - 95)
c7 (row 98) = the sum of c7 (row 96 - 97)
c7 (row 100) = the sum of c7 (row 98 - 99)
c2 is within ((c7 * 100) / c5) +/- 0.2
but not equal (c7 * 100) / c5
If c2(row97)>0 then c4>0 and c5>0
If c2(row97)=0 then c7=0
c4 (row 100) = the sum of c4 (row 98 - 99)
If c4(row97)=0 then c5=0 and c7=0 and c2=0
c4(row97)>= c5
c4 (row 100) > 0.00095 * ar204.c7
c4 (row 100) < 0.00105 * ar204.c7
c5 (row 100) = the sum of c5 (row 98 - 99)
If c5(row97)=0 then c4=0 and c7=0 and c2 = 0
c5 (row 100) > 0.00095 * ar204.c8
c5 (row 100) < 0.00105 * ar204.c8
c6 (row 100) > 0.000999 * ar204.c39
c6 (row 100) < 0.001001 * ar204.c39
If c7(row97) = 0 then c2 = 0
C-6
Appendix C
TABLE: ar204r
If ar204.c3 = RR, then use ar204r
If ar204.c3 = BW or BR then use ar204b
If ar204.c3 = PD or UR, do not use Sec C
Errors:
Warnings:
c2 is beyond ((c7 * 100) / c5) +/- 0.2
If c2(except row72)>0 then c4>0 and c5>0
If c2(except row72)=0 then c7=0
c2 cannot be negative
c3 (row 71) = the sum of c3 (row 1 - 70)
c3 (row 73) = the sum of c3 (row 71 - 72)
c3 (row 75) = the sum of c3 (row 73 - 74)
If c4(except row72) = 0
then c5 = 0 and c7 = 0 and c2 = 0
c4(except row72) >= c5
c4 (row 71) = the sum of c4 (row 1 - 70)
c4 (row 73) = the sum of c4 (row 71 - 72)
c4 (row 75) = the sum of c4 (row 73 - 74)
If c5(except row72) = 0
then c4 = 0 and c7 = 0 and c2 = 0
c5 (row 71) = the sum of c5 (row 1 - 70)
c5 (row 73) = the sum of c5 (row 71 - 72)
c5 (row 75) = the sum of c5 (row 73 - 74)
c6 (row 71) = the sum of c6 (row 1 - 70)
c6 (row 73) = the sum of c6 (row 71 - 72)
c6 (row 75) = the sum of c6 (row 73 - 74)
c6 (row 75) > 0.00095 * ar204.c36
If c6 (row 75) > 0.01 * ar204.c36,
then c6 > 0.95 * ar204.c36
c6 (row 75) < 1.05 * ar204.c36
If c6 (row 75) < 0.1 * ar204.c36,
then c6 > 0.00105 * ar204.c36
If c7(except row72) = 0 then c2 = 0
c7 (row 71) = the sum of c7 (row 1 - 70)
c7 (row 73) = the sum of c7 (row 71 - 72)
c7 (row 75) = the sum of c7 (row 73 - 74)
c2 is within ((c7 * 100) / c5) +/- 0.2
but not equal
(c7 * 100) / c5
If c2(row72)>0 then c4>0 and c5>0
If c2(row72)=0 then c7=0
If c4(row72) = 0
then c5 = 0 and c7 = 0 and c2 = 0
c4(row72) >= c5
c4 (row 75) > 0.00095 * ar204.c7
c4 (row 75) < 0.00105 * ar204.c7
If c5(row72) = 0
then c4 = 0 and c7 = 0 and c2 = 0
c5 (row 75) = the sum c5 (row 73 - 74)
c5 (row 75) > 0.00095 * ar204.c8
c5 (row 75) < 0.00105 * ar204.c8
c6 (row 75) > 0.000999 * ar204.c39
c6 (row 75) < 0.001001 * ar204.c39
If c7(row72) = 0 then c2 = 0
C-7
Appendix C
TABLE: arertx, ETA 205
Errors:
c1 != NULL
c1 <= 10.00
c1 > 0
c2 ! = NULL
c2 > 0
c2 <= c1
c2 <= 10.00
Warning:
c2/c1 >.25 and <.75
c2 - c2 of prior year and
c1 - c1 of prior year > or < 0
c2/c1 remains within 10% of c7/c5 from
ar202 (apply only NO Application).
C-8
Appendix C
TABLE: ar207
Errors:
Warnings:
c1 through c46 cannot be NULL
c1 = c2+c3
c2 = c17+c33
c4 = c5+c6
c7 = c8+c9
c8 = c21+c39
c10 = c11+c12
c17 = c18+c19+c20
c21 = c22+c23+c24
c25 = c26+c27+c28
c29 = c30+c31+c32
c33 = c34+c35+c36+c37+c38+c45
c39 = c40+c41+c42+c43+c44+c46
c1, c7, c13 – c19, c21, c25, c29,
c33 - c39, 45 exception (g_excep)
c7 < c1
c8 < c2
c9 < c3
c13 < c1
c14 <= c13
c15 < c1
c16 <= c15
c20 < c19
c21 < c17
c22 < c18
c23 <= c19
c24 <= c20
c25 < c17
c26 < c18
c27 < c19
c28 <= c20
c29 <= c25
c30 <= c26
c31 <= c27
c32 <= c28
c39 < c33
c40 <= c34
c41 <= c35
c42 <= c36
c43 <= c37
c44 <= c38
c46 <= c45
C-9
Appendix C
ar207 Data Exception Edits
Cell Percentage Percentage Absolute Value
Increase
Decrease
c1
35
25
5000
c7
50
25
3300
c13
70
40
45
c14
70
45
50
c15
70
45
80
c16
100
50
60
c17
30
20
1230
c18
50
35
1300
c19
50
35
2200
c21
35
20
740
c25
80
45
40
c29
100
50
25
c33
50
30
5000
c34
80
40
1400
c35
80
40
800
c36
80
40
130
c37
80
40
1200
c38
80
40
800
c39
60
30
5000
c45
80
40
200
C-10
Appendix C
TABLE: ae207 / at207
Errors:
c1 through c22 cannot be NULL
c7 >= c10+c9+c8
c11 >= c14+c13+c12
c15 >= c18+c17+c16
c19 >= c22+c21+c20
Warnings:
c2 <= c1
c3 < c1
c4 <= c3
c5 < c1
c6 <= c5
c11 <= c7
c12 <= c8
c13 <= c9
c14 <= c10
c19 <= c15
c20 <= c16
c21 <= c17
c22 <= c18
C-11
Appendix C
TABLE: ar218
Errors:
Warnings:
c1 through c36 cannot be NULL
c1 = c2+c3
c9=c10+c11+c12+c13+c14+c15+
c23+c24+c25+c26+c27
c9=c4
c16=c17+c18+c19+c20+c21+c22+
c30+c31+c32+c33+c34
c1, c4, c9, c16 exception (g_excep)
c4 <= c3
c5 <= c4
c6 <= c4
c6 <= c5
c28 <= c9
If st != MA or WA Then c29 <= 26 weeks
Else c29 <= 30 weeks
c35 <= c16
If st != MA or WA Then c36 <= 26 weeks
Else c36 <= 30 weeks
TABLE: ae218 / at218
Errors:
c1 = c3+c2
ar218
Data Exception Edits
Cell
Percentage
Increase
Percentage
Decrease
Absolute
Value
c1
60
35
16000
c4
90
45
14000
c9
60
40
14000
c16
50
35
2400
C-12
Appendix C
TABLE: ar227
Errors:
c1 through c232 cannot be NULL
c27 = c5+c9+c13+c17+c23
c28 = c6+c10+c14+c18+c24
c29 = c7+c11+c15+c19+c25
c30 = c8+c12+c16+c20+c26
c31 = c27+c1
c32 = c28+c2
c33 = c29+c3+c21
c34 = c30+c4+c22
c35 = c71 prior rptdate
c36 = c72 prior rptdate
c37 = c73 prior rptdate
c38 = c74 prior rptdate
c71 = c3+c35-c206-c55+
c59-c67-c222
c72 = c4+c36-c207-c56+
c60-c68-c223
c73=c29+c21+c37-c208c49-c57+c61-c69-c224
c74=c30+c22+c38-c209-c50c58+c62-c70-c225
c75 >= c76+c78
c131 = c1+c2
c131 = c188 + c202
c132 = c3 + c4
c132 = c189 + c203
c133 = c27 + c28
c133= c190 + c204
c134 = c29 + c30
c134 = c191+c205
c159> = c160+c162
c164 >= c165
c181=c169+c171+c173+
c175+c177+c179
c182=c170+c172+c174+
c176+c178+c180
c31+c32=c131+c133
c33+c34-c21-c22=c132+c134
c33+c34-c21-c22=c132+c134
c181 = c71+c73
cl82 = c72 +c74
c188 =c76+c160+c193+
c165+c198+c116
c189 = c77+c161+c194+
c166+c199+c117
c190 = c78+c162+c195+c200+c118
c191 = c79+c163+c196+c201+c119
c192 >= c193+c195
c197 >= c198+c200
c206 = c39+c43+c210+c214+c218
c207 = c40+c44+c211+c215+c219
c208 = c41+c45+c212+c216+c220
c209 = c42+c46+c213+c217+c221
Warnings:
c2 <= c1
c4 <= c3
c6 <= c5
c8 <= c7
c10 <= c9
c12 <= c11
c14 <= c13
c16 <= c15
c18 <= c17
c20 <= c19
c22 <= c21
c24 <= c23
c26 <= c25
c28 <= c27
c30 <= c29
c32 <= c31
c34 <= c33
c36 <= c35
c38 <= c37
c40 <= c39
C-13
c40 <= c39
c42 <= c41
c44 <= c43
c46 <= c45
c50 <= c49
c56 <= c55
c58 <= c57
c60 <= c59
c62 <= c61
c68 <= c67
c70 <= c69
c72 <= c71
c74 <= c73
c164 < = c165
c165 < = c166
c183 <= c184
c184 <= c186
c185 <= c184
c187 <= c186
c202 <= c203
c204 <= c205
c207 <= c206
c209 <= c208
c211 <= c210
c213 <= c212
c215 <= c214
c217 <= c216
c219 <= c218
c221 <= c220
c222 > 0
c223 > 0
c224 > 0
c225 > 0
Appendix C
TABLE: at227
Errors:
c1 through c232 cannot be NULL
c35 = c71 prior rptdate
c36 = c72 prior rptdate
c37 = c73 prior rptdate
c38 = c74 prior rptdate
Warnings:
c2 <= c1
c4 <= c3
c28 <= c27
c30 <= c29
c36 <= c35
c38 <= c37
c50 <= c49
c56 <= c55
c58 <= c57
c60 <= c59
c62 <= c61
c68 <= c67
c70 <= c69
c71 = c3+c35-c206-c55+ c59-c67-c222
c72 = c4+c36-c207-c56+ c60-c68-c223
c72 <= c71
c73=c29+c21+c37-c208- c49-c57+c61-c69-c224
c74=c30+c22+c38-c209-c50- c58+c62-c70-c225
c74 <= c73
c207 <= c206
c209 <= c208
c222 > 0
c223 > 0
c224 > 0
c225 > 0
C-14
Appendix C
TABLE: ar2112
Errors:
c1 = c85 prior report
c1 = c2+c3+c4
c2 = c86 prior report
c3 = c87 prior report
c4 = c88 prior report
c5 = c6+c7+c8
c5 = c9+c11+c13+c15+c90+c17+c21+
c25+c27+c29+c31+c33+c35+
c37+c39+c43+c104+c108+c112
c6 = c10+c12+c16+c22+c28+c30+
c32+c40+c44+c105+c109+c113
c7 = c14+c91+c19+c23+c26+c34+
c36+c38+c41+c45+c106+c110+c114
c8 = c20+c24+c42+c46+c107+c111+c115
c9 = c10
c11 = c12
c13 = c14
c15 = c16
c17 = c19+c20
c19 = c78
c20 = c79
c21 = c22+c23+c24
c25 = c26
c27 = c28
c29 = c30
c31 = c32
c33 = c34
c35 = c36
c37 = c38
c39 = c40+c41+c42
c43 = c44+c45+c46
c47 = c48+c49+c50
c47 = c51+c53+c55+c57+c59+c61+
c63+c65+c67+c69+c71+c73+
c75+c77+c81+c98+c100+c102
c48 = c74+c78+c82
c49 = c72+c79+c83+c89+92+c93+c94
c50 = c52+c54+c56+c58+c60+c62+c64+c66+
c68+c70+c76+ c84+c99+c101+c103
c51 = c52
c53 = c54
c55 = c92+c56
c57 = c93+c58
c59 = c94+c60
c61 = c62
c63 = c64
c65 = c66
c67 = c68
c69 = c70+c89
c71 = c72
c73 = c74
c75 = c76
c77 = c78+c79
c81 = c82+c83+c84
c85 = c1+c5-c47
c86 = c2+c6-c48
c87 = c3+c7-c49
c88 = c4+c8-c50
c90 = c91
c95 = c96+c97
c98=c99
c100=c101
c102=c103
c104=c105+c106+c107
c108=c109+c110+c111
c112+c113+c114+c115
TABLE: ac2112
Warnings:
c1+c2+c3+c4+c5+c6+c7 <= ar2112.c67
C-15
Appendix C
TABLE: ar538
Warnings:
c3 < c4
c3 exception checks (g_excep)
c4 exception checks (g_excep)
c5 < c4
ar538
Data Exception Edits
Cell
Percentage
Increase
Percentage
Decrease
Absolute
Value
c3
200
50
2100
c4
200
30
4400
C-16
Appendix C
TABLE: ar539
Errors:
c1, c3 through c16, c19 >= 0
c2 = rptdate – 7 days
c17, c18, c23 cannot be NULL
c17, c18, c20, c21 > 0
c19 = (c17 * 100) / c18
c21 = (c19 * 100) / c20
c22 = B then c23 = a Sunday date
c22 = E then c23 = a Saturday date
(If c22 changes from prior week then c23 should change unless c22 was blank)
c23 >= c23 prior week
(If c23 changes from prior week then c22 should change unless c23 was blank)
Warnings:
(c3 / prior c3 - 1) <= 200/100
(1 - c3 / prior c3) <= 50/100
c4 < c3
(c4 / prior c4 - 1) <= 150/100
(1 - c4 / prior c4) <= 60/100
c5 < c3
(c5 / prior c5 - 1) <= 100/100
(1 - c5 / prior c5) <= 50/100
c6 < c3
c7<= c6
c8 > c3
(c8 - prior c8) <= 4400
(1 - c8 / prior c8) <= 30/100
c9 < c8
(c9 / prior c9 - 1) <= 70/100
(1 - c9 / prior c9) <= 50/100
c10 < c8
(c10 / prior c10 - 1) <= 70/100
(1 - c10 / prior c10) <= 50/100
c11 < c8
c12 <= c11
c13 < c8
c14 <= c13
c15 < c8
c16 <= c15
(c17 / prior c17 - 1) <= 25/100
(1 - c17 / prior c17) <= 20/100
c18 = c18 of previous week
If NOT first week of quarter.
(c18 / prior c18 - 1) <= 4/100
(1 - c18 / prior c18) <= 4/100
c19 >= .2 And <= 10.0
(c19 - prior c19) <= 0.25
(c19 / prior c19 - 1) <= 20/100
(1 - c19 / prior c19) <= 15/100
c20 >= .2 And <= 10.0
(c20 - prior c20) <= 0.25
(c20 / prior c20 - 1) <= 20/100
(1 – c20 / prior c20) <= 15/100
(c21 - prior c21) <= 10
(c21 / prior c21 - 1) <= 20/100
(1 – c21 / prior c21) <= 15/100
C-17
Appendix C
Cell
c3
c4
c5
c8
c9
c10
c17
c18
c19
c20
c21
ar539
Data Exception Edits
Percentage Percentage
Increase
Decrease
200
50
150
60
100
50
200
30
70
50
70
50
25
20
4
4
20
15
20
15
20
15
C-18
Absolute
Value
1100
520
30
4400
85
50
5500
29000
0.25
0.25
10
Appendix C
TABLE: ar581
Errors:
c1 through c69 cannot be NULL
c1 through c3, c11 through c69 cannot be negative
c3 = c1+c2
c4
If rptdate = 3/31/YYYY, then c4 > 1/31/YYYY
If rptdate = 6/30/YYYY, then c4 > 4/30/YYYY
If rptdate = 9/30/YYYY, then c4 > 7/31/YYYY
If rptdate = 12/31/YYYY, then c4 > 10/31/YYYY
c14a = c18 prior rptdate
If rptdate > = 06/30/1990 then c18 = c43+c44+c45+c46+c47
else c18 = c14a+c15-c16-c17-c64
c19a = c23 prior report period
If rptdate >= 06/30/1990 then c23 = c48+c49+c50+c51+c52
else c23 = c19a+c20-c21-c22-c65
c25b >= c25a
c25b >= c28a
c43 – c52 >= 0
c53 <= c54
c55 >= c54 prior report period
c56 <= c57
c58 >= c57 prior report period
c59 – c62
If rptdate >= 3/31/1995, then c59 <= c60 and c59 <= c68
If rptdate >= 3/31/1995, then c60 <= c68
If rptdate >= 3/31/1995, then c61 <= c11 and c61 <= c62
If rptdate >= 3/31/1995, then c62 <= c11
c67 = c66+c37a - c40a
Warnings:
ar581
Data Exception Edits
Cell
Percentage
Increase
Percentage
Decrease
Absolute
Value
c1
2
5
8000
c3
2
5
8000
c14
110
25
355500
C-19
Appendix C
TABLE: ar586
Errors:
c1 through c85 cannot be NULL
c1 > 0
c2 > 0
c4 > 0
c5 > 0
c25 > 0
c26 = c84+c85+c39+c42+c45+c48+c51+c54+c57+c60+c63+c66+c69
c35 = c37+c40+c43+c46+c49+c52+c55+c58+c61+c64+c67
c36 = c38+c41+c44+c47+c50+c53+c56+c59+c62+c65+c68
c70 = c72+c74+c76+c78+c80+c82
c71 = c73+c75+c77+c79+c81+c83
Warnings:
5 < c5 / c4 < 354
c9 > 0
5 < c10 / c9 < 354
ar586
Data Exception Edits
Cell
c1
c2
c3
c4
c5
c6
c7
c9
c10
c25
c26
Percentage
Increase
70
70
300
70
70
230
230
45
100
55
70
Percentage
Decrease
40
45
75
40
40
70
70
30
50
35
40
C-20
Absolute
Value
500
400
70
4200
520000
20
20
360
42000
650
640
Appendix C
TABLE: ar5130
Errors:
c1 through c73 cannot be NULL
c51 = c53+c55+c57
c52 = c54+c56+c58
c59 = c61+c63+c65
c60 = c62+c64+c66
c67 <= c51
c67 = c68+c69+c70+c71+c72+c73
Warnings:
c2 < c1
c3 < c1
c4 < c2
c4 <= c3
c5 < c1
c6 < c5
c7 <= c1
c10 < c9
c14 < c13
c54 <= c53
c59 <= c51
c60 <= c52
c61 <= c53
c62 <= c54
c62 <= c61
c63 <= c55
c64 <= c56
c65 <= c57
c66 <= c58
ar5130
Data Exception Edits
Cell
c1
c2
c9
c10
c13
c14
Percentage
Increase
35
130
50
70
35
70
Percentage
Decrease
25
40
30
40
25
45
C-21
Absolute
Value
250
95
300
95
300
105
Appendix C
TABLE: ae5130 / at5130
Errors:
c1 through c73 cannot be null
c51 = c53+c55+c57
c51 = c67
c52 = c54+c56+c58
c59 = c61+c63+c65
c60 = c62+c64+c66
c67 = c68+c69+c70+c71+c72+c73
c67 = c53+c55+c57
Warnings:
c59 <= c51
c60 <= c52 c61 <= c53
c62 <= c54
c63 <= c55
c64 <= c56
c65 <= c57
c66 <= c58
C-22
Appendix C
TABLE: ar5159
Errors:
c1 through c99 cannot be null
c1 > 0
c1 = c2+c3+c4
c7 = c8+c9+c10
c13 = c14+c15+c16
c21 > 0
c38 > 0
c39 > 0
c40 > 0
c45 > 0
c46 > 0
c47 > 0
c51 > 0
c51 = c52+c53
c97 <= c4
c98 <= c10
c99 <= c16
Warnings:
c5 < c1
c6 < c1
c7 < c1
c8 < c2
c9 < c3
c10 < c4
c11 <= c5
c11 < c7
c12 < c6
c12 < c7
c13 < c1
c14 < c2
c15 < c3
c16 < c4
c16 < c13
c17 <= c5
c17 < c13
c18 < c6
c18 < c13
c27 < c21
c28 < c22
c30 < c24
c33 < c21
c34 < c22
c36 < c24
c39 < c38
c40 < c39
c41 => c42+c43
c45/c38 > 5 And < 354
c45/c38>g_sigprv.minben AND 5 And < 354
c46/c39>g_sigprv.minben AND 5 And < 354
c47/c40>g_sigprv.minben AND 5 And < 354
c48/c41>g_sigprv.minben AND= c49+c50
c49/c42 > 5 And < 354
c49/c42>g_sigprv.minben AND 5 And < 354
c50/c43>g_sigprv.minben AND 0
c57 < c56
c58 < c56
Exception Edits:
c2-c6, c8-c12, c14-c24, c27, c28, c33, c34, c38-c40, c42-c47, c49, c50, c51-c53, c54, c55, c56
C-23
Appendix C
ar5159
Data Exception Edits
Cell
Percentage
Increase
Percentage
Decrease
Absolute
Value
c2
70
40
75
c3
85
35
5000
c4
35
25
250
c5
70
60
600
c6
90
30
260
c8
75
50
150
c9
125
65
75
c10
125
65
75
c11
100
95
75
c12
100
60
75
c14
85
35
75
c15
125
65
75
c16
500
80
75
c17
110
50
75
c18
400
80
75
c19
50
30
1600
c20
70
45
150
c21
50
20
30000
C-24
c22
25
20
1700
c24
35
25
1700
c27
50
20
400
c28
50
20
75
c33
50
20
75
c34
50
35
75
c38
35
20
25000
c39
35
20
25000
c40
30
23
1500
c42
50
30
350
c43
35
27
350
c45
50
23
3500000
c46
50
23
3000000
c47
50
23
200000
c49
50
35
40000
c50
50
28
40000
c51
60
37
3500
c53
45
35
130
c54
75
50
150
c55
65
40
75
c56
50
30
700
Appendix C
TABLE: ae5159 / at5159
Errors:
c1 through c51 cannot be NULL
c49 <= c2
c49 >= 0
c50 <= c5
c50 >= 0
c51 <= c8
c51 >= 0
Warnings:
c3 <= c1
c4 <= c1
c7 <= c1
c18 <= c12
c24 <= c12
c30 <= c29
c30 <= c29
c31 <= c29
c31 >= c33+c32
c36 <= c35
c37 <= c35
c37 >= c38+c39
c41 <= c40
c42 <= c40
c44 <= c43
c45 <= c43
TABLE: aw5159
Errors:
c1 through c9 cannot be NULL
c1 through c9 > = 0
c8 <= c1+c2
c9 <= c3
Warning:
c4 <= c3
C-25
Appendix C
TABLE: ar8401
Errors:
c1 through c4 cannot be NULL
c1 >= 0
c1 cannot be duplicated for the state
c4 = ‘c’ or ‘s’
c6 = c11+c12+c13+c14 +/- 1
c7 = c15+c16+c17 +/-1
c8 = c5+c6-c7 +/-1
c9 = c18/calendar days in month +/- 1
c10 = (c9 * 100)/c7 +/- 1
Warnings:
c5 = c8 previous report
C-26
Appendix C
TABLE: ar8405
Errors:
c1 through c4 cannot be NULL
c1 >= 0
c1 cannot be duplicated for the state
c4 = ‘c’ or ‘s’
c8 = c12+c13+c14+c15 +/- 1
c9 = c5+c6 - c7 - c8 +/- 1
c10 = (c16/calendar days in month) +/- 1
c11 = (c10 * 100)/c6 +/- 1
Warnings:
c5 = c9 previous report
C-27
Appendix C
TABLE: ar8413
Errors:
c1 through c3 cannot be NULL
c1 >= 0
c1 cannot be duplicated for the state
c8 = c7+c5-c6 +/- 1
c9 = (c4/calendar days on the month) +/-1
c11 = c9-c10 +/-1
c13 = c12*c11/100 +/-1
c14 = c11-c13 +/-1
c19 = c17*c18 +/- 1
c22 = c20*c21 +/- 1
c25 = c23*c24 +/- 1
c28 = c26*c27 +/- 1
c32 = c19+c22+c25+c28+c29+c30+c31 +/- 1
c33 = c16-c32 +/- 1
Warnings:
c7 = c8 previous report
c16 = (c15/1200) * c14 +/- 1
C-28
Appendix C
TABLE: ar8414
Errors:
c1 through c3 cannot be NULL
c1 >= 0
c1 cannot be duplicated for the state
c8 = c7+c5-c6 +/- 1
c9 = (c4/calendar days in the month) +/- 1
c11 = c9-c10 +/- 1
c13 = c12*c11/100 +/- 1
c14 = c11-c13 +/- 1
c19 = c17*c18 +/- 1
c22 = c20*c21 +/- 1
c25 = c23*c24 +/- 1
c28 = c26*c27 +/- 1
c31 = c29*c30 +/- 1
c35 = c19+c22+c25+c28+c31+c32+c33+c34 +/- 1
c36 = c16-c35 +/- 1
Warnings:
c7 = c8 previous report
c16 = (c15/1200) * c14 +/- 1
C-29
Appendix C
TABLE: ar902
Errors:
c1 through c68 cannot be NULL
500 <= c1 <= 9999
c17 <= c5
c45 <= c33
c46 <= c34
c57 <= c4
c60 <= c33
c61 <= c34
c62 <= c58
c63 <= c59
c64 <= c45
c64 <= c60
c65 <= c46
c65 <= c61
c60 = ‘I’ or ‘F’
Warnings:
c22 <= c21
c23/c22 < 400
If c22 != 0 then c23 != 0
c53 <= c49
c54 <= c50
c55 <= c51
C-30
Appendix C
TABLE: ar9000
Errors:
c1 through c184 cannot be NULL
c1 through c184 >= 0
c1 = c6+c5
c7 = c11+c12
c13 = c17+c18
c19 = c23+c24
c25 = c29+c30
c31 = c35+c36
c37 = c41+c42
c43 = c47+c48
c49 = c53+c54
c49 = c1+c7+c13+c19+c25+c31+c37+c43
c50 = c2+c8+c14+c20+c26+c32+c38+c44
c51 = c3+c9+c15+c21+c27+c33+c39+c45
c52 = c4+c10+c16+c22+c28+c34+c40+c46
c53 = c5+c11+c17+c23+c29+c35+c41+c47
c54 = c6+c12+c18+c24+c30+c36+c42+c48
c55 = c59+c60
c61 = c65+c66
c67 = c71+c72
c73 = c77+c78
c79 = c83+c84
c85 = c89+c90
c91 = c95+c96
c97 = c101+c102
c103 = c107+c108
C-31
c103 = c55+c61+c67+c73+c79+c85+c91+c97
c104 = c56+c62+c68+c74+c80+c86+c92+c98
c105 = c57+c63+c69+c75+c81+c87+c93+c99
c106 = c58+c64+c70+c76+c82+c88+c94+c100
c107 = c59+c65+c71+c77+c83+c89+c95+c101
c108 = c60+c66+c72+c78+c84+c90+c96+c102
c109 = c113+c114
c115 = c119+c120
c121 = c125+c126
c127 = c131+c132
c133 = c137+c138
c139 = c143+c144
c145 = c149+c150
c145 = c109+c115+c121+c127+c133+c139
c146 = c110+c116+c122+c128+c134+140
c147 = c111+c117+c123+c129+c135+c141
c148 = c112+c118+c124+c130+c136+c142
c149 = c113+c119+c125+c131+c137+c143
c150 = c114+c120+c126+c132+c138+c144
c163 = c49+c103+c145
c163 = c151+c153+c155+c159
c164 = c50+c104+c146
c164 = c157+c160
c165 = c51+c105+c147
c165 = c152+c154+c156+c161
c166 = c52+c106+c148
c166 = c158+c162
Appendix C
TABLE: ar9016
Errors:
c1 through c9 cannot be NULL
Warnings:
c1 >= c2
c2 > c3
c3 > c8
c8 >= c9
C-32
Appendix C
TABLE: ar9047
Errors:
c1 through c6 cannot be NULL
c1 + c4 > 0
c1 >= c2+c3
c2+c5 > 0
c4 >= c5+c6
Warnings:
c2 < c3
c5 < c6
c2+c3 = c1
c5+c6 = c4
C-33
Appendix C
TABLE: ar9048
Errors:
c1 through c20 cannot be NULL
c1 != 0
c2 != 0
c2 <= c1
c3 != 0
c3 <= c1
c4 <= c1
c4 <= 40% of c3
c5 != 0
c6 <= c5
c7 <= c5
c8 < = c5
c9 <= c5
c10 <= c5
c11 <= c5
c12 < = c5
c13 != 0
c13 <= 110% of c5
c14 <= c13
c15 <= c13
c16 <= c13
c17 <= c13
c18 <= c13
c19 <= c13
c20 <= c13
Warnings:
c1 <= ar5159.c2 + ar5159.c8 + ar5159.c14 for the same quarter (3 monthly reports),
If any one of the ar5159 reports is missing, ignore this edit
c4 <= 20% of c3
c5 <= c6+c7+c8+c9+c10+c11+c12
c13 >= 80% of c5
c13 <= c14+c15+c16+c17+c18+c19+c20
C-34
Appendix C
TABLE: ar9049
Errors:
c1 through c24 cannot be NULL
c1 <= ar9048.c3 for same rptdate (if exists)
c2 <= 30
c9 <= ar9048 c3 for same rptdate (if exists)
c10 <= ar9048 c3 for same rptdate (if exists)
c11 <= ar9048 c3 for same rptdate (if exists)
c12 <= ar9048 c3 for same rptdate (if exists)
c17 <= c9
(if exists)c17 <= ar9048 c3 for same rptdate (if exists)
c18 <= c10
c19 <= c11
c20 <= c12
Warnings:
c13 is usually <= c4
c14 is usually <= c4
c15 is usually <= c4
c16 is usually <= c4
c21 is usually < c13
c22 is usually < c14
c23 is usually < c15
c24 is usually < c16
C-35
Appendix C
TABLE: ar9050 / ar9050p
Errors:
c1 = c2+c3+c4
c2=c10+c18+c26+c34+c42+c50+c58+c66+c74+c82+c90
c3=c11+c19+c27+c35+c43+c51+c59+c67+c75+c83+c91
c4=c12+c20+c28+c36+c44+c52+c60+c68+c76+c84+c92
c5 = c6+c7+c8
c6=c14+c22+c30+c38+c46+c54+c62+c70+c78+c86+c94
c7=c15+c23+c31+c39+c47+c55+c63+c71+c79+c87+c95
c8 = c16+c24+c32+c40+c48+c56+c64+c72+c80+c88+c96
c9 = c10+c11+c12
c13 = c14+c15+c16
c17 = c18+c19+c20
c21 = c22+c23+c24
c25 = c26+c27+c28
c29 = c30+c31+c32
c33 = c34+c35+c36
c37 = c38+c39+c40
c41 = c42+c43+c44
c45 = c46+c47+c48
c49 = c50+c51+c52
c53 = c54+c55+c56
c57 = c58+c59+c60
c61 = c62+c63+c64
c65 = c66+c67+c68
c69 = c70+c71+c72
c73 = c74+c75+c76
c77 = c78+c79+c80
c81 = c82+c83+c84
c85 = c86+c87+c88
c89 = c90+c91+c92
c93 = c94+c95+c96
TABLE: aw9050
Errors:
c1 = sum c2 through c12
C-36
Appendix C
TABLE: ar9051 / ar9051p
Errors:
c1 = c2+c3+c4
c2=c10+c18+c26+c34+c42+c50+c58+c66+c74+c82+c90
c3=c11+c19+c27+c35+c43+c51+c59+c67+c75+c83+c91
c4=c12+c20+c28+c36+c44+c52+c60+c68+c76+c84+c92
c5 = c6+c7+c8
c6=c14+c22+c30+c38+c46+c54+c62+c70+c78+c86+c94
c7=c15+c23+c31+c39+c47+c55+c63+c71+c79+c87+c95
c8=c16+c24+c32+c40+c48+c56+c64+c72+c80+c88+c96
c9 = c10+c11+c12
c13 = c14+c15+c16
c17 = c18+c19+c20
c21 = c22+c23+c24
c25 = c26+c27+c28
c29 = c30+c31+c32
c33 = c34+c35+c36
c37 = c38+c39+c40
c41 = c42+c43+c44
c45 = c46+c47+c48
c49 = c50+c51+c52
c53 = c54+c55+c56
c57 = c58+c59+c60
c61 = c62+c63+c64
c65 = c66+c67+c68
c69 = c70+c71+c72
c73 = c74+c75+c76
c77 = c78+c79+c80
c81 = c82+c83+c84
c85 = c86+c87+c88
c89 = c90+c91+c92
c93 = c94+c95+c96
TABLE: aw9051
Errors:
c1 = sum c2 through c12
C-37
Appendix C
TABLE: ar9052
Errors:
c1 = c2+c3+c4
c2 = c10+c18+c26+ c34+
c42+c50+c58+c66+
c74+c82+c90
c3 = c11+c19+c27+c35+
c43+c51+c59+c67+
c75+c83+c91
c4 = c12+c20+c28+c36+
c44+c52+c60+c68+
c76+c84+c92
c5 = c6+c7+c8
c6 = c14+c22+c30+c38+
c46+c54+c62+c70+
c78+c86+c94
c7 = c15+c23+c31+c39+
c47+c55+c63+c71+
c79+c87+c95
c8 = c16+c24+c32+c40+
c48+c56+c64+c72+
c80+c88+c96
c9 = c10+c11+c12
c13 = c14+c15+c16
c17 = c18+c19+c20
c21 = c22+c23+24
c25 = c26+c27+28
c29 = c30+c31+c32
c33 = c34+c35+c36
c37 = c38+c39+c40
c41 = c42+c43+c44
c45 = c46+c47+c48
c49 = c50+c51+c52
c53 = c54+c55+c56
c57 = c58+c59+c60
c61 = c62+c63+c64
c65 = c66+c67+c68
c69 = c70+c71+c72
c73 = c74+c75+c76
c77 = c78+c79+c80
c81 = c82+c83+c84
c85 = c86+c87+c88
c89 = c90+c91+c92
c93 = c94+c95+c96
c97 = c98+c99+c100
c98 = c106+c114+c122+
c130+c138+c146+
c154+c162+c170+
c178+c186
c99 = c107+c115+c123+
c131+c139+c147+
c155+c163+c171+
c179+c187
c100 = c108+c116+c124+
c132+c140+c148+
c156+c164+c172+
c180+c188
c101 = c102+c103+c104
c102 = c110+c118+c126+
c134+c142+c150+
c158+c166+c174+
c182+c190
c103 = c111+c119+c127+
c135+c143+c151+
c159+c167+c175+
c183+c191
c104 = c112+c120+c128+
c136+c144+c152+
c160+c168+c176+
c184+c192
c105 = c106+c107+c108
c109 = c110+c111+c112
c113 = c114+c115+c116
c117 = c118+c119+c120
c121 = c122+c123+c124
c125 = c126+c127+c128
C-38
c129 = c130+c131+c132
c133 = c134+c135+c136
c137 = c138+c139+c140
c141 = c142+c143+c144
c145 = c146+c147+c148
c149 = c150+c151+c152
c153 = c154+c155+c156
c157 = c158+c159+c160
c161 = c162+c163+c164
c165 = c166+c167+c168
c169 = c170+c171+c172
c173 = c174+c175+c176
c177 = c178+c179+c180
c181 = c182+c183+c184
c185 = c186+c187+c188
c189 = c190+c191+c192
c193 = c194+c195
c194 = c197+c200+c203+
c206+c209+c212+
c215+c218+c221+
c224+c227
c195 = c198+c201+c204+
c207+c210+c213+
c216+c219+c222+
c225+c228
c196 = c197+c198
c199 = c200+c201
c202 = c203+c204
c205 = c206+c207
c208 = c209+c210
c211 = c212+c213
c214 = c215+c216
c217 = c218+c219
c220 = c221+c222
c223 = c224+c225
c226 = c227+c228
Appendix C
TABLE: ar9053
Errors:
c1 = c2+c3+c4
c2 = c10+c18+c26+c34+
c42+c50+c58+c66+
c74+c82+c90
c3 = c11+c19+c27+c35+
c43+c51+c59+c67+
c75+c83+c91
c4 = c12+c20+c28+c36+
c44+c52+c60+c68+
c76+c84+c92
c5 = c6+c7+c8
c6 = c14+c22+c30+c38+
c46+c54+c62+c70+
c78+c86+c94
c7 = c15+c23+c31+c39+
c47+c55+c63+c71+
c79+c87+c95
c8 = c16+c24+c32+c40+
c48+c56+c64+c72+
c80+c88+c96
c9 = c10+c11+c12
c13 = c14+c15+c16
c17 = c18+c19+c20
c21 = c22+c23+24
c25 = c26+c27+28
c29 = c30+c31+c32
c33 = c34+c35+c36
c37 = c38+c39+c40
c41 = c42+c43+c44
c45 = c46+c47+c48
c49 = c50+c51+c52
c53 = c54+c55+c56
c57 = c58+c59+c60
c61 = c62+c63+c64
c65 = c66+c67+c68
c69 = c70+c71+c72
c73 = c74+c75+c76
c77 = c78+c79+c80
c81 = c82+c83+c84
c85 = c86+c87+c88
c89 = c90+c91+c92
c93 = c94+c95+c96
c97 = c98+c99+c100
c98 = c106+c114+c122+
c130+c138+c146+
c154+c162+c170+
c178+c186
c99 = c107+c115+c123+
c131+c139+c147+
c155+c163+c171+
c179+c187
c100 = c108+c116+c124+
c132+c140+c148+
c156+c164+c172+
c180+c188
c101 = c102+c103+c104
c102 = c110+c118+c126+
c134+c142+c150+
c158+c166+c174+
c182+c190
c103 = c111+c119+c127+
c135+c143+c151+
c159+c167+c175+
c183+c191
c104 = c112+c120+c128+
c136+c144+c152+
c160+c168+c176+
c184+c192
c105 = c106+c107+c108
c109 = c110+c111+c112
c113 = c114+c115+c116
c117 = c118+c119+c120
c121 = c122+c123+c124
c125 = c126+c127+c128
C-39
c129 = c130+c131+c132
c133 = c134+c135+c136
c137 = c138+c139+c140
c141 = c142+c143+c144
c145 = c146+c147+c148
c149 = c150+c151+c152
c153 = c154+c155+c156
c157 = c158+c159+c160
c161 = c162+c163+c164
c165 = c166+c167+c168
c169 = c170+c171+c172
c173 = c174+c175+c176
c177 = c178+c179+c180
c181 = c182+c183+c184
c185 = c186+c187+c188
c189 = c190+c191+c192
c193 = c194+c195
c194 = c197+c200+c203+
c206+c209+c212+
c215+c218+c221+
c224+c227
c195 = c198+c201+c204+
c207+c210+c213+
c216+c219+c222+
c225+c228
c196 = c197+c198
c199 = c200+c201
c202 = c203+c204
c205 = c206+c207
c208 = c209+c210
c211 = c212+c213
c214 = c215+c216
c217 = c218+c219
c220 = c221+c222
c223 = c224+c225
c226 = c227+c228
Appendix C
TABLE: ar9054h
Errors:
c1 = c2 + c3
c2 = c5+c8+c11+c14+c17+c20+c23+c26+c29+c32+c35+c38+c41+c44
c3 = c6+c9+c12+c15+c18+c21+c24+c27+c30+c33+c36+c39+c42+c45
c4 = c5 + c6
c7 = c8 + c9
c10 = c11 + c12
c13 = c14 + c15
c16 = c17 + c18
c19 = c20 + c21
c22 = c23 + c24
c25 = c26 + c27
c28 = c29 + c30
c31 = c32 + c33
c34 = c35 + c36
c37 = c38 + c39
c40 = c41 + c42
c43 = c44 + c45
TABLE: ar9054l
Errors:
c1 = c2 + c3
c2 = c5+c8+c11+c14+c17+c20+c23
c3 = c6+c9+c12+c15+c18+c21+c24
c4 = c5 + c6
c7 = c8 + c9
c10 = c11 + c12
c13 = c14 + c15
c16 = c17 + c18
c19 = c20 + c21
c22 = c23 + c24
C-40
Appendix C
TABLE: ar9055h
Errors:
c1 = c2+c3+c4+c5+c6+c7
c8 > 1.0
c9 > 1.0
Warnings:
c8 < 200.0
c8 < c8 in previous month’s report * 125%
c8 > c8 in previous month’s report * 75%
c9 < 200.0
c9 < c9 in previous month’s report * 125%
c9 > c9 in previous month’s report * 75%
TABLE: ar9055l
Errors:
c1 = c2+c3+c4+c5+c6+c7
c9 > 1.0
c10 > 1.0
Warnings:
c9 < 200.0
c9 < c9 in previous month’s report * 125%
c9 > c9 in previous month’s report * 75%
c10 < 200.0
c10 < c10 in previous month’s report * 125%
c10 > c10 in previous month’s report * 75%
C-41
Appendix C
TABLE: ar9056
Errors:
c1: must be numeric (fatal error)
c2: = Values: 10, 20, 30, 31, 40, 50, 60, 70, 73, 80, 81, 82, 83, 84, 85, 86, 90, 99
c3: if c26 = ‘N’, then c3 is null; else c3 = ‘Y’ or ‘N’
c4: if c3 = ‘N’, then c4 values: 00, 01, 10, 20, 30, 31, 40, 50, 60, 70, 73, 80, 81, 82, 83, 84, 85,
86, 90, 99 and c4 != c2
c4: if c3 = ‘Y’ or c26 = ‘N’, then c4 must be null
c5: if c26 = ‘N’, then c5 is null; else c5 = ‘Y’ or ‘N’
c6: if c26 = ‘N’, then c6 is null; else c6 = ‘A’ or ‘D’
c7: if c26 = ‘N’, then c7 is null; else c7 = ‘Y’ or ‘N’
c8: if c26 = ‘N’, then c8 is null
c10 > 01/01/1990
c10: if state = ‘NY’, then day = Sunday; else day = Saturday
c11: if c26 = ‘N’, then c11 is null; else c11 = ‘Y’ or ‘N’
c12 > 01/01/1990
c12: if c11 = ‘N’, then c12 != c10
c12: if c11 = ‘Y’ or c26 = ‘N’, then c12 is null
c13 <= c24
c13: if c26 = ‘N’, then c13 is null
c14: if c26 = ‘N’, then c14 is null; else c14 = ‘Y’ or ‘N’
c15 > 01/01/1990
c15: if c14 = ‘N’, then c15 <= c24 and c15 != c13
c15: if c14 = ‘Y’ or c26 = ‘N’, then c15 is null
c16 = ‘A’, ‘I’,’N’, ‘X’
c16: if c26 = ‘N’, then c16 is null
c17 = ‘A’, ‘I’,’N’, or ‘X’
c17: if c26 = ‘N’, then c17 is null
c18 = ‘A’, ‘I’,’N’, or ‘X’
c18: if c26 = ‘N’, then c18 is null
c20: if c21 = ‘W’, then c20 = ‘Q’ or ‘W’; else c20 = ‘M’, ‘Q’, or ‘W’
c20: if c26 = ‘N’, then c20 is null
c21: if c20 = ‘M’, then c21 = ‘A’ or ‘I’; else c21 = ‘A’, ‘I’, or ‘W’
c21: if c26 = ‘N’, then c21 is null
c24 must be within sample quarter
c26 = ‘Y’ or ‘N’
c27 >= 0
c27 != 85 and != 90
c28: if c26 = ‘N’, then c28 is null; else c28 = ‘UI’, ‘UCFE’, or ‘UCX’
c29: if c26 = ‘N’, then c29 is null; else c29 = ‘Y’ or ‘N’
c30: if c26 = ‘N’ or c29 = ‘Y’, then c30 is null
Warning:
c12 must be less than rptdate + 7
C-42
Appendix C
TABLE: ar9057
Errors:
c1: c1 > 0 (fatal error)
c2 = ‘A’ or ‘D’
c3 = ‘A’, ‘R’, or ‘M’
c4 = ‘G’, ‘F’, ‘U’, or ‘D’
c5 = ‘G’, ‘F’, or ‘U’
c6 = ‘G’, ‘F’, ‘U’, or ‘D’
c7 = ‘G’, ‘F’, ‘U’, or ‘D’
c8 = ‘G’, ‘F’, or ‘U’
c9 = ‘G’, ‘F’, ‘U’, or ‘D’
c10 = ‘G’, ‘F’, or ‘U’
c11 = ‘G’, ‘F’, or ‘U’
c12 = ‘G’, ‘F’, ‘U’, or ‘D’
c13 = ‘G’, ‘F’, or ‘U’
c14 = ‘G’, ‘F’, ‘U’, or ‘D’
c15 = ‘G’, ‘F’, or ‘U’
c16 = ‘G’, ‘F’, or ‘U’
c17 = ‘G’, ‘F’, ‘U’, or ‘D’
c18 = ‘G’, ‘F’, ‘U’, or ‘D’
c19 = ‘G’, ‘F’, ‘U’, or ‘D’
c20 = ‘G’, ‘F’, ‘U’, or ‘D’
c21 = ‘G’, ‘F’, or ‘U’
c22 = ‘G’ or ‘U’
c23 = ‘G’, ‘F’, or ‘U’
c24 = ‘G’, ‘F’, or ‘U’
c25 = ‘G’ or ‘U’
c26 = ‘G’, ‘F’, or ‘U’
c27 = ‘G’ or ‘U’
c28 = ‘G’ or ‘U’
c29 = ‘G’, ‘F’, or ‘U’
c30 = ‘G’ or ‘U’
c31 = ‘G’, ‘F’, or ‘U’
c32 = ‘G’, ‘F’, or ‘U’
c33 = ‘G’, ‘F’, or ‘U’
c34 = ‘G’, ‘F’, or ‘U’
c35 => report period start
c35 <= rptdate
c36 => c35
c36 < today
c37 = “OK”, “TI”, “TM”, “DM”, “IM”, or “MM”
c38 > 0
c39 must not be null
C-43
Appendix C
TABLE: ar9128
Errors:
c1 through c24 != NULL
c1 through c3 > 0
c2 >= c1
c4 <= c3
c5 <= c4
c6 <= c4
c7 <= c3
c8 <= c7
c9 <= c7
c10 <= c7
c11 <= c7
c12 <= c7
c13 <= c7
If c13 > 0 then c14 > 0
c15 <= c2
c16 <= c15
c17 <= c15
c18 <= c15
c19 <= c15
If c19 > 0 then c20 > 0
c21 <= c15
c22 <= c15
Warning:
c3 != c2
C-44
Appendix C
TABLE: ar9129
Errors:
c1 through c16 != NULL
c1 through c3, c5, c9 through c11, c13 > 0
c2 > c1
c4 <= c1
c5 <= c1
c6 <= c1
c7 <= 27
c10 > c9
c13 <= c9
c14 <= c9
c15 <= 27
C-45
Appendix C
TABLE: arui1
Errors:
c11 through c20 > 0
c11 = c12+c13+c14+c15
c16 = c17+c18+c19+c20
C-46
Appendix C
TABLE: arui3
Errors:
rptdate: if mlflag = 2 for 09/30/YY+1, then cannot update 12/31/YY, 03/31/YY+1, 06/30/YY+1
rptdate: cannot update 09/30/YY+1 after 6 months past the due date of the 09/30/YY+1
c1 through c18, c20, c24, c26, c29, c31 through c36, c39 through c42, c44, c49 through c52, c55,
c62, c65, c71 cannot be null
c1 through c6, c9 through c12, c14 through c18 < 10,000
c7, c8, c13 < 1,000
c20 = ‘Y’ or ‘N’
c23, c25, c28, c30, c76: arMPU for the fiscal year exists (fatal error)
c24 = at5159.(c1+c2+c3+c4+c5+c6+c7+c8+c9+c46+c47+c48)
c26 = at5159.(c12+c15+c18+c21+c24+c27)
c29 = at207.(c1+c3+c5)
c31 = at5130.(c1+c2+c3+c4+c5+c6)
c44 = ar9016.c1
c49, c50, c51: arui1 for the fiscal year exists (fatal error)
c52 = at5159.(c2+c3+c6+c8+c9+c12+c14+c15+c18+c97+c98+c99) +
ae5159.(c1+c3+c4+c6+c7+c9+c46+c47+c48+c49+c50+c51) + aw5159.(c1+c2)
c55 = ar5159.(c21+c24+c27+c30+c33+c36) + ae5159.(c12+c15+c18+c21+c24+c27) +
aw5159.c3
c62 = ar207.(c1+c13+c15) + ae207.(c1+c3+c5)
c76: arui1 for the fiscal year exists (fatal error)
c82 = ar5159.(c4+c10+c16-c97-c98-c99) + ae5159.(c2+c5+c8-c8-c49-c50-c51)
Warning:
c44: ar9016 for the quarter exists
c44: ar9016 has been submitted to National Office
c49, c50, c51, c76: arui1 has been submitted to National Office
c52: all ar5159 for the quarter exists
c52: all the ar5159, ae5159, aw5159 for the quarter have been submitted to National Office
c55: all ar5159 for the quarter exists
c55: all the ar5159 for the quarter have been submitted to National Office or
all the ae5159 or aw5159 for the quarter have been submitted to National Office if exists
c62: ar207 for the quarter exists
c62: ar207, ae207 has been submitted to National Office if exists
c65: ar5130 for the quarter exists
c65: ar5130, ae5130 has been submitted to National Office if exists
c82: ar5159 for the quarter exists
c82: ar5159 has been submitted to National Office
C-47
Appendix C
TABLE: abui3
Errors:
c2 = armpu.ic
c4 = armpu.wc
c6 = armpu.nm
c8 = armpu.ap
c15 = c28+c29+c14
c18 = arui1.c17 (Qtr 1)
c18 = arui1.c18 (Qtr 2)
c18 = arui1.c19 (Qtr 3)
c18 = arui1.c20 (Qtr 4)
c19 = arui1.c17 (Qtr 1)
c19 = arui1.(c17+c18) (Qtr2)
c19 = arui1.(c17+c18+c19) (Qtr4)
c19 = arui1.(c17+c18+c19) (Qtr4)
C-48
| File Type | application/pdf |
| Author | CTHOMAS |
| File Modified | 2008-05-09 |
| File Created | 2008-05-06 |