ERE_DEPT_ESPLNG

(SQL View)
 Index Back

ERE Departments

Company departments affected by an ERE

SELECT DISTINCT B.ERE_ID_ESP , B.COMPANY , B.SETID_DEPT , B.DEPTID ,A1.LANGUAGE_CD , A1.DESCR FROM PS_ERE_EE_VW_ESP B , PS_DEPT_TBL A ,PS_DEPT_TBL_LANG A1 WHERE A.SETID = B.SETID_DEPT AND A.DEPTID = B.DEPTID AND %EffdtCheck(DEPT_TBL, A, %CurrentDateIn) AND A.SETID = A1.SETID AND A.DEPTID = A1.DEPTID AND A.EFFDT = A1.EFFDT

  • Related Language Record for ERE_DEPT_ESP_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description