PTADSREC_TOP_VL

index back

SELECT W.RECNAME , W.LANGUAGE_CD , W.RECDESCR , %NumToChar(P.RECTYPE) FROM %Table(PSRECDEFN) P , %Table(PSRECDEFNLANG) W WHERE P.RECNAME=W.RECNAME AND P.RECTYPE IN (0,1,5,6) AND NOT EXISTS ( SELECT 'Is Related Language Record?' FROM PSRECDEFN L WHERE L.RELLANGRECNAME = P.RECNAME )

  • Related language record for PTADSREC_TOP_VW
  • PeopleSoft Field Name Field Type Column Type Description
    RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code translate values
    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 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19