SQL-based Risk Models

SQL-based risk models allow users to write raw SQL to stratify their patients by risk. The SQL must be a single SELECT statement and return two columns:

• patient_id – this should match the primary key from the patients table in the rdm schema.
• score – a numeric value representing the patient’s risk. There are no constraints on how you calculate the score

Note: SQL-based risk models do not display the risk score components breakdowns. Unlike risk factor-based models, they won’t display additional context on hover.