PIM_CR_MERGE_VW

(SQL View)
 Index Back

Merged Duplicate Consumers

This record is used as a view for duplicate consumers for a user

SELECT A.BO_ID , A.OPRID , %subrec(RB_AUDIT_SBR, B) FROM %Table(PIM_BO_MERGE) A , %Table(BO_ROLE) B WHERE B.BO_ID = A.BO_ID AND B.ROLE_TYPE_ID IN (9, 46) AND (B.ROLE_END_DT > %CurrentDateIn OR EXISTS ( SELECT 'X' FROM %Table(PIM_PDUP_TBL) C WHERE C.BO_ID = B.BO_ID AND C.ROLE_TYPE_ID = B.ROLE_TYPE_ID AND C.PIM_DUP_STATUS = 'N') )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
4 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
5 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
6 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
7 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.
8 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time