The Retirement Time import file format is .xml, .exml, .csv,.txt, or .unl.
The following table shows the data columns, names, descriptions, destination database fields, and whether the field is required in the Retirement Time .csv import file.
|
Column |
Name |
Description |
Destination Database Field (table.field) |
Required or Optional |
|---|---|---|---|---|
|
A |
SERS Earnings Code |
The type of earnings for SERS reporting. Valid values:
|
oh_payrun_hrsdays.earn_code |
Required for SERS records. Not required for STRS records. |
|
B |
Employee Number |
The employee number. |
oh_payrun_hrsdays.empl_no |
Required |
|
C |
Retirement Days |
The number of days worked during the pay period that count toward retirement service credit. |
oh_payrun_hrsdays.pay_days |
Required |
|
D |
SERS Retirement Hours |
The number of hours worked during the pay period for SERS retirement reporting. |
oh_payrun_hrsdays.pay_hours |
Required |
|
E |
Pay Run |
The payroll run code that identifies a specific payroll processing cycle. |
oh_payrun_hrsdays.pay_run |
Required |
|
F |
Retirement System |
Identifies which Ohio retirement system the record applies to. Valid values:
|
oh_payrun_hrsdays.retsys |
Required |