The personmostrecentevent table summarizes the last instance of common utilization events and test results.
Usage
This table is commonly extended for data mart-specific use cases.
Source Concepts
Table Schema
| Name |
Type
|
Description |
| personid |
VARCHAR (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.
|
| hospitaldischarge |
TIMESTAMP |
Date of the most recent hospital discharge. NULL if no hospitalizations are detected.
|
| hospitaldischargeprimarydxccs |
VARCHAR |
CCSR category of the primary diagnosis recorded for the most recent hospital discharge. NULL if no hospitalizations are detected.
|
| edvisit |
TIMESTAMP |
Date of the most recent ED visit. NULL if no ED visits are detected.
|
| edvisitprimarydxccs |
VARCHAR |
CCSR category of the primary diagnosis recorded for the most recent ED visit. NULL if no ED visits are detected.
|
| wellnessvisit |
TIMESTAMP |
Date of the most recent wellness visit. NULL if no wellness visits are detected.
|
| homehealthvisit |
TIMESTAMP |
Date of the most recent home health visit. NULL if no home health visits are detected.
|
| physicianvisit |
TIMESTAMP |
Date of the most recent office visit with a 92xxx service. NULL of no office visits are detected.
|
| a1cdate |
TIMESTAMP |
Date of the most recent A1C lab result. NULL if no results detected.
|
| a1cvalue |
DECIMAL |
Most recent A1C lab result value.
|
| cgfrdate |
TIMESTAMP |
Date of the most recent cGFR lab result. NULL if no results detected.
|
| cgfrvalue |
DECIMAL |
Most recent cGRF lab result value.
|
Back to Tables
