Course Offerings (Kansas v3.6)

Tool Search: Ed-Fi

This entity represents an offering of a course by school during a session, representing the course catalog of available courses.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When a section with Section Placement is created and saved.

  • One (1) record reports per Course and Term Type combination.
  • A course MUST have a State Code present to report.
  • Does not send when the course is NOT marked as Active.
  • Does not send records when the Calendar Exclude checkbox is marked.
  • Does not send a record when the School Exclude checkbox is marked.
  • Does not post a record when the course is marked as Exclude from State Reporting.
Delete/Post

When the Course Number is changed.

Delete/Post

When the Term Descriptor changes either via section placement or mapping override and a course offering already exists with non-matching Term Descriptors.

Put

When Course information is changed and saved.

  • Course ID (New Course)
  • Course Code
  • Course Title
  • Course Level Characteristic Descriptor
Delete

When a section is deleted.


Delete

When a section schedule placement is removed and saved.

Delete/PostWhen there are two Sections with the same natural key and 1 is deleted, the other record posts with the remaining records data.

 

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.

ActionTrigger
NoneWhen a resource is toggled to OFF after data has sent, all sent data remains in the ODS but no new data sends.
DeleteWhen 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.
ResyncWhen 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.
ResyncWhen 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.
ResyncWhen a mapping is changed in Resource Preferences, a resync is needed 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.

ActionTrigger
Delete/Post

When any of the following changes in the Schools resource:

  • When the School Number/Ed-Fi School Number changes, a delete/post occurs with the cascading deletes from the School ID Change triggers.

When the Course Number changes.


When the Session Name changes to which the Course Offering is aligned.


When the natural key changes all dependent resources are deleted/posted.

Dependent ResourcesSections
Staff Section Associations
Student Section Associations

 

Scope Year Logic

This table describes scope year logic of this object.

Logic
Course Offerings report to the configured year to which they are aligned.
Data only sends for years that have valid configuration.

Identity Mapping Object Key

campusObjectTypeObject Key Data Source
SectionsectionID-termID

Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus TableEd-Fi ActionFields
coursePost/Put/DeleteThe primary table used for sending data for this resource.
sectionplacementPost/Put/DeleteThe primary table used for sending data for this resource.

  

Object Data Elements

This table describes data elements sent within the Course Offerings resource. 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 Requirements and Rules

Mandatory, Conditional or Ooptional

Location

id

The unique identifier of the resource

M
localCourseCode 

The local code assigned by the he school or district to  identify an individual course.


Reports the Course Number value.


MScheduling & Courses > Courses > Course Information > Course Number

Course.number
courseReference
A reference to the related Course resource.

See Array section below for Reference Array.

M
schoolReference
A reference to the related School resource.

Reports the fields that are part of the Natural Key for the School resource. 
  • See Array section below for Reference Array.
M
sessionReference
A reference to the related Session resource.

Reports the fields that are part of the Natural Key for the Session resource.
  • Term Descriptor reports based on section schedule placement of the sections of the course.
  • When Term Descriptor Override is marked and there is an existing mapping for the course, Term Descriptors report based on the mappings per the section schedule placement of the sections of the course.
M
courseLevelCharacteristics

Course level value for the course.


Reports the mapped Ed-Fi Course value of the Course Level selected. 


When blank, does not report.

MScheduling & Courses > Course Information > Custom Data Elements > Course Level

Course.courseLevel
curriculumUsed

An unordered collection of courseOfferingCurriculumUseds. This entity represents an offering of a course by school during a session, representing the course catalog of available courses.


This is optional, does not report.

O
instructionalTimePlanned

The planned total number of clock minutes of instruction for this course offering. Generally, this should be at least as many minutes as is required for completion by the related state- or district-defined Course.


This is optional, does not report.

O
localCourseTitle

The descriptive name given to a course of study offered in the school, when different from the Course Title.


Reports the Course Name.

OCourse Information > Name

Course.name
offeredGradeLevels

The grade levels in which the course is offered.


For each Course State Code, reports the Ed-Fi Grade Level Descriptor associated with the selected Grade Level. 

OCourse Information > Grade Level

Course.grade
courseCreditsReports the credits value for the Course.

Reports the sum of the credit value for all Grading Tasks marked as state-reported, rounded to the nearest hundredth decimal position.
OScheduling & Courses > Courses > Course Grading Tasks > Credit

GradingTaskCredit.credit
courseSequenceReports the course sequence from the location indicated.OScheduling & Courses > Courses > Course Information > Custom Data Elements > Sequence

Sequence.course
totalCourseSequenceReports the total course sequence from the location indicated.OScheduling & Courses > Courses > Course Information > Custom Data Elements > Sequence Total

Course.sequenceTotal
courseDeliveryTypeDescriptorReports the mapped Ed-Fi code value of the Delevery Type selected.

When blank, does not report.
OScheduling & Courses > Courses > Course Information > Custom Data Elements > Delivery Type

Course.deliveryType
courseProgramTypeDescriptorReports the mapped Ed-Fi code value of the Targeted Program selected.

When blank, does not report.
OScheduling & Courses > Courses > Course Information > Custom Data Elements > Targeted Program

Course.targetedProgram

     

Arrays

Click here to expand...

Reference Arrays

Data Element LabelBusiness Requirements and RulesMandatory, Conditional or OptionalLocation
courseReference

A reference to the related Course resource

  • Course Code is a combination of the state subject area code and the state course identifier.
  • Education Organization ID is always the KS state education organization id value of 100000000.

