S_MD_GSI_LetterGradeMapping_C (ver 17.7.0)
This table is a child table of the GRADESCALEITEM table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | 17.7.0 | Number (10,0) | Primary Key. |
ForeignKey | 17.7.0 | Number (11,0) | GradeScaleItem table ID. |
| GradeScaleItemDCID | 17.7.0 | Number (10,0) | Foreign key used to link back to the GradeScaleItem table. |
| Unique_ID | 17.7.0 | Number (11,0) | Primary key from the Virtual Table. |
| Code01 | 17.7.0 | Varchar2 (2000) | Code list of final grades to be associated with a State completion code. |
| Code02 | 17.7.0 | Varchar2 (2000) | Code list of final grades to be associated with a State completion code. |
| Code03 | 17.7.0 | Varchar2 (2000) | Code list of final grades to be associated with a State completion code. |
| Code04 | 17.7.0 | Varchar2 (2000) | Code list of final grades to be associated with a State completion code. |
| Code05 | 17.7.0 | Varchar2 (2000) | Code list of final grades to be associated with a State completion code. |
| SchoolID | 17.7.0 | Number (11,0) | ID of the school associated with this store code. |
ForeignKey_Alpha | 17.7.0 | Varchar2 (31) | Default field. No longer used. |