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.Assessment_Completed_M0090, Assessment_New.Transmission_status 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.HHAC_Agency_ID = '#Session.AgencyLogin#' AND Assessment_Completed_M0090 != '' AND Assessment_New.Deleted = 0 AND Assessment_New.Certification_End BETWEEN NOW() AND DATE_ADD(NOW(), INTERVAL 14 DAY) AND (Assessment_New.Assessment_Reason_M0100 LIKE '1%' OR Assessment_New.Assessment_Reason_M0100 LIKE '4%' OR Assessment_New.Assessment_Reason_M0100 LIKE '3%') ORDER BY 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

Expired Assessments

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.
Assessments by Case Manager

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" >

Name

Assessment Reason

Completed?

Cert Start

Admission Status

Transmission Status
Down
load?
  
#Last_Name_M0040#, #First_Name_M0040#
#Assessment_Reason_M0100#
#DateFormat(Assessment_Completed_M0090, "mm/dd/yy")#
#DateFormat(Certification_Start, "mm/dd/yy")#
#admission_status#
#Transmission_status#
 Signed out Delete
There are currently no Assessment records.