PowerSchool ERP Minnesota

Chapter X Validation Report - File Layout and Data Mapping (FAS On)

The following table shows the columns, column names, descriptions, and data sources or valid values for the Chapter X Validation report when Full Account Structure (FAS) is enabled.

Column

Column Name

Description

Data Source or Valid Values

A

FISCAL YEAR

The fiscal year to which the validation rule applies.

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

B

ACCOUNT ID


Identifies the type of financial record.


Valid values:

  • E = Expenditure

  • R = Revenue

  • G = General Ledger/Balance Sheet

System-generated based on record type.

C

FULL_ACCOUNT_NUMBER

The complete, formatted Full Account Number for each record that failed Chapter X validation.

This column is displayed when Full Account Structure (FAS) is enabled.

The system consolidates the Budget Code (Key Organization) and Account Number into a single formatted string,

D

UFARS FUND


The two-digit UFARS Fund code derived from the district's fund through crosswalk translation. This is the fund value that failed Chapter X or MARSS validation.

Retrieved from the Organization/Account Level field on the Fund row of the MN UFARS Report - Reporting Structure page, then translated using the MN UFARS Report - Setup - Data Crosswalk - Fund page.

E

UFARS ORG


The UFARS Organization code representing the school/site identifier. This value is validated against the MARSS table to ensure it corresponds to a valid MARSS number.


Retrieved from the Organization/Account Level field on the Org row of the MN UFARS Report - Reporting Structure page, then translated using the MN UFARS Report - Setup - Data Crosswalk - Org page.

F

UFARS PROGRAM


The three-digit UFARS Program code identifying the instructional or support program (e.g., Regular Instruction, Special Education).


Retrieved from the Organization/Account Level field on the Program row of the MN UFARS Report - Reporting Structure page, then translated using the MN UFARS Report - Setup - Data Crosswalk - Program page.

G

UFARS FINANCE


The three-digit UFARS Finance code indicating the funding source or financial category for the transaction.


Retrieved from the Organization/Account Level field on the Finance row of the MN UFARS Report - Reporting Structure page, then translated using the MN UFARS Report - Setup - Data Crosswalk - Finance page.

H

UFARS SOURCE/OBJECT


The three-digit UFARS Source code (for revenues) or Object code (for expenditures) that classifies the type of revenue received or expenditure made.


Retrieved from the Organization/Account Level field on the Object row of the MN UFARS Report - Reporting Structure page, then translated using the MN UFARS Report - Setup - Data Crosswalk - Object page.

I

UFARS COURSE


The 3-digit UFARS Course code identifying the subject area or course classification (primarily used for instructional expenditures).


Retrieved from the Organization/Account Level field on the Course row of the MN UFARS Report - Reporting Structure page, then translated using the MN UFARS Report - Setup - Data Crosswalk - Course page.

J

ERROR


The validation error message indicating why the record failed.


Valid values:

  • NO MATCH CHAPTER X = UFARS dimension combination not found in Chapter X Validation table.

  • NO MATCH MARSS = Organization code not found in MARSS table.

System-generated by comparing extracted records against the MN UFARS Report - Chapter X Validation page and the MN UFARS Report - MARSS Table page.