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 |