riskfactor

The riskfactor table provides a useful structure that summarizes all risk concepts computed by the Galileo Risk Stratification Framework that may be present on a person on a given date. Each row represents a person on a specified date. Risk factors are represented as boolean columns in this wide table structure.

See also: Galileo Risk Stratification Framework (GRSF)

Usage

This table is useful for developing models that relate the presence of risk factors to prospective utilization or clinical events.

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.

date TIMESTAMP

The date on which all risk factors in this row have been computed. Typically the first of a month.

risklevel VARCHAR

The risk level computed, based on all risk factors, on the specified date.

USD100K BOOLEAN

Annual Spend over 100K

USD50K BOOLEAN

Annual Spend over 50K

USD75K BOOLEAN

Annual Spend over 75K

A1C8 BOOLEAN

Last A1c 8 or greater

A1C8NoMeds BOOLEAN

A1C 8 or greater, no med therapy

A1C9 BOOLEAN

Last A1c 9 or greater

Age90 BOOLEAN

Age 90 or greater

ASCHosp45d BOOLEAN

ASC Hospitalization, prior 45d

ASCHospED BOOLEAN

1 or more ASCs coded on Hospitalization/ED, past 365 days

ASCHospEDprior3m BOOLEAN

1 or more ASCs coded on Hospitalization/ED, past 3 mo

ASCHospEDprior6m BOOLEAN

1 or more ASCs coded on Hospitalization/ED, past 6 mo

BHHosp120d BOOLEAN

Hospitalization BH Condition, prior 120d

BHHosp90d BOOLEAN

Hospitalization BH Condition, prior 90d

cGFR20 BOOLEAN

Last cGFR 20 or less

cGFR25 BOOLEAN

Last cGFR 25 or less

cGFR30 BOOLEAN

Last cGFR 30 or less

cGFR35 BOOLEAN

Last cGFR 35 or less

cGFR40 BOOLEAN

Last cGFR 40 or less

ChronicMed10 BOOLEAN

Chronic Meds 10 or more, last 6 month

ChronicMed15 BOOLEAN

Chronic Meds 15 or more, last 6 month

Dementia BOOLEAN

Dementia

ED+CHF BOOLEAN

ED or Hosp, prior 6m + Congestive Heart Failure

ED+COPD BOOLEAN

ED or Hosp, prior 6m + Chronic Obstructive Pulmonary Disease

ED+Dementia BOOLEAN

ED or Hosp, prior 6m + Dementia

ED+MED:ACEI BOOLEAN

ED or Hosp, prior 6m + Medication: ACE INHIBITORS

ED+MED:ANEST BOOLEAN

ED or Hosp, prior 6m + Medication: ANESTHETICS,MUCOSAL

ED+MED:ANTIA BOOLEAN

ED or Hosp, prior 6m + Medication: ANTIARRHYTHMICS

ED+MED:ANTIC BOOLEAN

ED or Hosp, prior 6m + Medication: ANTICONVULSANTS

ED+MED:ANTIH BOOLEAN

ED or Hosp, prior 6m + Medication: ANTIHYPERTENSIVES,OTHER

ED+MED:ANTIP BOOLEAN

ED or Hosp, prior 6m + Medication: ANTIPARKINSON AGENTS

ED+MED:BENZO BOOLEAN

ED or Hosp, prior 6m + Medication: BENZODIAZEPINE DERIVATIVE SEDATIVES/HYPNOTICS

ED+MED:BRONC BOOLEAN

ED or Hosp, prior 6m + Medication: BRONCHODILATORS,SYMPATHOMIMETIC,INHALATION

ED+MED:GENIT BOOLEAN

ED or Hosp, prior 6m + Medication: GENITO-URINARY AGENTS,OTHER

ED+MED:H.PY BOOLEAN

ED or Hosp, prior 6m + Medication: H. PYLORI AGENTS

ED+MED:HISTA BOOLEAN

ED or Hosp, prior 6m + Medication: HISTAMINE ANTAGONISTS

ED+MED:INSUL BOOLEAN

ED or Hosp, prior 6m + Medication: INSULIN

ED+MED:LOCAL BOOLEAN

ED or Hosp, prior 6m + Medication: LOCAL ANESTHETICS,TOPICAL

