CASE_CONTACT_INFO

Description: |
This table contains information about the case contacts.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
CASE_ID | 1 |
CONTACT_DATE_REAL | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | CASE_ID | NUMERIC | No |
The internal ID of the case record.
2 | CONTACT_DATE_REAL | FLOAT | No |
This is a numeric representation of the date of this encounter in your system. The integer portion of the number specifies the date of the encounter. The digits after the decimal point indicate multiple visits on one day.
3 | CONTACT_DATE | DATETIME | No |
Contact date in external format
4 | CONTACT_TYPE_C_NAME | VARCHAR | No |
The contact type category ID for the case event.
May contain organization-specific values: Yes
Category Entries:
Case created
5 | CONTACT_SEVERITY_C_NAME | VARCHAR | No |
The contact severity category ID for the case event.
May contain organization-specific values: Yes
6 | REVIEWED_DATE | DATETIME | No |
Date the contact was reviewed
7 | REVIEWED_BY_USER_ID | VARCHAR | No |
User who reviewed the contact
8 | REVIEWED_BY_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
9 | CONTACT_SUMMARY | VARCHAR | No |
The case contact summary.