SELECT distinct P.Patient_ID, P.First_Name_M0040, P.Last_Name_M0040, P.Middle_Initial_M0040 FROM #Request.prefix_db_agency#.patient P LEFT OUTER JOIN #Request.prefix_db_agency#.Assessment_New a on P.Patient_Id = a.Patient_Id WHERE P.Agency_ID = #Session.AgencyID# and SOC_420 in ('0','1','2','3','4','5','6','7','8','9') and SOC_490 in ('0','1','2','3','4','5','6','7','8','9') and SOC_680 in ('0','1','2','3','4','5','6','7','8','9') and SOC_690 in ('0','1','2','3','4','5','6','7','8','9') and SOC_700 in ('0','1','2','3','4','5','6','7','8','9') and SOC_780 in ('0','1','2','3','4','5','6','7','8','9') ORDER BY P.Last_Name_M0040 SELECT Patient_ID, Last_Name_M0040, First_Name_M0040, Middle_Initial_M0040 FROM #Request.prefix_db_agency#.patient WHERE Patient_ID = #Form.Patient_ID# SELECT Assessment_ID, Assessment_Number, Start_of_Care_M0030, Admission_Status, Assessment_Reason_M0100, Assessment_Completed_M0090, Assessment_Tracker_ID, Certification_Start, Certification_End FROM #Request.prefix_db_agency#.Assessment_New WHERE Patient_ID = #Form.Patient_ID# and SOC_420 in ('0','1','2','3','4','5','6','7','8','9') and SOC_490 in ('0','1','2','3','4','5','6','7','8','9') and SOC_680 in ('0','1','2','3','4','5','6','7','8','9') and SOC_690 in ('0','1','2','3','4','5','6','7','8','9') and SOC_700 in ('0','1','2','3','4','5','6','7','8','9') and SOC_780 in ('0','1','2','3','4','5','6','7','8','9') ORDER BY Assessment_Completed_M0090 Desc SELECT Assessment_ID, Assessment_Number, Start_of_Care_M0030, Admission_Status, Assessment_Reason_M0100, Assessment_Completed_M0090, Assessment_Tracker_ID, Certification_Start, Certification_End FROM #Request.prefix_db_agency#.Assessment_New WHERE Assessment_Tracker_ID = #URL.ATID# ORDER BY Assessment_Completed_M0090 Desc INSERT INTO #Request.prefix_db_agency#.Assessment_Forms (Patient_ID, Agency_ID, Form_Type, Form_Status, Name_Item_6, Record_Creation_Date, Record_Mod_Date, Cert_Start_Item_3a, Cert_End_Item_3b, Assessment_Tracker_ID, Record_Num, SOC_Item_2, Addendum_Details_21, Record_Modified_By ) VALUES (#Form.Patient_ID#, '#Session.AgencyLogin#', 'Form 487', 'Not Signed', '#Session.Patient.First#' ' ' '#Session.Patient.Last#', #now()#, #now()#, #CreateODBCDate(Session.Cert.Certification_Start)#, #CreateODBCDate(Session.Cert.Certification_End)#, #Form.Assessment_Tracker_ID#, '12345', #CreateODBCDate(Session.Cert.Start_of_Care_M0030)#, '#Form.Addendum_Details_21#', #Session.EmployeeID#)
Outcome Report - Step 1

Select a Patient from the list below.

Select
Outcome Report - Step 2

#Last_Name_M0040#, #First_Name_M0040# #Middle_Initial_M0040#

Select an Assessment from the list below.

Start of Care Cert Start Cert End Assessment Type (Click To View Graph)
#DateFormat(Start_of_Care_M0030,"mm/dd/yyyy")# #DateFormat(Certification_Start,"mm/dd/yyyy")# #DateFormat(Certification_End,"mm/dd/yyyy")# #Assessment_Reason_M0100#
Add an Order - Step 3
Patient:
#Session.Patient.Last#, #Session.Patient.First# #Session.Patient.Middle#
Orders:
Submit

Return to Unsigned Orders.
Order Added Successfully
Click here to return to alphabetical Patient Listing.