CSO_WORKFLOW_CONDITION
This table contains the properties for a workflow step condition.
Details
-
Schema: FUSION
-
Object owner: CSO
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
Name | Columns |
---|---|
CSO_WORKFLOW_CONDITION_PK |
RECORD_ID |
Columns
Name | Datatype | Length | Not-null | Comments |
---|---|---|---|---|
ADVANCE_TO_STEP_ID | VARCHAR2 | 32 | This is the GUID for workflow step to advance to when condition occurs. | |
CONDITION_CONTAINS | CHAR | 1 | Yes | Flag indicating if the condition must meet any or all constraints to trigger (Y if the Content record contains the selected fields, N if the Content record does n) |
CONDITION_NAME | VARCHAR2 | 100 | Yes | This is the User friendly name for the workflow step condition. |
DATE_ADDED | TIMESTAMP | Yes | This is the date that the record was added to the repository. | |
DATE_MODIFIED | TIMESTAMP | Yes | This is the date that the record was modified. | |
EVALUATE_ALL | CHAR | 1 | Yes | A flag indicating if all or any of the fields should be evaluated (Y=all, N=any) |
IS_MASTER_DOC | CHAR | 1 | A flag indicating if this condition applies for master documents(versions in the same locale in which this record was created) | |
IS_TRANSLATION | CHAR | 1 | A flag indicating if this condition applies for translated documents(versions in different locales in which this record was created) | |
RECORD_ID | VARCHAR2 | 32 | Yes | This is the primary key of the table. |
WORKFLOW_STEP_ID | VARCHAR2 | 32 | Yes | This is the GUID for the workflow stop for which the condition belongs. |
SORT_ORDER | NUMBER | Order in which the condition is evaluated. | ||
JUMP_TO_PUBLISH | CHAR | 1 | Flag indication if condition occurs directly publish document. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
CSO_WORKFLOW_CONDITION | cso_workflow_step | WORKFLOW_STEP_ID |
cso_wf_cond_locales | cso_workflow_condition | WORKFLOW_CONDITION_ID |
cso_wf_cond_categories | cso_workflow_condition | WORKFLOW_CONDITION_ID |
cso_wf_cond_user_grps | cso_workflow_condition | WORKFLOW_CONDITION_ID |
Indexes
Index | Uniqueness | Columns |
---|---|---|
CSO_WORKFLOW_CONDITION_U1 | Unique | RECORD_ID |
CSO_WORKFLOW_CONDITION_N1 | Non Unique | WORKFLOW_STEP_ID |