DIM_RESOURCE_POOLS

This table stores all the resource pools in the system. Resource pools contains resources that can be allocated to projects as needed.

Foreign Keys

Primary Key Table	Primary Key Column	Foreign Key Column
DIM_ORG_UNITS	ORG_UNIT _ID	PK_ ORG_UNITS_ID
DIM_ RESOURCE_POOLS	PARENT_RESOURCE_POOL _ID	PK_RESOURCE_POOLS _ID

Column Descriptions

Column Name	Null?	Data Type	Description	SCD2
PK_RESOURCE_POOLS_ID	Not Null	INT	System-generated identifier	No
MD_BUSINESS_KEY	Not Null	VARCHAR (1000)	Primary key that is mapped to one or more source columns	No
MD_ENTERPRISE_KEY	Not Null	INT	Unique identifier for entity	No
RESOURCE_POOL_NAME	Not Null	VARCHAR (260)	User entered name for the resource pool.	Yes
DESCRIPTION	Nullable	VARCHAR (650)	User entered description for this resource pool.	No
USER_DATA1-20	Nullable	VARCHAR (255)	User data segment	No
VISIBLE_USER_DATA1-20	Nullable	VARCHAR (255)	User data segment	No
PARENT_RESOURCE_POOL_ID	Nullable	INT	Unique identifier to the parent resource pool for this resource pool.	Yes
PARENT_RESOURCE_POOL_BUSINESS_ KEY	Nullable	VARCHAR (1000)	Foreign key that is mapped to dim_resource_pools	Yes
PARENT_RESOURCE_POOL_ ENTERPRISE_KEY	Nullable	INT	Unique identifier for foreign key	Yes
REGION_ID	Not Null	INT	Indicates the region this resource pool is used for.	Yes
REGION_NAME	Not Null	VARCHAR (100)	Region Name	Yes
ORG_UNIT_ID	Nullable	INT	Unique identifier to the organization unit this resource pool belongs to.	Yes
ORG_UNIT_BUSINESS_KEY	Nullable	VARCHAR (1000)	Foreign key that is mapped to dim_org_units	Yes
ORG_UNIT_ENTERPRISE_KEY	Nullable	INT	Unique identifier for foreign key	Yes
ORG_UNIT_NAME	Nullable	VARCHAR (200)	organization unit name	Yes
SYSTEM_DEFAULT_FLAG	Nullable	VARCHAR(1)	Indicates whether this is the system default resource pool.	No
ENABLED_FLAG	Nullable	VARCHAR(1)	Flag that indicates if this resource pool is enabled or not.	No
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_POOLS_ENTERPRISE_XREF_SEQ	MD_ENTERPRISE_KEY
RESOURCE_POOLS_KEY_LOOKUP_SEQ	PK_RESOURCE_POOLS_ID
ORG_UNITS_ENTERPRISE_XREF_SEQ	SKILL_ENTERPRISE_KEY
ORG_UNITS_KEY_LOOKUP_SEQ	PK_SKILL_ID
RESOURCE_POOLS_HIERARCHY_SEQ	PARENT_RESOURCE_POOL_ID