SELECT patient.Last_Name_M0040, patient.First_Name_M0040, Employee.Last_Name,
ScheduleItems.Visit_Date, ScheduleItems.StartTime, ScheduleItems.EndTime, ScheduleItems.Total_Units, ScheduleItems.ScheduleItems_ID,
Assessment_New.Assessment_Reason_M0100, Payer.PayName
FROM #Request.prefix_db_agency#.ScheduleItems
INNER JOIN #Request.prefix_db_agency#.patient ON ScheduleItems.Patient_ID = patient.Patient_ID
INNER JOIN #Request.prefix_db_lookup#.Employee ON ScheduleItems.Employee_ID = Employee.Employee_ID
INNER JOIN #Request.prefix_db_agency#.Payer ON ScheduleItems.Payer_ID = Payer.Payer_ID
INNER JOIN #Request.prefix_db_agency#.Assessment_New ON ScheduleItems.Assessment_Tracker_ID = Assessment_New.Assessment_Tracker_ID
WHERE ScheduleItems.Agency_ID = #session.AgencyID#
AND ScheduleItems.Visit_Type IN ('Assessment','Admission Visit','Re-Certification Visit','1 - Start of Care - further visits planned','4 - Recertification (follow-up) reassessment')
AND Assessment_New.Transmission_Status = 'Dataset has been transmitted.'
And Assessment_New.Assessment_Reason_M0100 IN ('1 - Start of Care - further visits planned','4 - Recertification (follow-up) reassessment')
AND Payer.Output_Type = 'Medicare'
AND Assessment_New.Certification_Start <> '0000-00-00'
AND Assessment_New.Certification_End <> '0000-00-00'
AND ScheduleItems.Visit_Date <> '0000-00-00'
AND ScheduleItems.Deleted <> 1
AND ScheduleItems.Employee_ID <> 0
AND (ScheduleItems.EClaimed = 0)
ORDER BY patient.Last_Name_M0040, ScheduleItems.ScheduleItems_ID
Billing Administration
RAPs visits waiting to be billed
Un-check visits you don't want billed. Items in red need correction before exporting.