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.
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: Check to see if it is a District course or a College course being reported
educationOrganizationId: Check to see if it is a District course or a College course being reported.
| M | CourseCode: Course > CourseID Course > College Course Code educationOrganizatonId: 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.collegeCourseCode 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 College course or a State course being reported. (For the toCourseCode to be College then course level is D or A)
educationOrganizationId: Check to see if it is a College course or a State course being reported.
| M | CourseCode: Course > CourseID Course > College Course Code educationOrganizatonId: 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.collegeCourseCode course.stateCode educationOrganizatonId: District.type District.number |
Resource Preferences Continued
The Ed-Fi Configuration tool is used to establish Ed-Fi data resources.
The following describes how to enable the Course Course Associations resource for Ed-Fi reporting. If the Configure or Edit button do not display, then the resource does not need to be mapped and the toggle button can be used to turn the resource on or off.
- Set the Course Course Associations preference to ON.
