PY_DEPT_VWLNG (SQL View)	Index Back
Department ID The view shows the department id information by language code.

PY_DEPT_VWLNG

(SQL View)

Department ID

The view shows the department id information by language code.

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

Related Language Record for GP_WC_DEPT_VW PY_DEPT_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description