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
|