SELECT patient.Patient_ID, Assessment_New.Assessment_Reason_M0100, Assessment_New.Start_of_Care_M0030, Assessment_New.Transmission_Status, Assessment_New.Assessment_Completed_M0090, Assessment_New.Certification_End, Assessment_New.Transmission_Status, patient.Last_Name_M0040 AS PatientLast, patient.First_Name_M0040 AS PatientFirst, Payer.PayName FROM #Request.prefix_db_agency#.Assessment_New, #Request.prefix_db_agency#.patient, #Request.prefix_db_agency#.Payer WHERE patient.Patient_ID = Assessment_New.Patient_ID AND patient.Agency_ID = #session.AgencyID# AND patient.Status = 'active' AND Assessment_New.deleted <> 1 AND Assessment_New.Payer_ID = Payer.Payer_ID AND Payer.UniqueAuth = 1 AND Assessment_New.UniqueAuth is null AND Assessment_New.Certification_Start <> '0000-00-00' AND Assessment_New.Certification_End <> '0000-00-00' ORDER BY patient.Last_Name_M0040 ASC, patient.First_Name_M0040 ASC, Assessment_New.Assessment_Completed_M0090 DESC

Missing Prior Authorization Numbers

Date Expires, Assessment Type, Transmission Status
___________________________________________
#PatientLast#, #PatientFirst# #PayName#
#DateFormat(Assessment_Completed_M0090,"mm/dd/yyyy")#, #Assessment_Reason_M0100#, #Transmission_Status##Transmission_Status#