In which table I can find this column "Department" ?
I'm creating a report with BI Publisher and I need the department column but I've searched several tables and can't find it. I've found the business units and legal employers in those tables (HRW_BUSINESS_UNITS & HRW_ENTERPRISES) but not the departments.
Also i'm looking for those colmuns if you can help me : "Entreprise Hire date' , "Projected End date" and "Manager"
This is the document that i use to find tables : HCM Tables and Views (oracle.com)
Thank you so much.