Table EVENT

DescriptionA classification of events in the lifecycle of a person or organisation that are of interest to the modelled organisation from a customer and prospect relationship management perspective.
A specific incident that results or may result in a for an insurance benefit. It includes death, theft, car accident and hospitalisation.
A significant incident in the life of a Person or in the existence of an Organisation that is of interest to the modelled organisation and may be a trigger for marketing activities. For a Person it includes: marriage, moving, changing job, birth of child, and divorce.
For an organisation it includes: merger, relocation, new premises and acquisition.

Columns
EVENT_IDEVENT_ID
ANCHOR_IDANCHOR_ID
DESCRIPTIONDESCRIPTION
EFFECTIVE_FROM_DATEEFFECTIVE_FROM_DATE
EFFECTIVE_TO_DATEEFFECTIVE_TO_DATE
END_DATEEND_DATE
EVENT_TIMEEVENT_TIME
EXTERNAL_REFERENCEEXTERNAL_REFERENCE
NAMENAME
PRIORITY_RATINGPRIORITY_RATING
RISK_SCENARIO_SIMULATIONRISK_SCENARIO_SIMULATION
START_DATESTART_DATE
TYPETYPE
VALID_FROM_DATEVALID_FROM_DATE
VALID_TO_DATEVALID_TO_DATE

Primary Key
EVENT_PKEVENT_PK

Dependencies
AWM - TransformationAWM - Transformation

Column Details

 EVENT_ID
DescriptionThe unique identifier of the Event
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
DescriptionThe textual representation of information about an occurrence of event.
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 date on which the event is considered to be terminated.

e.g. The end date of a gradual pollution would be the date that the gradual pollution ceased.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EVENT_TIME
DescriptionThe time at which the event is considered to have happened.

e.g. The event time for the loss event car accident was at 4pm.
Data TypeTIME
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 event by a party for identification or communication purposes.

e.g. Code 'PL1272' identifying hurricane 'Edward'.
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 identifying an occurrence of event.

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



 PRIORITY_RATING
DescriptionThe relative importance of a task

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



 RISK_SCENARIO_SIMULATION
DescriptionIndicates that the event is part of a risk scenario.
True if the event is in a risk scenario.
Data TypeCHAR(1)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 START_DATE
DescriptionThe date at which the event is considered as having started.

e.g. for a car accident it would be the date the accident happened.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TYPE
DescriptionThe mutually exclusive categorisation of this Event.
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

Primary Key Details

 EVENT_PK
DescriptionThe unique identifier of the Event
MemberEVENT_ID [BIGINT]

Dependency Details

 AWM - Transformation