Unemployment Insurance Data Validation Program

Unemployment Insurance Data Validation (DV) Program

Record Layout

Unemployment Insurance Data Validation Program

OMB: 1205-0431

⚠️ Notice: This form may be outdated. More recent filings and information on OMB 1205-0431 can be found here:

2022-07-26 - Extension without change of a currently approved collection

Document [pdf]

Download: pdf | pdf

Unemployment Insurance Data Validation Operations Guide

APPENDIX A

Unemployment Insurance Data Validation Operations Guide

EXPLANATION OF UI BENEFITS DATA FORMATS
There are five types of data formats referred to in Appendix A.
1. Required. These fields cannot be blank. They may be mandatory dates and
dollar values.
2. Text. These fields have text values that must be entered, such as UI, partial,
voluntary quit, etc. All of the allowable generic text values for each field are
listed in the record layout. The generic text values must be followed by a
dash and the corresponding state-specific value.
3. Optional (these fields are gray in Appendix A). The software does not
look at these fields at all. Any values can be entered or they can be left
blank.
4. Must be blank. These are text or date fields where the presence of data
indicates an error. Therefore, they must be left blank (such as monetary date
where the subpopulation is for a claim with no monetary determination or a
UCFE amount for a UI only payment).
5. Must be blank or 0. These are numeric fields where the presence of data
other than “0” indicates an error.
Some values are abbreviated in the record layouts (Appendix A) but are shown in
the report validation specifications (Appendix A) in their entirety for informational
purposes.
Notes:
For most steps referenced in Appendix A column headers, Rule 1 is the indicator
in the state system. However, if a state does not maintain the indicator specified
in Rule 1, then the state programmer must review the other rules in that step in
order to develop the required validation logic.
Unique ID is required for populations 2, 4, 6, 7, 8, 9, 10, and 11 and optional for
populations 5, 12, 13, and 14 because not all states maintain the indicators for
these four populations. There is no unique ID field for populations 1 and 3.
Federal Wages are required in certain situations. In population 4, for Joint
UI/Federal payments UCFE amount and/or UCX amount is required. In
population 4 for UCFE or UCFE/UCX payments, UCX amount is only required for
joint UCFE and UCX claims. In populations 12, 13 and 14 federal amount is
required for UI overpayments when there are also federal wages.

A-1

SSN

Type of UI
Program

Program Type

Intrastate/
Interstate

Date Week
Claimed

APPENDIX A

Claim Weekending Date

Field Name

OBS

No.

Step 11 - Rule 1

Intrastate: Step 5A - Rules 1
and 2
Interstate Received as Liable
State: Step 5B - Rules 1 and 2
Interstate Filed From Agent
State: Step 5D - Rules 1
and 2

UI: Step 4A - Rule 1
UCFE: Step 4B - Rule 1
UCX: Step 4C - Rule 1

Regular UI: Step 2A - Rule 1

Step 1A - Rule 1

Step 1A - Rule 2

Module 3 Reference

A-2

The date the week was claimed.

Intrastate, Interstate received as
liable state, or Interstate filed
from agent state.

UI, UCFE, or UCX.

Regular UI claim.

Social Security Number

The week-ending date of the
week claimed.

State assigned sequential unique
identifier for each record in the
extract file.

Field Description

Date - MM/DD/YYYY
(Required)

Text - Intrastate
Interstate liable
Interstate agent
(Required)

Text - UI
UCFE
UCX
(Required)

Text - Regular UI
(Required)

Number - 000000000
(Required)

Date - MM/DD/YYYY
(Required)

Number - 00000000
(Required)

Data Format

Example: If the state-specific code for UI Program Type is 01, then the data format would be UI-01.
Constraint

NOT NULL

RECORD LAYOUT

DATE

CHAR (30)

CHAR (20)

CHAR (9)

DATE

INTEGER

Data Type

This record layout provides the format for the validation extract file. The extract file type must be ASCII, comma delimited columns. Data
must be in the order listed in the record layout. The data Format column indicates the generic values for text fields. These must be
followed by a dash and the state-specific value. The Module 3 reference indicates the step where the state-specific values are
documented.

BENEFITS RECORD LAYOUT FOR POPULATION 1

Unemployment Insurance Data Validation Operations Guide

Earnings

WBA

User

APPENDIX A

Field Name

Monetarily Eligible
or Pending

No.

Step 11 - Rule 3

Step 11 - Rule 2

Module 3 Reference

A-3

User defined field. Can be used
for any additional data element.
Not mandatory.

Weekly benefit allowance

Earnings for the week claimed
except for interstate filed from
agent state claims.

Claimant is monetarily eligible for
benefits when the week was
claimed if: benefits have not
been exhausted or monetary
eligibility is pending, i.e. eligibility
has not been finally determined.

Field Description

Unemployment Insurance Data Validation Operations Guide

Data Format

Text
(Optional)

Number - 0000000.00
(Required)

Number - 0000000.00
(Required except optional for
Interstate filed from agent state
claims)

Text EligiblePending(Optional)

Data Type

NOT NULL

Constraint

RECORD LAYOUT

CHAR (100)

DECIMAL (9,2)

CHAR (30)

Check Number
Unique ID

Type of UI
Program

Program Type

MBA

WBA

Actual Weeks of
Duration

APPENDIX A

SSN

Field Name

OBS

No.

Step 9A - Rules 1 and 2

Step 7 - Rules 1 and 2

Step 9A and 9B - Rule 1

UI: Step 4A - Rule 1
UCFE: Step 4B - Rule 1
UCX: Step 4C - Rule 1

Regular UI: Step 2A - Rule 1

Step 1C - Rule 2

Step 1C - Rule 1

Module 3 Reference

Data Format

A-4

The number of actual weeks of
duration of the claim.

The weekly benefit allowance.

Number - 00
(Required except optional for
UCFE and UCX claims)

Number - 0000000.00
(Required)

Text - UI
UCFE
UCX
(Required)

UI, UCFE or UCX.

The maximum benefit
allowance.

Text - Regular UI
(Required)

Number - 0000000000
(Required)

Number - 000000000
(Required)

Number - 00000000
(Required)

Regular UI claim.

The check number or other
unique ID.

Social Security Number

Sequential number, start at 1.
Provides for a unique identifier
for each record in the extract
file.

Field Description

Example: If the state-specific code for UCFE is 5, then the data format would be UCFE-5.
Constraint

NOT NULL

RECORD LAYOUT

INTEGER

DECIMAL (9,2)

NOT NULL

CHAR (30)

DECIMAL (9,2)

NOT NULL

CHAR (20)

CHAR (30)

CHAR (9)

INTEGER

Data Type

BENEFITS RECORD LAYOUT FOR POPULATION 2

Unemployment Insurance Data Validation Operations Guide

Mail Date of Final
Payment

Balance

User

APPENDIX A

Field Name

Maximum Weeks
of Duration

No.

Step 10C - Rule 2

Step 10C - Rule 3

Steps 9B and 9C - Rule 1

Module 3 Reference

A-5

User defined field. Can be
used for any additional data
element. Not mandatory.

The balance left on the claim
at the time of the final
payment.

The mail date of the final
payment.

The number of actual weeks of
duration at the maximum or
not.

Field Description

Unemployment Insurance Data Validation Operations Guide

Data Format

Text
(Optional)

Number 0000000.00(Required)

Date - MM/DD/YYYY
(Required)

Text - Y
N
(Required except optional for
UCFE and UCX claims)

Data Type

NOT NULL

Constraint

RECORD LAYOUT

CHAR (100)

DECIMAL (9,2)

DATE

CHAR (20)

Date Claim
Filed/IB-4 Sent

Type of UI
Program

APPENDIX A

SSN

Field Name

OBS

No.

Regular UI: Step 2A - Rule 1

Step 3A - Rules 1 and 6
Step 3C - Rule 1

Step 1B - Rule 1

Module 3 Reference

A-6

Regular UI claim.

The date the claim was filed in
person, by mail or telephone,
or by other means.

Social Security Number

State assigned sequential
unique identifier for each
record in the extract file.

Field Description

Text - Regular UI
(Required)

Date - MM/DD/YYYY
(Required)

Number - 000000000
(Required)

Number - 00000000
(Required)

Data Format

Data Type

Constraint

NOT NULL

RECORD LAYOUT

CHAR (20)

DATE

CHAR (9)

INTEGER

Example: If the state-specific code for Transitional claim is T, then the data format would be TRANSITIONAL-5.

BENEFITS RECORD LAYOUT FOR POPULATION 3

Unemployment Insurance Data Validation Operations Guide

Program Type

APPENDIX A

Field Name

Type of Claim

No.

UI: Step 4A - Rule 1
UCFE: Step 4B - Rule 1
UCX: Step 4C - Rule 1

New: Step 3A - Rule
2Transitional: Step 3C Rule 2Entering SelfEmployment: Step 3D Rule 2Additional: Step
3B - Rule 2Reopened:
Step 3B - Rule 7New
CWC claim:Step 3A Rule 6New CWC claim
filed in prior quarter:
Step 3A - Rule 7New
claim filed in prior
quarter: Step 3A - Rule
5

Module 3 Reference

UI, UCFE or UCX.

A-7

New claim,Transitional
claim,Entering selfemployment,Additional
claim,Reopened claim,New
CWC claim,New CWC claim
filed in a prior quarter,
orNew claim filed in a prior
quarter.

Field Description

Unemployment Insurance Data Validation Operations Guide

Data Format

Text - UI
UCFE
UCX
(Required except optional for CWC and
entering self-employment program claims)

Text - NewTransitional Entering SelfEmploymentAdditionalReopenedCWC
NewPrior Qtr New CWCPrior Qtr New
Claim(Required)

CHAR (30)

Constraint
NOT NULL

