Student Cohort Group Fact Template (New Mexico)

Classic View: NM State Reporting > STUDENT_COHORT_GROUP_FACT

Search Term: STUDENT_COHORT_GROUP_FACT

The Student Cohort Group Fact Template is used to capture the Career Technical Student Organizations (CTSO) in which students are participating during the school year. 

Example Extract Editor

Report Logic

  • Reports one record per active student's CTSO participation (flag) when active on at least one date in the reporting range.
  • To report, the student must be actively enrolled in at least one calendar on at least one date during the reporting range.
  • Students are NOT included if
    • their enrollment record is marked as State Exclude;

    • their enrollment record is marked as No Show;

    • their Grade Level of enrollment is marked as State Exclude; or

    • their Calendar of enrollment is marked as State Exclude.

  • To report, the Flag must have a Program State Code selected where the Standard Code = CTSO.

Recommended Flag Setup

Program Admin > Flags > Flags Editor > Flags Detail

  • Make sure the Active checkbox is marked.
  • DO NOT mark the State Reported checkbox. If this checkbox is marked, CTSO flags will be included in the Programs Fact Template.
  • Be sure to select a valid CTSO Code from the State Program Code dropdown list.

Student Information > General > Flags > Student Flag Editor > Student Flag Detail

  • Select the Flag that is mapped to the CTSO program in which the student is participating.
  • Enter the date on which the student starts participating in the CTSO of record during the current school year in the Start Date field.
  • Enter the date on which the student stops participating in the CTSO of record during the current school year in the End Date field.

Report Editor

FieldDescription
Submission ScheduleThe collection period for the extract.
Start DateThe first day in the date range from which data will report.
End DateThe last day in the date range from which data will report.
Which students would you like to include in the report?

This option allows you to narrow your search results by using one of the following options.

  • Grade - Select a single grade or multiple grades. This is the mapped state grade level code. (CTRL-click or SHIFT-click to select multiple). 
  • Ad Hoc Filter - Select a filter to limit results to students included in the filter.
FormatThe format in which the report will generate. Options include State Format (CSV) or HTML.
Select CalendarsThe calendar(s) from which data is pulled for the report.
Generate Report/
Submit to Batch
Users have the option of submitting a report request to the batch queue by clicking Submit to Batch instead of Generate Extract. This process allows larger reports to generate in the background, without disrupting the use of Campus. For more information about submitting a report to the batch queue, see the Batch Queue article.


Report Layout

Element Name

Logic

Type, Format and Length

Campus Database

Campus Location

DistrictNumber

The state district number.

Alphanumeric, 20 charactersDistrict.numberSystem Administration > Resources > District Information > State District Number
StudentIDReports the state-assigned identifier for the student.Numeric, 9 digitsPerson.stateIDCensus > People > Demographics > State ID
StateCohortGroupDistrictCodeReports 0000.N/AN/AN/A
Filler4N/AN/AN/AN/A
CohortGroupCode

The State Programs Code for the active CTSO Flag.

CodeStudent Organization Name
BPABusiness Professionals of America
DECADECA
EREducation Rising
FCCLAFamily, Career and Community Leaders of America
HOSAHealth Occupations Students of America
NFFANational Future Farmers of America
SKILLSSkills USA
TSATechnology Student Association
Alphanumeric, 5 charactersProgram.codePrograms > Flags > Program Detail > State Programs Code
SchoolYearDateThe end year of the Year selected on the Campus tool bar plus the date 06-30. For example, 2019-06-30.

Date field, 10 characters

YYYY-MM-DD

N/AN/A
ReportingDateThe reporting date of the collection.This element reports the end year plus a specific value for the selected Submission Schedule.

Valid Values

  • YYYY-10-01: 40D
  • YYYY-12-15: 80D
  • YYYY-03-01: 120D
  • YYYY-06-01: EOY
  • YYYY-06-29: Summer Session

Date field, 10 characters

YYYY-MM-DD

Calendar.startDate

Calendar.endDate

System Administration > Calendar > Start/End Year
GroupEntryDateThe flag's Start Date.

Date field, 10 characters

YYYY-MM-DD

Program.startDate

Student Information > General > Flags > Start Date
Filler9N/AN/AN/AN/A
Filler10N/AN/AN/AN/A
Filler11N/AN/AN/AN/A
LocationCode

The state school number.

Reports 998 if, on the student's test date, the student has an active NM Exceptionality (state reporting) data entry plan where the Location is 998.

Otherwise, this field reports the State School Number based on the student's active, primary enrollment as of the date of the reporting assessment. If more than one enrollment is marked as primary or If no active enrollment is marked as primary, the number reports based on the lowest calendar ID.

Numeric, 5 digitsSchool.number

System Administration > Resources > School > State School Number