PSC_COM_CC_BRF_RULE

Details

Schema: FUSION
Object owner: PSC_CC
Object type: TABLE
Tablespace: psc_com_cc_brf_rule_log

Primary Key

Name	Columns
PSC_COM_CC_BRF_RULE_LOG_PK	RULE_LOG_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
RULE_LOG_ID	NUMBER		18	Yes	System generated primary key column.
CHECK_POINT	VARCHAR2	100			Records checkpoints in the rule execution flow.
KEYSET	CLOB				Contains the list of keys to be processed.
RULE_RETRY_COUNT	NUMBER		9		Number of retries of rule execution.
LOG_ID	NUMBER		18	Yes	System generated primary key column.
EXECUTION_ID	VARCHAR2	50		Yes	ID for each execution process.
RULE_ID	NUMBER		18	Yes	Specifies Rule Id which can be used to identify Rule.
RULE_NAME	VARCHAR2	250			Specifies Rule Name which can be used to identify Rule.
CAL_TRANS_KEY	NUMBER		18		The Transaction Reference Key which is returns by Calendar Integration API.
RECORD_FIRST_KEY_NAME	VARCHAR2	32			First key name of the record.
RECORD_FIRST_KEY_VALUE	VARCHAR2	100			First key value of the record.
RECORD_SECOND_KEY_NAME	VARCHAR2	32			Second key name of the record.
RECORD_SECOND_KEY_VALUE	VARCHAR2	100			Second key value of the record.
RECORD_THIRD_KEY_NAME	VARCHAR2	32			Third key name of the record.
RECORD_THIRD_KEY_VALUE	VARCHAR2	100			Third key value of the record.
RECORD_FOURTH_KEY_NAME	VARCHAR2	32			Fourth key name of the record.
RECORD_FOURTH_KEY_VALUE	VARCHAR2	100			Fourth key value of the record.
RECORD_FIFTH_KEY_NAME	VARCHAR2	32			Fifth key name of the record.
RECORD_FIFTH_KEY_VALUE	VARCHAR2	100			Fifth key value of the record.
RECORD_IDENTIFIER	VARCHAR2	100			Identifier of the record.
RECORD_SUB_IDENTIFIER	VARCHAR2	100			Sub Identifier of the record.
RULE_STATUS	VARCHAR2	50			Status of Rule executed.
RULE_STATUS_DETAIL	VARCHAR2	2048			Status of Rule details.
LOG	CLOB				Contains a log for the activity run.
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.
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.
TIME_01	NUMBER		10		Flex time column 1.
TIME_02	NUMBER		10		Flex time column 2.
TIME_03	NUMBER		10		Flex time column 3.
TIME_04	NUMBER		10		Flex time column 4.
TIME_05	NUMBER		10		Flex time column 5.

Foreign Keys

Table	Foreign Table	Foreign Key Column
PSC_COM_CC_BRF_RULE_LOG	psc_com_cc_rules	RULE_ID
PSC_COM_CC_BRF_RULE_LOG	psc_com_cc_brf_logs	LOG_ID
psc_com_cc_brf_attachment	psc_com_cc_brf_rule_log	RULE_LOG_ID
psc_com_cc_brf_action_log	psc_com_cc_brf_rule_log	RULE_LOG_ID

Indexes

Index	Uniqueness	Tablespace	Columns
PSC_COM_CC_BRF_RULE_LOG_FK1	Non Unique	PSC_COM_CC_BRF_RULE_LOG_FK1	LOG_ID
PSC_COM_CC_BRF_RULE_LOG_FK2	Non Unique	PSC_COM_CC_BRF_RULE_LOG_FK2	RULE_ID
PSC_COM_CC_BRF_RULE_LOG_PK	Unique	PSC_COM_CC_BRF_RULE_LOG_PK	RULE_LOG_ID