Candidate Citizenship Information for Fast Formulas
You can use the candidate's citizenship information in fast formulas used as conditions in candidate selection processes.
When you create Recruiting Candidate Selection Process and Recruiting Job Application Computed Fields fast formulas, you can use these fields:
- Legislation Code
- Status
- Start Date
- End Date
Database Items
| Name | Type | Description |
|---|---|---|
| IRC_CSP_CANDIDATE_CITIZENSHIP_LEGISLATION_CODE | Text | Country code of the candidate’s citizenship. |
| IRC_CSP_CANDIDATE_CITIZENSHIP_START_DATE | Date | Start date of the candidate’s citizenship. |
| IRC_CSP_CANDIDATE_CITIZENSHIP_END_DATE | Date | End date of the candidate’s citizenship. |
| IRC_CSP_CANDIDATE_CITIZENSHIP_STATUS | Text | Status of the candidate’s citizenship - Code. |
Here's an example of a fast formula to return true if job application citizenship is Canada and Active. Possible values for this database item are the country codes defined in the "NATIONALITY" lookup type.
DEFAULT_DATA_VALUE FOR IRC_CSP_CANDIDATE_CITIZENSHIP_LEGISLATION_CODE IS 'N/A'
DEFAULT_DATA_VALUE FOR IRC_CSP_CANDIDATE_CITIZENSHIP_STATUS IS 'N/A'
CONDITION_RESULT='N'
i = 1
WHILE IRC_CSP_CANDIDATE_CITIZENSHIP_LEGISLATION_CODE.EXISTS(i)AND IRC_CSP_CANDIDATE_CITIZENSHIP_STATUS.EXISTS(i) LOOP
(
IF ( IRC_CSP_CANDIDATE_CITIZENSHIP_LEGISLATION_CODE[i] = 'CA' AND IRC_CSP_CANDIDATE_CITIZENSHIP_STATUS[i] = 'A') THEN(
CONDITION_RESULT= 'Y'
)
i=i+1
)
RETURN CONDITION_RESULT
Nationality Lookup
Nationality Lookup Codes
With this feature, you can perform automated actions or prevent progression of job applications based on the citizenship information of the candidate.
Steps to Enable
You don't need to do anything to enable this feature.
Key Resources
For a complete list of database items, see this document on My Oracle Support:
- Recruiting Database Items (MOS ID 2723251.1).
For more info on fast formulas, refer to this topic in the Implementing Recruiting guide on Oracle Help Center: