This table is useful to query or describe general patterns related to hospitalizations. To trend hospitalizations over time, consider the utilizationperiod table. Columns related to hospitalizations in the utilizationperiod table are derived from this table.
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.
|
drg |
VARCHAR |
The DRG coded on the primary claim (if applicable).
|
secondarycaresettings |
VARCHAR |
A comma delimited string of other care settings (for example EMER when admitted from ED or OBSENC when admitted from observation) concurrent with the hospitalization.
|
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.
|
isacsc |
BOOLEAN |
True if the primary diagnosis is an Ambulatory Care Sensitive Condition.
|
isemergent |
BOOLEAN |
True of the admitsource is Emergency Department.
|
isbehavioralhealth |
BOOLEAN |
True if the primary diagnosis is a behavioral health diagnosis.
|
isreadmit30d |
BOOLEAN |
True if an inpatient discharge is detected in the prior 30 days.
|
claimstatus |
VARCHAR |
Denormalized claim.status from the primary claim (if applicable).
|
readmissionriskscore |
DECIMAL |
Based on the LACE readmit risk algorithm.
|
readmissionriskprofile |
VARCHAR |
Based on the LACE readmit risk algorithm.
|
admissionsource |
VARCHAR |
Admission source (i.e. Emergency Department, Transfer) for the derived encounter, determined in priority order from the primary encounter, claim, or authorization.
|
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.
|