Classic View: System Administration > Data Utilities > SIF
Search Term: SIF
This object is for course information.
Object Triggering
| Event Type | Requirement |
|---|---|
| Add | A Course is created with the following:
Add when checkbox is changed to Active on Course. |
| Delete | A reported Course is deleted. When Active checkbox is unchecked Or State Exclude is checked on Course. |
| Change | A change and save is made on a reported Course. When Grading Task Credit change. |
Object Population and Business Rules
| Requirement |
|---|
| Does not report for any Course belonging to a Calendar with "Exclude from SIF Exchange" = Checked. |
| Course must have "Active" = Checked to report. |
| Course must not have "State Exclude" = Checked to report. |
Object Data Elements
| Data Element Label | Description | Business Rules | Data Source GUI Path | Database Field | M, C or O |
| @RefId | The Id (GUID) that uniquely identifies the school course. | The course ID | Course.courseId | M | |
| @SchoolInfoRefId | The Id (GUID) that identifies the school where the course is offered. | The School ID | School.schoolId | M | |
| @SchoolYear | School year for which the information is applicable, expressed as the four-digit year in which the school year ends | The end year of the calendar. | calendar.endYear | M | |
| CourseCode | School-defined local code for the course. | Course.number | M | ||
| StateCourseCode | State-defined standard course code used to report information about courses. | When State Code is null, this element is not reported. | course.stateCode | O | |
| DistrictCourseCode | The corresponding district course code. | Course.number | O | ||
| SubjectAreaList | Subject matter areas. | Requires a SCED Subject Area (Course.scedSubjectArea) is entered. | O | ||
| SubjectAreaList/ SubjectArea | Subject matter. | MR | |||
| SubjectAreaList/ SubjectArea/Code | The subject area code (i.e. the first two digits of the course classification code) | 1. Report the SIF mapped code for the selection in (Scheduling>Courses>Course>NCES data>SCED Subject Area). | Course.scedSubjectArea | M | |
| 2. When no Subject Area is selected, report based on the SIF mapping to the the attribute Default Value entered. | |||||
| 3. When no Subject Area is selected and no valid (matching a code in the attribute dictionary) attribute Default Value exists, do not report the SubjectAreaList or associated child elements. | |||||
| 4. When Subject Area is NOT Null, including the valid attribute Default Value, and is not a code in the mapping table, report "22". | |||||
| SubjectAreaList/ SubjectArea/ OtherCodeList | Requires an entry in Course.type to report. | O | |||
| SubjectAreaList/ SubjectArea/ OtherCodeList/ OtherCode | A state/province code, local code, other code or a text string that crosswalks to or serves as a translation of an associated Code element. | Reports the Code selected in Course.type. | Course.type | MR | |
| SubjectAreaList/ SubjectArea/ OtherCodeList/ @Codeset | Describes the OtherCode element content as either a state/province code, a local code, other code, or text string. | Hardcoded to "StateProvince" | M | ||
| CourseTitle | Title of the course. | Course.name | M | ||
| Description | Textual description of the course. | Reports from the Description field on Course. | Course.description | O | |
| InstructionalLevel | An indication of the general nature and difficulty of instruction provided | Optional do not report | O | ||
| CourseCredits | The number of credits awarded upon course completion. | Sum of GradingTaskCredit.credit on the Course. | GradingTaskCredit.credit | O | |
| CourseCredits/ @Type | The type of credit offered | Hardcoded to "0585" | M | ||
| CoreAcademic Course | Does the course meet the state definition of a core academic course? | 1. When the Subject Type = Core Academic Subject Area (CORE), reports "Yes" . 2. Otherwise, "No" | Course.subjectType | O | |
| Graduation Requirement | Does the state require that the course be completed for graduation? | This is Optional. Does not Report. | O | ||
| Department | Department with jurisdiction over this course | This is Optional. Does not Report. | O | ||
| SCEDCode | Course code from the School Codes for the Exchange of Data that describes the course content. | This is Optional. Does not Report. | O | ||
| DualCredit | Indicates whether this course is applicable in having dual credits | This is Optional. Does not Report. | O | ||
| CTEConcentrator | Indicates whether this is a CTE concentrator for this course | This is Optional. Does not Report. | O |