RECORD LAYOUT

Data Type
CHAR (30)

APPENDIX A

Date of Original
Monetary

Field Name

Intrastate/
Interstate

No.

Step 6A - Rules 1 and 2
Step 6B - Rule 1

Intrastate: Step 5A Rules 1 and 2
Interstate Received as Liable
State: Step 5B Rules 1 and 2
Interstate Taken as Agent
State: Step 5C Rules 1 and 2
Interstate Filed From Agent
State: Step 5D Rules 1 and 2
Intrastate CWC: Step 5E Rules 1 and 2
Interstate CWC: Step 5F Rules 1 through 4

Module 3 Reference

A-8

Date the original determination
was made on whether the
claimant has sufficient baseperiod wages and/or
employment to establish a
benefit year.

Intrastate,
Interstate received as liable,
Interstate taken as agent,
Interstate filed from agent
state,
Intrastate combined wage
claim, or
Interstate combined wage
claim.

Field Description

Unemployment Insurance Data Validation Operations Guide

Data Format

Date - MM/DD/YYYY
(Required except must be
blank for "No Monetary" claim
and CWC claims with
insufficient wages and optional
for UCFE, UCX, interstate filed
from agent state, interstate
taken as agent state, and
entering self-employment
program claims)

Text - Intrastate
Interstate liable
Interstate taken
Interstate agent
CWC Intrastate
CWC Interstate
(Required except optional for
transitional claims, new claims
filed during a prior quarter, and
entering self-employment
program claims)

DATE

Constraint

RECORD LAYOUT

Data Type
CHAR (30)

APPENDIX A

WBA

Field Name

Sufficient/
Insufficient/
Combined
Wages

No.

Step 7 - Rules 1 and 2

Sufficient Wages: New
Benefit Year:
Step 6C - Rules 1 and 2
Sufficient Wages - No
New Benefit Year:
Step 6C - Rule 3
Insufficient Wages:
Step 6D - Rule 1
New CWC Wages:
Step 6C - Rule 4
No New CWC Wages:
Step 6D - Rules 2 and 3

Module 3 Reference

A-9

Weekly benefit allowance is
the maximum or less than
maximum.

The status of the new UI or
CWC claim at the time the 218
report was run: Sufficient-new
benefit year established;
Sufficient-no new benefit year
established; Insufficient;
Sufficient-new CWC benefit
year established.

Field Description

Unemployment Insurance Data Validation Operations Guide

Data Format

(States should include the
WBA after the dash which
follows the generic federal
value.)

Text - Maximum
Less than Maximum
(Required except must be
blank for insufficient, sufficient
but no benefit year, and "No
Monetary" claim, and optional
for UCFE, UCX, interstate
filed from agent state,
interstate taken as agent
state, CWC, and entering selfemployment program claims)

Text - Insufficient
Sufficient New BY
Sufficient No BY
Sufficient New CWC BY
(Required except must be
blank for "No Monetary" claim
and optional for UCFE, UCX,
interstate filed from agent
state, interstate taken as
agent state, and entering selfemployment program claims)

CHAR (30)

Constraint

RECORD LAYOUT

Data Type
CHAR (30)

APPENDIX A

Potential Weeks
of Duration

Field Name

MBA

No.

Step 8A - Rule 1

Steps 8A and 8B - Rule 1

Module 3 Reference

A-10

The number of full weeks of
benefits for which a claimant is
determined to be eligible within
a benefit year.

Maximum benefit allowance

Field Description

Unemployment Insurance Data Validation Operations Guide

Data Format

Number - 00
(Required except must be
blank or 0 for insufficient,
sufficient but no benefit year,
and "No Monetary" claim, and
optional for UCFE, UCX,
interstate filed from agent
state, interstate taken as agent
state, CWC, and entering selfemployment program claims)

Number - 0000000.00
(Required except must be
blank or 0 for insufficient,
sufficient but no benefit year,
and "No Monetary" claim, and
optional for UCFE, UCX,
interstate filed from agent
state, interstate taken as agent
state, CWC, and entering selfemployment program claims)

Data Type

INTEGER

Constraint

RECORD LAYOUT

DECIMAL (9,2)

APPENDIX A

User

Field Name

Potential
Weeks
Maximum
Duration

No.
Step 8B - Rules 1 and 2

Module 3 Reference

A-11

User defined field. Can be
used for any additional data
element. Not mandatory.

The duration of the benefit
year is or is not the maximum
for the State.

Field Description

Unemployment Insurance Data Validation Operations Guide

Data Format

Text
(Optional)

Text - Y
N
(Required except must be
blank for insufficient, sufficient
but no benefit year, and "No
Monetary" claim, and optional
for UCFE, UCX, interstate filed
from agent state, interstate
taken as agent state, CWC,
and entering self-employment
program claims)

Data Type

Constraint

RECORD LAYOUT

CHAR (100)

CHAR (20)

Date Claim Filed

Type of UI
Program

Type of Claim

Program Type

Intrastate/
Interstate

APPENDIX A

SSN

Field Name

OBS

No.

Intrastate: Step 5A - Rules 1
and 2
Interstate Received as Liable
State: Step 5B - Rules 1 and 2

UI: Step 4A - Rule 1
UCFE: Step 4B - Rule 1
UCX: Step 4C - Rule 1

Additional: Step 3B - Rule 2

Regular UI: Step 2A - Rule 1

Step 3B - Rule 1

Step 1B - Rule 1

Module 3 Reference

A-12

Claim is intrastate, or interstate
received as liable.

Program type is UI, UCFE or
UCX.

Additional claim.

Regular UI claim.

The date the claim was filed in
person, by mail or telephone.

Social Security Number

State assigned sequential
unique identifier for each
record in the extract file.

Field Description

Text - Intrastate
Interstate liable
(Required)

Text - UI
UCFE
UCX
(Required)

Text - Additional
(Required)

Text - Regular UI
(Required)

Date - MM/DD/YYYY
(Required)

Number - 000000000
(Required)

Number - 00000000
(Required)

Data Format

Example: If the state-specific code for Additional Claim is A, then the data format would be ADDITIONAL-A.
Constraint

NOT NULL

RECORD LAYOUT

CHAR (30)

CHAR (20)

DATE

CHAR (9)

INTEGER

Data Type

BENEFITS RECORD LAYOUT FOR POPULATION 3a

Unemployment Insurance Data Validation Operations Guide

Separation Date

Last Employer

Separation
Reason

User

APPENDIX A

Field Name

Unclaimed Week

No.

Step 3B - Rule 6

Step 3B - Rule 5

Step 3B - Rule 4

Step 3B - Rule 3

Module 3 Reference

A-13

User defined field. Can be used
for any additional data element.
Not mandatory.

The reason for separation.

The name of the separating
employer.

The date of separation from an
employer since the last claim
was filed.

The week-ending date of the
unclaimed week prior to the
additional claim.

Field Description

Unemployment Insurance Data Validation Operations Guide

Data Format

Text
(Optional)

Text
(Required)

Date - MM/DD/YYYY(Required)

Date - MM/DD/YYYY
(Optional)

Data Type

NOT NULL

Constraint

RECORD LAYOUT

CHAR (100)

CHAR (30)

CHAR (50)

DATE

Check Number
Unique ID

Type of UI
Program

Program Type

APPENDIX A

SSN

Field Name

OBS

No.

UI: Step 4A - Rule 1
UCFE: Step 4B - Rule 1
UCX Only: Step 4C - Rule 1
UI/Federal: Step 4D - Rule 1
Self-Employment:
Step 4E - Rule 1

Regular UI: Step 2A - Rule 1

Step 1C - Rule 2

Step 1C - Rule 1

Module 3 Reference

A-14

Type of Program is UI only,
UCFE, UCFE/UCX, UCX only,
Joint UI/Federal, or SelfEmployment.

Regular UI claim.

The check number ID or other
unique check ID. For offsets
assign a unique ID number.

Social Security Number

State assigned sequential
unique identifier for each record
in the extract file.

Field Description

Text - UI Only
UCFE Only
UCFE/UCX
UCX Only
Joint UI/Federal
Self-employ
(Required except optional for
CWC payments)

Text - Regular UI
(Required)

Number - 0000000000
(Required)

Number - 000000000
(Required)

Number - 00000000
(Required)

Data Format

Data Type

Constraint

NOT NULL

RECORD LAYOUT

CHAR (30)

CHAR (20)

CHAR (30)

CHAR (9)

INTEGER

Example: If the state-specific code for Adjustment payment is 13, then the data format would be ADJUSTMENT-13.

BENEFITS RECORD LAYOUT FOR POPULATION 4

Unemployment Insurance Data Validation Operations Guide

Partial/Total
Weeks of
Unemployment

Earnings

APPENDIX A

Type of
Compensation

Field Name

Intrastate/
Interstate

No.

Step 10D - Rule 2
Step 10E - Rule 2

Partial: Step 10D - Rule 1
Total: Step 10E - Rule 1

First: Step 10A - Rule 1
Continued: Step 10B - Rule 1
Adjustment: Step 10F - Rule 1
Prior Weeks Compensated:
Step 10G - Rule 1

Intrastate: Step 5A - Rule
1Interstate Received as Liable
State: Step 5B - Rule
1Intrastate CWC:Step 5E - Rule
1Interstate CWC:Step 5F Rule 1

Module 3 Reference

A-15

The earnings for the week
claimed.

Week of partial or total
unemployment.

First Payment, Continued
Payment, Adjustment, SelfEmployment, Prior Weeks
Compensated.

Intrastate, Interstate, Intrastate
CWC, or Interstate CWC claim.

Field Description

Unemployment Insurance Data Validation Operations Guide

Data Format

