HRS_JOPST_JFMLY

(SQL View)
Index Back

SELECT A.HRS_JOB_OPENING_ID ,B.JOBCODE ,COALESCE (D.JOB_FAMILY , C.JOB_FAMILY) ,B.JOB_FUNCTION ,COALESCE (D.HRS_DESCR , C.HRS_DESCR) FROM PS_HRS_JOB_OPENING A LEFT OUTER JOIN PS_JOBCODE_TBL B ON A.HRS_PRM_JOBCODE = B.JOBCODE LEFT OUTER JOIN PS_HRS_JOB_FAM_I_3 C ON B.JOB_FAMILY = C.JOB_FAMILY LEFT OUTER JOIN PS_HRS_JOB_FAM_I_3 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: HRS_JOPST_JFM_L
  • # 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 JOB_FAMILY Character(6) VARCHAR2(6) NOT NULL Job Family
    4 JOB_FUNCTION Character(3) VARCHAR2(3) NOT NULL Job Function Code
    5 HRS_JOB_FAMILY Character(30) VARCHAR2(30) NOT NULL Job family description