HRS_BIP_REF_VW

(SQL View)
 Index Back

Applicant References View

Retrieves applicant references for apply on line ss transaction.

SELECT A.HRS_PERSON_ID , A.HRS_REFERENCE_NUM , A.DT_CONTACTD , A.REFERENCE_TYPE , A.REF_NAME , A.REF_TITLE , A.EMPLOYER , A.EMAIL_ADDR FROM PS_HRS_APP_REF A

  • Related Language Record: HRS_APP_REF_LVW

    • # 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_REFERENCE_NUM Character(15) VARCHAR2(15) NOT NULL reference number
    3 DT_CONTACTD Date(10) DATE NOT NULL Date Contacted

    Default Value: %date

    4 REFERENCE_TYPE Character(1) VARCHAR2(1) NOT NULL Reference Type
    1=Professional
    2=Personal
    3=Both

    Default Value: 1

    5 HRS_REF_NAME Character(50) VARCHAR2(50) NOT NULL Reference Name
    6 REF_TITLE Character(30) VARCHAR2(30) NOT NULL Title
    7 EMPLOYER Character(30) VARCHAR2(30) NOT NULL Employer
    8 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address