BO_IDBO_ID_1PIM_PDUP_VW2(SQL View) |
Index Back |
|---|---|
Potential Duplicate List ViewThis record is used to store potential duplicate business objects for a contact/consumer. |
| SELECT BO_ID , BO_ID_1 , ROLE_TYPE_ID , MATCH_SCORE_NUM FROM %Table(PIM_PDUP_LIST) |
| # | 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 | BO_ID_1 |
Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID 1 |
| 3 | ROLE_TYPE_ID | Number(12,0) | DECIMAL(12) NOT NULL | Role Type ID |
| 4 | MATCH_SCORE_NUM | Number(3,0) | SMALLINT NOT NULL | Duplicate match score percentage |