SELECT Pt_Agy_ID, Pt_First, Pt_Last, Pt_Street, Pt_City, Pt_State, Pt_Phone, Pt_Zip, Pt_DOB, Pt_Gender FROM #Request.prefix_db_agency#.pPatients WHERE Patient_ID = AND Status < 2 SELECT Status, Admit_Type, M0104_PHYSN_RFRL_DT, Refer_Phys_ID, M0102_PHYSN_ORDRD_SOCROC_DT, COALESCE(M0102_PHYSN_ORDRD_SOCROC_DT_NA, 0) AS M0102_PHYSN_ORDRD_SOCROC_DT_NA, Render_Phys_ID, M0030_START_CARE_DT, Clinical_Manager, Case_Manager FROM #Request.prefix_db_agency#.pAdmit WHERE Admit_ID = AND Patient_ID = AND Status IN (0)