Setting Up Employee Referral Programs

This topic provides an overview of employee referral program setup steps and discusses how to define employee referral programs, including eligibility rules and awards.

Page Name

Definition Name

Usage

Employee Eligibility Rules Page

HRS_RULE_DEF

Name employee eligibility rules.

Referral Eligibility Rules - Rule SQL Page

HRS_RULE_SQL

Create SQL statements for employee eligibility rules.

View SQL Page

HRS_VW_SQL

View a SQL statement that the system generates from information that you enter to define an eligibility rule, an award rule, or hot job selection.

Award Category Rules Page

HRS_RULE_DEF

Name award category rules.

Referral Category Rules - Rule SQL Page

HRS_RULE_SQL

Create SQL statements for award category rules.

Award Schedule Page

HRS_RULE_AWD_SCH

Define award schedules.

Employee Referral Programs Page

HRS_REF_PGM_PG

Define employee referral programs.

Employee Referral Program - Criteria Page

HRS_REF_PGM_CRT

Define additional criteria that are not covered by employee eligibility or award category rules.

Employee Referral Program - Rules Page

HRS_REF_PGM_RUL

Select employee eligibility and award category rules that are in effect for the program.

Employee Eligibility Rule Page

HRS_RULE_ELIG_SP

View the employee eligibility rule description from the context of the Employee Referral Program - Rules page. The eligibility rule description comes from the Long Description field on the Employee Eligibility Rules page.

Award Category Rule Page

HRS_RULE_AWD_SP

View the award category rule description from the context of the Employee Referral Program – Rules page. The award category rule description comes from the Long Description field on the Award Category Rules page.

The following diagram shows how to set up employee referral programs by defining employee eligibility rules and award category rules, using those rules to create referral programs, and linking the programs to recruitment templates:

This diagram illustrates the process for setting up employee referral programs and linking the programs to recruitment templates

Process for setting up employee referral programs and linking the programs to recruitment templates

To set up employee referral programs:

  1. Define employee eligibility rules using the Referral Eligibility Rules (HRS_RULE_ELIG) component.

    Employee eligibility rules define the conditions under which an employee is eligible for award payment under the employee referral program. For example, you might want to limit eligibility to employees who work in a particular geographic area or type of job. You might want to exclude employees in certain departments or locations. You can create a rule that combines a number of criteria to determine employee eligibility.

    To define employee eligibility rules:

    1. Name and describe the employee eligibility rule on the Employee Eligibility Rules page.

    2. Create SQL statements for the employee eligibility rule on the Referral Eligibility Rules - Rule SQL page.

  2. Define award category rules using the Award Category Rules (HRS_RULE_AWD) component.

    When you define the award category rules, you're defining the job openings that qualify for awards in the category and the amounts and timing of awards for the category. You can create any number of award categories, each with an award schedule. The job opening that the applicant is hired into determines the award category for the referring employee's award.

    You should define categories so that each job opening (for which you want to have an employee referral program award) falls into only one category. Job openings that do not fall into any category cannot be processed for employee referrals.

    To define award category rules:

    1. Name and describe the award category rule on the Award Category Rules page.

    2. Create SQL statements for the employee eligibility rule on the Referral Category Rules - Rule SQL page.

    3. Define the amounts, timing, and earnings code for the rule on the Award Schedule page.

  3. Define employee referral programs using the Employee Referral Program (HRS_REF_PGM) component.

    To define employee referral programs:

    1. Name the employee referral programs.

    2. Set up additional criteria.

    3. Link employee eligibility and award category rules.

  4. Associate an employee referral program with a recruitment template using the Recruitment Template (HRS_RCTR_TMPL) component.

    By linking a referral program to a recruitment template, the system will automatically associate a referral program with a job opening when the job opening is created. In turn, the system uses this employee referral program's rules to evaluate eligibility and pay awards for the job opening.

Use the Employee Eligibility Rules page (HRS_RULE_DEF) to name and describe an employee eligibility rule.

