RY_EE_JOB_LVW

(SQL View)
 Index Back

WFC Job Info Related Lang view

Workforce Connect - Language related display for Job information

SELECT J.SETID %Concat '.' %Concat J.JOBCODE , J.LANGUAGE_CD , J.DESCR FROM PS_JOBCODE_LANG J WHERE %EffdtCheck(JOBCODE_LANG, J, %CurrentDateIn)

  • Related Language Record for RY_EE_JOB_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SID_JOBCODE Character(21) VARCHAR2(21) NOT NULL Workforce Connect - SetID JobCode
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR_JOBCODE Character(30) VARCHAR2(30) NOT NULL Description