HRS_DUPEMRG_LN

(SQL View)
Index Back

Related Language Record

Related Language Record for HRS_DUPEMRG_VW

SELECT A.HRS_PERSON_ID ,O.HRS_OFF_ID ,B.LANGUAGE_CD , B.FIRST_NAME , B.MIDDLE_NAME , B.LAST_NAME FROM PS_HRS_APPLICANT A INNER JOIN PS_HRS_OFFER O ON O.HRS_PERSON_ID = A.HRS_PERSON_ID LEFT OUTER JOIN PS_HRS_APP_NAME_LN B ON B.HRS_PERSON_ID = A.HRS_PERSON_ID

  • Related Language Record for HRS_DUPEMRG_VW
  • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    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