We use cookies from Google Analytics to improve our website. By accepting, you will receive these cookies from open.epic. Decline if you wish to use open.epic without these cookies. Read our privacy policy here.

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