RA_PROFILE_IDRA_ATTRIB_RECNAMERA_ATTRIB_FLDNAMERDH_MRG_PROF_VW(SQL View) |
Index Back |
|---|---|
CDM Profile MergeThis view is used by CDM Profile Merge for a list of the profile record names. |
| SELECT DISTINCT P.RA_PROFILE_ID , A.RA_ATTRIB_RECNAME , A.RA_ATTRIB_FLDNAME 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) |
| # | 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_ATTRIB_RECNAME |
Character(15) | VARCHAR2(15) NOT NULL | Profile - Attribute record name |
| 3 | RA_ATTRIB_FLDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Profile - Attribute field name |