RA_PRFL_FLD_RL

(SQL View)
 Index Back

Profile Field RelLang View

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

SELECT A.RA_PROFILE_ID , A.RA_ATTRIBUTE_ID , L.LANGUAGE_CD , L.RA_ATTRIB_NAME FROM PS_RA_ATTRIBUTE A , PS_RA_ATTR_LNG L WHERE A.RA_ATTRIB_STATUS = 'ACT' AND A.RA_PROFILE_ID = L.RA_PROFILE_ID AND A.RA_ATTRIBUTE_ID = L.RA_ATTRIBUTE_ID

  • Related Language Record for RA_PRFL_FLD_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 RA_ATTRIB_NAME Character(90) VARCHAR2(90) NOT NULL Profile - Attribute name