HRS_DUPE_PRCS_IDHRS_DUPE_SET_IDHRS_PERSON_ID10=Target
20=Source
Prompt Table: HRS_DUPE_PRNT_P
HRS_DUPE_PERSON(SQL Table) |
Index Back |
|---|---|
Duplicate Set Person MatchesDuplicate Set Person Matches |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_DUPE_PRCS_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Duplicate Process ID |
| 2 | HRS_DUPE_SET_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Duplicate Set ID |
| 3 | HRS_PERSON_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Person Id |
| 4 | HRS_DUPE_REL | Character(2) | VARCHAR2(2) NOT NULL |
Duplicate Relationship
10=Target 20=Source |
| 5 | HRS_DUPE_PARENT | Number(15,0) | DECIMAL(15) NOT NULL |
Target
Prompt Table: HRS_DUPE_PRNT_P |