RB_CIM_USER_VW1 (SQL View)	Index Back
View for searching persons View created for Config Search, used as "deep query" for searching created by user on the manage import batches and manage import rows configurable searches.

RB_CIM_USER_VW1

(SQL View)

View for searching persons

View created for Config Search, used as "deep query" for searching created by user on the manage import batches and manage import rows configurable searches.

SELECT BN.BO_NAME_DISPLAY , BN.BO_NAME_DISP_UPPER , BN.BO_ID , 1 , A.SYNCID FROM PS_RB_CIM_BAT_HDR A , PSOPRALIAS UA , PS_RD_PERSON P , PS_BO_NAME BN WHERE UA.OPRID = A.ROW_ADDED_OPRID AND UA.OPRALIASTYPE = 'PER' AND UA.PERSON_ID = P.PERSON_ID AND P.BO_ID = BN.BO_ID AND BN.PRIMARY_IND = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object

2 BO_NAME_DISP_UPPER Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object in Upper

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

5 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	BO_NAME_DISPLAY	Character(80)	VARCHAR2(80) NOT NULL	Full name of the Business Object
2	BO_NAME_DISP_UPPER	Character(80)	VARCHAR2(80) NOT NULL	Full name of the Business Object in Upper
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
5	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.