Navigation:

Set Up HCM > Product Related > Recruiting > Recruitment Sources > Referral Eligibility Rules > Employee Eligibility Rules

This example illustrates the Employee Eligibility Rules page.

Employee Eligibility Rules page

Field or Control

Description

Long Description

Enter a description of the employee eligibility rule. This description appears on the Employee Eligibility Rule page in the Employee Referral Program component.

Use the Referral Eligibility Rules - Rule SQL page (HRS_RULE_SQL) to create SQL statements for employee eligibility rules.

Navigation:

Set Up HCM > Product Related > Recruiting > Recruitment Sources > Referral Eligibility Rules > Rule SQL

This example illustrates the Referral Eligibility Rules - Rule SQL page.

Employee Eligibility Rules - Rule SQL page

Field or Control

Description

Open ( and Close ) (open and close parentheses)

Use these fields to add parentheses around clauses in your selection criteria. The drop-down list box offers separate values with one to five parentheses so that you can create nested groups of clauses.

Important! Be sure to properly close all parentheses.

Record and Field

Select the record and field that hold the data to be evaluated.

Select one of these records:

  • HRS_EMPLOYMT_I contains four employment-related fields: hire date, last date worked, rehire date, and termination date.

  • HRS_JOB_I2 contains several job-related fields, including (but not limited to) action, action reason, business unit, company, department, employee type, pay group, regulatory region, full time/part time status, regular/temporary status, and standard hours.

Operator

Enter the operator to indicate how you are going to evaluate the data in the selected field. Select from these options:

  • Equal To

  • Greater Than

  • Greater Than or Equal to

  • LIKE

  • Less Than

  • Less Than or Equal To

  • Not Equal To

Set ID

If setID is a key for the record and field that you selected, select the setID for the value that the clause evaluates.

This field does not appear if setID is not a key.

Action

If you are evaluating data in the Action/Reason field (that is, you selected HRS_JOB_I2 as the record and ACTION_REASON as the field), use this field to select an action.

Value

Enter a value that corresponds with the record, field, and operand that you selected. You can enter either a static string or select a value from a list of valid values for the field. When selecting from a list, you are limited to values from the setID, if any, that you entered.

If you are evaluating the Action/Reason field, select a reason that is associated with the action you selected.

Boolean

For every grid row except the last one, select AND or OR to link the clauses in the grid.

View SQL

Click to access the View SQL page, where you can view the SQL generated by the values that you entered for this rule definition.

Use the Award Category Rules page (HRS_RULE_DEF) to name award category rules.

Navigation:

Set Up HCM > Product Related > Recruiting > Recruitment Sources > Referral Category Rules > Award Category Rules

This example illustrates the Award Category Rules page.

Award Category Rules page

Field or Control

Description

Long Description

Enter a description of the award category rule. This description appears on the Award Category Rule page in the Employee Referral Program component.

Use the Referral Category Rules - Rule SQL page (HRS_RULE_SQL) to create SQL statements for award category rules.

Navigation:

Set Up HCM > Product Related > Recruiting > Recruitment Sources > Referral Category Rules > Rule SQL

This example illustrates the Referral Category Rules - Rule SQL page.

Referral Category Rules - Rule SQL page

The steps that you use to construct a rule are the same as the steps that you use on the Referral Eligibility Rules - Rule SQL page.

For award category rules, the records are HRS_EMPLOYMT_I, HRS_JOB_I2, HRS_JO_I, or HRS_PSTBTH_I.

See Referral Eligibility Rules - Rule SQL Page.

Use the Award Schedule page (HRS_RULE_AWD_SCH) to define award schedules.

Navigation:

Set Up HCM > Product Related > Recruiting > Recruitment Sources > Referral Category Rules > Award Schedule

This example illustrates the Award Schedule page.

Award Schedule page

Field or Control

Description

Currency Code

Select the currency that is used to define awards in this category. Valid values are Canadian Dollar and US Dollar. You can override the currency on the Referral Award Details page.

