Report & Database Configuration Settings

The following Configuration Settings are edited in the platform and control various aspects of the Reports & Routines.

SERVICES Configuration Settings

SERVICES, AddDefaultCongregationID
The ID of the Congregation to assign as the default congregation to Households if created without a Congregation.

SERVICES,AddHouseholdDonationDates
When set to yes, allows routine to populate Households._Last_Donation and Households._First_Donation.

SERVICES,AssignPledgesNightly
If set to YES, Donation Distributions assigned to programs participating in pledge campaigns will be assigned to active pledges by the donor or spouse of the donor to the campaign.

SERVICES,AttendanceNotificationMessageID
The ID number of the Message record in the dp_Communications table that serves as a template to send out nightly notification when group attendance is needed for a group where send_attend. Set this to 0 (zero) to turn off Attendance Notifications.

SERVICES,AttendanceNotificationEventVisibility
The visibility level you want set for the Events created by the Group Attendance Notification

SERVICES,AttendanceOptionalURL
The application URL you want included in the Group Attendance Notification to direct leaders to the desired application to record attendance. For example, you might choose MobileTools (Group Manager) or Portal (My Groups). Select Portal or MobileTools to send path to group leaders to add attendance.

SERVICES,BackgroundCheckNotificationMessageID
Used by the Background Check Status Notification (Deployed with 0, to turn on add Message ID). Set to 0 (zero) to turn off Background Check Notifications.

SERVICES,BackgroundCheckNotificationWeekdayNumber
Used by the Background Check Status Notification (0 = everyday, 1 = Sunday, 2 = Monday, 3 = Tuesday, 4 = Wednesday, 5 = Thursday, 6 = Friday, 7 = Saturday)

SERVICES,BirthdayNotificationMessageID
The ID number of the Message record in the dp_Communications table that serves as a template to send out a happy birthday notification. Set this to 0 (zero) to turn off Birthday Notifications.

SERVICES,CareCaseNotificationMessageID
The ID number of the Message record in the dp_Communications table that serves as a template to send out a Care Case Notification. Set this to 0 (zero) to turn off Care Case Notifications.

SERVICES,CopySharedAddresses
If Value is Yes above, this will cause the Data Quality Routine to make a copy of any address record shared by two households and assign the new copy to one of those households. Set Value to No to disable.

SERVICES,DaysTillTemporaryPasswordExpires
Portal users who use the forgot password mechanism are placed in recovery and sent a temporary password. The nightly data quality routine will erase that temporary password and set In Recovery.

SERVICES,DBMailProfileName
The profile used by default to send email with the DBMail service of SQL Server.

SERVICES,EnforceTimeZone
When true, a nightly routine will ensure all users are set to the default timezone. Only those not currently set to that value will be impacted.

Currently, this routine runs nightly, regardless of the setting.

SERVICES,EventReminderNotificationMessageID
The ID number of the Message record in the dp_Communications table that serves as a template to send out nightly event reminders when events.days_out_to_remind is populated. Set to 0 (zero) to turn off Event Reminders.

Used by the Event Reminder Notification 

SERVICES,MessageRecapNotificationMessageID
The ID number of the Message record in the dp_Communications table that serves as a template to send out the message recap report to the author of messages to large lists of people.

Used by the Message Recap Notification 

SERVICES: OpportunityReminderNotificationMessageID
The ID number of the Message record in the dp_Communications table that serves as a template to send out nightly Opportunity reminders when opportunity.days_out_to_remind is populated. Set to 0 (zero) to turn off Opportunity Reminders.

Used by the Opportunity Reminder Notification 

SERVICES,RedAlertUserID

The ID number of the User record of the "Red Alert" User. This prevents church staff from receiving task notification emails associated with "Red Alert" Tasks.

SERVICES,ServiceNotificationMessageID
The ID number of the Message record in the dp_Communications table that serves as a template to send out nightly notification to volunteers who are scheduled to serve. Set this to 0 (zero) to turn off Service Notifications.

SERVICES,TaskNotificationMessageID
The ID number of the Message record in the dp_Communications table that serves as a template to send out nightly notification of outstanding tasks to secured users. Set this to 0 (zero) to turn off Task Notifications.

SERVICES,WeeklyPromotionByUpdate
Yes/No values only. Set to yes and weekly promotion will only change the group in which a child is listed rather then end dating and creating a new group participant record in the promote to group.

SSRS Configuration Settings

SSRS,BaseURL
The full or absolute URL to the MinistryPlatform application on the web server. This is used in Task Notifications to support the [BaseURL] token, among other things.

SSRS,CurrentCampaignFilters 
Yes/No values only. If yes, lists only Events associated with current Mission Trips in the Events drop down on several Mission Trip-related reports.

SSRS,CurrentProgramFilters
Yes/No values only. Set to "yes" to ensure report filters (parameters) will list only current programs.

SSRS,DefaultAccountingProject
An integer value used during export to the accounting system when a donation is credited to an event but events.project_code is empty.

SSRS,GivingLevel
You can have multiple entries for this Configuration. Each value creates a level. You should have at least 2 levels, but more are acceptable. Change the values to suit your church. Giving Levels will answer questions like "How many donors gave at this level between these two dates?" See this KB for details.

SSRS,ReportDBVersion
The current version of the Report and Database loaded on your system.

 

Last Modified: 6/10/2019

Did this article help?
× Thank You for the Feedback