Table CHANNEL_ROLE_MINI_DIMENSION

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

Columns
CHANNEL_ROLE_MINI_DIMENSION_IDCHANNEL_ROLE_MINI_DIMENSION_ID
AUTHORITY_LEVELAUTHORITY_LEVEL
INDEPENDENCE_CATEGORYINDEPENDENCE_CATEGORY
LEVELLEVEL
PRIORITY_LEVELPRIORITY_LEVEL
STATUSSTATUS
STATUS_REASONSTATUS_REASON
TENURE_INDUSTRYTENURE_INDUSTRY
TRAINING_LEVELTRAINING_LEVEL
UNDERWRITING_AUTHORITYUNDERWRITING_AUTHORITY

Primary Key
CHANNEL_ROLE_MINI_DIMENSION_PKCHANNEL_ROLE_MINI_DIMENSION_PK

Dependencies
AWM - TransformationAWM - Transformation

Column Details

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



 AUTHORITY_LEVEL
DescriptionThe operational authority of the channel role for selling, servicing and marketing products.

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



 INDEPENDENCE_CATEGORY
DescriptionThe degree to which the channel role is independent of an organisation for which it conducts business.

e.g. Employed
e.g. Fully independent
e.g. Limited independence
e.g. Tied
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 LEVEL
DescriptionThe level of seniority of the channel role.
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 party role against other party roles of the same type. For example, it indicates whether a person considers a particular job to be a primary or alternative source of income.

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



 STATUS
DescriptionThe position of the party role within a life-cycle model consisting of a number of statuses.

e.g. Active
e.g. Ex-Customer
e.g. Prospect
e.g. Suspect
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.

e.g. Commenced
e.g. Leave of absence
e.g. Misconduct
e.g. Resignation
e.g. Retirement
e.g. Temporary reassignment
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TENURE_INDUSTRY
DescriptionIndicates how long an agent has been an Insurance agent registered with an Agent license.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TRAINING_LEVEL
DescriptionThe level of insurance business education successfully completed by the party playing this role.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 UNDERWRITING_AUTHORITY
DescriptionThe restrictions that apply to the channel role with respect to deciding the terms on which an financial services agreement will be accepted.

e.g. L (Limited)
e.g. N (None)
e.g. P (Preferred)
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Primary Key Details

 CHANNEL_ROLE_MINI_DIMENSION_PK
DescriptionThe unique identifier of the Channel role mini dimension
MemberCHANNEL_ROLE_MINI_DIMENSION_ID [BIGINT]

Dependency Details

 AWM - Transformation