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:
Membership Trends: Investigate overarching patterns in membership growth, attrition, or stability to inform strategic planning.
Financials: Dive into the intricacies of member premiums and budget allocations to ensure fiscal responsibility and sustainability.
Classifications: Explore various other member classifications to understand the diverse landscape of your membership base. These classifications include tiers, age, gender, among others.
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:
Eligibility Month - Here the user can select the eligibility months that will be considered in the report.
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.
Eligibility Month - Denotes the specific month of eligibility for each row.
Members - Represents the total number of Members. See definition in General Metrics Definitions of the Core Definitions.
Members RAF - Provides the average of each Member's RAF. See definition in General Metrics Definitions of the Core Definitions.
Revenue - This is the total revenue for members. See definition in General Metrics Definitions of the Core Definitions.
Revenue PMPM - Captures the average revenue on a per member per month basis, achieved by dividing total revenue by the number of members.
Budget - This is the budget for members. See definition in General Metrics Definitions of the Core Definitions.
Budget PMPM - Represents the average budget allocation on a per member per month basis, derived by dividing the total budget by the number of members.
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:
000 - 000: Members aged 0 years.
001 - 010: Members aged 1 to 10 years.
011 - 020: Members aged 11 to 20 years.
021 - 035: Members aged 21 to 35 years.
036 - 050: Members aged 36 to 50 years.
051 - 064: Members aged 51 to 64 years.
065 - 099: Members aged 65 years and above.
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:
0.00 to 0.99
1.00 to 1.99
2.00 to 2.99
3.00 to 3.99
4.00 and UP
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:
Enrollment: Members initiating their enrollment within the designated month.
Disenrollment: Members concluding their enrollment within that month.
Both: Members who, within a single month, both initiated and concluded their enrollment.
None: Members maintaining consistent enrollment throughout the entire month, implying no initiation or conclusion of enrollment during that period.
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:
000: Members aged exactly 0 years.
001 - 010: Members aged between 1 and 10 years.
011 - 020: Members aged between 11 and 20 years.
021 - 035: Members aged between 21 and 35 years.
036 - 050: Members aged between 36 and 50 years.
051 - 064: Members aged between 51 and 64 years.
065 - 099: Members aged 65 years and above.
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.
Distribution Member Age Range - let the user filter the desired Age Range cohort for the visuals in 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:
Members - total Members in period. See definition in General Metrics Definitions of the Core Definitions.
Unique Members - total Unique Members in period. See definition in General Metrics Definitions of the Core Definitions.
RAF - the average RAF for the members in the period. See definition in General Metrics Definitions of the Core Definitions.
Revenue - the total revenue (i.e. premium) for the members in the period. See definition in General Metrics Definitions of the Core Definitions.
Revenue PMPM - the Revenue divided by the Members. That is, the average revenue per member per month.
Budget - The total Budget for the members in the period. See definition in General Metrics Definitions of the Core Definitions.
Budget PMPM - The Budget divided by the Members. That is, the average budget per member per month.
Is Registered - Members affiliated with a Special Condition program within the Plan.Â
Gender Female - Members with gender female.
Gender Male - Members with gender male.
Age Range - Members in the particular age range.
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.