Report & DB Updates: 2014 - October

The updates below will be applied to customer systems in October of 2014.  An email with your church's specific date will be sent in the first half of the month. These updates do not require any system downtime and can be applied during the business day. Please note that database and report updates can include the following types of changes:
  • New and updated reports deployed to your Reporting Services installation
  • Changes to the System Setup (Metadata)
  • Changes to database objects to maintain a consistent "core" database schema across all churches
  • Changes to stored procedures used by various applications
  • Changes to nightly routines that assist you in managing your database
  • Housekeeping tasks to address specific data quality issues

 
UPDATES TAKING PLACE IN THIS RELEASE:
Check-in Stored Procedure and Database Changes October 2014
  • Enhancement: A new field was added to the Group record called "Suppress Care Note". If the group requires security AND the church has the system set to prompt for a care note, setting this option to true will prevent the prompt for members of this group. 
  • Enhancement: Added a "Closed" bit field to the Event Groups records. It is now possible to remove a group from the scope of check-in during an event by setting this bit field to true. 
  • Program Change: Never Allow Check-in for a Past Event: If an event ended more than 8 hours ago even an attended station will not be able to check people into it. 
  • Program Change: Station Time vs Server Time Impacts New Group Member Check-in: Change in the behavior so that if someone is added or removed from a group up to 8 hours on either side of the current time will be able to check into that group. 
  • Program Change: It will not be possible to add an individual to a group that has been end-dated in the past EVEN if this group is associated with the event directly. 
  • Bug Fix: Previously, if a group was listed in each of two events that were in the scope for check-in at one time and those groups were in different rooms, then the number of rows under family members belonging to these groups were duplicated. This has been corrected. 
  • Housekeeping: Removed redundant logic from the Stored Procedures that return search results to make them run faster.
 
New & Updated Reports October 2014
  • NEW REPORT: Selected Deposit Program Summary Export. This report is deployed to the Deposits page and provides a deposit level summary by Program with Account Number. It includes an option to mark the selected deposits as “exported”.
  • Selected Mail Merge Family Detail. This report was updated to include the Anniversary Date for both heads of house. It was updated so that Date of Birth would be properly formatted on systems where the field type for Date of Birth is now “Date” rather than “DateTime”
  • Contact Photo Report was updated to address a formatting issue on some systems with the date of birth.
  • Selected Contact Directory was updated to address a formatting issue on some systems with the date of birth.
  • Selected Program Group Multi-week Roster was updated to address a formatting issue on some systems with the date of birth. 
  • Process Selected Payments report was updated so that the summary pages at the end would include the amounts for payment detail less than $0 (discounts).
  • Selected Contact Dashboard was updated to address a formatting issue on some systems with the date of birth.
  • Selected Event Metrics was updated to address a formatting issue.
  • Selected Program Group Rollscan Roster was updated to address a formatting issue on some systems with the date of birth.
 
Other Database & System Setup Changes October 2014
  • Core Tool Map My Selection Stored Procedure Change: This change addresses an issue where only the one record was being Geocoded by the tool.
  • Core Tool Form Responses Stored Procedure Change: This change addresses an issue where churches on the latest version of the Platform were required to pass dates as the “All Records” option did not return results.
  • Portal Stored Procedure Change: Prevented a rare error with the stored procedure that returns meeting participants to the My Groups area of the Portal. The impacted stored procedure is titled api_mpp_getmeetingparticipants.
  • Portal Configuration Setting Change: Replaced “Forgot Password" with "Reset Account" in the Configuration Setting “NewUserContactNotFoundMessage”. This button was renamed in our last Portal release.
  • Ran a script to correct any user account where the User Display Name was missing
  • Added the field “Project_Code” (INT) to all systems where it was not already present on the Events page.
  • Added a separator field (label) to the Forms page called "Standalone Form Use Only".  Reorderd fields on the Forms page so that fields are listed under this separator when they only impact a form used independently from pages like event sign-up or mission trip registration.
  • Removed a default value from Event_Rooms.Room_Layout_ID that might cause an issue for churches on the latest Platform.
  • A stored procedure used by several reports was updated to prevent a rare error. The stored procedure is titled report_filter_selected_records.
 

Last Modified: 4/7/2018

Did this article help?
× Thank You for the Feedback