RA_PRFL_FLD_VW

(SQL View)
 Index Back

Profile Field view

Get Profile Fields, for field picking and assigning to profile group.

SELECT RA_PROFILE_ID , RA_ATTRIBUTE_ID , RA_ATTRIB_NAME , RA_ATTRIB_TYPE FROM PS_RA_ATTRIBUTE WHERE RA_ATTRIB_STATUS = 'ACT'

  • Related Language Record: RA_PRFL_FLD_RL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RA_PROFILE_ID Number(18,0) DECIMAL(18) NOT NULL Profile - profile ID
    2 RA_ATTRIBUTE_ID Number(18,0) DECIMAL(18) NOT NULL Profile / Attribute ID
    3 RA_ATTRIB_NAME Character(90) VARCHAR2(90) NOT NULL Profile - Attribute name
    4 RA_ATTRIB_TYPE Character(4) VARCHAR2(4) NOT NULL Profile - attribute type
    C1=Choose One
    C1R=Choose One (with Rating)
    CM=Choose Many
    DATE=Date
    DEC=Decimal
    FA=File
    INT=Integer
    LT=Text Block
    PRMT=Map Field Choice to Prompt
    TEXT=Text
    TIME=Time
    YN=Yes/No