PeopleSoft Wiki

with a as (
select recdescr,RECNAME, RELLANGRECNAME
from psrecdefn
n where rellangrecname <>' '
and recname like 'PS%' and rectype=0
),
b as (
SELECT RECNAME
,FIELDNAME
,(TRUNC((USEEDIT/1),0) - TRUNC((USEEDIT/2),0) * 2)
KEY
,(TRUNC((USEEDIT/2),0) - TRUNC((USEEDIT/4),0) * 2) DUPORDERKEY

,(TRUNC((USEEDIT/256),0) - TRUNC((USEEDIT/512),0) * 2) REQUIRED
FROM PSRECFIELD
)
select a.*,b.* from a,b where a.recname=b.recname
and b.key=1