PTADSREC_TOP_VW

 index back

SELECT RECNAME , RECDESCR , %NumToChar(RECTYPE) FROM PSRECDEFN P WHERE P.RECTYPE = 0 AND NOT EXISTS ( SELECT 'Is Related Language Record?' FROM PSRECDEFN L WHERE L.RELLANGRECNAME = P.RECNAME )

  • Related language record: PTADSREC_TOP_VL

    • PeopleSoft Field Name Field Type Column Type Description
    RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    RECDESCR Character(30) VARCHAR2(30) NOT NULL Record Description
    RECTYPE_CHAR Character(1) VARCHAR2(1) NOT NULL Record Type denoted in character for translate purpose.
    0=SQL Table
    1=SQL View
    2=Derived/Work
    3=SubRecord
    5=Dynamic View
    6=Query View
    7=Temporary Table
    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20