RB_GRP_ATTR_VW

(SQL View)
 Index Back

Attribute Group Attributes

View of Attributes associated with an Attribute Group

SELECT G.MARKET , G.ATTR_GROUP_ID , A.ATTRIBUTE_ID , A.ATTR_NAME , A.DESCR60 , A.ATTR_STATUS , A.ATTR_FIELD_TYPE FROM PS_RB_ATTR_GROUP G , PS_RB_ATTRIBUTE A WHERE G.MARKET = A.MARKET AND G.ATTR_GROUP_ID = A.ATTR_GROUP_ID

  • Related Language Record: RB_GRP_ATTR_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 MARKET Character(3) VARCHAR2(3) NOT NULL Market
    2 ATTR_GROUP_ID Character(15) VARCHAR2(15) NOT NULL attribute group id field used by applications
    3 ATTRIBUTE_ID Character(15) VARCHAR2(15) NOT NULL Attribute Label, Name or Properties
    4 ATTR_NAME Character(30) VARCHAR2(30) NOT NULL Attribute name
    5 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    6 ATTR_STATUS Character(4) VARCHAR2(4) NOT NULL Attribute status
    ACTV=Active
    INCT=Inactive
    7 ATTR_FIELD_TYPE Character(4) VARCHAR2(4) NOT NULL Attribute field type
    DRDN=Drop-Down
    EDIT=Edit Box
    LOOK=Prompt Lookup