SELECT Assessment_New.Assessment_Tracker_ID, Assessment_New.Admission_Status AS Status, Assessment_New.Certification_Start AS CertStart, Assessment_New.Certification_End AS CertEnd, Assessment_New.Assessment_Reason_M0100 AS Reason, Assessment_New.SN_Visit_Orders AS SNFreq, Assessment_New.Transmission_Status AS TranStatus, Assessment_New.Therapy_Visit_Orders AS TherapyFreq, Assessment_New.HHA_Visit_Orders AS HHAFreq, patient.Last_Name_M0040 AS PatientLast, patient.Status AS PatStat, patient.Primary_ReferringPhys_ID_M0072 AS DOC, patient.First_Name_M0040 AS PatientFirst, ScheduleItems.ScheduleItems_ID, ScheduleItems.Visit_Date, ScheduleItems.Missed, ScheduleItems.Visit_Type AS Type, ScheduleItems.Progress_Note, Payer.Payer_ID, Payer.Output_Type FROM #Request.prefix_db_agency#.Assessment_New LEFT JOIN #Request.prefix_db_agency#.patient ON Assessment_New.Patient_ID = patient.Patient_ID LEFT JOIN #Request.prefix_db_agency#.ScheduleItems ON Assessment_New.Assessment_Tracker_ID = ScheduleItems.Assessment_Tracker_ID LEFT JOIN #Request.prefix_db_agency#.Payer ON ScheduleItems.Payer_ID = Payer.Payer_ID WHERE patient.Agency_ID = #session.AgencyID# AND ScheduleItems.Visit_Date <= NOW() AND Assessment_New.Therapy_Need_M0825 = '1 - Yes' AND ScheduleItems.Visit_Type LIKE '%Therapy%' AND ScheduleItems.EClaimed = 0 AND Assessment_New.Certification_Start <> '0000-00-00' AND Assessment_New.Certification_End <> '0000-00-00' ORDER BY patient.Last_Name_M0040, Assessment_New.Certification_Start ASC, ScheduleItems.Visit_Type ASC, ScheduleItems.Visit_Date ASC
Therapy Compliance

___________________________________________
#PatientLast#, #PatientFirst# (#PatStat#) - No Doctor #Reason# - Cert Period: #DateFormat(CertStart,"mm/dd/yyyy")# - #DateFormat(CertEnd,"mm/dd/yyyy")# #Reason# - cert period UK OASIS incomplete Not transmitted   No Doctor   MEDICARE CLAIM DUE   Orders
Therapy #TherapyFreq# Therapy Orders UK
    #DateFormat(Visit_Date,"mm/dd/yyyy")#, #Type#   Payer UK #Output_Type#    Note? Missed     Edit | Delete | Add Order | Add Comm
Note? Yes  -   Edit | Print | Delete
Note? No  -   >Edit | Delete

No records found.