Minnesota Ed-Fi Data v3.1 - Course Offerings
Last Modified on 10/22/2022 10:26 am CDT
Classic View: System Administration > Ed-Fi
Search Terms: 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.
Action | Trigger |
---|
Post | When a section with Section Placement is created and saved. |
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. |
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. |
Dependent Resources | Sections, Staff Section Associations, Student Section Associations, Student Section Attendance Events, Grades |
Scope Year Logic
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.
| C | Course > Section > Period Minutes Override
Course > Period Minutes
Course > Section > Section Schedule Placement | Course.periodMinutes / CustomCourse.value
Section.periodMinutesOverride / CustomSection.value |
instructional Approaches | 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
Click here to expand...
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
Click here to expand...
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."
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 |