Resolution

The query below can be run to report on the Project Code, User Defined Field, Field Value, and Code Descriptions if a user defined code was used.

select pama_proj [Project Code],
spuf_label [Field Name],
spud_data [Field Value],
spuc_short [Short Code Description],
spuc_long [Long Code Description]
from spusrdat UDD
join spusrfld UDF on UDD.spud_field = UDF.spuf_field and UDD.spud_applid = UDF.spuf_applid and UDF.spuf_applid = 'pamaster'
join pamaster P on UDD.spud_key = P.pama_proj
left join spusrcod UDC on UDD.spud_data = UDC.spuc_value and UDC.spuc_applid = UDD.spud_applid and spuc_field = UDF.spuf_field
--where pama_proj = ''
order by spud_key

Browser not supported