Query to find out PeopleSoft Record Definition

SELECT
A.RECNAME
, A.FIELDNAME
, A.FIELDNUM
, DECODE (B.FIELDTYPE ,
0 ,'Char' ,
1 ,'LongChar' ,
2 ,'Number' ,
3 ,'SignNumber' ,
4 ,'Date' ,
5 ,'Time' ,
6 ,'DateTime' ,
8 ,'Image' ,
9 ,'ImgRef' )
,B.LENGTH
FROM PSRECFIELD A
, PSDBFIELD B
WHERE A.FIELDNAME = B.FIELDNAME
AND A.RECNAME = "Record Name"
ORDER BY FIELDNUM