FundRaisingSummaryUpdateCustomSP
| Initial Build | 2011.01 |
| Module | Fundraising |
| Current Setting Type | Text Box |
Custom stored procedure (SP) to update various fundraising denormalized fields on the constituent (np_constituent) record (amounts, dates and counts for YTD, highest, last, first, etc.). This SP is called within the np_rfm_summary baseline SP.
This option is referenced by the GiftsToIncludeInToDateAmounts system option.
The default for this option is empty.
Creating Your own Custom SP
If you create your own SP for this purpose, it must have the same parameters as the baseline SP np_rfm_summary.
If you elect to write a custom SP, you should follow the general logic of np_rfm_summary and then implement your own custom logic within your custom SP. Note that the parameters and internal logic of the SP changed in 2014.1 with the overhaul of the np_constituent table. Therefore, any custom SPs will need to be revised during the upgrade to 2014.1 or later builds.
Current Setting
The current setting for FundRaisingSummaryUpdateCustomSP is used as follows:
Values: This system option can call any stored procedure (SP) that will update various fundraising denormalized fields on the constituent (np_constituent) record (amounts, dates and counts for YTD, highest, last, first, etc.).
Default Value: empty
Fields
This system option includes the following fields:
Description: This field gives the description of the system option, including its use and default value.
Important! Do not modify the following fields after the system option is first created. Changing these fields after they have been used can invalidate existing data.
Category: This field sets the category (usually the module) where the system option is used.
Type: The Type field determines the display type of the Current setting field (check box, drop-down list, or text box).
Values: The values field indicates the allowed values for the Current setting field.
Availability
Each system option includes the following availability settings:
Entity Level Option?: Select this check box to make this system option available on an entity level.
Visible To External Systems?: Select this check box to make this system option available in xWeb.