Quarterly Employment Wages for DOL AU446110DOEFILE

Purpose: Creates a file showing all employee wages each quarter for use by the Department of Labor.
 
FREQUENCY:
Quarterly
CREATED IN:
AU446110
USERS:
Labor
 
 
File Layout:
 
Duplicate SSNs are not reported.
Will not display employees with zero wages.
 
FIELD NAME
FIELD LENGTH
DESCRIPTION
 
 
 
EAN
10
Employer number
SSN
9
Employee SSN
EMPLOYER_NAME
as needed
State agency name
EMPLOYEE _FIRST_NAME
as needed
 
EMPLOYEE_MIDDLE_INITIAL
1
 
EMPLOYEE_LAST_NAME
as needed
 
QUARTER
1
Current quarter
YEAR
4
Current year
QUARTERLY WAGES
7.2
Current wages
 
 
Example of file: