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.
Action
Trigger
Post
When a section with Section Placement is created and saved.
1 record will report per Course and Term Type combination.
Do not send records if the Calendar Exclude check box is checked.
Do not send a record if the School Exclude checkbox is checked.
Delete/Post
When the Local Course Number is changed.
Delete/Post
If 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 Name
Delete
When a section is deleted.
Delete
When a section schedule placement is removed and saved.
Delete/Post
Delete if a 2nd Schedule Structure is added after 1st Calendar is sent.
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:
School ID: If the Ed-Fi School Number changes.
School ID: If the State School Number changes and the Ed-Fi School Number is NULL.
Delete/Post
If the Course Number changes.
Delete/Post
If the Session Name changes to which the Course Offering is aligned.
Delete/Post
If the natural key changes all dependent resources will delete/post.
This table describes scope year logic of this object.
Logic
Course Offerings will report to the configured year to which they are aligned.
Data will only send for years that have valid configuration.
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.
sectionplacement
Post/Put/Delete
The 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 Label
Business Requirement
Business Rules
M, C or O
Data Source GUI Path
Database
Field
id
The unique identifier of the resource.
M
localCourse Code
The local code assigned by the LEA or Campus that identifies the organization of subject matter and related learning experiences provided for the instruction of students.
Reports the Course Number from the Course.
M
Scheduling > Course > Number
course.number
course Reference
A reference to the related Course resource.
Reports the fields that are part of the Natural Key for the Course resource.
M
school Reference
A reference to the related School resource.
Reports the fields that are part of the Natural Key for the School resource.
M
session Reference
A reference to the related Session resource.
Reports the fields that are part of the Natural Key for the Session resource.
Term Descriptor will report based on section schedule placement of the sections of the course.
If Term Descriptor Override is checked and there is an existing mapping for the course, Term Descriptors will report based on the mappings per the section schedule placement of the sections of the course.
M
courseLevel Characteristics
The type of specific program or designation with which the course offering is associated (e.g., AP, IB, Dual Credit, CTE). This collection should only be populated if it differs from the Course Level Characteristics identified at the Course level.
This is optional, does not report.
O
curriculum Used
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
instructional TimePlanned
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
localCourse Title
The descriptive name given to a course of study offered in the school, if different from the Course Title.
Reports the Course Name.
O
Scheduling > Course > Name
course.name
offeredGrade Levels
The grade levels in which the course is offered. This collection should only be populated if it differs from the Offered Grade Levels identified at the Course level.
This is optional, does not report.
O
instruction Minutes PerTerm
Instruction minutes per term.
If the Section's "Period Minutes Override" field is <> NULL, multiply that value by the total number of days the section is scheduled in the term and report that value.
If the Section's "Period Minutes Override" field is NULL, but the Course's "Period Minutes" field <> NULL, multiply that value by the total number of days the section is scheduled in the term and report that value.
If the Course's "Period Minutes" field is NULL, sum and report the number of instructional minutes (minus lunch minutes if within any applicable period) for each period this course/section is scheduled for, for all the days it is scheduled in the term and report that value.
An unordered collection of courseOfferingInstructionalApproaches. Instructional approach as implemented for the course offering. General purpose but initially implemented for Early Education.
See Array logic below.
siteBased Initiatives
An unordered collection of courseOfferingSiteBasedInitiatives. Site-based initiative as implemented for the course offering. General purpose but initially implemented for Early Education.
See Array logic below.
etag
A unique system-generated value that identifies the version of the resource.
This is optional, does not report.
O
Arrays
Instructional Approaches
Data Element Label
Business Requirement
Business Rules
M, C or O
Data Source
GUI Path
Database Field
instructionalApproach Descriptor
Instructional approach.
Report the mapped value, if it exists.
If no mapping exists, or no value is selected in the droplist, do not report the array.
M
Course > Inst. Approach and Implementation
Course.eeInstApproachAndImp
implementationStatus Descriptor
Status of implementation of the instructional approach.
Report the mapped value, if it exists.
If no mapping exists, or no value is selected in the droplist, do not report.
C
Course > Curriculum and Implementation
Course.eeCurrAndImp
Site Based Iniatives
Data Element Label
Business Requirement
Business Rules
M, C or O
Data Source
GUI Path
Database Field
siteBasedInitiativeDescriptor
Site-based initiative.
Report the mapped value, if it exists.
If no mapping exists, or no value is selected in the droplist, do not report the array.
M
Course > Site-Based Initiative and Impl.
Course.eeSiteBasedInitAndImp
implementationStatusDescriptor
Status of implementation of the site-based initiative.
Report the mapped value, if it exists.
If no mapping exists, or no value is selected in the droplist, do not report.
C
Course > Curriculum and Implementation
Course.eeCurrAndImp
Type/Descriptors
Instructional Approach Descriptors : Course.eeInstApproachAndImp "Inst. Approach and Implementation"
Campus Attribute Code
EdFi Descriptor code
EdFi Descriptor description
All codes that begin with 'ABA...'
ABA
Applied Behavior Analysis
All codes that begin with 'DR...'
DR
Dialogic Reading
All codes that begin with 'NONE...'
NONE
No organized instructional approach used.
All codes that begin with 'OTHER...'
OTHER
Use OTHER when the EE Inst. Approach is not listed.
All codes that begin with 'ISB...'
ISB
Interactive Shared Book Reading
All codes that begin with 'TD...'
TD
Transdisciplinary Approach (Only used with Program = Special Ed)
All codes that begin with 'PAT...'
PAT
Phonological Awareness Training
All codes that begin with 'R...'
R
RTI
All codes that begin with 'TE...'
TE
Teach
All codes that begin with 'LI...'
LI
Letter Identification
All codes that begin with 'PSP...'
PSP
Primary Service Provider
All codes that begin with 'SBR...'
SBR
Shared Book Reading
All codes that begin with 'L...'
L
Leap
Implementation Status Descriptors : Course.eeInstApproachAndImp "Inst. Approach and Implementation"
Campus Attribute Code
EdFi Descriptor code
EdFi Descriptor description
All codes that end with '...CBEG'
CBEG
Beginning - Centers of Excellence ONLY
All codes that end with '...CEXP'
CEXP
Expanding - Centers of Excellence ONLY
All codes that end with '...CMNT'
CMNT
Maintaining - Centers of Excellence ONLY
All codes that end with '...FULL'
FULL
Full Implementation
All codes that end with '...X'
X
Does not apply
All codes that end with '...YR1'
YR1
Initial Implementation Year 1
All codes that end with '...YR2'
YR2
Initial Implementation Year 2
Site Based Initiative Descriptors : Course.eeSiteBasedInitAndImp "Site-Based Initiative and Impl."
Campus Attribute Code
EdFi Descriptor code
EdFi Descriptor description
All codes that begin with 'CLASS...'
CLASS
The Classroom Assessment Scoring System
All codes that begin with 'FGRBI...'
FGRBI
Family Guided Routines Based Interventions
All codes that begin with 'MMC...'
MMC
Minnesota Math Corp
All codes that begin with 'MRC...'
MRC
Minnesota Reading Corp
All codes that begin with 'NONE...'
NONE
No site-base initiative used
All codes that begin with 'NW...'
NW
Numbers Work
All codes that begin with 'PBIS...'
PBIS
Positive Behavior Intervention and Support
All codes that begin with 'PECC...'
PECC
Parent Education Core Curriculum
All codes that begin with 'PYRAMID...'
PYRAMID
Pyramid Model
All codes that begin with 'RPPM...'
RPPM
Relationship-based Primary Provider Model
Implementation Status Descriptors : Course.eeSiteBasedInitAndImp "Site-Based Initiative and Impl."
