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.