SCS
The following table contains the SCS fields provided by the Massachusetts Department of Education, the associated title, and the location in the PowerSchool database where the field is found.
MA Field | Title | PS DB Location |
|---|---|---|
SCS01 | Locally Assigned Student Identifier (LASID) | [Students] Student_Number |
SCS02 | State-Assigned Student Identifier (SASID) | [Students] State_StudentNumber |
SCS03 | School/Program ID Number | [S_MA_CRS_X] OverrideSchoolCode – It is best to leave this field blank and the school code will be used. This is mainly designed for CLBR courses. |
SCS04 | Local Course Code | [Courses] Course_Number |
SCS05 | Subject Area–Course Code | [S_MA_CRS_X] NCESCode |
SCS06 | Class Section |
|
SCS07 | Course Term | [S_MA_TRM_X] State_Course_Term_Code – This is setup at the term level. |
SCS08 | Course Enrollment Status | [S_MA_CC_SCS_X] OverrideCourseEnrollStatus – This is autogenerated based on the current enrollment status in the class. This field is used as an override. |
SCS09 | Course Level | [S_MA_CRS_X] CourseLevel |
SCS10 | Course Credit Available | [Courses] Credit_Hours |
SCS11 | Course Credit Earned | [StoredGrades] EarnedCrHrs |
SCS12 | Course Letter Mark | [StoredGrades] Grade – This field is atuocalculated based on the SCS Grade Scale Mapping. |
SCS13 | Course Numeric Mark | [StoredGrades] Percentage |