This table stores day-level information about the gregorian calendar.
Module:
CAL_DAY_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
CAL_DAY_ID | NUMBER | 38 | 0 | True | Date in YYYYMMDD format. | ||
SOURCE_RECORD_ID | NUMBER | 38 | 0 | Integration identifier generated by formatting the date in YYYYMMDD format. | |||
CALENDAR_DATE | DATE | Calendar date. | |||||
DAY_OF_WEEK | NUMBER | 38 | 0 | Day of the week. Possible values are 1 through 7. | |||
DAY_OF_MONTH | NUMBER | 38 | 0 | Day of the month. Possible values are 1 through 31. | |||
DAY_OF_YEAR | NUMBER | 38 | 0 | Day of the year. Possible values are 1 through 366. | |||
DAY_AGO_DATE | DATE | Previous day's date. | |||||
DAY_AGO_ID | NUMBER | 38 | 0 | Previous date in YYYYMMDD format. | |||
DAY_CODE | VARCHAR2 | 16 | Name of the day. Possible values are SUN, MON, and so on. | ||||
DAY_LOCALE_NAME | VARCHAR2 | 32 | Full Name of the day. Possible values are Sunday, Monday..etc | ||||
JULIAN_DAY_NUMBER | NUMBER | 38 | 0 | Date in Julian format. | |||
CAL_WEEK_ID | NUMBER | 38 | 0 | Week identifier in YYYYW format. For example, 197949. | |||
CAL_MONTH_ID | NUMBER | 38 | 0 | Month identifier in YYYYQMM format. For example, 1979412. | |||
CAL_QUARTER_ID | NUMBER | 38 | 0 | Quarter identifier in YYYYQ format. For example, 19794. | |||
CAL_YEAR_ID | NUMBER | 38 | 0 | Year identifier in YYYY format. For example, 1979. | |||
CAL_MONTH_CODE | VARCHAR2 | 32 | Calendar month period. For example, 1979/12. | ||||
CAL_QUARTER_CODE | VARCHAR2 | 32 | Calendar quarter period. For example, 1979 Q4. | ||||
CAL_WEEK_CODE | VARCHAR2 | 32 | Calendar week period. For example, 1979 Week53. | ||||
CAL_YEAR_CODE | VARCHAR2 | 16 | Calendar Year period. For example, 1979 | ||||
CAL_WEEK_START_DATE | DATE | Start date of the week. | |||||
CAL_WEEK_END_DATE | DATE | End date of the week. | |||||
CAL_MONTH_START_DATE | DATE | Start date of the month. | |||||
CAL_MONTH_END_DATE | DATE | End date of the month. | |||||
CAL_QUARTER_START_DATE | DATE | Start date of the quarter. | |||||
CAL_QUARTER_END_DATE | DATE | End date of the quarter. | |||||
CAL_YEAR_START_DATE | DATE | Start date of the year. | |||||
CAL_YEAR_END_DATE | DATE | End date of the year. | |||||
CAL_MONTH_NUMBER | NUMBER | 38 | 0 | Calendar month of this day. Possible values are 1 through 12. | |||
CAL_HALF_NUMBER | NUMBER | 38 | 0 | Calendar half-year of this day. Possible values are 1 and 2. | |||
CAL_MONTH_LOCALE_NAME | VARCHAR2 | 32 | Calendar month name of this day. Possible values are January, February | ||||
CAL_QUARTER_NUMBER | NUMBER | 38 | 0 | Calendar quarter of this day. Possible values are 1, 2, 3, and 4. | |||
CAL_TRIMESTER_NUMBER | NUMBER | 38 | 0 | Calendar trimester of this day. Possible values are 1, 2 and 3. | |||
CAL_WEEK_NUMBER | NUMBER | 38 | 0 | Calendar week identifier. Possible values are 1 through 53. | |||
CAL_MONTH_END_DATE_ID | NUMBER | 38 | 0 | Last day of month in YYYYMMDD format. | |||
CAL_MONTH_START_DATE_ID | NUMBER | 38 | 0 | First day of month in YYYYMMDD format. | |||
CAL_WEEK_END_DATE_ID | NUMBER | 38 | 0 | Last day of week in YYYYMMDD format. | |||
CAL_WEEK_START_DATE_ID | NUMBER | 38 | 0 | First day of week in YYYYMMDD format. | |||
CAL_QUARTER_START_DATE_ID | NUMBER | 38 | 0 | First day of quarter in YYYYMMDD format. | |||
CAL_QUARTER_END_DATE_ID | NUMBER | 38 | 0 | Last day of quarter in YYYYMMDD format. | |||
CAL_YEAR_END_DATE_ID | NUMBER | 38 | 0 | Last day of year in YYYYMMDD format. | |||
CAL_YEAR_START_DATE_ID | NUMBER | 38 | 0 | First day of year in YYYYMMDD format. | |||
FIRST_DAY_CAL_WEEK_FLAG | VARCHAR2 | 16 | Indicates that this day is the first day of the calendar week. | ||||
LAST_DAY_CAL_WEEK_FLAG | VARCHAR2 | 16 | Indicates that this day is the last day of the calendar week. | ||||
FIRST_DAY_CAL_MONTH_FLAG | VARCHAR2 | 16 | Indicates that this day is the first day of the calendar month. | ||||
LAST_DAY_CAL_MONTH_FLAG | VARCHAR2 | 16 | Indicates that this day is the last day of the calendar month. | ||||
FIRST_DAY_CAL_QTR_FLAG | VARCHAR2 | 16 | Indicates that this day is the first day of the calendar quarter. | ||||
LAST_DAY_CAL_QTR_FLAG | VARCHAR2 | 16 | Indicates that this day is the last day of the calendar quarter. | ||||
FIRST_DAY_CAL_YEAR_FLAG | VARCHAR2 | 16 | Indicates that this day is the first day of the calendar year. | ||||
LAST_DAY_CAL_YEAR_FLAG | VARCHAR2 | 16 | Indicates that this day is the last day of the calendar year. | ||||
CURRENT_CAL_DAY_CODE | VARCHAR2 | 16 | Indicates current day. Possible value is Current. | ||||
CURRENT_CAL_WEEK_CODE | VARCHAR2 | 16 | Indicates that this day belongs to current week. Possible value is Current. | ||||
CURRENT_CAL_MONTH_CODE | VARCHAR2 | 16 | Indicates that this day belongs to current month. Possible value is Current. | ||||
CURRENT_CAL_QTR_CODE | VARCHAR2 | 16 | Indicates that this day belongs to current quarter. Possible value is Current. | ||||
CURRENT_CAL_YEAR_CODE | VARCHAR2 | 16 | Indicates that this day belongs to current year. Possible value is Current. | ||||
MONTH_END_OR_PRV_CRNT_DATE | DATE | For current month, day before current date else Month end date | |||||
QUARTER_END_OR_PRV_CRNT_DATE | DATE | For current quarter, day before current date else quarter end date | |||||
YEAR_END_OR_PRV_CRNT_DATE | DATE | For current year, day before current date else year end date | |||||
TRAILING_MONTH_NUMBER | NUMBER | 38 | 0 | Indicate trailing month number | |||
TRAILING_QUARTER_NUMBER | NUMBER | 38 | 0 | Indicate trailing quarter number | |||
TRAILING_YEAR_NUMBER | NUMBER | 38 | 0 | Indicate trailing year number | |||
MONTH_END_OR_PRV_CRNT_DATE_ALT | DATE | For current month, if current month start then month end date else day before current date else Month end date | |||||
QUARTER_END_OR_PRV_CRNT_DATE_ALT | DATE | For current quarter, if current quarter start then quarter end date else day before current date else quarter end date | |||||
YEAR_END_OR_PRV_CRNT_DATE_ALT | DATE | For current year,if current year start then year end date else day before current date else year end date |