QRY_NODEVW_LANG

index back

Message Node Definition Lang

PSNODEDEFNLANG is the alternative language table for PSMSGNODEDEFN.
SELECT A.MSGNODENAME , B.LANGUAGE_CD , B.DESCR , B.DESCRLONG FROM PSMSGNODEDEFN A , PSNODEDEFNLANG B WHERE A.MSGNODENAME = B.MSGNODENAME AND A.NODE_TYPE = 'PIA'

  • Related language record for QRY_NODEVW
  • Parent record: PSMSGNODEDEFN
  • PeopleSoft Field NameField TypeColumn TypeDescription
    MSGNODENAMECharacter(30)VARCHAR2(30) NOT NULLApplication Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
    LANGUAGE_CDCharacter(3)VARCHAR2(3) NOT NULLLanguage Code translate values
    DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    DESCRLONGLong CharacterCLOBLong Description
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19