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)