Ed-Fi Data v3.X - Cohorts | Infinite Campus Test

Classic View: System Administration > Ed-Fi

Search Terms: Ed-Fi

This entity represents any type of list of designated students for tracking, analysis, or intervention.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
Post	When a Program is added and is mapped to a Cohort Type Descriptor. The Program can only be created from Program Admin> Programs> Programs tab.
Put	If the Category or Description changes.
Delete	If the Program is Deleted.

Action

Trigger

Post

When a Program is added and is mapped to a Cohort Type Descriptor.

The Program can only be created from Program Admin> Programs> Programs tab.

Put

If the Category or Description changes.

Delete

If the Program is Deleted.

School Exclude, Calendar Exclude, Resource Toggle and Resync Logic

This table describes the School Exclude, Calendar Exclude, Resource Toggle and Resync logic of this object.

Action	Trigger
None	If a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send.
Delete	If a resource is toggled to 'OFF" after data has sent and an action is performed that would trigger a delete, that data will remain in the ODS until a resync is done.
Resync	If a Calendar Event record is in the Ed-Fi Identity Mapping table and not in the ODS, it will be deleted from the Ed-Fi Identity Mapping table.
Resync	If a Calendar Event record is in the ODS and it does not have a matching record in Campus or the Ed-Fi Identity Mapping table, it will be deleted from the ODS.
Resync	If a mapping is changed in Resource Preferences, a resync will need to be done to reflect the changes.

Natural Key Changes, Cascading Updates, and Deletes Logic

This table describes the Natural Key Changes/Cascading Updates and Deletes logic of this object.

Action	Trigger
Post/Delete	Natural Key change: N/A - program ID cannot change.
Delete	The following resources will be deleted/reposted: Student Cohort Associations & Staff Cohort Associations If a mapping to the Ed-Fi Cohort Type Descriptor is removed or changed, a resync must be completed on 'All Schools' to delete/repost Student & Staff Cohort Associations. If only 1 school is selected, only Student & Staff Cohort Association records associated with that school will be updated and the Cohort will remain until a resync on 'All Schools' for Cohorts is completed.

Action

Trigger

Post/Delete

Natural Key change: N/A - program ID cannot change.

Delete

The following resources will be deleted/reposted:

Student Cohort Associations & Staff Cohort Associations
If a mapping to the Ed-Fi Cohort Type Descriptor is removed or changed, a resync must be completed on 'All Schools' to delete/repost Student & Staff Cohort Associations. If only 1 school is selected, only Student & Staff Cohort Association records associated with that school will be updated and the Cohort will remain until a resync on 'All Schools' for Cohorts is completed.

Scope Year Logic

This table describes scope year logic of this object.

Logic
The record will send to the scope year for the school year the program record is associated with. Data will only send for years that have valid configuration.

Logic

The record will send to the scope year for the school year the program record is associated with.

Data will only send for years that have valid configuration.

Resource Preferences

This table describes the Resource Preferences of this object.

Data Element Label	Mapping Needed
Program Category	cohortScopeDescriptor
Programs	cohortTypeDescriptor

Identity Mapping Object Key

This table describes the Identity Mapping Object Key of this object.

campusObjectType	Object Key Data Source
Program	programID

Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus Table	Ed-Fi Action	Fields
programs	Post	The primary table used for sending data for this resource.

Object Data Elements

Data Element Labels in bold are part of the Natural Key and are required data elements for Data to send to Ed-Fi.

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
id	The unique identifier of the resource.		M
cohortIdentifier	The name or ID for the cohort.	Report the Program ID.	M	Program Admin> Programs> Program> ProgramID	program. programID
educationOrganizationReference	A reference to the related Education Organization resource.	Report the value in (System Admin>Resources>District Information>District Detail>State District Number).	M	System Administration> Resources> District Information> State District Number	district.number
academicSubjectDescriptor	The subject for an academic intervention (e.g., science, mathematics).	This field is optional, does not report.	O
cohortDescription	The description of the cohort and its purpose.	Report text in the Description field. If NULL, do not report.	O	Program Admin> Programs> Programs> Description	program.description
cohortScopeDescriptor	The scope of cohort (e.g., campus, district, classroom).	Report the mapped Ed-Fi Code from Resource Preferences. If a Category is not selected on the cohort or the Ed-Fi Code is NULL, do not report.	O	Program Admin> Programs> Programs> Category	program.program Category
cohortTypeDescriptor	The type of the cohort (academic intervention, attendance intervention, discipline intervention, breakout session, etc.).	Report the mapped Ed-Fi Code from Resource Preferences If the Ed-Fi Code is NULL, do not report.	M
programs	An unordered collection of cohortPrograms. The optional program associated with this cohort (e.g., Special Education).	This field is optional, does not report..	O
etag			O

Type/Descriptor

Cohort Type Descriptor

Code Value	Description	Namespace	Short Description
Academic Intervention	Academic Intervention	uri://ed-fi.org/CohortTypeDescriptor	Academic Intervention
Attendance Intervention	Attendance Intervention	uri://ed-fi.org/CohortTypeDescriptor	Attendance Intervention
Classroom Pullout	Classroom Pullout	uri://ed-fi.org/CohortTypeDescriptor	Classroom Pullout
Counselor List	Counselor List	uri://ed-fi.org/CohortTypeDescriptor	Counselor List
Discipline Intervention	Discipline Intervention	uri://ed-fi.org/CohortTypeDescriptor	Discipline Intervention
Extracurricular Activity	Extracurricular Activity	uri://ed-fi.org/CohortTypeDescriptor	Extracurricular Activity
Field Trip	Field Trip	uri://ed-fi.org/CohortTypeDescriptor	Field Trip
In-school Suspension	In-school Suspension	uri://ed-fi.org/CohortTypeDescriptor	In-school Suspension
Other	Other	uri://ed-fi.org/CohortTypeDescriptor	Other
Principal Watch List	Principal Watch List	uri://ed-fi.org/CohortTypeDescriptor	Principal Watch List
Study Hall	Study Hall	uri://ed-fi.org/CohortTypeDescriptor	Study Hall

Cohort Scope Descriptor

Code Value	Description	Namespace	Short Description
Classroom	Classroom	uri://ed-fi.org/CohortScopeDescriptor	Classroom
Counselor	Counselor	uri://ed-fi.org/CohortScopeDescriptor	Counselor
District	District	uri://ed-fi.org/CohortScopeDescriptor	District
Network	Network	uri://ed-fi.org/CohortScopeDescriptor	Network
Other	Other	uri://ed-fi.org/CohortScopeDescriptor	Other
Principal	Principal	uri://ed-fi.org/CohortScopeDescriptor	Principal
School	School	uri://ed-fi.org/CohortScopeDescriptor	School
Statewide	Statewide	uri://ed-fi.org/CohortScopeDescriptor	Statewide
Teacher	Teacher	uri://ed-fi.org/CohortScopeDescriptor	Teacher

Ed-Fi Data v3.X - Cohorts