OH Retirement Time - Pay Rates report - File layout and data mapping
The default file names for the OH Retirement Time - Pay Rates report are:
PDF: oh_payrate_hoursrpt<timestamp>.pdf
Excel: oh_payrate_hoursrpt<timestamp>.xlsx
The following table shows the columns, field names, descriptions, and data source or valid values for the OH Retirement Time - Pay Rates report’s .xlsx file format.
Column | Field Name | Description | Data Source or Valid Values |
|---|---|---|---|
A | EMPLOYEE NUMBER | The unique employee identification number assigned to the employee. | Retrieved from the Employee Number field on the OH Retirement Time page. |
B | EMPLOYEE NAME | The employee’s name. The format is last name, middle name, first name. | Retrieved from the Last Name, Middle Name, and First Name fields on the OH Retirement Time page. |
C | JOB CLASS | The job class associated with the employee’s primary pay rate. | Retrieved from the Job Class field on the OH Pay Rate Information page. |
D | SERS HOURS/DAY | The hours worked per day for SERS. | Retrieved from the SERS Hours/Day field on the OH Pay Rate Information page. |
E | FREEZE | Indicates whether to update the SERS Hours/Day during the pay rate update processes. | Retrieved from the Freeze field on the OH Pay Rate Information page. Valid values:
|