PAT_HX_REVIEW

Description:

This table contains information about when a patient's history was reviewed and by whom. More detailed information on what kinds of history were reviewed is in the PAT_HX_REV_TYPE and PAT_HX_REV_TOPIC tables.

Primary Key

Column Name	Ordinal Position
PAT_ENC_CSN_ID	1
LINE_COUNT	2

Column Information

	Name	Type	Discontinued?
1	PAT_ENC_CSN_ID	NUMERIC	No
	The unique contact serial number for this contact. This number is unique across all patient encounters in your system. If you use IntraConnect this is the Unique Contact Identifier (UCI).
2	LINE_COUNT	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	CONTACT_DATE	DATETIME	No
	The date of this contact in calendar format.
4	HX_REVIEWED_USER_ID	VARCHAR	No
	The unique ID of the user who reviewed history for the patient.
5	HX_REVIEWED_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
6	HX_REVIEWED_DATE	DATETIME	No
	The date history was reviewed for this patient.
7	HX_REVIEWED_INSTANT	DATETIME (Local)	No
	The date and time history was reviewed for this patient.