ACADEMIC TERMS Table
Information pertaining to academic terms
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACADEMIC_TERMS_KEY |
Use this field to join to the ACADEMIC_TERMS table to get information about the academic term(s). |
VARCHAR2 |
6 |
ACADEMIC_YEAR |
Academic year |
VARCHAR2 |
4 |
ACADEMIC_YEAR_DESC |
Descriptive text of the academic year |
VARCHAR2 |
30 |
ADD_DATE |
XXX |
DATE |
8 |
DEGREE_YEAR |
The academic year in which a degree is awarded. |
VARCHAR2 |
4 |
DROP_DATE |
XXX |
DATE |
7 |
FINANCIAL_AID_YEAR |
The financial aid year |
VARCHAR2 |
4 |
FIRST_DAY_OF_CLASSES |
The date of the first day of classes for the term |
DATE |
8 |
GRADUATE_AWARD_END_DATE |
The end date of the academic term for graduate award assignment |
DATE |
8 |
GRADUATE_AWARD_START_DATE |
The start date of the academic term for graduate award assignment. |
DATE |
8 |
IS_CURRENT_TERM |
Y=This is the current academic term |
VARCHAR2 |
1 |
IS_REGULAR_TERM |
XXX |
VARCHAR2 |
1 |
LAST_DAY_OF_CLASSES |
The date of the last day of classes for the academic term |
DATE |
8 |
LAST_DAY_OF_FINAL_EXAM |
The date for the last day of the final exam period in the academic term. |
DATE |
8 |
PRE_REGISTRATION_START_DAY |
The date when the pre-registration process starts for the academic term. |
DATE |
8 |
REGISTRATION_DAY |
The date of the Registration Day for the term |
DATE |
8 |
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 |
TERM_STATUS |
XXX |
VARCHAR2 |
11 |
TERM_STATUS_INDICATOR |
Status of an academic term. Possible values are: C=Current term, P=Prior term, F=Future term |
VARCHAR2 |
1 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |