Query to retrieve Union field

Summary:

Content (please ensure you mask any confidential information):

Hello experts,

do you have a sample query to retrieve the employee Union name as in the attached screen?

Which Oracle BI table stores this information?

Regards,

Valerio

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):