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.

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: