SELECT patient.Agency_ID AS Agency, patient.Patient_ID, patient.Status, patient.Last_Name_M0040 AS PatientLast, patient.First_Name_M0040 AS PatientFirst,
Assessment_Forms.Assessment_Tracker_ID, Assessment_New.Assessment_Tracker_ID, Assessment_Forms.Assessment_Forms_ID, Assessment_Forms.Form_Type,
Assessment_Forms.Form_Status, Assessment_Forms.Cert_Start_Item_3a, Assessment_Forms.Cert_End_Item_3b
FROM #Request.prefix_db_agency#.patient, #Request.prefix_db_agency#.Assessment_Forms, #Request.prefix_db_agency#.Assessment_New
WHERE patient.Patient_ID = Assessment_New.Patient_ID
AND Assessment_New.Assessment_Tracker_ID = Assessment_Forms.Assessment_Tracker_ID
AND Assessment_New.Assessment_Tracker_ID = #url.ID#
AND Assessment_Forms.Form_Status <> 'Delete'
Un-Signed HCFA485s and 487s for #PatientLast#, #PatientFirst#
Form Type, Cert Start-End
#Form_Type##Form_Type# #DateFormat(Cert_Start_Item_3a,"mm/dd/yyyy")# - #DateFormat(Cert_End_Item_3b,"mm/dd/yyyy")# - #Form_Status##Form_Status#
Print | EditView
There are no orders to display.