Database Schema
The adapter uses several database views to load outage notifications generated by Service Alert.
MYC_CSS_PARAM_VIO_TEXT
This table contains outage notifications generated by Service Alert for the Notifications Hub.
 
Field
Data Type
Description
PARAM_VIO_ID
NUMBER
 
NOTIFICATION_CHANNEL
VARCHAR2(30)
This column is populated with value 'NHUB' for all rows.
VIO_TEXT
CLOB
Outage notification in JSON format.
CSS_NOTIFIED
VARCHAR2(1)
Whether the Notifications Hub interface has processed this row.
TEXT_SIZE
NUMBER
Size of the value in the VIO_TEXT column in bytes.
INSERT_TIME
DATE
Date/time when this row was inserted.
 
MYC_CSS_NOTIFIED_CIDS
This table contains identifiers of the customers that have already been notified about specific outage event. It is used to avoid a customer notified multiple times about the same outage.
Field
Data Type
Description
EVENT_IDX
NUMBER
Outage event index.
TRIGGER_CODE
NUMBER
Service Alert notification trigger code.
CID
VARCHAR2(64)
Customer identifier.