Difference between revisions of "SH.TIMES (table)"

From dbscript Online Help
Jump to: navigation, search
 
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
−
|-
+
|- valign="top"
 
| '''Table
 
| '''Table
 
| SH.TIMES
 
| SH.TIMES
Line 8: Line 8:
 
| '''Description
 
| '''Description
 
| Time dimension table to support multiple hierarchies and materialized views
 
| Time dimension table to support multiple hierarchies and materialized views
−
|-
 
 
|}
 
|}
−
 
  
 
=== Columns ===
 
=== Columns ===
Line 20: Line 18:
 
| '''Default
 
| '''Default
 
| '''Description
 
| '''Description
−
+
 
−
|-
+
|- valign="top"
 
| TIME_ID
 
| TIME_ID
 
| DATE(7)
 
| DATE(7)
Line 27: Line 25:
 
|  
 
|  
 
| primary key; day date, finest granularity, CORRECT ORDER
 
| primary key; day date, finest granularity, CORRECT ORDER
−
|-
+
|- valign="top"
 
| DAY_NAME
 
| DAY_NAME
 
| VARCHAR2(9)
 
| VARCHAR2(9)
Line 33: Line 31:
 
|  
 
|  
 
| Monday to Sunday, repeating
 
| Monday to Sunday, repeating
−
|-
+
|- valign="top"
 
| DAY_NUMBER_IN_WEEK
 
| DAY_NUMBER_IN_WEEK
 
| NUMBER(1, 0)
 
| NUMBER(1, 0)
Line 39: Line 37:
 
|  
 
|  
 
| 1 to 7, repeating
 
| 1 to 7, repeating
−
|-
+
|- valign="top"
 
| DAY_NUMBER_IN_MONTH
 
| DAY_NUMBER_IN_MONTH
 
| NUMBER(2, 0)
 
| NUMBER(2, 0)
Line 45: Line 43:
 
|  
 
|  
 
| 1 to 31, repeating
 
| 1 to 31, repeating
−
|-
+
|- valign="top"
 
| CALENDAR_WEEK_NUMBER
 
| CALENDAR_WEEK_NUMBER
 
| NUMBER(2, 0)
 
| NUMBER(2, 0)
Line 51: Line 49:
 
|  
 
|  
 
| 1 to 53, repeating
 
| 1 to 53, repeating
−
|-
+
|- valign="top"
 
| FISCAL_WEEK_NUMBER
 
| FISCAL_WEEK_NUMBER
 
| NUMBER(2, 0)
 
| NUMBER(2, 0)
Line 57: Line 55:
 
|  
 
|  
 
| 1 to 53, repeating
 
| 1 to 53, repeating
−
|-
+
|- valign="top"
 
| WEEK_ENDING_DAY
 
| WEEK_ENDING_DAY
 
| DATE(7)
 
| DATE(7)
Line 63: Line 61:
 
|  
 
|  
 
| date of last day in week, CORRECT ORDER
 
| date of last day in week, CORRECT ORDER
−
|-
+
|- valign="top"
 
| WEEK_ENDING_DAY_ID
 
| WEEK_ENDING_DAY_ID
 
| NUMBER
 
| NUMBER
Line 69: Line 67:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| CALENDAR_MONTH_NUMBER
 
| CALENDAR_MONTH_NUMBER
 
| NUMBER(2, 0)
 
| NUMBER(2, 0)
Line 75: Line 73:
 
|  
 
|  
 
| 1 to 12, repeating
 
| 1 to 12, repeating
−
|-
+
|- valign="top"
 
| FISCAL_MONTH_NUMBER
 
| FISCAL_MONTH_NUMBER
 
| NUMBER(2, 0)
 
| NUMBER(2, 0)
Line 81: Line 79:
 
|  
 
|  
 
| 1 to 12, repeating
 
| 1 to 12, repeating
−
|-
+
|- valign="top"
 
| CALENDAR_MONTH_DESC
 
