HRS_EE_REF_ELIG

(SQL Table)
 Index Back

Employee Referral Eligibility

This record maintains employee eligibility information.

  • Parent Record Of HRS_EEELADT_HST HRS_EE_ELG_APDT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    3 HRS_PROFILE_SEQ Number(3,0) SMALLINT NOT NULL Profile sequece
    4 REFERRAL_PGM_ID Character(12) VARCHAR2(12) NOT NULL Employee referral program ID

    Prompt Table: HRS_REF_PGM

    5 EVENT_TYPE_ER Character(1) VARCHAR2(1) NOT NULL Recruiting Event Type
    A=Award Eligibility Rule
    G=General Eligibility Criteria
    H=Hire Eligibility Rule
    M=Manual Override
    R=Referral Eligibility Rule
    6 EVENT_DT Date(10) DATE Event Date
    7 ELIGIBILITY_STATUS Character(1) VARCHAR2(1) NOT NULL ERP Eligibility Status
    E=Eligible
    I=Ineligible
    8 CREATION_DT Date(10) DATE Creation Date
    9 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    10 PROCESSED Character(1) VARCHAR2(1) NOT NULL Processed?
    I=In Process
    N=Not Processed
    Y=Processed
    11 REPROCESS_ER Character(1) VARCHAR2(1) NOT NULL Reprocess

    Y/N Table Edit

    12 REPROCESS_ALL_ER Character(1) VARCHAR2(1) NOT NULL Reprocess Eligibility/Awards

    Y/N Table Edit

    Default Value: N

    13 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    14 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    15 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    16 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id