RY_ELE_TYPE_VW

(SQL View)
Index Back

Element Type View

View to find the Element Type information.

SELECT A.RY_ACT_TYPE_ID , B.RYE_ORDER , A.RY_ACT_TYPE , A.RY_ACT_LABEL , A.RY_IS_EXTERNAL , B.RYE_ELEMENT_RIGHTS , B.RY_ICON_NAME , B.RYE_START_ACTIVE FROM PS_RY_ACT_TYPE A , PS_RYEACT_OPTIONS B WHERE A.RY_ACT_TYPE_ID = B.RY_ACT_TYPE_ID

  • Related Language Record: RY_ACT_TYPE_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RY_ACT_TYPE_ID Number(18,0) DECIMAL(18) NOT NULL Used to determine the type of Element for the Dialog.
    2 RYE_ORDER Number(6,0) INTEGER NOT NULL Dialog Designer Toolbar buttion Order field for Dialogs.
    3 RY_ACT_TYPE Character(30) VARCHAR2(30) NOT NULL Used to determine an elements type.
    4 RY_ACT_LABEL Character(80) VARCHAR2(80) NOT NULL Used to store an element Types label.
    5 RY_IS_EXTERNAL Character(1) VARCHAR2(1) NOT NULL Use to know if an object is meant for external usage.
    6 RYE_ELEMENT_RIGHTS Number(15,0) DECIMAL(15) NOT NULL Element Rights field, intended to convert from decimal to binary to determine what the rights are. Each element will correspond to an element. If when converted that element has a 1 it is allowed to connect, if given a 0, then it is not allowed.
    7 RY_ICON_NAME Character(80) VARCHAR2(80) NOT NULL Icon Image name field for Various Elements.
    8 RYE_START_ACTIVE Character(1) VARCHAR2(1) NOT NULL Starts Active when the dialog loads, used for triggers.