Skip to Content
Student Cohort Group Fact 2019-02-15T13:56:21-07:00

Template Description:   The Student Cohort Group Fact Template is used to capture Career Technical Student Organizations (CTSO) that students are participating in during the school year. Every student who participates in a CTSO should be reported in this template.

School Year 2018-2019 Changes: This template is new for this school year.

Data Submission Schedule:

  • 40 Day is optional
  • 80 Day is optional
  • 120 Day is required
  • End of Year is Required

Grain:  One record per district / school year / student / CTSO

Load Dependencies:

  1. Student Snapshot

File Name Format:  DDD_STUDENT_COHORT_GROUP_FACT_YYYYMMDDHHMM.fff
File Name Format Example:  001_STUDENT_COHORT_GROUP_FACT_201807071201.csv

Field NumberField NameData Type, Required, CodeValid Values
1DISTRICT CODECharacter, Required, KeySchool year 2018-2019 Districts
2STUDENT IDCharacter, Required, KeyEnter the 9 digit student id
3STATE COHORT GROUP DISTRICT CODECharacter, Required, Key
  • 000 (Must be this value)
5COHORT GROUP CODECharacter, Required, Key

  • BPA = Business Professionals of America
  • DECA = DECA
  • ER = Educators Rising
  • FCCLA = Family, Career and Community Leaders of America
  • HOSA = Health Occupations Students of America
  • NFFA = National Future Farmers of America
  • SKILLS = Skills USA
  • TSA = Technology Student Association (TSA)
6SCHOOL YEAR DATEDate, Required, Key
  • 2019-06-30
7REPORTING DATEDate, Required, Key
  • 2018-10-01 = 40 Day
  • 2018-12-15 = 80 Day
  • 2019-03-01 = 120 Day
  • 2019-06-01 = End Of Year
8GROUP ENTRY DATEDate, Required, Key
  • 2018-07-01
12LOCATION CODECharacter, Required, KeySchool Year 2018-2019 Locations

FAQs

Q:  How is participation defined?
A:  Students who have paid dues (can be through fundraising) and are enrolled as members of a national student organization and considered CTSO participants.

Page last updated February 15, 2019