PSC_COM_CC_LOG

Details

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

Primary Key

Name	Columns
PSC_COM_CC_LOG_MESSAGES_PK	LOG_MESSAGE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
LOG_MESSAGE_ID	NUMBER		18	Yes	System generated primary key column.	Active
MESSAGE_SEQ	NUMBER		18	Yes	Identifies the message sequence.	Active
LOG_ID	NUMBER		18	Yes	Log Identifier. Foreign Key to PSC_COM_CC_LOGS.LOG_ID	Active
MESSAGE_LANGUAGE	VARCHAR2	4			This column is used to indicate Message language.	Active
PRIORITY	VARCHAR2	1		Yes	Determines the High priority of the message , valid values Yes/No	Active
VISIBILITY	VARCHAR2	30		Yes	Determines the visibility, values:Account Owner / Delegates (Includes access for agency staff),Public Users (Includes anonymous and signed in users and agency staff) and Agency Staff Only	Active
CHANNEL_TYPE	VARCHAR2	30			Determines the delivery channel type (e.g Alerts, Notifications, Email and SMS Text).	Active
MIME_TYPE	VARCHAR2	30			Mime Type. text and HTML.The default value should be HTML.
SHORT_MESSAGE	VARCHAR2	4000			Specifies the message short message.	Active
FROM_ADDRESS	VARCHAR2	256			This column is used to indicate Sender email address.	Active
SUBJECT	VARCHAR2	1000			This column is used to indicate Specifies the Subject.	Active
BODY	CLOB				This column is used to indicate Specifies the message body.	Active
TEMPLATE_ID	NUMBER		18		Template Identifier. Foreign Key to PSC_COM_CC_TEMPLATES_B.TEMPLATE_ID	Active
STATUS	VARCHAR2	30			This column is used to indicate Specifies the message status.	Active
TOTAL_SUCCESS_RECIPIENTS	NUMBER		12		Total number of recipients the message has been sent to	Active
TOTAL_ERROR_RECIPIENTS	NUMBER		12		Total number of recipients the message has not been sent to because they are in error.	Active
UMS_MSG_ID	VARCHAR2	150			This column is used to store the UMS server side message id information
UMS_MSG_STATUS	VARCHAR2	200			This column is used to store the UMS server side message delivery status information
UMS_ERROR_CODE	VARCHAR2	200			This column is used to store the UMS server side message delivery error status code information
UMS_ERROR_DESCR	VARCHAR2	1200			This column is used to store the UMS server side message delivery error status description information
UMS_UPDATE_DTTM	TIMESTAMP				This column is used to store the last update datetime information of when any UMS server side message delivery error occurs.
UMS_JOB_PROCESS_ID	VARCHAR2	30			This column is used to store the UMS related ESS-process monitor job process id information for that row.
AGENCY_ID	NUMBER		8		This column is used to indicate agency id	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
MESSAGE_DELETE_ALLOWED	VARCHAR2	1			Communication message generated from template is allowed to delete by the user or not.

Foreign Keys

Table	Foreign Table	Foreign Key Column
PSC_COM_CC_LOG_MESSAGES	psc_com_cc_logs	LOG_ID
psc_com_cc_webform	psc_com_cc_log_messages	LOG_MESSAGE_ID
psc_com_cc_log_recipients	psc_com_cc_log_messages	LOG_MESSAGE_ID
psc_com_cc_attachments	psc_com_cc_log_messages	LOG_MESSAGE_ID

Indexes

Index	Uniqueness	Tablespace	Columns	Status
PSC_COM_CC_LOG_MESSAGES_FK1	Non Unique	FUSION_TS_TX_IDX	LOG_ID	Active
PSC_COM_CC_LOG_MESSAGES_PK	Unique	FUSION_TS_TX_IDX	LOG_MESSAGE_ID	Active