Munis Database Schema Request

• I need to get a database schema of all the programs in Munis
• Need DDL (Data Definition Language) to all the tables within the Munis database for SSRS reports development
• Copy of Database Diagram from SSMS

• Enterprise ERP Data Dictionary
• SQL
• SSMS
• Reporting

Informational

These details can be obtained in the Munis Data Dictionary Inquiry program:

Enterprise ERP > System Administration > Report Writer > Munis Data Dictionary Inquiry

How to download Munis data dictionary

Database column overlay functionality is available in most Munis Programs. The following procedure uses Employee Master program as an example, the same steps can be replicated to obtain same information for other Programs.

1. Navigate to Enterprise ERP > Human Capital Management > Human Resources > Employee Job/Pay Classification > Employee Master

2. Click on the Cog wheel Icon on the top right and select option View Database Columns

3. The current page will refresh to show the database schema name, table name and the column name from where the information in a field is fetched from.

This database information can be used to locate an appropriate TRS view by searching the Munis Data Dictionary.