| WEALTH Data Model |
Description | Individual Activity identifies the specific business-related activities that an Individual wishes to engage in with the Financial Institution |
Primary Key | |
![]() |
Indexes | |
![]() |
Column Details |
Description | Individual Activity Type classifies Individual performed by the Individual with the Financial Institution |
Data Type | VARCHAR(50) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Activity Impact classifies Individual Activities based on how they affect the behavior pattern of an Involved Party, Product or Arrangement. |
Data Type | VARCHAR(50) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Authorization Status classifies Individal Activities based on whether the Individual Activity received the necessary permissions for its execution. |
Data Type | CHAR(10) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Context Flag classifies Individual Activities based on the circumstances of their occurrence. For example; Initial = 1 or Follow Up = 0. |
Data Type | CHAR(10) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Reported Status classifies Campaign Segment Activities based on whether the details of the occurrence of the Activity have been disclosed. |
Data Type | CHAR(10) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Scheduled 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 Type | CHAR(10) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Life 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 Type | CHAR(10) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Life 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 Type | VARCHAR(2000) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Population Date indicates the date on which the instance of the entity was last updated. |
Data Type | DATE |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Population Time indicates the time on which the instance of the entity was last updated. |
Data Type | TIMESTAMP |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Population Description indicates the textual description of the population cycle. |
Data Type | VARCHAR(2000) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Source System Name indicates the textual name by which the Source System is known. |
Data Type | VARCHAR(50) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Source System Code indicates the code by which the Source System is known. |
Data Type | CHAR(20) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Unique Id In Source System indicates the unique identifier of the populated instance in the Source System. |
Data Type | INTEGER |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Data Type | BIGINT |
Default Value | None |
Is Primary Key | true |
Is Identity | true |
Is Nullable | false |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Primary Key Details |
Member | INDIVIDUAL_ACTVITY_DIMENSION_ID [BIGINT] |
Index Details |
Is Unique | true |
Is Clustered | false |
Member | INDIVIDUAL_ACTVITY_DIMENSION_ID [BIGINT] Ascending |
| WEALTH Data Model |