| CALENDAR_MONTH_DESC
 
| VARCHAR2(8)
 
| VARCHAR2(8)
Line 87: Line 85:
 
|  
 
|  
 
| e.g. 1998-01, CORRECT ORDER
 
| e.g. 1998-01, CORRECT ORDER
−
|-
+
|- valign="top"
 
| CALENDAR_MONTH_ID
 
| CALENDAR_MONTH_ID
 
| NUMBER
 
| NUMBER
Line 93: Line 91:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| FISCAL_MONTH_DESC
 
| FISCAL_MONTH_DESC
 
| VARCHAR2(8)
 
| VARCHAR2(8)
Line 99: Line 97:
 
|  
 
|  
 
| e.g. 1998-01, CORRECT ORDER
 
| e.g. 1998-01, CORRECT ORDER
−
|-
+
|- valign="top"
 
| FISCAL_MONTH_ID
 
| FISCAL_MONTH_ID
 
| NUMBER
 
| NUMBER
Line 105: Line 103:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| DAYS_IN_CAL_MONTH
 
| DAYS_IN_CAL_MONTH
 
| NUMBER
 
| NUMBER
Line 111: Line 109:
 
|  
 
|  
 
| e.g. 28,31, repeating
 
| e.g. 28,31, repeating
−
|-
+
|- valign="top"
 
| DAYS_IN_FIS_MONTH
 
| DAYS_IN_FIS_MONTH
 
| NUMBER
 
| NUMBER
Line 117: Line 115:
 
|  
 
|  
 
| e.g. 25,32, repeating
 
| e.g. 25,32, repeating
−
|-
+
|- valign="top"
 
| END_OF_CAL_MONTH
 
| END_OF_CAL_MONTH
 
| DATE(7)
 
| DATE(7)
Line 123: Line 121:
 
|  
 
|  
 
| last day of calendar month
 
| last day of calendar month
−
|-
+
|- valign="top"
 
| END_OF_FIS_MONTH
 
| END_OF_FIS_MONTH
 
| DATE(7)
 
| DATE(7)
Line 129: Line 127:
 
|  
 
|  
 
| last day of fiscal month
 
| last day of fiscal month
−
|-
+
|- valign="top"
 
| CALENDAR_MONTH_NAME
 
| CALENDAR_MONTH_NAME
 
| VARCHAR2(9)
 
| VARCHAR2(9)
Line 135: Line 133:
 
|  
 
|  
 
| January to December, repeating
 
| January to December, repeating
−
|-
+
|- valign="top"
 
| FISCAL_MONTH_NAME
 
| FISCAL_MONTH_NAME
 
| VARCHAR2(9)
 
| VARCHAR2(9)
Line 141: Line 139:
 
|  
 
|  
 
| January to December, repeating
 
| January to December, repeating
−
|-
+
|- valign="top"
 
| CALENDAR_QUARTER_DESC
 
| CALENDAR_QUARTER_DESC
 
| CHAR(7)
 
| CHAR(7)
Line 147: Line 145:
 
|  
 
|  
 
| e.g. 1998-Q1, CORRECT ORDER
 
| e.g. 1998-Q1, CORRECT ORDER
−
|-
+
|- valign="top"
 
| CALENDAR_QUARTER_ID
 
| CALENDAR_QUARTER_ID
 
| NUMBER
 
| NUMBER
Line 153: Line 151:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| FISCAL_QUARTER_DESC
 
| FISCAL_QUARTER_DESC
 
| CHAR(7)
 
| CHAR(7)
Line 159: Line 157:
 
|  
 
|  
 
| e.g. 1999-Q3, CORRECT ORDER
 
| e.g. 1999-Q3, CORRECT ORDER
−
|-
+
|- valign="top"
 
| FISCAL_QUARTER_ID
 
| FISCAL_QUARTER_ID
 
| NUMBER
 
