Table CUSTOMER_PEER_SPEND_DIFFERENCE

DescriptionCustomer Peer Spend difference identifies the customer spending pattern versus his/her peer group.

Columns
INDIVIDUAL_CUSTOMER_DIMENSION_IDINDIVIDUAL_CUSTOMER_DIMENSION_ID
AMOUNTAMOUNT
CUSTOMER_PEER_DIMENSION_IDCUSTOMER_PEER_DIMENSION_ID
SPEND_DIFFERENCE_DIMENSION_IDSPEND_DIFFERENCE_DIMENSION_ID

Column Details

 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



 AMOUNT
DescriptionAmount measure identifies the expense incurred by the individual or expense incurred by the peer group.

Spend difference dimension identifier identifier identifies whether the amount is associated with the individual or with the peer group.
Data TypeDECIMAL(31 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CUSTOMER_PEER_DIMENSION_ID
DescriptionThe unique identifier of the peer group.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SPEND_DIFFERENCE_DIMENSION_ID
DescriptionThe unique identifier of the spend difference dimension.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse