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

PeopleSoft Field Type Number Mapping

0 - Char
1 - LongChar
2 - Number
3 - SignNumber
4 - Date
5 - Time
6 - DateTime
8 - Image
9 - ImgRef
8 - Attachment