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