Report & DB Updates: 2014 - June
NEW REPORT (ID 700)
"Find Donor Household Change" is a report that will list donor households by giving change (amount and %) and allow the user to create a selection.
NEW REPORT (ID 699)
"Selected Group Participation Percentages" is a report listing selected groups and comparing the numbers of participants in those group between two time periods.
NEW PAGE VIEW (ID 691)
"Form Usage" on the Forms page lists how many events, opportunities, and pledge campaigns are using that form.
NEW PAGE VIEW (ID 683)
"Open - BG Check Needed" added to Response page to reveal those interested in a group role that requires a background check who do not have one yet.
NEW PAGE VIEW (ID 676)
“Fix Active Participant End Dated” added to the Participants page for the Data Quality Team.
UPDATED REPORT RDL (ID 667)
Improved sort order for Campaign Statement.
UPDATED REPORT RDL (ID 709)
Selected Group Birthday List Cdate() wrap on Date_of_Birth so certain systems would show the DOB.
UPDATED REPORT RDL (ID 710)
Selected Group Roster Plus Family Cdate() wrap for Date_of_Birth so certain systems would show the DOB.
UPDATED REPORT RDL (ID 708)
Selected Labels changed to prevent an extra, blank line from being added.
UPDATED REPORT SP (ID 717)
Allowing Null values in Group Type for: report_group_summary_Range.
UPDATED REPORT SP (ID 716)
Minor fix to a URL returned by the stored procedure: report_filter_ministries.
UPDATED REPORT SP (ID 715)
Minor fix to prevent an error if no envelope numbers exist on any records for: report_Value_Max_Envelope_No.
UPDATED REPORT SP (ID 714)
Minor fix to report_Contact_Log_Listing to prevent an error.
UPDATED REPORT SP (ID 712)
Minor fix to report_Contacts_Selected_Household_Donations impacting Programs with very long names.
UPDATED REPORT SP (ID 718)
Sort order fix to the stored procedure: report_Group_Contacts_Selected.
UPDATED REPORT SP & RDL (ID 704)
Minor change to the "Feedback Report" added HH Position.
UPDATED REPORT SP & RDL (ID 707)
Minor fix to the "Selected Event Registrants Summary" fixed amount paid when multiple payments made.
SECURITY ROLE CHANGE (ID 672)
Removed QuickAdd of Banks from any security role for USA churches. This feature is primarily for Philippine churches.
SECURITY ROLE CHANGE (ID 678)
Removed the deprecated "Add Next Env Number" report from any security roles and/or pages. Use the Add Envelope Number Core Tool.
SECURITY ROLE CHANGE (ID 496)
Removed the deprecated "Trim My Selection" report from security roles. Use the Trim Selection Core Tool.
DATABASE CHANGE (ID 701)
Created an Index on Contacts.Card_ID.
DATABASE CHANGE (ID 706)
Improved the trigger titled TR_InvoiceDetail_AddToGroup. It now only adds the registrant to a group if that person is not already in the group.
DATABASE CHANGE (ID 696)
Made dp_Page_Sections.View_Order required to prevent an error if it is left blank.
DATABASE CHANGE (ID 702)
Remove Activity_Log.Participant_ID field which is redundant.
SYSTEM SETUP CHANGE (ID 692)
"Check-in New Past 7 Days" view no longer limited to entries made by "webuser".
SYSTEM SETUP CHANGE (ID 688)
Added “Field_Type_ID_Table.Field_Type” to default field list of “Fields” sub-page of open Form.
SYSTEM SETUP CHANGE (ID 686)
Added an invoice status of “Cancelled” to the Invoice_Statuses page.
SYSTEM SETUP CHANGE (ID 675)
Default Field list for Page Views Page now includes user and user group.
SYSTEM SETUP CHANGE (ID 698)
Enabled the "Add" button on Pledges subpage of open Pledge Campaign so multiple pledges might be added at one time.
SYSTEM SETUP CHANGE (ID 697)
Fully qualify fields in dp_Pages.selected_record_expression where table_name = 'Form_Responses' to prevent a rare error.
SYSTEM SETUP CHANGE (ID 679)
Improved sub-page default field list for Form Responses sub-page of Events.
SYSTEM SETUP CHANGE (ID 690)
Improved sub-page default field list for Payment Detail sub-page of Payment adding event title, event date, and registrant display name.
SP CHANGE (ID 500)
Prevented a rare error with My Calls if contact is not part of a Household.
SP CHANGE (ID 499)
Prevented a rare error with My Events if contact is not part of a Household.
SP CHANGE (ID 703)
Suppressed Donation Amounts in api_MPP_GetMyMissionTripDonors when config setting is true.
UPDATED ROUTINE (ID 719)
Updated the stored procedure "service_activity_log" removing any references to activity_log.participant_id.