Oracle Fusion Data Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion Data Intelligence› Oracle Fusion Data Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Recruitment Time in Stage

Accepted answer
21
Views
2
Comments
Nathan Yeager
Nathan Yeager Rank 0 - Community Observer
in Oracle Fusion Data Intelligence

Does anyone have a dashboard for time in each stage of the recruitment process including: Apply to phone screen, phone screen to interview, interview to offer, and offer to start?

Tagged:

Best Answer

  • Gina DiVenti
    Gina DiVenti Rank 5 - Community Champion
    edited Oct 31, 2025 7:10PM Answer ✓

    Have you explored the phase and state completion duration metrics? These are really great for tracking how long the candidates are in each phase and state.

    image.png

    We have also built custom calculations that measure the time difference between two Oracle dates (we had to explore different aggregation methods to make these accurate, so be careful to validate closely):

    Avg (TIMESTAMPDIFF(SQL_TSI_DAY,"HCM - Talent Acquisition"."Job Application - Dates"."Job Application Submitted Date","HCM - Talent Acquisition"."Job Offer - Basic Information"."Accepted Date"))

    If there isn't a date tracked in the system but a phase or state is changed, we have also had success using the date the phase or state is activated:

    AVG(
    CASE
    WHEN "HCM - Talent Acquisition"."Recruiting History Event Type"."Event Type Name" = 'State Activated'
    AND "HCM - Talent Acquisition"."Recruiting State"."State Name" = 'Selected for Offer'
    THEN TIMESTAMPDIFF(
    SQL_TSI_DAY,
    "HCM - Talent Acquisition"."Job Application - Dates"."Job Application Submitted Date",
    "HCM - Talent Acquisition"."Time"."Date"
    )
    ELSE NULL
    END
    )

Answers