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.Certification_Start, Assessment_New.Certification_End, 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_Completed_M0090 != '' AND Assessment_New.Patient_ID IN (#form.Patient_ID#) AND Assessment_New.Assessment_Completed_M0090 BETWEEN DATE_ADD(NOW(), INTERVAL -150 DAY) AND DATE_ADD(NOW(), INTERVAL -60 DAY) AND Assessment_New.Assessment_Completed_M0090 < DATE_ADD(NOW(), INTERVAL -60 DAY) AND Assessment_New.Assessment_Completed_M0090 BETWEEN DATE_ADD(NOW(), INTERVAL -150 DAY) AND DATE_ADD(NOW(), INTERVAL -60 DAY) 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 - Assessments older than 60 days

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.

Filter For:
View all assessments older than 60 days for selected patients.
This option will not work if "All Patients" is selected.

Select PatientRecordLock_ID From #Request.prefix_db_agency#.PatientRecordLock Where Patient_ID = #patient_ID# AND agency_ID = #session.agencyID# AND UnlockedBy_ID = 0

Assessments between 60 and 150 days old

Assessments older than 60 days
Patient Name M0100 Assessment Reason Cert. Start Cert. End Assessment Status Transmission Status DL?
#Last_Name_M0040#, #First_Name_M0040# #Assessment_Reason_M0100# #DateFormat(Certification_Start, "mm/dd/yy")# #DateFormat(Certification_End, "mm/dd/yy")# #admission_status# #Transmission_status# Patient Locked Archive Delete
 
There are currently no Assessment records.