ED+MED:LOOP BOOLEAN

ED or Hosp, prior 6m + Medication: LOOP DIURETICS

ED+MED:OPIOI BOOLEAN

ED or Hosp, prior 6m + Medication: OPIOID ANALGESICS

ED+MED:OSMOT BOOLEAN

ED or Hosp, prior 6m + Medication: OSMOTIC AGENTS,SYSTEMIC OPHTHALMIC

ED+MED:PLATE BOOLEAN

ED or Hosp, prior 6m + Medication: PLATELET AGGREGATION INHIBITORS

ED+MED:POTAS BOOLEAN

ED or Hosp, prior 6m + Medication: POTASSIUM SPARING/COMBINATIONS DIURETICS

ED+RF BOOLEAN

ED or Hosp, prior 6m + Acute Renal Failure

ED1Hosp1p6m BOOLEAN

ED 1 or more, prior 6m + Hospitalizations 1 or more, prior 6m

ED1prior12m BOOLEAN

ED 1 or more, prior 12m

ED1prior3m BOOLEAN

ED 1 or more, prior 3m

ED1prior3mA1C9 BOOLEAN

ED 1 or more, prior 3m + Last A1c 9 or greater

ED1prior3mChronicMed10 BOOLEAN

ED 1 or more, prior 3m + Chronic Meds 10 or more, last 6 month

ED1prior3mDementia BOOLEAN

ED 1 or more, prior 3m + Dementia

ED1prior3mHCC2 BOOLEAN

ED 1 or more, prior 3m + HCC 2

ED1prior3mHCC25 BOOLEAN

ED 1 or more, prior 3m + HCC 2.5

ED1prior3mHCC3 BOOLEAN

ED 1 or more, prior 3m + HCC 3

ED1prior3mHCCplus1 BOOLEAN

ED 1 or more, prior 3m + HCC change 1 or more

ED1prior3mOpioid6m BOOLEAN

ED 1 or more, prior 3m + Opioid usage

ED1prior3mUM1 BOOLEAN

ED 1 or more, prior 3m + UM 1.0

ED1prior3mUM2 BOOLEAN

ED 1 or more, prior 3m + UM 2.0

ED1prior6m BOOLEAN

ED 1 or more, prior 6m

ED1prior6mA1C9 BOOLEAN

ED 1 or more, prior 6m + Last A1c 9 or greater

ED1prior6mDementia BOOLEAN

ED 1 or more, prior 6m + Dementia

ED1prior6mHCC15 BOOLEAN

ED 1 or more, prior 6m + HCC 1.5

ED1prior6mHCC2 BOOLEAN

ED 1 or more, prior 6m + HCC 2

ED1prior6mHCCplus1 BOOLEAN

ED 1 or more, prior 6m + HCC change 1 or more

ED2Hosp1p6m BOOLEAN

ED 2 or more, prior 6m + Hospitalizations 1 or more, prior 6m

ED2prior12m BOOLEAN

ED 2 or more, prior 12m

ED2prior3m BOOLEAN

ED 2 or more, prior 3m

ED2prior6m BOOLEAN

ED 2 or more, prior 6m

ED3Hosp1p6m BOOLEAN

ED 3 or more, prior 6m + Hospitalizations 1 or more, prior 6m

ED3Hosp2p6m BOOLEAN

ED 3 or more, prior 6m + Hospitalizations 2 or more, prior 6m

ED3prior12m BOOLEAN

ED 3 or more, prior 12m

ED3prior3m BOOLEAN

ED 3 or more, prior 3m

ED3prior6m BOOLEAN

ED 3 or more, prior 6m

ED4Hosp1p6m BOOLEAN

ED 4 or more, prior 6m + Hospitalizations 1 or more, prior 6m

ED4prior12m BOOLEAN

ED 4 or more, prior 12m

ED4prior3m BOOLEAN

ED 4 or more, prior 3m

ED4prior6m BOOLEAN

ED 4 or more, prior 6m

ED6prior12m BOOLEAN

ED 6 or more, prior 12m

EDHosp3p12m BOOLEAN

Hosp + 2 more ED/Hosp, prior 12m

EDHospp6mHCC15 BOOLEAN

ED or Hosp, prior 6m + HCC 1.5

ESLD BOOLEAN

ESLD

