HR_CPJCODEP_LNG

(SQL View)
 Index Back

Career Path Table - Job Code

Related Lang Record

SELECT A.BUSINESS_UNIT_JOBC , A.JOBCODE , A.LANGUAGE_CD , A.DESCR FROM PS_BU_JOBCDVW_LNG A ,PS_BU_JOBCD_VW B WHERE B.EFF_STATUS = 'A' AND A.BUSINESS_UNIT_JOBC = B.BUSINESS_UNIT_JOBC AND A.JOBCODE = B.JOBCODE AND EXISTS ( SELECT 'X' FROM PS_CAREERPATH_TBL B WHERE A.BUSINESS_UNIT_JOBC = B.BUSINESS_UNIT AND A.JOBCODE = B.JOBCODE)

  • Related Language Record for HR_CP_JCODE_P

  • Parent record: CAREERMOVE_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description