Classic View: System Administration > Ed-Fi
Search Terms: Ed-Fi
This association indicates the Staff associated with a cohort of students.
NDE will be collecting programs in Cohort for the 2021-22 school year. In order to assign a staff member to a Cohort Program, a Program Session needs to be created in Program Admin > Programs > Program Sessions.
Object Triggering Logic
This table describes logic for triggering syncing of this object.
Action | Trigger |
---|---|
Post | When a Staff is assigned as "Instructor" to a Program Session that is reported as a Cohort in the Scoped Year.
|
Put | The end date is updated on the Program Sessions tab. |
Delete/Post | If any part of the Natural Key changes:
|
Delete | If the Program Session is deleted. |
Delete | Staff is removed from the "Instructor" field. |
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. |
Resync | If a 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 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 changes:
|
Delete | Cascading Deletes: N/A - there are no dependent resources. |
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.
|
Event Queue Detail
This table describes the Event Queue Detail of this object.
Campus Table | Ed-Fi Action | Fields |
---|---|---|
programSession | 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 | |||
beginDate | The month, day, and year on which the Student was first identified as part of the Cohort. | Reports the Start Date the staff is assigned to the Program Session. | M | Programs Admin > Programs > Program Sessions > Start Date | programSession.startdate |
cohortReference | A reference to the related Cohort resource. | Reports the Natural Key of the Cohort resource. | M | ||
staffreference | A reference to the related Staff resource. | Reports the Natural Key of the Staff resource. | M | ||
endDate | The month, day, and year on which the Student was removed as part of the Cohort. |
| C | Programs Admin> Programs> Program Sessions> End Date | programSession.enddate |
studentRecordAccess | Indicator of whether the staff has access to the student records of the cohort per district interpretation of FERPA and other privacy laws, regulations, and policies. | This is optional, does not report. | O | ||
etag | O |