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
Mammography