HRS_DUPE_STATUS (SQL View)	Index Back
Duplicate Set Person Matches Duplicate Set Person Matches

HRS_DUPE_STATUS

(SQL View)

Duplicate Set Person Matches

SELECT DISTINCT A.STATUS_CODE FROM PS_HRS_STS_TBL A , PS_HRS_APPLICANT B WHERE A.STATUS_CODE = B.STATUS_CODE AND A.STATUS_AREA = '2' AND A.OPEN_STS_IND = 'Y'

Parent record: HRS_DUPE_SET

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Identifies a status.