Key Database Tables to run sql scripts on

what are some of the key tables in the database that I can use to extract data from. I would like to create an sql script that returns data elements data value for the org unit for a specific period of time.

Hi and welcome to the community @fmwesigwa :tada:

I’d start with the related tables to your purpose. Use the sqlViews in the Maintenance app → Other → SQL Views, and create the query:
SELECT * FROM information_schema.tables which will list the available tables for you and then you could use keywords such as ‘dataelement’ using Ctrl+F .

Thanks @Gassim. This is much helpful

1 Like