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 parent topicCompleting a PeopleSoft Contributor Relations Installation

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.

Click to jump to top of pageClick to jump to parent topicPage Used to Complete a PeopleSoft Contributor Relations Installation

Page Name

Definition 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 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.

Click to jump to top of pageClick to jump to parent topicSetting Up Contributor Relations Installation Defaults

Access the CR Installation page (Set Up SACR, Install, Contributor Rel Installation).

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, 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.

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 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.

Contact Reports

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.

Financials Release

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 Financials and by an external financial application. The value 8.4 or 8.8 triggers an integrated messaging interface.

See Interfacing with PeopleSoft Financials.

Name Display Type

Select a particular Name Display Type for the system to use to generate display names throughout the headers of Contributor Relations pages. Only current, active, effective-dated Name Display Types appear in this list. You can define the properties for a display name on the Name Display Type setup component.

Note. If you do nothing to implement this functionality, there is no impact on how the system displays names throughout Contributor Relations.

See Defining Name Display Settings.

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 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:

Click 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

Definition Name

Navigation

Usage

Institution Installation

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.

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 Up Institution Default Values

Access the Institution Installation page (Set Up SACR, Product Related, Contributor Relations, Install Contributor Relations, Institution Defaults, Institution Installation).

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 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.

Membership

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.

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 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.

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

Access the Bio Bit Setup page or the Bio Brief Setup page (Click the Bio Bit button on the Institution Installation 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

Click to jump to top of pageClick to jump to parent topicSetting Up Additional Default Values for the Institution

Access the Institution Installation 2 page (Set Up SACR, Product Related, Contributor Relations, Install Contributor Relations, Institution Defaults, Institution Installation 2).

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 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.

To Do List

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.

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, 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.

Action Commitments

This group box enables you to determine how far back in time your institution wants the system to go when returning gifts and pledges for display on the Action Results page. The system will display all gifts with an age of [current date] minus [Gift Days value]. The same rule applies to Pledge Days. The default value for both fields is set to 60 but can be changed to include gifts or pledges beyond 60 days.

Click to jump to parent topicDefining Name Display Settings

To define how the system displays names throughout Contributor Relations pages, use these components: Name Display Type (SCC_NMD_TYP_TBL) and Name Display Type Parameters (SCC_NMD_TYP_PRM).

This section provides an overview of name display and discusses how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding Name Display

The Name Display framework provides a configurable solution that allows institutions to define how a display name will appear throughout the Contributor Relations product. This functionality specifically focuses on how a display name appears at the top of the page (at Level 0), not elsewhere on the page. Note that this functionality only impacts pages accessed through the Contributor Relations menu; the style and formatting does not follow to a component accessed from a link within a component or which results in a transfer to a component not on the Contributor Relations menu.

Click to jump to top of pageClick to jump to parent topicPages Used to Define Name Display Settings

Page Name

Definition Name

Navigation

Usage

Name Display Type

SCC_NMD_TYP_TBL

Set Up SACR, Product Related, Contributor Relations, CR Common Definitions, Name Display Type Setup

Set the various display properties for a display name.

Name Display Type Parameters

SCC_NMD_TYP_PRM

Click the Edit Parameters button on the Name Display Type page.

Further configure how the system will display names throughout Contributor Relations.

Click to jump to top of pageClick to jump to parent topicDefining a Name Display Type

Access the Name Display Type page (Set Up SACR, Product Related, Contributor Relations, CR Common Definitions, Name Display Type Setup).

There are four delivered Style choices: PABOLDBLUETEXT, PABOLDTEXT, PSTEXT, and STRONG; PSTEXT is the default value. The system always applies the style you select here to a display name, regardless of any additional parameters. After saving this page, click the Edit Parameters button to access the Name Display Type Parameters page, where you can further define how names will appear.

Click to jump to top of pageClick to jump to parent topicConfiguring Name Display Rules

Access the Name Display Type Parameters page (Click the Edit Parameters button on the Name Display Type page).

Name Types

Name Type

Select a name type, which is defined on the Name Type Table page. You can assign multiple name types (such as Primary, Preferred, and Legal) to each Name Display Type. The value selected here determines which name type the system displays for a person's record on the Name Display subpage at Level 0 in a component.

Order

Rank the Name Type in the Name Type hierarchy for the Name Display Type. The system uses this hierarchy in the Display Name resolution process, and determines the particular name display options to use for a display name.

Default Name Field

Select from three delivered options: Use Formal Name, Use Name, or Use Name Display. If no Country Rules are specified, the Default Name Field value is used to derive the Display Name.

Country Rules

You can define multiple sets of country rules for each Name Type. For example, your institution might define English country rules for the primary name type and Belgian country rules for the preferred name type. If you specify country rules, then you must select an option in the Name Field group box.

Format Using

The system only displays PeopleSoft-supported countries in this list.

Test EmplID

Add person IDs to this grid, which allows you to select test IDs to see how a name will actually display on a page based on the rules entered. You can only add IDs whose names include parts associated with the country.

Name Field

Use the fields in this group box to override the Default Name Field option in the Name Types group box and customize names for a specific country format. You can define the name's appearance part by part, as you go; the appearance of each ID added to the Name Display Test group box will refresh on any field change you make.

There are four options in this group box: Use Name Display, Use Formal Name, Use Name, and Use Name Parts. If you select the Use Name Parts option, the Name Parts grid appears. The grid displays Name Fields specific to the country selected.

Part Type

Available options are: Name Field, Space, or User Defined.

Name Field: contains values that are dependent on the selected country format such as First Name, Middle Name, Last Name.

Space: allows you to add a single space between other part types. Spaces can only be specified from Part 2 onward.

User Defined: allows you to define other characters (such as commas or periods), or a character string up to 35 characters long.

Name Field

The values that appear in this column are country-specific, based on your selection in the Format Using field.

Dependency

Enter a number to specify a dependent Part, so that parts will only be displayed when their dependent parts contain a value. For example, if a prefix is listed but a person has no prefix associated with their name record, the system ignores the entire prefix (name part, punctuation, and spaces) and moves to the next part in the list.

Ignore Criteria

This group box is hidden by default; select the Ignore Rules check box to make it appear. Use the fields here to ignore any Name Field parts of a name. For example, you can make selections here to remove any special characters (such as * or !) used as placeholders for people with single names in your database.

Click to jump to parent topicAdding Resources

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:

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 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_DESIGNATION

Designation Funds

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

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

Page Name

Definition Name

Navigation

Usage

Roles

AV_PRPS_TBL

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

Set up the resource roles at your institution.

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, and assign roles to them.

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 fund-raising and cultivation purposes, and assign roles to them.

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 for your institution.

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

Access the Roles page (Set Up SACR, Product Related, Contributor Relations, CR Common Definitions, Resources, Roles).

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 session 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 membership session 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.

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

Access the Define Staff or the Define Volunteers page (Set Up SACR, Product Related, Contributor Relations, CR Common Definitions, Resources, Staff or Set Up SACR, Product Related, Contributor Relations, CR Common Definitions, Resources, Volunteers).

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.

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

Access the Units page (Set Up SACR, Product Related, Contributor Relations, CR Common Definitions, Resources, Units).

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.