SELECT * FROM #Request.prefix_db_lookup#.Agency where Agency_ID = #Session.AgencyID#

#AgencyData.D_Act_Pts# (#AgencyData.D_Act_Pts_MC#)

Active Patients (MEDICARE)

#AgencyData.OMbetter#%

Improving (MEDICARE)

#AgencyData.OMsame#%

No Change (MEDICARE)

#AgencyData.OMworse#%

Deteriorating (MEDICARE)
News
  #DateFormat(getSystemNews.created, 'mmm dd, yyyy')# -#getSystemNews.title#  
Current 5-Star and VBP Statistics weekly stats...
TODAY
5-Star Ranking
SELECT ROUND(AVG(s.Avg5Star_DC)) as Avg5Star_DC FROM #Request.prefix_db_agency#.Assessment_Score s JOIN #Request.prefix_db_agency#.Assessment_New an ON s.Assessment_ID = an.Assessment_ID JOIN #Request.prefix_db_agency#.patient p ON p.Patient_ID = an.Patient_ID JOIN #Request.prefix_db_agency#.Payer py ON py.Payer_ID = an.Payer_ID WHERE an.Certification_End > '2015-12-31' and an.Deleted = 0 and an.Admission_Status = 'complete' AND (('transfer/discharged' = (select an.Medical_or_Treatment_Change_M0200 from #Request.prefix_db_agency#.Assessment_New an WHERE an.Assessment_ID = s.Assessment_ID)) OR ('discharged' = (select an.Medical_or_Treatment_Change_M0200 from #Request.prefix_db_agency#.Assessment_New an WHERE an.Assessment_ID = s.Assessment_ID))) and py.Track_Outcomes = 1 and py.payerstatus = 'active' and (s.Avg5Star_DC != '' or s.Avg5Star_TDC != '') GROUP BY an.Agency_ID SELECT * FROM #Request.prefix_db_lookup#.CMS_Outcomes ,#Request.prefix_db_lookup#.Agency WHERE CMS_Outcomes.CCN = Agency.Agency_Medicare_ID AND Agency.status = 'active' AND Agency.Agency_ID = '#Session.AgencyID#' #SOC.Avg5Star_DC# / 0 / 0.5 / 1.0 / 1.5 / 2.0 / 2.5 / 3.0 / 3.5 / 4.0 / 4.5 / 4.0 / 5.0
4/1/2018-3/31/2019
5-Star Ranking
VBP Reimbursement
Index
??%
DAILY CLASSES AVAILABLE

  Physician Marketing Reports

  Conditions of Participation Software Updates Training Request Form

  Run Coding Wizard#Session.Password#


  Teachplan Dashboard

  Pathway Dashboard


   Datasets Ready for Transmission
SELECT ROUND((AVG(s.Avg5Star_SOC)+AVG(s.AvgHHC_SOC))/2) as AVG_DC FROM #Request.prefix_db_agency#.Assessment_Score s JOIN #Request.prefix_db_agency#.Assessment_New an ON s.Assessment_ID = an.Assessment_ID WHERE an.Certification_End > '2015-12-31' and an.Deleted = 0 and an.Admission_Status = 'complete' and (an.Medical_or_Treatment_Change_M0200 = '') and (s.Avg5Star_SOC != '' or s.AvgHHC_SOC != '') GROUP BY an.Agency_ID
Quality-of-Care Index for Active Patients

#Avg_DC.AVG_DC# 0

Performance                                  Communications Last 30 records...
Assmt Completed > Dataset : #AgencyData.D_Trans_TA# days
Assmt Completed > RAP : #AgencyData.D_RAP_TA# days
Physician Order Turnaround : #AgencyData.D_Order_TA# days
Certification End > Final Billing : #AgencyData.D_Final_TA# days
Medicare Visits Need Re-Assignmt : #AgencyData.D_Schedule_Wrong#
Medicare Assmts/Evals No Rollover : #AgencyData.D_Rollover_No#