You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

SQL for writing BI to fetch Document Eligibility details

edited Jul 17, 2020 1:16PM in Performance Management 1 comment

Summary

SQL for writing BI to fetch Document Eligibility details

Content

Can someone help me with the SQL for the below OTBI query. I want to write a BI report to pull the employee details along with their Performance Document Eligibility.

Basically want to know the table name storing Performance Document Period Name

 

SELECT  "Workforce Performance - Performance Document Eligibility Real Time"."Performance Document Eligibility Details"."Eligibility" s_2, 
        "Workforce Performance - Performance Document Eligibility Real Time"."Performance Document"."Performance Document Period Name" s_3,
        "Workforce Performance - Performance Document Eligibility Real Time"."Worker"."Employee Name" s_5, 
   FROM "Workforce Performance - Performance Document Eligibility Real Time"

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!