PowerSchool ERP Louisiana

LA Unique Id - File Layout and Data Mapping - Trailer Record

The Trailer record should always be the last in the file.

The Trailer record should be delimited by a single tab or space character, and there should be no extra spaces or data after the last column in the Trailer Record.

The following table shows the fields, descriptions, data types, data sources or valid values, and whether the field is required or optional for the LA Unique Id upload file’s trailer record.

Field

Description

Data Type

Data Source or Valid Values

Required or Optional

Record Type

Identifies the record type.

Char (2)

The valid value is TT.

Required

Transmission ID

Use this number for auditing, as an identifier for the submission.

VarChar (10)

The valid value is the same Transmission ID from the header record.

Required

Number of Records

The number of records in the file, including the header and trailer records.

VarChar (10)

The valid value is the number of records in the file, including the header and trailer records.

Required