HRS_APP_DTL

(SQL View)
 Index Back

Duplicate Set Person Matches

Duplicate Set Person Matches

SELECT APP.HRS_PERSON_ID , ( SELECT FIRST_NAME FROM PS_HRS_APP_NAME_I NAME1 WHERE APP.HRS_PERSON_ID = NAME1.HRS_PERSON_ID ) FIRST_NAME , ( SELECT MIDDLE_NAME FROM PS_HRS_APP_NAME_I NAME1 WHERE APP.HRS_PERSON_ID = NAME1.HRS_PERSON_ID ) MIDDLE_NAME, ( SELECT LAST_NAME FROM PS_HRS_APP_NAME_I NAME1 WHERE APP.HRS_PERSON_ID = NAME1.HRS_PERSON_ID ) LAST_NAME, ( SELECT EMAIL_ADDR FROM PS_HRS_APP_EMAIL_I EML WHERE APP.HRS_PERSON_ID = EML.HRS_PERSON_ID ) EMAIL_ADDR, ( SELECT PHONE FROM PS_HRS_APP_PHONE_I PHON WHERE APP.HRS_PERSON_ID = PHON.HRS_PERSON_ID ) PHONE, ( SELECT ADDRESS1 FROM PS_HRS_APP_ADDRESS ADDR WHERE ADDR.HRS_PERSON_ID = APP.HRS_PERSON_ID AND ADDRESS_TYPE ='HOME') ADDRESS1, ( SELECT ADDRESS2 FROM PS_HRS_APP_ADDRESS ADDR WHERE ADDR.HRS_PERSON_ID = APP.HRS_PERSON_ID AND ADDRESS_TYPE ='HOME') ADDRESS2, ( SELECT ADDRESS3 FROM PS_HRS_APP_ADDRESS ADDR WHERE ADDR.HRS_PERSON_ID = APP.HRS_PERSON_ID AND ADDRESS_TYPE ='HOME') ADDRESS3, ( SELECT ADDRESS4 FROM PS_HRS_APP_ADDRESS ADDR WHERE ADDR.HRS_PERSON_ID = APP.HRS_PERSON_ID AND ADDRESS_TYPE ='HOME') ADDRESS4, ( SELECT CITY FROM PS_HRS_APP_ADDRESS ADDR WHERE ADDR.HRS_PERSON_ID = APP.HRS_PERSON_ID AND ADDRESS_TYPE ='HOME') CITY, ( SELECT STATE FROM PS_HRS_APP_ADDRESS ADDR WHERE ADDR.HRS_PERSON_ID = APP.HRS_PERSON_ID AND ADDRESS_TYPE ='HOME') STATE, ( SELECT COUNTRY FROM PS_HRS_APP_ADDRESS ADDR WHERE ADDR.HRS_PERSON_ID = APP.HRS_PERSON_ID AND ADDRESS_TYPE ='HOME') COUNTRY, ( SELECT POSTAL FROM PS_HRS_APP_ADDRESS ADDR WHERE ADDR.HRS_PERSON_ID = APP.HRS_PERSON_ID AND ADDRESS_TYPE ='HOME') POSTAL, STATUS_CODE FROM PS_HRS_APPLICANT APP

  • Parent record: HRS_DUPE_SET

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    2 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
    3 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME
    4 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    5 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address
    6 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
    7 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    8 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    9 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    10 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    11 CITY Character(30) VARCHAR2(30) NOT NULL City
    12 STATE Character(6) VARCHAR2(6) NOT NULL State
    13 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    14 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    15 STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Identifies a status.