Peoplesoft SQL Query to Identify Field Length and Field Datatype

SELECT DISTINCT P.LBLTEXT,P.FIELDNAME,P.RECNAME,F.LENGTH ,(CASE WHEN F.FIELDTYPE = '0' THEN 'Character' WHEN F.FIELDTYPE='1' THEN 'Long Character' WHEN F.FIELDTYPE='2' THEN 'Number' WHEN F.FIELDTYPE='3' THEN 'Signed number' WHEN F.FIELDTYPE='4' THEN 'Date' WHEN F.FIELDTYPE='5' THEN 'Time' WHEN F.FIELDTYPE='6' THEN 'DateTime' WHEN F.FIELDTYPE='8' THEN 'Attachment' ELSE 'TBD' END) as Field_Type FROM SYSADM.PSPNLFIELD P,SYSADM.PSDBFIELD F WHERE --P.PNLNAME in ('BEN_PROG_PARTICPTN') --'ENCUMB_TRIGGER','JOB_DATA1_WRK','EMPLOYMENT_DATA','BENEFIT_PROGRAM_PARTICI', 'JOB_DATA_DISTRIBU','JOB_DATA_3','JOB_LABOR','JOB_DATA_JOBCODE', 'JOB_DATA_SALPLAN','JOB_DATA2','JOB_DATA_3') --AND P.FIELDNAME=F.FIELDNAME --AND P.LBLTEXT like 'Benefit Record Number%' --AND RECNAME LIKE '%Car%' AND p.fieldname = 'INCLUDE_POINTS' ORDER BY P.LBLTEXT;