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:
This field is required. | 1 | 57 | Empuser.ftext7 where empuser.page_no = ‘32000’. If fext7 is empty reports ‘T’ |