DW_EB_X_EBS_COMMON_W_CHNL_TYPE_D
The Channel Types Dimension covers the methods by which contact paths are established between the Customer and our organisation. Definition of Channel Type : Any communication media that is used to broadcast messages/offers is a channel type. This table stores different kinds of communication paths through a specific medium. For eg., Channel Type would be Direct Mail/News Papers through Print Media; Email through Web Media; Internet Advertisements through Web Media;This table can also store information about sales channels and servicing channels used by organizations. Examples of Sales Channel can include both direct and indirect channels used by an organization. From an analysis perspective if one want's to know the services provided to the customer were done through internal channels or through external(third party) channels ,this table can be used to store this kind of information also.
Details
Module: Common Tables (EBS_COMMON)
Business Name: Channel Type
Key Columns
Key column information is not documented in the supplied metadata.
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table |
|---|---|---|---|---|---|---|
| ROW_WID | NUMBER | 38 | True | Surrogate key to uniquely identify a record. | ||
| AUX1_CHANGED_ON_DT | TIMESTAMP | 6 | Oracle System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| AUX2_CHANGED_ON_DT | TIMESTAMP | 6 | Oracle System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| AUX3_CHANGED_ON_DT | TIMESTAMP | 6 | Oracle System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| AUX4_CHANGED_ON_DT | TIMESTAMP | 6 | Oracle System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| CHANGED_BY_WID | NUMBER | 38 | This is a foreign key to the DW_EB_X_EBS_COMMON_W_USER_D dimension indicating the user who last modified the record in the source system. | DW_EB_X_EBS_COMMON_W_USER_D | ||
| CHANGED_ON_DT | TIMESTAMP | 6 | Identifies the date and time when the record was last modified in the source system. | |||
| CHNL_GRP_CODE | VARCHAR2 | 80 CHAR | This code identifies a broad group of channel types. Examples include Electronic, Manned Point of Representation, and Indirect Sales Channel, Internal Service Channel, Direct Sales Channel, External Service Channel. | |||
| CHNL_MEDIA_CODE | VARCHAR2 | 80 CHAR | This code identifies the media under which every channel type is categorized. | |||
| CHNL_TYPE_CODE | VARCHAR2 | 80 CHAR | This is the unique code for the channel type. This identifies the code to define every channel type. Examples include: Email, Telephone, Dmail (for Direct Mail), and Fax ,Dealer, Reseller, Customer Service Representative | |||
| CREATED_BY_WID | NUMBER | 38 | This is a foreign key to the DW_EB_X_EBS_COMMON_W_USER_D dimension indicating the user who created the record in the source system. | DW_EB_X_EBS_COMMON_W_USER_D | ||
| CREATED_ON_DT | TIMESTAMP | 6 | Identifies the date and time when the record was initially created in the source system. | |||
| DATASOURCE_NUM_ID | NUMBER | 10 | This column is the unique identifier of the source system from which data was extracted. In order to be able to trace the data back to its source, Oracle recommends that you define separate unique source IDs for each of your different source instances. | |||
| DELETE_FLG | VARCHAR2 | 1 CHAR | This flag indicates the deletion status of the record in the source system. A value of "Y" indicates that the record is deleted from the source system and logically deleted from the data warehouse; a value of "N" indicates that the record is active. | |||
| ENABLED_FLAG | VARCHAR2 | 1 CHAR | ||||
| END_DATE_ACTIVE | TIMESTAMP | 6 | ||||
| ETL_PROC_WID | NUMBER | 38 | Oracle System Field. This column is the unique identifier for the specific ETL process used to create or update this data. | |||
| INTEGRATION_ID | VARCHAR2 | 80 CHAR | This column is the unique identifier of a dimension or fact entity in its source system. In case of composite keys, the value in this column can consist of concatenated parts. | |||
| START_DATE_ACTIVE | TIMESTAMP | 6 | ||||
| TENANT_ID | VARCHAR2 | 80 CHAR | This column is the unique identifier for a Tenant in a multi-tenant environment. This would typically be used in an Application Service Provider (ASP) / Software As a Service (SOAS) model. | |||
| W_CHTY_GRP_CODE | VARCHAR2 | 80 CHAR | Identifies the code portion of Oracle- supplied domain value for grouping the various source supplied channel types. For example, sales channels can be grouped or mapped into Oracle BI Applications supplied domain value "DIRECT" or "INDIRECT". | |||
| W_CHTY_SUBG_CODE | VARCHAR2 | 80 CHAR | Identifies the code portion of Oracle- supplied domain value for sub- grouping the various source supplied channel types. For example, sales channels grouped as INDIRECT can be further sub grouped or mapped into Oracle BI Applications supplied domain value RESELLEER, PARTNER, etc | |||
| W_INBOUND_TYPE_FLG | VARCHAR2 | 1 CHAR | This flag identifies the channel type as Inbound or Outbound. Possible values are 'Y', 'N'. | |||
| X_CUSTOM | VARCHAR2 | 10 CHAR | This column is used as a generic field for customer extensions. | |||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |