PJR_RESOURCE_COND_RESULTS_HDR
Latest results for the process to maintain project enterprise labor resources. Results include information such as the number of resources created and number of exceptions encountered by the process.
Details
-
Schema: FUSION
-
Object owner: PJR
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
PJR_RESOURCE_COND_RLT_HDR_PK |
RESULT_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 the last successfully-completed run of the process to maintain project enterprise labor resources. | |
| PARENT_REQUEST_ID | NUMBER | 18 | Yes | Unique identifier of the last successfully-completed run of the process to maintain project enterprise labor resources. | |
| CHILD_REQUEST_ID | NUMBER | 18 | Unique identifier of the child process initiated during the last successfully-completed run of the process to maintain project enterprise labor resources. | ||
| CREATE_NEW_FLAG | VARCHAR2 | 1 | Process option to create project enterprise labor resources based on the project enterprise labor resource maintenance conditions. | ||
| INACTIVE_FLAG | VARCHAR2 | 1 | Process option to deselect the option to manage resource availability and staffing for project enterprise labor resources who are associated with HCM persons who no longer have an active HCM assignment. | ||
| PROCESS_RUN_DATE | TIMESTAMP | Completion date and time of the last successfully-completed run of the process to maintain project enterprise labor resources. | |||
| TOTAL_RESOURCE_CREATED | NUMBER | Number of resources that are created by the process to maintain project enterprise labor resources. | |||
| TOTAL_RESOURCE_UPDATED | NUMBER | Number of resources that are updated by the process to maintain project enterprise labor resources. | |||
| TOTAL_RESOURCE_REJECTED | NUMBER | Number of resource exceptions that are encountered by the process to maintain project enterprise labor resources. | |||
| TOTAL_RESOURCE_REMOVED | NUMBER | Number of resources for whom the option to manage resource availability and staffing was deselected by 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. | ||
| UPDATE_FLAG | VARCHAR2 | 1 | Process option to update project enterprise labor resources based on the project enterprise labor resource maintenance conditions. | ||
| UPDATE_PRJ_ENT_RES_DTLS_FLAG | VARCHAR2 | 1 | Process option to update additional details of project enterprise labor resources based on the values defined in project enterprise labor resource maintenance conditions. |
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_HDR_U1 | Unique | FUSION_TS_TX_IDX | RESULT_ID |