Share this page

# 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 | Content 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

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: