PATIENT_VERIF_HX
Description:
When the verification status of a patient is changed the previous and new verification information is stored in this group of items.

Primary Key
Column Name Ordinal Position
PAT_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 PAT_ID VARCHAR No
The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
2 LINE INTEGER No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 VERIF_HX_PRE_STAT_C_NAME VARCHAR No
When verification status changes stores previous value
May contain organization-specific values: Yes
4 VERIF_HX_NEW_STAT_C_NAME VARCHAR No
When verification status changes stores new value
The category values for this column were already listed for column: VERIF_HX_PRE_STAT_C_NAME
5 VERIF_HX_USER_ID VARCHAR No
When verification status changes stores ID of user making change
6 VERIF_HX_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
7 VERIF_HX_CHNG_DT DATETIME No
When verification status changes stores date of change
8 VERIF_HX_NXT_REV_DT DATETIME No
When verification status changes stores calculated next review date