Wisconsin Ed-Fi Data v3.3 - Courses

Tool Search: Ed-Fi

This educational entity represents the organization of subject matter and related learning experiences provided for the instruction of students on a regular or systematic basis. 

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Get

Wisconsin has pre-loaded courses so we do not post or delete courses.

  • No Trigger, this is a look-up as Courses are pre-loaded. We do a match on the State Course Code to see if the course exists in the ODS.
  • We do not send data for courses that are marked as Excluded or not marked as Active, Courses in a Calendar marked State Exclude or Calendar Exclude, or Courses in a Calendar marked Summer School.


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 Ed-Fi School Number changes.
  • School ID: If the State School Number changes and the Ed-Fi School Number is NULL
Delete/PostIf the State Code or Number changes.
Delete/Post

Cascading Updates/Delete:  If the natural key changes all dependent data will be deleted/reposted:

  • Course Transcripts


Scope Year Logic

This table describes scope year logic of this object.

Logic
Courses 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

This table describes the Identity Mapping Object Key of this object.

campusObjectTypeObject Key Data Source
CoursecourseID


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.


Object Data Elements

This table describes data elements sent within the Courses 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

courseCode 

A unique alphanumeric code assigned to a course.

  1. Report the Course ID for the course.
M

Scheduling> Course> Course ID

course.ID

identificationCodesAn unordered collection of courseIdentificationCodes. This educational entity represents the organization of subject matter and related learning experiences provided for the instruction of students on a regular or systematic basis.
  1. See Array logic below.
M

educationOrganization
Reference

A reference to the related Education Organization resource.



  1. Courses are pre-loaded by the state and are all assigned to the reporting District Number: "48856".
M System Administration> Resources> District Information district.number
academicSubjectDescriptorThe intended major subject area of the course. 
  1. Reports the Ed-Fi Code from the SCED SCED Subject Area.
  2. If NULL or Ed-Fi Value is blank, do not report.
OScheduling> Course> SCED Subject Area course.sced SubjectArea
careerPathwayDescriptor

The career cluster or pathway representing the career path of the Vocational/CTE concentrator.

  1. This field is optional, do not report.
O

competencyLevelsAn unordered collection of courseCompetencyLevels. This educational entity represents the organization of subject matter and related learning experiences provided for the instruction of students on a regular or systematic basis.
  1. This field is optional, do not report.
O

courseDefinedByDescriptor

Specifies whether the course was defined by the SEA, LEA, school or national organization.

  1. This field is optional, do not report.
O

courseDescriptionA description of the content standards and goals covered in the course. Reference may be made to state or national content standards. 
  1. This field is optional, do not report.
O

courseGPAApplicability
Descriptor
An indicator of whether or not this course being described is included in the computation of the student’s Grade Point Average, and if so, if it weighted differently from regular courses. ,
  1. This field is optional, do not report.
O

courseTitleThe descriptive name given to a course of study offered in a school or other institution or organization. In departmentalized classes at the elementary, secondary, and postsecondary levels (and for staff development activities), this refers to the name by which a course is identified (e.g., American History, English III). For elementary and other non-departmentalized classes, it refers to any portion of the instruction for which a grade or report is assigned (e.g., reading, composition, spelling, and language arts). 
  1. Reports the Course Name.
MScheduling> Course> Namecourse.name
dateCourseAdoptedThe date the district adopted the course.
  1. This field is optional, do not report.
O

highSchoolCourseR
equirement
An indication that this course credit is required for a high school diploma.
  1. This field is optional, do not report.
O

learningObjectivesAn unordered collection of courseLearningObjectives. This educational entity represents the organization of subject matter and related learning experiences provided for the instruction of students on a regular or systematic basis.
  1. This field is optional, do not report.
O

learningStandardsAn unordered collection of courseLearningStandards. This educational entity represents the organization of subject matter and related learning experiences provided for the instruction of students on a regular or systematic basis.
  1. This field is optional, do not report.
O

levelCharacteristicsAn unordered collection of courseLevelCharacteristics. This educational entity represents the organization of subject matter and related learning experiences provided for the instruction of students on a regular or systematic basis.
  1. See Array logic below.
O

maxCompletionsForCredit

Designates how many times the course may be taken with credit received by the student.

  1. This field is optional, do not report.
O

maximumAvailableCredit
Conversion
Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units.
  1. This field is optional, do not report.
O

maximumAvailableCreditsThe maximum amount of credit available to a student who successfully completes the course.
  1. This field is optional, do not report.
O

maximumAvailableCredit
TypeDescriptor

The type of credits or units of value awarded for the completion of a course.

  1. This field is optional, do not report.
O

minimumAvailableCredit
Conversion
Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units.
  1. This field is optional, do not report.
O

minimumAvailableCreditsThe minimum amount of credit available to a student who successfully completes the course.
  1. This field is optional, do not report.
O

minimumAvailableCredit
TypeDescriptor

The type of credits or units of value awarded for the completion of a course.

  1. This field is optional, do not report.
O

numberOfPartsThe number of parts identified for a course.
  1. Report the value selected in the SCED Sequence "Part m" field.
  2. If NULL, report '1'
MScheduling> Course> SCED Sequence (part m)course.sced SequenceMax
offeredGradeLevelsAn unordered collection of courseGradeLevels. This educational entity represents the organization of subject matter and related learning experiences provided for the instruction of students on a regular or systematic basis.
  1. This field is optional, do not report.
O

timeRequiredFor
Completion
The actual or estimated number of clock minutes required for class completion. This number is especially important for career and technical education classes and may represent (in minutes) the clock hour requirement of the class.
  1. This field is optional, do not report.
O

etagA unique system-generated value that identifies the version of the resource.
  1. This field is optional, do not report.
O

Arrays

Click here to expand...

Course Identification Code

Data Element Label

Business Requirement

Business Rules

M, C or O

Data Source GUI Path

Database Field

courseIdentificationSystemDescriptor

A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.
  1. Reports the mapped Ed-Fi Code for the identification code being reported.
M

assigningOrganizationIdentificationCode

The organization code or name assigning the staff Identification Code.
  1. This field is optional, do not report.
O

identificationCode

A unique number or alphanumeric code assigned to a space, room, site, building, individual, organization, program, or institution by a school, school system, a state, or other agency or entity.
  1. Reports the State Code if populated on Course and is mapped to an Ed-FI Code.
  2. Reports the Number if mapped to an Ed-Fi Code.
M

Scheduling> Course> State Code


and/or


Scheduling> Course> Number

course.statecode

or

course.number

Course Level Characteristics

Data Element Label

Business Requirement

Business Rules

M, C or O

Data Source GUI Path

Database Field

courseLevelCharacteristicDescriptor

Specification of the specific program or designation associated with the course. For example: Ap, IB, Dual Credit, CTE, etc.
  1. Reports the Ed-Fi Code from the Course Level Selected.
  2. If Ed-FI Code is NULL or field is blank, do not report.
MScheduling> Courses> Course Levelcourse.honorsCode