RS_CW_JOBCD_VW

(SQL View)
 Index Back

Create Resources

JOBCODE List.

SELECT DISTINCT A.JOBCODE , A.DESCR , 'N' FROM %Table(JOBCODE_TBL) A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM %Table(JOBCODE_TBL) B WHERE B.EFFDT <= %CurrentDateIn AND B.JOBCODE = A.JOBCODE AND B.EFF_STATUS = 'A') AND A.EFF_STATUS = 'A'

  • Related Language Record: RS_CW_JOBCD_VWL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 RS_CW_SELECTED Character(1) VARCHAR2(1) NOT NULL VARCHAR2(1) NOT NULL

    Y/N Table Edit