TL_WV_GO_LANG (SQL View)	Index Back
eTime Related links Search This view allows to load the 'TIME CALENDARS' menu entries to the Go To combo box. Thus the user is able to navigate to related time clendar functionalities.

TL_WV_GO_LANG

(SQL View)

eTime Related links Search

This view allows to load the 'TIME CALENDARS' menu entries to the Go To combo box. Thus the user is able to navigate to related time clendar functionalities.

SELECT DISTINCT E.ROLEUSER , C.ITEMNAME_STRING , G.LANGUAGE_CD , G.DESCR50 FROM PSAUTHITEM B , PS_TL_APP_SUITEDTL C , PS_TL_APP_ITEM D , PSROLEUSER E , PSROLECLASS F , PS_TL_APP_ITEM_LNG G , PS_INSTALLATION I WHERE E.ROLENAME = F.ROLENAME AND F.CLASSID = B.CLASSID AND (C.APPLICATION_SUITE = 'TIME CALENDARS' OR (C.APPLICATION_SUITE = 'TIME CALENDARGP' AND I.INSTALLED_PAY_GBL='Y')) AND C.ITEMNAME_STRING = D.ITEMNAME_STRING AND D.ITEMNAME_STRING = G.ITEMNAME_STRING AND B.MENUNAME = D.MENUNAME AND B.BARNAME = D.BARNAME AND B.BARITEMNAME = D.ITEMNAME

Related Language Record for TL_WV_GO_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 ITEMNAME_STRING1 Character(50) VARCHAR2(50) NOT NULL Links

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

4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	ITEMNAME_STRING1	Character(50)	VARCHAR2(50) NOT NULL	Links
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50