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 NameField TypeColumn TypeDescription
    RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
    LANGUAGE_CDCharacter(3)VARCHAR2(3) NOT NULLLanguage Code translate values
    RECDESCRCharacter(30)VARCHAR2(30) NOT NULLRecord Description
    RECTYPE_CHARCharacter(1)VARCHAR2(1) NOT NULLRecord 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.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19