- DATA VIEW NAME
- STDNT_TERM_CODES
- OVERVIEW
- This descriptor view contains the term description and term begin and end date for the Undergraduate Academic Calendar.
- LOAD FREQUENCY
- The data is refreshed weekly.
- DATA CUSTODIAN
- Registrar’s Office
Contact: Phil Hull - AUTHORIZATION
- No approval signature is required by the Data Custodian to receive
authorization to access this data view. For information about how to get authorized for InfoAccess data views, connect to InfoAccess Home Page - SPECIAL
CONSIDERATIONS - None
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 9/99 Data view created.
10/01 View create to use varchar2 data types and conformed data element names.
09/2012 – Data Custodian Contact changed from Karen Hanon to Kim Alling - 09/2023 – fields added for AC_YEAR_SHORT_DESCR, AC_YEAR_LONG_DESCR, and CALENDAR_YR.
- DATA FORMATS
- Key fields are identified with an asterisk(*)
Field Formats describe the field type and length.
Last sentence under Numeric Data should read:
Examples: NUMBER (6,2) contains 2500.12. NUMBER (6) contains 250012.
| Column Name | Format | Description |
|---|---|---|
| TERM | VARCHAR2 (4) | Formerly the semester. The term code is derived as follows: Character 1 = Century (0 = 1900 and 1 = 2000) Character 2 & 3 = Academic Year Character 4 = Term ( 2=Fall, 4=Spring and 6=Summer) |
| TERM_DESCR | VARCHAR2 (30) | This is description of the TERM. |
| AC_YEAR_SHORT_DESCR | VARCHAR2 (40) | The short description of the academic year. Refers to the calendar year of the spring term (e.g. ‘2024’) |
| AC_YEAR_LONG_DESCR | VARCHAR2 (81) | The long description of the academic year. Refers to the calendar year of the summer term through the calendar year of the spring term. (e.g. ‘2023-2024’) |
| CALENDAR_YR | VARCHAR2 (4) | The calendar year of the term end date for the selected Term. (e.g. term 1226 would be ‘2022’) |
| TERM_BEGIN_DATE | VARCHAR2 (8) | Date that this term started. |
| TERM_END_DATE | VARCHAR2 (6) | Date that this term ended. |
| EXTRACT_DATE_TIME | DATE | The System generated date when the data was last refreshed. Format: mm/dd/ccyy. |