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 This column is for Oracle Internal use only. 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