SELECT pSchedules.Schedule_ID ,pSchedules.Visit_Date, pPayer.Output AS Output_Type, pSchedules.Skill AS Visit_Type ,pPayer.Pay_Name ,pPatients.Pt_Last AS PatientLast, pPatients.Pt_First AS PatientFirst ,pSchedules.Assmt_ID, pAssessments.F26 AS Assessment_Reason_M0100, pAssessments.F176 AS Assessment_Completed_M0090, pAssessments.F178 Certification_End FROM #Request.prefix_db_agency#.pSchedules JOIN #Request.prefix_db_agency#.pAssessments ON pSchedules.Assmt_ID = pAssessments.Assmt_ID JOIN #Request.prefix_db_agency#.pPatients ON pAssessments.Patient_ID = pPatients.Patient_ID JOIN #Request.prefix_db_agency#.pPtPayer ON pSchedules.PtPayer_ID = pPtPayer.PtPayer_ID JOIN #Request.prefix_db_agency#.pPayer ON pPtPayer.Payer_ID = pPayer.Pay_ID WHERE pSchedules.EClaimed = 0 AND pSchedules.Nonbillable = 1 AND pSchedules.status = 0 AND pAssessments.status = 0 AND pPatients.status < 2 GROUP BY pSchedules.Schedule_ID ORDER BY pSchedules.Visit_Date DESC, PatientLast ASC
Visits Marked as 'Do Not Bill'
Name Assessment Visit Type Visit Date Payer Name Output Type Action
#PatientLast#, #PatientFirst# #Trim(Assessment_Reason_M0100)# #Visit_Type# #dateformat(Visit_Date,"mm/dd/yyyy")# #Trim(Pay_Name)# #Trim(Output_Type)# Un-Flag