Table name used to store compulsory data elements for a dataset

Hi all,

Which table in the DHIS2 database is used to store the compulsory data elements for a dataset?

Thanks,
Pomi

Hi @Pomi_Daniel
In response to your inquiry, you can find the data elements metadata in the ‘dataelement’ table in the database and also find the data element data values in the ‘datavalue’ table.

Thanks for your response @e4eDHIS2 . I’m not looking for the table of data elements and data values. As you know, you can make a data element compulsory for a specific dataset. Where is that information captured in DHIS2 tables?

I tracked the size of the DHIS2 database tables before and after making data elements mandatory and discovered that datasetoperands and dataelementoperand tables store information about whether or not a data element is compulsory for a specific dataset.

4 Likes