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

Contnet 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