CAREERTBL_S_LNG

(SQL View)
 Index Back

Search Vw-Career Path Tbl

CAREERTBL_SRCH is a view used in Career Planning as a search record for the Career Path Table. It selects only those jobcodes that exist on the Career Path Table and then joins in the correct DESCRs from JOBCODE_TBL.

SELECT A.BUSINESS_UNIT ,A.JOBCODE ,B.LANGUAGE_CD ,B.DESCR FROM PS_CAREERMOVE_TBL A ,PS_JOBCODE_LANG B ,PS_SET_CNTRL_REC C WHERE A.JOBCODE=B.JOBCODE AND C.SETID=B.SETID AND C.SETCNTRLVALUE=A.BUSINESS_UNIT AND C.RECNAME='DEPT_TBL' AND B.EFFDT= (SELECT MAX(D.EFFDT) FROM PS_JOBCODE_TBL D WHERE B.JOBCODE=D.JOBCODE AND D.EFFDT<=%CURRENTDATEIN AND D.SETID = B.SETID)

  • Related Language Record for CAREERTBL_SRCH

    • # 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

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

    Prompt Table: JOBCODE_TBL

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description