Select * , 0 as Pay_ID FROM #Request.prefix_db_agency#.pAssessments WHERE Assmt_ID = '#AssId#' SELECT Pay_Name FROM #Request.prefix_db_agency#.pPayer WHERE Pay_ID = '#AssDetails.Pay_ID#' SELECT pPatients.* FROM #Request.prefix_db_agency#.pPatients WHERE Patient_ID = AND Status NOT IN (2,3) SELECT *, pAdmit.admit_type FROM #Request.prefix_db_agency#.pAdmit JOIN #Request.prefix_db_lookup#.pPhysicians ON pPhysicians.Phys_ID = pAdmit.Render_Phys_ID WHERE pAdmit.Patient_ID = AND pAdmit.Status = 0 ORDER BY pAdmit.M0030_START_CARE_DT DESC SELECT admit_type FROM #Request.prefix_db_agency#.pAdmit WHERE Patient_ID = AND Status = 0 ORDER BY M0030_START_CARE_DT DESC LIMIT 1

#GetP.Pt_First# #GetP.Pt_Last# [#GetP.Pt_Agy_ID#]

GetPhysician.Phys_verified EQ 0>

omitted from PECOS

General General Contacts Contacts Payers Payers Meds Meds Uploads Uploads Careplans Careplans Careplans Schedules Schedules Communications Communications Incidences Incidences VBP Risk Analysis VBP Risk Analysis Orphan Symptoms Orphan Symptoms Med Reconciliation Med Reconciliation Run outcomes Run outcomes Careplan Review Careplan Review Goals Review Goals Review Version Version Account Billing Account Billing