Send Additional Screening Results Using Job Application Flexfields

You can allow your screening partners to send additional screening results using candidate job application flexfields.

Discuss with your assessment, tax credit, and background check screening partners if they want to support additional job application flexfields for screening results. If that’s the case, you need to configure these additional job application flexfields for the result payload per partner.

When the flexfields are configured, the additional results and values are displayed in the job application’s Screening Results tab. Recruiters can add these additional fields to the job application grid view and filters. The fields aren’t available in the candidate detail’s view, where only assessment standard fields are displayed. In the grid view Compound Field section, all segments including hidden ones are displayed when the context is selected.

Here's what to do:

1. Create Multi-Row Flexfield Context for Job Candidate Application Usage
2. Create Value Sets
3. Associate Context to Partner
4. Input Payload for Partners

Create Multi-Row Flexfield Context for Job Candidate Application Usage

To support additional results, you need to create a multi-row flexfield context using the extensible flexfield called Person EIT Information.

• You can only select one multi-row context per partner.
• You need to create the hidden fields PROVISIONING_ID and PACKAGE_RESULT_ID to support the partner and package.
• You can create up to 25 additional result fields for each context.
• You can only use text, number, and date format:
  • Date time isn’t supported.
  • Date must be sent by the partner using the ISO-8601 format YYYY-MM-DD

1. In the Setup and Maintenance work area, search for the task Manage Person Extensible Flexfield.
2. On the Manage Person Extensible Flexfield page, select the extensible flexfield called Person EIT Information.
3. Click the Edit icon.
4. On the Manage Person Extensible Flexfield page, click Manage Contexts.
5. On the Manage Contexts page, you create one multi-row context per partner supporting those additional result fields.
6. In the Context Usages tab, click the Create icon and select the usage Usage code for candidate application.
7. In the Context Sensitive Segments section, click the Create icon.
8. Create the mandatory segments in the context using values provided in the following table.
9. Click Save and Close.

Note: PROVISIONING_ID and PACKAGE_RESULT_ID must be configured as hidden.

Name	Code	API Name	Unique Key	Enabled	Data Type	Table Column	Value Set	Prompt	Display Type
Partner Name	PROVISIONING_ID	provisioningId	No	Yes	NUMBER	PEI_INFORMATION_NUMBER1	PartnerNameLovValueSet	Partner Name	Hidden
Package Result Identifier	PACKAGE_RESULT_ID	packageResultId	Yes	Yes	NUMBER	PEI_INFORMATION_NUMBER2	15 Digit Number	Package Result Identifier	Hidden
Package Name	PACKAGE_CODE	packageCode	No	Yes	CHARACTER	PEI_INFORMATION1	BGCPackageNameLovValueSet or AssessmentPackageNameLovValueSet or TaxCreditsPackageNameLovValueSet	Package Name	List of values

In addition, you can create up to 25 result fields, using those 3 supported formats:

• Date Segments: You can use the ORA_FND_FLEX_DEFAULT_FORMAT_ONLY_DATE value set, or you can define your own value set with minimum and maximum date validation. Date time isn’t supported. The partner needs to send date data in the ISO-8601 format YYYY-MM-DD.
• Number Segments: You can use the FND_NUMBER15 value set, or you can define your own with different precision/scale to support integer and decimal numbers.
• Char Segments: You can use the FND_CHAR100 value set, or you can define your own value set. The maximum number of characters allowed is 150.

Create Value Sets

You need to create value sets for the Partner Name, Package Name, Package Result Identifier.

1. In the Context Sensitive Segments section, select the context sensitive segment you created and click Edit.
2. Click Create Value Set.
3. Enter the required values as indicated in the following tables.
4. Click Save and Close.

Partner Name table-value set
Module	Recruiting
Validation Type	Table
Value Data Type	Number
FROM Clause	FUSION.IRC_TP_PARTNERS PRTNR,FUSION.IRC_TP_PARTNER_PROVISNGS PRTNR_PROV
Value Column Name	PRTNR_PROV.PROVISIONING_ID
Description Column Name	PRTNR.NAME
WHERE Clause	PRTNR.PARTNER_ID = PRTNR_PROV.PARTNER_ID

Assessment partner package LOV value set for AssessmentPackageNameLovValueSet
Module	Recruiting
Validation Type	Table
Value Data Type	Number
FROM Clause	(SELECT DISTINCT A.PACKAGE_CODE,A.PACKAGE_NAME,B.PROVISIONING_ID FROM FUSION.IRC_ASMT_ACCT_PACKAGES A,FUSION.IRC_TP_PARTNER_ACCOUNTS B WHERE A.ACCOUNT_ID=B.ACCOUNT_ID) PKG,FUSION.IRC_ASMT_PARTNER_CONFIG PC
Value Column Name	PACKAGE_CODE
Description Column Name	PACKAGE_NAME
WHERE Clause	PC.PROVISIONING_ID =PKG.PROVISIONING_ID AND PC.RESULTS_FLEX_CONTEXT_CODE=’ASMT_FLEX_CONTEXT’ Note: ASMT_FLEX_CONTEXT is the context code for which you are creating Segments. It will vary depend on the context code you created.
Order By	PACKAGE_CODE

Background check partner package LOV value set for BGCPackageNameLovValueSet
Module	Recruiting
Validation Type	Table
Value Data Type	Number
FROM Clause	(SELECT DISTINCT A.SCR_PKG_CODE,A.SCR_PKG_NAME,B.PROVISIONING_ID FROM FUSION.irc_bc_acct_sp_assgmnts A,FUSION.IRC_TP_PARTNER_ACCOUNTS B WHERE A.ACCOUNT_ID=B.ACCOUNT_ID) PKG,FUSION.IRC_BC_ACTIVATION_CONFIG PC
Value Column Name	SCR_PKG_CODE
Description Column Name	SCR_PKG_NAME
WHERE Clause	PC.PROVISIONING_ID =PKG.PROVISIONING_ID AND PC.RESULTS_FLEX_CONTEXT_CODE=’BGC_FLEX_CONTEXT’ Note: BGC_FLEX_CONTEXT is the context code for which you are creating Segments. It will vary depend on the context code you created.
Order By	SCR_PKG_CODE

Tax credit partner package LOV value set for TaxCreditsPackageNameLovValueSet
Module	Recruiting
Validation Type	Table
Value Data Type	Number
FROM Clause	(SELECT DISTINCT A.PACKAGE_CODE,A.PACKAGE_NAME,B.PROVISIONING_ID FROM FUSION.IRC_TC_ACCOUNT_PACKAGES A,FUSION.IRC_TP_PARTNER_ACCOUNTS B WHERE A.ACCOUNT_ID=B.ACCOUNT_ID)PKG, FUSION.IRC_TC_PARTNER_CONFIG PC
Value Column Name	PACKAGE_CODE
Description Column Name	PACKAGE_NAME
WHERE Clause	PC.PROVISIONING_ID =PKG.PROVISIONING_ID AND PC.RESULTS_FLEX_CONTEXT_CODE='TAX_RESULTS_FLEX_CONTEXT’ TAX_RESULTS_FLEX_CONTEXT is the context code for which you are creating Segments. It will vary depend on the context code you created.
Order By	PACKAGE_CODE

Associate Context to Partner

When the context configuration is done, you need to associate the context to the partner.

1. In the Setup and Maintenance work area, go to:
   • Offering: Recruiting and Candidate Experience
   • Functional Area: Recruiting and Candidate Experience Management
   • Task: Recruiting Category Provisioning and Configuration
2. On the Partner Integration Provisioning page, locate the partner and click the Edit icon.
3. Select the context in the Context for Additional Results field.
4. Click Save.

Input Payload for Partners

With this newly associated context, the partner can start to send additional results into those defined segments. For details, refer to the Partner Integration technical briefs available on My Oracle Support (ID 2627681.1).