EPISODE_ALL

Description:

This table contains all episode records, regardless of the type and is intended for use with Organization Filter functionality. If used for Organization Filtering, users will be able to see an episode if they have authorization for the owning business segment on the episode or the patient associated with the episode.

Primary Key

Column Name	Ordinal Position
EPISODE_ID	1

Column Information

	Name	Type	Discontinued?
1	EPISODE_ID	NUMERIC	No
	The unique identifier of the episode record.
2	STATUS_C_NAME	VARCHAR	No
	The status of the episode record. An episode status might be Active, Resolved, or Deleted. May contain organization-specific values: No Category Entries: Active Resolved Deleted
3	EPISODE_NAME	VARCHAR	No
	The name of the episode.
4	START_DATE	DATETIME	No
	The date the episode was initiated.
5	END_DATE	DATETIME	No
	The date the episode was resolved.
6	CARE_INTG_ID	VARCHAR	No
	The unique ID of the care plan linked to the episode.
7	TREATMENT_CAREPLAN_ID	VARCHAR	No
	Link to the treatment list