This chapter discusses how to:
Complete Contributor Relations (CR) installation.
Set up institution defaults.
Add resources.
See Also
Securing Contributor Relations
Defining Contributor Relations User Defaults
To set up CR installation defaults, use the Contributor Rel Installation component (AV_INSTALLATION).
This section discusses how to set CR installation defaults.
Page Name |
Object Name |
Navigation |
Usage |
AV_INSTALLATION |
Set Up SACR, Install, Contributor Rel Installation |
Define system-wide business rules for many functional areas within the CR system. In addition, specify the most recently used numbers for things such as strategies, assets, ratings, actions, gifts, and sessions to eliminate problems with duplicate data after the conversion is complete. |
Access the CR Installation page.
Use this group box to determine how roles are made available in fields throughout the system.
Defined |
Select this option if resources can only be assigned with the roles that you select for them on the Staff Roles, Unit Roles, or Volunteer Roles pages. For example, if staff member Darla Perkins is a Prospect Manager, you must first define Prospect Manager as a staff role, then select that role for Darla Perkins on the Staff Roles page. Then, if this is her only defined role, whenever Darla Perkins is selected, only Prospect Manager appears as an available option. |
Class |
Select this option if all the roles defined for a resource type are available to every person or unit that is part of that resource type. For example, if you define the role of Prospect Manager and select the Staff check box on the Define Roles page, then all the staff members at the institution can be assigned as Prospect Managers, regardless of whether they have been assigned that role. |
All |
Select this option if any resource at the institution (whether staff, unit, or volunteer) can be assigned for any defined role. Using this option, it is possible to assign a unit as a Prospect Manager. There are no restrictions in place to prevent you from doing so. See Defining Roles. |
Use the Spouse Recognition Split group box to set up the default hard and soft credit splits that occur when a person gives a gift and credits the spouse. These values are used to calculate spouse recognition on the Recognition page, but can be overwritten.
Donor Record |
Select a credit type and the percent of the gift to allocate to that credit type as a default for the donor who makes the commitment. |
Donor Record 2 |
(Optional) Select a credit type and the percent of the gift to allocate to that credit type as a default. |
Spouse Record |
Select a credit type and the percent of the gift to allocate to that credit type as a default for the spouse’s recognition. |
Spouse Record 2 |
(Optional) Select a credit type and the percent of the gift to allocate to that credit type as a default. |
Note. There are two rows of donor recognition defaults and two rows of spouse recognition defaults so that you can set up both a hard credit and soft credit recognition default for each person. The total percentage of hard credit types between the donor record and the spouse record must equal 100%.
Setting the Default Soft Credit Type, Payment Schedule, Pledge Feed, and Pledge Payment Override
You can determine the default type of soft credit recognition to appear in the Soft Credit field when entering gift and pledge recognition information. Soft credits are defined by your institution.
Default Soft Credit Type |
Select the soft credit type to appear by default in the Soft Credit field when entering gift and pledge recognition information. This default can be overwritten. The valid soft credits at your institution display in this prompt dialog box. Hard is a delivered credit type. All other credit types are considered soft credit. |
Payment Schedule |
Select the payment schedule to display as the default in the Payment Schedule field on the Pledge Detail page when entering a pledge. This default can be overridden. Field values are delivered with the system as translate values. Do not modify these values in any way. Any modifications to these values require a substantial programming effort. |
Allow Feedable Pledges |
Select this check box for the ability to send pledges to the financial system for recording as a receivable. This is not an automatic process. Selecting this check box activates the Feed Pledge check box on the Gift Entry and Adjust Gift Entry pages. The decision to send a particular pledge occurs when you enter each transaction individually. The system includes only pledges with the Feed Pledge check box selected in the AV_ACCTG_LN record that is created through the GL Interface process. |
Allow Pledge Payment Override |
Select this check box to allow data entry staff to change recognition or designation information for a pledge at the time of pledge payment. |
Important! Pledge payment overrides can only be made if the pledge has not been sent to the financial system.
Determining Whether Contact Reports are Required
You can determine whether contact reports are required for each completed action in the system.
Require Contact Report |
Select this option if contact reports are required for each completed action at the institution. When you select this check box, you are required to write a contact report before saving an action as Completed. |
Identify the version of financial software in use at your institution, whether from PeopleSoft or a third-party vendor.
Your selection determines which path the Contributor Relations system uses to transfer accounting line information. The values 7.5 and Other trigger a flat-file approach, in which the system creates a flat file that can be picked up and used both by older versions of PeopleSoft Enterprise Financials and by an external financial application. The value 8.4 or 8.8 triggers an integrated messaging interface.
See Interfacing with PeopleSoft Enterprise Financials.
You can enter the last record number that was assigned to items such as strategies, actions, gifts, and so on. When you create new records in the system, they are numbered consecutively beginning with the number after the one that you enter here. As new records are added, the last record numbers on this page increase so that you always know the number of the last record entered.
Important! After you set these numbers, PeopleSoft recommends that you never reset it or decrease it, to avoid duplicate key errors. However, you can increase these numbers.
Enter the last Strategy Number, assigned to the most recent prospect strategy.
Enter the last Asset Number, assigned to the most recent personal asset.
Enter the last Rating Number, assigned to the most recent prospect rating.
Enter the last Action Number, assigned to the most recent constituent action.
Enter the last Initiative Action Number, assigned to the most recent initiative action.
Enter the last Gift Number, assigned to the most recent commitment.
Enter the last Session Number, assigned to the most recent session.
Enter the last Relation Number, assigned to the most recent organization relationship record.
Enter the last Planned Giving Number, assigned to the most recent planned gift.
Enter the last Volunteer Group, assigned to the most recent volunteer group.
Enter the last Volunteer Structure Number, assigned to the most recent volunteer structure.
Enter the last Membership Number, assigned to the most recent membership in a member organization.
Enter the last Membership Payment Number, assigned to the most recent membership dues payment.
Enter the Last Receipt Number, assigned to the most recent online gift or pledge.
Enter the Last Reference Number, assigned to the most recent credit card transaction processed.
To set up institution defaults that are used throughout the system, use the Institution Defaults component (AV_INSTALL_INST).
This section discusses how to:
Set institution default values.
Set up the Bio Bit and Bio Brief reports.
Set further institution default values.
Page Name |
Object Name |
Navigation |
Usage |
AV_INSTALL_INST |
Set Up SACR, Product Related, Contributor Relations, Install Contributor Relations, Institution Defaults, Institution Installation |
Begin the process of setting institution default values that are used throughout the system. |
|
AV_BIO_BIT_SP |
Click the Bio Bit button on the Institution Installation page. |
Select the attributes to include in the standard Bio Bit report that is generated by the institution. |
|
AV_BIO_BIT_SP |
Click the Bio Brief button on the Institution Installation page. |
Select the attributes to include in the standard Bio Brief report that is generated by the institution. |
|
AV_INSTALL_INST2 |
Set Up SACR, Product Related, Contributor Relations, Install Contributor Relations, Institution Defaults, Institution Installation 2 |
Set up acknowledgement and receipt defaults for your institution. |
Access the Institution Installation page.
Use this group box to determine how pledge overpayments are distributed.
Next Payment |
Select this option to deduct the amount of the overpayment from the next scheduled pledge payment. |
Equally |
Select this option to evenly distribute the overpayment throughout all remaining expected pledge payments. |
Ignore |
Select this option to retain the pledge schedule as is, without being affected by the additional amount paid by the donor. |
Select the appropriate option from this group box to determine how pledge underpayments are distributed.
Next Payment |
Select this option to add the amount of the underpayment to the next scheduled pledge payment. |
Equally |
Select this option to evenly add the underpayment throughout all remaining pledge payments. |
SetID |
This setID appears by default in fields throughout the system. It is used when entering gift annuities, pooled income funds, or trusts in Planned Giving. It is also used to determine the calendar that defines the fiscal year in commitment and membership entry. |
Calendar ID |
Select the default ID for the institutional calendar that determines the fiscal year. |
Clearing Account |
Enter the default clearing account to be used when processing membership and gift transactions. The clearing account holds refunds for donors. The available values for this field include all the valid item types that you can use for a clearing account. Clearing accounts must have a journal set of 0 with an indicator of credit. When a refund is manually issued, this clearing account should be debited and the tender account should be credited. |
Allow Gifts in Membership |
Enables you to enter additional gifts through the Membership Entry page |
Membership Days |
Enter a number of days before a membership period ends. This number represents the period of time during which payments are credited to the next membership period. For example, a member organization resets membership every June 1. You set the Membership Days field to 31 days. Any dues payments that are received for that membership organization after May 1 are credited toward the next membership period. |
Maximum Retrieval |
Enter the maximum number of records that the system retrieves on the involvement roster at one time. If this number is exceeded, the system displays a warning message telling the user that additional records exist and cannot be retrieved without limiting search criteria. |
Bio Bit |
Click to access the Bio Bit Setup page. Using this page, select the attributes to include in the standard Bio Bit report. |
Bio Brief |
Click to access the Bio Brief Setup page. Using this page, select the attributes to include in the standard Bio Brief report. |
Select the check boxes next to the attributes to include in the standard Bio Brief report. The report that you define here prints when a you select a Bio Brief on the Biographic Profile page rather than selecting a specialized report.
See Also
Specifying Custom Setup for the Bio Bit and Bio Brief Reports
Contributor Relations Reports: Selected Reports
Access the Institution Installation 2 page.
Event ID |
Select the event ID that contains the letter code for the default receipt that your institution issues. |
Enter numbers to represent the priority for sending acknowledgement letters. The priority that you set determines which acknowledgement setup parameters the system reviews first to determine which letter a donor receives. This priority is used in the Acknowledgements COBOL process to produce a single letter for the commitment.
Acknowledgement
Soft Credit |
Select to send acknowledgement letters for soft credit. The system sends acknowledgement letters to donors with only soft credit on a gift, based on the rules set up on the Acknowledgement Setup pages. If a donor has soft credit on a gift, no soft credit acknowledgement is produced unless this option is checked. The system never generates a receipt for soft credit only recognition, even if this option is checked or the gift is joint with a hard credit donor. |
Adjusted Gift, Adjusted Pledge |
Select to indicate that you want the system to generate acknowledgements for adjusted gifts or adjusted pledges. If you select either of these two check boxes, the system generates acknowledgements for adjustments based on the rules from the Acknowledgement Setup2 page. If you clear these check boxes, the system does not require acknowledgement rules for adjustments on the Acknowledgement Setup2 page. |
Note. If a designation has its own acknowledgement defined, the system creates a letter acknowledging a gift to that designation as well.
Reminder Days |
Enter the number of days prior to an action’s planned date for which the item should appear on the current view of the assigned resource’s to do list. |
Base Currency |
Although business units may operate under different default currencies, all calculations performed by the system translate to the institution base currency that you select here. To protect historical data, after you select a value for this field and save the page, you cannot make additional changes. |
Rate Type |
Select the exchange rate to use when translating amounts to the base currency. Examples of rate type are Official Rate, Spot Market Rate, and Free Market Rate. To protect historical data, after you select a value for this field and save the page, you cannot make additional changes. |
To set up resources, use these components: Staff (AV_STAFF), Volunteers (AV_VOLUNTEERS), Units (AV_UNIT_TBL), Roles (AV_PRPS), Staff Roles (AV_STAFF_PRPS), Unit Roles (AV_UNIT_PRPS), and Volunteer Roles (AV_VOL_PRPS).
This section provides an overview of resources and discusses how to:
Add staff and volunteers.
Define units.
Define roles.
Define staff, unit, and volunteer roles.
View staff members and volunteers.
You can add staff members, volunteers, and business units to the system, then assign the roles they play at your institution. Resources are used throughout the system for managing prospects, controlling gift sessions, and so on.
Important! A person must have an ID in the system before being added as a staff member or volunteer. This process is required to have access to many functions throughout the Contributor Relations system. We recommend that you spend some time determining the roles at your institution and carefully assign resources to those roles.
This table lists the editable pages that are affected by roles throughout the Contributor Relations system. The values in the Role field depend on how you assign roles. In some cases, the values also depend on the settings on the CR Installation page. Titles preceded by an asterisk contain a Role field that is dependent on the settings on the CR Installation page.
Page Name |
Title |
AV_ACKNLDG_SETUP |
Acknowledgement Setup1 |
AV_ACKNLDG_SETUP2 |
Acknowledgement Setup2 |
AV_ACKNLDG_SETUP3 |
Acknowledgement Setup3 |
AV_BEQUEST_INFO |
* Bequest Information |
AV_CNST_ACTN2 |
* Action Info (for Prospect Actions) |
AV_DESIGNATION2 |
Designation Funds 2 |
AV_GIFTAN_INFO |
* Gift Annuity Information |
AV_INTV_ACTN2 |
* Action Info (for Initiative Actions) |
AV_INTV_CMPGN_RSRC |
* Campaign Resources |
AV_INTV_EVNT_RSRC |
* Event Resources |
AV_INTV_MEMBR_RSRC |
* Membership Resources |
AV_INTV_OTHR_RSRC |
* Other Resources |
AV_INTV_VOL_RSRC |
* Volunteer Resources |
AV_LDR_TYPE_TBL |
Leadership Types |
AV_MASS_PRSN |
* Mass Assign Staff |
AV_MASS_PRSN_WS |
* Mass Assign Staff (workset version) |
AV_MASS_UNIT |
* Mass Assign Units |
AV_MASS_UNIT_WS |
* Mass Assign Units (workset version) |
AV_MASS_VOL |
* Mass Assign Volunteers |
AV_MASS_VOL_WS |
* Mass Assign Volunteers (workset version) |
AV_PINC_INFO |
* Pooled Income Information |
AV_STAFF_ASGN |
* Staff Assignment |
AV_TRUST_INFO |
* Trust Information |
AV_UNIT_ASGN |
* Unit Assignment |
AV_VOL_ASGN |
* Volunteer Assignment |
AV_VOL_GRP1_ASGN |
Volunteer Group Assignments |
AV_VOL_GRP2_ASGN |
Sub-Group Assignments |
AV_VOL_LDR_GRP |
Volunteer Structure |
AV_VOL_LDR_GRP_M |
Volunteer Structure 2 |
AV_VOL_SUB_GRP |
Sub-Groups |
AV_VOL_SUB_GRP_M |
Sub-Groups 2 |
Page Name |
Object Name |
Navigation |
Usage |
AV_STAFF_TBL |
|
Add staff members and volunteers to the system individually. |
|
AV_UNIT_TBL |
Set Up SACR, Product Related, Contributor Relations, CR Common Definitions, Resources, Units |
Define the formal and informal organizational units at your institution for fundraising and cultivation purposes. |
|
AV_PRPS_TBL |
Set Up SACR, Product Related, Contributor Relations, CR Common Definitions, Resources, Roles |
Set up the various roles for resources at your institution. |
|
AV_STAFF_PRPS_TBL AV_UNIT_PRPS_TBL |
|
Set up valid roles for individual resources at your institution. |
|
AV_INST_STAFF AV_INST_VOL |
Contributor Relations, Initiatives, Volunteer Initiatives, Volunteer Listing |
View a list of all the staff members and volunteers defined at your institution. |
Access the Define Staff page.
The appearance of this page changes, depending on whether you are adding staff or volunteers.
Access the Units page.
The units that you define here are for use by this application only, and are different from the business units that are used to differentiate between sectors of your institution throughout the system. Using prospect management functionality, you have the ability to assign institutional units to prospects for particular cultivation purposes. Common examples of units include Annual Fund, College of Fine Arts, and Development Office.
Department |
Select the department at your institution to which the unit belongs. Note. This field is optional and is provided for use in reports only. |
Access the Roles page.
A role is a description of the undertakings in which a resource participates at your institution. Examples of roles include Prospect Manager, Solicitor, Campaign Manager, and so on. Roles are used throughout the system in assigning resources to prospects and initiatives.
The following values are required in the PURPOSE_CD field that resides in the AV_PRPS_TBL table:
Code |
Value |
Where Used |
What it Does |
PM |
Prospect Manager |
Prospect Management |
Only one prospect manager can be assigned to a constituent for a specific period. Assignment periods must be unique. |
SOL |
Solicitor |
Prospect Management |
When assigning solicitors, only staff or volunteers who are identified as a solicitor appear as available values. |
GPS |
Gift and Pledge Supervisor |
Session Management |
Assigning the GPS role to an individual gives special authority in session management to reopen a session's expected amounts and counts, reopen a balanced session, or transfer sessions between users on the Session Summary page. |
GE |
Gift Entry Operator |
Session Management |
Assigning the GE role to a user provides the ability to see the user's sessions in session management and on the Session Summary page. It prevents the user from seeing another user's sessions. This limitation is based on user ID. |
GCA |
Giving Club Administrator |
Giving Club Management |
Only a user with this role can add members to a giving club. |
MS |
Membership Supervisor |
Membership Management |
Assigning the MS role to an individual gives special authority in session management to reopen a membership session's expected amounts and counts, reopen a balanced membership session, or transfer membership sessions between users on the Session Summary page. |
Purpose Type |
Select Administrative when creating internal assignments, such as Gift and Pledge Supervisor, that are not used when assigning a resource to a prospect. Select Assignment, such as Prospect Manager, to assign a resource to a prospect. |
Staff |
Select this check box to indicate that this role applies to staff resources. For example, if a Prospect Manager must always be a staff member, select this check box and clear the others. |
Volunteer |
Select this check box to indicate that this role applies to volunteer resources. |
Unit |
Select this check box to indicate that this role applies to unit resources. |
Warning! The Staff, Volunteer, and Unit check boxes only affect the system if you have selected the Class option on the CR Installation page. When you select the Class option, you indicate that all the role codes for a resource type are available to every person or unit that’s part of that resource type. For example, if you define the role of Prospect Manager and select the Staff check box, then all the staff members at the institution can be assigned as Prospect Managers. If you select the Defined option on the CR Installation page, then resources can only be assigned to prospects for the roles that you select for them on the Staff Roles, Unit Roles, or Volunteer Roles pages. For example, if staff member Darla Perkins is a Prospect Manager, you must first define Prospect Manager as a role code, then select that role code for Darla Perkins on the Staff Roles page. PeopleSoft recommends that you select the appropriate Staff, Volunteer, or Unit check boxes on this page, regardless of the option that you select on the CR Installation page. If you do so, and your institution decides to switch from Defined to Class installation mode, your role codes are already set up.
Access the Staff Roles, Unit Roles, or Volunteer Roles page.
The appearance of this page changes, depending on whether you are defining roles for staff, volunteers, or units.
Role |
Select the role to associate with the resource. The role's description displays to the right of the code. |
Important! Individual staff, volunteer, and unit roles are used in the system if you select the Defined installation mode for assignments on the CR Installation page.
Access the View Staff and View Volunteers pages.