ESRD BOOLEAN

ESRD

HCC15 BOOLEAN

HCC 1.5 or higher

HCC2 BOOLEAN

HCC 2 or higher

HCC25 BOOLEAN

HCC 2.5 or higher

HCC2Opioid6m BOOLEAN

HCC 2 or greater + Opioid usage

HCC3 BOOLEAN

HCC 3 or higher

HCC35 BOOLEAN

HCC 3.5 or higher

HCC4 BOOLEAN

HCC 4 or higher

HCC45 BOOLEAN

HCC 4.5 or higher

HCC5 BOOLEAN

HCC 5 or higher

HCC55 BOOLEAN

HCC 5.5 or higher

HCC6 BOOLEAN

HCC 6 or higher

HCCplus15prior3m BOOLEAN

HCC change 1.5 or greater, prior 3m

HCCplus1Opioid6m BOOLEAN

HCC change 1 or greater + Opioid usage

HCCplus1prior3m BOOLEAN

HCC change 1.0 or greater, prior 3m

HCCplus2prior3m BOOLEAN

HCC change 2 or greater, prior 3m

Hosp1prior12m BOOLEAN

Hospitalizations 1 or more, prior 12m

Hosp1prior3m BOOLEAN

Hospitalizations 1 or more, prior 3m

Hosp1prior3mHCC2 BOOLEAN

Hospitalizations 1 or more, prior 3m + HCC 2

Hosp1prior3mHCC3 BOOLEAN

Hospitalizations 1 or more, prior 3m + HCC 3

Hosp1prior3mHCCplus1 BOOLEAN

Hospitalizations 1 or more, prior 3m + HCC change 1 or more

Hosp1prior6m BOOLEAN

Hospitalizations 1 or more, prior 6m

Hosp1prior6mHCC15 BOOLEAN

Hospitalizations 1 or more, prior 6m + HCC 1.5

Hosp2prior12m BOOLEAN

Hospitalizations 2 or more, prior 12m

Hosp2prior3m BOOLEAN

Hospitalizations 2 or more, prior 3m

Hosp2prior6m BOOLEAN

Hospitalizations 2 or more, prior 6m

Hosp3prior12m BOOLEAN

Hospitalizations 3 or more, prior 12m

MED:ACEI BOOLEAN

Medication: ACE INHIBITORS

MED:ANEST BOOLEAN

Medication: ANESTHETICS,MUCOSAL

MED:ANTIA BOOLEAN

Medication: ANTIARRHYTHMICS

MED:ANTIP BOOLEAN

Medication: ANTIPARKINSON AGENTS

MED:BENZO BOOLEAN

Medication: BENZODIAZEPINE DERIVATIVE SEDATIVES/HYPNOTICS

MED:GENIT BOOLEAN

Medication: GENITO-URINARY AGENTS,OTHER

MED:H.PY BOOLEAN

Medication: H. PYLORI AGENTS

MED:HISTA BOOLEAN

Medication: HISTAMINE ANTAGONISTS

MED:LOCAL BOOLEAN

Medication: LOCAL ANESTHETICS,TOPICAL

MED:LOOP BOOLEAN

Medication: LOOP DIURETICS

MED:OPIOI BOOLEAN

Medication: OPIOID ANALGESICS

MED:OSMOT BOOLEAN

Medication: OSMOTIC AGENTS,SYSTEMIC OPHTHALMIC

MED:PLATE BOOLEAN

Medication: PLATELET AGGREGATION INHIBITORS

MED:POTAS BOOLEAN

Medication: POTASSIUM SPARING/COMBINATIONS DIURETICS

Opioid6m BOOLEAN

3 or more opioid prescriptions, last 6 months

Readmit120d BOOLEAN

30d Readmit, prior 120d

Readmit45d BOOLEAN

30d Readmit, prior 45d

Readmit90d BOOLEAN

30d Readmit, prior 90d

StableBH BOOLEAN

Stable BH condition

SubstanceAbuse12m BOOLEAN

Substance abuse, prior 12m

SubstanceAbuse90d BOOLEAN

Substance abuse, prior 90d

UM1 BOOLEAN

UM 1 or higher

UM2 BOOLEAN

UM 2 or higher

UM3 BOOLEAN

UM 3 or higher


Back to Tables