PSC_COM_CC_BRF_ACTION

Details

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

Primary Key

Name	Columns
PSC_COM_CC_ACTION_LOG_PK	ACTION_LOG_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
ACTION_LOG_ID	NUMBER		18	Yes	System generated primary key column.
RULE_LOG_ID	NUMBER		18	Yes	System generated primary key column.
EXECUTION_ID	VARCHAR2	50		Yes	ID for each execution process.
ACTION_SEQUENCE	NUMBER		5		Sequence indicator for this Action.
ACTION_CODE	VARCHAR2	32			Specifies an action code which can be used to identify an action.
ACTION_RECORD_IDENTIFIER	VARCHAR2	100			Identifier of the action record.
ACTION_RECORD_SUB_IDENTIFIER	VARCHAR2	100			Sub identifier of the action record.
ACTION_API_PAYLOAD	CLOB				Payload which is sending to API.
ACTION_RESPONSE_CODE	VARCHAR2	20			Action is executed and response retuns with status code.
ACTION_RESPONSE_PAYLOAD	CLOB				Action is executed and returns response data.
ACTION_STATUS	VARCHAR2	50			Status of Action executed.
ACTION_RETRY_COUNT	NUMBER		9		Number of times action retry.
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_ACTION_LOG	psc_com_cc_brf_rule_log	RULE_LOG_ID

Indexes

Index	Uniqueness	Tablespace	Columns
PSC_COM_CC_ACTION_LOG_FK1	Non Unique	PSC_COM_CC_ACTION_LOG_FK1	RULE_LOG_ID
PSC_COM_CC_ACTION_LOG_FK2	Non Unique	PSC_COM_CC_ACTION_LOG_FK2	EXECUTION_ID
PSC_COM_CC_ACTION_LOG_PK	Unique	PSC_COM_CC_ACTION_LOG_PK	ACTION_LOG_ID