| Column
| Data Type
| Nullable
| Default
| Description
|
| TIME_ID
| DATE(7)
| not null
|
| primary key; day date, finest granularity, CORRECT ORDER
|
| DAY_NAME
| VARCHAR2(9)
| not null
|
| Monday to Sunday, repeating
|
| DAY_NUMBER_IN_WEEK
| NUMBER(1, 0)
| not null
|
| 1 to 7, repeating
|
| DAY_NUMBER_IN_MONTH
| NUMBER(2, 0)
| not null
|
| 1 to 31, repeating
|
| CALENDAR_WEEK_NUMBER
| NUMBER(2, 0)
| not null
|
| 1 to 53, repeating
|
| FISCAL_WEEK_NUMBER
| NUMBER(2, 0)
| not null
|
| 1 to 53, repeating
|
| WEEK_ENDING_DAY
| DATE(7)
| not null
|
| date of last day in week, CORRECT ORDER
|
| WEEK_ENDING_DAY_ID
| NUMBER
| not null
|
|
|
| CALENDAR_MONTH_NUMBER
| NUMBER(2, 0)
| not null
|
| 1 to 12, repeating
|
| FISCAL_MONTH_NUMBER
| NUMBER(2, 0)
| not null
|
| 1 to 12, repeating
|
| CALENDAR_MONTH_DESC
| VARCHAR2(8)
| not null
|
| e.g. 1998-01, CORRECT ORDER
|
| CALENDAR_MONTH_ID
| NUMBER
| not null
|
|
|
| FISCAL_MONTH_DESC
| VARCHAR2(8)
| not null
|
| e.g. 1998-01, CORRECT ORDER
|
| FISCAL_MONTH_ID
| NUMBER
| not null
|
|
|
| DAYS_IN_CAL_MONTH
| NUMBER
| not null
|
| e.g. 28,31, repeating
|
| DAYS_IN_FIS_MONTH
| NUMBER
| not null
|
| e.g. 25,32, repeating
|
| END_OF_CAL_MONTH
| DATE(7)
| not null
|
| last day of calendar month
|
| END_OF_FIS_MONTH
| DATE(7)
| not null
|
| last day of fiscal month
|
| CALENDAR_MONTH_NAME
| VARCHAR2(9)
| not null
|
| January to December, repeating
|
| FISCAL_MONTH_NAME
| VARCHAR2(9)
| not null
|
| January to December, repeating
|
| CALENDAR_QUARTER_DESC
| CHAR(7)
| not null
|
| e.g. 1998-Q1, CORRECT ORDER
|
| CALENDAR_QUARTER_ID
| NUMBER
| not null
|
|
|
| FISCAL_QUARTER_DESC
| CHAR(7)
| not null
|
| e.g. 1999-Q3, CORRECT ORDER
|
| FISCAL_QUARTER_ID
| NUMBER
| not null
|
|
|
| DAYS_IN_CAL_QUARTER
| NUMBER
| not null
|
| e.g. 88,90, repeating
|
| DAYS_IN_FIS_QUARTER
| NUMBER
| not null
|
| e.g. 88,90, repeating
|
| END_OF_CAL_QUARTER
| DATE(7)
| not null
|
| last day of calendar quarter
|
| END_OF_FIS_QUARTER
| DATE(7)
| not null
|
| last day of fiscal quarter
|
| CALENDAR_QUARTER_NUMBER
| NUMBER(1, 0)
| not null
|
| 1 to 4, repeating
|
| FISCAL_QUARTER_NUMBER
| NUMBER(1, 0)
| not null
|
| 1 to 4, repeating
|
| CALENDAR_YEAR
| NUMBER(4, 0)
| not null
|
| e.g. 1999, CORRECT ORDER
|
| CALENDAR_YEAR_ID
| NUMBER
| not null
|
|
|
| FISCAL_YEAR
| NUMBER(4, 0)
| not null
|
| e.g. 1999, CORRECT ORDER
|
| FISCAL_YEAR_ID
| NUMBER
| not null
|
|
|
| DAYS_IN_CAL_YEAR
| NUMBER
| not null
|
| 365,366 repeating
|
| DAYS_IN_FIS_YEAR
| NUMBER
| not null
|
| e.g. 355,364, repeating
|
| END_OF_CAL_YEAR
| DATE(7)
| not null
|
| last day of cal year
|
| END_OF_FIS_YEAR
| DATE(7)
| not null
|
| last day of fiscal year
|
| Check Constraint
| Expression
| Description
|
| SYS_C005088
| "TIME_ID" IS NOT NULL
|
|
| SYS_C005089
| "DAY_NAME" IS NOT NULL
|
|
| SYS_C005090
| "DAY_NUMBER_IN_WEEK" IS NOT NULL
|
|
| SYS_C005091
| "DAY_NUMBER_IN_MONTH" IS NOT NULL
|
|
| SYS_C005092
| "CALENDAR_WEEK_NUMBER" IS NOT NULL
|
|
| SYS_C005093
| "FISCAL_WEEK_NUMBER" IS NOT NULL
|
|
| SYS_C005094
| "WEEK_ENDING_DAY" IS NOT NULL
|
|
| SYS_C005095
| "WEEK_ENDING_DAY_ID" IS NOT NULL
|
|
| SYS_C005096
| "CALENDAR_MONTH_NUMBER" IS NOT NULL
|
|
| SYS_C005097
| "FISCAL_MONTH_NUMBER" IS NOT NULL
|
|
| SYS_C005098
| "CALENDAR_MONTH_DESC" IS NOT NULL
|
|
| SYS_C005099
| "CALENDAR_MONTH_ID" IS NOT NULL
|
|
| SYS_C005100
| "FISCAL_MONTH_DESC" IS NOT NULL
|
|
| SYS_C005101
| "FISCAL_MONTH_ID" IS NOT NULL
|
|
| SYS_C005102
| "DAYS_IN_CAL_MONTH" IS NOT NULL
|
|
| SYS_C005103
| "DAYS_IN_FIS_MONTH" IS NOT NULL
|
|
| SYS_C005104
| "END_OF_CAL_MONTH" IS NOT NULL
|
|
| SYS_C005105
| "END_OF_FIS_MONTH" IS NOT NULL
|
|
| SYS_C005106
| "CALENDAR_MONTH_NAME" IS NOT NULL
|
|
| SYS_C005107
| "FISCAL_MONTH_NAME" IS NOT NULL
|
|
| SYS_C005108
| "CALENDAR_QUARTER_DESC" IS NOT NULL
|
|
| SYS_C005109
| "CALENDAR_QUARTER_ID" IS NOT NULL
|
|
| SYS_C005110
| "FISCAL_QUARTER_DESC" IS NOT NULL
|
|
| SYS_C005111
| "FISCAL_QUARTER_ID" IS NOT NULL
|
|
| SYS_C005112
| "DAYS_IN_CAL_QUARTER" IS NOT NULL
|
|
| SYS_C005113
| "DAYS_IN_FIS_QUARTER" IS NOT NULL
|
|
| SYS_C005114
| "END_OF_CAL_QUARTER" IS NOT NULL
|
|
| SYS_C005115
| "END_OF_FIS_QUARTER" IS NOT NULL
|
|
| SYS_C005116
| "CALENDAR_QUARTER_NUMBER" IS NOT NULL
|
|
| SYS_C005117
| "FISCAL_QUARTER_NUMBER" IS NOT NULL
|
|
| SYS_C005118
| "CALENDAR_YEAR" IS NOT NULL
|
|
| SYS_C005119
| "CALENDAR_YEAR_ID" IS NOT NULL
|
|
| SYS_C005120
| "FISCAL_YEAR" IS NOT NULL
|
|
| SYS_C005121
| "FISCAL_YEAR_ID" IS NOT NULL
|
|
| SYS_C005122
| "DAYS_IN_CAL_YEAR" IS NOT NULL
|
|
| SYS_C005123
| "DAYS_IN_FIS_YEAR" IS NOT NULL
|
|
| SYS_C005124
| "END_OF_CAL_YEAR" IS NOT NULL
|
|
| SYS_C005125
| "END_OF_FIS_YEAR" IS NOT NULL
|
|
