BRIDGE_HIERARCHY_ORG_UNITS

This table stores many-to-many relationship between specific unit.

Foreign Keys

Primary Key Table	Primary Key Column	Foreign Key Column
DIM_ORG_UNITS	ORG_UNIT_ID	PK_ORG_UNITS_ID

Column Descriptions

Column Name	Data Type	NULLABLE	Description
PK_HIERARCHY_ORG_UNITS_ID	INT	NOT NULL	Unique identifier for manager
MD_BUSINESS_KEY	VARCHAR(1000)	NOT NULL	Primary key that is mapped to one or more source columns
MD_ENTERPRISE_KEY	INT	NOT NULL	Unique identifier for entity
ORG_UNITS_ID	INT	NOT NULL	Unique identifier for manager
ORG_UNITS_BUSINESS_KEY	VARCHAR(1000)	NOT NULL	Foreign key that is mapped to DIM_ORG_UNITS
ORG_UNITS_ENTERPRISE_KEY	INT	NOT NULL	Unique identifier for foreign key
PARENT_ORG_UNITS_ID	INT	NOT NULL	Unique identifier to the parent organization unit
PARENT_ORG_UNITS_BUSINESS_KEY	VARCHAR(1000)	NOT NULL	Foreign key that is mapped to DIM_ORG_UNITS
PARENT_ORG_UNITS_ENTERPRISE_KEY	INT	NOT NULL	Unique identifier for foreign key
ORG_UNIT_LEVEL	INT	NOT NULL	Interval levels
MD_BATCH_ID	INT	NULLABLE	ID of data batch
MD_PROCESS_ID	INT	NULLABLE	ID of ETL process running on a specific task
MD_SOURCE_INSTANCE_ID	INT	NULLABLE	Contnet pack ID of source instance
MD_CREATEDDATE	DATETIME	NULLABLE	Date of the record being inserted
MD_DELETEDDATE	DATETIME	NULLABLE	Date of the record being deleted
MD_LASTMODDATE	DATETIME	NULLABLE	Date of the record being updated
MD_TRANSLASTIND	VARCHAR(1)	NULLABLE	Flags whether it is the latest record after updated by SCD2
MD_TRANSENDDATE	DATETIME	NULLABLE	End date of the record being effective
MD_ACTIVESTATUSIND	VARCHAR(1)	NULLABLE	Flags whether or not the old record is deleted
MD_HASH_CODE_SCD1	VARCHAR(40)	NULLABLE	(Only for dimension table) Hash code that is generated by SCD1 columns
MD_HASH_CODE_SCD2	VARCHAR(40)	NULLABLE	(Only for dimension table) Hash code that is generated by SCD2 columns

Projections

This table uses no projections.

Sequences

This table uses no sequences.