JOBCODE_VW_L

(SQL View)
 Index Back

Job Code in Non-Base Languages

View that returns the current job code description in non-base languages. This view is NOT to be used as a related-language record, but INSTEAD of a related-language record when filling rowsets.

SELECT A.SETID , A.JOBCODE , L.LANGUAGE_CD , A.DESCR FROM PSLANGUAGES L , PS_JOBCODE_LANG A WHERE L.INSTALLED = 1 AND A.LANGUAGE_CD = L.LANGUAGE_CD AND A.EFFDT = ( SELECT MAX(AA.EFFDT) FROM PS_JOBCODE_LANG AA WHERE AA.SETID = A.SETID AND AA.JOBCODE = A.JOBCODE AND AA.EFFDT <= %CurrentDateIn ) UNION SELECT A.SETID , A.JOBCODE , L.LANGUAGE_CD , A.DESCR FROM PSLANGUAGES L , PS_JOBCODE_TBL A WHERE L.LANGUAGE_CD <> ( SELECT O.LANGUAGE_CD FROM PSOPTIONS O) AND L.INSTALLED = 1 AND A.EFFDT = ( SELECT MAX(AA.EFFDT) FROM PS_JOBCODE_TBL AA WHERE AA.SETID = A.SETID AND AA.JOBCODE = A.JOBCODE AND AA.EFFDT <= %CurrentDateIn ) AND NOT EXISTS ( SELECT 'X' FROM PS_JOBCODE_LANG B WHERE B.SETID = A.SETID AND B.JOBCODE = A.JOBCODE AND B.EFFDT = A.EFFDT AND B.LANGUAGE_CD = L.LANGUAGE_CD)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_HR.SETID

Prompt Table: SET_VLD_HR_02

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