| NUMBER
Line 165: Line 163:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| DAYS_IN_CAL_QUARTER
 
| DAYS_IN_CAL_QUARTER
 
| NUMBER
 
| NUMBER
Line 171: Line 169:
 
|  
 
|  
 
| e.g. 88,90, repeating
 
| e.g. 88,90, repeating
−
|-
+
|- valign="top"
 
| DAYS_IN_FIS_QUARTER
 
| DAYS_IN_FIS_QUARTER
 
| NUMBER
 
| NUMBER
Line 177: Line 175:
 
|  
 
|  
 
| e.g. 88,90, repeating
 
| e.g. 88,90, repeating
−
|-
+
|- valign="top"
 
| END_OF_CAL_QUARTER
 
| END_OF_CAL_QUARTER
 
| DATE(7)
 
| DATE(7)
Line 183: Line 181:
 
|  
 
|  
 
| last day of calendar quarter
 
| last day of calendar quarter
−
|-
+
|- valign="top"
 
| END_OF_FIS_QUARTER
 
| END_OF_FIS_QUARTER
 
| DATE(7)
 
| DATE(7)
Line 189: Line 187:
 
|  
 
|  
 
| last day of fiscal quarter
 
| last day of fiscal quarter
−
|-
+
|- valign="top"
 
| CALENDAR_QUARTER_NUMBER
 
| CALENDAR_QUARTER_NUMBER
 
| NUMBER(1, 0)
 
| NUMBER(1, 0)
Line 195: Line 193:
 
|  
 
|  
 
| 1 to 4, repeating
 
| 1 to 4, repeating
−
|-
+
|- valign="top"
 
| FISCAL_QUARTER_NUMBER
 
| FISCAL_QUARTER_NUMBER
 
| NUMBER(1, 0)
 
| NUMBER(1, 0)
Line 201: Line 199:
 
|  
 
|  
 
| 1 to 4, repeating
 
| 1 to 4, repeating
−
|-
+
|- valign="top"
 
| CALENDAR_YEAR
 
| CALENDAR_YEAR
 
| NUMBER(4, 0)
 
| NUMBER(4, 0)
Line 207: Line 205:
 
|  
 
|  
 
| e.g. 1999, CORRECT ORDER
 
| e.g. 1999, CORRECT ORDER
−
|-
+
|- valign="top"
 
| CALENDAR_YEAR_ID
 
| CALENDAR_YEAR_ID
 
| NUMBER
 
| NUMBER
Line 213: Line 211:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| FISCAL_YEAR
 
| FISCAL_YEAR
 
| NUMBER(4, 0)
 
| NUMBER(4, 0)
Line 219: Line 217:
 
|  
 
|  
 
| e.g. 1999, CORRECT ORDER
 
| e.g. 1999, CORRECT ORDER
−
|-
+
|- valign="top"
 
| FISCAL_YEAR_ID
 
| FISCAL_YEAR_ID
 
| NUMBER
 
| NUMBER
Line 225: Line 223:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| DAYS_IN_CAL_YEAR
 
| DAYS_IN_CAL_YEAR
 
| NUMBER
 
| NUMBER
Line 231: Line 229:
 
|  
 
|  
 
| 365,366 repeating
 
| 365,366 repeating
−
|-
+
|- valign="top"
 
| DAYS_IN_FIS_YEAR
 
| DAYS_IN_FIS_YEAR
 
| NUMBER
 
| NUMBER
Line 237: Line 235:
 
|  
 
|  
 
| e.g. 355,364, repeating
 
| e.g. 355,364, repeating
−
|-
+
|- valign="top"
 
| END_OF_CAL_YEAR
 
| END_OF_CAL_YEAR
 
| DATE(7)
 
| DATE(7)
Line 243: Line 241:
 
|  
 
|  
 
| last day of cal year
 
| last day of cal year
−
|-
+
|- valign="top"
 
| END_OF_FIS_YEAR
 
| END_OF_FIS_YEAR
 