Number - 0000000.00
(Required except optional for
UCFE only, UCFE/UCX, and
UCX only adjustments, and selfemployment and CWC
payments)

Text - Partial
Total
(Required except optional for
UCFE only, UCFE/UCX, and
UCX only adjustments, and for
self-employment and CWC
payments)

Text - First Payment
Continued Payment
Adjustment
Self-Employment
Prior Weeks Compensated
(Required)

Text InterstateIntrastateIntrastate
CWC Interstate CWC(Required
except optional for UCFE only,
UCFE/UCX, and UCX only
adjustments)

Data Type

NOT NULL

Constraint

RECORD LAYOUT

DECIMAL (9,2)

CHAR (20)

CHAR (50)

CHAR (30)

UCFE Amount

UCX Amount

APPENDIX A

UI Amount

Field Name

WBA

No.

Step 12C - Rule 1

Step 12B - Rule 1

Step 12A - Rule 1

Step 10D - Rule 3
Step 10E - Rule 3

Module 3 Reference

A-16

The amount of benefits paid
from military funds.

The amount of benefits paid
from Federal Funds.

The amount of benefits paid
from State Unemployment
Funds.

The weekly benefit allowance.

Field Description

Unemployment Insurance Data Validation Operations Guide

Data Format

Number - 0000000.00
(Required for UCX only, Joint
UI/Federal, and UCFE/UCX
payments; must be blank or 0
for all other payment types)

Number - 0000000.00
(Required for UCFE only, Joint
UI/Federal, and UCFE/UCX
payments; must be blank or 0
for all other payment types)

Number - 0000000.00
(Required except must be blank
or 0 for UCFE only, UCFE/UCX,
UCX only, self-employment,
and CWC payments)

Number - 0000000.00
(Required except optional for
UCFE only, UCFE/UCX, and
UCX only adjustments, and selfemployment and CWC
payments)

Data Type

Constraint

RECORD LAYOUT

DECIMAL (9,2)

Week End Date

Mail Date

User

APPENDIX A

Self-Employ
Amount

Field Name

CWC Amount

No.

Step 14 - Rule 1

Step 13 - Rule 1

Step 12E - Rule 1

Step 12D - Rule 1

Module 3 Reference

A-17

User defined field. Can be used
for any additional data element.
Not mandatory.

The date on which the payment
is actually mailed to the
claimant.

The week-ending date of the
week compensated.

The total dollars paid under the
SEA program.

The amount of benefits paid for
a combined wage claim
payment.

Field Description

Unemployment Insurance Data Validation Operations Guide

Data Format

Text
(Optional)

Date - MM/DD/YYYY
(Required)

Date - MM/DD/YYYY
(Required except optional for
adjustment, self-employment,
and all CWC payments with the
exception of CWC first
payments)

Number - 0000000.00
(Required for self-employment
payments; must be blank or 0
for all other payment types)

Number - 0000000.00
(Required for all CWC
payments; must be blank or 0
for all other payment types)

Data Type

NOT NULL

Constraint

RECORD LAYOUT

CHAR (100)

DATE

DECIMAL (9,2)

Issue Number
(Unique ID)

Type of UI
Program

Program Type

APPENDIX A

SSN

Field Name

OBS

No.

UI: Step 4A - Rule 1
UCFE: Step 4B - Rule 1
UCX: Step 4C - Rule 1

Regular UI: Step 2A - Rule 1
Workshare: Step 2B - Rule 1

Step 1D - Rule 2

Step 1D - Rule 1

Module 3 Reference

A-18

UI, UCFE, or UCX.

Regular UI claim or Workshare
claim.

The unique issue number or
other unique number assigned
to the nonmonetary
determination.

Social Security Number

State assigned sequential
unique identifier for each
record in the extract file.

Field Description

Text - UI
UCFE
UCX
(Required except optional for
multi-claimants)

Text - Regular UI
Workshare
(Required)

Number - 000000
(Required if State maintains a
unique ID)

Number - 000000000
(Required)

Number - 00000000
(Required)

Data Format

Example: If the state-specific code for UI Program Type is 01, then the data format would be UI-01
Constraint

NOT NULL

RECORD LAYOUT

CHAR (30)

CHAR (20)

CHAR (50)

CHAR (9)

INTEGER

Data Type

BENEFITS RECORD LAYOUT FOR POPULATION 5

Unemployment Insurance Data Validation Operations Guide

Type of Determination

APPENDIX A

Determination/
Redetermination

Field Name

Intrastate/ Interstate

No.

Step 17A - Rules 1 and 2
Step 17B - Rule 1

Step 16A - Rule 1Step 16B - Rule 1

Intrastate: Step 5A - Rule 1
Interstate Received as Liable State:
Step 5B - Rule 1

Module 3 Reference

Field Description

A-19

The determination was
based upon facts related
to an individual situation
or to groups of similarly
situated individuals.

The decision made by the
authority on an issue was
a determination or
redetermination.

Intrastate or interstate.

Unemployment Insurance Data Validation Operations Guide

Data Format

Text - Single
Multi
(Required)

Text - Determination
Redetermination
(Required)

Text - Intrastate
Interstate
(Required except optional for
multi-claimants)

Data Type

NOT NULL

Constraint

RECORD LAYOUT

CHAR (20)

CHAR (30)

Detection Date

APPENDIX A

First Week
Affected

Field Name

Issue Types

No.

Step 20 - Rule 1

Step 19 - Rules 1 and 2

VL: Step 18A - Rule 1
MC: Step 18B - Rule 1
Sep/Other: Step 18C - Rule 1
A & A: Step 18D - Rule 1
Ded. Income: Step 18E - Rule
1
Suitable Work: Step 18F - Rule
1
Reporting: Step 18G - Rule 1
Profiling: Step 18H - Rule 1
Other/Nonsep: Step 18I - Rule 1
Labor Dispute: Step 18J - Rule
1
Other Multiclaimaint Issues:
Step 18K - Rule 1

Module 3 Reference

A-20

The earliest date that the
agency is in possession of
information indicating the
existence of a nonmonetary
issue.

The week-ending date of the
first week in a claim series to
which a notice of nonmonetary
determination applies.

The separating issue was
voluntary leaving,
misconduct, or other separation
issue. The nonseparation issue
was
able and available for work,
deductible income, suitable
work refusal, reporting
requirements, profiling,
other nonseparation issue, or
labor dispute or other multiclaimant issue.

Field Description

Unemployment Insurance Data Validation Operations Guide

Data Format

Date - MM/DD/YYYY
(Required except optional for
redeterminations)

Text - VL
MC
Sep/Other
A&A
Ded. Income
Suitable Work
Reporting
Profiling
Other Nonsep
Labor Dispute
Other Multiclaimant
(Required)

Data Type

Constraint
NOT NULL

RECORD LAYOUT

DATE

CHAR (50)

User

APPENDIX A

Allow or Deny

Field Name

Notice Date

No.

Step 23A - Rules 1 and 2
Step 23B - Rules 1 and 2

Step 21 - Rule 1

Module 3 Reference

A-21

User defined field. Can be used
for any additional data element.
Not mandatory.

The outcome of the
nonmonetary determination was
an allow or a deny.

The date the determination
notice is mailed or, if no notice
is required, the date payment is
authorized, waiting week credit
is given, or an offset is applied.

Field Description

Unemployment Insurance Data Validation Operations Guide

Data Format

Text
(Optional)

Text - Allow
Deny
(Required)

Date - MM/DD/YYYY
(Required)

Data Type

Constraint

NOT NULL

RECORD LAYOUT

CHAR (100)

CHAR (20)

DATE

SSN

Docket Number
Unique ID

Appeal Level

Type of Appeal
(Single or
Multiclaimant)

APPENDIX A

OBS

Field Name

No.

Single: Step 25A - Rule 1
Multi: Step 25B - Rule 1

Step 24A - Rule 1

Step 1E - Rule 2

Step 1E - Rule 1

Module 3 Reference

A-22

The appeals case involves one
or more than one claimant.

The appeal type was a lower
authority appeal.

The Docket Number of the
lower authority appeal.

Social Security Number

State assigned sequential
unique identifier for each
record in the extract file.

Field Description

Text - S
M
(Required)

Text - Lower
(Required)

Number - 0000000000
(Required)

Number - 000000000
(Required)

Number - 00000000
(Required)

Data Format

Example: If the state-specific code for Single Claimant is N, then the data format would be S-N.

NOT NULL

Constraint

RECORD LAYOUT

CHAR (20)

CHAR (30)

CHAR (9)

INTEGER

Data Type

BENEFITS RECORD LAYOUT FOR POPULATION 6

Unemployment Insurance Data Validation Operations Guide

User

APPENDIX A

Filed Date

Field Name

Number of
Claimants

No.

Step 32 - Rule 1

Step 25B - Rules 3 and 5

Module 3 Reference

A-23

User defined field. Can be used
for any additional data element.
Not mandatory.

The date on which the appeal
was filed.

The number of claimants in a
multiclaimant appeal.If the State
stores a single record for a
multi-claimant appeal with a
field for the number of
claimants, insert the number in
this field. If the State stores a
record for each claimant
involved in a multi-claimant
appeal, include all of the
records in the file and insert a '1'
in this field.

Field Description

Unemployment Insurance Data Validation Operations Guide

Data Format

Text
(Optional)

Date - MM/DD/YYYY
(Required)

Number => 1(Required for
mutiple claimant appeals;
optional for single claimant
appeals)

Data Type

NOT NULL

Constraint

RECORD LAYOUT

CHAR (100)

DATE

INTEGER

Docket Number
Unique ID

Appeal Level

Type of Appeal
(Single or
Multiclaimant)

APPENDIX A

SSN

Field Name

OBS

No.

Single: Step 25A - Rule 1
Multi: Step 25B - Rule 1

Step 24B - Rule 1

Step 1F - Rule 2

Step 1F - Rule 1

Module 3 Reference

A-24

The appeals case involves one
or more than one claimant.

The appeal type was a higher
authority appeal.

The Docket Number of the
higher authority appeal.

Social Security Number

State assigned sequential
unique identifier for each
record in the extract file.

Field Description

Text - S
M
(Required)

Text - Higher
(Required)

Number - 0000000000
(Required)

Number - 000000000
(Required)

Number - 00000000
(Required)

Data Format

Example: If the state-specific code for Higher Authority Appeal is B, then the data format would be Higher-B.

NOT NULL

Constraint

RECORD LAYOUT

CHAR (20)

CHAR (30)

CHAR (9)

INTEGER

Data Type

BENEFITS RECORD LAYOUT FOR POPULATION 7

Unemployment Insurance Data Validation Operations Guide

User

APPENDIX A

Filed Date

Field Name

Number of
Claimants

No.

Step 32 - Rule 1

Step 25B - Rules 3 and 5

Module 3 Reference

A-25

User defined field. Can be used
for any additional data element.
Not mandatory.

The date on which the appeal
was filed.

The number of claimants in a
multiclaimant appeal. If the
State stores a single record for
a multi-claimant appeal with a
field for the number of
claimants, insert the number in
this field. If the State stores a
record for each claimant
involved in a multi-claimant
appeal, include all of the records
in the file and insert a '1' in this
field.

Field Description

Unemployment Insurance Data Validation Operations Guide

Data Format

Text
(Optional)

Date - MM/DD/YYYY
(Required)

Number => 1(Required for
multiple claimant appeals;
optional for single claimant
appeals)

Data Type

NOT NULL

Constraint

RECORD LAYOUT

CHAR (100)

DATE

INTEGER

SSN

Docket Number
Unique ID

Type of UI
Program

Program Type

Intrastate/
Interstate

Appeal Level

APPENDIX A

OBS

Field Name

No.

Step 24A - Rule 1

Intrastate: Step 5A Rules 1 and 2
Interstate Received as Liable
State: Step 5B - Rules 1 and 2

UI: Step 4A - Rule 1
UCFE: Step 4B - Rule 1
UCX: Step 4C - Rule 1

Regular UI: Step 2A - Rule 1
Workshare: Step 2B - Rule 1

Step 1E - Rule 2

Step 1E - Rule 1

Module 3 Reference

A-26

The appeal type is a lower authority
appeal.

Intrastate or Interstate.

UI, UCFE, or UCX.

Regular UI claim or Workshare claim.

The Docket Number or other unique ID
assigned to the appeal.

Social Security Number

State assigned sequential unique
identifier for each record in the extract
file.

Field Description

Text - Lower
(Required)

Text - Intrastate
Interstate
(Required)

Text - UI
UCFE
UCX
(Required)

Text - Regular UI
Workshare
(Required)

Number - 0000000000
(Required)

Number - 000000000
(Required)

Number - 00000000
(Required)

Data Format

Example: If the state-specific code for UI Program Type is 01, then the data format would be UI-01.

NOT NULL

Constraint

RECORD LAYOUT

CHAR (20)

CHAR (30)

CHAR (20)

CHAR (30)

CHAR (9)

INTEGER

Data Type

BENEFITS RECORD LAYOUT FOR POPULATION 8

Unemployment Insurance Data Validation Operations Guide

Field Name

Type of Appeal
(Single or
Multiclaimant)

APPENDIX A

No.
Single: Step 25A – Rule 1
Multi: Step 25B - Rule 1

Module 3 Reference

Field Description

A-27

States which maintain multiple records (one
for each claimant) for a multi-claimant appeal
should designate one of the records as the
lead claimant. States should insert a text
prefix of 'M-Lead’ in this field for the lead
claimant record. Both of these types of
records will be assigned to subpopulations
8.45 to 8.52 (lower) or 9.13 to 9.20 (higher).
States which maintain multiple records
should insert a prefix of 'M-Nonlead' in the
multi-claimant field for the non-lead
claimants. These records will be assigned to
subpopulations 8.53 (lower) or 9.21 (higher).

States which maintain a single record for
multi-claimant appeals with a field for the
number of claimants involved should insert a
text prefix of 'M-1' for a multi-claimant
appeal with only one record for the whole
appeal.

The determination is based upon facts
related to an individual situation or to groups
of similarly situated individuals.

Unemployment Insurance Data Validation Operations Guide

Data Format
Text - S
M-1
M-Lead
M-Nonlead
(Required)

Data Type

Constraint
NOT NULL

RECORD LAYOUT

CHAR (20)

In Favor of
Appellant

Filed Date

Decision Date

Disposed of by
Decision

APPENDIX A

Appellant

Field Name

Number of
Claimants in
Multiclaimant
Appeal

No.

By Decision: Step 30A Rule 1
Not by Decision: Step 30B
Rule 1

Step 28 - Rule 1

Step 32 - Rule 1

In Favor: Step 27A - Rule
1
Not in Favor: Step 27B Rule 1

Claimant: Step 26A - Rule
1
Employer: Step 26B Rule 1
Other: Step 26C - Rule 1

Step 25B - Rules 3 and 5

Module 3 Reference

A-28

The date the decision was mailed to the
interested parties concerned.
The appeals case was disposed of by a written
ruling.

The date on which the appeal was filed.

The decision was or was not in favor of the
appellant.

The appellant is the claimant, employer, or
other than claimant or employer.

The number of claimants involved in a
multiclaimant appeal (could be one if separate
records are provided for each participating
claimant)

Field Description

Unemployment Insurance Data Validation Operations Guide

Data Format

Date - MM/DD/YYYY
(Required)
Date - MM/DD/YYYY
(Required)
Text - Y
N
(Optional)

Text - Y
N
(Required except optional
for UCFE, UCX, and nonlead multi-claimant claims)

Text - Claimant
Employer
Other
(Required except optional
for UCFE, UCX, and nonlead multi-claimant claims)

Number => 1
(Required for multiple
claimant appeals; must be
blank or 0 for single
claimant appeals)

Data Type

NOT NULL

Constraint

RECORD LAYOUT

CHAR (20)

DATE

CHAR (20)

INTEGER

APPENDIX A

User

Field Name

Issue Code

No.
VL: Step 31A - Rule 1
MC: Step 31B - Rule 1
Suit: Step 31C - Rule 1
A&A: Step 31D - Rule 1
Other: Step 31E - Rule 1
Labor Disp: Step 31F - Rule 1

Module 3 Reference

Field Description

A-29

User defined field. Can be used for any
additional data element. Not mandatory.

The issue code of the appeal was voluntary
leaving, misconduct, refusal
of suitable work, able and available to work,
other issues, or labor dispute.

Unemployment Insurance Data Validation Operations Guide

Data Format

Text
(Optional)

Data Type

CHAR (100)

CHAR (30)

RECORD LAYOUT

Text - VL
MC
Suit
A&A
Other
Labor Disp
(Required except optional
for UCFE and UCX claims)

Constraint

SSN

Docket Number
Unique ID

Type of UI
Program

Program Type

Intrastate/
Interstate

Appeal Level

APPENDIX A

OBS

Field Name

No.

Step 24B - Rule 1

Intrastate: Step 5A - Rules 1 and
2
Interstate Received as Liable
State: Step 5B - Rules 1 and 2

UI: Step 4A - Rule 1
UCFE: Step 4B - Rule 1
UCX: Step 4C - Rule 1

Regular UI: Step 2A - Rule 1
Workshare: Step 2B - Rule 1

Step 1F - Rule 2

Step 1F - Rule 1

Module 3 Reference

A-30

The appeal is a higher authority appeal.

Intrastate or interstate.

UI, UCFE, or UCX.

Regular UI claim or Workshare claim.

The Docket ID or other unique number
assigned to the appeal.

Social Security Number

State assigned sequential unique
identifier for each record in the extract
file.

Field Description

Example: If the state-specific code for In Favor Of is F, then the data format would be Y-F.

Text - Higher
(Required)

Text - Intrastate
Interstate
(Required except optional
for non-lead claimant
multi-claimant appeals)

Text - UI
UCFE
UCX
(Required)

Text - Regular UI
Workshare
(Required)

Number - 0000000000
(Required)

Number - 000000000
(Required)

Number - 00000000
(Required)

Data Format

NOT NULL

Constraint

RECORD LAYOUT

CHAR (20)

CHAR(20)

CHAR(30)

CHAR (9)

INTEGER

Data Type

BENEFITS RECORD LAYOUT FOR POPULATION 9

Unemployment Insurance Data Validation Operations Guide

Field Name

Type of Appeal
(Single or
Multiclaimant)

APPENDIX A

No.
Single: Step 25A - Rule 1Multi:
Step 25B - Rule1

Module 3 Reference

A-31

States which maintain multiple records
(one for each claimant) for a multiclaimant appeal should designate one
of the records as the lead claimant.
States should insert a text prefix of 'MLead’ in this field for the lead claimant
record. Both of these types of records
will be assigned to subpopulations 8.45
to 8.52 (lower) or 9.13 to 9.20 (higher).
States which maintain multiple records
should insert a prefix of 'M-Nonlead' in
the multi-claimant field for the non-lead
claimants. These records will be
assigned to subpopulations 8.53
(lower) or 9.21 (higher).

States which maintain a single record
for multi-claimant appeals with a field
for the number of claimants involved
should insert a text prefix of 'M-1' for a
multi-claimant appeal with only one
record for the whole appeal.

The determination is based upon facts
related to an individual situation or to
groups of similarly situated individuals.

Field Description

Unemployment Insurance Data Validation Operations Guide

Data Format
Text - SM-1M-LeadMNonlead (Required)

