PowerSchool ERP Minnesota

Contribution Report - Header (Type 03) Record - File Layout and Data Mapping

The following table lists the field names, descriptions, positions, lengths, formats, and data sources or valid values for the Contribution report’s Header (Type 03) record.

Field Name

Description

Position

Length

Format

Data Source or Valid Values

Record Type

Identifies the type of record.

1-2

2

Left-justified

The valid value is 03.

Employer Unit Number

Identification number assigned to the employer by the Teachers Retirement Association (TRA).

3-10

8

Right-justified, zero-filled

Retrieved from the TRA Employer Number field on the Human Resources Profile - State page.

Batch Date/Time

Batch creation date and time.

11-22

12

MMDDYYYYHHmm

System-generated timestamp when the batch was created during the Load process.

Record Count

The total number of records in the file (including the header).

23-28

6

Right-justified, zero-filled

The valid value is the count of all detail records in the batch plus 1 (for the header record itself).

Filler

Fill with spaces.

29-276

248

spaces

Not applicable