Wisconsin Ed-Fi Data v3.1 - Course Offerings

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 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 check box is checked.
  • Do not send a record if the School Exclude checkbox is checked.
  • Do not send a record if the Calendar is marked Summer School.
  • Do not send a record if the State Course Code is NULL.
  • Do not send a record if the Course is marked Exclude.
  • If Ed-Fi Configuration Profile = Choice OR Choice + Private Opt In, do not send a record.
Delete/PostWhen the Local Course Number is changed.
Delete/PostIf 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
DeleteWhen a section is deleted.
DeleteWhen 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 will post 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
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:

  • 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/PostIf the Course Number changes.
Delete/PostIf the Session Name changes that the Course Offering is aligned to.
Delete/PostIf the  natural key changes all dependent resources will delete/post.
Dependent ResourcesSections, 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 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.

Error Log

This table describes scope year logic of this object.

ErrorPossible Causes/How to Fix

Error: No match found State Course code: AAAAA sent for Course BBBB Section CC.

*Where AAAAA is the State Course code submitted, BBBB is the local Course Number, and CC is the Section of the course.

The State Course Code is not a valid code.


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

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. 
  1. Reports the Course Number from the Course.
MScheduling > Course > Numbercourse.number
courseReferenceA reference to the related Course resource.
  1. Report from the State Course Code for code.
  2. If State Course Code is NULL, do not process and remove from the Ed-Fi Queue.
  3. Otherwise, match to the State Ed-Fi Course.
  4. Report the fields that are part of the Natural Key for the matching Course resource.
  5. If no match is found, report an error in the error log with the following message:
    • Error: No match found State Course code: AAAAA sent for Course BBBB Section CC.
    • Where AAAAA is the State Course code submitted, BBBB is the local Course Number, and CC is the Section of the course.
MScheduling > Course > State Course Code
schoolReferenceA reference to the related School resource.
  1. Reports the fields that are part of the Natural Key for the School resource.


M

sessionReferenceA reference to the related Session resource.
  1. 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 mapping.
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.
  1. 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.
  1. 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.,
  1. This is optional, does not report.
O

localCourseTitleThe descriptive name given to a course of study offered in the school, if different from the CourseTitle.
  1. Reports the Course Name.
OScheduling > Course > Namecourse.name
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.
  1. This is optional, does not report.
O

careerPathways (wi_courseOfferingCareerPathway)If a course is a Career Technical Education then submit the career cluster or pathway representing the career path of the course offered.
  1. Report the Ed-Fi value for Cluster/ Career Program Pathway(s) on the Course for careerPathwayType.
  2. If there are multiples, report all.
  3. If the field is blank, do not report this element.
CScheduling > Course > Custom Data Elements > Cluster/ Career Program Pathway
etagA unique system-generated value that identifies the version of the resource.
  1. This is optional, does not report.
O

Type/Descriptors

Click here to expand...

Career Pathway Descriptors

CodeDescription
1: Agriculture, Food and Natural ResourcesAgriculture, Food and Natural Resources
2: Architecture and ConstructionArchitecture and Construction
3: Arts, A/V Technology and CommunicationsArts, A/V Technology and Communications
4: Business, Management and AdministrationBusiness, Management and Administration
5: Education and TrainingEducation and Training
6: FinanceFinance
7: Government and Public AdministrationGovernment and Public Administration
8: Health ScienceHealth Science
9: Hospitality and TourismHospitality and Tourism
10: Human ServicesHuman Services
11: Information TechnologyInformation Technology
12: Law, Public Safety, Corrections and SecurityLaw, Public Safety, Corrections and Security
13: ManufacturingManufacturing
14: Marketing, Sales and ServiceMarketing, Sales and Service
15: Science, Technology, Engineering and MathematicsScience, Technology, Engineering and Mathematics
16: Transportation, Distribution and LogisticsTransportation, Distribution and Logistics