Skip to Content
District Fact Template 2019-10-08T16:56:25-06: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, CodeValid
Values
1DISTRICT CODECHARACTER, REQUIRED, KEY
2REPORTING DATEDATE, REQUIRED, KEY
  • 2019-10-01 = 40D
  • 2019-12-15 = 80D
  • 2020-03-01 = 120D
3CATEGORY 01CHARACTER, REQUIRED, KEY
  • Bus Transportation
4CATEGORY 02CHARACTER, REQUIRED, KEYValid Values for K5P, 80D, 120D

  • ELIGSTUDNOTSTARS
  • MILEAGE
  • FEEDER
  • PROJSTUDENTS

Valid Values for 40D

  • MILEAGE
6PRIMARY MEASURE TYPECHARACTER, REQUIRED, KEY
  •  COUNT
7COUNTNUMBER, REQUIRED, KEY
18CATEGORY SET CODECHARACTER, REQUIRED, KEYValid Values for K5P, 80D, 120D

  • ELIGSTUDNOTSTARS
  • MILEAGE
  • FEEDER
  • PROJSTUDENTS

Valid Values for 40D

  • MILEAGE

Submit one record for each category set.  Example:

DISTRICT CODEREPORTING
DATE
CATEGORY 01CATEGORY 02PRIMARY MEASURE
TYPE
COUNTCATEGORY SET CODE
0002019-12-15Bus TransportationELIGSTUDNOTSTARSCOUNT10ELIGSTUDNOTSTARS
0002019-12-15Bus TransportationMILEAGECOUNT5869MILEAGE
0002019-12-15Bus TransportationFEEDERCOUNT8FEEDER
0002019-12-15Bus TransportationPROJSTUDENTSCOUNT220PROJSTUDENTS
Page last updated October 8, 2019