PSC_COM_CC_BRF

Details

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

Primary Key

Name	Columns
PSC_COM_CC_BRF_LOGS_PK	LOG_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
LOG_ID	NUMBER		18	Yes	System generated primary key column.	Active
CHECK_POINT	VARCHAR2	100			Records checkpoints in the execution flow.
KEYSET	CLOB				Contains the list of keys to be processed.
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.
EXECUTION_RETRY_COUNT	NUMBER		9		Number of retries done for execution.
EXECUTION_ID	VARCHAR2	50		Yes	ID for each execution process.
EVENT_ID	NUMBER		18		Event Identifier. Foreign Key to PSC_COM_CC_EVENTS_B.EVENT_ID	Active
RESOURCE_ID	NUMBER		18		Business object reference for the communication	Active
EVENT_CODE	VARCHAR2	32			Specifies an event code which can be used to identify an event
RESOURCE_CODE	VARCHAR2	32			Specifies a resource code which can be used to identify an event
REFERENCE_ID	VARCHAR2	150			Specifies a Resource Id which can be used to identify an event
REFERENCE_NAME	VARCHAR2	100			Specifies a Resource Name which can be used to identify an event
EXECUTION_STATUS	VARCHAR2	50			Specifies an Execution Status which can be used to identify an event status
REQUEST_PAYLOAD	CLOB				The Request Payload which is received from API call
LOG	CLOB				Contains a log for the activity run.	Active
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.	Active
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.	Active
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.	Active
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.	Active
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.	Active
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.	Active

Foreign Keys

Table	Foreign Table	Foreign Key Column
PSC_COM_CC_BRF_LOGS	psc_com_cc_events_b	EVENT_ID
PSC_COM_CC_BRF_LOGS	psc_com_cc_resources_b	RESOURCE_ID
psc_com_cc_brf_attachment	psc_com_cc_brf_logs	LOG_ID
psc_com_cc_brf_rule_log	psc_com_cc_brf_logs	LOG_ID

Indexes

Index	Uniqueness	Tablespace	Columns	Status
PSC_COM_CC_BRF_LOGS_FK1	Non Unique	FUSION_TS_TX_IDX	EVENT_ID	Active
PSC_COM_CC_BRF_LOGS_FK2	Non Unique	Default	RESOURCE_ID
PSC_COM_CC_BRF_LOGS_PK	Unique	FUSION_TS_TX_IDX	LOG_ID	Active