Skip to Content
District Fact Template 2019-10-08T16:56:25-07:00

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”:

  1. 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).
  2. Number of per capita feeder routes.
  3. Per capita feeder annual mileage.
  4. 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
  • 2019-10-01 = 40D
  • 2019-12-15 = 80D
  • 2020-03-01 = 120D
3 CATEGORY 01 CHARACTER, REQUIRED, KEY
  • Bus Transportation
4 CATEGORY 02 CHARACTER, REQUIRED, KEY Valid Values for K5P, 80D, 120D

  • ELIGSTUDNOTSTARS
  • MILEAGE
  • FEEDER
  • PROJSTUDENTS

Valid Values for 40D

  • MILEAGE
6 PRIMARY MEASURE TYPE CHARACTER, REQUIRED, KEY
  •  COUNT
7 COUNT NUMBER, REQUIRED, KEY
18 CATEGORY SET CODE CHARACTER, REQUIRED, KEY Valid Values for K5P, 80D, 120D

  • ELIGSTUDNOTSTARS
  • MILEAGE
  • FEEDER
  • PROJSTUDENTS

Valid Values for 40D

  • MILEAGE

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
Page last updated October 8, 2019