BO_ID_FROMBO_ID_TOMERGE_IDRDH_MRGHSTLG_VW(SQL View) |
Index Back |
|---|---|
Merge History and Merge LogThis is a combined view of merge history and merge log. |
| SELECT A.BO_ID_FROM , A.BO_ID_TO , A.MERGE_ID , A.MERGE_DTTM , B.MERGE_HANDLER_ID , B.MERGE_EXCEPT_DTTM , B.MERGE_EXCEPT_LOG FROM PS_RDH_MERGE_HIST A , PS_RDH_MERGE_LOG B WHERE B.BO_ID_TO = A.BO_ID_TO AND B.BO_ID_FROM = A.BO_ID_FROM AND B.MERGE_ID = A.MERGE_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BO_ID_FROM |
Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 2 | BO_ID_TO |
Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 3 | MERGE_ID |
Number(15,0) | DECIMAL(15) NOT NULL | CDH Batch Merge ID |
| 4 | MERGE_DTTM | DateTime(26) | TIMESTAMP | This is the field for the merge event date time. |
| 5 | MERGE_HANDLER_ID | Character(167) | VARCHAR2(167) NOT NULL | Application Class Full Path of the Merge Handler |
| 6 | MERGE_EXCEPT_DTTM | DateTime(26) | TIMESTAMP | Merge Exception DateTime |
| 7 | MERGE_EXCEPT_LOG | Long Character | CLOB | Merge Exception Log |