HRS_EE_REFERRAL

(SQL Table)
 Index Back

eRecruit Referral Record

This record stores general data about employee referrals made through eRecruit.

  • Parent Record Of HRS_EEREFJO_HST HRS_EE_REF_JO HRS_EE_RF_J_VW HRS_REF_JO_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_PROFILE_SEQ Number(3,0) SMALLINT NOT NULL Profile sequece
    3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON_NAME

    4 HRS_AL_LOG_SRC_SEQ Number(15,0) DECIMAL(15) NOT NULL Unique Identifier - For Log Source
    5 REFERRAL_DTTM DateTime(26) TIMESTAMP Referral Time Stamp

    Default Value: %DateTime

    6 REFERRAL_ID Character(20) VARCHAR2(20) NOT NULL Referral Track ID
    7 REFERRAL_PWD Character(6) VARCHAR2(6) NOT NULL Referral Password
    8 APPL_EMPLID Character(11) VARCHAR2(11) NOT NULL Applicant Employee ID
    9 APPL_EMPL_RCD Number(3,0) SMALLINT NOT NULL Applicant Empl Record
    10 HIRE_DT Date(10) DATE First Start Date
    11 HRS_JO_ID_HIRED Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone

    Prompt Table: HRS_JOB_OPENING

    12 PREV_TERM_DT Date(10) DATE Previous Termination Date
    13 REFERRER_NAME Character(50) VARCHAR2(50) NOT NULL Referral Name
    14 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address
    15 PREV_EMPL_BY_COMPY Character(1) VARCHAR2(1) NOT NULL Previously Employed by Company
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    16 APP_IS_FAMILY Character(1) VARCHAR2(1) NOT NULL Applicant is a Family Member
    N=No
    Y=Yes

    Default Value: N

    17 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    18 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    19 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    20 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id