TL_WORKREC_VW

(SQL View)
 Index Back

PSRECDEFN selective view

View lists records that represent physical tables, views and temporary tables for use as Work Records in rules. View also excludes related language records

SELECT RECNAME , RECDESCR FROM PSRECDEFN WHERE RECTYPE IN (0,1,7) AND RECNAME NOT IN ( SELECT RELLANGRECNAME FROM PSRECDEFN)

  • Related Language Record: TL_WORKREC_LV

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description