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”:
- Number of eligible students transported that are not included in STARS. (Student lives in NM but goes to school in another state and you transport them to the state border).
- Number of per capita feeder routes.
- Per capita feeder annual mileage.
- Projected number of students to be transported next year.
School Year 2019-2020 Changes:
- Added 40D Windows Dates for ELTP Only
- Snapshot Change:
- 40D snapshot date and collection window has been added.
- 40D will be used to collect Extended Learning Transportation data only.
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 |