SELECT Assessment_New.Assessment_ID, Assessment_New.Assessment_tracker_ID, Assessment_New.Patient_ID,
Assessment_New.admission_status, Assessment_New.Assessment_Reason_M0100, patient.Last_Name_M0040, patient.Current_Payment_Sources_M0150,
patient.First_Name_M0040, Assessment_New.Certification_Start, Assessment_New.Certification_End, Assessment_New.Transmission_Status,
Assessment_New.Waiting_For_Eval
FROM #Request.prefix_db_agency#.Assessment_New
LEFT JOIN #Request.prefix_db_agency#.patient ON Assessment_New.Patient_ID = patient.Patient_ID
WHERE Assessment_New.Agency_Number = '#Session.AgencyID#'
AND Assessment_New.Patient_ID IN (#form.Patient_ID#)
AND Assessment_New.Deleted = 0
AND Assessment_New.Transmission_status = 'Ready to Lock'
ORDER BY patient.Current_Payment_Sources_M0150 ASC, Assessment_New.Certification_End ASC
SELECT Patient_ID, First_Name_m0040, Last_Name_m0040, Middle_Initial_M0040
From #Request.prefix_db_agency#.patient
Where Agency_ID = #session.AgencyID#
AND status = 'active'
Order By Last_Name_m0040
Select PatientRecordLock_ID
From #Request.prefix_db_agency#.PatientRecordLock
Where Patient_ID = #patient_ID#
AND agency_ID = #session.agencyID#
AND UnlockedBy_ID = 0
Agency Administration - Assessments Ready for Review
Select the patient to search. Ctrl-Click to select multiple patients. Then check off the assessments you want to download.
Important: You can download multiple assessments BUT ONLY
one (1) assessment per patient.
There are currently no Assessment records.