Setting Up Your Contributor Relations Framework

This chapter discusses how to:

See Also

Securing Contributor Relations

Defining Contributor Relations User Defaults

Click to jump to top of pageClick to jump to parent topicCompleting CR Installation

To set up CR installation defaults, use the Contributor Rel Installation component (AV_INSTALLATION).

This section discusses how to set CR installation defaults.

Click to jump to top of pageClick to jump to parent topicPage Used to Complete CR Installation

Page Name

Object Name

Navigation

Usage

CR Installation

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.

Click to jump to top of pageClick to jump to parent topicSetting CR Installation Defaults

Access the CR Installation page.

Assignment Role Option

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.

Spouse Recognition Split

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.

Financials Release

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.

Setting Last Record Numbers

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.

Click to jump to top of pageClick to jump to parent topicSetting Up Institution Defaults

To set up institution defaults that are used throughout the system, use the Institution Defaults component (AV_INSTALL_INST).

This section discusses how to:

Click to jump to top of pageClick to jump to parent topicPages Used to Set Up Institution Defaults

Page Name

Object Name

Navigation

Usage

Institution Installation

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.

Bio Bit Setup

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.

Bio Brief Setup

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.

Institution Installation 2

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.

Click to jump to top of pageClick to jump to parent topicSetting Institution Default Values

Access the Institution Installation page.

Distribute Overpayment

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.

Distribute Underpayment

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.

Financials Link

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.

Membership

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.

Other Page Elements

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.

Click to jump to top of pageClick to jump to parent topicSetting Up Bio Bit and Bio Brief Reports

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

Click to jump to top of pageClick to jump to parent topicSetting Further Institution Default Values

Access the Institution Installation 2 page.

Receipt

Event ID

Select the event ID that contains the letter code for the default receipt that your institution issues.

Acknowledgement Priority

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.

To Do List

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.

Currency Default

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.

Click to jump to top of pageClick to jump to parent topicAdding Resources

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:

Click to jump to top of pageClick to jump to parent topicUnderstanding Resources

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

Click to jump to top of pageClick to jump to parent topicPages Used to Add Resources

Page Name

Object Name

Navigation

Usage

Define Staff, Define Volunteers

AV_STAFF_TBL

  • Set Up SACR, Product Related, Contributor Relations, CR Common Definitions, Resources, Staff

  • Set Up SACR, Product Related, Contributor Relations, CR Common Definitions, Resources, Volunteers

Add staff members and volunteers to the system individually.

Units

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.

Roles

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.

Staff Roles, Unit Roles, and Volunteer Roles

AV_STAFF_PRPS_TBL

AV_UNIT_PRPS_TBL

  • Set Up SACR, Product Related, Contributor Relations, CR Common Definitions, Resources, Staff Roles

  • Set Up SACR, Product Related, Contributor Relations, CR Common Definitions, Resources, Unit Roles

  • Set Up SACR, Product Related, Contributor Relations, CR Common Definitions, Resources, Volunteer Roles

Set up valid roles for individual resources at your institution.

View Staff, View Volunteers

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.

Click to jump to top of pageClick to jump to parent topicAdding Staff and Volunteers

Access the Define Staff page.

The appearance of this page changes, depending on whether you are adding staff or volunteers.

Click to jump to top of pageClick to jump to parent topicDefining Units

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.

Click to jump to top of pageClick to jump to parent topicDefining Roles

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.

Click to jump to top of pageClick to jump to parent topicDefining Staff, Unit, and Volunteer Roles

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.

Click to jump to top of pageClick to jump to parent topicViewing Staff Members and Volunteers

Access the View Staff and View Volunteers pages.