QP_PROCESS_STEPS_B

This table stores the process steps.

Details

  • Schema: FUSION

  • Object owner: QP

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

QP_PROCESS_STEPS_B_PK

PROCESS_STEP_ID

Columns

Name Datatype Length Precision Not-null Comments
PROCESS_STEP_ID NUMBER 18 Yes The identifier of the step. Mandatory and Unique.
PROCESS_VERSION_ID NUMBER 18 Yes The Process_Version_Id the process step belongs to.
PROCESS_STEP_REF_TYPE_CODE VARCHAR2 30 Yes The code to identify the step. Mandatory and Unique.
PROCESS_STEP_REF_ID NUMBER 18 Yes The reference to the sub-process or the step that needs to be executed for the process step.
SEQUENCE_NUMBER NUMBER 18 Yes Indicates the sequence number of the process step
START_DATE TIMESTAMP Yes Indicates the date from which the process step is active.
END_DATE TIMESTAMP Indicates the date after which the process step is not active.
EXEC_CONDITION_EXPRESSION VARCHAR2 1000 This is a logical condition. The process step will be executed if the condition is true.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated 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.

Foreign Keys

Table Foreign Table Foreign Key Column
QP_PROCESS_STEPS_B qp_process_versions PROCESS_VERSION_ID
qp_process_steps_tl qp_process_steps_b PROCESS_STEP_ID
qp_proc_step_param_values qp_process_steps_b PROCESS_STEP_ID

Indexes

Index Uniqueness Tablespace Columns
QP_PROCESS_STEPS_B_PK Unique FUSION_TS_SEED PROCESS_STEP_ID
QP_PROCESS_STEPS_B_U1 Unique FUSION_TS_SEED PROCESS_VERSION_ID, PROCESS_STEP_REF_TYPE_CODE, PROCESS_STEP_REF_ID, SEQUENCE_NUMBER