PAT_HX_REV_TYPE

Description:

This table contains information types of history that were reviewed for a patient, such as Medical, Surgical, Socioeconomic, Alcohol, Tobacco, etc. Where in the application a type of history was reviewed is in the PAT_HX_REV_TOPIC table. Additional information about when a patient's history was reviewed and by whom is found in the PAT_HX_REVIEW table.

Primary Key

Column Name	Ordinal Position
PAT_ENC_CSN_ID	1
GROUP_LINE	2
VALUE_LINE	3

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	GROUP_LINE	INTEGER	No
	The line number of the associated instance of history review in this encounter. Together with PAT_ENC_CSN_ID, this forms the foreign key to the PAT_HX_REVIEW table.
3	VALUE_LINE	INTEGER	No
	The line number of one of the multiple history types that were reviewed for the associated instance of review and encounter from the PAT_HX_REVIEW table.
4	CONTACT_DATE	DATETIME	No
	The date of this contact in calendar format.
5	HX_REVIEWED_TYPE_C_NAME	VARCHAR	No
	The category value associated with the type of History Visit Navigator topic that was reviewed, such as Medical, Surgical, Socioeconomic, etc. May contain organization-specific values: No Category Entries: Medical Surgical ADL Substance & Sexual Activity Tobacco Alcohol Drug Use Sexual Activity Family Custom Pediatric Obstetric Social Documentation Socioeconomic Dialysis Gynecology Lifestyle Relationships BH Substance Use Vaping