RBQ_OBJREL_VW

(SQL View)
 Index Back

Security Object View

Security Object Relationship view used by Adapter Field Security options.

SELECT A.RSEC_OBJECT_ID , B.RSEC_REL_OBJ_ID , C.DESCR FROM %Table(RSEC_OBJECTDEFN) A , %Table(RSEC_OBJECT_REL) B , %Table(RSEC_OBJECTDEFN) C WHERE A.RSEC_OBJECT_ID = B.RSEC_OBJECT_ID AND C.RSEC_OBJECT_ID = B.RSEC_REL_OBJ_ID

  • Related Language Record: RBQ_OBJREL_VW_L

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RSEC_OBJECT_ID Character(30) VARCHAR2(30) NOT NULL Security Object ID used for defining application security objects.
    2 RSEC_REL_OBJ_ID Character(30) VARCHAR2(30) NOT NULL Related security object ID field is captured using this field definition.

    Prompt Table: RSEC_OBJECTDEFN

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