Share this page

# FACT_RESOURCE_DEMAND

This table stores daily forecast demand effort values for the position.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
DIM_POSITION | POSITION_ID | PK_POSITIONS_ID
DIM_PROJECTS | PROJECT_ID | PK_PROJECTS_ID
DIM_PROPOSALS | PROPOSAL_ID | PK_ PROPOSALS_ID
DIM_ASSETS | ASSET_ID | PK_ASSETS_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
PK_RESOURCE_DEMAND_ID | Not Null | INT | System-generated identifier
MD_ENTERPRISE_KEY | Not Null | VARCHAR(1000) | Primary key that is mapped to one or more source columns
MD_BUSINESS_KEY | Not Null | INT | Unique identifier for entity
POSITION_ID | Nullable | INT | Unique identifier for positions
POSITION_BUSINESS_KEY | Nullable | VARCHAR(1000) | Foreign key that is mapped to DIM_ POSITIONS
POSITION_ENTERPRISE_KEY | Nullable | INT | Unique identifier for foreign key
DEMAND_DATE | Not Null | DATE | Date for estimated forecast demand
PROJECT_ID | Nullable | INT | Unique identifier for projects
PROJECT_BUSINESS_KEY | Nullable | VARCHAR(1000) | Foreign key that is mapped to DIM_ PROJECTS
PROJECT_ENTERPRISE_KEY | Nullable | INT | Unique identifier for foreign key
PSOPOSAL_ID | Nullable | INT | Unique identifier for proposals
PSOPOSAL_BUSINESS_KEY | Nullable | VARCHAR(1000) | Foreign key that is mapped to DIM_ PROPOSALS table
PSOPOSAL_ENTERPRISE_KEY | Nullable | INT | Unique identifier for foreign key
ASSET_ID | Nullable | INT | Unique identifier for assets
ASSET_BUSINESS_KEY | Nullable | VARCHAR(1000) | Foreign key that is mapped to the DIM_ ASSETS table
ASSET_ENTERPRISE_KEY | Nullable | INT | Unique identifier for foreign key
STAFFING_PROFILE_ID | Not Null | INT | Indicates the position this forecast demand belongs to
DEMAND_VALUE | Not Null | INT | Estimated effort in hours for forecast date. Forecast hours per day. Forecast value of 0 is not stored.
UNMET_DEMAND | Nullable | INT | Unmet demand hours per day
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_DEMAND_ENTERPRISE_XREF_SEQ | MD_ENTERPRISE_KEY
RESOURCE_DEMAND_KEY_LOOKUP_SEQ | PK_ RESOURCE_DEMAND_ID
POSITIONS_ENTERPRISE_XREF_SEQ | POSITION_ENTERPRISE_KEY
POSITIONS_KEY_LOOKUP_SEQ | POSITION_ID
PROJECTS_ENTERPRISE_XREF_SEQ | PROJECT_ENTERPRISE_KEY
PROJECTS_KEY_LOOKUP_SEQ | PROJECT_ID
PROPOSALS_ENTERPRISE_XREF_SEQ | PROPOSAL_ENTERPRISE_KEY
PROPOSALS_KEY_LOOKUP_SEQ | PROPOSAL_ID
ASSETS_ENTERPRISE_XREF_SEQ | ASSET_ENTERPRISE_KEY
ASSETS_KEY_LOOKUP_SEQ | ASSET_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: