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.