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