CMGMT_EPISODE_CASE_TEAM

Description:

This table contains the providers and pools that are responsible for performing ongoing outreach related to a Coordinated Care Management episode.

Primary Key

Column Name	Ordinal Position
EPISODE_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	EPISODE_ID	NUMERIC	No
	The unique identifier for the summary block record.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	MANAGER_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.
4	POOL_REGISTRY_ID	NUMERIC	No
	Stores the pool of providers responsible for performing ongoing patient outreach related to this Coordinated Care Management episode.
5	POOL_REGISTRY_ID_REGISTRY_NAME	VARCHAR	No
	The name of the In Basket registry in the HIP master file.
6	EFFECTIVE_DATE	DATETIME	No
	Stores the date on which the provider or pool starts being responsible for reviewing the Coordinated Care Management episode.
7	TERMINATION_DATE	DATETIME	No
	Stores the date on which the provider or pool stops being responsible for reviewing the Coordinated Care Management episode.
8	RELATIONSHIP_C_NAME	VARCHAR	No
	Stores the type of relationship between the case manager and patient. May contain organization-specific values: Yes
9	REV_FREQ_UNIT_C_NAME	VARCHAR	No
	Stores the review frequency unit that indicates how often the manager or pool performs patient outreach. May contain organization-specific values: No Category Entries: Years Months Weeks Days Hours Postmenstrual Age
10	REVIEW_DUE_DATE	DATETIME	No
	Stores the date by which the provider or pool must next complete the Coordinated Care Management episode review.
11	REVIEW_DUE_TASK_ID	VARCHAR	No
	Stores the task record in the Coordinated Care Management episode checklist that indicates the next review date. This task is generated by the system when a review due date (I HSB 18140) is set.
12	LAST_REVIEW_DATE	DATETIME	No
	Stores the date on which the provider or pool performed the last Coordinated Care Management episode review.
13	MANAGER_IS_PRIMARY_YN	VARCHAR	No
	This flag indicates whether the provider or pool is primarily responsible for the Coordinated Care Management episode. Only one provider/pool can be primarily responsible on any given effective date. May contain organization-specific values: No Category Entries: No Yes