Core 5.1 Model | Population Health | derivedencounter_nonacutebed

derivedencounter_nonacutebed

The derivedencounter_nonacutebed model reconciles all encounter and claim data sources into a unified list of health system visits where person is assigned a bed, not including acute hospitalization. Includes: SNF, LTC, and long term rehab encounters.

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.
caresetting	VARCHAR	NONAC-SNF, NONAC-OTH (Rehab, LTC)
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.
drg	VARCHAR	The DRG coded on the primary claim (if applicable).
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.
claimstatus	VARCHAR	Denormalized claim.status from the primary claim (if applicable).
dischargedisposition	VARCHAR	Discharge disposition (i.e. Home, SNF, Hospice) for the derived encounter, determined in priority order from the primary encounter, claim, or authorization.
annotations	VARCHAR	A comma delimited set of strings that represent computed features of the derived encounter.

Back to Tables