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 |