PAT_ENC_RSN_VISIT

Description: |
The PAT_ENC_RSN_VISIT contains the data entered as the Reason for Visit for a clinical system encounter. Each row in this table is one reason for visit associated with a patient encounter. One patient encounter may have multiple reasons for visit; therefore, the item LINE is used to identify each reason for visit within an encounter.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
PAT_ENC_CSN_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | PAT_ENC_CSN_ID | NUMERIC | No |
A unique serial number for this encounter. This number is unique across all patients and encounters in the system.
2 | LINE | INTEGER | No |
The line number of the reason for visit within the encounter.
3 | ENC_REASON_ID_REASON_VISIT_NAME | VARCHAR | No |
The name of the Reason for Visit record.
4 | COMMENTS | VARCHAR | No |
The comments associated with the reason for visit entered in a clinical system exam encounter.
5 | RFV_ONSET_DT | DATETIME | No |
The onset date for reason for call/visit stored on this line. Typically this value will only be collected during call workflows such as a telephone encounter.
6 | BODY_LOC_ID | NUMERIC | No |
The body location associated with the reason for visit for this patient encounter. This column is frequently used to link to the VESSEL_DOC table.
7 | BODY_LOC_ID_RECORD_NAME | VARCHAR | No |
Stores record name (.2)