PATIENT_HPI_INFO

Description:

This table is for history of present illness information that is captured for the patient within the visit info section.

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
	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	LINE	INTEGER	No
	The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
3	HPI_HRV_ID_REASON_VISIT_NAME	VARCHAR	No
	The name of the Reason for Visit record.
4	HPI_ELEM_ID_QUEST_NAME	VARCHAR	No
	The name of the question record.
5	HPI_PROMPT	VARCHAR	No
	Stores the prompt for multiple response HPI elements related to the HPI information.
6	HPI_VALUE	VARCHAR	No
	Stores the data values for a response to an HPI element.
7	HPI_COMMENT	VARCHAR	No
	Stores the comment related to a history of present illness (HPI) finding.
8	HPI_USER_ID	VARCHAR	No
	Stores the user who entered the most recent HPI information.
9	HPI_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
10	HPI_UPDATED_IN_DTTM	DATETIME (Local)	No
	Stores the instant of entry for the most recent HPI information.