Licensure
Column Title
Column Title
Column Title
Haven’t found what you’re looking for?
Target Table: DISTRICT_FACT
Data Submission Schedule: 40 Day (ELTP Only), 80 Day, 120 Day
GRAIN: One record per district / fact
LOAD DEPENDENCIES: NONE
Template Description – The District Fact template is used to report the following district level bus “facts”:
School Year 2019-2020 Changes:
DELETE OPTIONS
1. Delete District_Fact by District Code and Reporting Date. Deletes all records for reporting date.
File Name Format: DDD_DISTRICT_FACT_YYYYMMDDHHMM.fff
File Name Format Example: 001_DISTRICT_FACT_201807071201.csv
| Field Number | Field Name | Data Type, Required, Code | Valid Values |
|---|---|---|---|
| 1 | DISTRICT CODE | CHARACTER, REQUIRED, KEY | |
| 2 | REPORTING DATE | DATE, REQUIRED, KEY |
|
| 3 | CATEGORY 01 | CHARACTER, REQUIRED, KEY |
|
| 4 | CATEGORY 02 | CHARACTER, REQUIRED, KEY |
Valid Values for K5P, 80D, 120D
Valid Values for 40D
|
| 6 | PRIMARY MEASURE TYPE | CHARACTER, REQUIRED, KEY |
|
| 7 | COUNT | NUMBER, REQUIRED, KEY | |
| 18 | CATEGORY SET CODE | CHARACTER, REQUIRED, KEY |
Valid Values for K5P, 80D, 120D
Valid Values for 40D
|
Submit one record for each category set. Example:
| DISTRICT CODE | REPORTING DATE |
CATEGORY 01 | CATEGORY 02 | PRIMARY MEASURE TYPE |
COUNT | CATEGORY SET CODE |
|---|---|---|---|---|---|---|
| 000 | 2019-12-15 | Bus Transportation | ELIGSTUDNOTSTARS | COUNT | 10 | ELIGSTUDNOTSTARS |
| 000 | 2019-12-15 | Bus Transportation | MILEAGE | COUNT | 5869 | MILEAGE |
| 000 | 2019-12-15 | Bus Transportation | FEEDER | COUNT | 8 | FEEDER |
| 000 | 2019-12-15 | Bus Transportation | PROJSTUDENTS | COUNT | 220 | PROJSTUDENTS |