RA_PUPD_FILTER (SQL Table)	Index Back
Filter for Profile Updater This table stores filter criteria for multi row profile updater module

RA_PUPD_FILTER

(SQL Table)

Filter for Profile Updater

This table stores filter criteria for multi row profile updater module

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RA_PUPD_ID Signed Number(32,0) DECIMAL(31) NOT NULL Manage Profile Update ID using for tracking mass profile changer ids

2 RA_PUPD_FILT_SEQ Number(3,0) SMALLINT NOT NULL Profile Updater Sequence Number for Filter definition.

3 RA_PROFILE_ID Number(18,0) DECIMAL(18) NOT NULL Profile - profile ID

4 RA_ATTRIBUTE_ID Number(18,0) DECIMAL(18) NOT NULL Profile / Attribute ID
Prompt Table: RA_PUPD_ATTR_VW

5 ORDERBYNUM Number(3,0) SMALLINT NOT NULL Order-By Number

6 RA_OPEN_BRACKETS Character(2) VARCHAR2(2) NOT NULL Open Brackets
01=(
02=((
03=(((
04=((((

7 RA_PRF_ATTRIB_OPER Character(4) VARCHAR2(4) NOT NULL This field stores the operator for use in audience builder and manage profile changes.

8 RA_AND_OR_WITH Character(4) VARCHAR2(4) NOT NULL Marketing Center Selection Criteria an/or/with value
AND=And
OR=Or
WITH=With

9 RA_VALUE_CHAR254 Character(254) VARCHAR2(254) NOT NULL Holds a string value for audience builder and manage profile updates criteria.

10 RA_VALUE_NUM Signed Number(25,5) DECIMAL(23,5) NOT NULL Number Value

11 RA_VALUE_DATE Date(10) DATE Search Filter - value date

12 RA_VALUE_TIME Time(15) TIMESTAMP Search Filter - value time

13 RA_VALUE_LONG Long Character CLOB Long text

14 RA_CLOSE_BRACKETS Character(2) VARCHAR2(2) NOT NULL Close Brackets
01=)
02=))
03=)))
04=))))

15 RA_LB_HIST_ELEMENT Character(1) VARCHAR2(1) NOT NULL Audience criteria history query element
1=Email Sent
2=Web Page Seen
3=Web Page Completed
4=Web Link Clicked
5=Audience
6=Segment
7=Campaign Activity Executed
8=Lead Accepted
9=Order Placed

16 EOCF_LIB_TERM_ID Number(31,0) DECIMAL(31) NOT NULL a library element that can be evaluated. NOTE: this primary key value is actually a foreign key to the library element portion of a term. Terms are sub-types of elements.

17 BO_TYPE_ID Number(6,0) INTEGER NOT NULL ID Type

18 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

19 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.

20 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.

21 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.

22 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

23 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RA_PUPD_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Manage Profile Update ID using for tracking mass profile changer ids
2	RA_PUPD_FILT_SEQ	Number(3,0)	SMALLINT NOT NULL	Profile Updater Sequence Number for Filter definition.
3	RA_PROFILE_ID	Number(18,0)	DECIMAL(18) NOT NULL	Profile - profile ID
4	RA_ATTRIBUTE_ID	Number(18,0)	DECIMAL(18) NOT NULL	Profile / Attribute ID Prompt Table: RA_PUPD_ATTR_VW
5	ORDERBYNUM	Number(3,0)	SMALLINT NOT NULL	Order-By Number
6	RA_OPEN_BRACKETS	Character(2)	VARCHAR2(2) NOT NULL	Open Brackets 01=( 02=(( 03=((( 04=((((
7	RA_PRF_ATTRIB_OPER	Character(4)	VARCHAR2(4) NOT NULL	This field stores the operator for use in audience builder and manage profile changes.
8	RA_AND_OR_WITH	Character(4)	VARCHAR2(4) NOT NULL	Marketing Center Selection Criteria an/or/with value AND=And OR=Or WITH=With
9	RA_VALUE_CHAR254	Character(254)	VARCHAR2(254) NOT NULL	Holds a string value for audience builder and manage profile updates criteria.
10	RA_VALUE_NUM	Signed Number(25,5)	DECIMAL(23,5) NOT NULL	Number Value
11	RA_VALUE_DATE	Date(10)	DATE	Search Filter - value date
12	RA_VALUE_TIME	Time(15)	TIMESTAMP	Search Filter - value time
13	RA_VALUE_LONG	Long Character	CLOB	Long text
14	RA_CLOSE_BRACKETS	Character(2)	VARCHAR2(2) NOT NULL	Close Brackets 01=) 02=)) 03=))) 04=))))
15	RA_LB_HIST_ELEMENT	Character(1)	VARCHAR2(1) NOT NULL	Audience criteria history query element 1=Email Sent 2=Web Page Seen 3=Web Page Completed 4=Web Link Clicked 5=Audience 6=Segment 7=Campaign Activity Executed 8=Lead Accepted 9=Order Placed
16	EOCF_LIB_TERM_ID	Number(31,0)	DECIMAL(31) NOT NULL	a library element that can be evaluated. NOTE: this primary key value is actually a foreign key to the library element portion of a term. Terms are sub-types of elements.
17	BO_TYPE_ID	Number(6,0)	INTEGER NOT NULL	ID Type
18	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
19	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
20	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
21	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
22	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
23	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time