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.