HRS_APP_EML_VW2

(SQL View)
 Index Back

Applicant Data - Email

Applicant Data - Email

SELECT A.HRS_PERSON_ID , EMAIL_ADDR FROM PS_HRS_APP_EMAIL A WHERE A.PREF_EMAIL_FLAG = 'Y'

  • Parent record: HRS_APPLICANT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    2 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address