Important! Employee referral program rewards are paid to employees in the currency that corresponds to where the employee is located. Recruiting Solutions and PeopleSoft Payroll for North America do not provide currency conversion. For example, if you define the award as 100.00 CAD, but the employee that receives the award is normally paid in US dollars, Payroll for North America will pay an award of 100.00 USD to the employee.

Award Total

Displays the total of all awards in the schedule. Click the refresh button to update the award total.

Earnings Code

If you use the delivered integration with Payroll for North America to pay employee referral award, you must select the earnings code associated with the award. This field appears only if Payroll for North America is installed. Define earnings codes by using the Earnings Table (EARNINGS_TABLE) component.

Duration and Type

Enter the time period that the referring employee must wait until the award is payable. You can enter the time period in days, months, or years. To calculate the date on which the reward is payable, the system begins with the date that the applicant is hired or rehired and adds the duration time period. This is referred to as the award date and is the date on which the duration requirement is fulfilled; it is not necessarily the date on which the award is paid. If you use the delivered integration with Payroll for North America to pay employee referral award, the system will not send award information before the award date.

Award Value

Enter the amount of a cash award or the value of a noncash award.

Gross-Up

Select this check box if the award should be grossed up.

Use the Employee Referral Programs page (HRS_REF_PGM_PG) to define employee referral programs.

Navigation:

Set Up HCM > Product Related > Recruiting > Recruitment Sources > Employee Referral Program

This example illustrates the Employee Referral Programs page.

Employee Referral Programs page

Field or Control

Description

Effective Date

Enter an effective date. The system uses the effective date with the Use Program As Of field to determine the rules that are in effect for a referral.

Require Approval for Payment

Select this check box to require approval for an award before the award is sent to the payroll system. Awards that have an Approved status can be submitted for payment. If you select this option, the system assigns a Needs Approval status to an award when the award is created. Users must manually approve the award on the Approve Employee Awards page. If you deselect this check box, awards are automatically given Approved status when they are created.

Separate Check

Select this check box if you want the award paid separately from the employee's regular paycheck. If you are paying awards through Payroll for North America, all grossed-up awards are paid by a separate check.

Allow Dups to Exceed Original (allow duplicates to exceed original)

Select this check box if the total award can exceed the original award amount when an award is split among several referring employees.

Use Program As Of

Select which effective-dated program rules apply to the referral. Valid values are Applicant's Hire Date and Referral Date. The system applies all program rules that are in the effective-dated row that is active as of the Use Program As Of date. For example, an employee referred an applicant on December 1 and that applicant was hired on February 1 of the following year. However, the ERP rules changed on January 1 from $100 for all successful referrals before January 1 to $1000 for those on or after January 1. If the Use Program As Of field is set to Referral Date, the employee is entitled to only $100 since the referral was made before January 1. If the field is set to Applicants Hire Date, the employee is entitled to $1000 since the applicant was hired after January 1.

Note: This field is only available when a new employee referral program is created. After saving the employee referral program, the value in subsequent effective-dated rows cannot be changed.

Use the Employee Referral Program - Criteria page (HRS_REF_PGM_CRT) to define additional criteria that are not covered by employee eligibility or award category rules.

Navigation:

Set Up HCM > Product Related > Recruiting > Recruitment Sources > Employee Referral Program > Criteria

This example illustrates the Employee Referral Program - Criteria page.

Employee Referral Program - Criteria page

Limit Referral Life Span To

Field or Control

Description

Limit Interval and Limit Duration

Enter a time limit for how soon after the referral the applicant must be hired. The limit interval can be measured in Months, Years, or Days. The limit duration is the number of months, days, or years.

For example, if employees get referral credit for applicants who are hired within two months of the referral, enter Months as the limit interval and 2 as the limit duration.

Disqualify Award If

Use this group box to indicate conditions that disqualify the employee from the referral program.

Field or Control

Description

Applicant Reports to Employee

