PowerSchool ERP Minnesota

UFARS Reports - Header (A or U) Record - File Layout and Data Mapping

The following table lists the field names, descriptions, positions, lengths, and data sources or valid values for the UFARS report's Header (A or U) Record.

Field Name

Description

Position

Length

Data Source or Valid Values

Audited Flag

Indicates whether the fiscal year's financial statements have been reviewed and certified by auditors.

1

1

Valid values:

  • A = Audited

  • U = Unaudited

Retrieved from the Audited field on the MN UFARS Report - Reports page.

District ID

The unique identifier assigned to your school district by the Minnesota Department of Education.

2-5

4

Retrieved from the District ID field on the MN UFARS Report - Setup - District Settings page.

District Type

The classification code that identifies the type of educational organization.

6

1

Retrieved from the District Type field on the MN UFARS Report - Setup - District Settings page.

Region Code

The regional code or area designation for the district.

7-8

2

Retrieved from the Region Code field on the MN UFARS Report - Setup - District Settings page.

Fiscal Year

The fiscal year of the UFARS report data.

9-13

5

Retrieved from the Fiscal Year field on the MN UFARS Report - Reports page.

Timestamp

The time the report file was created.

14-23

10

System-generated at the time of file creation.

Filler

Fill with spaces

24-40

17

spaces

Version

The UFARS report version.

41-42

2

The valid value is 00 and is hardcoded.

GL Record Count

The count of General Ledger records.

43-48

6

System-calculated from the count of General Ledger records extracted for the report.

Expenditure Record Count

The count of Expenditure records.

49-54

6

System-calculated from the count of Expenditure records extracted for the report.

Revenue Record Count

The count of Revenue records.

55-60

6

System-calculated from the count of Revenue records extracted for the report.