Certified Annual Report - File Layouts
The default file name is CAR<YYYY><District ID>.csv.
Record Layout
The following table lists the fields, data type, length, and notes for the CAR electronic file.
Field | Type | Length | Notes |
---|---|---|---|
District ID | Text | 4 | - |
Account ID | Text | 1 | Valid values:
Account ID 1-7 match the first digit in the balance sheet account code. |
Fund | Text | 2 | - |
*Facility | Text | 4 | *required to segregate Charter School transactions |
Function | Text | 4 | - |
Program | Text | 3 | - |
Project | Text | 4 | - |
Object | Text | 3 | - |
Source | Text | 4 | - |
Account | Text | 3 | - |
**Amount | Numeric | 18 | **decimal point expected; comma or dollar sign not allowed |
Header Record
The first record of the import file contains the District ID. Fields following the District ID are represented by zeroes (0).
Example: 4203,0,00,0000,0000,000,0000,000,0000,000,0
Trailer Record
The last record of the import file contains the District ID and the count of records in the input file including the header and trailer records. The count of records is stored in the Amount field. Fields between the District ID and Amount fields are represented by nines (9).
Example: 4203,9,99,9999,9999,999,9999,999,9999,999,7123