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
Workers' Compensation
National Cancer Audits
Medication Access
Breast Cancer High Risk
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
Kanta Appointments
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
Undefined
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
29 | EPSD_CMGMT_PROG_CAT_C_NAME | VARCHAR | No |
This item stores the program category value, which defines the type of program supported by a Compass Rose episode type.
May contain organization-specific values: No
Category Entries:
Transitions of Care
Transitional Care Management - CMS
Complex Care Management
Chronic Care Management - CMS
Principal Care Management
Disease Management
Diabetes Management and Education
Diabetes Prevention Program
Medication Therapy Management
Pharmacist-Led Chronic Disease Management
Specialty Pharmacy
Home Infusion
Program for All-Inclusive Care for the Elderly
Remote Patient Monitoring
Care Navigation
Care Coordination
Palliative/Hospice Care
Advanced Primary Care and Primary Care Coordination
Home Care
Social Work
Rehabilitation
Mental Health
Substance Use
Smoking Cessation
Maternal/Women's Health
Sexual Health
Social Drivers of Health/Community Resource Coordination
Child Social Services
Safeguarding
Disability Services
Episodic Bundled Payment
Chronic Condition Special Needs Plan
Dual Special Needs Plan
Institutional Special Needs Plan
High Utilization
Value-Based Care
Medication Access
Bariatric Surgery
CIED Clinic Care Management
Other
30 | EPSD_PAUSE_START_LOCAL_DTTM | DATETIME (Local) | No |
Pause period start instant for the received Compass Rose episode. Dates may also be stored as instants set to midnight.
31 | EPSD_PAUSE_END_LOCAL_DTTM | DATETIME (Local) | No |
Pause period end instant for the received Compass Rose episode. Dates may also be stored as instants set to midnight.
32 | EPSD_CMGMT_PAUSE_REASON | VARCHAR | No |
This item stores the reason for a Compass Rose episode pause period.
33 | EPSD_CMGMT_CLOSED_REASON | VARCHAR | No |
Status reason for closed Compass Rose episodes.
34 | EPSD_CMGMT_DECLINE_REASON | VARCHAR | No |
Status reason for declined Compass Rose episodes.
35 | EPSD_CMGMT_ENROLLMENT_REASON | VARCHAR | No |
Status reason for enrolled Compass Rose episodes.