Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse SUBJECT GRADE CHARS Table


View exposing subject grade character reference values used to classify grade results.


Field Name

Description

Data Type

Length

COUNT_IN_EARNED_UNITS

Count in earned units associated with the record.

VARCHAR2

1

COUNT_IN_GPA

Count in gpa associated with the record.

VARCHAR2

1

COUNT_IN_PASSED_UNITS

Count in passed units associated with the record.

VARCHAR2

1

EFFECTIVE_FROM_TERM

Effective from term associated with the record.

VARCHAR2

6

EFFECTIVE_THROUGH_TERM

Effective through term associated with the record.

VARCHAR2

6

GPA_Q_POINTS

Gpa q points associated with the record.

NUMBER

GRADE_DESCRIPTION

Description of grade.

VARCHAR2

30

GRADE_SYMBOL

Grade symbol associated with the record.

VARCHAR2

4

IS_INCOMPLETE

Indicator identifying whether incomplete (Y/N).

VARCHAR2

1

IS_OPEN_GRADE

Indicator identifying whether open grade (Y/N).

VARCHAR2

1

LAST_ACTIVITY_DATE

Date associated with last activity.

DATE

SUBJECT_GRADE_CHARS_KEY

Surrogate key identifying the subject grade chars.

NUMBER

10

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE