How to Find the Record Type of a Record in PeopleSoft

This simple SQL will show you how to find basic information about a record type.

SELECT RECNAME,
DECODE (RECTYPE,
     0, 'SQL Table',
     1, 'SQL View',
     2, 'Derived',
     3, 'Sub Record',
     5, 'Dynamic View',
     6, 'Query View',
     7, 'Temporary Table',
     'Unknown') As RecordType,
RECDESCR,
PARENTRECNAME,
AUDITRECNAME
FROM PSRECDEFN WHERE RECNAME = 'ACAD_PROG'; --Record Name

Read More»