RA_PUPD_FIELDS (SQL Table)	Index Back
Profile Changed Fields Profile Changed Fields Value table for storing new values for Profile fields

RA_PUPD_FIELDS

(SQL Table)

Profile Changed Fields

Profile Changed Fields Value table for storing new values for Profile fields

# 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_PROFILE_ID Number(18,0) DECIMAL(18) NOT NULL Profile - profile ID

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

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

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

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

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

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

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

10 RA_VALUE_LONG Long Character CLOB Long text

11 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

12 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.

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

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

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

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

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

18 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.

19 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_PROFILE_ID	Number(18,0)	DECIMAL(18) NOT NULL	Profile - profile ID
3	RA_ATTRIBUTE_ID	Number(18,0)	DECIMAL(18) NOT NULL	Profile / Attribute ID Prompt Table: RA_PUPD_ATTR_VW
4	RA_PRF_ATTRIB_OPER	Character(4)	VARCHAR2(4) NOT NULL	This field stores the operator for use in audience builder and manage profile changes. Default Value: 0003
5	ORDERBYNUM	Number(3,0)	SMALLINT NOT NULL	Order-By Number
6	RA_VALUE_CHAR254	Character(254)	VARCHAR2(254) NOT NULL	Holds a string value for audience builder and manage profile updates criteria.
7	RA_VALUE_NUM	Signed Number(25,5)	DECIMAL(23,5) NOT NULL	Number Value
8	RA_VALUE_DATE	Date(10)	DATE	Search Filter - value date
9	RA_VALUE_TIME	Time(15)	TIMESTAMP	Search Filter - value time
10	RA_VALUE_LONG	Long Character	CLOB	Long text
11	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
12	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.
13	BO_TYPE_ID	Number(6,0)	INTEGER NOT NULL	ID Type
14	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
15	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
16	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
17	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
18	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.
19	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time