HR_SRCH_PORG_LG

(SQL View)
 Index Back

Per Org

Per Org

SELECT a.emplid ,a.empl_rcd ,a1.language_cd ,COALESCE(x1.xlatlongname ,m2.message_text) ,m1.MESSAGE_TEXT FROM ps_HR_SRCH_PER_ORG a LEFT OUTER JOIN psxlatitemlang x1 ON (x1.FIELDNAME='PER_ORG' AND x1.FIELDVALUE=a.PER_ORG ) ,PS_PER_ORG_ASG_LNG a1 ,PSMSGCATLANG m1 ,PSMSGCATLANG m2 WHERE a.emplid=a1.emplid AND a.empl_rcd=a1.empl_rcd AND m1. message_set_nbr=1000 AND m1.message_nbr=1744 AND m2. message_set_nbr=1000 AND m2.message_nbr=1746 AND a1.language_cd=m1.language_cd AND a1.language_cd=m2.language_cd AND COALESCE(x1.language_cd,m1.language_cd)=m1.language_cd

  • Related Language Record for HR_SRCH_PER_ORG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 HR_SRCH_PER_ORG Character(50) VARCHAR2(50) NOT NULL Description for the PER_ORG field.
    5 PER_ORG_DESCR Character(50) VARCHAR2(50) NOT NULL Description for the PER_ORG field.