One report to view them all - person reporting showing department, assignment status etc

Content

Hi,

Is there a SQL based data model that shows everyone in HCM, their assignment status, department, name, suffix, email, location, manager details, role details job title etc

We are currently using a data model comprised of 3 UNIONs but I can't help but think there's an easier way using a SQL data model

Thanks