FP_JOBCDVW_LNG

(SQL View)
Index Back

Job Code Setid View Rel Lang


SELECT A.SETID , A.JOBCODE , A.EFFDT , B.LANGUAGE_CD , B.DESCR FROM PS_JOBCODE_TBL A , PS_JOBCODE_LANG B WHERE A.EFF_STATUS = 'A' AND B.SETID = A.SETID AND B.JOBCODE = A.JOBCODE AND B.EFFDT = A.EFFDT

  • Related Language Record for FP_JOBCODE_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code SetID
    2 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
    3 EFFDT Date(10) DATE Effective Date
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description