SC_EPISODE_EXTERNAL_ENC

Description:

Data about external encounters linked to a Compass Rose episode.

Primary Key

Column Name	Ordinal Position
SUMMARY_BLOCK_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	SUMMARY_BLOCK_ID	NUMERIC	No
	The unique identifier (.1 item) for the episode 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	REFERENCE	VARCHAR	No
	The composite DXR reference ID for an external encounter linked to this episode.
4	METRIC_STATUS_C_NAME	VARCHAR	No
	The status category ID for an external encounter linked to this episode. May contain organization-specific values: No Category Entries: Active Inactive
5	BND_EPSD_SRC_C_NAME	VARCHAR	No
	The source category ID for an external encounter linked to this episode. May contain organization-specific values: No Category Entries: User Visit Association Auto Link Auto Creation Auto Link Via Transform Auto Link Via Association Auto Removal
6	INVALIDATION_DATE	DATETIME	No
	The date when the link was found to be invalid for an external encounter linked to this episode.
7	START_DTTM	DATETIME (Local)	No
	The encounter start date and time for an external encounter linked to this episode. This will only be populated for non-Epic encounters and is used to match an encounter to an existing link even when the reference ID changes.
8	END_DTTM	DATETIME (Local)	No
	The encounter end date and time for an external encounter linked to this episode. This will only be populated for non-Epic encounters and is used to match an encounter to an existing link even when the reference ID changes.
9	DISP_ENC_TYPE_C_NAME	VARCHAR	No
	The encounter type category ID for an external encounter linked to this episode. This will only be populated for non-Epic encounters and is used to match an encounter to an existing link even when the reference ID changes. May contain organization-specific values: Yes Category Entries: Registration Walk-In Hospital Encounter Canceled Unmerge Contact Moved Intake EMPTY Research Encounter Recurring Plan Update PCP/Clinic Change Wait List Enrollment Social Care Application Service Decision Registration Leader Rounds Clerical Orders Mother Baby Link Lactation Encounter Appointment Surgery Anesthesia Anesthesia Event Guardian Screening Ancillary Procedure Anticoagulation Discharge Documentation Health Maintenance Letter Patient Message E-Visit Mobile Order Only Questionnaire Series Submission Travel Patient Self-Triage Community Care Management Patient Outreach Telephone Nurse Triage E-Consult E-Consult Community Order Results Follow-Up Clinical Documentation Only Telemedicine Plan of Care Documentation External Communication Reconciled Outside Data External Contact Ophth Exam Dialysis Calendar Documentation Pre-Admission Testing Episode Documentation Update Hospice Admission Home Infusion Home Infusion Billing Episode Update Home Health Resumption of Care Planning Home Health Admission Home Care Visit Home Care Update Kanta Service Event Remote Monitoring Data Collection Patient Web Update Community Orders Committee Review Post Mortem Documentation Billing Encounter Lab Requisition Office Visit Consent Form Procedure Pass External Hospital Admission Letter (Out) Hospital Refill Immunization History Referral Orders Only Rx Refill Authorize Meds Only (Web) Meds Void (Web) Resolute Professional Billing Hospital Prof Fee Episode Changes Ancillary Orders Pharmacy Visit OurPractice Advisory Abstract
10	ENC_TYPE_NAME	VARCHAR	No
	The encounter type free text name for an external encounter linked to this episode. This will only be populated for non-Epic encounters and is used to match an encounter to an existing link even when the reference ID changes.
11	ORG_ID	NUMERIC	No
	A unique organization identifier that consists of the name and the organization ID for the source organization of an external encounter linked to this episode. This column is often used for grouping, sorting, and display purposes in reports.
12	ORG_ID_EXTERNAL_NAME	VARCHAR	No
	Organization's external name used as the display name on forms and user interfaces.