Table LIFE_EVENT_DIMENSION

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

Columns
LIFE_EVENT_DIMENSION_IDLIFE_EVENT_DIMENSION_ID
EVENT_TYPEEVENT_TYPE
AUTHORIZATION_STATUSAUTHORIZATION_STATUS
CONTACT_MEDIUMCONTACT_MEDIUM
CONTEXT_FLAGCONTEXT_FLAG
EVENT_IMPACTEVENT_IMPACT
EXCEPTION_FLAGEXCEPTION_FLAG
EXECUTION_MODE_FLAGEXECUTION_MODE_FLAG
LIFE_CYCLE_STATUSLIFE_CYCLE_STATUS
LIFE_CYCLE_STATUS_REASONLIFE_CYCLE_STATUS_REASON
ORIGINATIONORIGINATION
PRIORITY_RATINGPRIORITY_RATING
PROBABILITY_OF_OCCURRENCEPROBABILITY_OF_OCCURRENCE
REPORTED_STATUSREPORTED_STATUS
SCHEDULED_FLAGSCHEDULED_FLAG
SEVERITY_LEVELSEVERITY_LEVEL
SUSPICIOUS_FLAGSUSPICIOUS_FLAG
POPULATION_DATEPOPULATION_DATE
POPULATION_TIMEPOPULATION_TIME
POPULATION_DESCRIPTIONPOPULATION_DESCRIPTION
SOURCE_SYSTEM_NAMESOURCE_SYSTEM_NAME
SOURCE_SYSTEM_CODESOURCE_SYSTEM_CODE
UNIQUE_ID_IN_SOURCE_SYSTEMUNIQUE_ID_IN_SOURCE_SYSTEM

Primary Key
LIFE_EVENT_DIMENSION_PKLIFE_EVENT_DIMENSION_PK

Indexes
LIFE_EVENT_DIMENSION_PKLIFE_EVENT_DIMENSION_PK

Column Details

 LIFE_EVENT_DIMENSION_ID
DescriptionThe unique identifier of the Event Characteristics Mini Dimension
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identitytrue
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EVENT_TYPE
DescriptionEvent Type classifies Events based on their inherent characteristics such as Political, Sociological, or Judicial, and as a Communication or Business Activity (such as travel, meetings, account postings).
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 AUTHORIZATION_STATUS
DescriptionAuthorization Status classifies Events based on whether the Event received the necessary permissions for its execution.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CONTACT_MEDIUM
DescriptionContact Medium classifies Events based on the manner in which they either took place or are preferred to take place. For example; Email, Online, Face-To-Face, Fax, File Transfer, Mail, Phone.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CONTEXT_FLAG
DescriptionContext Flag classifies Events based on the circumstances of their occurrence.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EVENT_IMPACT
DescriptionEvent Impact classifies Events based on how they affect the behavior pattern of an Involved Party, Product or Arrangement.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EXCEPTION_FLAG
DescriptionException Flag classifies Events based on whether or not the Event generated a warning notice.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EXECUTION_MODE_FLAG
DescriptionExecution Mode Flag classifies Events based on the manner in which they are executed.
Data TypeCHAR(10)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 LIFE_CYCLE_STATUS
DescriptionLife Cycle Status classifies Events based on their current state within the Event life cycle.
Data TypeCHAR(10)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 LIFE_CYCLE_STATUS_REASON
DescriptionLife Cycle Status Reason classifies Events based on the motive for changing the life cycle status of the Event.
Data TypeVARCHAR(500)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 ORIGINATION
DescriptionOrigination classifies Events based on whether or not the Event was initiated from within or outside the Financial Institution.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PRIORITY_RATING
DescriptionPriority Rating classifies Events based on the priority or importance of one Event over other Events.
Data TypeDECIMAL(5 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PROBABILITY_OF_OCCURRENCE
DescriptionProbability Of Occurrence classifies Events based on the likelihood that the Event will occur within a given period.
Data TypeDECIMAL(5 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 REPORTED_STATUS
DescriptionReported Status classifies Events based on whether the details of the occurrence of the Event have been disclosed.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SCHEDULED_FLAG
DescriptionSchedules Flag classifies Events based on whether or not it was a scheduled Event, or whether it occurred due to an unscheduled occurrence.
Data TypeCHAR(10)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SEVERITY_LEVEL
DescriptionSeverity Level classifies Events based on the severity with which the violation is to be treated.
Data TypeCHAR(10)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SUSPICIOUS_FLAG
DescriptionSuspicious Flag classifies Events based on whether or not the Event was considered to be fraudulent. For example, Suspicious=1, Not Suspicious=0.
Data TypeCHAR(10)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 POPULATION_DATE
DescriptionPopulation Date indicates the date on which the instance of the entity was last updated.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 POPULATION_TIME
DescriptionPopulation Time indicates the time on which the instance of the entity was last updated.
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 POPULATION_DESCRIPTION
DescriptionPopulation Description indicates the textual description of the population cycle.
Data TypeVARCHAR(2000)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SOURCE_SYSTEM_NAME
DescriptionSource System Name indicates the textual name by which the Source System is known.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SOURCE_SYSTEM_CODE
DescriptionSource System Code indicates the code by which the Source System is known.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 UNIQUE_ID_IN_SOURCE_SYSTEM
DescriptionUnique Id In Source System indicates the unique identifier of the populated instance in the Source System.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Primary Key Details

 LIFE_EVENT_DIMENSION_PK
MemberLIFE_EVENT_DIMENSION_ID [BIGINT]

Index Details

 LIFE_EVENT_DIMENSION_PK
Is Uniquetrue
Is Clusteredfalse
MemberLIFE_EVENT_DIMENSION_ID [BIGINT] Ascending