BRIDGE_RESOURCE_POOLS_RESOURCES

This table stores all the relationship between resource pools and resources.

Foreign Keys

Primary Key Table	Primary Key Column	Foreign Key Column
DIM_ RESOURCE	RESOURCE _ID	PK_RESOURCES_ID
DIM_ RESOURCE_POOL	RESOURCE_POOL_ID	PK_RESOURCE_POOLS_ID

Column Descriptions

Column Name	Null?	Data Type	Description	SCD2
PK_RESOURCE_POOLS_RESOURCES_ ID	Nullable	INT	System-generated identifier	Yes
MD_BUSINESS_KEY	Nullable	VARCHAR (1000)	Primary key that is mapped to one or more source columns	Yes
MD_ENTERPRISE_KEY	Nullable	INT	Unique identifier for entity	Yes
RESOURCE_ID	Nullable	INT	Unique identifier for resource	Yes
RESOURCE_BUSINESS_KEY	Nullable	VARCHAR (1000)	Foreign key that is mapped to DIM_RESOURCES	Yes
RESOURCE_ENTERPRISE_KEY	Nullable	INT	Unique identifier for foreign key	Yes
RESOURCE_POOL_ID	Nullable	INT	Unique identifier for resource pool	Yes
RESOURCE_POOL_BUSINESS_KEY	Nullable	VARCHAR (1000)	Foreign key that is mapped to DIM_RESOURCE_POOLS	Yes
RESOURCE_POOL_ENTERPRISE_KEY	Nullable	INT	Unique identifier for foreign key	Yes
RESOURCE_START_DATE	Nullable	DATE	Indicates the start date of the resource in the associated resource pool	No
RESOUCE_FINISH_DATE	Nullable	DATE	Indicates the end date of the resource in this resource pool	No
RESOUCE_DISTRIBUTION_PERCENT	Nullable	FLOAT	The participation percentage of the resource in this resource pool	Yes
MD_BATCH_ID	Nullable	INT	ID of data batch	No
MD_PROCESS_ID	Nullable	INT	ID of ETL process running on a specific task	No
MD_SOURCE_INSTANCE_ID	Nullable	INT	Content pack ID of source instance	No
MD_CREATEDDATE	Nullable	DATETIME	Date of the record being inserted	No
MD_DELETEDDATE	Nullable	DATETIME	Date of the record being deleted	No
MD_LASTMODDATE	Nullable	DATETIME	Date of the record being updated	No
MD_TRANSLASTIND	Nullable	VARCHAR(1)	Flags whether it is the latest record after updated by SCD2	No
MD_TRANSENDDATE	Nullable	DATETIME	End date of the record being effective	No
MD_ACTIVESTATUSIND	Nullable	VARCHAR(1)	Flags whether or not the old record is deleted	No
MD_HASH_CODE_SCD1	Nullable	VARCHAR(40)	(Only for dimension table) Hash code that is generated by SCD1 columns	No
MD_HASH_CODE_SCD2	Nullable	VARCHAR(40)	(Only for dimension table) Hash code that is generated by SCD2 columns	No

Projections

This table uses no projections.

Sequences

Sequence Name	Sequence Type
RESOURCE_POOL_RESOURCES_ENTERPRISE_XREF_SEQ	MD_ENTERPRISE_KEY
RESOURCE_POOL_RESOURCES_KEY_LOOKUP_SEQ	PK_RESOURCE_POOL_RESOURCES_ID
RESOURCES_ENTERPRISE_XREF_SEQ	RESOURCE_ENTERPRISE_KEY
RESOURCES_KEY_LOOKUP_SEQ	RESOURCE_ID
RESOURCE_POOLS_ENTERPRISE_XREF_SEQ	RESOURCE_POOL_ENTERPRISE_KEY
RESOURCE_POOLS_KEY_LOOKUP_SEQ	RESOURCE_POOL_ID