Ability to know for how a long a job application is in a specific phase

Summary:

Ability to know via reporting (SQL, OTBI) for how long a job application is in a specific phase

Content (please ensure you mask any confidential information):

Hello All,

Is it possible know via reporting (SQL, OTBI) for how a long a job application is in a specific phase ? The objective is to send alerts to the recruiter if a job application is in specific phase for more than one day.

Thanks

Bernard

Version (include the version you are using, if applicable):

25C

Code Snippet (add any code snippets that support your topic, if applicable):