Classic View: System Administration > Ed-Fi
Search Terms: Ed-Fi
This entity supports associations from State, District, and College courses.
There are three categories of records, each involving the connection of one type of course data to another:
- A District Course associated to a State Course
- A District Course associated to a College Course
- A College Course associated to a State Course
In each case, a set of courseCode/educationOrganizationId data is being associated with a different set of courseCode/educationOrganizationId data.
District Course associated to a State Course:
District Course associated to a College Course
College Course associated to a State Course
Object Triggering Logic
This table describes logic for triggering syncing of this object.
| Action | Trigger |
|---|---|
| Post | When a new Course record is saved, and there is a value saved in the State Code, College Code and College Course Code fields:
|
| Delete | When a course record 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. |
| Delete | If a mapping is removed in Resource Preferences, and data has been sent to the ODS predicated on the Resource Preferences mapping record (i.e., a District > College CCA record was posted), the record will be deleted from the ODS and the Ed-Fi Identity Mapping table. |
| 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 |
|---|---|
| Delete/Post | If any of the following changes in the Schools resource: If the School Number/Ed-Fi School Number changes, a delete/post will occur with the cascading deletes from the change triggers, for any District Course records. |
| Delete/Post | If the College Course Code or State Code changes, a delete/post will occur with the cascading deletes from the School ID Change triggers, for any College Course or State Course records. |
| Delete/Post | If the College Place Holder is unchecked, a delete/post will occur with the cascading deletes for College → State Course Course/Course associations. |
Scope Year Logic
This table describes scope year logic of this object.
| Business Rules |
|---|
Course Course Associations will report to the configured year they are aligned to:
|
Resource Preferences
| Data Element | Mapping Needed |
|---|---|
| course.number: course.name | postSecondaryInstitution |
Object Data Elements
This table describes data elements sent within the Parents resource.
| Data Element Label | Business Requirement | Business Rules | M, C or O | Data Source GUI Path | Database Field |
|---|---|---|---|---|---|
| course Reference | courseCode: A unique alphanumeric code assigned to a course. educationOrganizationId: The identifier assigned to an education organization. | courseCode:
educationOrganizationId:
| M | CourseCode: Course > CourseID Course > College Course Code education OrganizatonId: System Administration > Resources > District > District Record > Ed-Fi District ID tt: System Administration > Resources > District Information > district record > Type dddd: System Administration > Resources > District Information > District Record > State District Number Course > College Code | CourseCode: course.courseID education OrganizatonId: District.type District.number |
| toCourse Reference | courseCode: A unique alphanumeric code assigned to a course. educationOrganizationId: The identifier assigned to an education organization. | courseCode: Check to see if it is a District course, a College course, or a State course being reported.
educationOrganizationId: Check to see if it is a District course, a College course, or a State course being reported.
| M | CourseCode: Course > CourseID Course > College Course Code Course > State Code education OrganizatonId: System Administration > Resources > District > District Record > Ed-Fi District ID tt: System Administration > Resources > District Information > district record > Type dddd: System Administration > Resources > District Information > district record > State District Number Course > College code | CourseCode: course.courseID course.stateCode education Organizaton Id: District.type District.number |
