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. |