HR_CP_JBCD_SRCH

(SQL View)
 Index Back

Admin - Job Code

HR Admin Job Code Search record for Career Progression Chart

SELECT A.BUSINESS_UNIT , A.JOBCODE , B.DESCR FROM PS_CAREERPATH_TBL A , PS_BU_JOBCD_VW B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT_JOBC AND A.JOBCODE = B.JOBCODE AND B.EFF_STATUS = 'A' AND B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_BU_JOBCD_VW C WHERE B.BUSINESS_UNIT_JOBC = C.BUSINESS_UNIT_JOBC AND B.JOBCODE = C.JOBCODE AND C.EFFDT <= %CurrentDateIn)

  • Related Language Record: HR_CP_JBCD_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT

    Prompt Table: HR_CP_BU_PROMPT

    2 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: HR_CP_JCODE_P

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description