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

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_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