PowerSchool ERP Indiana

Form 9 Report - File Layout and Data Mapping

The default file name for the Form 9 report is <Corporation Number>form9.rpt.

The following table lists the field names, descriptions, positions, lengths, formats, and data sources or valid values for the Form 9 report.

Field Name

Description

Position

Length

Format

Data Source or Valid Values

Corporation Number

The four-digit state-assigned corporation identification number that identifies your school corporation/district to the Indiana Department of Education (IDOE).

1-4

4

Numeric

Retrieved from the Corporation Number field on the IN Biannual Form 9 Report – Load page.

Section

The specific reporting category of the financial data as required by the State of Indiana.

5

1

Numeric

Valid values:

  • 1 = Revenue

  • 2 = Expenditure

  • 3 = Revenue Exception

  • 4 = Expenditure Exception

  • 5 = Beginning Balance

  • 6 = Ending Balance

  • 8 = Encumbrances

  • M = Minus Exception

  • P = Plus Exception

Retrieved from the Section field on the Biannual Form 9 Data form of the IN Biannual Form 9 Report page.

Fund

The specific fund for which financial data is being reported.

6-9

4

Numeric

Retrieved from the Fund field on the Biannual Form 9 Data form of the IN Biannual Form 9 Report page.

Account/Budget Code

The function or program code (for expenditures) or revenue account code (for revenue) that identifies where funds came from or how they were used.

10-14

5

Numeric

Retrieved from the Budget Code field on the Biannual Form 9 Data form of the IN Biannual Form 9 Report page.

Object

The expenditure object code that identifies the nature or type of purchase.

15-17

3

Numeric

Retrieved from the Object field on the Biannual Form 9 Data form of the IN Biannual Form 9 Report page.

Amount

The cumulative total for all 13 periods for this organization/account or fund/account.

18-31

14

Numeric

Retrieved from the Amount field on the Biannual Form 9 Data form of the IN Biannual Form 9 Report page.

Building

The four-digit Indiana Department of Education state building identification code indicating which school building or location the transaction is associated with.

32-35

4

Character

Retrieved from the Building field on the Biannual Form 9 Data form of the IN Biannual Form 9 Report page.

Subcategory

A two-digit special designation code used to identify certain high per-pupil expenditure transactions that require additional state reporting detail or explanation.

36-37

2

Character

Retrieved from the Subcategory field on the Biannual Form 9 Data form of the IN Biannual Form 9 Report page.