Table INDIVIDUAL_ACTIVITY_DIMENSION

DescriptionIndividual Activity identifies the specific business-related activities that an Individual wishes to engage in with the Financial Institution

Columns
INDIVIDUAL_ACTIVITY_TYPEINDIVIDUAL_ACTIVITY_TYPE
ACTIVITY_IMPACTACTIVITY_IMPACT
AUTHORIZATION_STATUSAUTHORIZATION_STATUS
CONTEXT_FLAGCONTEXT_FLAG
REPORTED_STATUSREPORTED_STATUS
SCHEDULED_FLAGSCHEDULED_FLAG
LIFE_CYCLE_STATUSLIFE_CYCLE_STATUS
LIFE_CYCLE_STATUS_REASONLIFE_CYCLE_STATUS_REASON
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
INDIVIDUAL_ACTVITY_DIMENSION_IDINDIVIDUAL_ACTVITY_DIMENSION_ID

Primary Key
INDIVIDUAL_ACTIVITY_DIMENSION_PKINDIVIDUAL_ACTIVITY_DIMENSION_PK

Indexes
INDIVIDUAL_ACTIVITY_DIMENSION_PKINDIVIDUAL_ACTIVITY_DIMENSION_PK

Column Details

 INDIVIDUAL_ACTIVITY_TYPE
DescriptionIndividual Activity Type classifies Individual performed by the Individual with the Financial Institution
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 ACTIVITY_IMPACT
DescriptionActivity Impact classifies Individual Activities 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



 AUTHORIZATION_STATUS
DescriptionAuthorization Status classifies Individal Activities based on whether the Individual Activity received the necessary permissions for its execution.
Data TypeCHAR(10)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CONTEXT_FLAG
DescriptionContext Flag classifies Individual Activities based on the circumstances of their occurrence. For example; Initial = 1 or Follow Up = 0.
Data TypeCHAR(10)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 REPORTED_STATUS
DescriptionReported Status classifies Campaign Segment Activities based on whether the details of the occurrence of the Activity have been disclosed.
Data TypeCHAR(10)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SCHEDULED_FLAG
DescriptionScheduled Flag classifies Campaign Segment Activities based on whether or not it was a scheduled Campaign Segment Activity, 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



 LIFE_CYCLE_STATUS
DescriptionLife Cycle Status Type classifies Campaign Segment Activities based on their current state within the life cycle.

* Domain *
Potential Segment Activity
Pending Segment Activity
In Progress Segment Activity
Suspended Segment Activity
Cancelled Segment Activity
Superseded Segment Activity
Completed Segment Activity
Abandoned Segment Activity
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 Campaign Segment Activities based on the motive for changing the life cycle status of the Campaign or associated Activity.

* Domain *
Preparation For New Product
Unfavorable Reaction Received
Campaign Funding Exhausted
Campaign Normal Termination
Data TypeVARCHAR(2000)
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 TypeCHAR(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 TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 INDIVIDUAL_ACTVITY_DIMENSION_ID
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identitytrue
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Primary Key Details

 INDIVIDUAL_ACTIVITY_DIMENSION_PK
MemberINDIVIDUAL_ACTVITY_DIMENSION_ID [BIGINT]

Index Details

 INDIVIDUAL_ACTIVITY_DIMENSION_PK
Is Uniquetrue
Is Clusteredfalse
MemberINDIVIDUAL_ACTVITY_DIMENSION_ID [BIGINT] Ascending