VARIANCE

Description:

This table contains data on variance (IVR) records associated with a patient.

Primary Key

Column Name	Ordinal Position
VARIANCE_ID	1

Column Information

	Name	Type	Discontinued?
1	VARIANCE_ID	VARCHAR	No
	The unique ID for the variance record.
2	USER_ID	VARCHAR	No
	The unique ID of the user creating this record.
3	USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
4	USER_DISC_TYPE_ID	VARCHAR	No
	The unique ID of the discipline of the user creating this variance record.
5	USER_DISC_TYPE_ID_DISC_NAME	VARCHAR	No
	The name of the discipline record.
6	CREATED_TIME	DATETIME (Local)	No
	The instant this variance record was created.
7	CSN	NUMERIC	No
	The patient contact serial number for this variance.
8	DEPARTMENT_ID_EXTERNAL_NAME	VARCHAR	No
	The external name of the department record. This is often used in patient correspondence such as reminder letters.
9	VARIANCE_TYPE_ID	VARCHAR	No
	The unique ID for the variance type associated with this record.
10	VARIANCE_TYPE_ID_VARIANCE_NAME	VARCHAR	No
	The name of the variance type record.
11	VAR_CAT_C_NAME	VARCHAR	No
	The category assigned to this variance record. May contain organization-specific values: Yes
12	GOAL_ID	VARCHAR	No
	The unique ID of the goal associated with this variance record.
13	GOAL_TYPE_ID	VARCHAR	No
	The unique ID of the goal type associated with this variance record.
14	GOAL_TYPE_ID_GOAL_NAME	VARCHAR	No
	The name of the goal type record.
15	INTERVENTION_ID	VARCHAR	No
	The unique ID of the intervention associated with this variance record.
16	INTRVNTN_TYPE_ID_INTRVNTN_TYPE_NAME	VARCHAR	No
	The name of the intervention type.
17	DISPLAY_NAME	VARCHAR	No
	The display name for this record.