HRS_DUPE_PRNT_P

(SQL View)
 Index Back

SELECT A.HRS_PERSON_ID , B.HRS_PERSON_ID FROM PS_HRS_DUPE_PERSON A , PS_HRS_DUPE_PERSON B WHERE A.HRS_DUPE_PRCS_ID=B.HRS_DUPE_PRCS_ID AND A.HRS_DUPE_SET_ID=B.HRS_DUPE_SET_ID AND B.HRS_DUPE_REL='10'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
2 HRS_DUPE_PARENT Number(15,0) DECIMAL(15) NOT NULL Target