Share this page
FACT_RESOURCE_ACTUAL_EFFORT
This table stores the daily actual effort (in hours) for staffing profile resource.
Foreign Keys
|
Primary Key Table |
Primary Key Column |
Foreign Key Column |
|---|---|---|
|
DIM_ RESOURCES |
RESOURCE_ID |
PK_RESOURCES_ID |
|
DIM_PROJECTS |
PROJECT_ID |
PK_PROJECTS_ID |
Column Descriptions
|
Column Name |
Null? |
Data Type |
Description |
|---|---|---|---|
|
PK_RESOURCE_ACTUAL_EFFORT_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_RESOURCES |
|
RESOURCE _ENTERPRISE_KEY |
NULLABLE |
INT |
Unique identifier for foreign key |
|
ITEM_TYPE |
NULLABLE |
VARCHAR(255) |
Indicates the type of item. Valid values are REQUEST, PACKAGE, TASK, PROJECT, and MISC. |
|
ITEM_ID |
NULLABLE |
INT |
Identifier of the item type |
|
ITEM_BUSINESS_KEY |
NULLABLE |
VARCHAR(1000) |
Foreign key that is mapped to the related item table |
|
ITEM_ENTERPRISE_KEY |
NULLABLE |
INT |
Unique identifier for the foreign key |
|
DATE |
NULLABLE |
DATE |
Indicates the date of the effort being made |
|
EFFORT |
NULLABLE |
FLOAT |
Stores the actual effort for a single cell of data that appears on the time breakdown of a time sheet item |
|
SOURCE |
NULLABLE |
VARCHAR(20) |
TIME MANAGEMENT/WORK PLAN/ REQUEST/ STAFFING PROFILE |
|
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_ACTUAL_EFFORT_ENTERPRISE_XREF_SEQ |
MD_ENTERPRISE_KEY |
|
RESOURCE_ACTUAL_EFFORT_KEY_LOOKUP_SEQ |
PK_ RESOURCE_ACTUAL_EFFORT_ID |
| RESOURCES_ENTERPRISE_XREF_SEQ | RESOURCE_ENTERPRISE_KEY |
| RESOURCES_KEY_LOOKUP_SEQ | RESOURCE_ID |
| PROJECTS_ENTERPRISE_XREF_SEQ | PROJECT_ENTERPRISE_KEY |
| PROJECTS_KEY_LOOKUP_SEQ | PROJECT_ID |
