VAR_CONTACT

Description:

This table contains the contact specific information for each variance record.

Primary Key

Column Name	Ordinal Position
VARIANCE_ID	1
CONTACT_DATE_REAL	2

Column Information

	Name	Type	Discontinued?
1	VARIANCE_ID	VARCHAR	No
	The unique ID for the variance record.
2	CONTACT_DATE_REAL	FLOAT	No
	The internal contact date for this variance record.
3	CONTACT_DATE	DATETIME	No
	The date of this contact in calendar format.
4	IMPACT_C_NAME	VARCHAR	No
	The impact rating for this variance contact. May contain organization-specific values: Yes
5	LAST_UPD_USER_ID	VARCHAR	No
	The unique ID of the user to last update this contact.
6	LAST_UPD_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
7	LAST_UPDATE_TIME	DATETIME (Local)	No
	The instance this contact was last updated.
8	CONTACT_NUM	VARCHAR	No
	Contact number for the variance contact.
9	INSTANT_OF_ENT_DTTM	DATETIME (Local)	No
	The instant of entry.
10	READING_CAREPLAN_CSN_ID	NUMERIC	No
	Links to the care plan contact that this variance was documented under
11	VARIANCE_COMMENT	VARCHAR	No
	The comment added to a variance on a care plan.