RY_EE_JOB_VW

(SQL View)
 Index Back

WFC Job Information View

Workforce Connect - Related display on JOBCODE_TBL

SELECT J.SETID %Concat '.' %Concat J.JOBCODE , J.DESCR FROM PS_JOBCODE_TBL J WHERE %EffdtCheck(JOBCODE_TBL, J, %CurrentDateIn)

  • Related Language Record: RY_EE_JOB_LVW

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