If you have questions or if you have ideas for a report you wish we would create, please contact the Data Solutions Platform customer service team at: DataSolutions@ahca.org
The Data Solutions
Platform is AHCA/NCAL's new data platform where you may purchase
specialized reports not available in LTC Trend Tracker. Access to this
resource is available to AHCA/NCAL members only and was created with
member input to help meet data needs that cannot be addressed with public
you wish to purchase reports from the Data Solutions Platform, please
visit DataSolutions.ahcancal.org or click the Login button below. Your
log in information will be the same username and password that you use
for other AHCA/NCAL sites: LTC Trend Tracker, ahcancal.org, and
educate.ahcancal.org. If you are registered for LTC Trend Tracker, you
are automatically registered for the Data Solutions Platform, you simply
need to log in and accept the terms and conditions to activate your
account. If you are not registered for LTC Trend Tracker, please click
the register button.
Data Solutions Platform Products
The Data Solutions Platform is
being launched with our debut report, P3©! P3© is a SNF-centered report
that uses Medicare Part A FFS hospital, SNF, and other PAC claims to
track patient flow and availability in your market area, broken out by
clinical categories relevant to the Patient Driven Payment Model (PDPM).
For more information about what is in the report, you may watch our introductory video at https://educate.ahcancal.org/p3
or you may log in to your account at DataSolutions.ahcancal.org
and view example excel reports and a pdf preview. For more details, please refer to the following FAQ.
What is P3©?
P3© is a SNF-centered report using hospital and SNF claims to track patient
flow and availability in your market area, broken out by clinical categories
relevant to the Patient Driven Payment Model (PDPM). The format of the P3©
report is an Excel workbook with four data tabs:
- Hospital Referral Data: shows
discharge patterns from the top 5 hospitals by volume in your market, state and
national benchmarks, the top SNFs receiving patients from the top 5 hospitals
in your market, the top 5 hospitals referring to your facility by volume
SNF LOS and Referral Data: shows
the LOS for your facility compared to state and top SNF benchmarks as well as a
summary of what settings your facility discharges patients to
Market PDPM Data: shows your
market’s hospital discharge volume by PDPM category
Top Hospital PDPM Data: shows
hospital discharge volume by PDPM category for the hospital from which you
receive the most referrals
How do I use this publication?
This report is intended to help your organization understand your market
hospitals' patient mix as you strengthen your clinical competencies and
programming to deliver high-value care under PDPM.
How do I get access to P3©?
In order to access P3©, you must be an AHCA/NCAL member, and you must be
registered for LTC Trend Tracker. If you are a member who is already registered
in LTC Trend Tracker, you may simply go to the AHCA/NCAL Data Solutions
platform, datasolutions.ahcancal.org, log in using your LTC Trend Tracker
credentials, then select and pay for subscription to the SNFs you are
Can I share my report with others?
Yes, you may share your subscriptions with up to 5 other LTC Trend Tracker
users. You must use their LTC Trend Tracker log in emails, and they will have
access to all reports you have subscribed to. You may add and remove shares if
you change your mind later.
What if I do not have access to LTC Trend Tracker?
If you do not have access to LTC Trend Tracker because you are not an AHCA/NCAL
member, then you will not have access to P3©. P3© is only accessible to
If you are a member, but are not registered in LTC Trend Tracker, you may
register here: https://www.ahcancal.org/research_data/trendtracker/Pages/default.aspx
If you have further questions or need assistance with registration, please
How much does it cost?
A one-year subscription to P3© is $750 per SNF per year, plus state and local
What is included in a subscription?
A one-year subscription includes four quarterly report updates for the SNF
building you have subscribed to. Subscriptions are for one calendar year from
the date of purchase and will begin with immediate access the most recent
report available. Your subscription will then include the remaining 3 reports
on a rolling basis for the remainder of the subscription cycle, as they become
In addition to the report itself, your subscription includes access to
supporting and complementary educational material available through
educate.ahcancal.org/p3. At launch, materials will include an informational
video about the P3© report and how to access it and informational and marketing
materials as they become available. As 2020 progresses, additional material
will be added to expand and support your use and understanding of how to
leverage the P3© tool.
How do I pay for a report?
Payments must be made by credit card and will be handled directly through the
AHCA/NCAL Data Solutions Platform through the third party vendor,
authorize.net. Shortly after launch, payment from electronic accounts will be
made available, but that functionality is not currently supported.
What is the data source and how often are the data refreshed?
100% Medicare Fee-For-Service (FFS) claims, updated quarterly. Each report
contains four quarters of claims data and for each new quarterly report, the
rolling year-long window will be shifted forward one quarter. Medicare
Advantage referrals are not included in the data.
Why does my report show “*” or “<11”?
To comply with HIPAA, data points with <11 volume will show “*”. Cells will
show 0 when there is no volume.
How is the market defined?
The market definition is based on the SNF’s county, which is then mapped to a
Metropolitan Statistical Area (MSA). Should a facility be in a rural area and
fall outside of an MSA, your market will be defined as your Hospital Referral
How are hospitals selected in the “Market PDPM Data” tab?
This tab shows data from the top five hospitals in the market. Top five
hospitals are defined by total number of discharges to all post-acute settings
How is the hospital selected in the “Top Hospital PDPM Data” tab?
This tab shows data from the SNF’s (defined by CCN) top referring hospital by
What is the PDPM condition methodology?
The underlying data in this report are Medicare Fee-For-Service hospital
claims. PDPM conditions and services are specified to enable SNF coding on the
MDS. For some PDPM conditions/services, there is a clear mapping back to the
hospital claim data (ICD-10). For example, CMS provided crosswalks for some
NTAs (e.g., HIV/AIDs, Lung Transplant Status, Opportunistic Infections) with
the corresponding ICD-10 codes. For other PDPM conditions/services, especially
those that indicate a level of function, this report uses the generic condition
and may lose some level of detail in the crosswalk (e.g., Special Care High:
COPD and shortness of breath when lying flat is captured as "COPD" in
this report and includes all ICD-10 codes for COPD). Conditions may require
additional clinical services. The conditions/services are not mutually
exclusive (i.e., a patient can be counted under any number of