Earnings Limitation Report - File Layouts and Data Mapping

The following table lists the data items, field name, description, length, position, and from where the data is retrieved.

Data Item	Field Name		Description	Length	Position	Location
Social Security Number	Social Security		The employee’s Social Security Number. Do not use embedded spaces or special characters. This field is required.	9	1-9	employee.ssn
Location	Employee Location Code or Teacher Location Code	The eight-character code composed of two four-character parts. The first four characters are the Employee Location Code or Teacher Location Code on the Human Resources Profile - State page. The following four characters are set to 0000. This field is required.		8	10-17	hrmstate.state18 + “0000” or, if they have an active retirement deduction code with a system code of 2 or 7, then hrmstate.state8 + “0000”
Last Name	Last Name	The employee’s last name. Left-justified and blank-filled.		17	18-34	employee.l_name
First Name	First Name	The employee’s first name. Left-justified and blank-filled.		12	35-46	employee.f_name
Middle Initial	Middle Name	The employee’s middle initial.		1	47	employee.m_name
Wage Paid	NA	The total wages paid. Assumed decimal, right-justified, zero-filled. This field is required.		9	48-56	Sum of checkhi2.amt for earnings records, where the checkhi2.code = paytable.pay_code and paytable.time_type <> ‘A’
Payroll Type	Payroll Type	Valid values: P - Permanent T - Temporary C - Contractual This field is required.		1	57	Empuser.ftext7 where empuser.page_no = ‘32000’. If fext7 is empty reports ‘T’