Revised interstate liable-agent data transfer record format
Apply this to your situation
This page explains the general guidance. Ask about your specific situation and see what current federal labor law says, with citations.
U.S. Department of Labor
Employment and Training Administration
Washington, D.C. 20210
Classification: UI
Correspondence symbol: OWS/OIS/DUIO
Issue date: October 23, 2000
Rescissions: None
Expiration date: October 31, 2001
Directive: UNEMPLOYMENT INSURANCE PROGRAM LETTER NO. 38-96, Change 2
To: ALL STATE EMPLOYMENT SECURITY AGENCIES
From: GRACE A. KILBANE, Administrator, Office of Workforce Security
Subject: Revised Interstate Statistical Data Exchange/Liable -Agent Data Transfer (LADT) Record Format
Purpose. To advise State Employment Security Agencies (SESAs) 1) of the revised LADT record format that accommodates the transfer of data coded in accordance with the revised Ethnic and Race Reporting Requirements; and 2) that LADT data reporting includes the use of the North American Industry Classification System (NAICS) and Standard Occupational Classification (SOC) codes.
References. UIPL No. 24-00, dated May 15, 2000; ET Handbook No. 401, Change 20, dated March 29, 2000; ET Handbook No. 395; ET Handbook No. 392; and the ICON LADT User Guide.
Background. When the LADT record format was developed, the planned implementation of changing to the NAICS and SOC coding of unemployment insurance (UI) data was accounted for in the design. However, the recent change in the ethnic and race data reporting, which requires the collection of data in separate race and ethnic categories, was not included in the design. Therefore, the LADT record has been revised to accommodate the reporting of interstate data as required by ET Handbook No. 401, Change 20, for the ETA 203, Characteristics of the Insured Unemployed.
NAICS. NAICS is a new economic classification system that classifies work establishments by type of economic activity. NAICS replaces the1987 Standard Industrial Classification (SIC) for statistical purposes and is organized in a hierarchical structure. NAICS employs a 6-digit coding system in which the first two digits designate the sector (the NAICS term "sector" replaces the term "division" used in the 1987 SIC), the third digit designates the subsector, the fourth digit designates the industry group, the fifth digit represents the NAICS industry, and the sixth digit designates individual country-level national industries.
Information on the industry group of the UI benefit recipient's last employer and primary base period employer has been collected using the SIC classifications. Given the current structure of the Benefit Accuracy Measurement (BAM) database, which allocates four cells for the current SIC code, NAICS is being implemented at the Industry Group level for ETA 203 and BAM reporting purposes. Therefore, for LADT reporting, States should enter, at a minimum, the first four (4) digits of the NAICS code in Field 41 of the LADT record, left justified, followed by "00".
SOC / ONET. The SOC (1998 version) serves as the framework for information collected through the Department of Labor Employment and Training Administration's (ETA) ONET, which replaces the Dictionary of Occupational Titles (DOT) codes, effective January 1, 2001, for UI reporting purposes. Federal Government agencies that collect occupational information developed SOC to replace several different classification systems supported by these agencies. The SOC is organized in a hierarchical structure. The SOC employs a 6-digit coding system in which the first two digits represent the major group; the third digit represents the minor group; the fourth and fifth digits represent the broad occupation; and the sixth digit represents the detailed occupation.
The BAM database uses the first three digits of the DOT code(s) to code information on the occupation of the claimant's last job, usual job, and the type of work the claimant is seeking. To accommodate the current structure of the BAM database, which allocates three positions for the occupational code, the 1998 SOC is being implemented at the minor group level for LADT reporting. Therefore, States should enter, at a minimum, the first three (3) digits of the SOC code in Field 29 of the LADT record, left justified, followed by a "0".
Race and Ethnicity. The Office of Management and Budget's, Standards for Maintaining, Collecting, and Presenting Federal Data on Race and Ethnicity allows for a two question format to provide more flexibility in data collection and to ensure data quality. ET Handbook No. 401, Change 20, dated March 29, 2000, issued the reporting instructions for the ES 203 for which this LADT data are necessary.
To accommodate reporting on race and ethnic group separately in the LADT record format, the name of Field 16 has been changed from Ethnic to Race and an additional field (Field 60) has been added to the record for ethnic classification. An explanation of the information to be reported in the separate categories which was taken from the Office of Management and Budget's notice of revisions to its Statistical Policy Directive No. 15, "Race and Ethnic Standards for Federal Statistics and Administrative Reporting," follows below. The code numbers have been added to provide for LADT reporting of the information.
Ethnicity. There are two categories for data on ethnicity: "Hispanic or Latino" and "Not Hispanic or Latino". The single term "Hispanic" designation has been changed to "Hispanic or Latino" because it was determined that, whereas the term "Hispanic" is commonly used in the eastern United States, the term "Latino" is used in the western United States.
The Hispanic/Latino category refers to individuals who trace their origin or descent to Cuba, Mexico, Puerto Rico, Central America, and other Spanish cultures. This information is to be reported under "Ethnic" on LADT in Field 60 as follows:
Code 1 = Hispanic or Latino
Code 2 = Not Hispanic or Latino.
Code 3 = Information not available.
Race. The minimum categories for data on race are defined and will be coded in Field 16 of the LADT record as follows:
Code 1 = White. A person having origins in any of the original peoples of Europe, the Middle East, or North Africa.
Code 2 = Black or African American. A person having origins in any of the black racial groups of Africa.
Code 3 = Asian. A person having origins in any of the original peoples of the Far East, Southeast Asia, or the Indian subcontinent including, for example, Cambodia, China, India, Japan, Korea, Malaysia, Pakistan, the Philippine Islands, Thailand, and Vietnam.
Code 4 = American Indian or Alaska Native. A person having origins in any of the original peoples of North and South America, (including Central America), and who maintains tribal affiliation or community attachment.
Code 5 = Native Hawaiian or Other Pacific Islander. A person having origins in any of the original peoples of Hawaii, Guam, Samoa, or other Pacific Islands.
Code 6 = Information not available.
Summary of LADT Coding Changes.
a. Field 16 - Race. States should data enter race classification in Field 16 of the LADT record as defined in (6. b) above.
b. Field 29 - SOC. States should data enter, at a minimum, the first three (3) digits of the SOC code in Field 29 of the LADT record, left justified, followed by a "0".
c. Field 41 - NAICS. States should data enter, at a minimum, the first four (4) digits of the NAICS code in Field 41 of the LADT record, left justified, followed by "00".
d. Field 60 - Ethnic. States should data enter ethnic classification in Field 60 of the LADT record as defined in (6. a) above.
Distribution of ICON LADT User Guide/System Modification Requirements. An ICON LADT User Guide has been developed in cooperation with the National Association of State Workforce Agencies' (formerly the Interstate Conference of Employment Security Agencies) Interstate Benefit Committee to provide a better understanding of data exchange and the agent and liable State reports produced by the system. The Lockheed Martin ICON support group will distribute the User Guide, which includes the record format and data reporting modification requirements to each State's ICON Programmer and Interstate Program Coordinator and the Employment and Training Administration's Regional Office Interstate Coordinator, on 10/04/00. Any technical questions related to the data exchange, including the modified data records, should be addressed to Carlys Hill at (407) 306-4376 or Martha Hazelrigg at (407) 306-7228. Any policy questions related to the data to be exchanged should be directed to Mary Montgomery at (202) 219-5340 extension 178.
Effective Date. The new NAICS and SOC codes are required to be used on all BAM cases signed off by the BAM investigator and supervisor or reopened on or after January 1, 2001. Information based on the new codes are required to be reported on the ES 203 effective with the report for the month of January 2001. Therefore, LADT data should include these codes as soon as possible, but no later than for data reported for the week ending January 6, 2001.
Action Required. State Administrators are requested to provide copies of these instructions to the appropriate staff.
Inquiries. Questions should be directed to the appropriate ETA Regional Office.
Attachment - LADT Record Format
Attachment: LADT Record Format
Official attachment: https://oui.doleta.gov/dmstree/uipl/uipl96/uipl_3896c2a.pdf
Attachment to UIPL 38-96, Change 2
LIABLE/AGENT DATA TRANSFER RECORD
Required Fields By Record Type
Y = Required Field
Number = Rule Number Listed at End of Layout
FLD FIELD NAME FIELD BEGIN FIELD TIC REOP/ W/C - W/C - DESCRIPTION
NBR TYPE COLUM LENGTH TRAN IB COMM
N
1 Social Security Number N 1 9 Y Y Y Y Enter Claimant’s Social Security Number
2 Claimant’s Name - First A/N 10 12 Y Y Enter at least one alphabetic character. This is
the claimant’s first name. First position cannot
be blank.
3 Claimant’s Name - Middle A/N 22 1 Y Y Claimant’s middle initial.
Initial
4 Claimant’s Name - Last A/N 23 23 Y Y Enter at least one alphabetic character. This is
the claimant’s last name. First position cannot
be blank.
5 Mailing Address - Street A/N 46 30 Y Y 2 2 Enter Claimant’s (Mailing) Street
6 Mailing Address - City A/N 76 19 Y Y 2 2 Enter Claimant’s (Mailing) City
7 Mailing Address - State A/N 95 2 Y Y 2 2 Enter Claimant’s (Mailing) State
8 Mailing Address - Zip Code A/N 97 9 Y Y 2 2 Enter Claimant’s (Mailing) Zip Code
9 Residence Addr - Street A/N 106 30 6 6 6 6 Enter Claimant’s (Residence) Street
10 Residence Addr - City A/N 136 19 6 6 6 6 Enter Claimant’s (Residence) City
11 Residence Addr - State A/N 155 2 6 6 6 6 Enter Claimant’s (Residence) State
12 Residence Addr - Zip Code A/N 157 9 6 6 6 6 Enter Claimant’s (Residence) Zip Code
13 Claimant’s Telephone Number N 166 10 Y Y Enter Area Code, Exchange, and Extension of
the Claimant’s Telephone Number
14 Year of Birth N 176 4 Y Y Y Y Claimant’s Year of Birth - Format is “CCYY”
- “CC” (century) is not used at this time but is
included for the future.
15 Sex N 180 1 Y Y Y Y Enter the sex of the claimant
1 = Male
2 = Female
3 = Unknown
- 1 -
Attachment to UIPL 38-96, Change 2
LIABLE/AGENT DATA TRANSFER RECORD
Required Fields By Record Type
Y = Required Field
Number = Rule Number Listed at End of Layout
FLD FIELD NAME FIELD BEGIN FIELD TIC REOP/ W/C W/C - DESCRIPTION
-
NBR TYPE COLUMN LENGTH TRAN IB COMM
16 RACE N 181 1 Y Y Claimant’s Race Code
1 = White
2 = Black
3 = Asian
4 = American Indian/Alaskan Native
5 = Native Hawaiian/Other Pacific Islander
6 = Information Not Available
17 Education N 182 2 Highest Grade Completed
01 - 12 Actual grade completed (GED = 12)
13 = 1 year of college or technical school
14 = 2 years of college or Associate
degree/technical school
15 = 3 years of college
16 = 4 years of college or undergraduate
degree
17 = 1 year of post graduate study
18 = 2 years of post graduate study or
Masters degree
19 = Doctorate
18 Liable State FIPS A/N 184 2 Y Y Y Y Liable state FIPS code or US postal
alphabetic abbreviation. The liable state
cannot be the same as the agent state.
19 Liable State Office/Call N 186 4 Y Y Enter number that identifies the Liable
Center Number Interstate office/Liable Call Center that
handles the claim.
20 Agent State FIPS A/N 190 2 5 5 Y 5 Agent state FIPS code or US postal
alphabetic abbreviation. The agent state
cannot be the same as the liable state.
21 Agent State Local N 192 4 Y Y Y Y Local office/Call Center where the claimant
Office/Call Center Number filed the claim.
- 2 -
Attachment to UIPL 38-96, Change 2
LIABLE/AGENT DATA TRANSFER RECORD
Required Fields By Record Type
Y = Required Field
Number = Rule Number Listed at End of Layout
FLD FIELD NAME FIELD BEGIN FIELD TIC REOP W/C W/C - DESCRIPTION
/ -
NBR TYPE COLUMN LENGTH TRAN IB COMM
22 Residence State FIPS N 196 2 5 5 1 5 Residence State FIPS code. The residence
state cannot be the same as the liable state.
23 Residence County FIPS N 198 3 Y Y 2 2 Residence County FIPS code.
24 Residence City/Town FIPS N 201 4 Y Y Y Y Residence City/Town FIPS Code.
25 Date Claim Taken N 205 8 Y Y Enter the date the claim was taken. Format
is “CCYYMMDD”. “CC” (century) is not
used at this time but is included for the
future.
26 Effective Date of Claim N 213 8 Y Y Enter effective date of the claim. Correlates
with today’s date, backdate reason, and
liable state. Format is “CCYYMMDD”.
“CC” (century) is not used at this time but is
included for the future.
27 Program Type N 221 1 Y Y Y Y Enter the program type:
1 = UI
5 = UCFE
7 = UCX
28 Entitlement N 222 1 Y Y Y Y Enter the entitlement type:
0 = Regular
1 = Extended Benefits (EB)
2 = Federal Benefit Extension
3 = Additional Benefits (AB)
29 SOC Code N 223 4 3 3 3 3 Enter at least the first 3 digits of the
Claimant’s Standard Occupational
Classification (SOC) Code (left justified)
followed by a zero or enter the first 4
digits of the SOC.
- 3 -
Attachment to UIPL 38-96, Change 2
LIABLE/AGENT DATA TRANSFER RECORD
Required Fields By Record Type
Y = Required Field
Number = Rule Number Listed at End of Layout
FLD FIELD NAME FIELD BEGIN FIELD TIC REOP W/C COMM DESCRIPTION
/ -
NBR TYPE COLUMN LENGTH TRAN IB
30 Initial Claim N 227 1 Y Enter Status of Claim:
1 = New
2 = Additional
3 = Transitional
31 BYB N 228 8 Benefit year beginning date. Format is
“CCYYMMDD”. “CC” (century) is not
used at this time but is included for the
future.
32 BYE N 236 8 Benefit year ending date. Format is
“CCYYMMDD”. “CC” (century) is not
used at this time but is included for the
future.
33 WBA N 244 3 Weekly Benefit Amount (include
Dependents Allowance)
34 MBA N 247 5 Maximum Benefit Amount (include
Dependents Allowance)
35 Base Period Wages - 1st Qtr N 252 7 Enter BP wages for the 1st Qtr
36 Base Period Wages - 2nd Qtr N 259 7 Enter BP wages for the 2nd Qtr
37 Base Period Wages - 3rd Qtr N 266 7 Enter BP wages for the 3rd Qtr
38 Base Period Wages - 4th Qtr N 273 7 Enter BP wages for the 4th Qtr
39 Base Period Wages - 5th Qtr N 280 7 Enter BP wages for the 5th Qtr
- 4 -
Attachment to UIPL 38-96, Change 2
LIABLE/AGENT DATA TRANSFER RECORD
Required Fields By Record Type
Y = Required Field
Number = Rule Number Listed at End of Layout
FLD FIELD NAME FIELD BEGIN FIELD TIC REOP W/C W/C - DESCRIPTION
/ -
NBR TYPE COLUMN LENGTH TRAN IB COMM
40 Base Period Wages - Total N 287 8 Enter total BP wages for all quarters
41 NAICS (Employer with N 295 6 Enter at least the first four digits of the
Most Wages) North American Industry Classification
System (NAICS) code, followed by “00",
of the claimant’s employer for which
he/she had the most wages or enter the 6
digit code.
42 Last Employer - Name A/N 301 30 Enter name of last employer
43 Date Employment Began N 331 8 Enter date employment began with last
employer. Format is “CCYYMMDD”.
“CC” (century) is not used at this time but is
included for the future.
44 Date Employment Ended N 339 8 Enter date employment ended with last
employer. Format is “CCYYMMDD”.
“CC” (century) is not used at this time but is
included for the future.
45 Last Employer - NAICS N 347 6 4 4 4 4 Enter at least the first four digits of the
North American Industry Classification
System (NAICS) code, followed by “00", of
the claimant’s employer for which he/she
had the most wages or enter the 6 digit code.
46 Last Employer - Ownership N 353 1 Y Y Y Y Valid entries are ‘1’ through ‘5’, default is
Code ‘5’.
1 = Federal government
2 = State government
3 = Local government
4 = International or Foreign
5 = Private
47 Separation N 354 1 Separation:
1 = Permanent
2 = Temporary
FLD FIELD NAME FIELD BEGIN FIELD TIC REOP/ W/C W/C - DESCRIPTION
-
- 5 -
Attachment to UIPL 38-96, Change 2
LIABLE/AGENT DATA TRANSFER RECORD
Required Fields By Record Type
Y = Required Field
Number = Rule Number Listed at End of Layout
NBR TYPE COLUMN LENGTH TRAN IB COMM
48 Recall Date N 355 8 Enter date claimant is to return to work. If
no recall date, enter all zeros, format is
“CCYYMMDD”. “CC” (century) is not
used at this time but is included for the
future.
49 Union A/N 363 1 Y = Yes
N = No
50 US Citizenship A/N 364 1 Y = Yes
N = No
51 Alien Registration Number A/N 365 20 Enter claimant’s alien registration number, if
applicable and available
52 Week Ending Date N 385 8 Y Y Week ending date of week claimed, format
is “CCYYMMDD”. “CC” (century) is not
used at this time but is included for the
future.
53 Earnings During Week A/N 393 1 Y Y Y Y X = Yes. Indicated that claimant had
Claimed earnings during the week claimed.
54 Date First Payment Issued N 394 8 Enter the date the first payment was issued.
Format is “CCYYMMDD”. “CC” (century)
is not used at this time but is included for the
future.
55 Exhaustee A/N 402 1 X = Yes.
Complete only upon exhaustion
56 Weeks Compensated N 403 2 Enter the number of weeks compensated
during the benefit year.
57 $ Amount of Benefits Paid N 405 7 Enter the total amount of benefits paid
during the benefit year.
58 Commuter Identification A/N 412 1 Y X = Yes. Complete to identify claims filed
Code by commuters from residence state.
- 6 -
Attachment to UIPL 38-96, Change 2
LIABLE/AGENT DATA TRANSFER RECORD
Required Fields By Record Type
Y = Required Field
Number = Rule Number Listed at End of Layout
FLD FIELD NAME FIELD BEGIN FIELD TIC REOP/ W/C W/C - DESCRIPTION
-
NBR TYPE COLUMN LENGTH TRAN IB COMM
59 Reopen Claim/Transfer of N 413 1 Y 1 = Reopen claim. Complete when there is a
Claim break in claim series not caused by
employment.
2 = Transfer of claim. Complete when there
is a change in the Residence Agent State
with no break in claim series.
60 Ethnic N 414 1 Y Y 1 = Hispanic
2 = Non-Hispanic
3 =Information Not Available
61 Filler A/N 415 57 (for future use)
62 Record Type A/N 472 1 Y Y Y Y Required Entry to indicate Type-of Record
1 = TIC (Telephone Initial Claim)
2 = Weeks Claimed
3 = Reopen/Transfer
63 Process Date N 473 8 Y Y Y Y Format is “CCYYMMDD”. “CC”(century)
is not used at this time but is included for the
future.
Rule Number
Definition of Rule
1 On a Weeks Claimed (IB) – the Residence State FIPS can be the same as the Liable State FIPS as long as the Agent State FIPS is different.
2 Either Mailing Address or Field 23 (Residence County FIPS) should be provided. For New England states, either Mailing Address or
Field 24 (Residence City/Town FIPS) should be provided.
3 SOC should be provided if possible. If not provided, a warning message will be returned. THE RECORD WILL BE PROCESSED.
4 Last Employer – NAICS should be provided if possible. If not provided, a warning message will be returned. THE RECORD WILL BE
PROCESSED.
5 On a Weeks Claimed – Commuter, the value in the Residence State FIPS (field 20) will determine the receiving state.
6 Residence Address will be completed when the Liable State can provide a Residence Address that is different from the Mailing Address.
For TIC and Reopen/Transfer of Claims records, these fields should be filled in if the state has elected to provide the County FIPS Code
(Field 23) or City/Town FIPS Code (Field 24) on the Weeks Claimed data record.
- 7 -
What does federal law require in your situation?
Ezel checks current federal labor law against your facts and answers with citations.
Opens in Ezel Pro.
- Checks the law as it stands today, not only this page
- Cites every source it relies on, so you can verify it
- Chat, drafting and research in one workspace