| DATE(7)
 
| DATE(7)
Line 256: Line 254:
 
| '''Primary Key
 
| '''Primary Key
 
| '''Columns
 
| '''Columns
−
|-
+
|- valign="top"
 
| TIMES_PK
 
| TIMES_PK
 
| TIME_ID
 
| TIME_ID
Line 267: Line 265:
 
| '''Expression
 
| '''Expression
 
| '''Description
 
| '''Description
−
+
 
−
|-
+
|- valign="top"
 
| SYS_C005088
 
| SYS_C005088
 
| "TIME_ID" IS NOT NULL
 
| "TIME_ID" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005089
 
| SYS_C005089
 
| "DAY_NAME" IS NOT NULL
 
| "DAY_NAME" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005090
 
| SYS_C005090
 
| "DAY_NUMBER_IN_WEEK" IS NOT NULL
 
| "DAY_NUMBER_IN_WEEK" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005091
 
| SYS_C005091
 
| "DAY_NUMBER_IN_MONTH" IS NOT NULL
 
| "DAY_NUMBER_IN_MONTH" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005092
 
| SYS_C005092
 
| "CALENDAR_WEEK_NUMBER" IS NOT NULL
 
| "CALENDAR_WEEK_NUMBER" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005093
 
| SYS_C005093
 
| "FISCAL_WEEK_NUMBER" IS NOT NULL
 
| "FISCAL_WEEK_NUMBER" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005094
 
| SYS_C005094
 
| "WEEK_ENDING_DAY" IS NOT NULL
 
| "WEEK_ENDING_DAY" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005095
 
| SYS_C005095
 
| "WEEK_ENDING_DAY_ID" IS NOT NULL
 
| "WEEK_ENDING_DAY_ID" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005096
 
| SYS_C005096
 
| "CALENDAR_MONTH_NUMBER" IS NOT NULL
 
| "CALENDAR_MONTH_NUMBER" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005097
 
| SYS_C005097
 
| "FISCAL_MONTH_NUMBER" IS NOT NULL
 
| "FISCAL_MONTH_NUMBER" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005098
 
| SYS_C005098
 
| "CALENDAR_MONTH_DESC" IS NOT NULL
 
| "CALENDAR_MONTH_DESC" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005099
 
| SYS_C005099
 
| "CALENDAR_MONTH_ID" IS NOT NULL
 
| "CALENDAR_MONTH_ID" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005100
 
| SYS_C005100
 
| "FISCAL_MONTH_DESC" IS NOT NULL
 
| "FISCAL_MONTH_DESC" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005101
 
| SYS_C005101
 
| "FISCAL_MONTH_ID" IS NOT NULL
 
| "FISCAL_MONTH_ID" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005102
 
| SYS_C005102
 
| "DAYS_IN_CAL_MONTH" IS NOT NULL
 
| "DAYS_IN_CAL_MONTH" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005103
 
| SYS_C005103
 
| "DAYS_IN_FIS_MONTH" IS NOT NULL
 
| "DAYS_IN_FIS_MONTH" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005104
 
| SYS_C005104
 
| "END_OF_CAL_MONTH" IS NOT NULL
 
| "END_OF_CAL_MONTH" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005105
 
| SYS_C005105
 
| "END_OF_FIS_MONTH" IS NOT NULL
 
| "END_OF_FIS_MONTH" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005106
 
| SYS_C005106
 
| "CALENDAR_MONTH_NAME" IS NOT NULL
 
| "CALENDAR_MONTH_NAME" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005107
 
| SYS_C005107
 
| "FISCAL_MONTH_NAME" IS NOT NULL
 
| "FISCAL_MONTH_NAME" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005108
 
| SYS_C005108
 
| "CALENDAR_QUARTER_DESC" IS NOT NULL
 
| "CALENDAR_QUARTER_DESC" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005109
 
| SYS_C005109
 
