Share this page
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 |
