SUBJECT GRADE CHARS Table
Characteristics of a grade for a subject
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COUNT_IN_EARNED_UNITS |
XXX |
VARCHAR2 |
1 |
COUNT_IN_GPA |
XXX |
VARCHAR2 |
1 |
COUNT_IN_PASSED_UNITS |
XXX |
VARCHAR2 |
1 |
EFFECTIVE_FROM_TERM |
XXX |
VARCHAR2 |
6 |
EFFECTIVE_THROUGH_TERM |
XXX |
VARCHAR2 |
6 |
GPA_Q_POINTS |
XXX |
NUMBER |
5 |
GRADE_DESCRIPTION |
Description of the grade symbol |
VARCHAR2 |
30 |
GRADE_SYMBOL |
Grade symbol or letter |
VARCHAR2 |
5 |
IS_INCOMPLETE |
XXX |
VARCHAR2 |
1 |
IS_OPEN_GRADE |
XXX |
VARCHAR2 |
1 |
LAST_ACTIVITY_DATE |
Date when information in the record was last updated. |
DATE |
8 |
SUBJECT_GRADE_CHARS_KEY |
Use this field to join between SUBJECT GRADE DETAIL and SUBJECT GRADE CHARS to get characteristic information about the grades. |
NUMBER |
10 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |