Configure Job Offer Flexfields to Get Default Values

You can configure any of the offer's flexfields to be created with default values pulled from existing information about the candidate or about the requisition for which they're being recruited.

When you enable this feature, recruiters create job offers with initial flexfield values based upon values from the requisition or the candidate who is receiving the offer. This saves time and reduces errors made in manually entering the information.

You need to configure which offer flexfields will get default values. Two parameters are available to create SQL queries which affect these fields:

• SUBMISSION_ID, which refers to the job application and thus to the requisition

• PERSON_ID, which refers to the candidate who will be the offer recipient

To configure the defaulting behavior from the requisition or candidate into a newly-created offer, the offer's flexfields must be defined as the same data type and value set as the fields from which their values will come. Then custom SQL code can specify the initial default of any offer's flexfield based on the requisition field or person field.

1. In the Setup and Maintenance work area, go to:

   • Offering: Recruiting and Candidate Experience

   • Functional Area: Job Offers

   • Task: Job Offers Descriptive Flexfields

2. On the Job Offers Descriptive Flexfields page, select any existing flexfield and click the Edit icon.

3. In the Edit Segment page, in the Initial Default section, select the value SQL in the field Initial Default Type.

4. In the Default Value area, you need to configure the source of this flexfield's default value. These two parameters are available to create an SQL query or Parameter query:

   • SUBMISSION_ID, which refers to the job application and thus to the requisition

   • PERSON_ID, which refers to the candidate who will be the offer recipient

5. Click Save and Close.

Here is an example of an SQL query which can be pasted into that Default Value area. The purpose of this example is to identify the offer's related requisition, and then to pull the current value from its flexfield in Attribute Number 1 into the current offer flexfield.

SELECT REQ.ATTRIBUTE_NUMBER1 FROM IRC_REQUISITIONS_B REQ, IRC_SUBMISSIONS SUB

WHERE REQ.REQUISITION_ID = SUB.REQUISITION_ID

AND SUB.SUBMISSION_ID = :{PARAMETER.SUBMISSION_ID}