PowerSchool ERP Missouri

ASBR Expenditures Report - File Layout And Data Mapping

The default file name for the ASBR Expenditures report is ASBRFILE.CSV.

For the latest file layout information, search for and refer to the current file specification document on the Missouri Department of Elementary and Secondary Education (DESE) website.

The following table shows the columns, column names, descriptions, and data sources or valid values for the ASBR Expenditures report.

Column

Column Name

Description

Data Source or Valid Values

A

ASBR Fund

The ASBR Fund code.

Valid values:

  • 1 = General Fund

  • 2 = Special Revenue Fund

  • 3 = Debt Service Fund

  • 4 = Capital Projects Fund 

Retrieved from the ASBR Fund field on the Expenditure Detail form of the MO Annual Secretary of the Board Report - Expenditure Detail page.

B

Account

The ASBR Function code.

Retrieved from the ASBR Function field on the Expenditure Detail form of the MO Annual Secretary of the Board Report - Expenditure Detail page.

C

ASBR Object

The ASBR Object code.

Retrieved from the ASBR Object field on the Expenditure Detail form of the MO Annual Secretary of the Board Report - Expenditure Detail page.

D

ASBR Location

The ASBR Location code.

Retrieved from the ASBR Location field on the Expenditure Detail form of the MO Annual Secretary of the Board Report - Expenditure Detail page.

E

ASBR Source

The ASBR Source code.

Retrieved from the ASBR Source field on the Expenditure Detail form of the MO Annual Secretary of the Board Report - Expenditure Detail page.

F

ASBR Project

The ASBR Project code

Retrieved from the ASBR Project field on the Expenditure Detail form of the MO Annual Secretary of the Board Report - Expenditure Detail page.

G

Actual

The expenditure amount.

Retrieved from the Amount field on the Expenditure Detail form of the MO Annual Secretary of the Board Report - Expenditure Detail page.

H

Date

The report generation date.

The valid value is the date on which the report was generated.

I

District Id

The county district code.

Retrieved from the County District Code field on the MO Annual Secretary of the Board Report - Expenditure Detail - Setup - Reporting Structure page.

J

Report Year

The fiscal year being reported.

Retrieved from the Year field on the MO Annual Secretary of the Board Report - Expenditure Detail - Reports page.