RB_ATTR_ITEM_VL

(SQL View)
 Index Back

Attribute item view record

Used to get the attribute items

SELECT MARKET ,ATTRIBUTE_ID ,ATTR_ITEM_ID ,LANGUAGE_CD ,ATTR_ITEM_VALUE FROM PS_RB_ATTR_ITM_LNG

  • Related Language Record for RB_ATTR_ITEM_V1

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 ATTR_ITEM_VALUE Character(50) VARCHAR2(50) NOT NULL Attribute drop-down item value