CAREERTBL_SRCH

(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.DESCR FROM PS_CAREERMOVE_TBL A ,PS_JOBCODE_TBL 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='JOBCODE_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: CAREERTBL_S_LNG

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

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

    Prompt Table: JOBCODE_TBL

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