Table CAMPAIGN_MINI_DIMENSION

DescriptionGrouping of attributes used to perform analysis on instances of Campaign that share the same characteristics.

Columns
CAMPAIGN_MINI_DIMENSION_IDCAMPAIGN_MINI_DIMENSION_ID
CATEGORYCATEGORY
FREQUENCYFREQUENCY
PRIORITY_LEVELPRIORITY_LEVEL
REASON_FOR_ENDINGREASON_FOR_ENDING
STATUSSTATUS
STATUS_REASONSTATUS_REASON

Primary Key
CAMPAIGN_MINI_DIMENSION_PKCAMPAIGN_MINI_DIMENSION_PK

Dependencies
AWM - TransformationAWM - Transformation

Column Details

 CAMPAIGN_MINI_DIMENSION_ID
DescriptionThe unique identifier of the Campaign mini dimension
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identitytrue
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CATEGORY
DescriptionThe category to which the campaign belongs.

e.g. Direct marketing
e.g. Event triggered
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FREQUENCY
DescriptionThe regularity with which the activity occurrence happens or is planned to happen. Activity occurrences can be recurrent.

e.g. The radio-therapy is planned to be carried out weekly.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PRIORITY_LEVEL
DescriptionThe relative priority of the activity with respect to other activities of the same type. For example, it distinguishes between a primary and secondary occupation.

e.g. Primary
e.g. Secondary
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 REASON_FOR_ENDING
DescriptionThe explanation for the cessation of the activity

e.g. Change of employment
e.g. Injury
e.g. Loss of interest
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 STATUS
DescriptionThe position of the campaign within a life-cycle consisting of a number of statuses.

e.g. Initiated
e.g. Ongoing
e.g. Suspended
e.g. Terminated
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 STATUS_REASON
DescriptionThe reason explaining why there was a status change.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Primary Key Details

 CAMPAIGN_MINI_DIMENSION_PK
DescriptionThe unique identifier of the Campaign mini dimension
MemberCAMPAIGN_MINI_DIMENSION_ID [BIGINT]

Dependency Details

 AWM - Transformation