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 |
