> For the complete documentation index, see [llms.txt](https://docs.lucernahealth.com/guide/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.lucernahealth.com/guide/consumer-360/consumer-profile/clinical.md).

# Clinical

Top opportunities, conditions, assessments, risk, care programs and care gaps. Select any value in the **Source System** column to see where that data originates.

<table><thead><tr><th width="139.51953125">Section</th><th width="129.9921875">Field</th><th width="201.03515625">What it means</th><th>Source System</th><th>Badge</th></tr></thead><tbody><tr><td>Top Opportunities</td><td>Top Opportunities</td><td>Ranked list of the highest-value actions available for this consumer right now.</td><td><a href="#top-opportunities-1">Derived in Leap</a></td><td>The first three are shown; View More reveals the rest.</td></tr><tr><td>All Conditions</td><td>All Conditions</td><td>Chronic and acute conditions on record. A condition appears once the payer's analytics have identified it, so a diagnosis made this morning will not show until the next data cycle.</td><td><a href="#all-conditions-1">Payer population health analytics</a></td><td><br>-</td></tr><tr><td>Sensitive Diagnoses</td><td>Sensitive Diagnoses</td><td>Conditions held behind restricted visibility, such as behavioral health and substance use.</td><td><a href="#sensitive-diagnoses-1">Payer population health analytics</a></td><td>-</td></tr><tr><td>Assessments</td><td>HRA</td><td>Health risk assessment score and the flags driving it.</td><td><a href="#hra">Self reported screenings</a></td><td>High: Red, 70% or above<br>Medium: Yellow, 40-69%<br>Low: Green, below 40%</td></tr><tr><td></td><td>SDoH</td><td>Count of social needs identified in screening.</td><td><a href="#sdoh">Self reported screenings</a></td><td>3+ needs: Red<br>1-2 needs: Yellow<br>0 needs: Green</td></tr><tr><td></td><td>PHQ-9</td><td>Depression screening score and flags.</td><td><a href="#phq-9">Self reported screenings</a></td><td>High: Red, 10-27<br>Medium: Yellow, 5-9<br>Low: Green, 0-4</td></tr><tr><td>Risk Profile</td><td>Risk Level</td><td>Risk profile is the composite risk snapshot: risk level, severity, ER frequent flyer status and payer cohort.<br>Risk level is how much care this consumer is expected to need relative to an average member. Higher scores mean higher expected cost and utilization, driven by the conditions on their record.</td><td><a href="#risk-level">Payer risk scoring</a></td><td>-</td></tr><tr><td></td><td>Severity Level</td><td>How clinically advanced this consumer's conditions are.</td><td><a href="#severity-level">Payer risk scoring</a></td><td>-</td></tr><tr><td></td><td>ER Frequent Flyer</td><td>Whether this consumer has a pattern of repeated emergency department visits, and when. Historical (PY) means the pattern was in the prior year; Recent (CY) means the current year; Current means it's happening now.</td><td><a href="#er-frequent-flyer">Payer risk scoring</a></td><td>-<br></td></tr><tr><td></td><td>Payer Cohort</td><td>The segment the payer has placed this consumer in for program purposes.</td><td><a href="#payer-cohort">Payer risk scoring</a></td><td>-</td></tr><tr><td>Risk and Cost Predictions Next 12 Months</td><td>Preventable ER Risk</td><td>Risk and cost predictions are forward-looking predictions for preventable ER, preventable inpatient and high cost. Predictions about what may happen, not a record of what has.<br>Preventable ER Risk is the predicted likelihood of an emergency visit in the next 12 months that timely outpatient care could have avoided.</td><td><a href="#preventable-er-risk">ML model output</a></td><td>High: Red<br>Medium: Yellow<br>Low: Green</td></tr><tr><td></td><td>Preventable Inpatient Risk</td><td>The same prediction for a hospital admission that timely outpatient care could have avoided.</td><td><a href="#preventable-inpatient-risk">ML model output</a></td><td>High: Red<br>Medium: Yellow<br>Low: Green</td></tr><tr><td></td><td>High Cost - 10%</td><td>Whether this consumer is predicted to land in the most expensive 10% of members over the next 12 months.</td><td><a href="#high-cost-10">ML model output</a></td><td>Yes: Red<br>No: Green</td></tr><tr><td></td><td>High Cost - 1%</td><td>Whether this consumer is predicted to land in the most expensive 1%.</td><td><a href="#high-cost-1">ML model output</a></td><td>Yes: Red<br>No: Green</td></tr><tr><td>Care Programs</td><td>Care Programs</td><td>Program eligibility and enrollment status, with the reason for the current status.</td><td><a href="#care-programs-1">Care management program feed</a></td><td>Elligible: Blue,<br>Enrolled: Green, <br>Declined, Disenrolled: Red</td></tr><tr><td>Care Gaps</td><td>Care Gaps</td><td>Open and closed quality measures. A gap closes when the payer's quality engine sees the closing evidence, which lags the visit that closed it.</td><td><a href="#care-gaps-1">Payer quality and HEDIS engine</a></td><td>Complete: Green, <br>Overdue: Red</td></tr></tbody></table>

{% hint style="info" %}
**Why a care gap still says Overdue after the visit.** A gap closes when the payer's quality engine sees the closing evidence, which lags the visit that closed it. A service performed and charted may still show as overdue until it is adjudicated.
{% endhint %}

***

### Data Lineage

#### Top Opportunities

<details>

<summary><strong>Top Opportunities</strong></summary>

<table><thead><tr><th width="134.453125">Source system</th><th>Leap table</th><th>UDM Source</th></tr></thead><tbody><tr><td>Derived in Leap by rules run across care gaps, care programs and assessments</td><td> <code>top_opportunities</code></td><td>consumer_factors, <a href="https://sanitas.leap.lucernahealth.com/data-hub/data-model/catalog-overview/leap_norm_model/phm/fct_factor"><code>fct_factor</code></a>, care_gaps, <a href="https://sanitas.leap.lucernahealth.com/data-hub/data-model/catalog-overview/leap_norm_model/phm/fct_quality"><code>fct_quality</code></a>, care_programs, <a href="https://sanitas.leap.lucernahealth.com/data-hub/data-model/catalog-overview/leap_norm_model/care_program/fct_care_program"><code>fct_care_program</code></a>, <a href="https://sanitas.leap.lucernahealth.com/data-hub/data-model/catalog-overview/leap_norm_model/claim/agg_claim"><code>agg_claim</code></a>, <a href="https://sanitas.leap.lucernahealth.com/data-hub/data-model/catalog-overview/leap_norm_model/claim/fct_med_encounter_procedure"><code>fct_med_encounter_procedure</code></a>, <a href="https://sanitas.leap.lucernahealth.com/data-hub/data-model/catalog-overview/leap_norm_model/appointment/fct_appointment"><code>fct_appointment</code></a>, <a href="https://sanitas.leap.lucernahealth.com/data-hub/data-model/catalog-overview/leap_norm_model/roster/fct_roster"><code>fct_roster</code></a>, <a href="https://sanitas.leap.lucernahealth.com/data-hub/data-model/catalog-overview/leap_application/cps/dim_consumer"><code>dim_consumer</code></a>, <a href="https://sanitas.leap.lucernahealth.com/data-hub/data-model/catalog-overview/leap_norm_model/cross_domain/rpt_consumer_latest_insurance"><code>rpt_consumer_latest_insurance</code></a>, assessment_phq9, assessment_sdoh, top_opportunities_tenant_config</td></tr></tbody></table>

</details>

#### All Conditions

<details>

<summary><strong>All Conditions</strong></summary>

<table><thead><tr><th width="134.453125">Source system</th><th>Leap table</th><th>UDM Source</th></tr></thead><tbody><tr><td>Payer population health analytics</td><td> <code>health_conditions</code></td><td><a href="https://sanitas.leap.lucernahealth.com/data-hub/data-model/catalog-overview/leap_norm_model/phm/fct_factor"><code>fct_factor</code></a></td></tr></tbody></table>

</details>

#### Sensitive Diagnoses

<details>

<summary><strong>Sensitive Diagnoses</strong></summary>

<table><thead><tr><th width="134.453125">Source system</th><th>Leap table</th><th>UDM Source</th></tr></thead><tbody><tr><td>Payer population health analytics</td><td> <code>health_conditions</code></td><td><a href="https://sanitas.leap.lucernahealth.com/data-hub/data-model/catalog-overview/leap_norm_model/phm/fct_factor"><code>fct_factor</code></a></td></tr></tbody></table>

</details>

#### Assessments

<details>

<summary><strong>HRA</strong></summary>

<table><thead><tr><th width="134.453125">Source system</th><th>Leap table</th><th>UDM Source</th></tr></thead><tbody><tr><td>Self-reported health risk assessment, collected by the payer or through an outreach campaign</td><td> <a href="https://sanitas.leap.lucernahealth.com/data-hub/data-model/catalog-overview/leap/self_reported_assessment/hra_commercial_united?version=163"><code>assessment_hra</code></a></td><td><a href="https://sanitas.leap.lucernahealth.com/data-hub/data-model/catalog-overview/leap_norm_model/cross_domain/rpt_hra_combined"><code>rpt_hra_combined</code></a>, <a href="https://sanitas.leap.lucernahealth.com/data-hub/data-model/catalog-overview/leap_norm_model/self_reporting/fct_hra_commercial_united"><code>fct_hra_commercial_united</code></a>, <a href="https://sanitas.leap.lucernahealth.com/data-hub/data-model/catalog-overview/leap_application/cps/dim_consumer"><code>dim_consumer</code></a></td></tr></tbody></table>

</details>

<details>

<summary><strong>SDoH</strong></summary>

<table><thead><tr><th width="134.453125">Source system</th><th>Leap table</th><th>UDM Source</th></tr></thead><tbody><tr><td>SDoH screening responses</td><td> <a href="https://sanitas.leap.lucernahealth.com/data-hub/data-model/catalog-overview/leap/sdoh/social_determinants_of_health?version=163"><code>sdoh</code></a></td><td><a href="https://sanitas.leap.lucernahealth.com/data-hub/data-model/catalog-overview/leap_norm_model/social_determinants_of_health/fct_sdoh"><code>fct_sdoh</code></a></td></tr></tbody></table>

</details>

<details>

<summary><strong>PHQ-9</strong></summary>

<table><thead><tr><th width="134.453125">Source system</th><th>Leap table</th><th>UDM Source</th></tr></thead><tbody><tr><td>PHQ-9 screening responses</td><td> <a href="https://sanitas.leap.lucernahealth.com/data-hub/data-model/catalog-overview/leap/self_reported_assessment/phq9?version=163"><code>assessment_phq9</code></a></td><td><a href="https://sanitas.leap.lucernahealth.com/data-hub/data-model/catalog-overview/leap_norm_model/self_reporting/fct_phq9"><code>fct_phq9</code></a></td></tr></tbody></table>

</details>

#### Risk Profile

<details>

<summary><strong>Risk Level</strong></summary>

<table><thead><tr><th width="134.453125">Source system</th><th>Leap table</th><th>UDM Source</th></tr></thead><tbody><tr><td>Payer risk scoring</td><td> <a href="https://sanitas.leap.lucernahealth.com/data-hub/data-model/catalog-overview/leap_application/cps?version=24"><code>consumer_profile</code></a></td><td><a href="https://sanitas.leap.lucernahealth.com/data-hub/data-model/catalog-overview/leap_norm_model/phm/fct_factor"><code>fct_factor</code></a></td></tr></tbody></table>

</details>

<details>

<summary><strong>Severity Level</strong></summary>

<table><thead><tr><th width="134.453125">Source system</th><th>Leap table</th><th>UDM Source</th></tr></thead><tbody><tr><td>Payer risk scoring</td><td> <a href="https://sanitas.leap.lucernahealth.com/data-hub/data-model/catalog-overview/leap_application/cps?version=24"><code>consumer_profile</code></a></td><td><a href="https://sanitas.leap.lucernahealth.com/data-hub/data-model/catalog-overview/leap_norm_model/phm/fct_factor"><code>fct_factor</code></a></td></tr></tbody></table>

</details>

<details>

<summary><strong>ER Frequent Flyer</strong></summary>

<table><thead><tr><th width="134.453125">Source system</th><th>Leap table</th><th>UDM Source</th></tr></thead><tbody><tr><td>Payer risk scoring, with the frequent flyer flag derived in Leap from claims</td><td> <a href="https://sanitas.leap.lucernahealth.com/data-hub/data-model/catalog-overview/leap_application/cps?version=24"><code>consumer_profile</code></a></td><td><a href="https://sanitas.leap.lucernahealth.com/data-hub/data-model/catalog-overview/leap_norm_model/phm/fct_factor"><code>fct_factor</code></a></td></tr></tbody></table>

</details>

<details>

<summary><strong>Payer Cohort</strong></summary>

<table><thead><tr><th width="134.453125">Source system</th><th>Leap table</th><th>UDM Source</th></tr></thead><tbody><tr><td>Payer risk scoring</td><td> <a href="https://sanitas.leap.lucernahealth.com/data-hub/data-model/catalog-overview/leap_application/cps?version=24"><code>consumer_profile</code></a></td><td><a href="https://sanitas.leap.lucernahealth.com/data-hub/data-model/catalog-overview/leap_norm_model/phm/fct_factor"><code>fct_factor</code></a></td></tr></tbody></table>

</details>

#### Risk and Cost Predictions Next 12 Months

<details>

<summary><strong>Preventable ER Risk</strong></summary>

<table><thead><tr><th width="134.453125">Source system</th><th>Leap table</th><th>UDM Source</th></tr></thead><tbody><tr><td>ML model output</td><td> <a href="https://sanitas.leap.lucernahealth.com/data-hub/data-model/catalog-overview/leap_application/cps?version=24"><code>consumer_profile</code></a></td><td><a href="https://sanitas.leap.lucernahealth.com/data-hub/data-model/catalog-overview/leap_norm_model/phm/fct_factor"><code>fct_factor</code></a></td></tr></tbody></table>

</details>

<details>

<summary><strong>Preventable Inpatient Risk</strong></summary>

<table><thead><tr><th width="134.453125">Source system</th><th>Leap table</th><th>UDM Source</th></tr></thead><tbody><tr><td>ML model output</td><td> <a href="https://sanitas.leap.lucernahealth.com/data-hub/data-model/catalog-overview/leap_application/cps?version=24"><code>consumer_profile</code></a></td><td><a href="https://sanitas.leap.lucernahealth.com/data-hub/data-model/catalog-overview/leap_norm_model/phm/fct_factor"><code>fct_factor</code></a></td></tr></tbody></table>

</details>

<details>

<summary><strong>High Cost 10%</strong></summary>

<table><thead><tr><th width="134.453125">Source system</th><th>Leap table</th><th>UDM Source</th></tr></thead><tbody><tr><td>ML model output</td><td> <a href="https://sanitas.leap.lucernahealth.com/data-hub/data-model/catalog-overview/leap_application/cps?version=24"><code>consumer_profile</code></a></td><td><a href="https://sanitas.leap.lucernahealth.com/data-hub/data-model/catalog-overview/leap_norm_model/phm/fct_factor"><code>fct_factor</code></a></td></tr></tbody></table>

</details>

<details>

<summary><strong>High Cost 1%</strong></summary>

<table><thead><tr><th width="134.453125">Source system</th><th>Leap table</th><th>UDM Source</th></tr></thead><tbody><tr><td>ML model output</td><td> <a href="https://sanitas.leap.lucernahealth.com/data-hub/data-model/catalog-overview/leap_application/cps?version=24"><code>consumer_profile</code></a></td><td><a href="https://sanitas.leap.lucernahealth.com/data-hub/data-model/catalog-overview/leap_norm_model/phm/fct_factor"><code>fct_factor</code></a></td></tr></tbody></table>

</details>

#### Care Programs

<details>

<summary><strong>Care Programs</strong></summary>

<table><thead><tr><th width="134.453125">Source system</th><th>Leap table</th><th>UDM Source</th></tr></thead><tbody><tr><td>Care management program feed</td><td> <code>care_programs</code></td><td><a href="https://sanitas.leap.lucernahealth.com/data-hub/data-model/catalog-overview/leap_norm_model/care_program/fct_care_program"><code>fct_care_program</code></a></td></tr></tbody></table>

</details>

#### Care Gaps

<details>

<summary><strong>Care Gaps</strong></summary>

<table><thead><tr><th width="134.453125">Source system</th><th>Leap table</th><th>UDM Source</th></tr></thead><tbody><tr><td>Payer quality and HEDIS engine</td><td> <code>care_gaps</code></td><td><a href="https://sanitas.leap.lucernahealth.com/data-hub/data-model/catalog-overview/leap_norm_model/phm/fct_quality"><code>fct_quality</code></a></td></tr></tbody></table>

</details>
