Description of Issue

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

Context

Enterprise ERP Data Dictionary
SQL
SSMS
Reporting

Cause

Informational

Resolution

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.

Navigate to Enterprise ERP > Human Capital Management > Human Resources > Employee Job/Pay Classification > Employee Master
Click on the Cog wheel Icon on the top right and select option View Database Columns
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.

Additional Information

Browser not supported