EPISODE

Description:

This table contains high-level information on the episodes recorded in the clinical system for your patients. 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. It does not contain episodes linked to an inpatient encounter.

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.
2	NAME	VARCHAR	No
	The name of the episode.
3	SUM_BLK_TYPE_ID_EPISODE_DEF_NAME	VARCHAR	No
	This column displays the name of the episode / block definition record.
4	START_DATE	DATETIME	No
	The date the episode was initiated.
5	END_DATE	DATETIME	No
	The date the episode was resolved in calendar format. This field is called "Resolved" on the clinical system screen.
6	COMMENTS	VARCHAR	No
	Any free text comments about the episode.
7	PREGRAVID_WEIGHT	NUMERIC	No
	This field contains the pre-pregnancy weight maintained before this episode.
8	NUMBER_OF_BABIES	INTEGER	No
	Prior to delivery, this column is expected to contain the number of fetuses that the patient is carrying. This can be manually documented, such as in the Prenatal Vitals section, or the value can be automatically set by creating or removing fetal result tabs in the ultrasound activity. If your organization documents on the Delivery Summary then after the Delivery Summary is signed, this column is expected to contain the number of viable deliveries associated with the pregnancy. Specifically, this is the number of delivery records attached to the pregnancy. This expectation is based on Epic's recommendation that only viable deliveries should be documented on the Delivery Summary. Your organization may follow a different policy for when to create a delivery record. The behavior of this column containing the number of delivery records may be overridden at the profile level in system definitions, in which case it will continue to contain the number of fetuses that were being carried unless the number of deliveries is manually documented in its place.
9	PRIMARY_LPL_ID	NUMERIC	No
	The primary problem linked to the episode.
10	STATUS_C_NAME	VARCHAR	No
	The status category number for the episode. May contain organization-specific values: No Category Entries: Active Resolved Deleted
11	L_UPDATE_USER_ID	VARCHAR	No
	The ID of the last user that updated the episode of care record.
12	L_UPDATE_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
13	PATERNITY_ACK_C_NAME	VARCHAR	No
	Whether a paternity acknowledgement has been signed by the biological father of the baby if the parents are not married. This column may not be applicable depending on the identity of the second parent and the two parents' relationship. May contain organization-specific values: Yes Category Entries: Yes No Unknown Unnecessary
14	SMOKE_3_MO_BEF	INTEGER	No
	The number of cigarettes/packs smoked per day 3 months before the pregnancy by the mother.
15	SMOKE_3_MO_BEF_C_NAME	VARCHAR	No
	The unit of measurement for the quantity of cigarettes being smoked 3 months before the pregnancy by the mother. May contain organization-specific values: Yes Category Entries: Packs Cigarettes
16	SMOKE_1ST_3_MO	INTEGER	No
	The number of cigarettes/packs smoked per day in the first 3 months of the pregnancy by the mother.
17	SMOKE_1ST_3_MO_C_NAME	VARCHAR	No
	The unit of measurement for the quantity of cigarettes being smoked the first three months of the pregnancy by the mother. The category values for this column were already listed for column: SMOKE_3_MO_BEF_C_NAME
18	SMOKE_2ND_3_MO	INTEGER	No
	The number of cigarettes/packs smoked per day in the second 3 months of the pregnancy by the mother.
19	SMOKE_2ND_3_MO_C_NAME	VARCHAR	No
	The unit of measurement for the quantity of cigarettes being smoked the second three months of the pregnancy by the mother. The category values for this column were already listed for column: SMOKE_3_MO_BEF_C_NAME
20	SMOKE_3RD_TRI	INTEGER	No
	The number of cigarettes/packs smoked per day in the third trimester of the pregnancy by the mother.
21	SMOKE_3RD_TRI_C_NAME	VARCHAR	No
	The unit of measurement for the quantity of cigarettes being smoked the third trimester of the pregnancy by the mother. The category values for this column were already listed for column: SMOKE_3_MO_BEF_C_NAME
22	DRINK_3_MO_BEF	INTEGER	No
	The number of alcoholic drinks consumed per week 3 months before the pregnancy by the mother.
23	DRINK_1ST_3_MO	INTEGER	No
	The number of alcoholic drinks consumed per week in the first three months of the pregnancy by the mother.
24	DRINK_2ND_3_MO	INTEGER	No
	The number of alcoholic drinks consumed per week in the second three months of the pregnancy by the mother.
25	DRINK_3RD_TRI	INTEGER	No
	The number of alcoholic drinks consumed per week in the third trimester of the pregnancy by the mother.
26	IN_CITY_LIMITS_YN	VARCHAR	No
	Whether the address of the mother is inside the city limits. May contain organization-specific values: No Category Entries: No Yes
27	WIC_FOODS_YN	VARCHAR	No
	Did the mother receive WIC foods during this pregnancy? The category values for this column were already listed for column: IN_CITY_LIMITS_YN
28	TOTAL_PNC	INTEGER	No
	Override value to be used in situations where not all prenatal care was given at the same Epic provider and so not all prenatal care visits are in the system.
29	MONTH_1ST_PNC	INTEGER	No
	Override value to be used in situations where not all prenatal care was given at the same Epic provider and so first date of prenatal care is not in the system and the month of the pregnancy when prenatal care began cannot be calculated.
30	LIVE_BIRTHS_LIVING	INTEGER	No
	Override value to be used in situations where not all prenatal care was given at the same Epic provider, and consequently, other pregnancy information is not available. The number of children born alive which are still living not including children born at this birth.
31	LIVE_BIRTHS_DEAD	INTEGER	No
	Override value to be used in situations where not all prenatal care was given at the same Epic provider, and consequently, other pregnancy information is not available. The number of other children born alive which are now deceased not including any born alive and deceased at this birth.
32	MOTHER_MARRIED_YN	VARCHAR	No
	Whether the mother is married at birth, conception, or any time in between. The category values for this column were already listed for column: IN_CITY_LIMITS_YN
33	OB_PREGRAVID_BMI	NUMERIC	No
	The patient's pre-pregnancy BMI for this pregnancy episode.
34	FIRST_PNT_LOC_C_NAME	VARCHAR	No
	This item stores who the patient's first prenatal care was with. May contain organization-specific values: Yes
35	SERV_AREA_ID_LOC_NAME	VARCHAR	No
	The name of the revenue location.
36	OB_WRK_EDD_DT	DATETIME	No
	The estimated date of delivery for a pregnancy episode.
37	EXPECTED_DEL_LOC_C_NAME	VARCHAR	No
	Location where the woman plans to deliver her baby. May contain organization-specific values: Yes
38	DEL_LOC_CHANGE_C_NAME	VARCHAR	No
	Why the delivery location changed from the expected delivery location (EXPECTED_DEL_LOC_C) for a pregnancy episode. May contain organization-specific values: Yes
39	OB_FEEDING_INTENTIONS_C_NAME	VARCHAR	No
	Mother's intended feeding method for the baby. May contain organization-specific values: Yes Category Entries: Breast Milk Formula Breast Milk and Formula
40	INTENT_TREAT_C_NAME	VARCHAR	No
	The intended treatment for an implanted Mechanical Circulatory Device. May contain organization-specific values: Yes Category Entries: Medical Management Bridge to Recovery Rescue Therapy Bridge to Transplant - Currently Listed Possible Bridge to Transplant - Likely Eligible Possible Bridge to Transplant - Moderate Likelihood Possible Bridge to Transplant - Unlikely Eligible Destination Therapy - Modifiable Destination Therapy - Unmodifiable Unknown Other
41	INTENT_TREAT_OTHR	VARCHAR	No
	The free text intended treatment for an implanted Mechanical Circulatory Device.
42	MCS_DISCHARGE_DT	DATETIME	No
	Date a Mechanical Circulatory Device patient is discharged.
43	MCS_EVAL_DT	DATETIME	No
	The start date of the Mechanical Circulatory Device evaluation.
44	MCS_REV_DT	DATETIME	No
	The date when the Mechanical Circulatory Device case was reviewed by the evaluation committee.
45	MCS_ADMISSION_DT	DATETIME	No
	Date of the admission for the Mechanical Circulatory Device procedure.
46	MCS_SURG_DT	DATETIME	No
	The date of the Mechanical Circulatory Device surgery.
47	MCS_IS_HISTORIC_YN	VARCHAR	No
	Flag indicating a historic Mechanical Circulatory Device episode. This is intended to flag if the Device was implanted at another center than the Center that is currently following the patient. May contain organization-specific values: No Category Entries: Yes No
48	MCS_EVAL_END_DT	DATETIME	No
	The date on which the Mechanical Circulatory Device evaluation was completed.
49	MCS_NEXT_REVIEW_DT	DATETIME	No
	The date on which both the Mechanical Circulatory Device episode and the patient chart should be reviewed.
50	MCS_REFERRAL_DT	DATETIME	No
	The date the patient was referred for the Mechanical Circulatory Device.
51	MCS_TXPORT_MTHD_C_NAME	VARCHAR	No
	The method of transportation to the implantation center. May contain organization-specific values: Yes Category Entries: Car Ambulance Airplane Helicopter