RS_CW_DEPTID_VW

(SQL View)
 Index Back

Create Resources

DEPTID List.

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

  • Related Language Record: RS_CW_DEPT_VWL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    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