IP_EPISODE_LINK

Description:

The episode table for Inpatient episodes. This is used as a substitute for the EPISODE and EPISODE_LINK tables.

Primary Key

Column Name	Ordinal Position
EPISODE_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	EPISODE_ID	NUMERIC	No
	The unique ID of the episode of care record.
2	LINE	INTEGER	No
	This identifies the encounter within the episode.
3	SUM_BLK_TYPE_ID_EPISODE_DEF_NAME	VARCHAR	No
	This column displays the name of the episode / block definition record.
4	PAT_ENC_CSN_ID	NUMERIC	No
	A unique serial number for this encounter. This number is unique across all patients and encounters in the system.
5	INP_CSN	NUMERIC	No
	A unique serial number for this Inpatient Data (INP) record.
6	INPATIENT_DATA_ID	VARCHAR	No
	A unique ID assigned to the Inpatient Data (INP) record
7	START_DATE	DATETIME	No
	The date the episode was initiated in calendar format. This field is called Noted on the clinical system screen.
8	END_DATE	DATETIME	No
	The date the episode was resolved in calendar format. This field is called Resolved on the clinical system screen.
9	CARE_INTG_ID	VARCHAR	No
	The unique ID for the inpatient care integrator record.
10	STATUS_C_NAME	VARCHAR	No
	The status of the episode record: i.e. Active, Resolved, or Deleted. May contain organization-specific values: No Category Entries: Active Resolved Deleted
11	EPISODE_NAME	VARCHAR	No
	The name of the episode.