Table CHANNEL_DIMENSION

DescriptionChannel identifies the different delivery and communications mechanisms through which products and services are made available to a customer and by which the Financial Institution and customers communicate with each other.

At a leaf level, Channel is a role played by either an Involved Party (e.g. Employee, Organization Unit) or a Resource Item (e.g. an ATM, a Website). At higher levels, Channels are Groups of such Involved Parties and/or Resource Items.

The lowest granularity of Channel required will be a matter of choice for the Financial Institution. Some may wish to just identify the ATM Network (a Resource Item) as a Channel, whereas others will wish to be able to identify each individual ATM machine (each a Resource Item). A Call Centre (an Organization Unit) may be sufficient granularity as a Channel in some cases - others will require recording of each Call Centre operative (Employees).

Where a given Involved Party or Resource Item instance is capable of both receiving or distributing services, it may be appropriate to associate that instance with two Channels. For example, a Teller Employment Position may be part of the Teller Receipt Channel for Transactions, but part of the Teller Distribution Channel for Product Campaigns.

Specific Channels may be utilized where there are accessibility issues e.g. an IP who prefers to be contacted by telephone, in this case the Channel Communication Form of Verbal is utilized.

Columns
CHANNEL_DIMENSION_IDCHANNEL_DIMENSION_ID
CALENDAR_DATE_DIMENSION_IDCALENDAR_DATE_DIMENSION_ID
DENOMINATION_CURRENCY_DIMENSION_IDDENOMINATION_CURRENCY_DIMENSION_ID
ADMINISTRATION_INVOLVED_PARTY_CODEADMINISTRATION_INVOLVED_PARTY_CODE
ADMINISTRATION_INVOLVED_PARTY_NAMEADMINISTRATION_INVOLVED_PARTY_NAME
CODECODE
DELIVERY_CHANNEL_CODEDELIVERY_CHANNEL_CODE
DELIVERY_CHANNEL_NAMEDELIVERY_CHANNEL_NAME
DELIVERY_INVOLVED_PARTY_CODEDELIVERY_INVOLVED_PARTY_CODE
DELIVERY_INVOLVED_PARTY_NAMEDELIVERY_INVOLVED_PARTY_NAME
DESCRIPTIONDESCRIPTION
KEYWORDKEYWORD
NAMENAME
PARENT_CHANNEL_CODEPARENT_CHANNEL_CODE
PARENT_CHANNEL_NAMEPARENT_CHANNEL_NAME
ANCHOR_IDANCHOR_ID
CURRENT_ROW_INDICATORCURRENT_ROW_INDICATOR
EFFECTIVE_FROM_DATEEFFECTIVE_FROM_DATE
EFFECTIVE_TO_DATEEFFECTIVE_TO_DATE
VALID_FROM_DATEVALID_FROM_DATE
VALID_TO_DATEVALID_TO_DATE
UNIQUE_ID_IN_SOURCE_SYSTEMUNIQUE_ID_IN_SOURCE_SYSTEM
INDIVIDUAL_CUSTOMER_DIMENSION_IDINDIVIDUAL_CUSTOMER_DIMENSION_ID

Foreign Key
CHAN_INDIVIDUAL_FKCHAN_INDIVIDUAL_FK

Primary Key
CHANNEL_DIMENSION_PKCHANNEL_DIMENSION_PK

Indexes
CHANNEL_DIMENSION_PKCHANNEL_DIMENSION_PK

Column Details

 CHANNEL_DIMENSION_ID
