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 |
|---|---|
| Post | When a Course is created and saved.
Information related to Early Education programs:
|
| Put | When Course information not part of the natural key is changed and saved.
|
| Delete | When a Course is deleted and there are no other courses with the same number in the same school and year.
|
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 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:
|
| Delete/Post | Cascading Updates/Delete: If the course is deleted from Campus.
|
| Delete | If a Course is marked Inactive after dependent data has sent, all dependent data will be 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 will report to the configured year to which they are aligned. |
| 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 |
|---|---|
| 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. |
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. |
Object Data Elements
This table describes data elements sent within the Courses resource.
Data Element Label | Business Requirement | Business Rules | M, C or O | Location | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | The unique identifier of the resource. | M | ||||||||||||||||||||||
| courseCode | A unique alphanumeric code assigned to a course. |
| M | Scheduling & Courses > Courses > Course Information > Course ID Scheduling & Courses > Courses > Course Information > College Course Code course.ID Course.collegeCourseCode | ||||||||||||||||||||
| identification Codes | 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 | |||||||||||||||||||||
| education Organization Reference | The identifier assigned to an education organization. |
ttddddmmm where: dddd = district number, left zero filled mmm = 000 for all organizations reported in Ed-Fi
3. When reporting College Course - Report course.collegeCode | M | School & District Settings > Schools > School Information > school record > Ed-Fi School ID tt: School & district Settings > District > District Information > district record > Type dddd: School & district Settings > District > District Information > district record > State District Number Scheduling> Course> Custom Data Elements > College Course Code School.entityID District.type District.number Course.collegeCode | ||||||||||||||||||||
| academic Subject Descriptor | N/A | Do not report. | Scheduling & Courses > Courses > Course Information > SCED Subject Area Course.scedSubjectArea | |||||||||||||||||||||
| careerPathway Descriptor | The career cluster or pathway representing the career path of the Vocational/CTE concentrator. | This field is optional, do not report. | O | |||||||||||||||||||||
| competency Levels | An unordered collection of courseCompetencyLevels. 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. | This field is optional, do not report. | O | |||||||||||||||||||||
| courseDefined ByDescriptor | Specifies whether the course was defined by the SEA, LEA, school or national organization. |
| M | |||||||||||||||||||||
| course Description | A description of the content standards and goals covered in the course. Reference may be made to state or national content standards. NEDM: Course Description. |
| C | Scheduling & Courses > Courses > Course Information > Description Course.Description | ||||||||||||||||||||
| courseGPA Applicability Descriptor | An indicator of whether or not this course being described is included in the computation of the student’s Grade Point Average, and if so, if it weighted differently from regular courses. | This field is optional, do not report. | O | |||||||||||||||||||||
| 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 postsecondary 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. | M | Scheduling & Courses > Courses > Course Information > Name course. name | ||||||||||||||||||||
| dateCourse Adopted | The date the district adopted the course. | This field is optional, do not report. | O | |||||||||||||||||||||
| highSchool Course Requirement | An indication that this course credit is required for a high school diploma. |
| C | Scheduling & Courses > Courses > Course Information > High School Credit Course.secondary Credit | ||||||||||||||||||||
| learning Objectives | An unordered collection of courseLearningObjectives. 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. | This field is optional, do not report. | O | |||||||||||||||||||||
| learning Standards > learningStandard Reference | learningStandardId An unordered collection of courseLearningStandards. Learning Standard(s) to be taught by the course. The identifier for the specific learning standard (e.g., 111.15.3.1.A). |
| C | Scheduling & Courses > Courses > Course Information > Standards > Standards Alignment Grading & Standards > Standards Setup > Standards Bank > Record > Standard Editor > State Reported Grading & Standards > Standards Setup > Standards Bank > Record > Standard Editor > Final Grading & Standards > Standards Setup > Standards Bank > Record > Standard Editor > Code | ||||||||||||||||||||
| level Characteristics | An unordered collection of courseLevelCharacteristics. 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. | If any Campus code(s)/value(s) identified in the chart below exists in the database, report the related descriptor code(s):
| C | Scheduling & Courses > Courses > Course Information > End of Course Indicator Scheduling & Courses > Courses > Course Information > EE Adult Basic Ed. Indicator Scheduling & Courses > Courses > Course Information > EE State/Federal Program Indicator | ||||||||||||||||||||
| maxCompletions ForCredit | Designates how many times the course may be taken with credit received by the student. | This field is optional, do not report. | O | |||||||||||||||||||||
| maximumAvailable CreditConversion | Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units. | This field is optional, do not report. | O | |||||||||||||||||||||
| maximumAvailable Credits | The maximum amount of credit available to a student who successfully completes the course. |
| C | Scheduling & Courses > Courses > Course Information > College Course Credit Course.collegeCourse Credit CustomCourse.value | ||||||||||||||||||||
| maximumAvailable CreditType Descriptor | The type of credits or units of value awarded for the completion of a course. | This field is optional, do not report. | O | |||||||||||||||||||||
| minimumAvailable CreditConversion | Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units. | This field is optional, do not report. | O | |||||||||||||||||||||
| minimumAvailable Credits | The minimum amount of credit available to a student who successfully completes the course. | This field is optional, do not report. | O | |||||||||||||||||||||
| minimumAvailable CreditType Descriptor | The type of credits or units of value awarded for the completion of a course. | This field is optional, do not report. | O | |||||||||||||||||||||
| numberOfParts | The number of parts identified for a course. gradeLevelDescriptor An unordered collection of courseOfferedGradeLevels. The grade levels in which the course is offered. |
| M | Scheduling & Courses > Courses > Course Information > NCES Data > Sequence Number part m course.scedSequence Max | ||||||||||||||||||||
| offeredGrade Levels | gradeLevelDescriptor An unordered collection of courseOfferedGradeLevels. The grade levels in which the course is offered. | Does not report. Set on preloaded Course by the state in ODS. Does not report. | ||||||||||||||||||||||
| timeRequiredFor Completion | The actual or estimated number of clock minutes required for class completion. This number is especially important for career and technical education classes and may represent (in minutes) the clock hour requirement of the class. gradeLevelDescriptor An unordered collection of courseOfferedGradeLevels. The grade levels in which the course is offered. | This field is optional, do not report. | O | |||||||||||||||||||||
| careerCluster Descriptor | Career cluster defines the industry or occupational focus for a career pathways program, plan of study, or course. | Does not report. Set on preloaded Course by the state in ODS. Does not report. | ||||||||||||||||||||||
| earlyEducation CourseLocation Descriptor | Classification of instruction site for Early Education. E.g., child’s home or care center. | Report the mapped value.
| C | Scheduling & Courses > Courses > Course Information > Instruction Method / EE Location Course.teaching Method | ||||||||||||||||||||
| standard Addressed Descriptor | Locality of entity who’s learning standard is addressed by this course. E.g., State, Federal, or Local. | Report the mapped value
Do not report for College Courses. | C | Scheduling & Courses > Courses > Course Information > Standard Addressed Course.standardAddressed | ||||||||||||||||||||
| sequenceLimit | The upper limit of this course within a sequence. E.g., (1 of N) |
| M | Scheduling & Courses > Courses > Course Information > NCES Data > Sequence Number part n Course.scedSequence Num | ||||||||||||||||||||
| assessmentTools | assessmentToolDescriptor: Assessment tool. implementationStatusDescriptor: Status of implementation of the assessment tool. | Report the mapped value.
| C | Scheduling & Courses > Courses > Course Information > Assessment Tool and Implementation Course.eeAssessment Tool And ImpCourse.eeCurr AndImp / Custom Course.value | ||||||||||||||||||||
| curriculumUseds | An unordered collection of courseCurriculumUseds. Curriculum as implemented for the course. General purpose but initially implemented for Early Education.
| Report the mapped value.
| C | Scheduling & Courses > Courses > Course Information > Early Education Fields > Curriculum and Implementation Course.eeCurr AndImp / Custom Course.value | ||||||||||||||||||||
| levelTypes | An unordered collection of courseLevelTypes. The ‘type level’ of which the course is associated. E.g, Advanced, Articulated, Basic, Dual, General, No credit, Occupational courseLevelTypeDescriptor: The ‘type level’ of which the course is associated. E.g, Advanced, Articulated, Basic, Dual, General, No credit, Occupational | Report the mapped value.
| C | Scheduling & Courses > Courses > Course Information > SCED Course Level Course.scedCourseLevel | ||||||||||||||||||||
| etag | A unique system-generated value that identifies the version of the resource. | This field is optional, do not report. | O |
Arrays
Type/Descriptor
Resource Preferences Continued
The Ed-Fi Configuration tool is used to establish Ed-Fi data resources.
The following describes how to set the resource preferences for the Courses resource. If the Configure or Edit buttons 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.
Select the appropriate Ed-Fi Code for the Academic Subject Descriptors.
Any item not mapped will not report to Ed-Fi.Course Assessment Tool and Implementation Attribute Dictionary System Settings > Custom Data and Links > Core Attribute Dictionary > Courses > Assessment Tool and Implementation UI Location Scheduling & Courses > Courses > Course Information > Assessment Tool and Implementation 
Select the appropriate Ed-Fi Code for the Career Cluster Descriptors.
Course SCED Subject Area Attribute Dictionary System Settings > Custom Data and Links > Core Attribute Dictionary > Courses > SCED Subject Area UI Location Scheduling & Courses > Courses > Course Information > Course > SCED Subject Area 
Select the appropriate Ed-Fi Code for the Course Level Type Descriptors.
Course Secondary Course Level Attribute Dictionary System Settings > Custom Data and Links > Core Attribute Dictionary > Courses > Secondary Course Level UI Location Scheduling & Courses > Courses > Course Information > Course > Secondary Course Level 
- Select the appropriate Ed-Fi Code for the Curriculum Used Descriptors.
Course Curriculum and Implementation Attribute Dictionary System Settings > Custom Data and Links > Core Attribute Dictionary > Courses > Difficulty Level UI Location Scheduling & Courses > Courses > Course Information > Course > Early Education Fields > Curriculum and Implementation 
- Select the appropriate Ed-Fi Code for the Early Education Course Location Descriptors.
Course Instruction Method / EE Location Attribute Dictionary System Settings > Custom Data and Links > Core Attribute Dictionary > Courses > Instruction Method / EE Location UI Location Scheduling & Courses > Courses > Course Information > Course > Instruction Method / EE Location 
- Select the appropriate Ed-Fi Code for the Implementation Status Descriptors.
Course Curriculum and Implementation Attribute Dictionary System Settings > Custom Data and Links > Core Attribute Dictionary > Course > Curriculum and Implementation UI Location Scheduling & Courses > Courses > Course Information > Course > Curriculum and Implementation 
- Select the appropriate Ed-Fi Code for the Standard Addressed Descriptors.
Course EE State/Federal Program Indicator Attribute Dictionary System Settings > Custom Data and Links > Core Attribute Dictionary > Courses > Standard Addressed UI Location Scheduling & Courses > Courses > Course Information > Course > Standard Addressed 
Click Save
