Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

wikibot

TableSH.TIMES
DescriptionTime dimension table to support multiple hierarchies and materialized views

Columns

ColumnData TypeNullableDefaultDescription
TIME_IDDATE(7)not null primary key; day date, finest granularity, CORRECT ORDER
DAY_NAMEVARCHAR2(9)not null Monday to Sunday, repeating
DAY_NUMBER_IN_WEEKNUMBER(1, 0)not null 1 to 7, repeating
DAY_NUMBER_IN_MONTHNUMBER(2, 0)not null 1 to 31, repeating
CALENDAR_WEEK_NUMBERNUMBER(2, 0)not null 1 to 53, repeating
FISCAL_WEEK_NUMBERNUMBER(2, 0)not null 1 to 53, repeating
WEEK_ENDING_DAYDATE(7)not null date of last day in week, CORRECT ORDER
WEEK_ENDING_DAY_IDNUMBERnot null  
CALENDAR_MONTH_NUMBERNUMBER(2, 0)not null 1 to 12, repeating
FISCAL_MONTH_NUMBERNUMBER(2, 0)not null 1 to 12, repeating
CALENDAR_MONTH_DESCVARCHAR2(8)not null e.g. 1998-01, CORRECT ORDER
CALENDAR_MONTH_IDNUMBERnot null  
FISCAL_MONTH_DESCVARCHAR2(8)not null e.g. 1998-01, CORRECT ORDER
FISCAL_MONTH_IDNUMBERnot null  
DAYS_IN_CAL_MONTHNUMBERnot null e.g. 28,31, repeating
DAYS_IN_FIS_MONTHNUMBERnot null e.g. 25,32, repeating
END_OF_CAL_MONTHDATE(7)not null last day of calendar month
END_OF_FIS_MONTHDATE(7)not null last day of fiscal month
CALENDAR_MONTH_NAMEVARCHAR2(9)not null January to December, repeating
FISCAL_MONTH_NAMEVARCHAR2(9)not null January to December, repeating
CALENDAR_QUARTER_DESCCHAR(7)not null e.g. 1998-Q1, CORRECT ORDER
CALENDAR_QUARTER_IDNUMBERnot null  
FISCAL_QUARTER_DESCCHAR(7)not null e.g. 1999-Q3, CORRECT ORDER
FISCAL_QUARTER_IDNUMBERnot null  
DAYS_IN_CAL_QUARTERNUMBERnot null e.g. 88,90, repeating
DAYS_IN_FIS_QUARTERNUMBERnot null e.g. 88,90, repeating
END_OF_CAL_QUARTERDATE(7)not null last day of calendar quarter
END_OF_FIS_QUARTERDATE(7)not null last day of fiscal quarter
CALENDAR_QUARTER_NUMBERNUMBER(1, 0)not null 1 to 4, repeating
FISCAL_QUARTER_NUMBERNUMBER(1, 0)not null 1 to 4, repeating
CALENDAR_YEARNUMBER(4, 0)not null e.g. 1999, CORRECT ORDER
CALENDAR_YEAR_IDNUMBERnot null  
FISCAL_YEARNUMBER(4, 0)not null e.g. 1999, CORRECT ORDER
FISCAL_YEAR_IDNUMBERnot null  
DAYS_IN_CAL_YEARNUMBERnot null 365,366 repeating
DAYS_IN_FIS_YEARNUMBERnot null e.g. 355,364, repeating
END_OF_CAL_YEARDATE(7)not null last day of cal year
END_OF_FIS_YEARDATE(7)not null last day of fiscal year

Primary Key

Primary KeyColumns
TIMES_PKTIME_ID

Check Constraints

Check ConstraintExpressionDescription
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 TableColumnReferencing Column
SH.COSTSTIME_IDTIME_ID
SH.SALESTIME_IDTIME_ID

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.