PowerSchool ERP Minnesota

UFARS Report - Data Crosswalk - Org

Use the MN UFARS Report - Setup - Data Crosswalk - Org page to create a crosswalk (translation table) that converts your district's internal organization codes to the corresponding state-defined UFARS Org codes during the UFARS report generation process.

The Org crosswalk is more complex than the Fund crosswalk because it can be fund-specific and can differentiate between revenue and expenditure transactions.

  1. On the MN UFARS Report - Setup - Data Crosswalk - Fund page, select Org from the Crosswalk Type drop-down list.

  2. Select the Year.

  3. Filter records using the filter criteria. To enter filter criteria:

    1. Select an option in the first field.

    2. Select or enter a value.

    3. Select Add if the button is enabled.
      Refer to Search for records for more information.

      • To add a record, select Add Record. Refer to the Field descriptions and enter valid information in the required fields. Select Save, then Yes.

      • To edit a record, select the record and select Accept. Update the information and select Accept.

      • To delete, select Delete, then Yes.

      • To download the information, select Download, then select Download PDF or Download as an Excel Document. The default file names are:

        • Excel: MN UFARS Report Org Crosswalk_<MMDDYYYY_hhmmss>.xlsx

        • PDF: MN UFARS Report Org Crosswalk_<MMDDYYYY_hhmmss>.pdf

Field descriptions

The following table describes the fields on the MN UFARS Report - Setup - Data Crosswalk - Org page.

Field

Description

Year

The fiscal year of the org crosswalk.

District Fund

The district-level fund code to which this organization mapping applies.

Enter a specific fund code to limit the mapping to that fund, or enter an asterisk (*) to apply the mapping to all funds.

District Org

The district-level organization code that needs to be translated to a UFARS code.

UFARS Org

The corresponding state-level UFARS organization code that will be reported to the Minnesota Department of Education.

Revenue Only

Indicates whether this crosswalk mapping applies only to revenue transactions.

Valid values:

  • No = The mapping applies to all transaction types.

  • Yes = The mapping applies only to revenue transactions.

The default is No.