SELECT patient.Patient_ID, patient.Status, patient.Last_Name_M0040 AS PatientLast,
patient.First_Name_M0040 AS PatientFirst, Assessment_Forms.Assessment_Forms_ID, Assessment_Forms.Form_Type,
Assessment_Forms.Date_Sent, patient.Primary_ReferringPhys_ID_M0072, Assessment_Forms.Cert_Start_Item_3a,
Assessment_Forms.Cert_End_Item_3b, Assessment_Forms.Cert_Start_Item_3a, Assessment_Forms.Nurse_Digital_Signature,
Assessment_Forms.Record_Creation_Date,
Physician.Physician_ID, Employee.Last_Name
FROM #Request.prefix_db_agency#.patient, #Request.prefix_db_agency#.Assessment_Forms, #Request.prefix_db_lookup#.Physician,#Request.prefix_db_lookup#.Employee
WHERE patient.Patient_ID = Assessment_Forms.Patient_ID
AND Assessment_Forms.Record_Creation_Date != '0000-00-00'
AND Assessment_Forms.Date_Sent != '0000-00-00'
AND Assessment_Forms.Cert_Start_Item_3a != '0000-00-00'
AND Assessment_Forms.Cert_End_Item_3b != '0000-00-00'
AND patient.Agency_ID = #session.AgencyID#
AND Physician.Physician_ID = patient.Primary_ReferringPhys_ID_M0072
AND Employee.Employee_ID = Physician.Employee_ID
AND Assessment_Forms.Date_Sent IS NULL
AND Assessment_Forms.Form_Status NOT IN ('Signed','Delete')
ORDER BY patient.Last_Name_M0040, Assessment_Forms.Cert_End_Item_3b
New orders that need to be printed and sent
___________________________________________
Form 487
Form 485
#DateFormat(Cert_Start_Item_3a,"mm/dd/yyyy")# - #DateFormat(Cert_End_Item_3b,"mm/dd/yyyy")#
Print print in PowerPath
created #DateFormat(Record_Creation_Date,"mm/dd/yyyy")#
Digitally signed by Clinician