SELECT Assessment_New.Assessment_Tracker_ID, Assessment_New.Certification_Start AS CertStart, Assessment_New.Admission_Status AS Status, Assessment_New.Certification_End AS CertEnd, Assessment_New.Assessment_Reason_M0100 AS Reason, Assessment_New.Assessment_ID, Assessment_New.Assessment_Number, Assessment_New.SN_Visit_Orders AS SNFreq, Assessment_New.Transmission_Status AS TranStatus, patient.Patient_ID, Assessment_New.Therapy_Visit_Orders AS TherapyFreq, Assessment_New.HHA_Visit_Orders AS HHAFreq, patient.Patient_ID, patient.Last_Name_M0040 AS PatientLast, patient.Payer_ID, patient.Primary_ReferringPhys_ID_M0072 AS DOC, patient.First_Name_M0040 AS PatientFirst, patient.Status AS PatStat, ScheduleItems.ScheduleItems_ID, ScheduleItems.Visit_Date, ScheduleItems.Missed,ScheduleItems.Patient_ID, ScheduleItems.Visit_Type AS Type, ScheduleItems.Total_Units, ScheduleItems.Progress_Note, ScheduleItems.Output_Type AS Output, ScheduleItems.Employee_ID, Payer.Payer_ID, Payer.Output_Type, Payer.PayName FROM #Request.prefix_db_agency#.Assessment_New, #Request.prefix_db_agency#.patient, #Request.prefix_db_agency#.ScheduleItems, #Request.prefix_db_agency#.Payer WHERE ScheduleItems.Agency_ID = #session.AgencyID# AND ScheduleItems.Patient_ID = patient.Patient_ID AND patient.Payer_ID = Payer.Payer_ID AND patient.Status <>'deleted' AND ScheduleItems.Assessment_Tracker_ID = Assessment_New.Assessment_Tracker_ID AND ScheduleItems.Visit_Date <> '0000-00-00' AND Assessment_New.Certification_Start <> '0000-00-00' AND Assessment_New.Certification_End <> '0000-00-00' AND ScheduleItems.Visit_Date <= NOW() AND ScheduleItems.EClaimed = 0 AND ScheduleItems.Deleted <> 1 AND (Assessment_New.Deleted IS Null OR Assessment_New.Deleted = '0') AND (Assessment_New.Archive IS Null OR Assessment_New.Archive = '0') AND patient.Last_Name_M0040 LIKE '#URL.Alpha#%' Order by PatientLast, PatientFirst, CertEnd, Reason, Visit_Type, Visit_Date
Visit Compliance

The following is a list of all visits scheduled on the calendar. Items in red must be fixed to bill.

unscheduled SOC/ROC   unscheduled episodes

___________________________________________
#PatientLast#, #PatientFirst#  (#PatStat#)  #PayName#   Doctor Unknown   RAP READY TO BILL   FINAL CLAIM READY TO BILL
#Reason#  (if Medicare, visits need to be re-assigned to SOC/ROC)
#Reason#  #DateFormat(CertStart,"mm/dd/yyyy")# - #DateFormat(CertEnd,"mm/dd/yyyy")#cert period UK OASIS incomplete Not transmitted
SN #SNFreq#SN Orders UK Therapy #TherapyFreq#Therapy Orders UK HHA #HHAFreq#HHA Orders UK  Orders Add Visit

     #DateFormat(Visit_Date,"mm/dd/yyyy")#   No Visit Type  #Type#   Payer UK   RAP   Medicare Final   UB92-1450   UB82-1500   Unassigned   0 Units   Missed Visit  Delete | Add Order | Add Comm
  Print | Delete
  No Note!  Delete

No records found.