Platform SQL - Released August 2025
Employee view only: This SQL-only release was not communicated to customers because all changes were either on the backend or for upcoming changes that will be announced in release notes later.
Announcements
- The Announcements feature has not been used in MinistryPlatform in over two years, and we've moved our product communications to other channels. So, we removed the CRM endpoint in SQL. We will remove the Announcements icon
from the Platform at a later time. MP-4806
Emails
- Previously, the maximum number of emails that could be sent at a time was 32,766. That limit has been increased to 2,147,483,647. MP-4744
Large Tables
- On the Table Stats page, we updated the "Large Tables" view to include a column for Index MB. This can help users see if the index size increases database storage. MP-4749
Locations
- We added a Location Categories lookup table and page. The page will be visible to the Administrator, System, and Personnel Admin roles in Catholic and non-Catholic instances. MP-4782
- We added a Location Category field to the Locations table. It's used to identify a location based on its function. For Catholic instances, the default values are Department, Facility, Office, Organization, and Parish. For non-Catholic instances, there are no default values. MP-4776
- There's a Locations tab on the Location Category record that shows all locations that are marked for that category. MP-4776
- We moved the existing Location Type page from system lookup to lookup values so users (especially dioceses) can add location types that meet their needs. MP-4777
Payments
- We added a view on the Payments page called "Refunds". It shows Payment records that have a negative Payment Total, with more recent payments showing first. If a view notification is set up, it triggers as soon as the payment record is created with a negative amount, no matter where it's created (for example, the Reverse Payment tool or a third party like MP eGiving). MP-4710
Personnel
Categories and Types:
- We created a Personnel Categories table and page that are only available in Catholic instances. We moved the existing values from Personnel Types to Personnel Categories, and added new values to Personnel Types. MP-4685
- Personnel Categories (identify personnel based on what they do in the church or diocese): Catechist, Clergy, Religious, Staff, Volunteer.
- Personnel Types (categorize personnel based on their role, status, and/or employment relationship): Permanent Deacon, Transitional Deacon, Religious Priest, Diocesan Priest.
Note: It is possible that Catholic customers created page views that reference the "old" Personnel Types table. This change could break those views. We contacted Sioux Falls ahead of this release to let them know. - We changed the following to reference Personnel Categories instead of Personnel Types: MP-4795
- Personnel page (Default Field List, Selected Record Expression)
- Personnel Comments page (Default Field List)
- Clergy: Expires Within 30 Days view (hardcoded in View Clause)
- Directory Clergy Assignment view (hardcoded in View Clause)
Beneficiaries:
- We added a Personnel Beneficiaries table, page, and subpage. These records track beneficiaries who have some relationship with the personnel, such as a spouse, child, or parent. An admin must grant users permission to the page and subpage as well as the Beneficiary Relationships page. MP-4759 / MP-4775
- We added a Beneficiary grouping to the Personnel Estate Plans page, where we moved the Beneficiary On File and Beneficiary Notes fields. Existing customer data will be migrated. MP-4704
- In a later release, we'll deprecate the beneficiary fields in the Personnel table. MP-4704
Personnel Record:
Ordination:
- We now track more advanced ordination details on the Personnel Ordination record, which are grouped under General, Diaconate Ordination, Priest Ordination, and Religious. MP-4756
- We changed the existing fields for Ordained Here and Ordained By to be Deacon Ordained Here and Deacon Ordained By. MP-4756
Views:
- We added a view on the Personnel Assignments page called "Expires Within 30 Days". It shows Assignment records where the End Date is within the next 30 days from the current domain time. Assignments that don't have a Start Date are not included in this view. MP-4785
- We added a view on the Personnel Assignments page called "Directory Personnel Assignment". This is similar to the Directory Clergy Assignment view, but it includes ALL personnel types. This view shows Assignment records that have a future End Date or no End Date. Assignments that don't have a Start Date are not included in this view. MP-4786
- We added a view on the Personnel Assignments page called "Active Assignments by Location Group". It shows active Assignment records sorted alphabetically by Location Group Type. MP-4788
- We added a view on the Personnel page called "Upcoming Birthdays". It shows personnel birthdays in the next 30 days. MP-4787
Security Roles
- We added a new security role called "System", which grants ACST employees access to all features. The role has a new Security Role Type of "System" (ID=10) and is hidden from the Security Roles page. We added the API User and MPAdmin to the System security role. MP-4388
User Count
- We updated the script that calculates user counts. We now follow the same logic as the "Users With Security Roles" view: ICS-307
- Users are omitted by address (DO NOT share or document these for the public so we can prevent abuse), including @acst.com, @ministryplatform.com, @pocketplatform.io, @pocketplatform.com, @thinkministry.com, and @highergroundtech.com.
- Users are omitted by username, including apiuser, mpadmin, mp_egiving, mpsupport, mponboard, mpsuccess, MPProfSvcs, mptrainer, pocketplatform, and HGTSupport.
- Users are omitted if they are assigned to an enabled dp_Api_Clients record AND they are not in the dp_Authentication_Log table in the last 30 days.