PowerSchool ERP Minnesota

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

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 off.

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

BUDGET CODE


The district's organization key (Key Orgn) from the budget ledger that identifies the specific budget unit associated with the invalid record.

Retrieved from the Key Organization field in the Budget, Expenditure, or Revenue Ledger during the Load process.

D

ACCOUNT


The district's account number from the ledger associated with the invalid record.

Retrieved from the Account field in the Budget, Expenditure, or Revenue Ledger during the Load process.

E

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.

F

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.

G

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.

H

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.

I

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.

J

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.

K

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.