RDH_MRG_PHEM_VW (SQL View)	Index Back
Merge Date Time Merge Date Time view returns all the unique merge datetime

RDH_MRG_PHEM_VW

(SQL View)

Merge Date Time

Merge Date Time view returns all the unique merge datetime

SELECT A.BO_ID_TO , A.MERGE_DTTM , A.BO_ID_FROM , B.CM_SEQ_ORIGIN , B.PROFILE_CM_SEQ FROM PS_RDH_MERGE_HIST A , PS_RDH_MRG_CM_HIST B WHERE A.MERGE_ID = B.MERGE_ID AND A.BO_ID_TO = B.BO_ID_TO AND A.BO_ID_FROM = B.BO_ID_ORIGIN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BO_ID_TO Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID

2 MERGE_DTTM DateTime(26) TIMESTAMP This is the field for the merge event date time.

3 BO_ID_FROM Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID

4 CM_SEQ_ORIGIN Number(31,0) DECIMAL(31) NOT NULL This is the CDM CM Origin field.

5 PROFILE_CM_SEQ Number(31,0) DECIMAL(31) NOT NULL The Contact Method Profile ID is a key field that is used to reference the details of a Contact Method in various CM tables.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BO_ID_TO	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
2	MERGE_DTTM	DateTime(26)	TIMESTAMP	This is the field for the merge event date time.
3	BO_ID_FROM	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
4	CM_SEQ_ORIGIN	Number(31,0)	DECIMAL(31) NOT NULL	This is the CDM CM Origin field.
5	PROFILE_CM_SEQ	Number(31,0)	DECIMAL(31) NOT NULL	The Contact Method Profile ID is a key field that is used to reference the details of a Contact Method in various CM tables.