SELECT Patient_ID, First_Name_M0040, Last_Name_M0040, Middle_Initial_M0040 FROM #Request.prefix_db_agency#.patient WHERE Agency_ID = AND patient.Status = 'active' ORDER BY Last_Name_M0040 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.First_Name_M0040, Assessment_New.Certification_Start, Assessment_New.Certification_End, 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_Completed_M0090 != '' AND Assessment_Completed_M0090>= DATE_ADD(NOW(), INTERVAL -#Form.DateRange# DAY) AND Assessment_New.Patient_ID IN (#Form.Patient_ID#) AND Assessment_New.Deleted = 0 GROUP BY Assessment_Tracker_ID ORDER BY patient.Last_Name_M0040, Assessment_New.Assessment_Completed_M0090 Desc SELECT Patient_ID, Assessment_Reason_M0100 FROM #Request.prefix_db_agency#.Assessment_New WHERE Assessment_Tracker_ID = #temptracker# LIMIT 1 INSERT INTO #Request.prefix_db_agency#.PatientRecordLock ( Patient_ID, Agency_ID, LockDate, LockedBy_ID, DL_Type, Assessment_Tracker_ID, Assessment_Reason ) VALUES ( #getp.Patient_ID#, #session.AgencyID#, #CreateODBCDateTime(Now())#, #Session.EmployeeID#, 1, '#temptracker#', '#getp.Assessment_Reason_M0100#') SELECT PatientRecordLock_ID FROM #Request.prefix_db_agency#.PatientRecordLock WHERE Patient_ID = #getp.Patient_ID# AND Agency_ID = #session.AgencyID# AND LockedBy_ID = #Session.EmployeeID# AND UnLockedBy_ID = 0
Download Assessments

Select the patient(s) to filter. 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 By:
Assessments Completed Within:
Bold fields are required.

Assessments by Case Manager
SELECT PatientRecordLock_ID FROM #Request.prefix_db_agency#.PatientRecordLock WHERE Patient_ID = #Patient_ID# AND UnlockedBy_ID = 0
Patient M0100 Assessment Reason Delete? Cert. Start Cert. End Assessment Status Transmission Status Download?
#Last_Name_M0040#, #First_Name_M0040# #Assessment_Reason_M0100# Delete Signed Out #DateFormat(Certification_Start, "mm/dd/yy")# #DateFormat(Certification_End, "mm/dd/yy")# #Admission_Status# #Transmission_Status#

There are currently no Assessment records.

Your selections have been marked for download.

You must select at least one assessment to download.

Please click the Back button in your browser to correct the problem.