DEPTID_BUHC_VW

(SQL View)
 Index Back

Departments BU HC View


SELECT %Substring(B.SETCNTRLVALUE,1,5) , A.DEPTID , A.DESCR FROM PS_DEPT_TBL A , PS_SET_CNTRL_REC B WHERE B.REC_GROUP_ID = 'FS_06' AND B.RECNAME = 'DEPT_TBL' AND A.SETID = B.SETID AND A.EFFDT= ( SELECT MAX(AA.EFFDT) FROM PS_DEPT_TBL AA WHERE A.SETID = AA.SETID AND AA.DEPTID = A.DEPTID AND AA.SETID = B.SETID AND AA.EFFDT<=%CurrentDateIn) AND A.EFF_STATUS<>'I' AND A.BUDGETARY_ONLY = 'N'

  • Related Language Record: DEPTID_BUHC_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPT_TBL

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description