RDH_MRG_PRFF_VW

(SQL View)
 Index Back

CDM Merge Profile Fields Info

This view is used in the CDH/CDM merge of profiles and contains the profile record field names.

SELECT A.RA_ATTRIB_RECNAME , A.RA_ATTRIB_FLDNAME , P.RA_PROFILE_ID , A.RA_ATTRIB_FLDTYPE FROM PS_RA_ATTRIBUTE A , PS_RA_PROFILE P WHERE A.RA_PROFILE_ID = P.RA_PROFILE_ID AND P.RA_PROFILE_STATUS IN ('ACT', 'UPD') AND %Sql(RDH_MRG_PROFILE_CONDITION) AND A.RA_ATTRIB_FLDNAME NOT IN ('CHOICE', 'TEXT_LONG')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RA_ATTRIB_RECNAME Character(15) VARCHAR2(15) NOT NULL Profile - Attribute record name
2 RA_ATTRIB_FLDNAME Character(18) VARCHAR2(18) NOT NULL Profile - Attribute field name
3 RA_PROFILE_ID Number(18,0) DECIMAL(18) NOT NULL Profile - profile ID
4 RA_ATTRIB_FLDTYPE Character(4) VARCHAR2(4) NOT NULL Profile Attribute Field Data Type
CHAR=Character
LONG=Long Text Block
NUM=Number - with decimal 0