SELECT af.Discharge_Plan,a.Agency_Name ,p.Phys_First, p.Phys_Last, p.Phys_Email ,Pt_First, Pt_Last FROM #Request.prefix_db_agency#.pCMS4857 af, #Request.prefix_db_lookup#.pPhysicians p, #Request.prefix_db_lookup#.Agency a WHERE af.Order_ID = '#assessmentFormsId#' AND af.Render_Phys_ID = '#docId#' AND p.Phys_ID = af.Render_Phys_ID AND p.status = '0' AND a.agency_id = p.Loc_ID

Dr. #getDoc.Phys_First# #getDoc.Phys_Last#,

A New Patient Order is awaiting your Approval at MyHomeCareBiz.com...

Please click here to Sign In and then View and Approve your Patient Orders.

ORDER DETAILS...

Home Health Care Agency Name: #getDoc.Agency_Name#

Patient Name: #getDoc.Pt_First# #getDoc.Pt_Last#

Order Info: #getDoc.Discharge_Plan#


This is an automated system notification from MyHomeCareBiz.com. Therefore, there is no Unsubscribe option.