Employee Rating not fetching

Summary:

I have issue with my performance rating analysis. I was able to get the Overall Manager Rating but it's not fetching the Employee Rating, Rating Level Name, Status. I need help checking the SQL below. Thank you in advance!

I need help to check the SQL below:

SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT
0 s_0,
"Workforce Performance - Performance Rating Real Time"."- Performance Rating"."Overall Manager Rating" s_1,
"Workforce Performance - Performance Rating Real Time"."- Performance Rating"."Overall Worker Rating" s_2,
"Workforce Performance - Performance Rating Real Time"."- Performance Rating"."Status" s_3,
"Workforce Performance - Performance Rating Real Time"."- Rating Level"."Rating Description" s_4,