DW_CXSR_CHANNEL_VIA_D

This table stores detailed information about how a service request was received or how an SR message was received or sent, and whom it was sent to

Details

Module: Service Request Management

Key Columns

VIA_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
VIA_ID NUMBER 38 0 True ID
SOURCE_RECORD_ID VARCHAR2 256 This column is for Oracle Internal use only. System Generated Unique Identifier
CREATION_DATE TIMESTAMP Indicates the date and time of the creation of the row.
LAST_UPDATE_DATE TIMESTAMP Indicates the date and time of the last update of the row.
OBJECT_ID NUMBER 38 0 Foreign key that references SVC_SERVICES_REQUESTS (SR_ID) if this channel is for an SR, or SVC_SR_MESSAGES (MESSAGE_ID) if this channel is for an SR MESSAGE.
OBJECT_TYPE_CODE VARCHAR2 32 Lookup code that indicates whether the OBJECT_ID is for SR or for SR_Message. DW_CXSR_OBJECT_TYPE_CODE_D_TL Code
CHANNEL_ID NUMBER 38 0 Channel ID DW_CXSR_CHANNELS_D_TL CHANNEL_ID
ROUTING_CODE VARCHAR2 32 Lookup code that indicates how the message was routed to the PARTY_VIA_END_POINT. For example, if the message is an email, whether the recipient is a TO, CC, or BCC recipient. DW_CXSR_ROUTING_CODE_D_TL Code
DELETED_FLAG VARCHAR2 16 Flag to indicate if the record was deleted