PAT_ENC_HPF

Description:

The PAT_ENC_HPF table contains encounter information. Each record in this table is based on a patient contact serial number.

Primary Key

Column Name	Ordinal Position
PAT_ENC_CSN_ID	1

Column Information

	Name	Type	Discontinued?
1	PAT_ENC_DATE_REAL	FLOAT	No
	A unique, internal contact date in decimal format. The integer portion of the number indicates the date of the contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
2	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).
3	HOSP_ADMSN_DT	DATETIME	No
	The date that the patient was first admitted to the facility, bedded in the ED, or confirmed for an HOV for this contact, regardless of patient's base patient class.
4	PENDING_DISCH_DT	DATETIME	No
	The date and time of the pending discharge for this patient contact.
5	ADMISSION_PROV_ID_PROV_NAME	VARCHAR	No
	The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
6	DEPARTMENT_ID_EXTERNAL_NAME	VARCHAR	No
	The external name of the department record. This is often used in patient correspondence such as reminder letters.
7	BILL_NUM	VARCHAR	No
	An account number (or billing number) for this patient contact. This may be an external ID.
8	CONTACT_DATE	DATETIME	No
	The date of this contact in calendar format.