SELECT Assessment_Forms.Addendum_Details_21, Assessment_Forms.Digital_Signature,
Assessment_Forms.Date_Received_Item_25, Assessment_Forms.Record_Mod_Date, Assessment_Forms.Form_Status,
Assessment_Forms.Date_Sent, patient.Last_Name_M0040, patient.First_Name_M0040,patient.Patient_ID
FROM #Request.prefix_db_agency#.Assessment_Forms, #Request.prefix_db_agency#.patient
WHERE Assessment_Forms.Assessment_Forms_ID = #url.afID#
AND Assessment_Forms.Record_Mod_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.Patient_ID = Assessment_Forms.Patient_ID
SELECT Assessment_Forms.Addendum_Details_21, Assessment_Forms.Digital_Signature,
Assessment_Forms.Date_Received_Item_25, Assessment_Forms.Record_Mod_Date, Assessment_Forms.Form_Status,
Assessment_Forms.Date_Sent, patient.Last_Name_M0040, patient.First_Name_M0040,patient.Patient_ID,
Assessment_Forms.contact_id,pc.ContactName,pc.ContactType,Assessment_Forms.physician_id
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_agency#.PatientContact pc on Assessment_Forms.Contact_ID = pc.Patientcontact_ID
WHERE Assessment_Forms.Assessment_Forms_ID = #url.AFID#
Select * from #Request.prefix_db_agency#.PatientContact where patient_id = '#getV.Patient_ID#' and contactstatus=0
order by contactname
Select Last_Name, First_Name, p.Physician_id
from #Request.prefix_db_lookup#.Physician p
left outer join #Request.prefix_db_lookup#.Employee e on p.employee_id = e.employee_id
where p.agency_id = #session.agencyid# and e.status='active'
order by Last_Name,First_Name
Update #getV.First_Name_M0040# #getV.Last_Name_M0040# Order