derivedencounter_ed

The derivedencounter_ed table reconciles all encounter and claim data sources into a unified list of “treat and release” ED visits for a person. Each ED visit is represented with one row. Multiple encounter or claim sources may be rolled into this single row based on a reconciliation algorithm.

See also:

  • Galileo Encounter Reconciliation for a description of the algorithm used to derive encounters from claims, encounters, and authorizations based on primarycaresetting.

Usage

This table is useful to query or describe general patterns related to ED utilization. To trend ED visits over time, consider the utilizationperiod table. Columns related to ED visits in the utilizationperiod table are derived from this table.

Source Concepts

  • claim
  • encounter

Table Schema

Name Type Description
personid VARCHAR(38) GUID

Unique identifier representing a unique person that may include data from several sources that have been linked. This identifier is the person_id of a HIEBus recordgroup.

id VARCHAR(38) GUID

Unique identifier assigned by the algorithm for the derived encounter.

admitdate TIMESTAMP

The date of admission. Selected using the following priority: admitdate from the primary encounter, admitdate from the primary claim, admitdate from the primary authorization.

dischargedate TIMESTAMP

The date of discharge. Selected using the following priority: dischargedate from the primary encounter, dischargedate from the primary claim, dischargedatefrom the primary authorization.

primarydx VARCHAR

The description of the primary diagnosis of the derived encounter.

primarydxcode VARCHAR

The code of the primary diagnosis of the derived encounter.

primarydxccs VARCHAR

The HCUP CCSR category name related to the primary diagnosis of the derived encounter.

primarydxtermid INTEGER

The termid of the primary diagnosis of the derived encounter. This is a reference to a HIEBus term that captures the coded diagnosis sent by the source system. This reference can be used to join to the Terminology Model to determine source details, mappings, and value sets.

primaryprovideridentifier VARCHAR

The identifier of the provider selected by the algorithm as the primary provider.

primaryprovider VARCHAR

The name of the provider selected by the algorithm as the primary provider. This is an institutional provider, commonly the name of a hospital or health system.

primaryclaimid VARCHAR(38) GUID

Reference to the source claim. NULL if a related claim is not available.

primaryencounterid VARCHAR(38) GUID

Reference to the source encounter. NULL if a related encounter is not available.

primaryreferralid VARCHAR(38) GUID

Reference to the source authorization. NULL if a related authorization is not available.

primaryclaimdatasource VARCHAR

Datasource of the source claim. NULL if a related claim is not available.

primaryencounterdatasource VARCHAR

Datasource of the source encounter. NULL if a related encounter is not available.

primaryreferraldatasource VARCHAR

Datasource of the source authorization. NULL if a related authorization is not available.

isavoidable BOOLEAN

True if the primary diagnosis is an Ambulatory Care Sensitive Condition.

isbehavioralhealth BOOLEAN

True if the primary diagnosis is a behavioral health diagnosis.

isrepeat30d BOOLEAN

True if an inpatient discharge is detected in the prior 30 days.

claimstatus VARCHAR

Denormalized claim.status from the primary claim (if applicable).

annotations VARCHAR

A comma delimited set of strings that represent computed features of the derived encounter.


Back to Tables