Redwood Experience: Calculate Rank Score Using Fast Formulas
You can write fast formulas to calculate a rank score for job applications. A new formula type is available: Recruiting Job Application Rank Score
These new database items are available when you create fast formulas.
Database Items
| Database Item | Type | Description |
|---|---|---|
|
IRC_CSP_JOBAPP_RIF_QSTNR_CODE |
Text value and number index array | Request information flow questionnaire answered by the candidate - Code |
| IRC_CSP_JOBAPP_RIF_QSTNR_VERSION | Number value and number index array | Request information flow questionnaire answered by the candidate - Version |
| IRC_CSP_JOBAPP_RIF_QSTNR_SCORE | Number value and number index array | Score obtained by the candidate for a request information flow questionnaire |
| IRC_CSP_JOBAPP_RIF_QSTNR_MAX_SCORE | Number value and number index array | Maximum score for a request information flow questionnaire |
| IRC_CSP_JOBAPP_PROFILE_AI_SCORE | Number | Candidate profile AI score |
| IRC_CSP_JOBAPP_EXPERIENCE_AI_SCORE | Number | Candidate work experience AI score |
| IRC_CSP_JOBAPP_EDUCATION_AI_SCORE | Number | Candidate education AI score |
| IRC_CSP_JOBAPP_SKILLS_AI_SCORE | Number |
Candidate skills AI score |
NOTE: These database items are also available for these formula types: Recruiting Candidate Selection Process, Recruiting Job Application Computed Field.
Here’s an example of a fast formula to calculate job application rank based on the interview feedback questionnaire score.
Example of a Fast Formula to Calculate Job Application Rank
Here’s an example of a fast formula to calculate job application rank using AI database items.
Example of a Fast Formula to Calculate Job Application Rank
Here’s an example of a fast formula to calculate job application rank based on the questionnaire used to request more info to candidates.
Example of a Fast Formula to Calculate Job Application Rank
A new action called Calculate Rank Score can be added to candidate selection processes to define triggers where rank score is calculated. You can add the action to different phases and states and you can use rank score fast formulas as conditions. When job applications reach the phase or state, the rank is calculated automatically using the fast formula and the score is displayed on the job applications list and details page.
Calculate Rank Score Action
With this feature, you can use fast formulas to calculate a rank score for job applications to help users reviewing job applications.
Steps to Enable
You create fast formulas in My Client Groups > Fast Formulas. For details, see Overview of Using Fast Formulas.
When you add the new Calculate Rank Score action to phases and states in a candidate selection process, you can select the fast formula you created as a condition. For details, see How do I configure candidate selection processes with actions and conditions?
To display rank scores in Redwood, you need enable these profile options:
- ORA_IRC_RECRUITING_REDWOOD_ENABLED
- ORA_IRC_JOB_APPLICATION_REDWOOD_ENABLED
- ORA_IRC_CANDIDATE_REDWOOD_ENABLED
For details, see How do I enable a profile option?
For details on enabling and customizing Redwood for HCM, see How do I adopt Redwood for HCM? and Extending Redwood Applications for HCM and SCM Using Visual Builder Studio.
Key Resources
For a complete list of database items, see Database Items for Oracle Recruiting Cloud Fast Formulas on My Oracle Support (MOS ID 2723251.1).