Table COMMUNICATION_MINI_DIMENSION

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

Columns
COMMUNICATION_MINI_DIMENSION_IDCOMMUNICATION_MINI_DIMENSION_ID
DIRECTIONDIRECTION
PRIORITYPRIORITY
PURPOSEPURPOSE
STATUSSTATUS
STATUS_REASONSTATUS_REASON

Primary Key
COMMUNICATION_MINI_DIMENSION_PKCOMMUNICATION_MINI_DIMENSION_PK

Dependencies
AWM - TransformationAWM - Transformation

Column Details

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



 DIRECTION
DescriptionThe direction of a communication relative to the modelled organisation.

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



 PRIORITY
DescriptionThe numeric value that specifies the importance of this communication relative to other communications.

e.g. 1 (High Priority)
e.g. 5 (Low Priority)
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PURPOSE
DescriptionIndicates why a communication occurs or is planned to occur.

e.g. Campaign mailing
e.g. Claim coverage notification
e.g. Complaint
e.g. Demographic data
e.g. Quotation request
e.g. Regular statement
e.g. Returned mail
e.g. Sale
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 communication within a life-cycle model consisting of a number of statuses.

e.g. Awaiting further information
e.g. Closed
e.g. Open
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

 COMMUNICATION_MINI_DIMENSION_PK
DescriptionThe unique identifier of the Communication mini dimension
MemberCOMMUNICATION_MINI_DIMENSION_ID [BIGINT]

Dependency Details

 AWM - Transformation