Manager Field Data Dictionary

[assravichandr]

Hi Experts,

Good day! I am trying to build a customized LMS report via Plateau Report Designer and I need to pull a data for the Manager email address, First name, Last name however I cannot find in the Data dictionary what are the equivalent of the mentioned fields. 

I have refer to existing report and check the query however the query is too advance for me to understand. Would you know what are the fields name from data dictionary I can use? Thank you for the help.

Regards,

Wayne

[Padraig · Accepted solution]

Hi Wayne

So there is no specific table where manager data is exclusively recorded.

To identify a manager in the DB tables you need to check the PA_STUDENT.SUPER column. When a user reports into a manager, the SUPER field in PA_STUDENT table will be populated with the STUD_ID value of the user who is the manager.

So if you know that MARY_B is a manager a simple query would be SELECT STUD_ID, LNAME, FNAME, EMAIL_ADDR FROM PA_STUDENT WHERE STUD_ID=’MARY_B’ will bring back the details for the manager.

To know what users report into MARY_B then you could have a query like SELECT * FROM PA_STUDENT WHERE SUPER='MARY_B'

If this information helped you then please consider giving Kudos or accepting this post as solution.

Regards

Padraig

[assravichandr · Accepted solution]

Hi Padraig,

This is resolved. I managed to get what Im looking for. Thank you!

Regards,

Wayne