DescriptionThe unique identifier of the Channel Dimension.
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identitytrue
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CALENDAR_DATE_DIMENSION_ID
DescriptionThe unique identifier of the Calendar Date Dimension.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DENOMINATION_CURRENCY_DIMENSION_ID
DescriptionThe unique identifier of the Denomination Currency Dimension. It indicates the Currency in which the monetary amounts are expressed.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 ADMINISTRATION_INVOLVED_PARTY_CODE
DescriptionAdministration Involved Party Code indicates a short alphanumeric identifier that uniquely identifies the Involved Party.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 ADMINISTRATION_INVOLVED_PARTY_NAME
DescriptionAdministration Involved Party Name indicates the entire and complete name of the subject Involved Party; for example, 'Incorporated Township of East Quincy', 'International Business Machines Corporation' , 'XYZ Limited Partnership for Fossil Fuel Exploration'.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CODE
DescriptionCode indicates 'meaningful' mnemonic external codes, in each language of the warehouse environment, are assigned to each Group occurrence for purposes of identification.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DELIVERY_CHANNEL_CODE
DescriptionDelivery Channel Code indicates 'meaningful' mnemonic external codes, in each language of the warehouse environment, are assigned to each Group occurrence for purposes of identification.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DELIVERY_CHANNEL_NAME
DescriptionDelivery Channel Name indicates a label by which Channel is known; for example, Group #43 is known as, and is commonly called,
'Fiscal Year 1993 Marketing Prospects'.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DELIVERY_INVOLVED_PARTY_CODE
DescriptionDelivery Involved Party Code indicates a short alphanumeric identifier that uniquely identifies the Involved Party.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DELIVERY_INVOLVED_PARTY_NAME
DescriptionInvolved Party Name indicates the entire and complete name of the subject Involved Party; for example, 'Incorporated Township of East Quincy', 'International Business Machines Corporation' , 'XYZ Limited Partnership for Fossil Fuel Exploration'.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DESCRIPTION
DescriptionDescription indicates a textual explanation or free form comments about the Group.
Data TypeVARCHAR(2000)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 KEYWORD
DescriptionKeyword indicates a significant word to be used for searching a database. This is often known as a 'Shortname', and is based on an abbreviated version of the complete Involved Party Name.
Data TypeVARCHAR(100)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NAME
DescriptionName indicates a label by which Channel is known; for example, Group #43 is known as, and is commonly called,
'Fiscal Year 1993 Marketing Prospects'.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PARENT_CHANNEL_CODE
DescriptionParent Channel Code indicates 'meaningful' mnemonic external codes, in each language of the warehouse environment, are assigned to each Parent Channel occurrence for purposes of identification.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PARENT_CHANNEL_NAME
DescriptionParent Channel Name indicates a label by which an instance of Parent Channel is known.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 ANCHOR_ID
DescriptionAnchor Id indicates any value without business meaning that uniquely distinguishes occurrences of this entity independently of its history.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CURRENT_ROW_INDICATOR
DescriptionCurrent Row Indicator indicates whether or not, among the different versions of this dimension, this row holds the values that are currently valid in the business reality. This indicator enables the current values of the dimension to be retrieved quickly.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EFFECTIVE_FROM_DATE
DescriptionEffective From Date indicates the effective date and time that represents the beginning of the time period during which the values of all attributes of the entity occurrence are true in the business reality.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EFFECTIVE_TO_DATE
DescriptionEffective To Date indicates the effective date and time that represents the end of the time period during which the values of all attributes of the entity occurrence are true in the business reality.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 VALID_FROM_DATE
DescriptionValid From Date indicates the transaction time that represents the beginning of the time period during which the values of this recorded data are true in the source system.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 VALID_TO_DATE
DescriptionValid To Date indicates the transaction time that represents the end of the time period during which the values of this recorded data are true in the source system.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 UNIQUE_ID_IN_SOURCE_SYSTEM
DescriptionUnique Id In Source System indicates the unique identifier of the populated instance in the Source System.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 INDIVIDUAL_CUSTOMER_DIMENSION_ID
DescriptionThe unique identifier of the Individual Customer Dimension.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Foreign Key Details

 CHAN_INDIVIDUAL_FK
DescriptionThe unique identifier of the Individual Snapshot
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshipfalse
Child TableCHANNEL_DIMENSION
Child Multiplicity*
Key ColumnCALENDAR_DATE_DIMENSION_ID [BIGINT]
Key ColumnDENOMINATION_CURRENCY_DIMENSION_ID [BIGINT]
Key ColumnINDIVIDUAL_CUSTOMER_DIMENSION_ID [BIGINT]
Parent TableINDIVIDUAL_SNAPSHOT_FACT
Parent Multiplicity0..1
Unique ConstraintINDIVIDUAL_SNAPSHOT_FACT_PK

Primary Key Details

 CHANNEL_DIMENSION_PK
DescriptionThe unique identifier of the Channel Dimension
MemberCHANNEL_DIMENSION_ID [BIGINT]

Index Details

 CHANNEL_DIMENSION_PK
DescriptionThe unique identifier of the Channel Dimension
Is Uniquetrue
Is Clusteredfalse
MemberCHANNEL_DIMENSION_ID [BIGINT] Ascending