SET_JOBCDVW_LNG

(SQL View)
Index Back

Jobcode view

/*bu/setid 09/19/1997 */ View to get the values from jobcode_tbl on careerpath_tbl.next_posn_jobcd carresponding to careerpath_tbl.setid_jobcode.

SELECT DISTINCT SETID ,JOBCODE ,LANGUAGE_CD ,DESCRSHORT ,DESCR FROM PS_JOBCODE_LANG

  • Related Language Record for SET_JOBCD_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code Set ID
    2 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description