DOCS_RCVD_SOCIALCARE_EPSD

Description: |
External documents for Compass Rose episodes.

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 |
The unique identifier (.1 item) for the document record.
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 | EPISODE_REFERENCE_ID | VARCHAR | No |
The unique reference ID associated with the Compass Rose episode.
6 | EPISODE_CSN_ID | NUMERIC | No |
CSN of the source DXR record which contains the compass rose episode data.
7 | SINGLE_SRC_ORG_ID | NUMERIC | No |
The source organization for the compass rose episode data.
8 | SINGLE_SRC_ORG_ID_EXTERNAL_NAME | VARCHAR | No |
Organization's external name used as the display name on forms and user interfaces.
9 | EPSD_PRIMARY_PROB_DEDUP_REF_ID | VARCHAR | No |
The de-duplicated primary problem associated with this episode.
10 | EPSD_PROGRAM_EPSD_DEDUP_REF_ID | VARCHAR | No |
The program episode de-duplicated reference ID associated with this episode.
11 | EPSD_START_DATE | DATETIME | No |
The date the episode was started.
12 | EPSD_ENROLLMENT_DATE | DATETIME | No |
The date the patient was enrolled in the program.
13 | EPSD_CALC_ENROLLMENT_DATE | DATETIME | No |
The date the patient was calculated to be enrolled in the program.
14 | EPSD_END_DATE | DATETIME | No |
The date the program was ended.
15 | EPSD_CCM_EPISODE_TYPE_C_NAME | VARCHAR | No |
Indicates whether the Coordinated Care Management episode is for a program or for a service.
May contain organization-specific values: Yes
Category Entries:
Program
Service
16 | EPSD_TYP_ID_C_NAME | VARCHAR | No |
The episode class for the 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
17 | EPSD_CMGMT_PROG_CAT_C_NAME | VARCHAR | No |
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
Other
18 | EPSD_STAT_INFO_C_NAME | VARCHAR | No |
The status of the episode.
May contain organization-specific values: No
Category Entries:
Active
Resolved
Deleted
19 | EPSD_CMGMT_STATUS_C_NAME | VARCHAR | No |
The status of the care coordination episode.
May contain organization-specific values: No
Category Entries:
Enrolling
Active
Closed
Paused
Declined
20 | EPSD_START_TO_ENROLL_BUS_DAYS | INTEGER | No |
The number of business days between when the episode started and when the patient was enrolled in the program associated with the episode.
21 | EPSD_ENROLL_TO_END_BUS_DAYS | INTEGER | No |
The number of days between when the patient was enroll in the program associated with the episode and when the episode ended in business days.
22 | EPSD_START_TO_END_BUS_DAYS | INTEGER | No |
The number of days between when the episode started and ended in business days.
23 | EPSD_START_TO_CALCENR_BUS_DAYS | INTEGER | No |
The number of days between when the episode started and the calculated enrollment date for the patient in the program in business days.
24 | EPSD_CALCENR_TO_END_BUS_DAYS | INTEGER | No |
The number of days between when the patient was calculated enrolled in the program and when the episode ended in business days.
25 | EPSD_PROGRAM_NAME | VARCHAR | No |
The name for the Compass Rose episode program.