HRS_JO_RCTR_LNG

(SQL View)
Index Back

Related Language Record

Related Language Record for HRS_JO_RCTR

SELECT A.HRS_JOB_OPENING_ID , B.LANGUAGE_CD , B.NAME_DISPLAY FROM PS_HRS_JOB_OPENING A ,PS_NAMES_LNG B WHERE A.RECRUITER_ID=B.EMPLID AND B.NAME_TYPE = 'PRI' AND B.EFFDT = ( SELECT MAX(BE.EFFDT) FROM PS_NAMES_LNG BE WHERE BE.EMPLID = B.EMPLID AND BE.NAME_TYPE = B.NAME_TYPE AND BE.LANGUAGE_CD = B.LANGUAGE_CD AND BE.EFFDT <= %CurrentDateIn )

  • Related Language Record for HRS_JO_RCTR
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 RECRUITER_NAME Character(50) VARCHAR2(50) NOT NULL Recruiter Name