Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Best Practices for Time to Complete Application
Summary
OBI Reporting: Time To Complete Application for Retail Hourly ApplicationsContent
We are looking for best practices on reporting on time to complete application.
Currently our formula is the time (in minutes) between Submission Created Date and Submission Completed Date with a date range prompt on Submission Created Date. We are searching for the average time to complete (in minutes) over 12 months, however, we are running into instances where applicants start an application in one month and do not fully submit until months later, which causes our time to complete application to be longer than we anticipated.
Formula for Time to Complete: (TIMESTAMPDIFF(SQL_TSI_MINUTE, "Submission Dates"."Submission Created Date", "Submission Dates"."Submission Completed Date"))
0