Purchase Requests Query - Requested by

Purchase Requests Query - Requested by

In Asset Explorer, my query is showing Requested By as a number.  What am I missing?    

SELECT pr.requestid "PR ID", (poaddfield.UDF_CHAR1) AS "ITSR", pr.Subject "Subject", pr.requestedby AS "Requested By", (poaddfield.UDF_CHAR3) AS "Funds", Quantity * Estimated_cost "Total" FROM purchaserequest pr LEFT JOIN SDOrganization aaov ON pr.SITEID = aaov.ORG_ID LEFT JOIN SDUser crd ON pr.Createdby = crd.USERID LEFT JOIN SDUser sdu ON pr.Requestedby=sdu.USERID LEFT JOIN AaaUser cri ON crd.USERID = cri.USER_ID LEFT JOIN SDUser td ON pr.Technicianid = td.USERID LEFT JOIN AaaUser ti ON td.USERID = ti.USER_ID LEFT JOIN POStatus std ON pr.statusid = std.statusid LEFT JOIN PurchaseRequest_Fields poaddfield ON pr.requestid = poaddfield.requestid LEFT JOIN prrequesteditems prt ON pr.requestid = prt.requestid WHERE (poaddfield.UDF_CHAR10) = '2023' ORDER BY 1

                  New to ADSelfService Plus?