1. Tables and Views for Project Management
  2. PJR_RESOURCE_COND_RESULTS_DTL

PJR_RESOURCE_COND_RESULTS_DTL

Detailed exceptions that the process to maintain project enterprise labor resources encounters. Users can review persons for whom exceptions are encountered and messages that explain the reasons.

Details

  • Schema: FUSION

  • Object owner: PJR

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

PJR_RESOURCE_COND_RLT_DTL_PK

RESULT_ID, RESULT_LINE_ID

Columns

Name Datatype Length Precision Not-null Comments
ENTERPRISE_ID NUMBER 18 Yes Enterprise identifier of the result detail of the last successfully-completed run of the process to maintain project enterprise labor resources. The enterprise ID uniquely identifies a tenant in a multi-tenant environment.
RESULT_ID NUMBER 18 Yes Automatically-generated unique identifier of each exception encountered during the last successfully-completed run of the process to maintain project enterprise labor resources.
RESULT_LINE_ID NUMBER 18 Yes Automatically-generated unique identifier of each exception line encountered. Used to differentiate identical values in the RESULT_ID column.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
PERSON_DISPLAY_NAME VARCHAR2 240 Name of the person for whom a resource exception was encountered during the process to maintain project enterprise labor resources.
PERSON_NUMBER VARCHAR2 30 Number of the person for whom a resource exception was encountered during the process to maintain project enterprise labor resources.
MESSAGE_NAME VARCHAR2 30 Yes Message text that explains a resource exception that was encountered during the process to maintain project enterprise labor resources.
MESSAGE_TOKEN_NAME1 VARCHAR2 30 Token name used in a resource exception message that was generated during the process to maintain project enterprise labor resources.
MESSAGE_TOKEN_VALUE1 VARCHAR2 240 Token value used in a resource exception message that was generated during the process to maintain project enterprise labor resources.
TOKEN_DATA_TYPE1 VARCHAR2 20 Token data type used in a resource exception message that was generated during the process to maintain project enterprise labor resources.
MESSAGE_TOKEN_NAME2 VARCHAR2 30 Token name used in a resource exception message that was generated during the process to maintain project enterprise labor resources.
MESSAGE_TOKEN_VALUE2 VARCHAR2 240 Token value used in a resource exception message that was generated during the process to maintain project enterprise labor resources.
TOKEN_DATA_TYPE2 VARCHAR2 20 Token data type used in a resource exception message that was generated during the process to maintain project enterprise labor resources.
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.
IMPORT_STATUS VARCHAR2 1 Status of HCM resources imported as project enterprise resources

Foreign Keys

Table Foreign Table Foreign Key Column
PJR_RESOURCE_COND_RESULTS_DTL pjr_resource_cond_results_hdr RESULT_ID

Indexes

Index Uniqueness Tablespace Columns
PJR_RESOURCE_COND_RLT_DTL_U1 Unique FUSION_TS_TX_IDX RESULT_ID, RESULT_LINE_ID