Tool Search: Student Cohort Group Fact Template
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
- 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.
- 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
| Field | Description |
|---|---|
| Submission Schedule | The collection period for the extract. |
| Start Date | The first day in the date range from which data will report. |
| End Date | The 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.
|
| Format | The format in which the report will generate. Options include State Format (CSV) or HTML. |
| Select Calendars | The 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 characters | District.number | System Administration > Resources > District Information > State District Number | ||||||||||||||||||
| StudentID | Reports the state-assigned identifier for the student. | Numeric, 9 digits | Person.stateID | Census > People > Demographics > State ID | ||||||||||||||||||
| StateCohortGroupDistrictCode | Reports 0000. | N/A | N/A | N/A | ||||||||||||||||||
| Filler4 | N/A | N/A | N/A | N/A | ||||||||||||||||||
| CohortGroupCode | The State Programs Code for the active CTSO Flag.
| Alphanumeric, 5 characters | Program.code | Programs > Flags > Program Detail > State Programs Code | ||||||||||||||||||
| SchoolYearDate | The 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/A | N/A | ||||||||||||||||||
| ReportingDate | The reporting date of the collection.This element reports the end year plus a specific value for the selected Submission Schedule. Valid Values
| Date field, 10 characters YYYY-MM-DD | Calendar.startDate Calendar.endDate | System Administration > Calendar > Start/End Year | ||||||||||||||||||
| GroupEntryDate | The flag's Start Date. | Date field, 10 characters YYYY-MM-DD | Program.startDate | Student Information > General > Flags > Start Date | ||||||||||||||||||
| Filler9 | N/A | N/A | N/A | N/A | ||||||||||||||||||
| Filler10 | N/A | N/A | N/A | N/A | ||||||||||||||||||
| Filler11 | N/A | N/A | N/A | N/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 digits | School.number | System Administration > Resources > School > State School Number |
