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