TL_LEFT_REC_VW

(SQL View)
 Index Back

Left Record View


SELECT A.RECNAME ,A.RECDESCR ,A.DESCRLONG FROM PSRECDEFN A WHERE A.RECTYPE <> 3 AND A.RECNAME LIKE 'TL_IPT%' OR A.RECNAME IN ( SELECT B.RIGHT_RECNAME FROM PS_TL_RLTNSHP_DEFN B)

  • Related Language Record: PSRECDEFNLANG

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