This table is useful for developing models that relate the presence of risk factors to prospective utilization or clinical events.
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
|