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,
Assessment_Forms.Cert_Start_Item_3a, Assessment_Forms.Cert_End_Item_3b, Assessment_Forms.Record_Mod_Date,
Physician.Physician_ID,
Employee.Last_Name as LastName, Employee.First_Name as FirstName,
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 Physician.Physician_ID = patient.Primary_ReferringPhys_ID_M0072
AND patient.Agency_ID = #session.AgencyID#
AND Assessment_Forms.Form_Status NOT IN ('Signed','Delete')
AND Employee.Employee_ID = Physician.Employee_ID
ORDER BY Employee.LastName ASC, Employee.FirstName, patient.Last_Name_M0040 ASC, Assessment_Forms.Date_Sent
Un-Signed Orders by Physician
New Order
by Date Sent
by Patient
|
___________________________________________
#LastName#, #FirstName#
#PatientLast#, #PatientFirst# #Form_Type##Form_Type# #DateFormat(Cert_Start_Item_3a,"mm/dd/yy")#
- #DateFormat(Cert_End_Item_3b,"mm/dd/yy")# PrintPrint
mailed #DateFormat(Date_Sent,"mm/dd/yyyy")#