This object provides information about courses. The SchoolCourseInfo records are published for each course that is assigned to the current school year for schools that are part of the zone.
Selection Criteria
-
Year-specific school courses must include course name, course number, and NCES code.
-
The school and course are not excluded from state reporting.
Dependency
School course info depends on School Info Resource
Element Mappings
|
SIF Element/Attribute |
Description |
Req. |
MA Field |
PS Field Mapping: [Table]Column |
Business logic/ Rules |
|---|---|---|---|---|---|
|
@RefId |
The Id (GUID) that uniquely identifies the school course. |
M |
|
|
The GUID generated for object type 13 and compositekey [school_course.dcid]. |
|
SchoolInfoRefId |
The Id (GUID) that identifies the school where the course is offered. |
M |
|
|
|
|
SchoolYear |
School year for which the information is applicable, expressed as the four-digit year in which the school year ends (e.g. 2025 for the 2025-2025 school year). |
M |
|
|
|
|
CourseCode |
School-defined local code for the course. |
M |
|
[Courses]Course_Number |
|
|
StateCourseCode |
State-defined standard course code used to report information about courses. |
O |
SCS05WA10 |
[S_MA_CRS_X]NCESCode |
|
|
DistrictCourseCode |
The corresponding district course code. |
O |
SCS05WA10 |
[Courses]Course_Number |
|
|
CourseTitle |
Title of the course. |
M |
|
[Courses]Course_Name |
|
|
InstructionalLevel |
An indication of the general nature and difficulty of instruction provided. |
O |
|
|
|
|
InstructionLevel/Code |
The code representing the general nature and difficulty of the instruction provided. |
M |
SCS09 |
[S_MA_CRS_X]CourseLevel |
Defaults to 0571, which is the same as 02 – General. |
|
CourseCredits |
The number of credits awarded upon course completion. |
O |
SCS10 |
|
|
|
1.CourseCredits/Type |
The type of credit offered. |
M |
|
[Courses]Credit_Hours |
If Credit_Hours is null, the value is 9998; else the value is 9999. |
|
1.CourseCredits/Value |
|
|
|
[Courses]Credit_Hours |
Value rounded off to 5 decimals |
|
CoreAcademicCourse/Value |
Does the course meet the state definition of a core academic course? |
O |
|
[S_MA_CRS_X]CoreCourseIndicator |
Yes/No |
|
Department |
The department that has jurisdiction over this course. |
O |
|
[Courses]Sched_Department |
|
|
SIF_ExtendedElements/SIF_ExtendedElement |
|
O |
|
|
|
|
[@Name="AttendingSchool"] |
If the student is attending a college, out of district traditional or out of district virtual course, then the school code is reported, otherwise the StateProvinceId from the SchoolInfoObject is used. This might not be equal to DOE015. Refer to SCS data handbook. |
C |
SCS03 |
[S_MA_CRS_X] OverrideSchoolCode |
If no value is present, the SchoolInfo/StateProvinceId value is used. If a district removes the value here, it sometimes does not correct for the state; entering the school code here, fixes this issue. |