SQL
Discussion List
-
Help with Duplicate Rows in Candidate Regulations FieldSummary Looking for a SQL Code to remove duplicate rowsContent Hello, I am using the Candidate Regulations "Race" field to report out hires information. I am finding tha… -
Multiple Rows With Offer Actual Start Date FieldContent I have a referral report that is pulling all required data and uses Offer Actual Start Date as the prompt. Issue I'm having is if there are multiple offer attemp…User_2025-01-25-04-51-45-357 61 views 5 comments 1 point Most recent by Dawn Phipps Taleo Enterprise -
Convert Dates to Fiscal Month and Fiscal YearSummary Convert Dates to Fiscal Month and Fiscal YearContent Does anyone have a formula for Fiscal Month and Year? I need to take the Latest Filled Date and convert that…Dawn Phipps 56 views 6 comments 1 point Most recent by User_2025-01-23-20-53-32-038 Taleo Enterprise -
Schedule an entire dashboardSummary Schedule an entire dashboardContent Hi there, I am trying to schedule an entire dashboard containing 3 pages (1 graph & 2 tables) but I get an error message that…User_2025-01-25-05-14-55-725 131 views 10 comments 1 point Most recent by Jairo Rojas Méndez Taleo Enterprise
-
Count of submissions from the past 24 hoursContent I am trying to measure the number of candidates that apply within the past 24 hours. I have tried both variables but I am not getting the complete list. I am not…User_2025-01-23-23-38-26-219 111 views 6 comments 1 point Most recent by User_2025-01-23-23-38-26-219 Taleo Enterprise
-
Passport ResultsSummary Previsor AssessmentContent Hello, In the past, I have had to build assessment results in the Legacy Recruiting Universe. Does anyone know if they are available i…
-
What role do you need in Taleo to have the privilege to create and edit a Business Intelligence repoSummary What role do you need in Taleo to have the privilege to create and edit a Business Intelligence report ?Content What role do you need in Taleo to have the privil… -
Time to Fill - Calculate Last Fully Approved Date to Last Position Accepted DateSummary OBI - Time to Fill - Calculate Last Fully Approved Date to Last Position Accepted DateContent We consider a requisition filled when the last offer has been accep…User_2025-01-23-22-18-46-975 78 views 3 comments 0 points Most recent by Dawn Phipps Taleo Enterprise
-
Pipleline Time In Process - Detail & Metrics Performance IssueSummary Pipleline Time In Process - Detail & Metrics Performance IssueContent Hi All, We have a dashboard -Pipeline Time In Process which consists of both Detail and Met…User_2025-01-23-23-24-55-308 47 views 0 comments 0 points Most recent by User_2025-01-23-23-24-55-308 Taleo Enterprise
-
Prescreening QuestionsSummary Can you report on prescreening questions?Content I was trying to build an analysis that included the candidate's answers to prescreening questions. I checked the…User_2025-01-23-23-38-26-219 196 views 8 comments 2 points Most recent by User_2025-01-23-21-51-52-012 Taleo Enterprise
-
Extract Substring (of varying length) within a String (of varying length)Summary How to extract a sub string from within a stringContent Hi There, I have a situation where I have a text string of the format. To be precise it is the Grade Code…User_2025-01-30-03-39-56-442 51 views 6 comments 0 points Most recent by User_2025-01-29-18-03-12-003 Taleo Enterprise
-
Help with finding how many days Candidates sit in a specific step using Taleo OBISummary I need help with findind how many days Candidates have been sitting in a specific step in TEE, using Taleo OBI Reporting.Content I need help with finding how man… -
OBI Reporting - Formulas for Time Sensitive ReportingSummary Need help with creating time/date sensitive filtersContent I will be the first to admit that I am not the most savvy when it comes to reporting in OBI. We are st…User_2025-01-23-22-24-54-342 79 views 7 comments 0 points Most recent by User_2025-01-30-00-46-46-858 Taleo Enterprise
-
Return only latest Application Reject/Decline Motive in OBISummary Trying to pull the final reject/decline motive per application in an OBI reportContent We had Application Tracking Reject/Decline motive on a report in Business …
-
Formula Help to Pull All Hires For Previous Month And Agent to Send 1st of Following MonthContent I have a weekly hired report that one user only needs monthly. I can create a monthly version to save but cannot figure out how to pull the data for the previous…
-
Most Recent Posting DateSummary Creating a report for time to offer accepted based on posting date, want to pull only most recent posting dateContent I am trying to pull only the most recent po…User_2025-01-28-22-59-03-153 76 views 4 comments 0 points Most recent by User_2025-01-28-22-59-03-153 Taleo Enterprise
-
Format UDF Attribute from Plain Text to Date?Summary I have a UDF that is in plain text format but I need it be able to filter on a time period.Content My UDF is Relocation Date. The screenshot shows the current Da…User_2025-01-25-00-37-41-739 42 views 7 comments 0 points Most recent by User_2025-01-25-00-37-41-739 Taleo Enterprise
-
OBIEE Reports Analysis with Multiple ValuesSummary How to combine and/or remove multiple valuesContent Hello, I am building an analysis and I have multiple values for a candidate. I would like to combine them to …User_2025-01-28-04-42-06-737 116 views 14 comments 5 points Most recent by User_2025-01-23-23-24-55-308 Taleo Enterprise
-
Fast Formula HelpSummary Formula Help- Time Stamp FormulaContent Hi All, This formula works but provides all "0" results. I think I am probably missing or need a different combination of…Kellyzuckerman 85 views 6 comments 3 points Most recent by User_2025-01-23-23-24-55-308 Taleo Enterprise
-
OBIEE: Performance Management Universe - Goal ReportContent Hi! I'm wondering what other clients have done in the space of Goal Plan reporting. After doing some research, I've learned that the performance management table…User_2025-01-25-03-59-10-954 58 views 12 comments 1 point Most recent by User_2025-01-28-04-05-14-166 Taleo Enterprise
-
How do I add Total Submissions field to Hired Candidates by Requistion report?Summary I have a request to add Total submissions for each requisition that has a hired candidate listed.Content The OBI Analysis currently has a row for each candidate …
-
YTD Evaluate Code for Dashboard PromptSummary Dashboard Prompt YTD defaultsContent Hi, I am working on a Dashboard prompt to default to YTD to filter all results on the dashboard. I have used a previously cr…User_2025-01-22-20-13-11-626 56 views 7 comments 2 points Most recent by User_2025-01-22-20-20-44-584 Taleo Enterprise
-
Percentage CalculationSummary Trying to write a formula to get me a percentage calculationContent The percentages I am trying to accomplish are two columns below: Historical Step 2 #Submissio…User_2025-01-28-00-58-05-364 68 views 3 comments 0 points Most recent by Rachel Martorelli-Oracle Taleo Enterprise
-
Need a report to calculate the sourcing TAT (Turn Around Time)Summary Need a report to calculate the sourcing TAT (Turn Around Time)Content Dear Experts, Need your help with a report to calculate the sourcing TAT, here is a the dat… -
Requisition Primary Location Zip CodeSummary Looking to only show Primary location zip codeContent Hello, I am looking to show the primary location zip code in an OBI report. I noticed under Requisition Pri…Kellyzuckerman 47 views 1 comment 0 points Most recent by User_2025-01-25-01-06-59-455 Taleo Enterprise
-
Application Historical Tracking Date and corresponding Application Historical CSW StepSummary Application Historical Tracking Date and corresponding Application Historical CSW StepContent This is an easy one but my brain is fried with the upcoming holiday…
-
Create a variable to count offer accepts where start date is > current dateContent Hello, I am creating a table that counts by location the various stages of the candidate life cycle. One of those counts is on offer accepts where the start date…User_2025-01-23-23-38-26-219 31 views 2 comments 1 point Most recent by User_2025-01-23-23-38-26-219 Taleo Enterprise
-
Current Date/Time Stamp in OBI AgentSummary Looking to put a date/time stamp in the subject line of my OBI agentContent Hello, I would like the subject line of my OBI agent to contain the date/time of the …Kellyzuckerman 69 views 2 comments 2 points Most recent by User_2025-01-23-23-38-26-219 Taleo Enterprise
-
How to get the nationality of a candidate or the language spoken by the candidate?Summary How to get the nationality of a candidate or the language spoken by the candidate?Content Hi All, One of my team members wanted to access all Dutch speaking cand…User_2025-01-28-04-22-02-757 57 views 0 comments 0 points Most recent by User_2025-01-28-04-22-02-757 Taleo Enterprise
-
Pull Analysis with Current Status as of a certain time/dateContent Hello, I have a graph set up in OBI where I need to re-pull it as of last Friday 10/28 as of noon. I already have a filter on it for Req Creation date less than …Kellyzuckerman 51 views 3 comments 0 points Most recent by User_2025-01-22-20-20-44-584 Taleo Enterprise