How to link Person Real Time Subject Area with Workforce Management - Worker Assignment Event Real T

Summary

Is it possible to do this using logical SQL?

Content

Hi,

I'm new to OTBI and I'm experiencing a lot of frustration regarding the Person Real Time Subject Area not having Legal Employer.

My organisation is structured on Legal Employer (aka Legal Entity) and I'm getting numerous report requests to include this field alongside Person Real Time specified fields. I don't understand why this field doesn't exist there - it really should be part of Person Details.

Anyhow,

I'm struggling with the nuances of OTBI generated SQL, it is subtlety different to the SQL I have previous used (I am at beginner level by the way).