which table should I use to get the employee preferred timezone for custom reporting

[dmak]

I am trying to create a custom report to show all employees and their preferred timezone settings. I have tried using pa_user_preferences table with user id joining with pa_student table's stud_id, the results didn't match what shows on screen; some people ended up with blank timezone on the report actually do have timezone settings according to the screen. I am wondering which table is the right one to use?

[former_member676516 · Accepted solution]

Hi Donna,

Hope you are doing well.

An LMS database will records involving DATE values in the timezone the database is set to. This is found in the PA_APP_ADMIN table in the DB_TIMEZONE column.

However, the LMS will return report output based on the time zone set in the admins time zone preference. You may refer below KBA for further details.

https://apps.support.sap.com/sap/support/knowledge/en/2320765

Please accept the answer in case you find this helpful.

Regards,
Srishty