TIME DAY Table
View exposing enterprise time dimension data at the day level including fiscal, calendar, academic, and financial-aid attributes together with start and end dates and day-of-week.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACADEMIC_TERM_CODE |
Code identifying academic term. |
VARCHAR2 |
6 |
ACADEMIC_TERM_DESCRIPTION |
Description of academic term. |
VARCHAR2 |
30 |
ACADEMIC_YEAR |
Academic year associated with the record. |
VARCHAR2 |
4 |
CALENDAR_DATE |
Date associated with calendar. |
DATE |
|
CALENDAR_PERIOD |
Calendar period associated with the record. |
VARCHAR2 |
6 |
CALENDAR_PERIOD_DESCRIPTION |
Description of calendar period. |
VARCHAR2 |
30 |
CALENDAR_YEAR |
Calendar year associated with the record. |
VARCHAR2 |
4 |
DAY_OF_WEEK |
Day of week associated with the record. |
VARCHAR2 |
36 |
END_DATE |
Date associated with end. |
DATE |
|
FINANCIAL_AID_YEAR |
Financial aid year associated with the record. |
VARCHAR2 |
4 |
FINANCIAL_AID_YEAR_DESC |
Description of financial aid year. |
VARCHAR2 |
30 |
FISCAL_PERIOD |
Fiscal period associated with the record. |
VARCHAR2 |
6 |
FISCAL_PERIOD_DESCRIPTION |
Description of fiscal period. |
VARCHAR2 |
30 |
FISCAL_YEAR |
Fiscal year associated with the record. |
VARCHAR2 |
4 |
START_DATE |
Date associated with start. |
DATE |