Data Type

Constraint
NOT NULL

RECORD LAYOUT

CHAR (20)

In Favor of
Appellant

Filed Date

Decision Date

Disposed of by
Decision

APPENDIX A

Appellant

Field Name

Number of
Claimants in
Multiclaimant
Appeal

No.

By Decision: Step 30A Rule 1
Not by Decision: Step 30B Rule 1

Step 28 - Rule 1

Step 32 - Rule 1

In Favor: Step 27A - Rule 1
Not in Favor: Step 27B Rule 1

Claimant: Step 26A - Rule 1
Employer: Step 26B - Rule 1
Other: Step 26C - Rule 1

Step 25B - Rules 3 and 5

Module 3 Reference

A-32

The appeals case was disposed of by a
written ruling.

The date the decision was mailed to the
interested parties concerned.

The date on which the appeal was filed.

The decision was or was not in favor of
the appellant.

The appellant is the claimant,
employer, or other than claimant or
employer.

The number of claimants involved in a
multiclaimant appeal (could be one if
separate records are provided for each
participating claimant)

Field Description

Unemployment Insurance Data Validation Operations Guide

Data Format

Text - Y
N
(Optional)

Date - MM/DD/YYYY
(Required)

Text - Y
N
(Required except optional
for UCFE and UCX
claims, and non-lead
multi-claimant appeals)

Text - Claimant
Employer
Other
(Required except optional
for UCFE and UCX
claims, and non-lead
multi-claimant appeals)

Number => 1
(Required for multiple
claimant appeals; must
be blank or 0 for single
claimant appeals)

Data Type

NOT NULL

Constraint

RECORD LAYOUT

CHAR (20)

DATE

CHAR (20)

CHAR (30)

INTEGER

Field Name

User

APPENDIX A

No.

Module 3 Reference

A-33

User defined field. Can be used for any
additional data element. Not
mandatory.

Field Description

Unemployment Insurance Data Validation Operations Guide

Data Format
Text
(Optional)

Data Type

Constraint

RECORD LAYOUT

CHAR (100)

SSN

Docket Number
Unique ID

Appeal Level

Appeal Pending

Filed Date

User

APPENDIX A

OBS

Field Name

No.

Step 32 - Rule 1

Step 30B - Rule 1

Step 24A - Rule 1

Step 1E - Rule 2

Step 1E - Rule1

Module 3 Reference

A-34

User defined field. Can be used
for any additional data element.
Not mandatory.

The date on which the appeal
was filed.

No decision has been made on
an appeal.

The appeal was a lower
authority appeal.

The Docket Number or other
unique number assigned to the
appeal.

Social Security Number

State assigned sequential
unique identifier for each record
in the extract file.

Field Description

Text
(Optional)

Date - MM/DD/YYYY
(Required)

Text - No Decision
(Optional)

Text - Lower
(Required)

Number - 0000000000
(Required)

Number - 000000000
(Required)

Number - 00000000
(Required)

Data Format

NOT NULL

Constraint

RECORD LAYOUT

CHAR (100)

DATE

CHAR (30)

CHAR (20)

CHAR (30)

CHAR (9)

INTEGER

Data Type

Example: If the state-specific code for Lower Authority Appeal is 100, then the data format would be LOWER-100.

BENEFITS RECORD LAYOUT FOR POPULATION 10

Unemployment Insurance Data Validation Operations Guide

Docket Number
Unique ID

Appeal Level

Appeal Pending

Filed Date

User

APPENDIX A

SSN

Field Name

OBS

No.

Step 32 - Rule 1

Step 30B - Rule 1

Step 24B - Rule 1

Step 1F - Rule 2

Step 1F - Rule 1

Module 3 Reference

A-35

User defined field. Can be used
for any additional data element.
Not mandatory.

The date on which the appeal
was filed.

No decision has been made on
an appeal.

The appeal was a higher
authority appeal.

The Docket Number or other
unique number assigned to the
appeal.

Social Security Number

State assigned sequential
unique identifier for each record
in the extract file.

Field Description

Text
(Optional)

Date - MM/DD/YYYY
(Required)

Text - No Decision
(Optional)

Text - Higher
(Required)

Number - 0000000000
(Required)

Number - 000000000
(Required)

Number - 00000000
(Required)

Data Format

Data Type

Constraint

NOT NULL

RECORD LAYOUT

CHAR (100)

DATE

CHAR (30)

CHAR (20)

CHAR (30)

CHAR (9)

INTEGER

Example: If the state-specific code for Higher Authority Appeal is 200, then the data format would be Higher-200.

BENEFITS RECORD LAYOUT FOR POPULATION 11

Unemployment Insurance Data Validation Operations Guide

Unique ID

Program Type

Type of
Overpayment

APPENDIX A

SSN

Field Name

OBS

No.

Fraud: Step 33A - Rule 1
Nonfraud: Step 33B - Rule 1
Penalty: Step 33C - Rule 1

UI: Step 4A - Rule 1
UCFE: Step 4B - Rule 1
UCX: Step 4C - Rule 1
EB: Step 4F – Rule 1

Step 1G - Rule 2

Step 1G - Rule 1

Module 3 Reference

A-36

The type of overpayment is
Fraud, Nonfraud or Penalty.

Type of program is UI, UCFE,
or UCX or EB.

The unique ID of the
overpayment.

Social Security Number

State assigned sequential
unique identifier for each
record in the extract file.

Field Description

Text - Fraud
Nonfraud
Penalty
(Required)

Text – UI, UCFE, UCX, EB
(Required)

Number - 0000000000
(Required if State maintains a
unique ID)

Number - 000000000
(Required)

Number - 00000000
(Required)

Data Format

Example: If the state-specific code for Fraud is F, then the data format would be FRAUD-F.
Constraint

NOT NULL

RECORD LAYOUT

CHAR (20)

CHAR (30)

CHAR (9)

INTEGER

Data Type

BENEFITS RECORD LAYOUT FOR POPULATION 12

Unemployment Insurance Data Validation Operations Guide

UI Amount

Federal Amount

EB Amount

APPENDIX A

Date Established

Field Name

Cause of Overpayment

No.

Step 37C – Rule 1

Step 37B - Rule 1

Step 37A - Rule 1

Step 36 - Rule 1

Multi Claimant Scheme:
Step 34A - Rule 1
Single Claimant: Step 34H – Rule 1
Agency Employee Benefit Fraud:
Step 34I – Rule 1
Reversal (JAVA): Step 34B – Rule
1
State Agency: Step 34C – Rule 1
Employer: Step 34D – Rule 1
Claimant: Step 34E – Rule 1
Other: Step 34F – Rule 1 and 3
Penalty: Step 34G – Rule 1

Module 3 Reference

Unemployment Insurance Data Validation Operations Guide

Field Description

A-37

The amount of benefits paid through
the permanent Extended Benefits
(EB) program.

The amount of benefits paid from
Federal Funds.

The amount of benefits paid from
State Unemployment Funds.

The date that the overpayment was
established.

The cause of the overpayment was
a fraud committed by Multi Claimant
Scheme, Single Claimant, or Agency
Employee; or a nonfraud by
Reversals, State Agency Errors,
Employer Errors, Claimant Errors, or
Other cause.

Data Format

Data Type

CHAR (100)

DECIMAL
(9,2)

DATE

CHAR (30)

RECORD LAYOUT

Number – 000000000.00
(Required for EB claims;
must be blank or 0 for UI or
UCFE or UCX claims)

Number - 0000000.00
(Required for UCFE, UCX,
or joint claims; must be
blank or 0 for UI or EB
claims)

Number - 0000000.00
(Required for UI claims;
must be blank or 0 for UCFE
or UCX or EB claims)

Date - MM/DD/YYYY
(Required)

Text – Multiclaimant; Single
Claimant; Agency
Employee; Reversals; State
Agency; Employer;
Claimant; Other
(Required except optional
for penalties)

NOT NULL

Constraint

Accumulated
Federal Amount

Accumulated EB
Amount

Date of Original
Monetary

APPENDIX A

Field Name

Accumulated UI
Amount

No.

Step 6A – Rules 1 and 3
Step 6B – Rule 1

Step 45C

Step 45B

Step 45A

Module 3 Reference

A-38

Date the original determination was
made on whether the claimant has
sufficient base-period wages and/or
employment to establish a benefit year.

The EB fraud or nonfraud overpayment
amount that the EB claim has
accumulated from previous quarters and
that is used to calculate a High Dollar
Overpayment. If in previous quarter the
claim was classified as a High Dollar
Overpayment, then the accumulated
amount is reset to 0.

The Federal fraud or nonfraud
overpayment amount that the UCFE,
UCX or joint claim has accumulated from
previous quarters and that is used to
calculate a High Dollar Overpayment. If
in previous quarter the claim was
classified as a High Dollar Overpayment,
then the accumulated amount is reset to
0.

The UI fraud or nonfraud overpayment
amount that the UI claim has
accumulated from previous quarters and
that is used to calculate a High Dollar
Overpayment. If in the previous quarter
the claim was classified as a High Dollar
Overpayment, then the accumulated
amount is reset to 0.

Field Description

Unemployment Insurance Data Validation Operations Guide

Data Format

Date – MM/DD/YYYY
(Required)

Data Type

DATE

DECIMAL
(9,2)

DECIMAL
(9.2)

RECORD LAYOUT

Number - 000000000.00
(Required for EB claims; must be blank
or 0 for UI or UCFE or UCX claims)

Number – 0000000.00
(Required for UCFE, UCX, or joint
claims; must be blank or 0 for UI or EB
claims)

Number – 0000000.00
(Required for UI claims; must be blank
or 0 for UCFE or UCX or EB claims)

NOT NULL

Constraint

Field Name

User

APPENDIX A

No.

Module 3 Reference

A-39

User defined field. Can be used for
any additional data element. Not
mandatory.

Field Description

Unemployment Insurance Data Validation Operations Guide

Data Format
CHAR (100)
Text
(Optional)

Constraint

RECORD LAYOUT

Data Type

Unique ID

Program Type

Type of
Overpayments

APPENDIX A

SSN

Field Name

OBS

No.

Fraud: Step 33A - Rule 1
Nonfraud: Step 33B - Rule 1

UI: Step 4A - Rule 1
UCFE: Step 4B - Rule 1
UCX: Step 4C - Rule 1
EB: Step 4F – Rule 1

Step 1H - Rule 2

Step 1H - Rule 1

Module 3 Reference

A-40

The type of overpayment is Fraud or
Nonfraud.

The program type is UI, UCFE, UCX
or EB.

The unique ID of the overpayment.

Social Security Number

State assigned sequential unique
identifier for each record in the
extract file.

Field Description

Text - Fraud
Nonfraud
(Required)

Text - UI
UCFE
UCX
EB
(Required)

Number - 0000000000
(Required if State maintains a
unique ID)

Number - 000000000
(Required)

Number - 00000000
(Required)

Data Format

Example: If the state-specific code for Recovered Cash is C, then the data format would be CASH-C.
Constraint

NOT NULL

RECORD LAYOUT

CHAR (20)

CHAR (30)

CHAR (9)

INTEGER

Data Type

BENEFITS RECORD LAYOUT FOR POPULATION 13

Unemployment Insurance Data Validation Operations Guide

UI Reconciliation
Amount

Federal
Reconciliation
Amount

APPENDIX A

Date of
Reconciliation
Activity

Field Name

Type of
Reconciliation
Activity

No.

Step 40B - Rule 1

A-41

The reconciled amount of
Federal Funds.

The reconciled amount of
State Unemployment Funds.

Indicate the date of the
Overpayment Activity.

Step 39 - Rule 1

Step 40A - Rule 1

Field Description
The reconciliation activity was
cash, benefit offset, state
income tax offset, Federal
Income tax offset, other
states, write-off, waived
addition, or subtraction.

Module 3 Reference
Recovered Cash: Step 38A Rule 1
Recovered Offset: Step 38B Rule 1
State Income Tax Offset:
Step 38C - Rule 1
By Other State: Step 38D Rule 1
Write-Off: Step 38G - Rule 1
Waived: Step 38F - Rule 1
Additions: Step 38H - Rule 1
Subtractions: Step 38I - Rule
1
Other: Step 38E - Rule 1
Federal Income Tax Offset:
Step 38J – Rule 1

Unemployment Insurance Data Validation Operations Guide

Data Format

Number - 0000000.00
(Required for UCFE, UCX,
or joint claims; must be
blank or 0 for UI claims)

Number - 0000000.00
(Required for UI claims;
must be blank or 0 for UCFE
or UCX claims)

Date - MM/DD/YYYY
(Required)

Text - Cash
Benefit Offset
State Tax Offset
Federal Tax Offset
By Other State
Write-off
Waived
Addition
Subtraction
Other
(Required)

Data Type

Constraint

NOT NULL

RECORD LAYOUT

DECIMAL (9,2)

DATE

CHAR (30)

APPENDIX A

User

Field Name

EB Reconciliation
Amount

No
.
Step 40C – Rule 1

Module 3 Reference

A-42

User defined field. Can be used
for any additional data element.
Not mandatory.

The reconciled amount of
Extended benefits funds.

Field Description

Unemployment Insurance Data Validation Operations Guide

Data Format

Text
(Optional)

Number – 0000000.00
(Required for EB)

Data Type

Constraint

RECORD LAYOUT

CHAR (100)

DECIMAL
(9.2)

Unique ID

Date Established

Program Type

APPENDIX A

SSN

Field Name

OBS

No.

UI: Step 4A - Rule 1
UCFE: Step 4B - Rule 1
UCX: Step 4C - Rule 1
EB: Step 4F – Rule 1

Step 36 - Rule 1

Step 1G - Rule 2

Step 1G - Rule 1

Module 3 Reference

A-43

The program type is UI, UCFE,
UCX or EB.

The date the overpayment was
established

The unique ID of the
overpayment.

Social Security Number

State assigned sequential
unique identifier for each record
in the extract file.

Field Description

Text - UI
UCFE
UCX
EB
(Required)

Date - MM/DD/YYYY
(Required)

Number - 0000000000
(Required if State maintains a
unique ID)

Number - 000000000
(Required)

Number - 00000000
(Required)

Data Format

Example: If the state-specific code for Nonfraud is NF, then the data format would be NONFRUAD-NF.
Constraint

NOT NULL

RECORD LAYOUT

CHAR (30)

DATE

CHAR (30)

CHAR (9)

INTEGER

Data Type

BENEFITS RECORD LAYOUT FOR POPULATION 14

Unemployment Insurance Data Validation Operations Guide

UI Balance at End of
Qtr

Federal Balance at
the End of Qtr

APPENDIX A

Type of
Overpayments

Field Name

Active Collection

No.

Step 42B - Rule 1

Step 42A - Rule 1

Fraud: Step 33A - Rule 1
Nonfraud: Step 33B - Rule
1

Yes or blank: Step 44A Rule 1
No: Step 44B - Rule 1
Dropped: Step 44C - Rule
1

Module 3 Reference

A-44

The Federal funds
overpayment balance at the
end of the quarter.

The State Unemployment
funds overpayment balance at
the end of the quarter.

The type of overpayment is
Fraud or Nonfraud.

Indicate Y if overpayment is in
process of recovery; use N if
overpayment is no longer in
process of recovery; use D if
the established date is more
than nine (9) quarters prior to
the report quarter and the
overpayment was in process
of recovery in the quarter
before the report quarter but
recovery was dropped in the
report quarter.

Field Description

Unemployment Insurance Data Validation Operations Guide

Data Format

Number - 0000000.00
(Required for UCFE, UCX, and joint
claims; must be blank or 0 for UI
claims)

Number - 0000000.00
(Required for UI claims; must be
blank or 0 for UCFE and UCX
claims)

Text - Fraud
Nonfraud
(Required for overpayments with
balances more than 8 quarters past
due; optional for other overpayment
balances)

Text – Y; N; D
(Required for overpayments with
balances more than 450 days past
due; optional for other overpayment
balances)

Data Type

Constraint

RECORD LAYOUT

DECIMAL (9,2)

CHAR (20)

User

APPENDIX A

Field Name

EB Balance at the
End of Qtr

No.
Step 42C – Rule 1

Module 3 Reference

A-45

User defined field. Can be used
for any additional data element.
Not mandatory.

The EB funds overpayment
balance at the end of the
quarter.

Field Description

Unemployment Insurance Data Validation Operations Guide

Data Format

Text
(Optional)

Number – 000000000.00
(Required for EB; must be blank
or 0 for UI, UCFE, UCX and
joint claims)

Data Type

Constraint

RECORD LAYOUT

CHAR (100)

DECIMAL
(9.2)

Type of
Overpayments

APPENDIX A

Field Name

Unique ID

No.

SSN

Field Name

OBS

No.

Module 3 Reference

Fraud: Step 33A – Rule 1
Nonfraud: Step 33B – Rule 1

Step 1G - Rule 2

Step 1G - Rule 1

Module 3 Reference

A-46

Field Description

The type of overpayment is
Fraud or Nonfraud

The unique ID of the
overpayment.

Social Security Number

State assigned sequential
unique identifier for each record
in the extract file.

Field Description

Data Format

Text – Fraud; Nonfraud
Must be blank if investigation
establishes no overpayment
(Required)

Number - 0000000000
(Required if State maintains a
unique ID)

Number - 000000000
(Required)

Number - 00000000
(Required)

Data Format

Example: If the state-specific code for Nonfraud is NF, then the data format would be NONFRUAD-NF.
Constraint

Constraint

NOT NULL

RECORD LAYOUT

Data Type

CHAR (20)

CHAR (30)

CHAR (9)

INTEGER

Data Type

BENEFITS RECORD LAYOUT FOR POPULATION 15

Unemployment Insurance Data Validation Operations Guide

Date Established

Overpayment
Amount

Overpayment
Established by
Investigation

User

APPENDIX A

Detection Method

Step 46 – Rule 1

Step 37A – Rule 1
Step 37B – Rule 1

Step 36 – Rule 1

Wage/Benefit Crossmatch: Step
35A – Rule 1
IB Crossmatch: Step 35B – Rule
1
National Directory of New Hires:
Step 35H – Rule 1
State Directory of New Hires:
Step 35C – Rule 1
Multi-Claimant Scheme
Systems: Step 35D – Rule 1
Special Project: Step 35E –
Rule 1
Other Controllable: Step 35F –
Rule 1
Noncontrollable: Step 35G –
Rule 1

A-47

User defined field. Can be used
for any additional data element.
Not mandatory.

Whether a completed
investigation established an
overpayment.

The amount of benefits paid
from State and Federal
Unemployment Funds

The date the investigation was
concluded or overpayment was
established.

The Detection Method used to
establish the overpayment was
Wage/Benefit Crossmatch, IB
Crossmatch, National Directory
of New Hires (NDNH), State
Directory of New Hires (SDNH),
Multi-Claimant Scheme
Systems, Special Project, Other
Controllable, and
Noncontrollable activity.

Unemployment Insurance Data Validation Operations Guide

Text
(Optional)

Text – Y, N
(Optional for Other Controllable
and Noncontrollable)

Number – 000000000.00

Date – MM/DD/YYYY
(Required)

Text – Wage Crossmatch; IB
Crossmatch; NDNH; SDNH;
Multi-Claimant; Special; Other
Controllable; Noncontrollable
(Required)

