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