SELECT * FROM #Request.prefix_db_lookup#.Agency where Agency_ID = #Session.AgencyID# select DE_Unapproved, DE_Progress_Items from #Request.prefix_db_lookup#.Employee Where Employee_ID='#session.EmployeeID#' SELECT Year(Date_Received_Item_25) as years,Month(Date_Received_Item_25) as Months,Count(*) As Total_orders,Form_Type FROM #Request.prefix_db_agency#.Assessment_Forms WHERE Form_Status = 'Signed' AND Month(Date_Received_Item_25) = MONTH(NOW()) AND Year(Date_Received_Item_25) = YEAR(NOW()) GROUP BY Form_Type SELECT Year(Date_Received_Item_25) as years,Month(Date_Received_Item_25) as Months,Count(*) As Total_orders,Form_Type FROM #Request.prefix_db_agency#.Assessment_Forms WHERE Form_Status = 'Signed' AND Year(Date_Received_Item_25) = YEAR(NOW()) GROUP BY Form_Type

#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)
SELECT * FROM #Request.prefix_db_lookup#.Employee WHERE Agency_ID = #Session.AgencyID# AND Employee_ID = #Session.EmployeeId# SELECT * FROM #Request.prefix_db_lookup#.Employee WHERE Agency_ID = #Session.AgencyID# AND Employee_ID = #Session.EmployeeId# AND DE_Act_Pts is not null AND DE_Act_Pts_MC is not null AND OMbetter is not null AND OMworse is not null AND OMsame is not null

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

Active Patients (MEDICARE)

#Emp.DE_Act_Pts# (#Emp.DE_Act_Pts_MC#)

Active Patients (MEDICARE)

#AgencyData.OMbetter#%

Improving (MEDICARE)

#Emp.OMbetter#%

Improving (MEDICARE)

#AgencyData.OMsame#%

No Change (MEDICARE)

#Emp.OMsame#%

No Change (MEDICARE)

#AgencyData.OMworse#%

Deteriorating (MEDICARE)

#Emp.OMworse#%

Deteriorating (MEDICARE)
News


  Run Coding Wizard

  Go Coding Wizard Dasboard
   #DateFormat(getSystemNews.created, 'mmm dd, yyyy')# - #getSystemNews.title#  
   Monthly Billing Reports 		MTD $#total_cost_month# YTD $#total_cost_year#
   Classes Every Hour, Monday-Friday, Starting at 9am EST 		More News..
  Physician Marketing Reports
  Conditions of Participation Software Updates Training Request Form
Performance 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
Employee Performance : #AgencyData.OMbetter#/#AgencyData.OMsame#/#AgencyData.OMworse#
Medicare Visits Need Re-Assignmt : #AgencyData.D_Schedule_Wrong#
Medicare Assmts/Evals No Rollover : #AgencyData.D_Rollover_No#
Visit Utilization

#AgencyData.AVG_Utilization#%

Communications
   style="color:red; font-weight:bold;">Assigned to You
   Created by You
   Agency Total
   New Communication
   UnResolved Incidences
   You have #GetEmp.DE_Unapproved# missing  and #GetEmp.DE_Progress_Items# incomplete/unapproved progress notes
   System Info
   Update PowerPath to #powerpath_version#
   Who Should be Your Project Manager?
   Computer Setup & Troubleshooting
   What's Your Home Health Regulations IQ?
News
  #DateFormat(getSystemNews.created, 'mmm dd, yyyy')# - #getSystemNews.title#  
   Monthly Billing Reports 		MTD $#total_cost_month# YTD $#total_cost_year#
   Classes Every Hour, Monday-Friday, Starting at 9am EST 		More News..
  Physician Marketing Reports
  Conditions of Participation Software Updates Training Request Form
Communications                                                       System info Last 30 records...
   style="color:red; font-weight:bold;">Assigned to You
   Created by You
   Agency Total
   New Communication
   UnResolved Incidences
   Update PowerPath to #powerpath_version#
   Who Should be Your Project Manager?
   Computer Setup & Troubleshooting
   What's Your Home Health Regulations IQ?