PSTREESTRCTLVVW

(SQL View)
 Index Back

Level RecNames on Structures

Lists Level Record Names referenced on all existing structures Used as prompt table for HTML Tree Manager search Record

SELECT DISTINCT a.level_recname ,b.recdescr FROM pstreestrct A ,PSRECDEFN B WHERE level_recname <> ' ' AND A.level_recname = B.recname

  • Related Language Record: PSTREESTRLVVWLA

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LEVEL_RECNAME Character(15) VARCHAR2(15) NOT NULL Tree Structure Level Record name
    2 RECDESCR Character(30) VARCHAR2(30) NOT NULL Record Description