RB_REC_ATTR_VW

(SQL View)
Index Back

RB_REC_ATTR_VW

RECORD SPECIFIC ATTRIBUTE VIEWS

SELECT MARKET , RECNAME , ATTRIBUTE_ID , ATTR_GRP_MARKET , ATTR_NAME , ATTR_STATUS FROM PS_RB_ATTR_OBJ_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 MARKET Character(3) VARCHAR2(3) NOT NULL Market
2 BASE_RECNAME Character(15) VARCHAR2(15) NOT NULL Base record that enabled for the supplemental data.
3 ATTRIBUTE_ID Character(15) VARCHAR2(15) NOT NULL Attribute Label, Name or Properties
4 ATTR_GRP_MARKET Character(3) VARCHAR2(3) NOT NULL Used in the Object Type Attributes page

Prompt Table: RB_MARKET_VW

5 ATTR_NAME Character(30) VARCHAR2(30) NOT NULL Attribute name
6 ATTR_STATUS Character(4) VARCHAR2(4) NOT NULL Attribute status
ACTV=Active
INCT=Inactive