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