Select this check box to disqualify employees if the applicant reports to them directly or indirectly based on the department tree structure as of the applicant's hire date. If you use this rule, you must set up the department tree structure in PeopleSoft Human Resources.

Employee Exceeds Manager Level

Select a value to disqualify employees above the specified level. The system evaluates employee levels as of the applicant's hire date.

To make all managers ineligible, select All Other Positions.

If you use this rule, you must set up the department tree structure in Human Resources.

Applicant Criteria

Field or Control

Description

Allow Previous Employees

Select this check box to give referral credit for applicants who are previous employees. If you select this check box, you must complete the termination interval fields in this group box.

Termination Interval, Interval Duration, and Is Prior To

If you allow referral credit for previous employees, use these fields to define how long the applicant must have been away from the organization before being rehired. The system evaluates this criteria based on information that users provide when they refer friends online or information that recruiters enter for an applicant on the applicant data pages. It does not check the organization's historical records.

To allow credit for all rehires, regardless of the length of the break in service lasted, enter 0 in the Interval Duration field.

To set a minimum duration for the break in service, use the Termination Interval field to select Months,Days, or Years, and then enter the number of months, days, or years in the Interval Duration field. Use the Is Prior To field to indicate whether the Applicant's Hire Date or the Referral Date is used as the starting point for the look-back.

For example, if you allow referral credit for rehires only if the rehire was away for your organization at least six months before being referred, enter Months as the termination interval, 6 as the interval duration, and Referral Date as the Is Prior To setting.

Allow Family Member Referrals

Select this check box to allow employees to refer members of their family.

Use the Employee Referral Program - Rules page (HRS_REF_PGM_RUL) to select employee eligibility and award category rules that are in effect for the program.

Navigation:

Set Up HCM > Product Related > Recruiting > Recruitment Sources > Employee Referral Program > Rules

This example illustrates the Employee Referral Program - Rules page.

Employee Referral Program - Rules page

Employee Eligibility Rules

Field or Control

Description

When to Apply

Select when to apply each employee eligibility rule that you associate with this program. Valid values are Applicant's Hire Date, Award Date, and Referral Date. You can select each of the three values only once for a maximum of three rows. The system uses the rule that you associate with the award date to check eligibility before paying any award in the award category award schedule or in a hot job award schedule.

This field enables you to apply different employee eligibility rules at different points in the referral process. For example, you might want to apply strict employee eligibility rules at the time that the applicant is hired, but on the award date, you might only require that the employee have an Active status.

Rule ID and Description

Select the rule that you want to apply. The system populates the Description field automatically. Valid values are the rules that you set up in the Referral Eligibility Rules component.

View Description

Click to access the Employee Eligibility Rule page, where you can view the description that you entered in the Long Description field on the Employee Eligibility Rules page.

View Rule

Click to access the Referral Eligibility Rules component, where you defined the employee eligibility rule. Use your browser's back button to return to the Employee Referral Program - Rules page.

Award Category Rules

Field or Control

Description

Priority

Enter an integer in this field to tell the system in what order to process the award category rules. The system checks the job opening that the applicant is hired into against the category rules in the priority order. As soon as it finds the job opening in a category, it stops processing that job opening and applies the award schedule for that category.

You should make the award category rules mutually exclusive so that a job opening does not fall into multiple categories.

The system does contain safeguards against paying an employee in multiple award categories for the same applicant.

If a job opening does not fall into any award category, no awards are scheduled or paid.

Rule ID and Description

Select the rule that you want to apply. The system populates the Description field automatically. Valid values are the rules that you set up in the Award Category Rules component. You can assign as many rules to the program as you want, each with a unique priority number. Do not select the same rule more than once.

View Description

Click to access the Award Category Rule page, where you can view the description that you entered in the Long Description field on the Award Category Rules page.

View Rule

Click to access the Award Category Rules component, where you defined the award category rule. Use your browser's back button to return to the Employee Referral Program - Rules page.