Skip to Content

Student Cohort Group Fact

Student Cohort Group Fact 2019-02-15T13:56:21-06: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 Number Field Name Data Type, Required, Code Valid Values
1 DISTRICT CODE Character, Required, Key School year 2018-2019 Districts
2 STUDENT ID Character, Required, Key Enter the 9 digit student id
3 STATE COHORT GROUP DISTRICT CODE Character, Required, Key
  • 000 (Must be this value)
5 COHORT GROUP CODE Character, 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)
6 SCHOOL YEAR DATE Date, Required, Key
  • 2019-06-30
7 REPORTING DATE Date, Required, Key
  • 2018-10-01 = 40 Day
  • 2018-12-15 = 80 Day
  • 2019-03-01 = 120 Day
  • 2019-06-01 = End Of Year
8 GROUP ENTRY DATE Date, Required, Key
  • 2018-07-01
12 LOCATION CODE Character, Required, Key School 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