WTW SUBJECT SUMMARY Table
View exposing subject summary records used in the Who's Teaching What teaching data model, with one subject per academic term.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CLUSTER_ENROLLMENT_NUMBER |
Cluster enrollment number associated with the record. |
NUMBER |
19 |
CLUSTER_LIST |
Cluster list associated with the record. |
VARCHAR2 |
4000 |
CLUSTER_TYPE |
Cluster type associated with the record. |
VARCHAR2 |
1 |
CLUSTER_TYPE_DESC |
Description of cluster type. |
VARCHAR2 |
30 |
DEPARTMENT_CODE |
Code identifying department. |
VARCHAR2 |
8 |
DEPARTMENT_NAME |
Department name associated with the record. |
VARCHAR2 |
30 |
DESIGN_UNITS |
Design units associated with the record. |
NUMBER |
2 |
LAB_UNITS |
Lab units associated with the record. |
NUMBER |
2 |
LECTURE_UNITS |
Lecture units associated with the record. |
NUMBER |
2 |
MASTER_SUBJECT_ID |
Business identifier for the master subject. |
VARCHAR2 |
8 |
MASTER_SUBJECT_ID_SORT |
Master subject id sort associated with the record. |
VARCHAR2 |
12 |
PREP_UNITS |
Prep units associated with the record. |
NUMBER |
2 |
SCHOOL_CODE |
Code identifying school. |
VARCHAR2 |
2 |
SCHOOL_NAME |
School name associated with the record. |
VARCHAR2 |
30 |
SUBJECT_ENROLLMENT_NUMBER |
Subject enrollment number associated with the record. |
NUMBER |
19 |
SUBJECT_ID |
Business identifier for the subject. |
VARCHAR2 |
8 |
SUBJECT_ID_SORT |
Subject id sort associated with the record. |
VARCHAR2 |
12 |
SUBJECT_TITLE |
Subject title associated with the record. |
VARCHAR2 |
60 |
TERM_CODE |
Code identifying term. |
VARCHAR2 |
6 |
TOTAL_UNITS |
Total units associated with the record. |
NUMBER |
2 |
ULT_MASTER_SUBJECT_ID |
Business identifier for the ult master subject. |
VARCHAR2 |
8 |
ULT_MASTER_SUBJECT_ID_SORT |
Ult master subject id sort associated with the record. |
VARCHAR2 |
12 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |
|
WTW_SUBJECT_SUMMARY_KEY |
Surrogate key identifying the wtw subject summary. |
VARCHAR2 |
14 |