Share this page
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.
