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
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
Patient graduated
Unable to reach patient
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