PowerSchool ERP Vermont

Wage and Contribution Report - Total (T) Record - Record Layout and Data Mapping

The following table lists the positions, lengths, field names, descriptions, and data sources or valid values for the Total (T) record of the Wage and Contribution report.

Position

Length

Field Name

Description

Data Source or Valid Values

1

1

Record Identifier

Identifies the record type.

The valid value is T.

2–8

7

Total Number of Employees

The total count of Employee (S) records included in the file, determined by counting all employee wage records loaded for the selected quarter and pay runs.


System-calculated.

The valid value is the total count of Employee (S) records included in the file, determined by counting all employee wage records loaded for the selected quarter and pay runs.

9–12

4

Taxing Entity Code

Identifies the taxing entity type.

The valid value is UTAX.

13–26

14

Total Gross Wages

The sum of the Gross Wages values across all Employee (S) records in the file, accumulated from payroll check history during the load process.


System-calculated.

The valid value is the sum of the Gross Wages values across all Employee (S) records in the file, accumulated from payroll check history during the load process.

27–275

249

Filler

Leave blank

spaces