WTW ACADEMIC TERM Table
View exposing academic term reference data used in the Who's Teaching What teaching data model.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACADEMIC_YEAR |
Academic year associated with the record. |
VARCHAR2 |
4 |
ACADEMIC_YEAR_DESC |
Description of academic year. |
VARCHAR2 |
24 |
IS_CURRENT_TERM |
Indicator identifying whether current term (Y/N). |
VARCHAR2 |
1 |
TERM_CODE |
Code identifying term. |
VARCHAR2 |
6 |
TERM_DESCRIPTION |
Description of term. |
VARCHAR2 |
30 |
TERM_END_DATE |
Date associated with term end. |
DATE |
|
TERM_SELECTOR |
Term selector associated with the record. |
VARCHAR2 |
37 |
TERM_START_DATE |
Date associated with term start. |
DATE |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |
|
WTW_ACADEMIC_TERM_KEY |
Surrogate key identifying the wtw academic term. |
VARCHAR2 |
6 |