Tool Search: Ed-Fi
This educational entity represents the organization of subject matter and related learning experiences provided for the instruction of students on a regular or systematic basis.
Object Triggering Logic
This table describes logic for triggering syncing of this object.
| Action | Trigger |
|---|---|
| GET | Vermont has pre-loaded courses so they are not posted or deleted. There is no trigger. This is a look-up only. A match on the State Course Code is done to verify the course exists in the ODS.
|
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 | When a resource is toggled to OFF after data has sent, all sent data remains in the ODS but no new data sends. |
| Delete | When a resource is toggled to OFF after data has sent and an action is performed that would trigger a delete, that data remains in the ODS until a resync is done. |
| Resync | When a record is in the Ed-Fi Identity Mapping table and not in the ODS, it is deleted from the Ed-Fi Identity Mapping table. |
| Resync | When a record is in the ODS and it does not have a matching record in Campus or the Ed-Fi Identity Mapping table, it is deleted from the ODS. |
| Resync | When a mapping is changed in Resource Preferences, a resync needs 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 | When any of the following changes in the Schools resource:
|
| None | Cascading Updates/Delete: When the course is deleted from Campus, all Ed-Fi Course Transcript records remain until a resync is complete. |
| Delete | When a Course is marked Inactive after dependent data has sent, all dependent data is deleted. |
| Dependent Resources | Course Offerings Sections Student Section Associations Staff Section Associations Student Section Attendance Events Grades Course Transcripts |
Scope Year Logic
This table describes scope year logic of this object.
| Logic |
|---|
| Courses report to the configured year to which they are aligned. |
| Data only sends for years that have valid configuration. |
Error Log
| Error | Possible Causes/How to fix |
|---|---|
409: Failed to delete courses resource. [message:The resource (or a subordinate entity of the resource) cannot be deleted because it is a dependency of the 'courseOffering' entity.] | There are still dependent resources in the Ed-Fi ODS so the course record cannot be deleted. Use the delete tool to remove any dependent data before the course can be removed. |
Resource Preferences
This table describes the Resource Preferences of this object.
| Data Element Label | Mapping Needed |
|---|---|
| State Code and Number | Course Identification System Descriptors |
| Course SCED Subject Area | Academic Subject Descriptors |
| Course Difficulty Level | Course Level Characteristic Types |
Identity Mapping Object Key
This table describes the Identity Mapping Object Key of this object.
| campusObjectType | Object Key Data Source |
|---|---|
| Course | courseID |
Event Queue Detail
This table describes the Event Queue Detail of this object.
| Campus Table | Ed-Fi Action | Fields |
|---|---|---|
| course | Post/Put/Delete | The primary table used for sending data for this resource. |
Object Data Elements
This table describes data elements sent within the Courses resource.
Data Element Label | Business Requirement and Rules | Mandatory, Conditional or Optional | Location |
|---|---|---|---|
| courseCode | A unique alphanumeric code assigned to a course. | M | Scheduling & Courses > Courses > Course Information > State Course Code course.ID |
| identificationCodes | An unordered collection of courseIdentificationCodes. This educational entity represents the organization of subject matter and related learning experiences provided for the instruction of students on a regular or systematic basis. See Array logic below. | M | Scheduling & Courses > Courses > Course Information > SCED Course Code |
| educationOrganizationReference | A reference to the related Education Organization resource. Courses are pre-loaded by the state and are all assigned to the State Agency ID: "1645". | M | |
| courseTitle | The descriptive name given to a course of study offered in a school or other institution or organization. In departmentalized classes at the elementary, secondary, and post-secondary levels (and for staff development activities), this refers to the name by which a course is identified (e.g., American History, English III). For elementary and other non-departmentalized classes, it refers to any portion of the instruction for which a grade or report is assigned (e.g., reading, composition, spelling, and language arts). Reports the Course Name. | Scheduling & Courses > Courses > Course Information > Name Course.name | |
| numberOfParts | The number of parts identified for a course. Reports the value selected in the SCED Sequence Part M field. When NULL, reports 1. | M | Scheduling & Courses > Courses > SCED Sequence (Part M) Course.sced SequenceMax |
| etag | A unique system-generated value that identifies the version of the resource. This field is optional, do not report. | O |
