Share this page

# 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

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: