PSTREESTRCTDTVW

(SQL View)
 Index Back

Detail RecNames on Structures

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

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

  • Related Language Record: PSTREESTRDTVWLA

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