DW_CXSR_CHANNEL_VIA_D

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     System    
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     Indicates whether this via record is logically deleted (Y or N).    

Copyright © 2019, 2023, Oracle and/or its affiliates.