Forgive me for having the most basic question, however, I am brand new to using SQL.
I am curious how to find out which tables are available to query in my system for the HCM product. Is there a query I can enter in BI that will give me a list of all the tables that we are using currently?
From there, I would also be interested in knowing the names of all the columns within these tables so that I have that information readily availably for querying.
Lastly, when I am transacting within 'Person Management', is there a way to determine what the name of a field would be if I wanted to report on it? For instance, I enter gender on a new employee and know that in BI that field would be called 'Gender_Employee' (making that up).