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.
| Action | Trigger |
|---|---|
| Get | Wisconsin has pre-loaded courses so we do not post or delete courses.
|
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:
|
| Delete/Post | If the State Code or Number changes. |
| Delete/Post | Cascading Updates/Delete: If the natural key changes all dependent data will be deleted/reposted:
|
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.
| campusObjectType | Object Key Data Source |
|---|---|
| Course | courseID |
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. |
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 |
|---|---|---|---|---|---|
| id | The unique identifier of the resource. | M | |||
| courseCode | A unique alphanumeric code assigned to a course. | Report the Course ID for the course. | M | Scheduling> Course> Course ID | course.ID |
| identificationCodes | An 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. | See Array logic below. | M | ||
| educationOrganization Reference | A reference to the related Education Organization resource. | 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 |
| academicSubjectDescriptor | The intended major subject area of the course. |
| O | Scheduling> Course> SCED Subject Area | course.sced SubjectArea |
| careerPathwayDescriptor | The career cluster or pathway representing the career path of the Vocational/CTE concentrator. | This field is optional, do not report. | O | ||
| competencyLevels | An 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. | This field is optional, do not report. | O | ||
| courseDefinedByDescriptor | Specifies whether the course was defined by the SEA, LEA, school or national organization. | This field is optional, do not report. | O | ||
| courseDescription | A description of the content standards and goals covered in the course. Reference may be made to state or national content standards. | 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. , | This field is optional, do not report. | O | ||
| courseTitle | The 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). | Reports the Course Name. | M | Scheduling> Course> Name | course.name |
| dateCourseAdopted | The date the district adopted the course. | This field is optional, do not report. | O | ||
| highSchoolCourseR equirement | An indication that this course credit is required for a high school diploma. | This field is optional, do not report. | O | ||
| learningObjectives | An 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. | This field is optional, do not report. | O | ||
| learningStandards | An 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. | This field is optional, do not report. | O | ||
| levelCharacteristics | An 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. | See Array logic below. | O | ||
| maxCompletionsForCredit | Designates how many times the course may be taken with credit received by the student. | 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. | This field is optional, do not report. | O | ||
| maximumAvailableCredits | The maximum amount of credit available to a student who successfully completes the course. | 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. | 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. | This field is optional, do not report. | O | ||
| minimumAvailableCredits | The minimum amount of credit available to a student who successfully completes the course. | 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. | This field is optional, do not report. | O | ||
| numberOfParts | The number of parts identified for a course. |
| M | Scheduling> Course> SCED Sequence (part m) | course.sced SequenceMax |
| offeredGradeLevels | An 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. | 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. | This field is optional, do not report. | O | ||
| etag | A unique system-generated value that identifies the version of the resource. | This field is optional, do not report. | O |
