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
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<>'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 Assessment_New.Assessment_Tracker_ID = #url.ATID#
AND (Assessment_New.Assessment_Reason_M0100 like '1%' or Assessment_New.Assessment_Reason_M0100 like '4%')
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.
___________________________________________
#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.