Share this page

# BRIDGE_ORG_UNIT_MEMBERS

This table stores references to the immediate members of an Organization Unit. It is a cross table between the DIM_ORG_UNITS table and the DIM_PERSON table.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
DIM_PERSON | PERSON_ID | PK_PERSON_ID
DIM_ORG_UNITS | ORG_UNIT_ID | PK_ORG_UNITS_ID
DIM_RESOURCES | RESOURCE_ID | PK_ RESOURCES_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
PK_ORG_UNIT_MEMBERS_ID | Nullable | INT | System-generated identifier
MD_BUSINESS_KEY | Nullable | VARCHAR(1000) | Primary key that is mapped to one or more source columns
MD_ENTERPRISE_KEY | Nullable | INT | Unique identifier for entity
ORG_UNIT_ID | Nullable | INT | Unique identifier for org unit
ORG_UNIT_BUSINESS_KEY | Nullable | VARCHAR(1000) | Foreign key that is mapped to DIM_ ORG_UNITE
ORG_UNIT_ENTERPRISE_KEY | Nullable | INT | Unique identifier for foreign key
PERSON_ID | Nullable | INT | Unique identifier for person
PERSON_BUSINESS_KEY | Nullable | VARCHAR(1000) | Foreign key that is mapped to dim_person
PERSON_ENTERPRISE_KEY | Nullable | INT | Unique identifier for foreign key
RESOURCE_ID | Nullable | INT | Unique identifier for resources
RESOURCE_BUSINESS_KEY | Nullable | VARCHAR(1000) | Foreign key that is mapped to dim_resources
RESOURCE_ENTERPRISE_KEY | Nullable | INT | Unique identifier for foreign key
MD_BATCH_ID | Nullable | INT | ID of data batch
MD_PROCESS_ID | Nullable | INT | ID of ETL process running on a specific task
MD_SOURCE_INSTANCE_ID | Nullable | INT | Content pack ID of source instance
MD_CREATEDDATE | Nullable | DATETIME | Date of the record being inserted
MD_DELETEDDATE | Nullable | DATETIME | Date of the record being deleted
MD_LASTMODDATE | Nullable | DATETIME | Date of the record being updated
MD_TRANSLASTIND | NULLABLE | VARCHAR(1) | Flags whether it is the latest record after updated by SCD2
MD_TRANSENDDATE | NULLABLE | DATETIME | End date of the record being effective
MD_ACTIVESTATUSIND | NULLABLE | VARCHAR(1) | Flags whether or not the old record is deleted
MD_HASH_CODE_SCD1 | NULLABLE | VARCHAR(40) | (Only for dimension table) Hash code that is generated by SCD1 columns
MD_HASH_CODE_SCD2 | NULLABLE | VARCHAR(40) | (Only for dimension table) Hash code that is generated by SCD2 columns

## Projections

Table Name | Projection Type | Projection Name
--- | --- | ---
DIM_ORG_UNIT | Super | DIM_ORG_UNITS_node0001
DIM_ORG_UNIT | Customized | TBD

## Sequences

Sequence Name | Sequence Type
--- | ---
ORG_UNITS_ENTERPRISE_XREF_SEQ | MD_ENTERPRISE_KEY
ORG_UNITS_KEY_LOOKUP_SEQ | PK_ORG_UNITS_ID
ORG_UNITS_HIERARCHY_SEQ | PARENT_ORG_UNIT_ID

## Projections

This table uses no projections.

## Sequences

Sequence Name | Sequence Type
--- | ---
ORG_UNIT_MEMBERS_ENTERPRISE_XREF_SEQ | MD_ENTERPRISE_KEY
ORG_UNIT_MEMBERS_KEY_LOOKUP_SEQ | PK_ ORG_UNIT_MEMBERS_ID
ORG_UNITS_ENTERPRISE_XREF_SEQ | ORG_UNIT_ENTERPRISE_KEY
ORG_UNITS_KEY_LOOKUP_SEQ | PK_ ORG_UNIT_ID
PERSON_ENTERPRISE_XREF_SEQ | PERSON_ENTERPRISE_KEY
PERSON_KEY_LOOKUP_SEQ | PK_PERSON_ID
RESOURCES_ENTERPRISE_XREF_SEQ | RESOURCE_ENTERPRISE_KEY
RESOURCES_KEY_LOOKUP_SEQ | PK_RESOURCE_ID

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: