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 |