RB_ATTRIBUTE

(SQL Table)
 Index Back

Attribute primary record

Common Object: Attribute primary record

  • Related Language Record: RB_ATTR_LNG

  • Parent Record Of RB_ATGR_ITEM_VW RB_ATTR_ITEM

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

    Default Value: OPR_DEF_TBL_RB.MARKET

    2 ATTRIBUTE_ID Character(15) VARCHAR2(15) NOT NULL Attribute Label, Name or Properties
    3 ATTR_NAME Character(30) VARCHAR2(30) NOT NULL Attribute name
    4 ATTR_STATUS Character(4) VARCHAR2(4) NOT NULL Attribute status
    ACTV=Active
    INCT=Inactive

    Default Value: ACTV

    5 ATTR_FIELD_TYPE Character(4) VARCHAR2(4) NOT NULL Attribute field type
    DRDN=Drop-Down
    EDIT=Edit Box
    LOOK=Prompt Lookup

    Default Value: EDIT

    6 ATTR_DATA_TYPE Character(4) VARCHAR2(4) NOT NULL Attribute data type
    DATE=Date
    NMBR=Number
    PSWD=Password
    STR=String
    7 ATTR_LENGTH Character(4) VARCHAR2(4) NOT NULL carry the length in characters of the attribute
    10=10
    20=20
    30=30
    40=40
    50=50
    60=60
    LONG=Long
    8 ATTR_DECIMALS Character(1) VARCHAR2(1) NOT NULL holds the number of decimals for attributes
    0=0
    1=1
    2=2
    3=3
    4=4
    5=5
    6=6
    9 ATTR_DEFAULT_VAL Character(254) VARCHAR2(254) NOT NULL Attribute default value
    10 ATTR_DEFAULT_NBR Number(29,6) DECIMAL(28,6) NOT NULL default number for attributes application
    11 ATTR_DEFAULT_DATE Date(10) DATE default date for attributes application
    12 RETRIEVAL_MODE Character(4) VARCHAR2(4) NOT NULL Retrieval Mode
    AUTO=Automatic
    MANL=Manual
    13 RETRIEVAL_RULE_ID Character(15) VARCHAR2(15) NOT NULL Retrieval Rule

    Prompt Table: RB_ATTR_RETR_VW

    14 VALIDATION_RULE_ID Character(15) VARCHAR2(15) NOT NULL Validation Rule

    Prompt Table: RB_ATTR_VALI_VW

    15 ATTR_GROUP_ID Character(15) VARCHAR2(15) NOT NULL attribute group id field used by applications

    Prompt Table: RB_ATTR_GROUP

    16 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    17 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    18 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    19 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    20 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    21 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time
    22 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description