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

Contnet 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