PJR_RESOURCE_CONDITIONS_B
Create and maintain resource conditions data model.
Details
-
Schema: FUSION
-
Object owner: PJR
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
PJR_RES_CONDITIONS_B_PK |
CONDITION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| 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. | |
| CONDITION_ID | NUMBER | 18 | Yes | Automatically-generated unique identifier of a labor resource condition. | |
| PERSON_TYPE_CODE | VARCHAR2 | 30 | Yes | System person type that determines which HCM people the condition includes in the process to maintain project enterprise labor resources. The person type can be employee (EMP), contingent worker (CWK), or both (ECWK). | |
| JOB_BASED_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the condition selects HCM people based on their job to include in the process to maintain project enterprise labor resources. | |
| SCHEDULING_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the resources included in the Maintain Project Enterprise Labor Resource process are available to fulfill project resource requests and have schedules that are managed by Oracle Fusion Project Resource Management. | |
| PROCESS_ORDER | NUMBER | 18 | Yes | Order in which to process a condition in the process to maintain project enterprise labor resources. Conditions with a lower number are processed first. | |
| CALENDAR_ID | NUMBER | 18 | Identifier of the calendar to assign to resources in the process to maintain project enterprise labor resources. | ||
| PROJECT_ROLE_ID | NUMBER | 18 | Identifier of the project role to assign to resources in the process to maintain project enterprise labor resources. | ||
| COST_RATE_CURRENCY_CODE | VARCHAR2 | 15 | Currency to assign to resources for the cost rate in the process to maintain project enterprise labor resources. | ||
| BILL_RATE_CURRENCY_CODE | VARCHAR2 | 15 | Currency to assign to resources for the bill rate in the process to maintain project enterprise labor resources. | ||
| COST_RATE | NUMBER | Cost rate to assign to resources in the process to maintain project enterprise labor resources. | |||
| BILL_RATE | NUMBER | Bill rate to assign to resources in 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. | ||
| UNIT_OF_MEASURE | VARCHAR2 | 30 | Unit of Measure. | ||
| POOL_ID | NUMBER | 18 | Identifier of the project resource pool to which a resource is assigned. | ||
| BUSINESS_UNIT_ID | NUMBER | 18 | Identifier of the business unit 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 business unit. | ||
| ORGANIZATION_ID | NUMBER | 18 | Identifier of the organization 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 organization. | ||
| ENABLE_CONDITION_FLAG | VARCHAR2 | 1 | Indicates if the condition is included while importing persons from HCM as part of Maintain Project Enterprise Labor Resources process. | ||
| INCLUDE_ORG_HIERARCHY | VARCHAR2 | 1 | Indicates if the HCM persons are imported only from the selected organization or from the organization hierarchy. | ||
| TREE_STRUCTURE_CODE | VARCHAR2 | 30 | Identifier of the Tree Structure. Possible values are PER_DEPT_TREE_STRUCTURE or PER_ORG_TREE_STRUCTURE. | ||
| TREE_CODE | VARCHAR2 | 30 | Identifier of the Organization or Department Tree. | ||
| POSITION_ID | NUMBER | 18 | Identifier of the position that determine which HCM people are included in the process to maintain project enterprise labor resources. | ||
| LOCATION_ID | NUMBER | 18 | Identifier of the location that determine which HCM people are included in the process to maintain project enterprise labor resources. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| pjr_resource_cond_criteria | pjr_resource_conditions_b | CONDITION_ID |
| pjr_resource_conditions_tl | pjr_resource_conditions_b | CONDITION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJR_RES_CONDITIONS_B_U1 | Unique | Default | CONDITION_ID |
| PJR_RES_CONDITIONS_B_U2 | Unique | Default | ENTERPRISE_ID, CONDITION_ID |