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 as LastName, Employee.First_Name as FirstName,
Assessment_Forms.contact_id,pc.ContactName,pc.ContactType,pc.ContactStreet,pc.ContactCity,pc.ContactState,pc.ContactZip,
Assessment_Forms.physician_id,pc.Telephone1 as ContactTelephone1,pc.Telephone2 as ContactTelephone2
FROM #Request.prefix_db_agency#.Assessment_Forms
LEFT OUTER JOIN #Request.prefix_db_agency#.patient on Assessment_Forms.Patient_ID = patient.Patient_ID
LEFT OUTER JOIN #Request.prefix_db_lookup#.Agency on patient.Agency_ID = Agency.Agency_ID
LEFT OUTER JOIN #Request.prefix_db_lookup#.Physician on patient.Primary_ReferringPhys_ID_M0072 = Physician.Physician_ID
LEFT OUTER JOIN #Request.prefix_db_lookup#.Employee on Physician.Employee_ID = Employee.Employee_ID
LEFT OUTER JOIN #Request.prefix_db_agency#.PatientContact pc on Assessment_Forms.Contact_ID = pc.Patientcontact_ID
WHERE patient.Agency_ID = #session.AgencyID#
AND (Assessment_Forms.Form_Status = 'Not Signed' or Assessment_Forms.Form_Status = 'Un-Signed')
ORDER BY patient.Last_Name_M0040, Assessment_Forms.Cert_End_Item_3b
Un-Signed Orders by Patient
New Order
by Date Sent
by Physician
|
___________________________________________
#PatientLast#, #PatientFirst# - (#status#) #LastName#
#Form_Type# #Form_Type# #DateFormat(Cert_Start_Item_3a,"mm/dd/yyyy")# - #DateFormat(Cert_End_Item_3b,"mm/dd/yyyy")#
View
View
Print Print
mailed #DateFormat(Date_Sent,"mm/dd/yyyy")#
new #DateFormat(Record_Creation_Date,"mm/dd/yyyy")#
Digitally signed by Clinician