Indiana Ed-Fi Data v2.4/3.1 - Course Offerings

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.

ActionTrigger
Post

When a section with Section Placement is created and saved.

  • One (1) record will report per Course and Term Type combination.
  • Do not send if course is marked as Inactive.
  • Do not send records if the Calendar Exclude checkbox is checked.
  • Do not send a record if the School Exclude checkbox is checked.

  • Do not send a record if the course is marked as 'Exclude from State Reporting'.

Delete/Post
  • When the Local Course Number is changed.
  • If the Term Descriptor changes either via section placement or mapping override and a course offering already exists with non-matching Term Descriptors.
  • When there are two Sections with the same natural key and one is deleted, the other record will post with the remaining records data.
Put

When Course information is changed and saved.

  • Course Name
  • Course Number
Delete
  • When a section is deleted.
  • When a section schedule placement is removed and saved.

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
NoneIf a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send.
DeleteIf 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.
ResyncIf 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.
ResyncIf 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.
ResyncIf 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.

ActionTrigger
Delete/Post

If any of the following changes in the Schools resource:

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

If the Course Number changes.

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

If the natural key changes all dependent resources will delete/post.

Dependent ResourcesSections, Staff Section Associations, Student Section Associations

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.

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 Requirement

Business Rules

M, C or O

Location

idThe unique identifier of the resource.


M
localCourseCode 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.

MScheduling > Course > Number

course.number
courseReferenceA reference to the related Course resource.
Reports the fields that are part of the Natural Key for the Course resource.
  • See Array section below for Reference Array.
M
schoolReferenceA 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
sessionReferenceA 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.
  • See Array section for Reference Array below
M
courseLevelCharacteristicsThe 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
curriculumUsedAn 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
instructionalTimePlannedThe 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
localCourseTitleThe descriptive name given to a course of study offered in the school, if different from the Course Title.

Reports the Course Name.

OScheduling > Course > Name

course.name
localCourseCodeThe local course code for the course.Reports course NumberMScheduling > Course > Number

course.number
offeredGradeLevelsThe 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
courseEducationOrganization

IDOE owns the courses.  Must report state Ed Org ID

This is part of the course reference - see references below.

Reports state Ed Org ID
  • 1088000000
MHardcoded number
etagA unique system-generated value that identifies the version of the resource.

This is optional, does not report.

O


Arrays

Click here to expand...

Reference Array

Data Element Label

Business Requirement

Business Rules

M, C or O

Location


Database Field

CourseReference

The courseReference includes the following:

  1. EdOrgID
  2. courseCode (labeled 'Code' = State Code)

Report the following in this reference:

  1. EdOrgID = 1088000000 (State EdOrg)
  2. courseCode = stateCode (on course)
M
  1. EdOrgID is hardcoded.
  2. Scheduling > Course/Section> stateCode

course.stateCode


SchoolReference

The schoolReference includes the following:

  • SchoolID

Report the following in this reference:

  1. 10+District+School  i.e., 1012344321
  2. If Multiple Connections, report based on EdFi School ID override.
M

Concatenated value


district.Number

school.number




SessionReference

The sessionReference includes the following:

  1. schoolYear
  2. termDescriptor

Report the following in this reference:

  1. schoolYear = the current active year alligned with the current active connection
    • Reports as the end Year (YYYY)
  2. termDescriptor = the mapped descriptor values. See Descriptors below
MSystem Administration > Calendar > School Years > End Year

calendar.endYear



Types/Descriptors

Click here to expand...

Term Descriptors

CodeShort DescriptionNamespaceLong Description
Fall SemesterFall Semesterhttp://doe.in.gov/Descriptor/TermDescriptor.xmlFall Semester
First QuarterFirst Quarterhttp://doe.in.gov/Descriptor/TermDescriptor.xmlFirst Quarter
First TrimesterFirst Trimesterhttp://doe.in.gov/Descriptor/TermDescriptor.xmlFirst Trimester
Fourth QuarterFourth Quarterhttp://doe.in.gov/Descriptor/TermDescriptor.xmlFourth Quarter
MiniTermMiniTermhttp://doe.in.gov/Descriptor/TermDescriptor.xmlMiniTerm
OtherOtherhttp://doe.in.gov/Descriptor/TermDescriptor.xmlOther
Second QuarterSecond Quarterhttp://doe.in.gov/Descriptor/TermDescriptor.xmlSecond Quarter
Second TrimesterSecond Trimesterhttp://doe.in.gov/Descriptor/TermDescriptor.xmlSecond Trimester
Spring SemesterSpring Semesterhttp://doe.in.gov/Descriptor/TermDescriptor.xmlSpring Semester
Summer SemesterSummer Semesterhttp://doe.in.gov/Descriptor/TermDescriptor.xmlSummer Semester
Third QuarterThird Quarterhttp://doe.in.gov/Descriptor/TermDescriptor.xmlThird Quarter
Third TrimesterThird Trimesterhttp://doe.in.gov/Descriptor/TermDescriptor.xmlThird Trimester
Year RoundYear Roundhttp://doe.in.gov/Descriptor/TermDescriptor.xmlYear Round