CONTSUMMARY
The CONTSUMMARY table contains a summary view of a contact record and contains indicators that track what information is stored about a particular party.
This table is used by the following domain.
| Name | Comment | Datatype | Null Option | Is PK |
|---|---|---|---|---|
| CONT_ID | A unique, system-generated key that identifies a party in the system. | BIGINT | Not Null | Yes |
| PRIVPREF_IND | Determines whether there is any party privacy preference on this party. This field is set by the system when a party privacy preference is associated with the Party record. | SMALLINT | Not Null | No |
| MISCVALUE_IND | Determines whether there is any party miscellaneous value on this party. This field is set by the system when a party miscellaneous value is associated with the Party record. | SMALLINT | Not Null | No |
| CONTACTREL_IND | Determines whether there is any party relationship on this party. This field is set by the system when a party relationship is associated with the Party record. | SMALLINT | Not Null | No |
| BANKACCOUNT_IND | Determines whether there is any party bank account on this party. This field is set by the system when a party financial profile is associated with the Party record. | SMALLINT | Not Null | No |
| CHARGECARD_IND | Determines whether there is any party charge card on this party. This field is set by the system when a party financial profile is associated with the Party record. | SMALLINT | Not Null | No |
| PAYROLLDEDUCT_IND | Determines whether there is any party payroll deduction on this party. This field is set by the system when a party financial profile is associated with the Party record. | SMALLINT | Not Null | No |
| INCOMESOURCE_IND | Determines whether there is any party income source on this party. This field is set by the system when a party financial profile is associated with the Party record. | SMALLINT | Not Null | No |
| IDENTIFIER_IND | Determines whether there is any party identifier on this party. This field is set by the system when a party identifier is associated with the Party record. | SMALLINT | Not Null | No |
| ALERT_IND | Indicates whether there is any kind of alert or restriction on this party. This field is set by the system when an active alert is associated with the Party record. | SMALLINT | Not Null | No |
| CONTEQUIV_IND | Indicates whether there is any contact equivalent on this party. This field is set by the system when a contact equivalent is associated with the Party record. | SMALLINT | Not Null | No |
| INTERACTION_IND | Indicates whether there is any interaction on this party. This field is set by the system when an interaction is associated with the Party record. | SMALLINT | Not Null | No |
| ADDRESSGROUP_IND | Indicates whether there is any party address group on this party. This field is set by the system when a party address group is associated with the Party record. | SMALLINT | Not Null | No |
| CONTMETHGROUP_IND | Indicates whether there is any party contact method group on this party. This field is set by the system when a party contact method group is associated with the Party record. | SMALLINT | Not Null | No |
| LOBREL_IND | Indicates whether there is any party line of business relationship on this party. This field is set by the system when a party line of business relationship is associated with the Party record. | SMALLINT | Not Null | No |
| LAST_UPDATE_DT | When a record is added or updated, this field is updated with the date and time. On subsequent updates, the system uses this information to ensure that the update request includes a matching date and time on this field; if it does not, the update fails. | TIMESTAMP | Not Null | No |
| LAST_UPDATE_TX_ID | A unique, system-generated key that identifies the specific transaction within the log system that either created, updated, or deleted the data row. | BIGINT | Null | No |
| LAST_UPDATE_USER | The ID of the user who last updated the data. | VARCHAR(20) | Null | No |