ERE_DEPT_ESP_VW

(SQL View)
 Index Back

ERE Departments

Company departments affected by an ERE

SELECT B.ERE_ID_ESP , B.COMPANY , B.SETID_DEPT , B.DEPTID , A.DESCR , COUNT(DISTINCT B.EMPLID) FROM PS_ERE_EE_VW_ESP B , PS_DEPT_TBL A WHERE A.SETID = B.SETID_DEPT AND A.DEPTID = B.DEPTID AND %EffdtCheck(DEPT_TBL, A, %CurrentDateIn) GROUP BY B.ERE_ID_ESP , B.COMPANY , B.SETID_DEPT , B.DEPTID , A.DESCR

  • Related Language Record: ERE_DEPT_ESPLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ERE_ID_ESP Character(10) VARCHAR2(10) NOT NULL ERE ID
    2 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    3 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_HR.SETID

    Prompt Table: SET_VLD_HR_01

    4 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPT_TBL

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 EMPL_COUNT Number(12,0) DECIMAL(12) NOT NULL Employee Count