PeopleSoft: Record Types

Smart Panda - IdeaSometimes it is nice to just have a quick reference to the Record Types from the Record Definitions, as here is a quick reference SQL code:

SELECT R.RECNAME AS RECORD_NAME,
( CASE
WHEN R.RECTYPE = 0 THEN ‘Table’
WHEN R.RECTYPE = 1 THEN ‘View’
WHEN R.RECTYPE = 2 THEN ‘Derived’
WHEN R.RECTYPE = 3 THEN ‘Sub Record’
WHEN R.RECTYPE = 5 THEN ‘Dynamic View’
WHEN R.RECTYPE = 6 THEN ‘Query View’
WHEN R.RECTYPE = 7 THEN ‘Temporary Table’
ELSE ‘Unknown’
END )   AS RECORD_TYPE
FROM   PSRECDEFN R