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
Restricted Health Data Sequestering
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
Radiation Treatment
Recurring Plan
Billing Exchange
Health Plan
Update
PCP/Clinic Change
Wait List
Enrollment
Social Care Application
Service Decision Registration
Leader Rounds
Clerical Orders
Patient-Selected Community Resource
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
Organ Offer
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.