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.Progress_Note, ScheduleItems.Output_Type AS Output, ScheduleItems.Employee_ID, Payer.Payer_ID, Payer.Output_Type, Payer.PayName,Payer.notes 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 = 'active' 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.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

Notes : #Visits.notes#

 ___________________________________________
#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   Missed Visit  Delete | Add Order | Add Comm
  Print | Delete
  No Note  Delete

No records found.