UPDATE #Request.prefix_db_lookup#.system_news_views SET stop = 'Y' WHERE system_news_id = '#url.snd#' AND employee_id = '#session.EmployeeId#' SELECT sn.* ,(SELECT viewed FROM #Request.prefix_db_lookup#.system_news_views WHERE system_news_id = sn.id AND employee_id = '#session.EmployeeId#') AS viewed ,(SELECT stop FROM #Request.prefix_db_lookup#.system_news_views WHERE system_news_id = sn.id AND employee_id = '#session.EmployeeId#') AS stop FROM #Request.prefix_db_lookup#.system_news sn WHERE sn.active = 'Y' AND (sn.dateStart <= SUBSTR(Now(),1,10) OR sn.dateStart = '' OR sn.dateStart IS NULL) AND (sn.dateEnd >= SUBSTR(Now(),1,10) OR sn.dateEnd = '' OR sn.dateEnd IS NULL) AND (sn.title LIKE '%#url.news#%' OR sn.message LIKE '%#url.news#%') ORDER BY sn.created DESC, sn.id DESC SELECT COUNT(Incident_ID) AS Count FROM #Request.prefix_db_lookup#.Incident WHERE Agency_ID = #session.AgencyID# AND Employee = '#session.Display#' AND DateCompleted is not null AND Deleted = 0 SELECT COUNT(Homework_ID) AS Count FROM #Request.prefix_db_agency#.Homework WHERE Agency_ID = '#session.AgencyID#' AND Username = '#session.Username#' AND Deleted <> 1 SELECT telephony FROM #Request.prefix_db_lookup#.Agency WHERE Agency_ID = '#session.AgencyID#' SELECT COUNT(Agency_ID) AS Count FROM #Request.prefix_db_lookup#.Agency WHERE Agency_ID = '#session.AgencyID#' AND (Agency_Medicare_ID = '' or Agency_State_ID = '' or Natl_Provider_ID = '' or Agent_FEIN = '' or Agency_Branch_ID = '') SELECT COUNT(PatientRecordLock_ID) AS Count FROM #Request.prefix_db_agency#.PatientRecordLock WHERE Agency_ID = #session.AgencyID# AND LockedBy_ID = #Session.EmployeeID# AND Version_PP = 2 SELECT count(*) c FROM #Request.prefix_db_agency#.Communication ,#Request.prefix_db_agency#.communication_to ct WHERE Communication.Agency_ID = '#session.AgencyID#' AND Communication.Resolved = 'No' AND ct.comm_id = Communication.Comm_ID AND ct.employee_id = '#session.EmployeeId#' SELECT count(*) c FROM #Request.prefix_db_agency#.Communication WHERE Communication.Agency_ID = '#session.AgencyID#' AND Communication.Record_Created_By = '#session.EmployeeId#' AND Communication.Resolved = 'No' SELECT count(*) c FROM #Request.prefix_db_agency#.Communication,#Request.prefix_db_lookup#.Employee, #Request.prefix_db_agency#.patient, #Request.prefix_db_agency#.CommunicationSubjects WHERE Communication.Agency_ID = '#session.AgencyID#' AND Communication.Resolved = 'No' AND Employee.Employee_ID = Communication.Employee_ID AND patient.Patient_ID = Communication.Patient_ID AND CommunicationSubjects.CommSub_ID = Communication.CommSub_ID
Dashboard
System News... » manage   » search the archive
Archive Search Results...
No new system news at this time No system news matching your Search was found in the Archive
#DateFormat(getSystemNews.created, 'mmm dd, yyyy')# - #getSystemNews.title#
Unresolved Issues: #GetComm1.c# Assigned to You    » New Communication
#GetComm2.c# Created by You
#GetComm3.c# for your Agency
there is a response to your recent problem
#powerpath_version# ). Update Now. Update PowerPath ( latest release #powerpath_version# )--->Update PowerPath ( latest release #powerpath_version# )
Current Time & Attendance
Site Map/Authority Levels Site Map Site Map
there is a response to your recent homework
Agency Information is incomplete
 
Chart Compliance
Patients needing Face to Face Physician encounters   «  New
Patients without a Case Manager
Patients without a current assessment
Incomplete Assessments
Patients without a current HCFA485
Assessments that need to be reviewed
New orders not printed
Orders sent to physician but not received
Missing Progress Notes (by Patient)
Missing Progress Notes (by Caregiver)
 
Scheduling Compliance
Assessments due to expire within 14 days
Medicare SOC and Re-Certifications not scheduled
All Payers: episodes not scheduled
Scheduled visits not assigned
 
Billing Compliance
Datasets ready to transmit
Visits Ready to Bill
 
Employee Compliance
Employees with Missing Information