Welcome
Guest
, you are in:
<root>
•
Login
devio dbscript ScrewTurn Wiki
Navigation
¶
Main Page
Random Page
Create a new Page
All Pages
Categories
Navigation Paths
Administration
File Management
Create Account
Search the wiki
»
Back
SH TIMES (table)
Modified on 2011/08/27 12:11
by
wikibot
Categorized as
Uncategorized
== wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- valign="top" | '''Table''' | SH.TIMES |- valign="top" | '''Description''' | Time dimension table to support multiple hierarchies and materialized views |} === Columns === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Column''' | '''Data Type''' | '''Nullable''' | '''Default''' | '''Description''' |- valign="top" | TIME_ID | DATE(7) | not null | | primary key; day date, finest granularity, CORRECT ORDER |- valign="top" | DAY_NAME | VARCHAR2(9) | not null | | Monday to Sunday, repeating |- valign="top" | DAY_NUMBER_IN_WEEK | NUMBER(1, 0) | not null | | 1 to 7, repeating |- valign="top" | DAY_NUMBER_IN_MONTH | NUMBER(2, 0) | not null | | 1 to 31, repeating |- valign="top" | CALENDAR_WEEK_NUMBER | NUMBER(2, 0) | not null | | 1 to 53, repeating |- valign="top" | FISCAL_WEEK_NUMBER | NUMBER(2, 0) | not null | | 1 to 53, repeating |- valign="top" | WEEK_ENDING_DAY | DATE(7) | not null | | date of last day in week, CORRECT ORDER |- valign="top" | WEEK_ENDING_DAY_ID | NUMBER | not null | | |- valign="top" | CALENDAR_MONTH_NUMBER | NUMBER(2, 0) | not null | | 1 to 12, repeating |- valign="top" | FISCAL_MONTH_NUMBER | NUMBER(2, 0) | not null | | 1 to 12, repeating |- valign="top" | CALENDAR_MONTH_DESC | VARCHAR2(8) | not null | | e.g. 1998-01, CORRECT ORDER |- valign="top" | CALENDAR_MONTH_ID | NUMBER | not null | | |- valign="top" | FISCAL_MONTH_DESC | VARCHAR2(8) | not null | | e.g. 1998-01, CORRECT ORDER |- valign="top" | FISCAL_MONTH_ID | NUMBER | not null | | |- valign="top" | DAYS_IN_CAL_MONTH | NUMBER | not null | | e.g. 28,31, repeating |- valign="top" | DAYS_IN_FIS_MONTH | NUMBER | not null | | e.g. 25,32, repeating |- valign="top" | END_OF_CAL_MONTH | DATE(7) | not null | | last day of calendar month |- valign="top" | END_OF_FIS_MONTH | DATE(7) | not null | | last day of fiscal month |- valign="top" | CALENDAR_MONTH_NAME | VARCHAR2(9) | not null | | January to December, repeating |- valign="top" | FISCAL_MONTH_NAME | VARCHAR2(9) | not null | | January to December, repeating |- valign="top" | CALENDAR_QUARTER_DESC | CHAR(7) | not null | | e.g. 1998-Q1, CORRECT ORDER |- valign="top" | CALENDAR_QUARTER_ID | NUMBER | not null | | |- valign="top" | FISCAL_QUARTER_DESC | CHAR(7) | not null | | e.g. 1999-Q3, CORRECT ORDER |- valign="top" | FISCAL_QUARTER_ID | NUMBER | not null | | |- valign="top" | DAYS_IN_CAL_QUARTER | NUMBER | not null | | e.g. 88,90, repeating |- valign="top" | DAYS_IN_FIS_QUARTER | NUMBER | not null | | e.g. 88,90, repeating |- valign="top" | END_OF_CAL_QUARTER | DATE(7) | not null | | last day of calendar quarter |- valign="top" | END_OF_FIS_QUARTER | DATE(7) | not null | | last day of fiscal quarter |- valign="top" | CALENDAR_QUARTER_NUMBER | NUMBER(1, 0) | not null | | 1 to 4, repeating |- valign="top" | FISCAL_QUARTER_NUMBER | NUMBER(1, 0) | not null | | 1 to 4, repeating |- valign="top" | CALENDAR_YEAR | NUMBER(4, 0) | not null | | e.g. 1999, CORRECT ORDER |- valign="top" | CALENDAR_YEAR_ID | NUMBER | not null | | |- valign="top" | FISCAL_YEAR | NUMBER(4, 0) | not null | | e.g. 1999, CORRECT ORDER |- valign="top" | FISCAL_YEAR_ID | NUMBER | not null | | |- valign="top" | DAYS_IN_CAL_YEAR | NUMBER | not null | | 365,366 repeating |- valign="top" | DAYS_IN_FIS_YEAR | NUMBER | not null | | e.g. 355,364, repeating |- valign="top" | END_OF_CAL_YEAR | DATE(7) | not null | | last day of cal year |- valign="top" | END_OF_FIS_YEAR | DATE(7) | not null | | last day of fiscal year |} === Primary Key === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Primary Key''' | '''Columns''' |- valign="top" | TIMES_PK | TIME_ID |} === Check Constraints === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Check Constraint''' | '''Expression''' | '''Description''' |- valign="top" | SYS_C005088 | "TIME_ID" IS NOT NULL | |- valign="top" | SYS_C005089 | "DAY_NAME" IS NOT NULL | |- valign="top" | SYS_C005090 | "DAY_NUMBER_IN_WEEK" IS NOT NULL | |- valign="top" | SYS_C005091 | "DAY_NUMBER_IN_MONTH" IS NOT NULL | |- valign="top" | SYS_C005092 | "CALENDAR_WEEK_NUMBER" IS NOT NULL | |- valign="top" | SYS_C005093 | "FISCAL_WEEK_NUMBER" IS NOT NULL | |- valign="top" | SYS_C005094 | "WEEK_ENDING_DAY" IS NOT NULL | |- valign="top" | SYS_C005095 | "WEEK_ENDING_DAY_ID" IS NOT NULL | |- valign="top" | SYS_C005096 | "CALENDAR_MONTH_NUMBER" IS NOT NULL | |- valign="top" | SYS_C005097 | "FISCAL_MONTH_NUMBER" IS NOT NULL | |- valign="top" | SYS_C005098 | "CALENDAR_MONTH_DESC" IS NOT NULL | |- valign="top" | SYS_C005099 | "CALENDAR_MONTH_ID" IS NOT NULL | |- valign="top" | SYS_C005100 | "FISCAL_MONTH_DESC" IS NOT NULL | |- valign="top" | SYS_C005101 | "FISCAL_MONTH_ID" IS NOT NULL | |- valign="top" | SYS_C005102 | "DAYS_IN_CAL_MONTH" IS NOT NULL | |- valign="top" | SYS_C005103 | "DAYS_IN_FIS_MONTH" IS NOT NULL | |- valign="top" | SYS_C005104 | "END_OF_CAL_MONTH" IS NOT NULL | |- valign="top" | SYS_C005105 | "END_OF_FIS_MONTH" IS NOT NULL | |- valign="top" | SYS_C005106 | "CALENDAR_MONTH_NAME" IS NOT NULL | |- valign="top" | SYS_C005107 | "FISCAL_MONTH_NAME" IS NOT NULL | |- valign="top" | SYS_C005108 | "CALENDAR_QUARTER_DESC" IS NOT NULL | |- valign="top" | SYS_C005109 | "CALENDAR_QUARTER_ID" IS NOT NULL | |- valign="top" | SYS_C005110 | "FISCAL_QUARTER_DESC" IS NOT NULL | |- valign="top" | SYS_C005111 | "FISCAL_QUARTER_ID" IS NOT NULL | |- valign="top" | SYS_C005112 | "DAYS_IN_CAL_QUARTER" IS NOT NULL | |- valign="top" | SYS_C005113 | "DAYS_IN_FIS_QUARTER" IS NOT NULL | |- valign="top" | SYS_C005114 | "END_OF_CAL_QUARTER" IS NOT NULL | |- valign="top" | SYS_C005115 | "END_OF_FIS_QUARTER" IS NOT NULL | |- valign="top" | SYS_C005116 | "CALENDAR_QUARTER_NUMBER" IS NOT NULL | |- valign="top" | SYS_C005117 | "FISCAL_QUARTER_NUMBER" IS NOT NULL | |- valign="top" | SYS_C005118 | "CALENDAR_YEAR" IS NOT NULL | |- valign="top" | SYS_C005119 | "CALENDAR_YEAR_ID" IS NOT NULL | |- valign="top" | SYS_C005120 | "FISCAL_YEAR" IS NOT NULL | |- valign="top" | SYS_C005121 | "FISCAL_YEAR_ID" IS NOT NULL | |- valign="top" | SYS_C005122 | "DAYS_IN_CAL_YEAR" IS NOT NULL | |- valign="top" | SYS_C005123 | "DAYS_IN_FIS_YEAR" IS NOT NULL | |- valign="top" | SYS_C005124 | "END_OF_CAL_YEAR" IS NOT NULL | |- valign="top" | SYS_C005125 | "END_OF_FIS_YEAR" IS NOT NULL | |} === Detail Tables === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Detail Table''' | '''Column''' | '''Referencing Column''' |- valign="top" | [[SH COSTS (table)|SH.COSTS]] | TIME_ID | TIME_ID |- valign="top" | [[SH SALES (table)|SH.SALES]] | TIME_ID | TIME_ID |}
ScrewTurn Wiki
version 3.0.1.400. Some of the icons created by
FamFamFam
.