HRS_DUPEMRG_VW

(SQL View)
 Index Back

Duplicate Merge process


SELECT A.HRS_PERSON_ID ,O.HRS_OFF_ID , B.FIRST_NAME , B.MIDDLE_NAME , B.LAST_NAME ,C.EMAIL_ADDR , D.ADDRESS1 , D.ADDRESS2 , D.ADDRESS3 , D.ADDRESS4 , D.CITY , D.STATE , D.COUNTRY , D.POSTAL , O.OFFER_DT , S.DESCR ,'' ,'' FROM PS_HRS_APPLICANT A INNER JOIN PS_HRS_OFFER O ON O.HRS_PERSON_ID = A.HRS_PERSON_ID INNER JOIN PS_HRS_STS_OFF_I S ON S.STATUS_CODE = O.STATUS_CODE LEFT OUTER JOIN PS_HRS_APP_NAME_I B ON B.HRS_PERSON_ID = A.HRS_PERSON_ID LEFT OUTER JOIN PS_HRS_APP_EMAIL_I C ON C.HRS_PERSON_ID = A.HRS_PERSON_ID LEFT OUTER JOIN PS_HRS_APP_ADDR_I D ON D.HRS_PERSON_ID = A.HRS_PERSON_ID

  • Related Language Record: HRS_DUPEMRG_LN

    • # 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_OFF_ID Number(15,0) DECIMAL(15) NOT NULL Offer ID
    3 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
    4 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME
    5 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    6 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address
    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 OFFER_DT Date(10) DATE Offer Date
    16 HRS_OFF_STATUS Character(30) VARCHAR2(30) NOT NULL Offer status
    17 HRS_APPROVER_NM Character(200) VARCHAR2(200) NOT NULL Approver name
    18 HRS_APPR_DT Date(10) DATE Approved date