WTW ACADEMIC TERM Table
Academic term information for the Who-is-Teaching-What data.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACADEMIC_YEAR |
Academic year |
VARCHAR2 |
4 |
ACADEMIC_YEAR_DESC |
Descriptive text of the academic year |
VARCHAR2 |
30 |
IS_CURRENT_TERM |
Y=This is the current academic term |
VARCHAR2 |
1 |
TERM_CODE |
** For FINANCIAL DATA: the Term Code identifies the status of the cost collector. Blank - open for charges between start and end dates. Term Code = 1 - Closed. Pre-end date charges allowed. Term Code = 2 - No longer in use. Term Code = 3 - Terminated. Charges not allowed. ** For STUDENT DATA: the Term Code identifies one of the terms in an academic year; for example: 1999FA==>Fall Term of the 1998-99 academic year, and 1999SP==>Spring Term of the 1998-99 academic year. |
VARCHAR2 |
6 |
TERM_DESCRIPTION |
Long text associated with the TERM_CODE for STUDENT data (Example: Fall 1996, Spring 1997.) |
VARCHAR2 |
30 |
TERM_END_DATE |
The end date of the academic term. |
DATE |
8 |
TERM_SELECTOR |
This field concatenates the academic term code (eg. 2011FA) and the descriptive text (eg. Fall Term 2010-2011) into one string (eg. 2011FA-Fall Term 2010-2011) for easier selections of academic term. |
VARCHAR2 |
37 |
TERM_START_DATE |
The begin date of the academic term. |
DATE |
8 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |
WTW_ACADEMIC_TERM_KEY |
Use this field to join together tables WTW_TEACHING_DETAIL and WTW_ACADEMIC_TERM to get the academic term information for the teaching data. |
VARCHAR2 |
6 |