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
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 patient.Agency_ID = #session.AgencyID#
AND Physician.Physician_ID = patient.Primary_ReferringPhys_ID_M0072
AND Assessment_Forms.Form_Status NOT IN ('Signed','Delete')
AND Employee.Employee_ID = Physician.Employee_ID
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