| BANKING Data Model |
Description | Involved Party Contact Information Bridge supports many-to-many relationships between the Involved Party Dimension or any other type of Involved Party, such as Organization Dimension, Individual Dimension, Organization Unit Dimension, Corporate Customer Dimension, Employee Dimension, and so on, and the Contact Information Dimension. |
Foreign Key | |
![]() |
|
![]() |
Primary Key | |
![]() |
Indexes | |
![]() |
Column Details |
Description | The unique identifier of the Nature Of Relationship. |
Data Type | BIGINT |
Default Value | None |
Is Primary Key | true |
Is Identity | false |
Is Nullable | false |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | The unique identifier of the Involved Party Dimension. This identifier can be populated with values from the Involved Party Dimension entity itself, or with values from any other type of Involved Party, such as Organization Dimension, Individual Dimension, Organization Unit Dimension, Corporate Customer Dimension, Employee Dimension, and so on. |
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 |
Description | The unique identifier of the Contact Information Dimension |
Data Type | BIGINT |
Default Value | None |
Is Primary Key | true |
Is Identity | false |
Is Nullable | false |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Nature Of Relationship classifies instances of Involved Party Contact Information Bridge based on the type of relationship that links the Involved Party and the Contact Information. For example, Contact Preference for Marketing, Contact Information for Billing. |
Data Type | VARCHAR(50) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | false |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Solicitable Flag classifies instances of Involved Party Contact Information Bridge based on whether or not the Involved Party has expressed that they would not like to receive any marketing material, brochures, etc. at this Contact Information. |
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 | Description provides a textual explanation or free form comments about the relationship between the Involved Party and the Contact Information. |
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 | Life Cycle Status classifies instances of Involved Party Contact Information Bridge based on the status of the relationship. |
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 instances of Involved Party Contact Information Bridge based on the motive for changing the life cycle status of the relationship. |
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 | Current Row Indicator indicates whether or not, among the different versions of each relationship recorded in this bridge entity, this row holds the values that are currently valid in the business reality. This indicator enables the current values of the bridge to be retrieved quickly. |
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 |
Description | Effective From Date indicates the effective date and time that represents the beginning of the time period during which the values of all attributes of the bridge occurrence are true in the business reality. |
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 | Effective To Date indicates the effective date and time that represents the end of the time period during which the values of all attributes of the bridge occurrence are true in the business reality. |
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 | Valid From Date indicates the transaction time that represents the beginning of the time period during which the values of all attributes of the bridge occurrence are true in the source system. |
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 | Valid To Date indicates the transaction time that represents the end of the time period during which the values of all attributes of the bridge occurrence are true in the source system. |
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 | The unique identifier of the Individual Customer Dimension. |
Data Type | BIGINT |
Default Value | None |
Is Primary Key | true |
Is Identity | false |
Is Nullable | false |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Foreign Key Details |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | true |
Child Table | INVOLVED_PARTY_CONTACT_INFORMATION_BRIDGE |
Child Multiplicity | * |
Key Column | CONTACT_INFORMATION_DIMENSION_ID [BIGINT] |
Parent Table | CONTACT_INFORMATION_DIMENSION |
Parent Multiplicity | 0..1 |
Unique Constraint | CONTACT_INFORMATION_DIMENSION_PK |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | true |
Child Table | INVOLVED_PARTY_CONTACT_INFORMATION_BRIDGE |
Child Multiplicity | * |
Key Column | INDIVIDUAL_CUSTOMER_DIMENSION_ID [BIGINT] |
Parent Table | INDIVIDUAL_CUSTOMER_DIMENSION |
Parent Multiplicity | 0..1 |
Unique Constraint | INDIVIDUAL_CUSTOMER_DIMENSION_PK |
Primary Key Details |
Member | INDIVIDUAL_CUSTOMER_DIMENSION_ID [BIGINT] |
Member | NATURE_OF_RELATIONSHIP_ID [BIGINT] |
Member | INVOLVED_PARTY_DIMENSION_ID [BIGINT] |
Member | CONTACT_INFORMATION_DIMENSION_ID [BIGINT] |
Index Details |
Is Unique | true |
Is Clustered | false |
Member | INDIVIDUAL_CUSTOMER_DIMENSION_ID [BIGINT] Ascending |
Member | NATURE_OF_RELATIONSHIP_ID [BIGINT] Ascending |
Member | INVOLVED_PARTY_DIMENSION_ID [BIGINT] Ascending |
Member | CONTACT_INFORMATION_DIMENSION_ID [BIGINT] Ascending |
| BANKING Data Model |