DW_EB_X_EBS_COMMON_W_INDUSTRY_DH

DW_EB_X_EBS_COMMON_W_INDUSTRY_DH contains a flattened hierarchy of the industry. Ten levels of the hierarchy are allowed, but the user can extend it easily if required. The lowest level is called Base level, and the highest level is called Top level. The other ones are numbered from 1 to 8.The grain level of this table is at each industry code level. This table is designed to support Type-1 changes out of the box.

Details

Module: Common Tables (EBS_COMMON)

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 record.
AUX1_CHANGED_ON_DT	TIMESTAMP		6		System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table.
AUX2_CHANGED_ON_DT	TIMESTAMP		6		System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table.
AUX3_CHANGED_ON_DT	TIMESTAMP		6		System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table.
AUX4_CHANGED_ON_DT	TIMESTAMP		6		System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table.
BASE_LVL_IND_CODE	VARCHAR2	80 CHAR			The Classification Code of the base level industry in the source system.
BASE_LVL_IND_ID	VARCHAR2	80 CHAR			The INTEGRATION_ID of the base level industry.
CATEGORY	VARCHAR2	30 CHAR			Identifies the classification category name. A classification category is a logical grouping of one or more classification codes. A classification category can be either industrial classification standards or user defined, that could be used to classify a party (Organization or Person).
CHANGED_BY_WID	NUMBER		38		This is a foreign key to the DW_EB_X_EBS_COMMON_W_USER_D dimension indicating the user who last modified the record in the source system.
CHANGED_ON_DT	TIMESTAMP		6		Identifies the date and time when the record was last modified in the source system.
CREATED_BY_WID	NUMBER		38		This is a foreign key to the DW_EB_X_EBS_COMMON_W_USER_D dimension indicating the user who created the record in the source system.
CREATED_ON_DT	TIMESTAMP		6		Identifies the date and time when the record was initially created in the source system.
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.
DELETE_FLG	VARCHAR2	1 CHAR			This flag indicates the deletion status of the record in the source system. A value of "Y" indicates that the record is deleted from the source system and logically deleted from the data warehouse; a value of "N" indicates that the record is active.
ETL_PROC_WID	NUMBER		38		System Field. This column is the unique identifier for the specific ETL process used to create or update this data.
FIXED_HIER_LEVEL	NUMBER		10		Level of this industry code (defined by BASE_LVL_IND_ID) in the current Hierarchy
INTEGRATION_ID	VARCHAR2	100 CHAR
LVL1ANC_IND_CODE	VARCHAR2	80 CHAR			The Classification Code of the level 1 industry in the source system.
LVL1ANC_IND_ID	VARCHAR2	80 CHAR			The INTEGRATION_ID of the level 1 industry.
LVL2ANC_IND_CODE	VARCHAR2	80 CHAR			The Classification Code of the level 2 industry in the source system.
LVL2ANC_IND_ID	VARCHAR2	80 CHAR			The INTEGRATION_ID of the level 2 industry.
LVL3ANC_IND_CODE	VARCHAR2	80 CHAR			The Classification Code of the level 3 industry in the source system.
LVL3ANC_IND_ID	VARCHAR2	80 CHAR			The INTEGRATION_ID of the level 3 industry.
LVL4ANC_IND_CODE	VARCHAR2	80 CHAR			The Classification Code of the level 4 industry in the source system.
LVL4ANC_IND_ID	VARCHAR2	80 CHAR			The INTEGRATION_ID of the level 4 industry.
LVL5ANC_IND_CODE	VARCHAR2	80 CHAR			The Classification Code of the level 5 industry in the source system.
LVL5ANC_IND_ID	VARCHAR2	80 CHAR			The Classification Code of the level 4 industry in the source system.
LVL6ANC_IND_CODE	VARCHAR2	80 CHAR			The Classification Code of the level 6 industry in the source system.
LVL6ANC_IND_ID	VARCHAR2	80 CHAR			The INTEGRATION_ID of the level 6 industry.
LVL7ANC_IND_CODE	VARCHAR2	80 CHAR			The Classification Code of the level 7 industry in the source system.
LVL7ANC_IND_ID	VARCHAR2	80 CHAR			The INTEGRATION_ID of the level 7 industry.
LVL8ANC_IND_CODE	VARCHAR2	80 CHAR			The Classification Code of the level 8 industry in the source system.
LVL8ANC_IND_ID	VARCHAR2	80 CHAR			The INTEGRATION_ID of the level 8 industry.
SET_ID	VARCHAR2	30 CHAR			This column represents a unique identifier used by source systems for the purpose of data sharing, reducing redundancies and minimizing system maintenance tasks, or even to drive data visibility. From a datawarehouse standpoint, the intended use of this column is to drive dimensional data security, primarily.
TENANT_ID	VARCHAR2	80 CHAR			This column is the unique identifier for a Tenant in a multi-tenant environment. This would typically be used in an Application Service Provider (ASP) / Software As a Service (SOAS) model.
TOP_LVL_IND_CODE	VARCHAR2	80 CHAR			The Classification Code of the top level industry in the source system
TOP_LVL_IND_ID	VARCHAR2	80 CHAR			The INTEGRATION_ID of the top level industry.
VERTICAL	VARCHAR2	30 CHAR			Identify which vertical this classification code belongs to.
W_INDUSTRY_CLASS	VARCHAR2	80 CHAR
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