Matches to the State Ed-Fi Course which is loaded into the ODS by the state. Report as follows: 

  • courseCode = course.stateCode
  • educationOrganizationID = 100000000 

This is a hardcoded value for the KS state education organization ID.   

MScheduling & Courses > Courses > Course Information > State Code

Course.stateCode

Type Descriptors

Click here to expand...

Course Delivery Type Descriptor

Code ValueDescriptionName SpaceShort Description
DDistance Learninguri://ksde.org/CourseDeliveryTypeDescriptorDistance Learning
GGeneraluri://ksde.org/CourseDeliveryTypeDescriptorGeneral
MSelf-contained Multiuri://ksde.org/CourseDeliveryTypeDescriptorSelf-contained Multi
SSelf-contained Singleuri://ksde.org/CourseDeliveryTypeDescriptorSelf-contained Single
VVirtualuri://ksde.org/CourseDeliveryTypeDescriptorVirtual

Course Program Type Descriptor

Code ValueDescriptionName SpaceShort Description
AAt-Riskuri://ksde.org/CourseProgramTypeDescriptorAt-Risk
EESOLuri://ksde.org/CourseProgramTypeDescriptorESOL
GGeneraluri://ksde.org/CourseProgramTypeDescriptorGeneral
MMigranturi://ksde.org/CourseProgramTypeDescriptorMigrant
SSpecial Educationuri://ksde.org/CourseProgramTypeDescriptorSpecial Education

College Career Type Descriptor

Code ValueDescriptionName SpaceShort Description
CCTE Dual credit funded IN an approved pathway (HS Only)/Not Excel in CTE (ouri://ksde.org/CollegeCareerTypeDescriptorCTE Dual credit funded IN an approved pathway (HS Only)/Not Excel in CTE (o
DDual credit NOT funded in a college programuri://ksde.org/CollegeCareerTypeDescriptorDual credit NOT funded in a college program
FCTE credit/funded course IN an approved program/pathway (Technical/Applicaturi://ksde.org/CollegeCareerTypeDescriptorCTE credit/funded course IN an approved program/pathway (Technical/Applicat
LCTE Dual credit IN an approved program/pathway/Excel in CTE only (old SB155uri://ksde.org/CollegeCareerTypeDescriptorCTE Dual credit IN an approved program/pathway/Excel in CTE only (old SB155
NNot dual credit/Regular courseuri://ksde.org/CollegeCareerTypeDescriptorNot dual credit/Regular course
RCTE Dual credit NOT part of an approved program/pathway/Excel in CTE only (uri://ksde.org/CollegeCareerTypeDescriptorCTE Dual credit NOT part of an approved program/pathway/Excel in CTE only (
TCTE course NOT funded OR part of an approved Pathway (Local Program)uri://ksde.org/CollegeCareerTypeDescriptorCTE course NOT funded OR part of an approved Pathway (Local Program)
XCTE credit/not funded IN an approved program/pathway (Introductory level)uri://ksde.org/CollegeCareerTypeDescriptorCTE credit/not funded IN an approved program/pathway (Introductory level)

Course Level Characteristic Descriptor

Code ValueDescriptionName SpaceShort Description
BBasic/Remedialuri://ksde.org/CourseLevelCharacteristicDescriptorBasic/Remedial
EEnriched/Advanceduri://ksde.org/CourseLevelCharacteristicDescriptorEnriched/Advanced
GGeneraluri://ksde.org/CourseLevelCharacteristicDescriptorGeneral
HHonorsuri://ksde.org/CourseLevelCharacteristicDescriptorHonors
XNo Specified Rigoruri://ksde.org/CourseLevelCharacteristicDescriptorNo Specified Rigor

Grade Level Descriptor

Code ValueDescriptionName SpaceShort Description
Infant/toddlerInfant/toddleruri://ed-fi.org/GradeLevelDescriptorInfant/toddler
KindergartenKindergartenuri://ed-fi.org/GradeLevelDescriptorKindergarten
First gradeFirst gradeuri://ed-fi.org/GradeLevelDescriptorFirst grade
Second gradeSecond gradeuri://ed-fi.org/GradeLevelDescriptorSecond grade
Third gradeThird gradeuri://ed-fi.org/GradeLevelDescriptorThird grade
Fourth gradeFourth gradeuri://ed-fi.org/GradeLevelDescriptorFourth grade
Fifth gradeFifth gradeuri://ed-fi.org/GradeLevelDescriptorFifth grade
Sixth gradeSixth gradeuri://ed-fi.org/GradeLevelDescriptorSixth grade
Seventh gradeSeventh gradeuri://ed-fi.org/GradeLevelDescriptorSeventh grade
Eighth gradeEighth gradeuri://ed-fi.org/GradeLevelDescriptorEighth grade
Ninth gradeNinth gradeuri://ed-fi.org/GradeLevelDescriptorNinth grade
Tenth gradeTenth gradeuri://ed-fi.org/GradeLevelDescriptorTenth grade
Eleventh gradeEleventh gradeuri://ed-fi.org/GradeLevelDescriptorEleventh grade
Twelfth gradeTwelfth gradeuri://ed-fi.org/GradeLevelDescriptorTwelfth grade
UngradedUngradeduri://ed-fi.org/GradeLevelDescriptorUngraded
PreschoolPreschooluri://ed-fi.org/GradeLevelDescriptorPreschool