EPISODE_2

Description: |
This table supplements the EPISODE table. It contains additional information about episodes. When a provider sees a patient several times for an ongoing condition, such as prenatal care, these encounters can be linked to a single Episode of Care.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
EPISODE_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | EPISODE_ID | NUMERIC | No |
The unique ID of the episode of care record. NOTE: This table is filtered to include only non-inpatient episodes. Inpatient episode data can be found in the table IP_EPISODE_LINK (first released with system 2002).
2 | DEPT_ID_EXTERNAL_NAME | VARCHAR | No |
The external name of the department record. This is often used in patient correspondence such as reminder letters.
3 | RXENROLL_LAST_EDIT_USER_ID | VARCHAR | No |
The user ID for whoever last updated the pharmacy enrollment.
4 | RXENROLL_LAST_EDIT_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
5 | RXENROLL_LAST_EDIT_DTTM | DATETIME (Local) | No |
The date and time the pharmacy enrollment was last updated.
6 | ENROLL_PROG_C_NAME | VARCHAR | No |
The current enrollment program for the pharmacy.
May contain organization-specific values: Yes
7 | RXENROLL_NOTE_ID | VARCHAR | No |
Summary note documented on this episode
8 | RXENROLL_ENROLLMENT_DATE | DATETIME | No |
The date the patient was enrolled in the program
9 | RXENROLL_DISENROLL_DATE | DATETIME | No |
The date the patient was unenrolled from the program.
10 | RXENROLL_DECLINE_DATE | DATETIME | No |
The date the patient was declined enrollment (or declined to enroll) in the program
11 | RXENROLL_STATUS_C_NAME | VARCHAR | No |
The current enrollment status
May contain organization-specific values: No
Category Entries:
Under Review
Enrolled
Disenrolled
Declined
Deleted
12 | CRT_PAT_ENC_CSN_ID | NUMERIC | No |
The patient contact serial number that auto created this episode.
13 | CMGMT_STATUS_C_NAME | VARCHAR | No |
Stores the status of the case episode. Enrolling - The manager is working to enroll the patient in a case management program. Open - The manager is performing ongoing outreach with the patient. Closed - The patient is no longer enrolled in case management, or they opted out of case management.
May contain organization-specific values: No
Category Entries:
Enrolling
Active
Closed
Paused
Declined
14 | CMGMT_SENSITIVITY_C_NAME | VARCHAR | No |
Store the sensitivity flag for security restricted case episodes. If your organization has implemented break-the-glass, this sensitivity flag can be used to restrict access to the case episode.
May contain organization-specific values: Yes
15 | CMGMT_ENROLLMENT_RSN_C_NAME | VARCHAR | No |
Stores the reason the patient was enrolled in case management.
May contain organization-specific values: Yes
Category Entries:
Referred by provider
Identified as high-risk
Self-enrolled
Identified using claims or encounter data
Identified using hospital discharge data
Identified using pharmacy data
Identified using UM data
Identified using referral data
Identified using coverage data
Identified via medication access
Identified using eligibility report
Referred from other program
16 | CMGMT_ENROLLING_STEP_C_NAME | VARCHAR | No |
Stores the enrolling step that specifies the current step of enrollment for the case episode.
May contain organization-specific values: Yes
Category Entries:
Not specified
Identified
17 | CMGMT_CLOSED_REASON_C_NAME | VARCHAR | No |
Stores the reason the case episode is closed.
May contain organization-specific values: Yes
Category Entries:
Not specified
Patient declined case management
Graduated
Unable to reach
No longer interested
No longer able to reach
18 | ENROLL_ID | NUMERIC | No |
The research study-patient association (LAR) record ID for this episode.
19 | PREG_CHORIONIC_C_NAME | VARCHAR | No |
For a pregnancy with multiple fetuses, indicates if the fetuses have individual or a shared chorionic and amniotic sacs.
May contain organization-specific values: No
Category Entries:
Mono-Mono
Mono-Di
Di-Di
Other
Mono-Tri
Di-Tri
Tri-Tri
20 | PLAN_ADOPT_TYPE_C_NAME | VARCHAR | No |
This item indicates if the mother plans to give the baby up for adoption and if so, what type of adoption or arrangement is planned.
May contain organization-specific values: Yes
Category Entries:
Open Adoption
Closed Adoption
Surrogate
Safe Surrender
Gestational Carrier
Traditional Surrogate
Hide Mother's Info
Not Applicable
21 | SUSPECTED_FD_YN | VARCHAR | No |
This item indicates whether a suspected fetal demise has occurred in the pregnancy.
May contain organization-specific values: No
Category Entries:
No
Yes
22 | PLAN_CIRCUMCISION_C_NAME | VARCHAR | No |
This item is used to indicate whether the parents have requested a circumcision after the baby is born.
May contain organization-specific values: No
Category Entries:
No
Provider Performed
Ritual
23 | PLAN_DELIVER_BY_GA | INTEGER | No |
This item represents the gestational age (in weeks of pregnancy) at when the patient and provider expect the delivery to occur.
24 | PLAN_DEL_METHOD_C_NAME | VARCHAR | No |
This item captures the planned method of delivery as documented prior to labor.
May contain organization-specific values: No
Category Entries:
Vaginal
C-Section
TOLAC
25 | CMGMT_DECLINE_REASON_C_NAME | VARCHAR | No |
Documents the reason a patient/client refused coordinated case management services.
May contain organization-specific values: Yes
26 | HSPC_ADD_DISCUSSED_WITH_PAT_YN | VARCHAR | No |
This item indicates whether or not a hospice election addendum was discussed with the patient for this episode.
The category values for this column were already listed for column: SUSPECTED_FD_YN
27 | HSPC_ADD_REQUESTED_WITH_PAT_YN | VARCHAR | No |
This item indicates whether or not a hospice election addendum was requested for this episode.
The category values for this column were already listed for column: SUSPECTED_FD_YN
28 | HSPC_ADD_DISCUSSED_USER_ID | VARCHAR | No |
The unique user record ID that is frequently used to link to the CLARITY_EMP table.
29 | HSPC_ADD_DISCUSSED_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
30 | HSPC_ADD_DISCUSSED_DATE | DATETIME | No |
The date the addendum was discussed with the patient.
31 | CMGMT_ENROLL_DATE | DATETIME | No |
Documents the enrollment date, which is the date on which a patient or client's status becomes active and the patient or client starts receiving Coordinated Care Management services. Refer to CMGMT_CALC_ENROLL_DATE for more robust reporting.
32 | CMGMT_ENROLL_CALC_DATE | DATETIME | No |
This virtual item contains a calculated enrollment date determined from the user- documented enrollment date (CMGMT_ENROLL_DATE, HSB-18030) or the Case Management History related group (I HSB 18400). If the overall episode status (CMGMT_STATUS_C, I HSB 18010) is 1-Enrolling, the value will be blank. If the overall status is anything besides 1-Enrolling, the value will be set to the user- documented Enrollment Date, if it exists. Otherwise, the value will be set to the date (ACTION_UTC_DTTM) the status (ASSOC_CMGMT_STATUS_C) originally changed to 2-Active, unless the status was changed to 1-Enrolling more recently.
33 | CMGMT_TRIGGERING_CLASSIFIER_ID | VARCHAR | No |
The classifier (CFR record) that triggered the creation of this case.
34 | CMGMT_TRIGGERING_CLASSIFIER_ID_CLASSIFIER_NAME | VARCHAR | No |
The title of the classifier record.
35 | CMGMT_TRIGGERING_CLAIM_ID | NUMERIC | No |
The claim that caused the creation of this case.
36 | PREG_CORD_BLOOD_PLANS_C_NAME | VARCHAR | No |
This item indicates the patient's plans for umbilical cord blood.
May contain organization-specific values: Yes
Category Entries:
See Overview
Do Not Collect
Research Study
Public Bank
Private Bank
Internal Bank
Internal Lab
37 | LINKED_SERVICE_PLAN_ID | NUMERIC | No |
The service plan associated with this episode.
38 | MC_TG_RSLV_DATE | DATETIME | No |
Stores the resolve date for this Tapestry bundle.
39 | BPC_ID | NUMERIC | No |
Stores the bundled episode terms id.
40 | BPC_ID_BPC_NAME | VARCHAR | No |
The name of the bundled episode terms record.
41 | BPC_CSN_ID | NUMERIC | No |
Stores the bundled episode terms contact serial number.
42 | TREATMENT_CAREPLAN_ID | VARCHAR | No |
Link to the treatment list
43 | CMGMT_COMPLEXITY_C_NAME | VARCHAR | No |
The complexity category ID of the episode.
May contain organization-specific values: Yes
Category Entries:
High
Moderate
Low