1. Tables and Views for Project Management
  2. PJR_ACTUAL_HOURS_INTERFACE

PJR_ACTUAL_HOURS_INTERFACE

This is an interface table of project enterprise labor resource actual hours PJR_ACTUAL_HOURS.

Details

  • Schema: FUSION

  • Object owner: PJR

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

PJR_ACTUAL_HOURS_INTERFAC_PK

XFACE_REC_ID

Columns

Name Datatype Length Precision Not-null Comments
XFACE_REC_ID NUMBER 18 Yes System-generated unique resource interface ID.
EXPENDITURE_ITEM_ID NUMBER 18 Expenditure Item identifier , imported from PJC_TXN_XFACE_ALL table.
ACT_HRS_SRC VARCHAR2 64 Source of actual hours. A value of 'ORA_PJR_PROJECT_COSTING' indicates that the source of actual hours is Oracle Fusion Project Costing Application.'ORA_PJR_SPREADSHEET_IMPORT' indicates that the source is a spreadsheet.
RESOURCE_ID NUMBER 18 Identifier of the project enterprise labor resource who reported the actual hours worked.
RESOURCE_DISPLAY_NAME VARCHAR2 240 Display Name of the project enterprise labor resource who reported the actual hours worked.
RESOURCE_EMAIL VARCHAR2 240 Email of the project enterprise labor resource who reported the actual hours worked.
HCM_PERSON_ID NUMBER 18 Identifier of the HCM person who is associated with the project enterprise labor resource who reported the actual hours worked.
PROJECT_ID NUMBER 18 Identifier of the project for which the project enterprise labor resource reported actual hours worked.
PROJECT_NUMBER VARCHAR2 25 Number of the project for which the project enterprise labor resource reported actual hours worked.
PROJECT_NAME VARCHAR2 240 Name of the project for which the project enterprise labor resource reported actual hours worked.
TASK_ID NUMBER 18 Identifier of the task for which the project enterprise labor resource reported actual hours worked.
TASK_NAME VARCHAR2 240 Name of the task for which the project enterprise labor resource reported actual hours worked.
WORK_DATE DATE Date on which the project enterprise labor resource worked.
UTILIZATION_DATE DATE Date that is associated with the actual hours worked for utilization reporting purposes. If no value is specified, then the utilization date is based on the work date.
ACTUAL_HOURS_WK_CATEGORY VARCHAR2 240 Category for the type of activity that is represented by the actual hours worked.
ACTUAL_HOURS_WK_CATEGORY_CODE VARCHAR2 80 Code for the type of activity that is represented by the actual hours worked.
QUANTITY NUMBER Total actual hours worked that the resource reports for a day. The actual hours worked can be positive or negative with a maximum of two decimal places.
COMMENTS VARCHAR2 240 Information about the actual hours reported.
UTILIZATION_FLAG VARCHAR2 1 Indicates whether the actual hours reported are eligible to be included in utilization calculations for the resource.
BILLING_FLAG VARCHAR2 1 Indicates whether the actual hours reported are eligible to be billed.
ORGNAL_TRANSACTION_REF VARCHAR2 120 Reference to the transaction details in the originating source system.
ADJUSTMENT_FLAG VARCHAR2 1 Indicates if the actual hours reported represent an adjustment to existing actual hours for a resource.
ADJUSTED_TRANSACTION_REF VARCHAR2 120 Reference to the transaction that this transaction adjusts.
ENTERPRISE_ID NUMBER 18 Enterprise identifier that uniquely identifies a tenant in a multi-tenant environment.
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.
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.
LOAD_STATUS VARCHAR2 32 Yes Processing status of the resource record.
LOAD_REQUEST_ID NUMBER 18 Yes Constant token for each insertion into the interface table.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.

Indexes

Index Uniqueness Tablespace Columns
PJR_ACTHRS_INT_N1 Non Unique FUSION_TS_TX_IDX LOAD_REQUEST_ID, REQUEST_ID, LOAD_STATUS
PJR_ACTHRS_INT_U1 Unique FUSION_TS_TX_IDX XFACE_REC_ID