From dbscript Online Help
wikibot
| Table
|
SH.TIMES
|
| Description
|
Time dimension table to support multiple hierarchies and materialized views
|
Columns
| 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
|
Primary Key
| Primary Key
|
Columns
|
| TIMES_PK
|
TIME_ID
|
Check Constraints
| 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
|
|
Detail Tables
| Detail Table
|
Column
|
Referencing Column
|
| SH.COSTS
|
TIME_ID
|
TIME_ID
|
| SH.SALES
|
TIME_ID
|
TIME_ID
|
