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,
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 ScheduleItems.Assessment_Tracker_ID = Assessment_New.Assessment_Tracker_ID
AND ScheduleItems.Visit_Date <= NOW()
AND ScheduleItems.EClaimed = 0
AND ScheduleItems.Deleted <> 1
AND ScheduleItems.Progress_Note = 'No'
AND (Assessment_New.Deleted IS Null OR Assessment_New.Deleted = '0')
AND (Assessment_New.Archive IS Null OR Assessment_New.Archive = '0')
Order by PatientLast, 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
RAPs Medicare Final UB92-1450 UB82-1500
___________________________________________
#PatientLast#, #PatientFirst# (#PatStat#) #PayName#
Doctor Unknown
RAP READY TO BILL
FINAL CLAIM READY TO BILL
#Reason# (change to skilled visit for related 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")#,
#Type#
Payer UK
RAP
Medicare Final
UB92-1450
UB82-1500
Note? Missed
Edit | Delete | Add Order | Add Comm
Note? Yes -
Edit | Print | Delete
Note? No -
Edit | Delete
No records found.