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 |