WTW OLD SUBJECT SECTION Table
View exposing subject and section records used in the old Who's Teaching What teaching data model.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CLUSTER_LIST |
Cluster list associated with the record. |
VARCHAR2 |
600 |
CLUSTER_TYPE |
Cluster type associated with the record. |
VARCHAR2 |
4 |
CLUSTER_TYPE_DESC |
Description of cluster type. |
VARCHAR2 |
120 |
DEPARTMENT_CODE |
Code identifying department. |
VARCHAR2 |
16 |
DEPARTMENT_NAME |
Department name associated with the record. |
VARCHAR2 |
120 |
MASTER_SUBJECT_ID |
Business identifier for the master subject. |
VARCHAR2 |
32 |
MASTER_SUBJECT_ID_SORT |
Master subject id sort associated with the record. |
VARCHAR2 |
32 |
MEET_PLACE |
Meet place associated with the record. |
VARCHAR2 |
60 |
MEET_TIME |
Time associated with meet. |
VARCHAR2 |
120 |
SCHOOL_CODE |
Code identifying school. |
VARCHAR2 |
8 |
SCHOOL_NAME |
School name associated with the record. |
VARCHAR2 |
120 |
SECTION_ENROLLMENT_NUMBER |
Section enrollment number associated with the record. |
VARCHAR2 |
40 |
SECTION_NAME |
Section name associated with the record. |
VARCHAR2 |
12 |
SUBJECT_ID |
Business identifier for the subject. |
VARCHAR2 |
32 |
SUBJECT_ID_SORT |
Subject id sort associated with the record. |
VARCHAR2 |
32 |
SUBJECT_TITLE |
Subject title associated with the record. |
VARCHAR2 |
240 |
TERM_CODE |
Code identifying term. |
VARCHAR2 |
24 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |
|
WTW_OLD_SUBJECT_SECTION_KEY |
Surrogate key identifying the wtw old subject section. |
VARCHAR2 |
64 |
WTW_SUBJECT_GROUPING_KEY |
Surrogate key identifying the wtw subject grouping. |
VARCHAR2 |
128 |
WTW_SUBJECT_SUMMARY_KEY |
Surrogate key identifying the wtw subject summary. |
VARCHAR2 |
56 |