Retirement Systems - Data Definitions
The following table lists the data items, description, database fields, type, size, and from where the data is retrieved.
Data Item | Description | Loaded Into (Table.Field) | Type | Size | Location |
|---|---|---|---|---|---|
Payroll End Date | The date on which the pay period ends. | mdretire.payroll_end | Date | Not Applicable | Entered when data is loaded. |
Last Name | The employee’s last name. | mdretire.l_name | Character | 30 | employee.l_name[1,17] |
First Name | The employee’s first name. | mdretire.f_name | Character | 30 | employee.f_name[1,12] |
Social Security | The employee’s Social Security Number. | mdretire.ssn | Character | 11 | employee.ssn |
Employee Number | The employee number. | mdretire.empl_no | Integer | Not Applicable | employee.empl_no |
Transaction Code | Always 405 (Payroll data transaction). | mdreitre.trans_code | Character | 3 | 405 |
System Code | Designates which individual system the employee is a member of. Valid values:
| mdretire.sys_cd | Character | 1 | mdretire_ded.sys_cd |
Location | The Agency code is an eight-digit numeric code used to identify each employer. The State Retirement Agency assigns the first four digits. The last four digits may be used by local participating governmental units or contain state appropriation codes but are generally 0000 if not used by the participating governmental units. | mdretire.location | Character | 8 | If System Code is “1” or “6”: Otherwise, |
Plan Code | Valid values:
| mdretire.plan_code | Character | 1 | mdretire_ded.plan_code |
Actual Annual Salary | For full-time members, this amount equals the annual earnable salary. For part-time members, it is calculated as the member’s annual earnable salary multiplied by the percentage of time. | mdretire.cur_ansal | Integer | Not Applicable | empuser.tcode1 where page_no =’32000’ if a value exists. Or, The sum of payrate.annl_sal where the pay rate job class matches a job class in hrmstate.state47, hrmstate.state49 or hrmstate.state51 through hrmstate.state60 and is not exempt from retirement. |
Employee Contribution | Represents the actual contribution amount for the pay period in dollars and cents. Do not round off. | mdretire.emp_cont | Decimal | 9,2 | If the deduction is board paid: deduct.cont_c Otherwise: deduct.taken_c |
Hours Worked | Reflects the actual number of hours worked (including annual, personal, sick, and compensatory hours paid) during the pay period. The actual hours worked may not exceed the total standard hours for the pay period for full-time and part-time employees. It should not reflect overtime. | mdretire.hrs_wrk | Decimal | 10,2 | Empuser.ftext10 where empuser.page_no = ‘32000’ if exists; otherwise, sum of checkhi2.hours for non-exempt earnings. |
Standard Worked | Reflects the regular hours for a full-time position during each pay period. The minimum standard hour for a position cannot be less than 30 hours per week for a teacher or ten-month employee or 35 hours per week for a 12-month employee. It should not include overtime. | mdretire.std_hrs | Decimal | 6,2 | empuser.ftext4 where empuser.page_no = ‘32000’ |
Percent Time | The percentage of budgeted time the employee is scheduled to work in a position. For full-time employees, fill with zeros. For part-time employees, fill with the applicable percentage (budgeted hours to the standard hours). It does not fluctuate from pay period to pay period. | mdretire.per_time | Small Integer | Not Applicable | Payrate.fte If payrate.fte is greater than 1.0 then per_time = 1.0. |
Base Salary Paid | Represents the gross recurring salary payable at the end of each pay period during the fiscal year. For full-time employees, this can be determined by taking the total gross salary divided by the total number of regular pay periods for the fiscal year. However, because it is calculated on the number of hours worked, for full-time employees working less than standard hours, the Base Salary Paid can fluctuate for that pay period. The Base Salary Paid should fluctuate based on Hours Worked for part-time employees. It does not include overtime, shift differential, bonus, summer school wages, etc. It is reflected as dollars and cents. Do not round off to the nearest whole dollar. | mdretire.base_sal_pd | Decimal | 10,2 | deduct.sal_c |
Annual Earnable Salary | Represents the total earnable salary on an annualized basis for a full-time position. For full-time employees, it will equal the Actual Annual Salary. For part-time employees, it will represent the total amount a full-time employee would earn in that position (Actual Annual Salary / Percentage of Time). It is reflected as whole dollars only. Includes:
Excludes:
| mdretire.annl_pt_sal | Integer | Not Applicable | If percent time is 0: mdretire.cur_ansal Otherwise: Mdretire.cur_ansal/ payrate.fte |
Street Address | The employee’s home street address. | mdretire.str_addr | Character | 30 | employee.addr1 |
Miscellaneous Address | Overflow address field for additional miscellaneous home address information. For example, Apt. B. | mdretire.misc_addr | Character | 30 | employee.addr2 |
City | The employee’s home city. | mdretire.city | Character | 20 | employee.city |
State | The employee’s home state. | mdretire.state_id | Character | 2 | employee.state_id |
Zip Code | The employee’s home address zip code. | mdretire.zip1 | Character | 5 | employee.zip[1,5] |
Zip Code Extension | The employee’s home address zip code extension. | mdretire.zip2 | Character | 4 | employee.zip[7,10] |
Middle Initial | The employee’s middle initial. | mdretire.mid_init | Character | 1 | employee.m_name[1,1] |