ALL_EPISODE_CSN_LINKS

Description:

The ALL_EPISODE_CSN_LINKS table contains one row for each master file link added to an episode. Each row contains information associated with the master file stored in the EPISODE_LINK_INI column. It can be used with other episode tables to report on episode data whether the episode is linked to an encounter or not.

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 for this row.
2	LINE	INTEGER	No
	This identifies the link master file.
3	TREATMENT_PLAN_ID	NUMERIC	No
	The unique ID of the transplant record for this row.
4	TREATMENT_PLAN_CSN_ID	NUMERIC	No
	The unique serial number for this transplant record. This number is unique across all patient encounters in your system. If you use IntraConnect, this is the Unique Contact Identifier (UCI).