WTW SUBJECT GROUPING Table
View exposing subject grouping records used in the Who's Teaching What teaching data model to identify clustered subjects by academic term, department, and school.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
DEPARTMENT_CODE |
Code identifying department. |
VARCHAR2 |
16 |
DEPARTMENT_NAME |
Department name associated with the record. |
VARCHAR2 |
120 |
SCHOOL_CODE |
Code identifying school. |
VARCHAR2 |
8 |
SCHOOL_NAME |
School name associated with the record. |
VARCHAR2 |
120 |
TERM_CODE |
Code identifying term. |
VARCHAR2 |
24 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |
|
WTW_SUBJECT_GROUPING_KEY |
Surrogate key identifying the wtw subject grouping. |
VARCHAR2 |
128 |