PERA Exclusion Report - File Layout and Data Mapping
The following table outlines the Minnesota PERA Exclusion report’s field names, descriptions, data type, length, and position.
The Fixed-Width Text format is used with a .txt extension.
Field Name | Description | Data Type | Length | Position |
|---|---|---|---|---|
Transaction Code | Field designates the record as detail. | Numeric | 2 | 1-2 |
Employer Number | Identification number given to the employer by PERA. | Numeric | 6 | 3-8 |
Exclusion Year | The calendar or fiscal year the report covers. | Numeric - YYYY | 4 | 9-12 |
Exclusion Code | Employee’s Exclusion Code. | Numeric | 3 | 13-15 |
Social Security Number (SSN) | Full or Partial Social Security Number. | Numeric | 9 | 16-24 |
Last Name | Employee’s Last Name | Alpha-numeric | 30 | 25-54 |
First Name | Employee’s First Name. | Text | 30 | 55-84 |
Middle Initial | Employee’s Middle Initial. | Text | 1 | 85-85 |
Original Hire Date | Employee’s Original Hire Date. | Date Field - YYYYMMDD | 8 | 86-93 |
Last Hire Date | Employee’s Last Hire Date. | Date Field - YYYYMMDD | 8 | 94-101 |
Status at Year End | Employee’s Employment Status at year end. | Text | 1 | 102-102 |
Annual Salary | Employee’s Annual Salary. | Numeric | 10 | 103-112 |
Last Pay Period Salary | Salary Amount last paid to the Employee in the Applicable Year. | Numeric | 10 | 113-122 |
Pay Cycle | Employee’s Pay Cycle. | Numeric | 1 | 123-123 |
Job Title | Employee’s Job Title. | Alpha-numeric | 30 | 124-153 |
Filler | Unused. Reserved for future expansion. | 97 | 154-250 |