| Column
|
Datatype
|
Nullable
|
Default value
|
Comment
|
| TIME_ID
|
DATE
|
N
|
|
primary key; day date, finest granularity, CORRECT ORDER
|
| DAY_NAME
|
VARCHAR2(9)
|
N
|
|
Monday to Sunday, repeating
|
| DAY_NUMBER_IN_WEEK
|
NUMBER(1,0)
|
N
|
|
1 to 7, repeating
|
| DAY_NUMBER_IN_MONTH
|
NUMBER(2,0)
|
N
|
|
1 to 31, repeating
|
| CALENDAR_WEEK_NUMBER
|
NUMBER(2,0)
|
N
|
|
1 to 53, repeating
|
| FISCAL_WEEK_NUMBER
|
NUMBER(2,0)
|
N
|
|
1 to 53, repeating
|
| WEEK_ENDING_DAY
|
DATE
|
N
|
|
date of last day in week, CORRECT ORDER
|
| CALENDAR_MONTH_NUMBER
|
NUMBER(2,0)
|
N
|
|
1 to 12, repeating
|
| FISCAL_MONTH_NUMBER
|
NUMBER(2,0)
|
N
|
|
1 to 12, repeating
|
| CALENDAR_MONTH_DESC
|
VARCHAR2(8)
|
N
|
|
e.g. 1998-01, CORRECT ORDER
|
| FISCAL_MONTH_DESC
|
VARCHAR2(8)
|
N
|
|
e.g. 1998-01, CORRECT ORDER
|
| DAYS_IN_CAL_MONTH
|
NUMBER(,)
|
N
|
|
e.g. 28,31, repeating
|
| DAYS_IN_FIS_MONTH
|
NUMBER(,)
|
N
|
|
e.g. 25,32, repeating
|
| END_OF_CAL_MONTH
|
DATE
|
N
|
|
last day of calendar month
|
| END_OF_FIS_MONTH
|
DATE
|
N
|
|
last day of fiscal month
|
| CALENDAR_MONTH_NAME
|
VARCHAR2(9)
|
N
|
|
January to December, repeating
|
| FISCAL_MONTH_NAME
|
VARCHAR2(9)
|
N
|
|
January to December, repeating
|
| CALENDAR_QUARTER_DESC
|
CHAR(7)
|
N
|
|
e.g. 1998-Q1, CORRECT ORDER
|
| FISCAL_QUARTER_DESC
|
CHAR(7)
|
N
|
|
e.g. 1999-Q3, CORRECT ORDER
|
| DAYS_IN_CAL_QUARTER
|
NUMBER(,)
|
N
|
|
e.g. 88,90, repeating
|
| DAYS_IN_FIS_QUARTER
|
NUMBER(,)
|
N
|
|
e.g. 88,90, repeating
|
| END_OF_CAL_QUARTER
|
DATE
|
N
|
|
last day of calendar quarter
|
| END_OF_FIS_QUARTER
|
DATE
|
N
|
|
last day of fiscal quarter
|
| CALENDAR_QUARTER_NUMBER
|
NUMBER(1,0)
|
N
|
|
1 to 4, repeating
|
| FISCAL_QUARTER_NUMBER
|
NUMBER(1,0)
|
N
|
|
1 to 4, repeating
|
| CALENDAR_YEAR
|
NUMBER(4,0)
|
N
|
|
e.g. 1999, CORRECT ORDER
|
| FISCAL_YEAR
|
NUMBER(4,0)
|
N
|
|
e.g. 1999, CORRECT ORDER
|
| DAYS_IN_CAL_YEAR
|
NUMBER(,)
|
N
|
|
365,366 repeating
|
| DAYS_IN_FIS_YEAR
|
NUMBER(,)
|
N
|
|
e.g. 355,364, repeating
|
| END_OF_CAL_YEAR
|
DATE
|
N
|
|
last day of cal year
|
| END_OF_FIS_YEAR
|
DATE
|
N
|
|
last day of fiscal year
|
| Check constraint
|
Check condition
|
| TIM_CAL_MONTH_DESC_NN
|
"CALENDAR_MONTH_DESC" IS NOT NULL
|
| TIM_CAL_MONTH_NAME_NN
|
"CALENDAR_MONTH_NAME" IS NOT NULL
|
| TIM_CAL_MONTH_NUMBER_NN
|
"CALENDAR_MONTH_NUMBER" IS NOT NULL
|
| TIM_CAL_QUARTER_DESC_NN
|
"CALENDAR_QUARTER_DESC" IS NOT NULL
|
| TIM_CAL_QUARTER_NUMBER_NN
|
"CALENDAR_QUARTER_NUMBER" IS NOT NULL
|
| TIM_CAL_WEEK_NN
|
"CALENDAR_WEEK_NUMBER" IS NOT NULL
|
| TIM_CAL_YEAR_NN
|
"CALENDAR_YEAR" IS NOT NULL
|
| TIM_DAY_IN_MONTH_NN
|
"DAY_NUMBER_IN_MONTH" IS NOT NULL
|
| TIM_DAY_IN_WEEK_NN
|
"DAY_NUMBER_IN_WEEK" IS NOT NULL
|
| TIM_DAY_NAME_NN
|
"DAY_NAME" IS NOT NULL
|
| TIM_DAYS_CAL_MONTH_NN
|
"DAYS_IN_CAL_MONTH" IS NOT NULL
|
| TIM_DAYS_CAL_QUARTER_NN
|
"DAYS_IN_CAL_QUARTER" IS NOT NULL
|
| TIM_DAYS_CAL_YEAR_NN
|
"DAYS_IN_CAL_YEAR" IS NOT NULL
|
| TIM_DAYS_FIS_MONTH_NN
|
"DAYS_IN_FIS_MONTH" IS NOT NULL
|
| TIM_DAYS_FIS_QUARTER_NN
|
"DAYS_IN_FIS_QUARTER" IS NOT NULL
|
| TIM_DAYS_FIS_YEAR_NN
|
"DAYS_IN_FIS_YEAR" IS NOT NULL
|
| TIM_END_OF_CAL_MONTH_NN
|
"END_OF_CAL_MONTH" IS NOT NULL
|
| TIM_END_OF_CAL_QUARTER_NN
|
"END_OF_CAL_QUARTER" IS NOT NULL
|
| TIM_END_OF_CAL_YEAR_NN
|
"END_OF_CAL_YEAR" IS NOT NULL
|
| TIM_END_OF_FIS_MONTH_NN
|
"END_OF_FIS_MONTH" IS NOT NULL
|
| TIM_END_OF_FIS_QUARTER_NN
|
"END_OF_FIS_QUARTER" IS NOT NULL
|
| TIM_END_OF_FIS_YEAR_NN
|
"END_OF_FIS_YEAR" IS NOT NULL
|
| TIM_FIS_MONTH_DESC_NN
|
"FISCAL_MONTH_DESC" IS NOT NULL
|
| TIM_FIS_MONTH_NAME_NN
|
"FISCAL_MONTH_NAME" IS NOT NULL
|
| TIM_FIS_MONTH_NUMBER_NN
|
"FISCAL_MONTH_NUMBER" IS NOT NULL
|
| TIM_FIS_QUARTER_DESC_NN
|
"FISCAL_QUARTER_DESC" IS NOT NULL
|
| TIM_FIS_QUARTER_NUMBER_NN
|
"FISCAL_QUARTER_NUMBER" IS NOT NULL
|
| TIM_FIS_WEEK_NN
|
"FISCAL_WEEK_NUMBER" IS NOT NULL
|
| TIM_FIS_YEAR_NN
|
"FISCAL_YEAR" IS NOT NULL
|
| TIM_WEEK_ENDING_DAY_NN
|
"WEEK_ENDING_DAY" IS NOT NULL
|