FACT_RESOURCE_CAPACITY

This table stores the daily capacity (in hours) for staffing profile resource allocation.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

DIM_ RESOURCE_POOLS

RESOURCE_POOL_ID

PK_ RESOURCE_POOLS_ID

DIM_ RESOURCES

RESOURCE_ID

PK_ RESOURCE_ID

Column Descriptions

Column Name

Null?

Data Type

Description

PK_RESOURCE_CAPACITY_ID

Nullable

INT

System-generated identifier

 

MD_BUSINESS_ KEY

Nullable

VARCHAR (1000)

Primary key that is mapped to one or more source columns

 

MD_ENTERPRISE_ KEY

Nullable

INT

Unique identifier for entity

RESOURCE_ID

Nullable

INT

Unique identifier for resource

RESOURCE _ BUSINESS_KEY

Nullable

VARCHAR (1000)

Foreign key that is mapped to DIM_RESOURCE

 

RESOURCE_ ENTERPRISE_KEY

Nullable

INT

Unique identifier for foreign key

 

RESOURCE_POOL_ ID

Nullable

INT

Unique identifier for resource pool

RESOURCE_POOL_ BUSINESS_KEY

Nullable

VARCHAR (1000)

Foreign key that is mapped to DIM_RESOURCE_POOLS

 

RESOURCE_POOL_ ENTERPRISE_KEY

Nullable

INT

Unique identifier for foreign key

 

DATE

Nullable

DATE

Date of the resource’s capacity

DEFAULT_ CAPACITY

Nullable

NUMERIC

Resource’s default capacity

ALLOCATION

Nullable

NUMERIC

Resource’s allocation effort per day

Column Name

Null?

Data Type

Column name

AVAILABLE_ CAPACITY

Nullable

NUMERIC

Negative means resource is over allocated.

RESOURCE_POOL_ AVAILABLE CAPACITY

Nullable

NUMERIC

For resource pool, the negative AVAILABLE_ CAPACITY is 0.

MD_BATCH_ID

Nullable

INT

ID of data batch

MD_PROCESS_ID

Nullable

INT

ID of ETL process running on a specific task

MD_SOURCE_ INSTANCE_ID

Nullable

INT

Contnet pack ID of source instance

MD_ CREATEDDATE

Nullable

DATETIME

Date of the record being inserted

MD_DELETEDDATE

Nullable

DATETIME

Date of the record being deleted

MD_ LASTMODDDATE

Nullable

DATETIME

Date of the record being updated

MD_ ACTIVESTATUSIND

Nullable

VARCHAR (1)

Flags whether or not the old record is deleted

MD_HASH_CODE

Nullable

VARCHAR (40)

Hash code that is generated

Projections

This table uses no projections.

Sequences

Sequence Name

Sequence Type

RESOURCE_CAPACITY_ENTERPRISE_XREF_SEQ

MD_ENTERPRISE_KEY

RESOURCE_CAPACITY_KEY_LOOKUP_SEQ

PK_ RESOURCE_CAPACITY_ID

RESOURCE_POOLS_ENTERPRISE_XREF_SEQ

RESOURCE_POOL_ENTERPRISE_KEY

RESOURCE_POOLS_KEY_LOOKUP_SEQ

RESOURCE_POOL_ID

RESOURCES_ENTERPRISE_XREF_SEQ

RESOURCE_ENTERPRISE_KEY

RESOURCES_KEY_LOOKUP_SEQ

RESOURCE_ID