Conditionally
Required

NOT NULL

RECORD LAYOUT

CHAR (100)

CHAR (20)

DECIMAL
(9.2)

DATE

CHAR (30)

Unemployment Insurance Data Validation Operations Guide

APPENDIX B

B-1

Unemployment Insurance Data Validation Operations Guide

EXPLANATION OF UI TAX DATA FORMATS
There are 6 types of data formats referred to in Appendix B.
1. Required. These fields cannot be blank. They may be mandatory codes,
dates or dollar values. Required cells in Appendix A tables indicate the
required code, date, or dollar value parameters, or display the word
“Required.”
Required text fields have code values that must be entered, such as A, C, R,
etc. All of the allowable generic values for each field are listed in the Data
Type/Format column on the record layout. The generic values must be
followed by a dash and the corresponding state-specific value.
2. Conditionally required. Data are included in these fields if the data are
present in the state’s system. Applies to date and wages fields.
3. Optional. These fields are gray in Appendix B and the word “Optional” is
displayed. The software does not look at these fields at all. Any values can
be entered or they can be left blank.
4. Must be blank. These are text or date fields where the presence of data
indicates an error. Therefore, they must be left blank (such as population 4
transaction date for balance subpopulations 4.7, 4.8, 4.15, and 4.16).
5. Must be blank or 0. These are numeric fields where the presence of data
other than 0 indicates an error. In tax these are primarily wages fields in
populations 4 and 5.
6. System generated. These fields are generated by the DV software and
data should not be placed in these fields in the extract files. These fields are
primarily time lapse and age fields.
Notes:
For most steps referenced in Appendix B column headers, Rule 1 is the indicator
in the state system. However, if a state does not maintain the indicator specified
in Rule 1, then the state programmer must review the other rules in that step in
order to develop the required validation logic.
The extract file type is ASCII, comma delimited. Data must be in the order listed
in the record layouts.

B-2

EAN

Employer Status Indicator

Employer Type

Liability Date (Met
Threshold)

APPENDIX B

OBS

Field Name

No.

Step 14

Step 2A
Step 2B

Step 3A

Step 1A

Module 3 Reference

B-3

Indicate the most recent
date on which the
employing unit met the
State law definition of a
newly established or
successor employer.

Indicate whether the
employer type is
contributory or
reimbursable.

Indicate that the employer
is an active employer.

Employer Account
Number

Assign to each record.
Use sequential numbers
starting at 1.

Field Description

Date - MM/DD/YYYY
(Required)

Text – C
R
(Required)

Text - A
(Required)

Number - 000000000
(Required)

Number - 00000000
(Required)

Data Format

Example: If the state-specific code for an Active Employer is 01, then the data format would be A-01.

DATE

CHAR (20)

INTEGER

Data Type

RECORD LAYOUT

NOT NULL

Constraint

The record layout provides the format for the validation extract file. The extract file type must be ASCII, comma delimited columns. Data
must be in the order listed in the record layout. The Data Format column indicates the generic values for text fields. These must be
followed by a dash and the state-specific value. The Module 3 reference indicates the step where the state-specific values are
documented.

TAX RECORD LAYOUT FOR POPULATION 1

Unemployment Insurance Data Validation Operations Guide

Inactive/Terminated "as of"
Date

Activation Processing Date

APPENDIX B

Reactivation Processing
Date

Field Name

No.

Step 15

Step 5

Step 16

Module 3 Reference

B-4

Indicate the date on
which an account was
established on the State’s
system for an 'employer,'
under the State
unemployment
compensation law.

Indicate the effective date
for the termination or
inactivation status of the
employer.

Indicate the date on
which an employer
account was updated on
the State's system to
reflect the reactivation of
a previously inactivated or
terminated employer.

Field Description

Unemployment Insurance Data Validation Operations Guide

Date - MM/DD/YYYY
(Required)

Date - MM/DD/YYYY

Data Format

DATE

Data Type

RECORD LAYOUT

NOT NULL

Constraint

Wages in Quarter 1

Wages in Quarter 2

APPENDIX B

Number of Liable Quarters

Field Name

No.

Step 7A

Step 7B

Module 3 Reference

B-5

Total wages for the
employer in the second
quarter prior to the report
quarter. Enter 0.00 for
either zero wage reports
or reports that weren't
filed.

Total wages for the
employer in the quarter
prior to the report quarter.
Enter 0.00 for either zero
wage reports or reports
that weren't filed.

Indicate the number of
consecutive quarters
between the date the
employer was activated
or reactivated on the
State’s system and the
quarter prior to the report
quarter being validated. If
the number of liable
quarters is eight or more,
the value should be
reported as eight. If the
employer was activated
or reactivated during the
report quarter, then the
number of liable quarters
is zero.

Field Description

Unemployment Insurance Data Validation Operations Guide

Number0000000000000.00
(Conditionally Required)

Number – 0
1
2
3
4
5
6
7
8
(Required)

Data Format

DECIMAL (15,2)

INTEGER

Data Type

RECORD LAYOUT

NOT NULL

Constraint

Wages in Quarter 3

Wages in Quarter 4

Wages in Quarter 5

Wages in Quarter 6

APPENDIX B

Field Name

No.

Step 7A

Module 3 Reference

B-6

Total wages for the
employer in the sixth
quarter prior to the report
quarter. Enter 0.00 for
either zero wage reports
or reports that weren't
filed.

Total wages for the
employer in the fifth
quarter prior to the report
quarter. Enter 0.00 for
either zero wage reports
or reports that weren't
filed.

Total wages for the
employer in the fourth
quarter prior to the report
quarter. Enter 0.00 for
either zero wage reports
or reports that weren't
filed.

Total wages for the
employer in the third
quarter prior to the report
quarter. Enter 0.00 for
either zero wage reports
or reports that weren't
filed.

Field Description

Unemployment Insurance Data Validation Operations Guide

Number 0000000000000.00
(Conditionally Required)

Data Format

DECIMAL (15,2)

Data Type

RECORD LAYOUT

Constraint

Wages in Quarter 7

Wages in Quarter 8

User Field

APPENDIX B

Field Name

No.

Step 7A

Module 3 Reference

B-7

User defined field. Can be
used for any additional
data element.

Total wages for the
employer in the eighth
quarter prior to the report
quarter. Enter 0.00 for
either zero wage reports
or reports that weren't
filed.

Total wages for the
employer in the seventh
quarter prior to the report
quarter. Enter 0.00 for
either zero wage reports
or reports that weren't
filed.

Field Description

Unemployment Insurance Data Validation Operations Guide

Text
(Optional)

Number 0000000000000.00
(Conditionally Required)

Data Format

CHAR (100)

DECIMAL (15,2)

Data Type

RECORD LAYOUT

Constraint

EAN

Employer Report Quarter
(ERQ)

Employer Type

Received Date

Final Assessment Date

APPENDIX B

OBS

Field Name

No.

Step 10

Step 9

Step 2A
Step 2B

Step 1B

Module 3 Reference

B-8

Indicate the date a final
assessment becomes legally
due and collectible.

Indicate the date of receipt
by the agency of the
contributions report from a
subject employer.

Indicate whether the
employer type is contributory
or reimbursable.

Indicate the calendar quarter
of business activity covered
by an employer’s
contributions report.

Employer Account Number

Sequential number, start at
1

Field Description

Date - MM/DD/YYYY
(Conditionally Required)

Text – C
R
(Required)

Number - YYYYQQ
(Required)

Number - 000000000
(Required)

Number - 00000000
(Required)

Data Format

Example: If the state-specific code for Contributory Employer Type is A, then the data format would be C-A.

DATE

CHAR (20)

CHAR (6)

CHAR (20)

INTEGER

Data Type

TAX RECORD LAYOUT FOR POPULATION 2

Unemployment Insurance Data Validation Operations Guide

RECORD LAYOUT

NOT NULL

Constraint

Liability Date
(Met Threshold)

Inactive/
Terminated "as of" Date

Suspended "as of" Quarter

Inactivation
/Termination
Processing Date

User Field

APPENDIX B

Liability Date (Initial or
Reopen)

Field Name

No.

Step 6A
Step 6B
Step 6C

Step 5

Step 14

Step 4A
Step 4B

Module 3 Reference

B-9

User defined field. Can be
used for any additional data
element.

Indicate the processing date
for the inactivation or
termination status of the
employer.

Indicate the specific ERQ for
which the State has
suspended the employer’s
report filing requirement.

Indicate the effective date
for termination or
inactivation status of the
employer.

Indicate the most recent
date on which the employing
unit met the State law
definition of a newly
established or successor
employer.

Indicate the date on which
an employing unit meets the
State’s legal definition of an
employer and is registered
and required to file reports.

Field Description

Unemployment Insurance Data Validation Operations Guide

Text
(Optional)

Date - MM/DD/YYYY
(Conditionally Required)

Number - YYYYQQ

Date - MM/DD/YYYY
(Conditionally Required)

Data Format

CHAR (100)

DATE

CHAR (6)

DATE

Data Type

RECORD LAYOUT

Constraint

EAN

Employer Type

Status Determination Type
Indicator

Time Lapse

APPENDIX B

OBS

Field Name

No.

Step 12

Step 11A
Step 11B
Step 11C
Step 11D

Step 2A
Step 2B

Step 1C

Module 3 Reference

B-10

Place a zero (0) in this field.
(Software generates the
time lapse)

Indicate status determination
type by New, Successor,
Inactivation or Termination.

Indicate whether the
employer type is contributory
or reimbursable.

Employer Account Number

Sequential number, start at
1

Field Description

Text – N
S
I
T
(Required)
Number – 0

Text – C
R
(Required)

Number - 000000000
(Required)

Number - 00000000
(Required)

Data Format

Example: If the state-specific code for New Status Determination is NEW, then the data format would be N-NEW.

INTEGER

CHAR (10)

CHAR (20)

INTEGER

Data Type

TAX RECORD LAYOUT FOR POPULATION 3

Unemployment Insurance Data Validation Operations Guide

RECORD LAYOUT

NOT NULL

Constraint

Liability Date
(Met Threshold)

End of Liable Quarter

Activation Processing Date

APPENDIX B

Status Determination Date

Field Name

No.

Step 15

Step 14

Step 13

Module 3 Reference

B-11

Indicate the date on which
an account was established
on the State’s system for an
'employer,' under the State
unemployment
compensation law.

Indicate the last day of the
quarter in which the
employing unit met the State
law definition of a newly
established or successor
employer. States that do not
have this should leave the
field blank; the value will
then be calculated by the
software.

Indicate the most recent
date on which the employing
unit met the State law
definition of a newly
established or successor
employer.

Indicate the date of any
recorded administrative
action that establishes,
modifies, changes,
inactivates, or terminates an
employing unit’s liability as
an employer.

Field Description

Unemployment Insurance Data Validation Operations Guide

Date - MM/DD/YYYY

Date - MM/DD/YYYY
(Conditionally Required)

Date - MM/DD/YYYY
(Required)

Data Format

DATE

Data Type

RECORD LAYOUT

NOT NULL

Constraint

Reactivation Processing
Date

Successorship Processing
Date

Predecessor Account
Number

Inactivation Processing Date

Termination Processing
Date

APPENDIX B

Field Name

No.

Step 6A or
Step 6C

Step 6A or
Step 6B

Step 18

Step 17

Step 16

Module 3 Reference

B-12

Indicate the processing date
for the termination status of
the employer.

Indicate the processing date
for the inactivation status of
the employer.

Indicate the account number
for an employing unit that
has been acquired by
another employer.

Indicate the date on which
an employer account was
established or updated to
reflect an acquisition by the
employer which met the
State law definition of
successorship.

Indicate the date on which
an employer account was
updated on the State’s
system to reflect the
reactivation of a previously
inactivated or terminated
employer.

Field Description

Unemployment Insurance Data Validation Operations Guide

Date - MM/DD/YYYY

Number - 000000000

Date - MM/DD/YYYY

Data Format

DATE

CHAR (20)

DATE

Data Type

RECORD LAYOUT

Constraint

User Field

APPENDIX B

Field Name

No.

Module 3 Reference

B-13

User defined field. Can be
used for any additional data
element.

Field Description

Unemployment Insurance Data Validation Operations Guide

Text
(Optional)

Data Format
CHAR (100)

Data Type

RECORD LAYOUT

Constraint

EAN

Employer Type

Transaction Date

Established Q/Date

Employer Report Quarter
(ERQ)

Due Date

APPENDIX B

OBS

Field Name

No.

Step 20

Step 1D

Step 19B

Step 19A

Step 2A
Step 2B

Step 1D

Module 3 Reference

B-14

Indicate the date after which
the State imposes interest
and penalty for late
payment.

Indicate the calendar quarter
of business activity covered
by an employer’s
contributions report.

Indicate the date that a past
due contribution was
entered into the system.

Indicate the date that a
transaction was entered into
the system.

Indicate whether the
employer type is
contributory or reimbursable.

Employer Account Number

Sequential number, start at
1

Field Description

Date - MM/DD/YYYY

Number - YYYYQQ

Date - MM/DD/YYYY
(Required)

Date - MM/DD/YYYY

Text – C
R
(Required)

Number - 000000000
(Required)

Number - 00000000
(Required)

Data Format

Example: If the state-specific code for Receivables Established is R, then the data format would be E-R.

DATE

CHAR (6)

DATE

CHAR (20)

INTEGER

Data Type

TAX RECORD LAYOUT FOR POPULATION 4

Unemployment Insurance Data Validation Operations Guide

RECORD LAYOUT

NOT NULL

Constraint

Amount Established in RQ

Amount Liquidated

Amount Uncollectible

Amount Removed

APPENDIX B

Transaction Type/Indicator

Field Name

No.

Step 25

Step 24

Step 23

Step 22

Step 21A
Step 21B
Step 21C

Module 3 Reference

B-15

Indicate the amount of
receivables removed during
the report quarter.

Indicate the amount of
receivables declared
uncollectible during the
report quarter.

Indicate the amount of
receivables liquidated during
the report quarter.

Indicate the amount of
contributions or payments
determined to be past due
during the report quarter.

Indicate the transaction type
code for receivables
established, liquidated,
declared uncollectible or
removed. Use a code of B
for records of account
balances at the end of the
RQ.

Field Description

Unemployment Insurance Data Validation Operations Guide

Number 0000000000000.00

Text – E
L
U
R
B
(Required)

Data Format

DECIMAL (15,2)

CHAR (20)

Data Type

RECORD LAYOUT

NOT NULL

Constraint

Balance at End of RQ

Age of Receivable

User Field

APPENDIX B

Field Name

No.

Step 27A
Step 27B

Step 26

Module 3 Reference

B-16

User defined field. Can be
used for any additional data
element.

Indicate the age of
receivable in days for
receivable balances at the
end of the report quarter.

Indicate the total amount of
past due contributions as of
the last day of the report
quarter being validated. For
aging, States should capture
a separate record for each
employer report quarter that
has a balance, rather than
an aggregate balance.

Field Description

Unemployment Insurance Data Validation Operations Guide

Text
(Optional)

Number – 0000000000000
(Optional)

Number 0000000000000.00

Data Format

CHAR (100)

INTEGER

DECIMAL (15,2)

Data Type

RECORD LAYOUT

Constraint

EAN

Audit ID #

Employer Size

Change Audit

Audit Completion Date

APPENDIX B

OBS

Field Name

No.

Step 30

Step 29A
Step 29B

Step 28A
Step 28B

Step 1E

Module 3 Reference

B-17

Indicate the date the audit
was completed and
recorded or posted as such.

Indicate whether an audit
resulted in a discovery of
wages, contributions or
employees not previously
reported.

Indicate whether the
employer size is large or
small.

Indicate the audit
identification number.

Employer Account Number

Sequential number, start at
1

Field Description

Date - MM/DD/YYYY
(Required)

Text – Y
N
(If field is blank, software will
determine if record has
value not equal to 0 in any
one of record layout fields 9,
10, 14, 15, 19, 20. Software
will then place a Y-DVWS in
field.)

Text – L
S
(Required)

Number - 00000000
(Required)

Number - 000000000
(Required)

Number - 00000000
(Required)

Data Format

Example: If the state-specific code for a Large Employer is Y, then the data format would be L-Y.

DATE

CHAR (20)

INTEGER

NOT NULL

Constraint

RECORD LAYOUT

Data Type

TAX RECORD LAYOUT FOR POPULATION 5

Unemployment Insurance Data Validation Operations Guide

Total Wages Post-Audit

Total Wages UnderReported

Total Wages Over-Reported

Total Wages Reconciliation
Amount

Taxable Wages
Pre-Audit

Taxable Wages
Post-Audit

Taxable Wages
Under-Reported

APPENDIX B

Total Wages Pre-Audit

Field Name

No.

Step 32C

Step 32B

Step 32A

Step 31E

Step 31D

Step 31C

Step 31B

Step 31A

Module 3 Reference

B-18

Indicate the full amount of
under reported taxable
wages discovered as a
result of the audit.

Indicate the full amount of
post-audit taxable wages for
quarters audited.

Indicate the full amount of
pre-audit taxable wages
reported for quarters
audited.

Place a zero (0) in this field.
(Software generates
amount)

Indicate the full amount of
over reported total wages
discovered as a result of the
audit.

Indicate the full amount of
under reported total wages
discovered as a result of the
audit.

Indicate the full amount of
total wages recorded in
audit summaries for audited
quarters.

Indicate the full amount of
pre-audit total wages
reported for quarters
audited.

Field Description

Unemployment Insurance Data Validation Operations Guide

Number 0000000000000.00

Number 0000000000000.00
(Optional)

Number – 0

Number 0000000000000.00

Number 0000000000000.00
(Required)

Data Format

NOT NULL

Constraint

RECORD LAYOUT

DECIMAL (15,2)

Data Type

Taxable Wages
Over-Reported

Taxable Wages
Reconciliation Amount

Contributions
Pre-Audit

Contributions
Post-Audit

Contributions
Under-Reported

Contributions
Over-Reported

Contributions Reconciliation
Amount

User Field

APPENDIX B

Field Name

No.

Step 33E

Step 33D

Step 33C

Step 33B

Step 33A

Step 32E

Step 32D

Module 3 Reference

B-19

User defined field. Can be
used for any additional data
element.

Place a zero (0) in this field.
(Software generates
amount)

Indicate the full amount of
over reported contributions
discovered as a result of the
audit.

Indicate the full amount of
under reported contributions
discovered as a result of the
audit.

Indicate the full amount of
post-audit contributions
reported for quarters
audited.

Indicate the full amount of
pre-audit contributions
reported for quarters
audited.

Place a zero (0) in this field.
(Software generates
amount)

Indicate the full amount of
over reported taxable wages
discovered as a result of the
audit.

Field Description

Unemployment Insurance Data Validation Operations Guide

Text
(Optional)

Number – 0

Number 0000000000000.00

Number 0000000000000.00
(Optional)

Number – 0

Number 0000000000000.00

Data Format

Constraint

RECORD LAYOUT

CHAR (100)

DECIMAL (15,2)

Data Type

File Type	application/pdf
File Title	UIPL_1_11_Chg2_Att.pdf
Author	Beistel.Rachel
File Modified	2015-10-27
File Created	2015-10-27