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
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