SELECT DISTINCT P.PayName,P.Payer_ID FROM #Request.prefix_db_agency#.Payer P left outer join #Request.prefix_db_agency#.Assessment_New AN on P.Agency_ID = AN.Agency_ID WHERE AN.Agency_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_520 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') and ROC_420 in ('0','1','2','3','4','5','6','7','8','9') and ROC_490 in ('0','1','2','3','4','5','6','7','8','9') and ROC_520 in ('0','1','2','3','4','5','6','7','8','9') and ROC_680 in ('0','1','2','3','4','5','6','7','8','9') and ROC_690 in ('0','1','2','3','4','5','6','7','8','9') and ROC_700 in ('0','1','2','3','4','5','6','7','8','9') and ROC_780 in ('0','1','2','3','4','5','6','7','8','9') ORDER BY P.PayName Asc SELECT DISTINCT P.PayName,P.Payer_ID FROM #Request.prefix_db_agency#.Payer P, #Request.prefix_db_agency#.Assessment_New AN, #Request.prefix_db_lookup#.Agency AG WHERE P.Agency_ID = AG.Agency_ID and AN.Agency_Id = AG.Agency_ID and ( Start_of_Care_M0030 >= and Resump_of_Care_M0032 <= ) 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_520 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') and ROC_420 in ('0','1','2','3','4','5','6','7','8','9') and ROC_490 in ('0','1','2','3','4','5','6','7','8','9') and ROC_520 in ('0','1','2','3','4','5','6','7','8','9') and ROC_680 in ('0','1','2','3','4','5','6','7','8','9') and ROC_690 in ('0','1','2','3','4','5','6','7','8','9') and ROC_700 in ('0','1','2','3','4','5','6','7','8','9') and ROC_780 in ('0','1','2','3','4','5','6','7','8','9') ORDER BY P.PayName Asc 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
to
Date Format: mm/dd/yyyy

Outcome Report - Step 2



Select a Payer From The List Below To See Chart
Start of Care Date: #form.from_Date#
Discharge Date: #form.to_date#
Payer View Graph
#payName# #PayName#

Add an Order - Step 3



Patient: #Session.Patient.Last#, #Session.Patient.First# #Session.Patient.Middle#
Orders:
Bold fields are required.

Return to Unsigned Orders.

Order Added Successfully

Click here to return to alphabetical Patient Listing.