This chapter discusses how to:
Complete a PeopleSoft Contributor Relations installation.
Set up institution defaults.
Add resources.
See Also
Securing Contributor Relations
Defining Contributor Relations User Defaults
To set up Contributor Relations installation defaults, use the Contributor Rel Installation component (AV_INSTALLATION).
This section discusses how to set up Contributor Relations 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 Contributor Relations system. In addition, specify the most recently used numbers for strategies, assets, ratings, actions, gifts, sessions, and so forth 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, and then select that role for Darla Perkins on the Staff Roles page. Then, if this is her only defined role, only the Prospect Manager role will appear as an available option when Darla Perkins is selected. |
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 to any defined role. This option enables you to assign a unit as a Prospect Manager; no restrictions 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 they can be overwritten.
Donor Record |
Select a credit type and the percent of the gift to allocate to that credit type as the 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 the default. |
Spouse Record |
Select a credit type and the percent of the gift to allocate to that credit type as the 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 the default. |
Note. The two rows of donor recognition defaults and two rows of spouse recognition defaults enable you to 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 percent.
Default Soft Credit Type, Payment Schedule, Pledge Feed, and Pledge Payment Override
You can determine the default type of soft credit recognition that will appear in the Default Soft Credit Type field when entering gift and pledge recognition information. Soft credits are defined by your institution.
Default Soft Credit Type |
Select the soft credit type that will 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 appear in this prompt dialog box. Hard Credit is a delivered credit type. All other credit types are considered soft credit. |
Payment Schedule |
Select the payment schedule that will appear by 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. |
Feed Gift to GL and Feed Pledge to GL |
Select these check boxes for the ability to send gifts and pledges to the financial system for recording as a receivable. This process is not automatic. 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 gift or 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.
You 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.
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 that follows 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, you should never reset them or decrease them. Resetting or decreasing these numbers could result in duplicate key errors. However, you can increase these numbers.
Enter these default values:
The last number assigned to the most recent prospect strategy in the Strategy Number field.
The last number assigned to the most recent personal asset in the Asset Number field.
The last number assigned to the most recent prospect rating in the Rating Number field.
The last number assigned to the most recent constituent action in the Action Number field.
The last number assigned to the most recent initiative action in the Initiative Action Number field.
The last number assigned to the most recent commitment in the Gift Number field.
The last number assigned to the most recent session in the Session Number field.
The last number assigned to the most recent organization relationship record in the Relation Number field.
The last number assigned to the most recent planned gift in the Planned Giving Number field.
The last number assigned to the most recent volunteer group in the Volunteer Group field.
The last number assigned to the most recent volunteer structure in the Volunteer Structure Number field.
The last number assigned to the most recent membership in a member organization in the Membership Number field.
The last number assigned to the most recent membership dues payment in the Membership Payment Number field.
The last number assigned to the most recent online gift or pledge in the Last Receipt Number field.
The last number assigned to the most recent credit card transaction processed in the Last Reference Number field.
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 up institution default values.
Set up the Bio Bit and Bio Brief reports.
Set up additional default values for the institution.
Page Name |
Object Name |
Navigation |
Usage |
AV_INSTALL_INST |
Set Up SACR, Product Related, Contributor Relations, Install Contributor Relations, Institution Defaults, Institution Installation |
Set 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 value appears by default 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 on the Membership Entry page. |
Membership Days |
Enter the 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, and you set the Membership Days field to 31 days. Therefore, 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 but cannot be retrieved without limiting the search criteria. |
Bio Bit |
Click to access the Bio Bit Setup page, where you select the attributes to include in the standard Bio Bit report. |
Bio Brief |
Click to access the Bio Brief Setup page, where you select the attributes to include in the standard Bio Brief report. |
Access the Bio Bit Setup page or the Bio Brief Setup page.
Select the check boxes next to the attributes that you want to include in the standard Bio Brief report. The report that you define here prints when a you select a Bio Brief rather than a specialized report on the Biographic Profile page.
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 selected. The system never generates a receipt for recognition of soft credit only, even if this option is selected or the gift is joint with a hard credit donor. |
Adjusted Gift and 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 before the planned date of an action that 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, you cannot make further changes after you select a value for this field and save this page. |
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, you cannot make further changes after you select a value for this field and save this page. |
To add resources, use these components: Roles (AV_PRPS), Staff (AV_STAFF), Volunteers (AV_VOLUNTEERS), and Units (AV_UNIT_TBL).
This section provides an overview of resources and discusses how to:
Define roles.
Define staff and volunteers.
Define units.
You can add staff members, volunteers, and business units to the system and you can 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 she or he can be added as a staff member or volunteer. Adding a person is required to enable access to functions throughout the Contributor Relations system. You should carefully decide on the roles at your institution and assign resources to the 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 |
Page 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_OUTR_ACTN_ASGN |
* Outreach Constituent Action |
AV_PINC_INFO |
* Pooled Income Information |
AV_RUNCTL_ROLE |
* Role Assignments Report |
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_PRPS_TBL |
Set Up SACR, Product Related, Contributor Relations, CR Common Definitions, Resources, Roles |
Set up the resource roles at your institution. |
|
AV_STAFF_TBL |
|
Add staff members and volunteers to the system individually, and assign roles to them. |
|
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, and assign roles to them. |
|
AV_INST_STAFF AV_INST_VOL |
Contributor Relations, Initiatives, Volunteer Initiatives, Volunteer Listing |
View a list of all the staff members and volunteers defined for your institution. |
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.
This table lists values that are required in the PURPOSE_CD field that resides in the AV_PRPS_TBL table:
Code |
Value |
Where Used |
Purpose |
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 among users on the Session Summary page. |
GE |
Gift Entry Operator |
Session Management |
Assigning the GE role to a user provides the ability to access the user's sessions in session management and on the Session Summary page. The user cannot view 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 among 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 is 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, and then select that role code for Darla Perkins on the Staff Roles page. You should select the appropriate Staff, Volunteer, or Unit check box 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 will already be set up.
Access the Define Staff or the Define Volunteers page.
The appearance of this page changes, depending on whether you are adding staff or volunteers.
Staff Roles
Role |
Select one or more roles to associate with the resource. The description of the role appears to the right of the code. |
Important! The system uses individual staff and volunteer roles if you select the Defined installation mode for assignments on the CR Installation page.
Access the Units page.
The units that you define here are used by this application only; they 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. |
Unit Roles
Role |
Select one or more roles to associate with the resource. The description of the role appears to the right of the code. |
Important! The system uses individual unit roles if you select the Defined installation mode for assignments on the CR Installation page.