S_MD_TermGradeMapping_S (ver 17.7.0)
This table is a standalone table and stores the Store Code that should be extracted for each Term ID.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | 17.7.0 | Number(11,0) | Primary Key. |
| Unique_ID | 17.7.0 | Number(11,0) | Primary key from the Virtual Table. |
| CompletionDate | 17.7.0 | Date | The completion date of the course term. |
| CourseTerm | 17.7.0 | Varchar2(10) | Identifies the term for the course. |
| SchoolID | 17.7.0 | Number(11,0) | ID of the school associated with this store code. |
| SortBy | 17.7.0 | Varchar2(100) | Identifies the sort order of fields for user interface display. |
| StoreCode | 17.7.0 | Varchar2(10) | Store code that will represent the final grade for a class. |
| TermID | 17.7.0 | Number(11,0) | ID of the term associated with the course. |
ForeignKey | 17.7.0 | Number(11,0) | Default field. No longer used. |
ForeignKey_Alpha | 17.7.0 | Varchar2(31) | Default field. No longer used. |