Table TASK

DescriptionAn the modelled organisation performs as part of its business, independently of whether the task is performed in house or outsourced.

e.g. The survey run by Acme to evaluate the customer satisfaction in September 2000.

Columns
TASK_IDTASK_ID
ANCHOR_IDANCHOR_ID
DESCRIPTIONDESCRIPTION
EFFECTIVE_FROM_DATEEFFECTIVE_FROM_DATE
EFFECTIVE_TO_DATEEFFECTIVE_TO_DATE
END_DATEEND_DATE
EXTERNAL_REFERENCEEXTERNAL_REFERENCE
NAMENAME
OBJECTIVEOBJECTIVE
PLANNED_END_DATEPLANNED_END_DATE
PLANNED_START_DATEPLANNED_START_DATE
REQUEST_DATEREQUEST_DATE
RESTART_COUNTERRESTART_COUNTER
SCENARIOSCENARIO
START_DATESTART_DATE
TASK_MINI_DIMENSION_IDTASK_MINI_DIMENSION_ID
TYPETYPE
VALID_FROM_DATEVALID_FROM_DATE
VALID_TO_DATEVALID_TO_DATE
VARIANCE_PERIODVARIANCE_PERIOD
PLANNED_COST_PER_OCCURRENCEPLANNED_COST_PER_OCCURRENCE
PLANNED_MANPOWERPLANNED_MANPOWER

Primary Key
TASK_PKTASK_PK

Dependencies
AWM - TransformationAWM - Transformation

Column Details

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



 ANCHOR_ID
DescriptionAny value without business meaning that uniquely distinguishes occurrences of this entity independently of its history.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DESCRIPTION
DescriptionA free-text statement used to explain the meaning of the task. This may include information about the context of the task as well as any background information.
Data TypeVARCHAR(256)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EFFECTIVE_FROM_DATE
DescriptionThe effective date and time that represents the beginning of the time period during which the values of all attributes of the entity occurrence are true in the business reality.
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EFFECTIVE_TO_DATE
DescriptionThe effective date and time that represents the end of the time period during which the values of all attributes of the entity occurrence are true in the business reality.
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 END_DATE
DescriptionThe end of the period during which the task takes place with some regularity.
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EXTERNAL_REFERENCE
DescriptionThe number or code assigned to a task by a party for identification or communication purposes.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NAME
DescriptionThe word or phrase used to identify (but not uniquely) the task.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 OBJECTIVE
DescriptionThe textual description of the task's objectives or business goals.
Data TypeVARCHAR(256)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PLANNED_END_DATE
DescriptionThe date at which the task is planned to end.
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PLANNED_START_DATE
DescriptionThe date at which the task is planned to start.
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 REQUEST_DATE
DescriptionIndicates the date the task was requested.
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 RESTART_COUNTER
DescriptionThe number of times this task has been restarted. Derived from any new start date recorded.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SCENARIO
DescriptionIndicates the principles, rules, assumptions, data set(s), factors or variables that are used to perform a risk assessment or a financial valuation activity, in particular a solvency valuation.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 START_DATE
DescriptionThe beginning of the period during which the task takes place with some regularity.
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TASK_MINI_DIMENSION_ID
DescriptionSoft link to Task mini dimension
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TYPE
DescriptionThe mutually exclusive categorisation of this Task.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 VALID_FROM_DATE
DescriptionThe transaction time that represents the beginning of the time period during which the values of this recorded data are true in the source system.
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 VALID_TO_DATE
DescriptionThe transaction time that represents the end of the time period during which the values of this recorded data are true in the source system.
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 VARIANCE_PERIOD
DescriptionIdentifies the period of time for which variance of financial indicators is measured.
For example, measuring the variation of currency exchange rates for a period of 2 years.

e.g. 1 year
e.g. 5 years
e.g. 6 months
Data TypeDECIMAL(20 , 6)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PLANNED_COST_PER_OCCURRENCE
DescriptionThe planned monetary amount allocated for every occurrence of the task.
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PLANNED_MANPOWER
DescriptionThe planned manpower required for the particular execution of a task.
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Primary Key Details

 TASK_PK
DescriptionThe unique identifier of the Task
MemberTASK_ID [BIGINT]

Dependency Details

 AWM - Transformation