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.