ACADEMIC TERMS Table

Information pertaining to academic terms

Field Name	Description	Data Type	Length
ACADEMIC_YEAR	Academic year	VARCHAR2	4
ACADEMIC_YEAR_DESC	Descriptive text of the academic year	VARCHAR2	30
DEGREE_YEAR	The academic year in which a degree is awarded.	VARCHAR2	4
FINANCIAL_AID_YEAR	The financial aid year	VARCHAR2	4
IS_CURRENT_TERM	Y=This is the current academic term	VARCHAR2	1
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	5
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_START_DATE	The begin date of the academic term.	DATE	8
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