Table TASK_MINI_DIMENSION

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

Columns
TASK_MINI_DIMENSION_IDTASK_MINI_DIMENSION_ID
COURSE_LANGUAGECOURSE_LANGUAGE
FORMAT_OF_TRAININGFORMAT_OF_TRAINING
FREQUENCYFREQUENCY
INSURABLEINSURABLE
METHODMETHOD
OUTSOURCEDOUTSOURCED
PRIORITY_LEVELPRIORITY_LEVEL
REASON_FOR_ENDINGREASON_FOR_ENDING
REINSURANCE_STATUSREINSURANCE_STATUS
SCENARIO_VALUATION_BASISSCENARIO_VALUATION_BASIS
SOLVENCY_MARGIN_STATUSSOLVENCY_MARGIN_STATUS
TAX_STATUSTAX_STATUS
VALUATION_STATEVALUATION_STATE
DISTRIBUTION_CALCULATION_METHODDISTRIBUTION_CALCULATION_METHOD
STATUSSTATUS
STATUS_REASONSTATUS_REASON

Primary Key
TASK_MINI_DIMENSION_PKTASK_MINI_DIMENSION_PK

Dependencies
AWM - TransformationAWM - Transformation

Column Details

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



 COURSE_LANGUAGE
DescriptionThe main language in which the training course is conducted.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FORMAT_OF_TRAINING
DescriptionThe setting, or format, of the training task.

e.g. Conference
e.g. E-learning
e.g. On the job
e.g. Seminar
e.g. Workshop
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 task happens or is planned to happen. Tasks can be recurrent.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 INSURABLE
DescriptionIndicates whether or not the task is considered to be insurable by the modelled organisation.
Data TypeCHAR(1)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 METHOD
DescriptionThe means by which the assessment performed by the task is derived.

e.g. Certified gemmologist appraisal
e.g. Data mining algorithm
e.g. Purchased demographic data
e.g. Real estate appraisal
e.g. Survey
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 OUTSOURCED
DescriptionIndicates whether the task is performed by resources internal to the modelled organisation, or, by external resources.
True when the task is performed by external resources.
Data TypeCHAR(1)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PRIORITY_LEVEL
DescriptionThe relative priority of the task with respect to other tasks of the same type.
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 task.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 REINSURANCE_STATUS
DescriptionIndicates whether reinsurance has been taken into consideration when performing the actuarial calculations.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SCENARIO_VALUATION_BASIS
DescriptionNames the set of parameters and their respective values that have been taken into consideration when calculating the analytical measures that scenarios govern.
The set of assumptions that those parameters and their values represent is labelled as a 'valuation basis'. The labels are essentially arbitrary, and may be plain text set by business users, such as actuaries.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SOLVENCY_MARGIN_STATUS
DescriptionIndicates whether the solvency margin has been taken into consideration when performing the actuarial calculations.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TAX_STATUS
DescriptionIndicates how taxation has been taken into consideration when performing the actuarial calculations.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 VALUATION_STATE
DescriptionIndication of the state of the values used as input into the task.
It indicates the types of assumptions and data set(s) that were used to perform the task.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DISTRIBUTION_CALCULATION_METHOD
DescriptionThe distribution calculation method used.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 STATUS
DescriptionIdentifies the position of the organisation within a life-cycle model consisting of a number of statuses.
It is used for all statuses other than foundation and dissolution.

e.g. Active
e.g. Closed out
e.g. Compulsory liquidation
e.g. Liquidation
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 STATUS_REASON
DescriptionThe additional information to explain the latest status of the organisation.

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

Primary Key Details

 TASK_MINI_DIMENSION_PK
DescriptionThe unique identifier of the Task mini dimension
MemberTASK_MINI_DIMENSION_ID [BIGINT]

Dependency Details

 AWM - Transformation