HRS_DUPE_VW

(SQL View)
 Index Back

Duplicate Set Person Matches

Duplicate Set Person Matches

SELECT HRS_DUPE_PRCS_ID , HRS_DUPE_SET_ID , DUPE.HRS_PERSON_ID , FIRST_NAME , MIDDLE_NAME , LAST_NAME , EMAIL_ADDR ,PHONE , ADDRESS1 , ADDRESS2 , ADDRESS3 ,ADDRESS4 ,CITY ,STATE ,COUNTRY ,POSTAL , HRS_DUPE_REL , HRS_DUPE_PARENT , APP.STATUS_CODE FROM PS_HRS_DUPE_PERSON DUPE , PS_HRS_APP_DTL APP WHERE DUPE.HRS_PERSON_ID = APP.HRS_PERSON_ID

  • Parent record: HRS_DUPE_SET

    • # 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 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
    5 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME
    6 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    7 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address
    8 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
    9 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    10 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    11 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    12 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    13 CITY Character(30) VARCHAR2(30) NOT NULL City
    14 STATE Character(6) VARCHAR2(6) NOT NULL State
    15 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    16 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    17 HRS_DUPE_REL Character(2) VARCHAR2(2) NOT NULL Duplicate Relationship
    10=Target
    20=Source
    18 HRS_DUPE_PARENT Number(15,0) DECIMAL(15) NOT NULL Target

    Prompt Table: HRS_DUPE_PRNT_P

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