DW_EB_X_EBS_COMMON_W_ENT_WEEK_D

Dimension table for storing Enterprise Weeks

Details

Module: Common Tables (EBS_COMMON)

Business Name: Enterprise Week Dimension

Key Columns

Key column information is not documented in the supplied metadata.

Columns

Columns
Name	Datatype	Length	Precision	Not Null	Comments
ROW_WID	NUMBER		38	True	Surrogate key to uniquely identify a Mcal Week record. This key is formed by appending Mcal Week to the Mcal Year in YYYYWK format.
DATASOURCE_NUM_ID	NUMBER		10		This column is the unique identifier of the source system from which data was extracted. In order to be able to trace the data back to its source, Oracle recommends that you define separate unique source IDs for each of your different source instances
ENT_CAL_CLASS	VARCHAR2	20 CHAR			Identifies the category of calendar. Valid values are 'Generated', ''File Sourced','OLTP Sourced'
ENT_CAL_ID	VARCHAR2	80 CHAR			Identifies the accounting calendar
ENT_CAL_NAME	VARCHAR2	30 CHAR			Identifies the name of the accounting calendar
ENT_CAL_WID	NUMBER		38		ID assigned within the warehouse to uniquely identify a calendar
ENT_DIM_MNTH_NUM	NUMBER		10		Cumulative Month Number getting added up through the years.
ENT_DIM_QTR_NUM	NUMBER		10		Cumulative Quarter Number getting added up through the years.
ENT_DIM_WEEK_NUM	NUMBER		10		Cumulative Week Number getting added up through the years.
ENT_DIM_YEAR_NUM	NUMBER		10		Cumulative Year Number getting added up through the years.
ENT_FST_WK_FR_KEY	NUMBER		10		Identifies the julian date of the first day of the first Mcal Week of the same Mcal year this Mcal week belongs to.
ENT_FST_WK_TO_KEY	NUMBER		10		Identifies the julian date of the last day of the first Mcal Week of the same Mcal year this Mcal week belongs to.
ENT_HALF	NUMBER		2		Identifies the half of Mcal Year that this week belongs. Possible values are 1 or 2.
ENT_MONTH	NUMBER		2		Identifies the Mcal Month this week belongs to. Possible values are 1 through 12.
ENT_PERIOD_AGO_WID	NUMBER		38		Surrogate key of enterprise previour period
ENT_PERIOD_END_DAY_WID	NUMBER		38		Surrogate key of enterprise period end day.
ENT_PERIOD_END_DT	TIMESTAMP		6		Identifies the Last Date of the Mcal Period.
ENT_PERIOD_END_DT_WID	NUMBER		38		Identifies the Date surrogate key in YYYYMMDD of the last day of the Mcal Period
ENT_PERIOD_NAME	VARCHAR2	240 CHAR			Name of the Mcal period
ENT_PERIOD_NUM	NUMBER		10		Mcal Period Number
ENT_PERIOD_OF_QUARTER	NUMBER		10		Identifies the Mcal period of the quarter to which this week belongs to
ENT_PERIOD_OF_YEAR	NUMBER		10		Identifies the Mcal period of the year to which this week belongs to
ENT_PERIOD_START_DAY_WID	NUMBER		38		Surrogate key of enterprise period start day.
ENT_PERIOD_START_DT	TIMESTAMP		6		Identifies the First Date of the Mcal Period.
ENT_PERIOD_START_DT_WID	NUMBER		38		Identifies the Date surrogate key in YYYYMMDD of the first day of the Mcal Period
ENT_PERIOD_TOTAL_DAYS	NUMBER		10		Total number of days in the Mcal period
ENT_PERIOD_TOTAL_WEEKS	NUMBER		10		Total number of weeks in the Mcal period
ENT_PERIOD_TYPE	VARCHAR2	50 CHAR			Identifies the accounting period type
ENT_PERIOD_WID	NUMBER		38		Surrogate key to DW_EB_X_EBS_COMMON_W_MCAL_PERIOD_D
ENT_PER_NAME_HALF	VARCHAR2	50 CHAR			Identifies the Mcal Half year Period Name. For example, 1980 Half1, 1980 Half2, etc.
ENT_PER_NAME_MNTH	VARCHAR2	50 CHAR			Month Period Name in YYYY/MM format. For example, "1980 / 01", "1980 / 10", etc.
ENT_PER_NAME_QTR	VARCHAR2	50 CHAR			Identifies the Mcal Quarter Period Name. For example, "1980 Q 1".
ENT_PER_NAME_TER	VARCHAR2	50 CHAR			Identifies the Mcal Trimester Period Name. For example, "1980T1".
ENT_PER_NAME_WEEK	VARCHAR2	50 CHAR			Identifies the Mcal Week Period Name. For example, "1980 Week01".
ENT_PER_NAME_YEAR	VARCHAR2	50 CHAR			Identifies the Mcal Year Period Name in YYYY format. For example, "1980".
ENT_PRIOR_PERIOD_WID	NUMBER		38		Surrogate key of enterprise prior period
ENT_PRIOR_QTR_WID	NUMBER		38		Surrogate key of the prior quarter
ENT_PRIOR_WEEK_WID	NUMBER		38		Surrogate key of enterprise prior week
ENT_PRIOR_YEAR_WID	NUMBER		38		Surrogate key of prior year
ENT_QTR	NUMBER		2		Identifies the Quarter of Mcal Year this week belongs to. Possible values are 1, 2, 3 and 4.
ENT_QTR_AGO_WID	NUMBER		38		Thw ROW_WID of the same quarter in the previous year, e.g. the W1 2007 prior period is W2 2006
ENT_QTR_END_DAY_WID	NUMBER		38		Surrogate key of enterprise quarter end day
ENT_QTR_END_DT	TIMESTAMP		6		Identifies the End Date of the Mcal Quarter.
ENT_QTR_END_DT_WID	NUMBER		38		Identifies the End Date Surrogate key in YYYYMMDD format of the Mcal Quarter
ENT_QTR_NUM	NUMBER		10		Mcal Quarter Number
ENT_QTR_START_DAY_WID	NUMBER		38		Surrogate key of enterprise quarter start day
ENT_QTR_START_DT	TIMESTAMP		6		Identifies the Start Date of the Mcal Quarter.
ENT_QTR_START_DT_WID	NUMBER		38		Identifies the Start Date Surrogate key in YYYYMMDD format of the Mcal Month
ENT_QTR_WID	NUMBER		38		Surrogate key to DW_EB_X_EBS_COMMON_W_MCAL_QTR_D
ENT_TRIMESTER	NUMBER		2		Identifies the Mcal trimester this week belongs to. Possible values are 1, 2 and 3.
ENT_WEEK	NUMBER		2		Week this week belongs to. Possible values are 1 through 52.
ENT_WEEK_AGO_WID	NUMBER		38		Surrogate key of enterprise previous week.
ENT_WEEK_END_DAY_WID	NUMBER		38		Surrogate key of enterprise week end day
ENT_WEEK_END_DT	TIMESTAMP		6		Identifies the End Date of the Mcal Week.
ENT_WEEK_END_DT_KEY	NUMBER		10		Identifies the Julian Date of the last day of the Mcal Week.
ENT_WEEK_END_DT_WID	NUMBER		38		Identifies the Date surrogate key in YYYYMMDD format of the last day of the Mcal Week
ENT_WEEK_KEY	NUMBER		10		Uniquely identifies enterprise week
ENT_WEEK_OF_PERIOD	NUMBER		10		Mcal week of the period
ENT_WEEK_OF_QTR	NUMBER		10		Mcal week of the quarter
ENT_WEEK_OF_YEAR	NUMBER		10		Week this week belongs to. Possible values are 1 through 52.
ENT_WEEK_START_DAY_WID	NUMBER		38		Surrogate key of enterprise week start day
ENT_WEEK_START_DT	TIMESTAMP		6		Identifies the First Date of the Mcal Week.
ENT_WEEK_START_DT_KEY	NUMBER		10		Identifies the Julian Date of the first day of the Mcal Week.
ENT_WEEK_START_DT_WID	NUMBER		38		Identifies the Date surrogate key in YYYYMMDD of the first day of the Mcal Week
ENT_YEAR	NUMBER		4		Identifies the Mcal Year this week belongs to in YYYY format.
ENT_YEAR_END_DAY_WID	NUMBER		38		Surrogate key of enterprise year end day
ENT_YEAR_END_DT	TIMESTAMP		6		Identifies the End Date of the Mcal Year.
ENT_YEAR_END_DT_WID	NUMBER		38		Identifies the End Date Surrogate key in YYYYMMDD format of the Mcal Year
ENT_YEAR_START_DAY_WID	NUMBER		38		Surrogate key of enterprise year start day
ENT_YEAR_START_DT	TIMESTAMP		6		Identifies the Start Date of the Mcal Year.
ENT_YEAR_START_DT_WID	NUMBER		38		Identifies the Start Date Surrogate key in YYYYMMDD format of the Mcal Year
ENT_YEAR_TOTAL_DAYS	NUMBER		10		Total number of days in this Mcal year
ENT_YEAR_TOTAL_WEEKS	NUMBER		10		Total number of weeks in this Mcal year
ENT_YEAR_WID	NUMBER		38		Surrogate key to DW_EB_X_EBS_COMMON_W_MCAL_YEAR_D
FST_WK_ENT_MNTH_FLG	VARCHAR2	1 CHAR			Identifies if the week is the first week of the Mcal Month or not.
FST_WK_ENT_QTR_FLG	VARCHAR2	1 CHAR			Identifies if the week is the first week of the Mcal Year or not.
FST_WK_ENT_YEAR_FLG	VARCHAR2	1 CHAR			Identifies if the week is the first week of the Mcal Year or not.
LAST_WK_ENT_MNTH_FLG	VARCHAR2	1 CHAR			Identifies if the week is the last week of the Mcal Month or not.
LAST_WK_ENT_QTR_FLG	VARCHAR2	1 CHAR			Identifies if the week is the last week of the Mcal Quarter or not.
LAST_WK_ENT_YEAR_FLG	VARCHAR2	1 CHAR			Identifies if the week is the first week of the Mcal Year or not.
TENANT_ID	VARCHAR2	80 CHAR			This column is the unique identifier for a Tenant in a multitenant environment. This would typically be used in an Application Service Provider (ASP) / Software As a Service (SOAS)
W_CURRENT_ENT_MONTH_CODE	VARCHAR2	50 CHAR			This code gets updated to Current or Next or Previous month depending on whether the period is previous , current or next month with respect to the current date. Default value is '__NOT_APPLICABLE__'.
W_CURRENT_ENT_PERIOD_CODE	VARCHAR2	50 CHAR			This code gets updated to Current or Next or Previous period depending on whether the period is previous , current or next period with respect to the current date. Default value is '__NOT_APPLICABLE__'.
W_CURRENT_ENT_QTR_CODE	VARCHAR2	50 CHAR			This code gets updated to Current or Next or Previous month depending on whether the period is previous , current or next month with respect to the current date. Default value is '__NOT_APPLICABLE__'.
W_CURRENT_ENT_WEEK_CODE	VARCHAR2	50 CHAR			This is the code which indicates whether the Mcal Week is Current or Next or Previous to the current Mcal Week. This code gets updated everyday and the default value is '__NOT_APPLICABLE__'.
W_CURRENT_ENT_YEAR_CODE	VARCHAR2	50 CHAR			This is the code which indicates whether the Mcal Year is Current or Next or Previous to the current Mcal Year. This code gets updated everyday and the default value is '__NOT_APPLICABLE__'.
X_CUSTOM	VARCHAR2	10 CHAR			This column is used as a generic field for customer extensions.
W$_INSERT_DT	TIMESTAMP		6
W$_UPDATE_DT	TIMESTAMP		6