RB_ATTR_OBJ_VW

(SQL View)
 Index Back

Attribute Object View

Common Object used for Attribute Object View

SELECT O.MARKET , O.RB_OBJECT_TYPE , G.ATTR_GRP_MARKET , O.ATTR_GROUP_ID , O.ATTRIBUTE_ID , T.PNLGRPNAME , T.RECNAME , G.CHD_OBJECT_TYPE , O.ATTR_SEQUENCE , O.REQUIRED_FLG , O.BEGIN_DATE , O.END_DATE , O.USE_ATTR_FLG , O.DISPLAY_ONLY_FLG , O.EXP_ATTR_HANDLE , A.ATTR_NAME , A.ATTR_STATUS , A.ATTR_FIELD_TYPE , A.ATTR_DATA_TYPE , A.ATTR_LENGTH , A.ATTR_DECIMALS , GP.ATTR_USAGE , A.ATTR_DEFAULT_VAL , A.ATTR_DEFAULT_NBR , A.ATTR_DEFAULT_DATE , A.RETRIEVAL_MODE , A.RETRIEVAL_RULE_ID , A.VALIDATION_RULE_ID , AI.ATTR_ITEM_ID , G.ATTR_GROUP_SEQ , GP.DESCR60 , O.ATTRCHG_FLAG , O.HIDE_FLAG FROM PS_RB_OBJ_ATTR_GRP G , PS_RB_OBJ_ATTR O , PS_RB_ATTRIBUTE A LEFT OUTER JOIN PS_RB_ATTR_ITEM AI ON A.ATTRIBUTE_ID = AI.ATTRIBUTE_ID AND A.MARKET = AI.MARKET AND AI.DEFAULT_FLG = 'Y' , PS_RB_OBJECT_TYPE T , PS_RB_ATTR_GROUP GP WHERE G.RB_OBJECT_TYPE = O.RB_OBJECT_TYPE AND G.MARKET = O.MARKET AND G.ATTR_GROUP_ID = O.ATTR_GROUP_ID AND O.ATTRIBUTE_ID = A.ATTRIBUTE_ID AND O.ATTR_GRP_MARKET = A.MARKET AND O.RB_OBJECT_TYPE = T.RB_OBJECT_TYPE AND O.MARKET = T.MARKET AND G.ATTR_GROUP_ID = GP.ATTR_GROUP_ID AND G.ATTR_GRP_MARKET = GP.MARKET AND O.USE_ATTR_FLG = 'Y' AND A.ATTR_STATUS = 'ACTV'

  • Related Language Record: RB_ATTR_OBJ_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 MARKET Character(3) VARCHAR2(3) NOT NULL Market
    2 RB_OBJECT_TYPE Character(30) VARCHAR2(30) NOT NULL Attribute Object Type
    3 ATTR_GRP_MARKET Character(3) VARCHAR2(3) NOT NULL Used in the Object Type Attributes page

    Prompt Table: RB_MARKET_VW

    4 ATTR_GROUP_ID Character(15) VARCHAR2(15) NOT NULL attribute group id field used by applications
    5 ATTRIBUTE_ID Character(15) VARCHAR2(15) NOT NULL Attribute Label, Name or Properties
    6 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
    7 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    8 CHD_OBJECT_TYPE Character(30) VARCHAR2(30) NOT NULL Child Object Type...................................
    9 ATTR_SEQUENCE Number(3,0) SMALLINT NOT NULL Attribute Sequence
    10 REQUIRED_FLG Character(1) VARCHAR2(1) NOT NULL Required Flag
    11 BEGIN_DATE Date(10) DATE Begin Date
    12 END_DATE Date(10) DATE End date field to store an end date.
    13 USE_ATTR_FLG Character(1) VARCHAR2(1) NOT NULL Use Attribute Flag.................................................
    14 DISPLAY_ONLY_FLG Character(1) VARCHAR2(1) NOT NULL Display-Only
    15 EXP_ATTR_HANDLE Character(4) VARCHAR2(4) NOT NULL Expiration Handling
    FULL=Full Access
    HIDE=Don't Show
    READ=Read Only
    16 ATTR_NAME Character(30) VARCHAR2(30) NOT NULL Attribute name
    17 ATTR_STATUS Character(4) VARCHAR2(4) NOT NULL Attribute status
    ACTV=Active
    INCT=Inactive
    18 ATTR_FIELD_TYPE Character(4) VARCHAR2(4) NOT NULL Attribute field type
    DRDN=Drop-Down
    EDIT=Edit Box
    LOOK=Prompt Lookup
    19 ATTR_DATA_TYPE Character(4) VARCHAR2(4) NOT NULL Attribute data type
    DATE=Date
    NMBR=Number
    PSWD=Password
    STR=String
    20 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
    21 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
    22 ATTR_USAGE Character(4) VARCHAR2(4) NOT NULL Attribute usage
    CONF=Configuration
    INFO=Information
    23 ATTR_DEFAULT_VAL Character(254) VARCHAR2(254) NOT NULL Attribute default value
    24 ATTR_DEFAULT_NBR Number(29,6) DECIMAL(28,6) NOT NULL default number for attributes application
    25 ATTR_DEFAULT_DATE Date(10) DATE default date for attributes application
    26 RETRIEVAL_MODE Character(4) VARCHAR2(4) NOT NULL Retrieval Mode
    AUTO=Automatic
    MANL=Manual
    27 RETRIEVAL_RULE_ID Character(15) VARCHAR2(15) NOT NULL Retrieval Rule
    28 VALIDATION_RULE_ID Character(15) VARCHAR2(15) NOT NULL Validation Rule
    29 ATTR_ITEM_ID Character(15) VARCHAR2(15) NOT NULL Attribute Item ID
    30 ATTR_GROUP_SEQ Number(3,0) SMALLINT NOT NULL sequence number used in attributes
    31 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    32 ATTRCHG_FLAG Character(1) VARCHAR2(1) NOT NULL Field aded for IBM bulk service management
    33 HIDE_FLAG Character(1) VARCHAR2(1) NOT NULL Field used for storing hide flag information