FUN_WF_PATTERNS

Details

Schema: FUSION
Object owner: FUN
Object type: TABLE
Tablespace: Default

Primary Key

Name	Columns
FUN_WF_PATTERNS_PK	PATTERN_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
PATTERN_ID	NUMBER		18	Yes	Pattern identifier and primary key.
RULE_ID	NUMBER		18	Yes	Foreign key reference identifier to the FUN_WF_RULES table.
PATTERN_ORDER	NUMBER		18	Yes	The order in which patterns are stored for a rule in the rule file.
PARENT_PATTERN_ID	NUMBER		18		Reference to the parent pattern when approval rules are having nested patterns.
FACT_PATH	VARCHAR2	256		Yes	Path joining multiple child patterns.
FORM_CODE	VARCHAR2	64			Type of pattern indicating whether the rules are configures using nested conditions.
PATTERN_VARIABLE	VARCHAR2	256			Variable name to identify the fact used within the pattern.
FACT_TYPE_NAME	VARCHAR2	256			Name of the fact used in the pattern.
FACT_TYPE_KEY	VARCHAR2	1000			Fully qualified fact name as defined in the rule file.
CONNECTIVE_OPERATOR	VARCHAR2	64			Operator symbol connecting the pattern to the next pattern in the order. Possible values are && and II.
TEST_FORM_CODE	VARCHAR2	64			Type of the rule condition associated with the pattern.
OPERATOR	VARCHAR2	64			Surround operator symbol used in the pattern as part of rule configuration. Possible values are && and II.
AGGREGATE_VARIABLE	VARCHAR2	256			Variable name defined for aggregate surround by operator.
AGGREGATE_FUNCTION	VARCHAR2	64			Name of the aggregate function.
AGGREGATE_EXPRESSION	VARCHAR2	512			Attribute expression that is being aggregated.
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.

Foreign Keys

Table	Foreign Table	Foreign Key Column
FUN_WF_PATTERNS	fun_wf_rules	RULE_ID
fun_wf_conditions	fun_wf_patterns	PATTERN_ID

Indexes

Index	Uniqueness	Tablespace	Columns
FUN_WF_PATTERNS_FK1	Non Unique	Default	RULE_ID
FUN_WF_PATTERNS_PK	Unique	Default	PATTERN_ID