Grade Scale Mapping: MA_SCS_GradeScale Virtual Table
Each mapping record is stored in a virtual table called MA_SCS_GradeScale. One mapping record should be set up for each grade scale for your district. The first field in the virtual table in gsid, which stores the grade scale name from the Grade Scale Item table (GradeScaleItem).
Data Element | Importing: [Table]Field | DDE: [Table]Field |
|---|---|---|
District ID (always "0") | [MA_SCS_GradeScale]schoolID | [VirtualTablesData2]schoolID |
Grade Scale ID | [MA_SCS_GradeScale]foreignKey | [VirtualTablesData2]foreignKey |
Grade Scale Name | [MA_SCS_GradeScale]gsid | [VirtualTablesData2]gsid |
Value A+ | [MA_SCS_GradeScale]Value01 | [VirtualTablesData2]Value01 |
Value A | [MA_SCS_GradeScale]Value02 | [VirtualTablesData2]Value02 |
Value A- | [MA_SCS_GradeScale]Value03 | [VirtualTablesData2]Value03 |
Value B+ | [MA_SCS_GradeScale]Value04 | [VirtualTablesData2]Value04 |
Value B | [MA_SCS_GradeScale]Value05 | [VirtualTablesData2]Value05 |
Value B- | [MA_SCS_GradeScale]Value06 | [VirtualTablesData2]Value06 |
Value C+ | [MA_SCS_GradeScale]Value07 | [VirtualTablesData2]Value07 |
Value C | [MA_SCS_GradeScale]Value08 | [VirtualTablesData2]Value08 |
Value C- | [MA_SCS_GradeScale]Value09 | [VirtualTablesData2]Value09 |
Value D+ | [MA_SCS_GradeScale]Value10 | [VirtualTablesData2]Value10 |
Value D | [MA_SCS_GradeScale]Value11 | [VirtualTablesData2]Value11 |
Value D- | [MA_SCS_GradeScale]Value12 | [VirtualTablesData2]Value12 |
Value F | [MA_SCS_GradeScale]Value13 | [VirtualTablesData2]Value13 |
Value Pass | [MA_SCS_GradeScale]Value14 | [VirtualTablesData2]Value14 |
Value Fail | [MA_SCS_GradeScale]Value15 | [VirtualTablesData2]Value15 |
Value Failing | [MA_SCS_GradeScale]Value16 | [VirtualTablesData2]Value16 |
Value Minimally Acceptable | [MA_SCS_GradeScale]Value17 | [VirtualTablesData2]Value17 |
Value Acceptable | [MA_SCS_GradeScale]Value18 | [VirtualTablesData2]Value18 |
Value Good | [MA_SCS_GradeScale]Value19 | [VirtualTablesData2]Value19 |
Value Outstanding | [MA_SCS_GradeScale]Value20 | [VirtualTablesData2]Value20 |
Withdrawn | [MA_SCS_GradeScale]Value21 | [VirtualTablesData2]Value21 |
Withdrawn – Pass | [MA_SCS_GradeScale]Value22 | [VirtualTablesData2]Value22 |
Withdrawn – Fail | [MA_SCS_GradeScale]Value23 | [VirtualTablesData2]Value23 |
Incomplete | [MA_SCS_GradeScale]Value40 | [VirtualTablesData2]Value40 |
Excused | [MA_SCS_GradeScale]Value50 | [VirtualTablesData2]Value50 |