Eligibility Dashboard

This comprehensive report serves as a cornerstone resource for understanding all facets of membership dynamics. Tailored for in-depth analysis and actionable insights, this report allows users to:

From this macro-level overview, the report provides the option for users to drill down into detailed reports, offering granular insights into specific metrics related to membership.

Report Parameters

The parameters of this report include the Core parameters defined in the General Parameters or Controls section of the Core Definitions. 

Other parameters are:

These parameters filter all the Tabs of the report.

Tab - Eligibility Dashboard

High Level Summary

This section presents the high-level eligibility metrics for the population being analyzed, structured month by month. Each row represents metrics for a distinct eligibility month.

For a deeper dive into the data of a specific month, users can drill down to the Eligibility Details report.

Members by Gender and Age

This stacked bar graph delineates the distribution of members by gender and age range for the most recent eligibility month selected. Each distinct color signifies a specific age bracket, while separate bars differentiate between genders. Users can further delve into the data by drilling down to the Eligibility Details, which are filtered by both gender and age range.

Eligibility per Month

This line graph illustrates the monthly membership trend for the specified population. Users can further examine data for a specific month by selecting the corresponding data point on the graph.

Members per Age in the Last Month

This pie chart presents the total membership for the most recent month, segmented by defined age cohorts. The age distribution is classified as follows:

For a detailed view, users can select any segment of the pie to drill down to the Eligibility Details specific to the chosen age cohort.

Members per RAF Range in the Last Month

This pie chart delineates the total membership for the most recent month, categorized by RAF (Risk Adjustment Factor) bands. The defined RAF intervals are:

For in-depth analysis, users may select any segment of the chart to navigate to the Eligibility Details corresponding to the selected RAF range.

Members per Tier Code 2 in Last Month

This pie chart delineates the total membership for the most recent month, categorized by Tier Code 2. The specific classifications under Tier Code 2 vary based on the Healthcare Model in focus.

For a detailed examination, users can select any segment of the chart to access the Eligibility Details associated with the chosen Tier Code 2 category.

Members per Tier Code 2 per Month

This table delineates the monthly membership, categorized by Tier Code 2. It's important to note that the specific classifications within Tier Code 2 are contingent upon the Healthcare Model under examination. In this layout, Tier Code 2 categories are arranged in rows, while the respective months are presented in columns. For a more granular view, users can navigate to the Eligibility Details by selecting a specific intersection of Tier Code 2 and Month.

Members per RAF Range per Month

This table displays the monthly membership data, organized by RAF (Risk Adjustment Factor) range. Within the table's structure, RAF ranges are designated in rows, while corresponding months occupy the columns. Users, seeking a more detailed perspective, can proceed to the Eligibility Details by selecting a specific intersection of RAF range and month.

Average Member Revenue per Month

This line graph delineates the progression of Revenue PMPM (Per Member Per Month) chronologically. The vertical axis signifies the revenue magnitude, while the horizontal axis enumerates the sequential months. Upon selecting any specific data point, users are redirected to the Eligibility Details corresponding to that particular month.

Tab - Trends

Membership Trend by Group Level

This Pivot Table delineates the membership distribution across various group levels, contingent upon the specific Healthcare Model under consideration. The table features Group Level 2 (commonly representative of regions), Group Level 5 (typically denoting Primary Medical Groups), and Group Level 7 (usually indicative of Primary Care Physicians). The hierarchical structure of this Pivot Table allows for tiered exploration; expanding Group Level 2 unveils associated Group Level 5 entities, and further expanding Group Level 5 reveals its corresponding Group Level 7 subsets. The temporal context is furnished through the columnar presentation of months.

For deeper analysis, users can navigate to the Eligibility Details, which will be filtered based on the selected group level and month.

Membership Trend by Group Level 4

This table delineates the membership distribution across Group Level 4, contingent upon the specific Healthcare Model under examination. Typically, Group Level 4 represents the Super Primary Medical Group. Months are displayed in the columns for temporal reference.

For a more granular analysis, users have the capability to navigate to the Eligibility Details, filtered contextually by the selected Group Level 4 and month.

Membership Trend by Group Level 3

This table systematically illustrates membership distribution across Group Level 3 in a temporal context. The interpretation of Group Level 3 is contingent upon the specific Healthcare Model under scrutiny, though it predominantly represents the Municipality. Time intervals, represented by months, are organized in the columns.

For enhanced, specific analysis, users can transition to the Eligibility Details, refining the view based on the chosen Group Level 3 and associated month.

Membership Trend by Enrollment Status

This table offers a structured overview of membership, delineated by Enrollment Status, further segmented into adults and minors, across a chronological spectrum. Enrollment Status classifications, depicted row-wise, include:

For categorization purposes, minors are defined as members aged between 0 and 20, while adults comprise members aged 21 and above.

For a more granulated exploration, users can drill down to the Eligibility Details, filtering the view based on the specified Enrollment Status and month.

Membership Trend by Age Range

This table delineates membership distribution by age range, categorized as either adults or minors, across a temporal spectrum. Rows denote distinct age brackets, while columns signify consecutive months. The specified age brackets are as follows:

For classification purposes, minors comprise members aged 0 to 20, whereas adults encompass members aged 21 and above.

Navigating from this table, users can access the Eligibility Details, specifically filtered by the chosen age bracket and month.

Tab - Distribution

Tab Parameters

This parameter applies only to this Tab.

Group Level 7 Membership Distribution by Age in Last Month

This table delineates membership distribution based on Group Level 7 and age parameters. It's essential to note that the definition of Group Level 7 varies according to the specific Healthcare Model under evaluation, typically corresponding to the Primary Care Physician designation.

From this table, users can seamlessly navigate to the Eligibility Details report, which is filtered based on the selected Group Level 7 and age criteria.

Tab - Summary

High Level Summary

This Pivot Table provides a comprehensive overview of essential metrics pertinent to the evaluated population and period. The table categorizes the population based on Group Level distinctions: Group Level 2 (commonly referring to 'Region'), Group Level 5 (typically 'Primary Medical Group'), and Group Level 7 (often denoting 'Primary Care Physician'). As an inherent feature of Pivot Tables, users can expand each group to reveal associated subgroups. For instance, expanding a Group Level 2 entry will display all underlying Group Level 5 entities, and similarly, unfolding a Group Level 5 will unveil all corresponding Group Level 7 components.

The metrics encapsulated within this table are as follows:

From this table, users possess the capability to navigate to the 'Eligibility Details' report, enabling filters based on a distinct month and group level.

Tab - Map

Last Month Population Map

This geospatial map visually represents the population distribution based on members' physical addresses. The determination of each location is anchored to the member's postal code. Users have the capability to magnify specific areas on the map, allowing for a more precise examination of member concentrations.