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

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: