DOC_EPSD_LIST_INFO

Description:

Episodes received from external documents.

Primary Key

Column Name	Ordinal Position
DOCUMENT_ID	1
CONTACT_DATE_REAL	2
LINE	3

Column Information

	Name	Type	Discontinued?
1	DOCUMENT_ID	NUMERIC	No
	This item stores the Received Document record ID.
2	CONTACT_DATE_REAL	FLOAT	No
	A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
3	LINE	INTEGER	No
	The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
4	CONTACT_DATE	DATETIME	No
	The date of this contact in calendar format.
5	EPSD_START_INST_DTTM	DATETIME (Local)	No
	Start instant for the received episode.
6	EPSD_END_INST_DTTM	DATETIME (Local)	No
	End instant for the received episode.
7	EPSD_IDENT	VARCHAR	No
	Unique identifier for the received episode.
8	EPSD_SET_ID	VARCHAR	No
	Episode set ID that represents a common identifier across all document revisions.
9	EPSD_TYP_ID_C_NAME	VARCHAR	No
	The episode type category ID for the received episode. May contain organization-specific values: Yes Category Entries: Obstetrics Acute Care Anticoagulation Transplant Oncology - Chemotherapy Oncology - Supportive Care Oncology - Follow-up Home Health Hospice Obstetrics - Delivery Blood and Marrow Transplant Traveler Obstetrics History Obstetrics - Delivery History Patient Administrative Pathway Billing Long Term Care Beacon - Treatment Plan Therapy Plan Mechanical Circulatory Support Patient-Entered Data (Storage) Patient-Entered Data (View) Immune Effector Cell Therapy Fertility ALS (Amyotrophic Lateral Sclerosis) Patient Administrative Pathway Parent Behavioral Health Care Path Care/Case Management Specialty Pharmacy Radiation Therapy Research Compass Rose Program Compass Rose Service Dialysis Episode Cell Therapy Care Path Medication Management Home Infusion Structural Heart Dialysis Modality Orthodontics Patient Care Plan Lung Nodule Management Remote Patient Monitoring National Cancer Audits Med Access Inpatient Rehab Outpatient Rehab DBC Medication for Opioid Use Disorder Treatment Intermediate Care Tapestry Cross-Claim Pricing
10	EPSD_NAME	VARCHAR	No
	Name of the received episode.
11	EPSD_STAT_INFO_C_NAME	VARCHAR	No
	Status of the received episode. May contain organization-specific values: No Category Entries: Active Resolved Deleted
12	EPSD_CMT	VARCHAR	No
	The free text comment for this row's received episode.
13	EPSD_DOC_ID	VARCHAR	No
	Universally unique identifier (UUID) of the received episode DXR document.
14	EPSD_DOC_TYP_C_NAME	VARCHAR	No
	Document type for the document that has the received episode. May contain organization-specific values: Yes Category Entries: Clinical Summary Document List Other Results Encounter Summary Lab Results Continuity of Care Document Referral Summary Discharge Summary LPR3 Document LPR3 Event Document Emergency Department Summary External Document - PDF External Document - Text Quality Reporting Document Architecture Continuity of Care Record Care Plan Overall Plan of Care Patient Health Summary Constellation Update Labor and Delivery Summary Laboratory Reports Immunization Content Consultation Note Diagnostic Imaging Report History and Physical Note Operative Note Procedure Note Progress Note Physician consulting Progress note Location Summary IRIS Ophthalmology Report Payer Document Endoscopy Registry Patient Level Quality Reporting Document Population Level Quality Reporting Document Professional Billing Exchange Document Cancer Registry Initial Public Health Case Report Outgoing Death Registry Reporting IHE VRDR Profile Outgoing NHCS Survey Documents Patient-Reported Information Specialist Letter Decision Support Request Cosmos Document Patient Level Cosmos Document Encounter Level Cosmos Document Unreconciled Data Encounter Level Cosmos Document Unreconciled Data Patient Level Treatment Document - eArchive Forms - eArchive Service Event - eArchive Finland eRx Kanta Social Care THL Registry Document THL Calculation Document Navitas Patient Summary Document Navitas Encounter Document Navitas Imaging Document USCDI CCD (Patient Level) USCDI CCD (Encounter Level) 2015 CCDS CCD Basisgegevensset Zorg (BgZ) Basisgegevensset Zorg (BgZ) - Encounter Clinical Analytics Overall Clinical Analytics Supplemental Analytics Overall Supplemental Analytics Transplant Episode Summary Comprehensive Care Coordination Summary Emergency department Note Note Outpatient Note Perioperative records Cardiology studies Transfer summary note Radiology studies Anesthesia records Dialysis Summary Oncology Summary Genomics Summary Health Plan Sourced Clinical Summary Patient Dialysis Summary Patient Oncology Summary Life Sciences Patient Level Update Life Sciences Restricted Data Exchange
15	EPSD_ENROLL_INST_DTTM	DATETIME (Local)	No
	Enrollment instant for the received episode.
16	EPSD_USES_ENROLL_DT_YN	VARCHAR	No
	Stores whether an episode considers the enrollment date to be the first effective date of the episode instead of the start date. May contain organization-specific values: No Category Entries: No Yes
17	EPSD_TYPE_NAME	VARCHAR	No
	Name of the episode type for the received episode.
18	EPSD_CMGMT_STATUS_C_NAME	VARCHAR	No
	Status of the received care coordination episode. May contain organization-specific values: No Category Entries: Enrolling Active Closed Paused Declined
19	EPSD_CMGMT_STATUS_NAME	VARCHAR	No
	Free text display name for the status of the received care coordination episode.
20	EPSD_DEPT_NAME	VARCHAR	No
	Free text episode department name.
21	EPSD_SPECIALTY_DEP_NAME	VARCHAR	No
	Free text department specialty name for the received episode.
22	EPSD_SPECIALTY_DEP_C_NAME	VARCHAR	No
	Department specialty ID for the received episode. May contain organization-specific values: Yes
23	EPSD_POOL	VARCHAR	No
	Free text name of the In Basket pool associated with the received episode.
24	EPSD_PARENT_EPISODE	VARCHAR	No
	The episode identifier for the parent episode.
25	ESPD_SRC_DOCUMENT_CSN_ID	NUMERIC	No
	This item stores the source DXR CSN that contains the external episode information.
26	EPSD_RCVD_INSTANT_DTTM	DATETIME (Local)	No
	Stores the last received instant.
27	EPSD_LST_UPD_INST_DTTM	DATETIME (UTC)	No
	Stores the last update instant of the episode in UTC.
28	EPSD_CCM_EPISODE_TYPE_C_NAME	VARCHAR	No
	Indicates whether the Coordinated Care Management episode is for a program or for a service. If null, this is not a Coordinated Care Management episode type. May contain organization-specific values: Yes Category Entries: Program Service