ACADEMIC TERMS Table
Stores academic term reference data and key academic calendar dates (term start/end, registration, add/drop, and related milestones). Each row represents a single academic term.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACADEMIC_TERMS_KEY |
Surrogate key identifying the academic term record. |
VARCHAR2 |
6 |
ACADEMIC_YEAR |
Academic year associated with the term. Format typically YYYY. |
VARCHAR2 |
4 |
ACADEMIC_YEAR_DESC |
Description of the academic year (human-readable label). |
VARCHAR2 |
24 |
ADD_DATE |
Add deadline date for the term. |
DATE |
|
DEGREE_YEAR |
Degree year associated with the term for academic progression reporting. |
VARCHAR2 |
4 |
DROP_DATE |
Drop deadline date for the term. |
DATE |
|
FINANCIAL_AID_YEAR |
Financial aid year associated with the term. |
VARCHAR2 |
4 |
FIRST_DAY_OF_CLASSES |
First day of classes for the term. |
DATE |
|
GRADUATE_AWARD_END_DATE |
End date of graduate award period for the term (as defined by source). |
DATE |
|
GRADUATE_AWARD_START_DATE |
Start date of graduate award period for the term (as defined by source). |
DATE |
|
IS_CURRENT_TERM |
Indicator identifying whether this term is the current term (Y/N). |
VARCHAR2 |
1 |
IS_REGULAR_TERM |
Indicator identifying whether this is a regular term (Y/N). |
VARCHAR2 |
1 |
LAST_DAY_OF_CLASSES |
Last day of classes for the term. |
DATE |
|
LAST_DAY_OF_FINAL_EXAM |
Date of the last day of final exams for the term. |
DATE |
|
PRE_REGISTRATION_START_DAY |
Date pre-registration begins for the term. |
DATE |
|
REGISTRATION_DAY |
Registration day/date for the term. |
DATE |
|
TERM_CODE |
Institutional term code identifying the academic term. |
VARCHAR2 |
6 |
TERM_DESCRIPTION |
Description/name of the academic term. |
VARCHAR2 |
30 |
TERM_END_DATE |
End date of the academic term. |
DATE |
|
TERM_SELECTOR |
Term selector or label used for reporting and UI selection. |
VARCHAR2 |
37 |
TERM_START_DATE |
Start date of the academic term. |
DATE |
|
TERM_STATUS |
Term status description (e.g., active, completed). |
VARCHAR2 |
11 |
TERM_STATUS_INDICATOR |
Term status indicator code. |
VARCHAR2 |
1 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |