Table CUSTOMER_ALERTS

DescriptionCustomer Alerts identifies the alerts for a given customer about the upcoming financial events.

Columns
ALERT_IDALERT_ID
CALENDAR_DATE_DIMENSION_IDCALENDAR_DATE_DIMENSION_ID
INDIVIDUAL_CUSTOMER_DIMENSION_IDINDIVIDUAL_CUSTOMER_DIMENSION_ID
DESCRIPTIONDESCRIPTION
ACITIVITY_DIMENSION_IDACITIVITY_DIMENSION_ID

Column Details

 ALERT_ID
DescriptionThe unique identifier of the alert.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identitytrue
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CALENDAR_DATE_DIMENSION_ID
DescriptionThe unique identifier of the calendar date dimension. This measure identifies the financial event likelihood date.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
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 Keyfalse
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DESCRIPTION
DescriptionDescription identifies the alert details.
Data TypeVARCHAR(2000)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 ACITIVITY_DIMENSION_ID
DescriptionThe unique idenitifier of the Activity dimension.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse