RPM_RA_REC_VW

(SQL View)
Index Back

RPM_RA_REC_VW

Used by Copy Audience to get the distinct company, partner, and consumer from RA_LIST to RPM_RA_LIST

SELECT DISTINCT SETID , RA_LIST_ID , CASE WHEN BO_ID_COMPANY = 0 THEN BO_ID ELSE BO_ID_COMPANY END , CASE WHEN ROLE_TYPE_ID_ORG = 0 THEN ROLE_TYPE_ID ELSE ROLE_TYPE_ID_ORG END FROM PS_RA_LIST_REC A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
2 RA_LIST_ID Character(15) VARCHAR2(15) NOT NULL Audience ID
3 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
4 ROLE_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Role Type ID