RA_DDP_LISTRECS (SQL View)	Index Back
Dedup Audience records Utility view to identify records for campaign audience deduping

RA_DDP_LISTRECS

(SQL View)

Dedup Audience records

Utility view to identify records for campaign audience deduping

SELECT W.BUSINESS_UNIT , W.RA_CAMPAIGN_ID , W.RA_CMPGN_WAVE_ID , R.BO_ID , R.ROLE_TYPE_ID , R.BO_REL_ID , L.SETID , L.RA_LIST_ID , L.RA_LIST_STATUS , W.LIST_DEDUP_PRI FROM PS_RA_CMPGN_WAVE W , PS_SET_CNTRL_REC S , PS_RA_LIST L , PS_RA_LIST_REC R WHERE W.LIST_DEDUP_PRI > 0 AND %TrimSubstr(S.SETCNTRLVALUE, 1, 5) = W.BUSINESS_UNIT AND S.RECNAME = 'RA_LIST' AND L.SETID = S.SETID AND L.RA_LIST_ID = W.RA_LIST_ID AND L.RA_INT_EXT_IND = 'I' AND L.RA_STAT_DYN_IND = 'S' AND L.RA_LIST_SOURCE <> 'EXT' AND R.SETID = L.SETID AND R.RA_LIST_ID = L.RA_LIST_ID AND R.DELETED_FLG = 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 RA_CAMPAIGN_ID Character(15) VARCHAR2(15) NOT NULL Marketing - Campaign Identification field. Character field that will contain a generated campaign or free form entered campaign id.

3 RA_CMPGN_WAVE_ID Character(15) VARCHAR2(15) NOT NULL Used to uniquely identify a Marketing - Campaign Activity (wave) ID

4 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID

5 ROLE_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Role Type ID

6 BO_REL_ID Signed Number(32,0) DECIMAL(31) NOT NULL Relationship ID of a Business Object

7 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

8 RA_LIST_ID Character(15) VARCHAR2(15) NOT NULL Audience ID

9 RA_LIST_STATUS Character(4) VARCHAR2(4) NOT NULL Audience / List Status
010=In Design
020=Designed
030=Scheduled
040=Processing
050=Generated
060=Approved
070=Committed
080=Archived

10 LIST_DEDUP_PRI Number(3,0) SMALLINT NOT NULL Audience DeDup priority

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	RA_CAMPAIGN_ID	Character(15)	VARCHAR2(15) NOT NULL	Marketing - Campaign Identification field. Character field that will contain a generated campaign or free form entered campaign id.
3	RA_CMPGN_WAVE_ID	Character(15)	VARCHAR2(15) NOT NULL	Used to uniquely identify a Marketing - Campaign Activity (wave) ID
4	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
5	ROLE_TYPE_ID	Number(12,0)	DECIMAL(12) NOT NULL	Role Type ID
6	BO_REL_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Relationship ID of a Business Object
7	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
8	RA_LIST_ID	Character(15)	VARCHAR2(15) NOT NULL	Audience ID
9	RA_LIST_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Audience / List Status 010=In Design 020=Designed 030=Scheduled 040=Processing 050=Generated 060=Approved 070=Committed 080=Archived
10	LIST_DEDUP_PRI	Number(3,0)	SMALLINT NOT NULL	Audience DeDup priority