HRS_EML_NODE_LV

(SQL View)
Index Back

SELECT A.MSGNODENAME , B.LANGUAGE_CD , B.DESCR FROM PSMSGNODEDEFN A , PSNODEDEFNLANG B WHERE A.CONNID='GETMAILTARGET' AND A.ACTIVE_NODE='1' AND A.MSGNODENAME=B.MSGNODENAME

  • Related Language Record for HRS_EML_NODE_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 MSGNODENAME Character(30) VARCHAR2(30) NOT NULL Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description