Table CUSTOMER_COMMUNICATION_FACT

DescriptionIndividual Customer Communication Fact is a fact table recording the key measures relating to Individual Customer Communications.

Columns
CALENDAR_DATE_DIMENSION_IDCALENDAR_DATE_DIMENSION_ID
CHANNEL_DIMENSION_IDCHANNEL_DIMENSION_ID
INDIVIDUAL_CUSTOMER_DIMENSION_IDINDIVIDUAL_CUSTOMER_DIMENSION_ID
COMMUNICATIONS_FAILURE_RATECOMMUNICATIONS_FAILURE_RATE
COMMUNICATIONS_SUCCESS_RATECOMMUNICATIONS_SUCCESS_RATE
COST_OF_OUTWARD_CUSTOMER_COMMUNICATIONSCOST_OF_OUTWARD_CUSTOMER_COMMUNICATIONS
DIRECT_COST_OF_COMMUNICATIONSDIRECT_COST_OF_COMMUNICATIONS
FI_PROCESSING_TIME_FOR_COMMUNICATIONSFI_PROCESSING_TIME_FOR_COMMUNICATIONS
FOLLOW_UP_TIME_FOR_COMMUNICATIONFOLLOW_UP_TIME_FOR_COMMUNICATION
IDLE_COMMUNICATION_TIMEIDLE_COMMUNICATION_TIME
LOSS_AMOUNTLOSS_AMOUNT
PREPARATION_TIME_FOR_COMMUNICATIONPREPARATION_TIME_FOR_COMMUNICATION
PROFIT_AMOUNTPROFIT_AMOUNT
POPULATION_TIMESTAMPPOPULATION_TIMESTAMP
CUSTOMER_SEGMENT_MINI_DIMENSION_IDCUSTOMER_SEGMENT_MINI_DIMENSION_ID

Foreign Key
CUSTOMER_C_CHAN_FKCUSTOMER_C_CHAN_FK
CUSTOMER__CALEN_FKCUSTOMER__CALEN_FK
CUSTOM_INDIVIDU_FKCUSTOM_INDIVIDU_FK
CUSTO_CUSTOMER__FKCUSTO_CUSTOMER__FK

Primary Key
CUSTOMER_COMMUNICATION_FACT_PKCUSTOMER_COMMUNICATION_FACT_PK

Indexes
CUSTOMER_COMMUNICATION_FACT_PKCUSTOMER_COMMUNICATION_FACT_PK

Column Details

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



 CHANNEL_DIMENSION_ID
DescriptionThe unique identifier of the Channel Dimension.
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identityfalse
Is Nullablefalse
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 Keytrue
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 COMMUNICATIONS_FAILURE_RATE
DescriptionA Measure that identifies the number of calls which resulted in a sale expressed as a percentage of the number of calls made or received.
Data TypeDECIMAL(5 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 COMMUNICATIONS_SUCCESS_RATE
DescriptionA Measure that identifies the number of calls which resulted in a sale expressed as a percentage of the number of calls made or received.
Data TypeDECIMAL(5 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 COST_OF_OUTWARD_CUSTOMER_COMMUNICATIONS
DescriptionA measure that identifies the total cost of communications initiated by the Financial Institution. For example, the cost of sending out bank statements to customers on a monthly basis.
Data TypeDECIMAL(10 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DIRECT_COST_OF_COMMUNICATIONS
DescriptionA Measure that identifies the cost to the Financial Institution of processing communications identified by the key dimensions, both in direct channel costs and in FI resources.
Data TypeDECIMAL(10 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FI_PROCESSING_TIME_FOR_COMMUNICATIONS
Description(Total Financial Institution Processing Time For Communications)
A Measure that identifies the total number of hours spent by employees of the Financial Institution in processing Communications during the measurement period.
Data TypeTIME
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FOLLOW_UP_TIME_FOR_COMMUNICATION
DescriptionA measure that identifies the amount of time spent processing matters arising from a Communication after the communication has been completed expressed in the units referenced by Time Unit Of Measure.
For example, the amount of time an operator in a call center spends documenting issues raised by a customer complaint after the customer call ends.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 IDLE_COMMUNICATION_TIME
DescriptionA Measure that identifies the amount of available time not spent processing Communications or related activities during the measurement period expressed in the units referenced by Financial Organisation's standard Time Unit Of Measure.
Data TypeTIME
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 LOSS_AMOUNT
DescriptionA Measure that identifies the monetary value of the loss.
Data TypeDECIMAL(20 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PREPARATION_TIME_FOR_COMMUNICATION
DescriptionA measure that identifies the amount of time spent preparing for a communication during the measurement period expressed in the units referenced by Time Unit Of Measure.
For example, the amount of time an operator in a telesales call center spends gathering information about a customer and planning the call before actually calling the customer.
Data TypeTIME
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PROFIT_AMOUNT
DescriptionA Measure that identifies the monetary value of the profit.
Data TypeDECIMAL(20 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 POPULATION_TIMESTAMP
DescriptionA timestamp that identifies when this Fact Entity's instance was populated.
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



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

Foreign Key Details

 CUSTOMER_C_CHAN_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TableCUSTOMER_COMMUNICATION_FACT
Child Multiplicity*
Key ColumnCHANNEL_DIMENSION_ID [BIGINT]
Parent TableCHANNEL_DIMENSION
Parent Multiplicity0..1
Unique ConstraintCHANNEL_DIMENSION_PK



 CUSTOMER__CALEN_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TableCUSTOMER_COMMUNICATION_FACT
Child Multiplicity*
Key ColumnCALENDAR_DATE_DIMENSION_ID [BIGINT]
Parent TableCALENDAR_DATE_DIMENSION
Parent Multiplicity0..1
Unique ConstraintCALENDAR_DATE_DIMENSION_PK



 CUSTOM_INDIVIDU_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TableCUSTOMER_COMMUNICATION_FACT
Child Multiplicity*
Key ColumnINDIVIDUAL_CUSTOMER_DIMENSION_ID [BIGINT]
Parent TableINDIVIDUAL_CUSTOMER_DIMENSION
Parent Multiplicity0..1
Unique ConstraintINDIVIDUAL_CUSTOMER_DIMENSION_PK



 CUSTO_CUSTOMER__FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshipfalse
Child TableCUSTOMER_COMMUNICATION_FACT
Child Multiplicity*
Key ColumnCUSTOMER_SEGMENT_MINI_DIMENSION_ID [BIGINT]
Parent TableCUSTOMER_SEGMENT_MINI_DIMENSION
Parent Multiplicity0..1
Unique ConstraintCUSTOMER_SEGMENT_MINI_DIMENSION_PK

Primary Key Details

 CUSTOMER_COMMUNICATION_FACT_PK
DescriptionThe unique identifier of the Customer Communication Fact
MemberCHANNEL_DIMENSION_ID [BIGINT]
MemberINDIVIDUAL_CUSTOMER_DIMENSION_ID [BIGINT]
MemberCALENDAR_DATE_DIMENSION_ID [BIGINT]

Index Details

 CUSTOMER_COMMUNICATION_FACT_PK
Is Uniquetrue
Is Clusteredfalse
MemberCHANNEL_DIMENSION_ID [BIGINT] Ascending
MemberINDIVIDUAL_CUSTOMER_DIMENSION_ID [BIGINT] Ascending
MemberCALENDAR_DATE_DIMENSION_ID [BIGINT] Ascending