APPDES_PERM_VTL

 index back

App Designer Objects

This SQL view will be used as PROMPT table behind DERIVED_APP_DES_OBJ.ACCESS_CD.
SELECT A.OBJNAME , A.ACCESS_CD , A.LANGUAGE_CD , B.DESCR , A.ACCESS_PERMISSION FROM PS_APPDES_OBJ_PM_L A , PS_APP_DES_OBJ_LNG B WHERE A.APP_DES_CATEGORY = '2' AND A.APP_DES_CATEGORY = B.APP_DES_CATEGORY AND A.LANGUAGE_CD = B.LANGUAGE_CD AND A.OBJNAME = B.OBJNAME

  • Related language record for APPDES_PERM_VWT

    • PeopleSoft Field Name Field Type Column Type Description
    OBJNAME Character(30) VARCHAR2(30) NOT NULL Object Name
    ACCESS_CD Character(1) VARCHAR2(1) NOT NULL Access Code
    N=No Access
    Y=Read/Write Access
    LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code translate values
    DESCR Character(30) VARCHAR2(30) NOT NULL Description
    ACCESS_PERMISSION Character(30) VARCHAR2(30) NOT NULL Access Permission
    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20