Module: Service Request Management
CHANNEL_ID
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 | 1024 | 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 |