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 |
