CLARITY_HVR

Description:

This table contains information about the generic verification (HVR) record.

Primary Key

Column Name	Ordinal Position
VERIFY_ID	1

Column Information

	Name	Type	Discontinued?
1	VERIFY_ID	NUMERIC	No
	The unique ID of the verification record
2	REC_STAT_C_NAME	VARCHAR	No
	Record status flag special item. Indicates whether the verification record is active, deleted, hidden, or a combination of statuses. May contain organization-specific values: No Category Entries: Active Inactive Deleted Inactive and Deleted Hidden Inactive and Hidden Deleted and Hidden Inactive Deleted and Hidden
3	VERIFY_TYPE_C_NAME	VARCHAR	No
	Category value representing the type of verification performed. May contain organization-specific values: Yes Category Entries: Anesthesia
4	PAT_ID	VARCHAR	No
	The unique ID of the patient associated with the verification record.
5	PAT_CSN_ID	NUMERIC	No
	The Contact Serial Number of the patient encounter the verification was performed within.
6	LOG_ID	VARCHAR	No
	Surgical log ID for this verification record.
7	VERIFY_USER_ID	VARCHAR	No
	The unique ID of the user who performed the verification
8	VERIFY_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
9	VERIFY_INSTANT	DATETIME (Attached)	No
	The instant the verification was performed