| "CALENDAR_QUARTER_ID" IS NOT NULL
 
| "CALENDAR_QUARTER_ID" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005110
 
| SYS_C005110
 
| "FISCAL_QUARTER_DESC" IS NOT NULL
 
| "FISCAL_QUARTER_DESC" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005111
 
| SYS_C005111
 
| "FISCAL_QUARTER_ID" IS NOT NULL
 
| "FISCAL_QUARTER_ID" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005112
 
| SYS_C005112
 
| "DAYS_IN_CAL_QUARTER" IS NOT NULL
 
| "DAYS_IN_CAL_QUARTER" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005113
 
| SYS_C005113
 
| "DAYS_IN_FIS_QUARTER" IS NOT NULL
 
| "DAYS_IN_FIS_QUARTER" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005114
 
| SYS_C005114
 
| "END_OF_CAL_QUARTER" IS NOT NULL
 
| "END_OF_CAL_QUARTER" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005115
 
| SYS_C005115
 
| "END_OF_FIS_QUARTER" IS NOT NULL
 
| "END_OF_FIS_QUARTER" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005116
 
| SYS_C005116
 
| "CALENDAR_QUARTER_NUMBER" IS NOT NULL
 
| "CALENDAR_QUARTER_NUMBER" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005117
 
| SYS_C005117
 
| "FISCAL_QUARTER_NUMBER" IS NOT NULL
 
| "FISCAL_QUARTER_NUMBER" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005118
 
| SYS_C005118
 
| "CALENDAR_YEAR" IS NOT NULL
 
| "CALENDAR_YEAR" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005119
 
| SYS_C005119
 
| "CALENDAR_YEAR_ID" IS NOT NULL
 
| "CALENDAR_YEAR_ID" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005120
 
| SYS_C005120
 
| "FISCAL_YEAR" IS NOT NULL
 
| "FISCAL_YEAR" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005121
 
| SYS_C005121
 
| "FISCAL_YEAR_ID" IS NOT NULL
 
| "FISCAL_YEAR_ID" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005122
 
| SYS_C005122
 
| "DAYS_IN_CAL_YEAR" IS NOT NULL
 
| "DAYS_IN_CAL_YEAR" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005123
 
| SYS_C005123
 
| "DAYS_IN_FIS_YEAR" IS NOT NULL
 
| "DAYS_IN_FIS_YEAR" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005124
 
| SYS_C005124
 
| "END_OF_CAL_YEAR" IS NOT NULL
 
| "END_OF_CAL_YEAR" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005125
 
| SYS_C005125
 
| "END_OF_FIS_YEAR" IS NOT NULL
 
| "END_OF_FIS_YEAR" IS NOT NULL
Line 428: Line 426:
 
| '''Column
 
| '''Column
 
| '''Referencing Column
 
| '''Referencing Column
−
+
 
−
|-
+
|- valign="top"
 
| [[SH.COSTS_(table)|SH.COSTS]]
 
| [[SH.COSTS_(table)|SH.COSTS]]
 
| TIME_ID
 
| TIME_ID
 
| TIME_ID
 
| TIME_ID
−
|-
+
|- valign="top"
 
| [[SH.SALES_(table)|SH.SALES]]
 
| [[SH.SALES_(table)|SH.SALES]]
 
| TIME_ID
 
| TIME_ID
 
| TIME_ID
 
| TIME_ID
 
|}
 
|}

Latest revision as of 07:16, 24 June 2010

wikibot[edit]

Table SH.TIMES
Description Time dimension table to support multiple hierarchies and materialized views

Columns[edit]

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[edit]

Primary Key Columns
TIMES_PK TIME_ID

Check Constraints[edit]

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[edit]

Detail Table Column Referencing Column
SH.COSTS TIME_ID TIME_ID
SH.SALES TIME_ID TIME_ID
Retrieved from "http://dbshelp.devio.at/index.php?title=SH.TIMES_(table)&oldid=2825"