RB_CIM_USER_VW2 (SQL View)	Index Back
View for searching persons View created for Config Search, used as "deep query" for searching last imported by user on the manage import batches configurable search.

RB_CIM_USER_VW2

(SQL View)

View for searching persons

View created for Config Search, used as "deep query" for searching last imported by user on the manage import batches configurable search.

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.LAST_IMPORT_BY 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_2 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_2	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.