EXPECTED_DISCHARGE_HX

Description:

This is the expected discharge status history. It will track changes made to the patient's expected discharge throughout the encounter. This table contains data about the expected discharge date (I EPT 10442), approximate expected discharge time (I EPT 10443), exact expected discharge time (I EPT 10444), comments about the expected discharge (I EPT 10445), the date and time that the expected discharge was entered (I EPT 10446), the user that made the change (I EPT 10447), and whether the expected discharge date and time was unknown (I EPT 10454). Each time the information is entered or modified, it will add a line to this table.

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	PAT_ID	VARCHAR	No
	The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
4	EXPECTED_DISCHARGE_APPROX_HX_C_NAME	VARCHAR	No
	Approximate time the patient is expected to be discharged. Each value in this column denotes a time range (e.g. Morning, Midday, Afternoon, Evening). If the approximate time is empty, the patient may have an associated exact time (check column EXPECTED_DISCH_DTTM_HX_TIME). May contain organization-specific values: Yes Category Entries: Morning Midday Afternoon Evening
5	EXPECTED_DISCH_DTTM_HX_TIME	DATETIME (Local)	No
	This column stores the date and exact time the patient is expected to be discharged (e.g. 10/16/2015 8:00AM). If an exact time is empty, the patient may have an associated approximate time (check column EXPECTED_DISCHARGE_APPROX_HX_C).
6	EXPECTED_DISCHARGE_COMMENT_HX	VARCHAR	No
	This column stores the comment entered about the expected discharge.
7	EXPECTED_DISCH_UPD_HX_UTC_DTTM	DATETIME (UTC)	No
	This column stores the date and time when the expected discharge items were updated.
8	EXPECTED_DISCHARGE_UPD_SRC_C_NAME	VARCHAR	No
	The reason the expected discharge date and / or time was updated. May contain organization-specific values: Yes Category Entries: User Entered Model Prediction Expected Discharge Date Update Expected Length of Stay Update Admission Planning Reservation Updated Discharge Order Filed Defaulted from CMLOS on Admission Order Set Automatically From Predicted Discharge Today or Tomorrow Set Automatically From CMLOS
9	EXPECTED_DISCHARGE_UNKNOWN_YN	VARCHAR	No
	Indicates whether the expected discharge date is unknown for this patient. 'Y' indicates that the expected discharge date is unknown and documented. 'N' indicates that the expected discharge date is known and documented. NULL should not be stored in the column. May contain organization-specific values: No Category Entries: No Yes