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