TL_WV_GO_VW

(SQL View)
 Index Back

eTime Related links Search

This view allows to load the 'eTIME MANAGEMENT' 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 , D.DESCR50 FROM PSAUTHITEM B , PS_TL_APP_SUITEDTL C , PS_TL_APP_ITEM D , PSROLEUSER E , PSROLECLASS F , 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 B.MENUNAME = D.MENUNAME AND B.BARNAME = D.BARNAME AND B.BARITEMNAME = D.ITEMNAME

  • Related Language Record: TL_WV_GO_LANG

    • # 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 Work field utilized on TL Launch Pad and other pages
    3 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50