PSPAINODE_LVW

index back

Language PIA nodes prompt view


SELECT A.MSGNODENAME , B. LANGUAGE_CD , B.DESCR , B.DESCRLONG FROM PSMSGNODEDEFN A , PSNODEDEFNLANG B WHERE A.MSGNODENAME = B.MSGNODENAME AND A.ACTIVE_NODE = '1' AND A.NODE_TYPE = 'PIA' AND IB_NETWORK = 1 AND LOCALNODE <> 1

  • Related language record for PSPIANODE_VW
  • 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