DW_EB_X_EBS_COMMON_W_INT_ORG_DH

It stores the current/latest flattenned hierarchy of internal organizations. When 1 organization rolls up into multiple hierarchies, the multiple hierarchies are stored in this table. Each hierarchy is differentiated by "Hierarchy Name".

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.
ASSET_ORG_FLG	VARCHAR2	1 CHAR			Indicates whether organization is an asset organization.
AUX1_CHANGED_ON_DT	TIMESTAMP		6		Auxiliary Changed Date
AUX2_CHANGED_ON_DT	TIMESTAMP		6		Auxiliary Changed Date
AUX3_CHANGED_ON_DT	TIMESTAMP		6		Auxiliary Changed Date
AUX4_CHANGED_ON_DT	TIMESTAMP		6		Auxiliary Changed Date
BALANCING_ENTITY_FLG	VARCHAR2	1 CHAR			Indicates whether organization is a balancing entity.
BASE_ORG_MGR	VARCHAR2	255 CHAR			Base Organization Manager
BASE_ORG_NUM	VARCHAR2	50 CHAR			This is the Base Organization number.
BRANCH_FLG	VARCHAR2	1 CHAR			Indicates if the organization is a branch
BUSINESS_AREA_FLG	VARCHAR2	1 CHAR			Indicates whether organization is a SAP/JDE business area.
BUSINESS_GROUP_FLG	VARCHAR2	1 CHAR			Indicates whether organization is an business group.
BU_FLG	VARCHAR2	1 CHAR			Indicates whether organization is a business unit.
CHANGED_BY_WID	NUMBER		38		Key to User Dim
CHANGED_ON_DT	TIMESTAMP		6		Changed Date
CNTCT_REP_ORG_FLG	VARCHAR2	1 CHAR			Indicates whether organization is a contact representative organization.
COLLECTIONS_BU_FLG	VARCHAR2	1 CHAR			Collections Business Unit Flag
COMPANY_FLG	VARCHAR2	1 CHAR			Indicates whether organization is a financial company.
CONTRACT_BU_FLG	VARCHAR2	1 CHAR			Contract Business Unit Flag
CONTROL_AREA_FLG	VARCHAR2	1 CHAR			Indicates whether organization is a SAP control area.
COST_ORG_FLG	VARCHAR2	1 CHAR			Cost Organization Flag
CREATED_BY_WID	NUMBER		38		Key to User Dim
CREATED_ON_DT	TIMESTAMP		6		Creation Date
CURRENT_FLG	VARCHAR2	1 CHAR			This is a flag for marking dimension records as "Y" in order to represent the current state of a dimension entity. This flag is typically critical for Type II slowly-changing dimensions, as records in a Type II situation tend to be numerous.
CUSTOMER_PAYMENTS_BU_FLG	VARCHAR2	1 CHAR			Customer Payments Business Unit Flag
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, Siebel 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.
DIVN_FLG	VARCHAR2	1 CHAR			Indicates whether organization is a division or department
EFFECTIVE_FROM_DT	TIMESTAMP		6		This column stores the date from which the dimension record is effective. A value is either assigned by Siebel Applications or extracted from the source.
EFFECTIVE_TO_DT	TIMESTAMP		6		This column stores the date up to which the dimension record is effective. A value is either assigned by Siebel Applications or extracted from the source.
ENTERPRISE_FLG	VARCHAR2	1 CHAR			Enterprise Flag
ETL_PROC_WID	NUMBER		38		Oracle System Field. This column is the unique identifier for the specific ETL process used to create or update this data.
EXPENDITURE_ORG_FLG	VARCHAR2	1 CHAR			Expenditure Organization Flag
EXPENSE_BU_FLG	VARCHAR2	1 CHAR			Expense Business Unit Flag
FINANCIAL_BU_FLG	VARCHAR2	1 CHAR			Financial Business Unit Flag
FIN_AREA_FLG	VARCHAR2	1 CHAR			Indicates whether organization is a SAP financial area.
FIXED_HIER_LEVEL	NUMBER		10		This is the fixed hierarchy level.
GOVT_REPT_ENTITY_FLG	VARCHAR2	1 CHAR			Indicates whether organization is a government reporting entity.
HIERARCHY_NAME	VARCHAR2	80 CHAR			This is the hierarchy name.
HIERARCHY_VERSION	VARCHAR2	255 CHAR			This column goves the version of the Hierarchy
HR_ORG_FLG	VARCHAR2	1 CHAR			Indicates whether organization is a human resource organization.
INTEGRATION_ID	VARCHAR2	80 CHAR			This column is the unique identifier of a dimension or fact entity in its source system. In case of composite keys, the value in this column can consist of concatenated parts.
INTERNAL_FLG	VARCHAR2	1 CHAR			Indicates whether organization is internal.
INV_ORG_FLG	VARCHAR2	1 CHAR			Indicates whether organization is an inventory organization.
LEGAL_ENTITY_FLG	VARCHAR2	1 CHAR			Indicates whether organization is a legal entity.
LEVEL_NAME	VARCHAR2	40 CHAR			Level Name
MARKETING_ORG_FLG	VARCHAR2	1 CHAR			Indicates whether organization is a marketing organization.
MATERIALS_MANAGEMENT_BU_FLG	VARCHAR2	1 CHAR			Materials Management Business Unit Flag
MFG_DEPT_FLG	VARCHAR2	1 CHAR			Manufacturing Department Flag
OPERATING_UNIT_FLG	VARCHAR2	1 CHAR			Indicates whether organization is an operating unit.
ORG_HIER10_MGR	VARCHAR2	255 CHAR			Organization Hierarchy10 Manager
ORG_HIER10_NUM	VARCHAR2	50 CHAR			This is the level10 number.
ORG_HIER11_MGR	VARCHAR2	255 CHAR			Organization Hierarchy11 Manager
ORG_HIER11_NUM	VARCHAR2	50 CHAR			This is the level11 number.
ORG_HIER12_MGR	VARCHAR2	255 CHAR			Organization Hierarchy12 Manager
ORG_HIER12_NUM	VARCHAR2	50 CHAR			This is the level12 number.
ORG_HIER13_MGR	VARCHAR2	255 CHAR			Organization Hierarchy13 Manager
ORG_HIER13_NUM	VARCHAR2	50 CHAR			This is the level13 number.
ORG_HIER1_MGR	VARCHAR2	255 CHAR			Organization Hierarchy1 Manager
ORG_HIER1_NUM	VARCHAR2	50 CHAR			This is the level1 number.
ORG_HIER2_MGR	VARCHAR2	255 CHAR			Organization Hierarchy2 Manager
ORG_HIER2_NUM	VARCHAR2	50 CHAR			This is the level2 number.
ORG_HIER3_MGR	VARCHAR2	255 CHAR			Organization Hierarchy3 Manager
ORG_HIER3_NUM	VARCHAR2	50 CHAR			This is the level3 number.
ORG_HIER4_MGR	VARCHAR2	255 CHAR			Organization Hierarchy4 Manager
ORG_HIER4_NUM	VARCHAR2	50 CHAR			This is the level4 number.
ORG_HIER5_MGR	VARCHAR2	255 CHAR			Organization Hierarchy5 Manager
ORG_HIER5_NUM	VARCHAR2	50 CHAR			This is the level5 number.
ORG_HIER6_MGR	VARCHAR2	255 CHAR			Organization Hierarchy6 Manager
ORG_HIER6_NUM	VARCHAR2	50 CHAR			This is the level6 number.
ORG_HIER7_MGR	VARCHAR2	255 CHAR			Organization Hierarchy7 Manager
ORG_HIER7_NUM	VARCHAR2	50 CHAR			This is the level7 number.
ORG_HIER8_MGR	VARCHAR2	255 CHAR			Organization Hierarchy8 Manager
ORG_HIER8_NUM	VARCHAR2	50 CHAR			This is the level8 number.
ORG_HIER9_MGR	VARCHAR2	255 CHAR			Organization Hierarchy9 Manager
ORG_HIER9_NUM	VARCHAR2	50 CHAR			This is the level9 number.
ORG_TOP_NUM	VARCHAR2	50 CHAR			This is the top level number.
ORG_TYPE_CODE	VARCHAR2	50 CHAR			Organization Type Code
PAYABLES_ORG_FLG	VARCHAR2	1 CHAR			Payables Organization Flag
PAYROLL_STATUTORY_UNIT_FLG	VARCHAR2	1 CHAR			Payroll Statutory Unit Flag
PRC_CONTRACT_MANAGEMENT_BU_FLG	VARCHAR2	1 CHAR			PRC Contract Management Business Unit Flag
PRIMARY_FLG	VARCHAR2	1 CHAR			This is the primary hierarchy within a domain value.
PROJECT_BU_FLG	VARCHAR2	1 CHAR			Project Business Unit Flag
PROJECT_EXP_ORG_FLG	VARCHAR2	1 CHAR			Project Expenditure Organization Flag
PROJECT_ORG_FLG	VARCHAR2	1 CHAR			Indicates whether organization is a project organization.
PROJECT_UNIT_FLG	VARCHAR2	1 CHAR			Project Unit Flag
PRTNR_FLG	VARCHAR2	1 CHAR			Indicates whether organization is a partner.
PURCH_ORG_FLG	VARCHAR2	1 CHAR			Indicates whether organization is a purchasing organization.
RECEIVABLES_ORG_FLG	VARCHAR2	1 CHAR			Receivables Organization Flag
RECEIVING_BU_FLG	VARCHAR2	1 CHAR			Receiving Business Unit flag
REPORTING_EST_FLG	VARCHAR2	1 CHAR			Reporting Establishment Flag
REQUISITION_BU_FLG	VARCHAR2	1 CHAR			Requisition Business Unit Flag
RETAIL_FLG	VARCHAR2	1 CHAR			Retail Flag
SALES_AREA_FLG	VARCHAR2	1 CHAR			Indicates whether organization is a SAP sales area.
SALES_GROUP_FLG	VARCHAR2	1 CHAR			Indicates whether organization is a sales group.
SALES_ORG_FLG	VARCHAR2	1 CHAR			Indicates whether organization is a sales organization.
SCD1_WID	NUMBER		38		SCD1 Surrogate Key
SERVICE_ORG_FLG	VARCHAR2	1 CHAR			Indicates whether organization is a service organization.
SET_ID	VARCHAR2	30 CHAR			Set Identifier
SIA_BU_FLG	VARCHAR2	1 CHAR			Student financial BU Flag
SRC_EFF_FROM_DT	TIMESTAMP		6		Source Effective From Date
SRC_EFF_TO_DT	TIMESTAMP		6		Source Effective To Date
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_ORG_MGR	VARCHAR2	255 CHAR			Top Organization Manager
VALUATION_AREA_FLG	VARCHAR2	1 CHAR			Indicates whether organization is a SAP valuation area.
W_HIERARCHY_CLASS	VARCHAR2	50 CHAR			This is the domain value of the Hiearchy Name
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