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

Contnet 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