RY_EE_DEPT_LVW (SQL View)	Index Back
WFC Dept Lang View Workforce Connect - Department information Language view .

RY_EE_DEPT_LVW

(SQL View)

WFC Dept Lang View

Workforce Connect - Department information Language view .

SELECT D.SETID %Concat '.' %Concat D.DEPTID , D.LANGUAGE_CD , D.DESCR FROM PS_DEPT_TBL_LANG D WHERE %EffdtCheck(DEPT_TBL_LANG, D, %CurrentDateIn)

Related Language Record for RY_EE_DEPT_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SID_DEPT Character(21) VARCHAR2(21) NOT NULL Workforce Connect - SetID_Department

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SID_DEPT	Character(21)	VARCHAR2(21) NOT NULL	Workforce Connect - SetID_Department
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	DESCR_DEPT	Character(30)	VARCHAR2(30) NOT NULL	Description