RA_PUPD_SRCH_VW (SQL View)	Index Back
Profile Updates Search View This configurable search view returns all profile updates.

RA_PUPD_SRCH_VW

(SQL View)

Profile Updates Search View

This configurable search view returns all profile updates.

SELECT RA_PUPD_ID , RA_PUPD_NAME , RA_PUPD_DESCR , RA_PUPD_STATUS , RA_PROFILE_ID , SETID , RA_LIST_ID , ROW_ADDED_OPRID , %DatePart(ROW_ADDED_DTTM) , ROW_ADDED_DTTM , SYNCID FROM PS_RA_PROF_UPD

Related Language Record: RA_PUPD_LNG

# 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_NAME Character(80) VARCHAR2(80) NOT NULL Name of the Manage Profile Changer

3 RA_PUPD_DESCR Character(254) VARCHAR2(254) NOT NULL Description field for Manager Profile Changer

4 RA_PUPD_STATUS Character(3) VARCHAR2(3) NOT NULL Status of the current Manager Profile Changer
010=In Design
020=Queued
030=Processing
040=Completed
050=Failed
060=Aborted

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

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

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

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

9 CREATION_DATE Date(10) DATE Creation date of the case.

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

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

#	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_NAME	Character(80)	VARCHAR2(80) NOT NULL	Name of the Manage Profile Changer
3	RA_PUPD_DESCR	Character(254)	VARCHAR2(254) NOT NULL	Description field for Manager Profile Changer
4	RA_PUPD_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Status of the current Manager Profile Changer 010=In Design 020=Queued 030=Processing 040=Completed 050=Failed 060=Aborted
5	RA_PROFILE_ID	Number(18,0)	DECIMAL(18) NOT NULL	Profile - profile ID
6	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
7	RA_LIST_ID	Character(15)	VARCHAR2(15) NOT NULL	Audience ID
8	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
9	CREATION_DATE	Date(10)	DATE	Creation date of the case.
10	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
11	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.