Table INVOLVED_PARTY_CONTACT_INFORMATION_BRIDGE

DescriptionInvolved 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.

Columns
NATURE_OF_RELATIONSHIP_IDNATURE_OF_RELATIONSHIP_ID
INVOLVED_PARTY_DIMENSION_IDINVOLVED_PARTY_DIMENSION_ID
CONTACT_INFORMATION_DIMENSION_IDCONTACT_INFORMATION_DIMENSION_ID
NATURE_OF_RELATIONSHIPNATURE_OF_RELATIONSHIP
SOLICITABLE_FLAGSOLICITABLE_FLAG
DESCRIPTIONDESCRIPTION
LIFE_CYCLE_STATUSLIFE_CYCLE_STATUS
LIFE_CYCLE_STATUS_REASONLIFE_CYCLE_STATUS_REASON
CURRENT_ROW_INDICATORCURRENT_ROW_INDICATOR
EFFECTIVE_FROM_DATEEFFECTIVE_FROM_DATE
EFFECTIVE_TO_DATEEFFECTIVE_TO_DATE
VALID_FROM_DATEVALID_FROM_DATE
VALID_TO_DATEVALID_TO_DATE
INDIVIDUAL_CUSTOMER_DIMENSION_IDINDIVIDUAL_CUSTOMER_DIMENSION_ID

Foreign Key
INVOLVED_P_CONT_FKINVOLVED_P_CONT_FK
INVOLVED_P_INDI_FKINVOLVED_P_INDI_FK

Primary Key
INVOLVED_PARTY_CONTACT_INFORMATION_BRIDGE_PKINVOLVED_PARTY_CONTACT_INFORMATION_BRIDGE_PK

Indexes
INVOLVED_PARTY_CONTACT_INFORMATION_BRIDGE_PKINVOLVED_PARTY_CONTACT_INFORMATION_BRIDGE_PK

Column Details

 NATURE_OF_RELATIONSHIP_ID
DescriptionThe unique identifier of the Nature Of Relationship.
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 INVOLVED_PARTY_DIMENSION_ID
DescriptionThe 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 TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CONTACT_INFORMATION_DIMENSION_ID
DescriptionThe unique identifier of the Contact Information Dimension
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NATURE_OF_RELATIONSHIP
DescriptionNature 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 TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SOLICITABLE_FLAG
DescriptionSolicitable 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 TypeCHAR(10)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DESCRIPTION
DescriptionDescription provides a textual explanation or free form comments about the relationship between the Involved Party and the Contact Information.
Data TypeVARCHAR(2000)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 LIFE_CYCLE_STATUS
DescriptionLife Cycle Status classifies instances of Involved Party Contact Information Bridge based on the status of the relationship.
Data TypeVARCHAR(50)
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 instances of Involved Party Contact Information Bridge based on the motive for changing the life cycle status of the relationship.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CURRENT_ROW_INDICATOR
DescriptionCurrent 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 TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EFFECTIVE_FROM_DATE
DescriptionEffective 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 TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EFFECTIVE_TO_DATE
DescriptionEffective 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 TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 VALID_FROM_DATE
DescriptionValid 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 TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 VALID_TO_DATE
DescriptionValid 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 TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 INDIVIDUAL_CUSTOMER_DIMENSION_ID
DescriptionThe unique identifier of the Individual Customer Dimension.
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Foreign Key Details

 INVOLVED_P_CONT_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TableINVOLVED_PARTY_CONTACT_INFORMATION_BRIDGE
Child Multiplicity*
Key ColumnCONTACT_INFORMATION_DIMENSION_ID [BIGINT]
Parent TableCONTACT_INFORMATION_DIMENSION
Parent Multiplicity0..1
Unique ConstraintCONTACT_INFORMATION_DIMENSION_PK



 INVOLVED_P_INDI_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TableINVOLVED_PARTY_CONTACT_INFORMATION_BRIDGE
Child Multiplicity*
Key ColumnINDIVIDUAL_CUSTOMER_DIMENSION_ID [BIGINT]
Parent TableINDIVIDUAL_CUSTOMER_DIMENSION
Parent Multiplicity0..1
Unique ConstraintINDIVIDUAL_CUSTOMER_DIMENSION_PK

Primary Key Details

 INVOLVED_PARTY_CONTACT_INFORMATION_BRIDGE_PK
MemberNATURE_OF_RELATIONSHIP_ID [BIGINT]
MemberINVOLVED_PARTY_DIMENSION_ID [BIGINT]
MemberINDIVIDUAL_CUSTOMER_DIMENSION_ID [BIGINT]
MemberCONTACT_INFORMATION_DIMENSION_ID [BIGINT]

Index Details

 INVOLVED_PARTY_CONTACT_INFORMATION_BRIDGE_PK
Is Uniquetrue
Is Clusteredfalse
MemberNATURE_OF_RELATIONSHIP_ID [BIGINT] Ascending
MemberINVOLVED_PARTY_DIMENSION_ID [BIGINT] Ascending
MemberINDIVIDUAL_CUSTOMER_DIMENSION_ID [BIGINT] Ascending
MemberCONTACT_INFORMATION_DIMENSION_ID [BIGINT] Ascending