PJT_PROJECT_RESOURCE_H

History Table that stores different versions of Project Resources - used to store the PRE and POST resource unification snapshot of the PJT_PROJECT_RESOURCE table.

Details

Schema: FUSION
Object owner: PJT
Object type: TABLE
Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
PJT_PROJECT_RESOURCE_H_PK	PROJ_RESOURCE_ID, UPG_CONTEXT

Columns

Name	Datatype	Length	Precision	Not-null	Comments
PROJ_RESOURCE_ID	NUMBER		18	Yes	System-generated that uniquely identifies a resouce to project assignment
DEFAULT_STAFFING_OWNER_FLAG	NUMBER		1		DEFAULT_STAFFING_OWNER_FLAG
EXPENSE_AMOUNT	NUMBER				Amount planned for a project resource assignment
LABOR_EFFORT	NUMBER				Effort associated with the resource on a project
LABOR_COST_RATE	NUMBER				Cost rate associated with the project resource
LABOR_BILL_RATE	NUMBER				Bill rate associated with the project resource
ALLOCATION	NUMBER				Allocation of a resource to a project
RESOURCE_ID	NUMBER		18	Yes	The ID of the resource assigned to a specific project
BILLABLE_PERCENT_REASON_CODE	VARCHAR2	30			Reason Code for the billable percentage of the project resource being less than 100%.
BILLABLE_PERCENT	NUMBER				Percentage of the billable scheduled time of the project resource.
ASSIGNMENT_TYPE	VARCHAR2	30			Type of assignment of the project resource. Possible values are BILLABLE or NON-BILLABLE or null.
PROJECT_ID	NUMBER		18		Project ID the resource is assigned to
SCHEDULE_ID	NUMBER		18		Calendar ID of the resource to project assignment
UNIT_OF_MEASURE	VARCHAR2	30			used for local expenditure or local person
CURRENCY_CODE	VARCHAR2	15			currency code for USER_DEFINED resources
RATE	NUMBER		22		Rate for USER_DEFINED resources
PROJECT_ROLE_ID	NUMBER		18		FK to project role table
START_DATE_ACTIVE	DATE				The date when the resource becomes active
END_DATE_ACTIVE	DATE				The date when the resource becomes inactive
PERSON_ID	NUMBER		18		FK to NAMED_PERSON type of resource defined in TCA
PARTY_ID	NUMBER		18		FK to NAMED_PERSON type of resource defined in TCA
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
RESOURCE_REQUEST_ID	NUMBER		18		Resource request identifier
ENTERPRISE_ID	NUMBER		18	Yes	Enterprise ID
PROJECT_RESOURCE_REQUEST_ID	NUMBER		18		FK to PJR_RESOURCE_REQUESTS request ID
ASSIGNMENT_STATUS_CODE	VARCHAR2	30			Assignmet lookup status code
TRACK_TIME_FLAG	VARCHAR2	1			Flag to indicate whether the application must track missing time for the team member. Valid values are Y and N.
UP_REQUEST_ID	NUMBER		18		To show the security assignment status on the PRS page for the user provisioning of the user based on his role in the PRS.
UPG_CONTEXT	VARCHAR2	10		Yes	This column will be used to save the upgrade sync up context like 'PRE' or 'POST'. The 'PRE' /'POST' context means the data is before/after running the upgrade sync up for Resource unification.

Indexes

Index	Uniqueness	Tablespace	Columns
PJT_PROJECT_RESOURCE_H_U2	Unique	Default	PROJ_RESOURCE_ID, UPG_CONTEXT