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

I need help on my SQL for With and Without Goals Report

in Reporting and Analytics for HCM 6 comments

Summary:

Hi, I hope someone can help me with my query. Only the employees "With Goals" are showing up. The employees "Without Goals" is not showing up in the report. I need to show all employees in the report whether with or without goals.

Thank you in advance!

SELECT
"Workforce Goals - Goal Status Overview Real Time"."Department"."Department Name" Department,
"Workforce Goals - Goal Status Overview Real Time"."Department"."PER_ORGANIZATION_UNIT_DFF_BRANCH_" Branch,
"Workforce Goals - Goal Status Overview Real Time"."Department"."PER_ORGANIZATION_UNIT_DFF_DIVISION_" Division,
"Workforce Goals - Goal Status Overview Real Time"."Review Period"."Review Period Name" ReviewPeriod,

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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