CST_PUBLOG (ver 15.5.1)
This table is a standalone table that captures logging messages generated from the publishing framework. This table is available for all states/provinces and may or may not be utilized for your state/province.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 15.5.1 | NUMBER(19,0) | The internal ID for the CST_PUBLOG record to which the record is associated. Required. (Default – Next value in CST_PUBLOG_SQ sequence) |
CST_PUBPROFILEID | 15.5.1 | NUMBER(19,0) | The internal ID for the CST_PUBPROFILE record to which the record is associated. Required. |
SEVERITYLEVEL | 15.5.1 | VARCHAR2(10) | The severity level of the log message. Required. (i.e. “ERROR”, “WARNING”, “INFO”, and “DIAG”) |
CODE | 15.5.1 | VARCHAR2(50) | A code to give more detail to the log message. For example, this could be a SQL code to give more detail to a SQL error. |
SERVICETYPE | 15.5.1 | CHAR(1) | The service type. (If the log message is related to a service.) (i.e. ‘G’–General, ‘P’-Publish, ‘U’-Unique ID, ‘D’-Download) (Default - ‘G’) |
SERVICESUBTYPE | 15.5.1 | VARCHAR2(50) | The service sub-type. (If the log message is related to a service.) |
KEYVALUE | 15.5.1 | VARCHAR2(20) | The key value for the log message. |
DASHBOARDID | 15.5.1 | NUMBER(19,0) | The dashboard ID. (If the log message is related to the dashboard.) |
LOCATION | 15.5.1 | VARCHAR2(100) | The location of where the log message was called. |
RESOURCENAME | 15.5.1 | VARCHAR2(100) | The resource name. (If the log message is related to a resource.) |
DISPLAYMESSAGE | 15.5.1 | VARCHAR2(2000) | The display message for the log message. |
TECHMESSAGE | 15.5.1 | VARCHAR2(2000) | The technical message for the log message. |