SELECT Assessment_New.Assessment_ID, Assessment_New.Record_creation_Date, Assessment_New.Assessment_tracker_ID, Assessment_New.Patient_ID, Assessment_New.admission_status, Assessment_New.Assessment_Reason_M0100, patient.Last_Name_M0040, patient.First_Name_M0040, Assessment_new.Start_of_Care_M0030, assessment_new.Assessment_Completed_M0090, assessment_new.Transmission_status From #Request.prefix_db_agency#.Assessment_New, #Request.prefix_db_agency#.patient Where Assessment_New.HHAC_Agency_ID = '#Session.AgencyLogin#' AND Assessment_New.Patient_ID = patient.Patient_ID AND Assessment_New.transmission_status = 'ready to transmit' AND Assessment_Completed_M0090 != '' AND Assessment_new.Patient_ID IN (#form.patient_ID#) AND Assessment_New.Deleted = 0 Order by Assessment_New.Assessment_Completed_M0090 Desc 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

Agency Administration - Assessment List

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.
Search For:
Select PatientRecordLock_ID From #Request.prefix_db_agency#.PatientRecordLock Where Patient_ID = #patient_ID# AND agency_ID = #session.agencyID# AND UnlockedBy_ID = 0 class="trhighlight" class="trnormal" >

Patient Name

M0030 Start_of_Care

M0100 Assessment_Reason

M0090 Assessment Completed

Assessment Status

Transmission Status

Download
#Last_Name_M0040#, #First_Name_M0040# #DateFormat(Start_of_Care_M0030, "mmm dd, yyyy")# #Assessment_Reason_M0100# #DateFormat(Assessment_Completed_M0090, "mmm dd, yyyy")# #admission_status# #Transmission_status# Patient Locked Archive Delete
There are currently no Assessment records.