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