1. Tables and Views for Project Management
  2. PJR_RESOURCE_COND_CRITERIA

PJR_RESOURCE_COND_CRITERIA

Create and maintain resource conditions criteria details.

Details

  • Schema: FUSION

  • Object owner: PJR

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

PJR_RESOURCE_COND_CRITERIA_PK

CRITERIA_ID

Columns

Name Datatype Length Precision Not-null Comments Status
ENTERPRISE_ID NUMBER 18 Yes Enterprise identifier of a labor resource condition for the process to maintain project enterprise labor resources. The enterprise ID uniquely identifies a tenant in a multi-tenant environment.
CRITERIA_ID NUMBER 18 Yes Automatically-generated unique identifier of a labor resource condition criteria.
CONDITION_ID NUMBER 18 Yes Automatically-generated unique identifier of a labor resource condition. Active
JOB_ID NUMBER 18 Yes List of identifiers of the jobs that determine which HCM people are included in the process to maintain project enterprise labor resources if the condition selects HCM people based on their job. Active
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. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active

Foreign Keys

Table Foreign Table Foreign Key Column
PJR_RESOURCE_COND_CRITERIA pjr_resource_conditions_b CONDITION_ID

Indexes

Index Uniqueness Tablespace Columns
PJR_RESOURCE_COND_CRITERIA_U1 Unique Default CRITERIA_ID
PJR_RES_COND_CRITERIA_N1 Non Unique Default CONDITION_ID