PERS_DEPT_VW_LN

(SQL View)
Index Back

Departement View

Departement View

SELECT A.SETID ,A.DEPTID ,A.LANGUAGE_CD ,A.EFFDT ,A.DESCR FROM PS_DEPT_TBL_LANG A WHERE A.EFFDT= ( SELECT MAX(B.EFFDT) FROM PS_DEPT_TBL_LANG B WHERE A.SETID =B.SETID AND A.DEPTID= B.DEPTID AND B.EFFDT<=%CurrentDateIn)

  • Related Language Record for PERS_DEPT_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID
    2 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 EFFDT Date(10) DATE Effective Date
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description