The riskprofile table represents a roll-up of a person’s currently active risk factors as computed by the Galileo Risk Stratification Framework. Each row in the table summarizes one risk factor that has been computed for a person and is currently active.
This table is similar to the conditionprofile table in structure and intended use.
See also: Galileo Risk Stratification Framework (GRSF)
Usage
This table is useful to understand the risk factors currently computed for a person or the overall frequency of risk factors in a population. Consider the riskfactor table to see these same risk factors structured in a one-row-per-person table.
Source Concepts
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.
|
| category |
VARCHAR |
Category of the active risk factor.
|
| code |
VARCHAR |
Code of the active risk factor.
|
| description |
VARCHAR |
Display name for the active risk factor.
|
| value |
VARCHAR |
The clinical value that is used to determine that the risk factor is active. For example, if the risk factor is “A1C greater than 9”, this column will be in the form “A1C 10.1 on 3/9/2017”.
|
| onsetdate |
TIMESTAMP |
The date on which the active risk factor became active. For example, if the risk factor is “2 or more ED visits in the past 6 months”, this is the date of the second ED visit.
|
| iscurrentrisklevel |
BOOLEAN |
True if this risk factor is used as criteria to compute the current risk level.
|
Back to Tables
