PERA Annual Leave Report - File Layout and Data Mapping
The default file name for the PERA Annual Leave report is MN PERA LOA Electronic Report_<YYYY>.xlsx.
The following table shows the columns, column names, descriptions, and data sources or valid values for the PERA Annual Leave report’s .xlsx file format.
Column | Column Name | Description | Data Source or Valid Values |
|---|---|---|---|
A | Transaction Code | The two-character PERA leave type code identifying the type of leave. | Valid values:
Retrieved from the Leave Type field on the Employee Information form of the MN PERA Annual Leave Report page. |
B | Employer Number | The district's PERA employer identification number. | Retrieved from the PERA Employer Number field on the Human Resources Profile - State page. |
C | SSN | The employee's Social Security number. | Retrieved from the Social Security field on the Employee Information form of the MN PERA Annual Leave Report page. |
D | Leave Start Date | The start date of the leave period. | Retrieved from the Leave Start Date field on the Employee Information form of the MN PERA Annual Leave Report page. |
E | Leave End Date | The end date of the leave period. | Retrieved from the Leave End Date field on the Employee Information form of the MN PERA Annual Leave Report page. |
F | Hourly Rate | The employee's hourly wage rate during the leave period. | Retrieved from the Hourly Rate field on the Employee Information form of the MN PERA Annual Leave Report page. |
G | Total Hours | The total number of leave hours for the period. | Retrieved from the Total Hours field on the Employee Information form of the MN PERA Annual Leave Report page. |