APPDES_PERM_VWO

(SQL View)
 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 , B.DESCR , A.ACCESS_PERMISSION FROM PS_APPDES_OBJ_PERM A , PS_APP_DES_OBJECTS B WHERE A.APP_DES_CATEGORY = '1' AND A.APP_DES_CATEGORY = B.APP_DES_CATEGORY AND A.OBJNAME = B.OBJNAME

  • Related Language Record: APPDES_PERM_VOL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OBJNAME Character(30) VARCHAR2(30) NOT NULL Object Name
    2 ACCESS_CD Character(1) VARCHAR2(1) NOT NULL Access Code
    N=No Access
    Y=Read/Write Access
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 ACCESS_PERMISSION Character(30) VARCHAR2(30) NOT NULL Access Permission