DOC_EPSD_LIST_INFO_CMPL
Description:
Episodes received from external documents.

Primary Key
Column Name Ordinal Position
DOCUMENT_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 DOCUMENT_ID NUMERIC No
The unique identifier (.1 item) for the document record.
2 LINE INTEGER No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 EPSD_NAME_CMPL VARCHAR No
The name of this row's received episode. This data is from the most recent contact of this episode in its received document.
4 EPSD_CMPL_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
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
Other