HRS_JOPST_JFM_L

(SQL View)
 Index Back

Job Opening Family Rel Lang

Related language Job Opening Family

SELECT A.HRS_JOB_OPENING_ID , B.JOBCODE , COALESCE (D.LANGUAGE_CD , C.LANGUAGE_CD) , COALESCE (D.HRS_DESCR , C.HRS_DESCR) FROM PS_HRS_JOB_OPENING A LEFT OUTER JOIN PS_HRS_JOBCDTBLLV5 B ON A.HRS_PRM_JOBCODE = B.JOBCODE LEFT OUTER JOIN PS_HRS_JOB_FAM_LN5 C ON (B.JOB_FAMILY = C.JOB_FAMILY AND B.LANGUAGE_CD = C.LANGUAGE_CD) LEFT OUTER JOIN PS_HRS_JOB_FAM_LN5 D ON A.JOB_FAMILY = D.JOB_FAMILY WHERE (B.SETID IS NULL OR (B.SETID = ( SELECT G.SETID FROM PS_SET_CNTRL_GROUP G WHERE G.SETCNTRLVALUE = A.BUSINESS_UNIT AND G.REC_GROUP_ID = ( SELECT H.REC_GROUP_ID FROM PS_REC_GROUP_REC H WHERE H.RECNAME = 'JOBCODE_TBL') ) AND B.EFFDT = ( SELECT MAX(BE.EFFDT) FROM PS_JOBCODE_TBL BE WHERE BE.SETID = B.SETID AND BE.JOBCODE = B.JOBCODE AND BE.EFFDT <= %CurrentDateIn)))

  • Related Language Record for HRS_JOPST_JFMLY

    • # 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 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 HRS_JOB_FAMILY Character(30) VARCHAR2(30) NOT NULL Job family description