DW_CXSR_CHANNELS_D_TL

Details

Module: Service Request Management

Key Columns

CHANNEL_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CHANNEL_ID NUMBER 38 0 True Channel    
SOURCE_RECORD_ID VARCHAR2 256     System    
CHANNEL_SHORT_NAME VARCHAR2 512     Auto-generated from CHANNEL_NAME and CREATION_DATE to make this value unique for any other purpose.    
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.    
ACCOUNT_ID NUMBER 38 0   Stores the bundle id of social channel account. DW_CXS_SALES_ACCOUNT_D SALES_ACCOUNT_ID
ACCOUNT_NAME VARCHAR2 512     Stores the account name to identify this channel instance.    
PRIVATE_P2P_ALLOWED_FLAG VARCHAR2 16     Indicates whether private P2P is allowed (Y or N).    
ORIGINAL_SYSTEM_REFERENCE VARCHAR2 256     Specifies the original system reference if record was imported.    
CHANNEL_TYPE_CODE VARCHAR2 32     Lookup code that indicates the channel type. Examples: EMAIL, PHONE, FACEBOOK, TWITTER. DW_CXSR_CHANNEL_TYPE_CODE_D_TL Code
END_POINT VARCHAR2 999     Stores the end point for this channel configuration.    
PORT VARCHAR2 16     Stores the port of this channel configuration.    
NETWORK_TYPE_CODE VARCHAR2 32     Indicates the type of social network, such as Facebook, Twitter, LinkedIn, etc. This will be blank for some channels such as WEB, PHONE, EMAIL. DW_CXSR_NETWORK_TYPE_CODE_D_TL Code
ENABLED_FLAG VARCHAR2 32     Indicates whether the channel instance is enabled (Y or N).    
DELETED_FLAG VARCHAR2 16     Indicates whether this channel instance is logically deleted (Y or N).    
ATTRIBUTE_CATEGORY VARCHAR2 32     Descriptive Flexfield: structure definition of the user descriptive flexfield.    
REPLY_FROM VARCHAR2 512     Stores the email address from which the messages will be sent.    
REPLY_TO VARCHAR2 512     Stores the email address to which the messages will be replied.    
PURPOSE_CODE VARCHAR2 32     Lookup code that indicates the purpose of the channel such as SALES, SUPPORT, INQUIRY. DW_CXSR_PURPOSE_CODE_D_TL Code
CUSTOMER_TYPE_CODE VARCHAR2 32     Lookup code that indicates the customer type that the channel will be used to identify, such as Consumer, Business or Both. DW_CXSR_CUSTOMER_TYPE_CODE_D_TL Code
MULTIPLE_MATCHES_ACTION_CODE VARCHAR2 32     Lookup code that indicates what action the application should take if multiple matches are found for the message sender. DW_CXSR_MULTIPLE_MATCHE_ACTION_CODE_D_TL Code
NO_MATCH_ACTION_CODE VARCHAR2 32     Lookup code that indicates what action the application should take if no matches are found for the message sender. DW_CXS_NO_MATCH_ACTION_CODE_D_TL Code
INCLUDE_SENDER_NAME_FLAG VARCHAR2 16     Indicates whether to include the sender's name as the from name.    
INCLUDE_SENDER_EMAIL_FLAG VARCHAR2 16     Indicates whether to include the sender's email address as the from email address.    
SUPPORT_ATTACHMENT_FLAG VARCHAR2 16     Whether email channel can handle attachment (Y or N).    
STRIPE_CODE VARCHAR2 32     Lookup code that indicates the stripe code, such as CRM, HCM, or PRM. DW_CXSR_STRIPE_CODE_D_TL Code
SOURCE_CODE VARCHAR2 32     Source Code DW_CXSR_SOURCE_CODE_D_TL Code
BUSINESS_UNIT_ORGANIZATION_ID NUMBER 38 0   Business Unit ID DW_INTERNAL_ORG_D_TL ORGANIZATION_ID
LANGUAGE VARCHAR2 16     Language    
SOURCE_LANGUAGE VARCHAR2 16     Source Language    
CHANNEL_DISPLAY_NAME VARCHAR2 512     Display Name    

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