PAT_ENC_HSP
Description:
This table is the primary table for hospital encounter information. A hospital encounter is a contact in the patient record created through an ADT workflow such as preadmission, admission, ED Arrival, discharge, and hospital outpatient visit (HOV) contacts. These contact types have the ADT flag (I EPT 10101) set to 1. This table excludes all other contacts.

Primary Key
Column Name Ordinal Position
PAT_ENC_CSN_ID 1

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 ADT_PAT_CLASS_C_NAME VARCHAR No
The category value corresponding to the patient classification for this patient contact.
May contain organization-specific values: Yes
3 ADT_PATIENT_STAT_C_NAME VARCHAR No
The category value corresponding to the patient status for this patient contact.
May contain organization-specific values: No
Category Entries:
Preadmission
Admission
Discharged
Leave of Absence
Hospital Outpatient Visit
4 LEVEL_OF_CARE_C_NAME VARCHAR No
The category value corresponding to the level of care for this patient contact.
May contain organization-specific values: Yes
5 PENDING_DISCH_TIME DATETIME (Local) No
The date and time of the pending discharge for this patient contact.
6 DISCH_CODE_C_NAME VARCHAR No
The category value corresponding to the discharge code for this patient contact.
May contain organization-specific values: Yes
7 ADT_ATHCRT_STAT_C_NAME VARCHAR No
The category value corresponding to the authorization/certification status for this patient contact.
May contain organization-specific values: Yes
Category Entries:
Incomplete
Complete
Not Needed
8 PREADM_UNDO_RSN_C_NAME VARCHAR No
The category value corresponding to the preadmission undo reason for this patient contact.
May contain organization-specific values: Yes
9 EXP_ADMISSION_TIME DATETIME (Local) No
The date and time of the expected admission for this patient contact.
10 EXP_LEN_OF_STAY INTEGER No
The expected length of stay in days of the admission for this patient contact.
11 EXP_DISCHARGE_DATE DATETIME No
The date of expected discharge of the admission for this patient contact.
12 ADMIT_CATEGORY_C_NAME VARCHAR No
The category value corresponding to the admission category for this patient contact.
May contain organization-specific values: Yes
13 ADMIT_SOURCE_C_NAME VARCHAR No
The category value corresponding to the admission source for this patient contact.
May contain organization-specific values: Yes
14 TYPE_OF_ROOM_C_NAME VARCHAR No
The category value corresponding to the type of room requested for this patient contact.
May contain organization-specific values: Yes
15 TYPE_OF_BED_C_NAME VARCHAR No
The category value corresponding to the type of bed requested for this patient contact.
May contain organization-specific values: Yes
16 RSN_FOR_BED_C_NAME VARCHAR No
The category value corresponding to the reason for the type of bed requested for this patient contact.
May contain organization-specific values: Yes
17 DELIVERY_TYPE_C_NAME VARCHAR No
The category value corresponding to the delivery type of the child for this patient contact.
May contain organization-specific values: Yes
Category Entries:
Vaginal, Spontaneous
C-Section, Low Transverse
Vertical C-Section
C-Section, Unspecified
Vaginal, Vacuum (Extractor)
Vaginal, Forceps
Vaginal, Breech
Non-Spontaneous Vaginal Delivery
VBAC, Spontaneous
C-Section, Low Vertical
C-Section, Classical
Biochemical
18 LABOR_STATUS_C_NAME VARCHAR No
The category value corresponding to the labor status for this patient contact.
May contain organization-specific values: No
Category Entries:
Expected
Assessment
Admitted
Delivered
Newborn
Discharged
Reserved
Undo
19 ER_INJURY VARCHAR No
Free text description of injury for this patient contact.
20 ADT_ARRIVAL_TIME DATETIME (Local) No
The date and time of arrival for this patient contact.
21 ADT_ARRIVAL_STS_C_NAME VARCHAR No
The category value corresponding to the arrival status for this patient contact.
May contain organization-specific values: Yes
Category Entries:
Expected
Waiting
Roomed
Admitted to ED
Transferred
Departed
22 HOSP_ADMSN_TIME DATETIME (Local) No
The date and time 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.
23 ADMIT_CONF_STAT_C_NAME VARCHAR No
The category value corresponding to the (admission) confirmation status for this patient contact.
May contain organization-specific values: No
Category Entries:
Confirmed
Pending
Canceled
Completed
24 HOSP_DISCH_TIME DATETIME (Local) No
The hospital discharge date and time for this patient contact.
25 HOSP_ADMSN_TYPE_C_NAME VARCHAR No
The category value corresponding to the admission type for the patient contact.
May contain organization-specific values: Yes
26 ROOM_ID_ROOM_NAME VARCHAR No
The name of the Room record.
27 HOSP_SERV_C_NAME VARCHAR No
The category value corresponding to the hospital service for this patient contact.
May contain organization-specific values: Yes
28 MEANS_OF_DEPART_C_NAME VARCHAR No
The category value corresponding to the means of departure of the patient for this patient contact.
May contain organization-specific values: Yes
29 DISCH_DISP_C_NAME VARCHAR No
The category value corresponding to the discharge disposition for this patient contact.
May contain organization-specific values: Yes
30 DISCH_DEST_C_NAME VARCHAR No
The category value corresponding to the discharge destination for this patient contact.
May contain organization-specific values: Yes
31 TRANSFER_FROM_C_NAME VARCHAR No
The category value corresponding to the transfer from location for this patient contact.
May contain organization-specific values: Yes
32 MEANS_OF_ARRV_C_NAME VARCHAR No
The category value corresponding to the means of arrival of the patient for this patient contact.
May contain organization-specific values: Yes
33 ACUITY_LEVEL_C_NAME VARCHAR No
The category value corresponding to the acuity level for this patient contact.
May contain organization-specific values: Yes
34 HOSPIST_NEEDED_YN VARCHAR No
Indicates whether a hospitalist needs to be assigned to the patient for this contact.
May contain organization-specific values: No
Category Entries:
Yes
No
35 ACCOMMODATION_C_NAME VARCHAR No
The category value corresponding to the room accommodation for this patient contact.
The category values for this column were already listed for column: TYPE_OF_ROOM_C_NAME
36 ACCOM_REASON_C_NAME VARCHAR No
The category value corresponding to the reason for the room accommodation for this patient contact.
May contain organization-specific values: Yes
37 INPATIENT_DATA_ID VARCHAR No
The unique ID of the Inpatient Data Store record.
38 PVT_HSP_ENC_C_NAME VARCHAR No
The category value corresponding to private encounter setting for this patient contact.
May contain organization-specific values: Yes
39 ED_EPISODE_ID NUMERIC No
The unique ID of the Inpatient episode record for the ED visit.
40 ED_DISPOSITION_C_NAME VARCHAR No
The disposition of the patient when discharged from the ED.
May contain organization-specific values: Yes
41 ED_DISP_TIME DATETIME (Local) No
The date and time that the disposition was entered.
42 FOLLOWUP_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.
43 PROV_CONT_INFO VARCHAR No
The contact information for the patient's follow-up provider.
44 OSHPD_ADMSN_SRC_C_NAME VARCHAR No
Office of Statewide Health Planning and Development (OSHPD) Source of Admission
May contain organization-specific values: Yes
45 OSHPD_LICENSURE_C_NAME VARCHAR No
Office of Statewide Health Planning and Development (OSHPD) Licensure of Site
May contain organization-specific values: Yes
46 OSHPD_ROUTE_C_NAME VARCHAR No
Office of Statewide Health Planning and Development (OSHPD) Route of Admission
May contain organization-specific values: Yes
47 INP_ADM_DATE DATETIME (Local) No
Date-time of the inpatient admission. This is the date/time during the hospital encounter when the patient first received a base patient class of inpatient. This can be different than the value for the admission date if the patient was assigned an emergency or outpatient base patient class.
48 COPY_TO_PCP_YN VARCHAR No
This item will indicate whether the PCP effective for the patient should be notified upon a pre-determined system event.
The category values for this column were already listed for column: HOSPIST_NEEDED_YN
49 ADOPTION_CASE_YN VARCHAR No
Item to store whether the current contact is related to an adoption case.
The category values for this column were already listed for column: HOSPIST_NEEDED_YN
50 PREOP_TEACHING_C_NAME VARCHAR No
This item describes whether a patient has been offered or given any pre-operative teaching.
May contain organization-specific values: Yes
Category Entries:
Yes
No
51 PREOP_PRN_EVAL_C_NAME VARCHAR No
This is a category item that describes whether a patient has been offered or given a pre-operative nurse practitioner evaluation.
May contain organization-specific values: Yes
Category Entries:
Yes
No
52 PREOP_PH_SCREEN_C_NAME VARCHAR No
This is a category list that describes whether a patient has been offered or given a pre-operative phone screening.
May contain organization-specific values: Yes
Category Entries:
Yes
No
53 LABOR_ACT_BIRTH_C_NAME VARCHAR No
The category value corresponding to the actual birth status of the delivery.
May contain organization-specific values: Yes
Category Entries:
Live Born
Stillborn
54 LABOR_FEED_TYPE_C_NAME VARCHAR No
The category value corresponding to the infant feeding type during the delivery process
May contain organization-specific values: Yes
Category Entries:
Breast
Bottle
55 PROC_SERV_C_NAME VARCHAR No
Procedure Based Service Category
May contain organization-specific values: Yes
56 ED_DEPARTURE_TIME DATETIME (Local) No
Date and time the patient left the ED.
57 TRIAGE_DATETIME DATETIME No
The date and the time the patient was triaged.
58 TRIAGE_STATUS_C_NAME VARCHAR No
The triage status.
May contain organization-specific values: Yes
No Entries Defined
59 INP_ADM_EVENT_ID NUMERIC No
The event record for the hospital encounter where the patient first received a base patient class of inpatient, making them an inpatient.
60 INP_ADM_EVENT_DATE DATETIME (Local) No
Instant of the event creation of the event which caused a patient to become an inpatient patient class.
61 INP_DWNGRD_EVNT_ID NUMERIC No
Column to return the event ID of the event that last downgrades the patient from an inpatient patient class to a non-inpatient patient class.
62 INP_DWNGRD_DATE DATETIME (Local) No
Column that returns the effective date and time of a patients latest downgrade from an inpatient patient class.
63 INP_DWNGRD_EVNT_DT DATETIME (Local) No
Column to return the event date and time of the last event that downgrades a patient from an inpatient patient class to a non-inpatient patient class.
64 OP_ADM_DATE DATETIME (Local) No
The date and time during the hospital encounter when the patient first received a base patient class of outpatient.
65 EMER_ADM_DATE DATETIME (Local) No
The date and time during the hospital encounter when the patient first received a base patient class of emergency.
66 OP_ADM_EVENT_ID NUMERIC No
The event record for the hospital encounter where the patient first received a base patient class of outpatient.
67 EMER_ADM_EVENT_ID NUMERIC No
The event record for the hospital encounter where the patient first received a base patient class of emergency.
68 PREREG_SOURCE_C_NAME VARCHAR No
Preregistration source value.
May contain organization-specific values: Yes
No Entries Defined
69 HOV_CONF_STATUS_C_NAME VARCHAR No
This item stores a flag to prevent HOVs from being closed by the end of day batch.
May contain organization-specific values: No
Category Entries:
In Progress
Ready For Completion
70 RELIG_NEEDS_VISIT_C_NAME VARCHAR No
Used to track a patient's visit-specific religious needs.
May contain organization-specific values: Yes
No Entries Defined
71 DISCHARGE_CAT_C_NAME VARCHAR No
General Category Item for Discharges
May contain organization-specific values: Yes
No Entries Defined
72 EXP_DISCHARGE_TIME DATETIME (Local) No
The time of expected discharge of the admission for this patient contact.
73 BILL_ATTEND_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.
74 OB_LD_LABORING_YN VARCHAR No
Indicates whether the patient was in labor upon arrival at the hospital.
May contain organization-specific values: No
Category Entries:
No
Yes
75 OB_LD_LABOR_TM DATETIME (Local) No
The date and time at which labor began.
76 TRIAGE_ID_TAG VARCHAR No
The trauma identifier assigned to patient. This number is frequently associated with a pre-printed trauma packet that is used when an accident or other incident results in many patients arriving at the hospital in a short time period.
77 TRIAGE_ID_TAG_CMT VARCHAR No
A free-text comment that can be entered along with the trauma identifier or triage ID assigned to the patient.
78 TPLNT_BILL_STAT_C_NAME VARCHAR No
The category number for the Transplant Billing Status for a visit.
May contain organization-specific values: Yes
No Entries Defined
79 ACTL_DELIVRY_METH_C_NAME VARCHAR No
Indicates the delivery method of the last baby delivered on this encounter by this patient. For example, Spontaneous Vaginal Delivery, C-Section - Unspecified, etc.
The category values for this column were already listed for column: DELIVERY_TYPE_C_NAME
80 PRENATAL_CARE_C_NAME VARCHAR No
Item used to indicate what type of prenatal care the patient has received.
May contain organization-specific values: Yes
81 AMBULANCE_CODE_C_NAME VARCHAR No
The category number for the ambulance code.
May contain organization-specific values: Yes
82 MSE_DATE DATETIME (Local) No
Indicates the date and time of the patient's medical screening exam (MSE).
83 ADMIT_PROV_TEXT VARCHAR No
The free text admitting provider for the encounter.
84 ATTEND_PROV_TEXT VARCHAR No
The free text attending provider for the encounter.
85 PROV_PRIM_TEXT VARCHAR No
The free text primary care provider for the encounter
86 PROV_PRIM_TEXT_PHON VARCHAR No
The free text phone number for the primary care provider.
87 HOSPITAL_AREA_ID_LOC_NAME VARCHAR No
The name of the revenue location.
88 CHIEF_COMPLAINT_C_NAME VARCHAR No
This holds the category number for the chief complaint if the free text chief complaint item is not being used.
May contain organization-specific values: Yes
No Entries Defined