RB_ATTR_ITEM_V1

(SQL View)
 Index Back

Attribute item view record

Used to get the attribute items

SELECT MARKET ,ATTRIBUTE_ID ,ATTR_ITEM_ID ,ATTR_ITEM_VALUE FROM PS_RB_ATTR_ITEM

  • Related Language Record: RB_ATTR_ITEM_VL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 MARKET Character(3) VARCHAR2(3) NOT NULL Market

    Default Value: GBL

    2 ATTRIBUTE_ID Character(15) VARCHAR2(15) NOT NULL Attribute Label, Name or Properties

    Prompt Table: RB_ATTRIBUTE

    3 ATTR_ITEM_ID Character(15) VARCHAR2(15) NOT NULL Attribute Item ID
    4 ATTR_ITEM_VALUE Character(50) VARCHAR2(50) NOT NULL Attribute drop-down item value