This chapter discusses how to:
Search for records.
Add people to the system.
Manage addresses and phone numbers.
Track external system IDs.
Manage names.
Maintain constituent types.
Track religious preferences.
Maintain photos.
Add constituent types to graduates.
Maintain degree information.
Maintain work experience information.
Add organizations.
Enter location data for organizations.
Enter department data for organizations.
Enter contact data for organizations.
Maintain organization financial information.
Defining organization foundation information.
View organization foundation information.
Define an organization’s matching gift rules.
View an organization’s matching gift rules.
Review organization data.
View an organization’s employee list.
View a person profile.
View an organization profile.
View a prospect profile.
Update a donor’s record or add a donor.
View a constituent’s audience history.
Maintain involvement information.
Establishing relationships.
See Also
This section provides an overview of records and discusses how to use Search/Match functionality.
Contributor Relations uses Search/Match functionality to search for constituent records. The search and results pages are identical to those used by Campus Community and enable you to search for specific people based on basic information such as name and address. This page should be used to ensure that a person does not already have an existing record before you add the person to the system.
Page Name |
Object Name |
Navigation |
Usage |
HCR_SM_SEARCH |
Contributor Relations, Constituent Information, People, Search/Match |
Specify sets of criteria and arrange them in order for searching for duplicate or multiple records. |
|
HCR_SM_RESULTS |
Click the Search button on the Search Criteria page. |
View search results, based on the criteria you enter on the Search Criteria page. |
To avoid entering duplicate personal records, use Search/Match functionality any time that you are entering a new person in the database. Search/Match criteria is utilized when you save a new person, but if a potential duplicate is detected, use Search/Match anyway to investigate the existing person records. Start with Search/Match to look for the person before adding them to the database. Search/Match also is used to search for external organizations.
To set up Search/Match for Contributor Relations, use the delivered search parameters and result codes. These predefined sample searches are PSCS_CR SEARCH for Person and Org. These delivered search parameters enable you to include fields specific to Contributor Relations in your search results set.
Example
Here is an example of Contributor Relations-specific Search/Match functionality that an institution might use:
Here are the results of the search in this example:
See Also
This section lists the pages used to add people to the system. These pages maintain all biographical information about the constituent.
Note. Contributor Relations uses Campus Community pages to maintain biographical information.
See Adding a Person to Your Campus Solutions Database.
Page Name |
Object Name |
Navigation |
Usage |
SCC_BIO_DEMO_PERS |
Contributor Relations, Constituent Information, People, Add/Update a Person, Biographical Details |
Enter biographical information, such as name, addresses, phone, email, gender, citizenship information, and marital status. |
|
SCC_BIO_DEMO_REG |
Contributor Relations, Constituent Information, People, Add/Update a Person, Regional |
Enter regional biographical information, organized by country. |
This section discusses how to:
Update linked addresses.
Review address data.
Enter electronic addresses.
Note. Contributor Relations uses Campus Community pages to maintain addresses and phone numbers. You can use these pages to update linked addresses, track electronic addresses, and view address data.
Page Name |
Object Name |
Navigation |
Usage |
RUNCTL_ADDRLINK |
|
Update linked addresses. |
|
ADDRESSES_89 |
Campus Community, Personal Information, Biographical, Addresses/Phones, Addresses |
View or update a list of all addresses in the system for an individual. |
|
E_ADDR_PERS |
Campus Community, Personal Information, Biographical, Addresses/Phones, Electronic Addresses |
Enter or review email and URL addresses for an individual. |
|
CC_ADDR_SEASONAL |
Campus Community, Personal Information, Biographical, Addresses/Phones, Seasonal Addresses |
Enter or review seasonal addresses for an individual. |
|
PHONE_PERS |
Campus Community, Personal Information, Biographical, Addresses/Phones, Phones |
Enter or review phone details for an individual. |
When you update the address for someone who is linked to an individual, the address for the linked entity is not changed in the database on the Addresses page for the primary individual until you run the Update Linked Addresses process. When you run the process, the system finds the primary individual and updates the address data.
See Also
Access the Addresses page to view information about a constituent who is a person.
See Also
Entering Addresses for an Individual
Access the Electronic Addresses page to maintain information about a constituent's email and URL addresses. You can specify a type for each address, such as work and home.
See Also
Entering Electronic Address Data
Use the External System IDs page to track constituent IDs by a number other than the Contributor Relations ID.
See Also
Use the Names page to specify a name type and name part for each full name and name part that an individual may use.
See Also
This section provides an overview of constituent types and discusses how to assign constituent types.
Constituent types are the relationships that exist between a constituent and your institution. Constituent types are used extensively in reporting and in completing many business processes.
Page Name |
Object Name |
Navigation |
Usage |
AV_CNST_TYPE_TBL AV_CNST_TYPE_TBL_W |
|
Assign constituent types to a constituent. |
|
AV_CNST_TYPE_INQ AV_CNST_TYPE_INQ_W |
|
View a list of all the constituent types assigned to a constituent. |
Access the Constituent Type page.
Your selections on this page indicate the relationships that exist between a constituent who is a person and your institution. An organization can be assigned one constituent type. You can assign an organization's constituent type on the Organization Financial Information page.
Past |
Select if the constituent no longer has the relationship with your institution. For example, if a constituent has a value of Parent, and the child graduates, select the Past option for the constituent type of Parent. |
Note. When constituent types are assigned to a constituent, you cannot delete the last remaining constituent type assignment. For example, if a constituent is assigned values of Alumni and Parent, you can delete one of these constituent types, but one must remain in the system.
Use the Religious Preference page to indicate a constituent's religion, if any. You can view a constituent's religious preference on the Person Profile page.
See Also
Entering Religious Preferences
You can store photographs of your constituents. Photographs are stored the same way that they are stored in any Windows application.
See Also
This section discusses how to run the Graduates to Alumni Application Engine process (AV_CONF_ALUM).
Contributor Relations provides a job process that searches for a group of graduates and adds to their records a constituent type of Alumni, based on each graduate’s program completion date. Running the process also generates a report that lists the search results and notes any record changes.
Page Name |
Object Name |
Navigation |
Usage |
AV_RUNCTL_CONFR |
Contributor Relations, Constituent Information, People, Process Biodemo Information, Graduates to Alumni |
Run the process that adds a constituent type of Alumni to a graduate. The criteria entered on this page determine which graduates are selected for the process. |
Access the Graduates To Alumni page.
Report Only |
Select to generate the Graduates To Alumni report (AV702) without making any changes to the Constituent Type table (PS_AV_CNST_TYP_TBL). Clear to both generate the report and add the graduates to the Constituent Type table with a constituent type of Alumni. |
Academic Institution |
Enter the associated academic institution for the graduates. |
Academic Career |
Select the associated academic career for the graduates. These values are defined by the institution. |
Completion Term |
Enter the term in which the graduates were granted or will be granted their degrees. These values are defined by the institution. |
Constituent Type |
Displays Alumni, the only constituent type that is assigned by this process. |
When users run this process, the system does the following:
Gathers all records that meet the institution, academic career, and completion term criteria from the Graduates to Alumni page, where the value in the Degree Confer Date field is not ‘Null’ and the value in the Degree Status field is Active.
Determines whether these records already have a constituent type of Alumni.
If the Report Only check box is cleared, the system updates the Constituent Type table where required.
If the person is not already assigned a constituent type of Alumni (type = 1), then a record is inserted for the current date with a constituent type of 1.
Regardless of whether the Report Only check box is selected, the system generates the Graduates To Alumni report AV702.
See Also
Contributor Relations Reports: Selected Reports
This section discusses how to:
Maintain external degree information.
View an academic summary.
Set a constituent's preferred year.
Enter internal legacy degree information.
The system enables you to enter and track external degree information, or information about degrees earned from institutions other than your own. In addition, you can view information about both internal and external degrees.
Page Name |
Object Name |
Navigation |
Usage |
AV_EXT_DEGR AV_EXT_DEGR_W |
Contributor Relations, Constituent Information, People, Academic Information, External Degrees |
Add information about degrees that a constituent earned at institutions other than your own. |
|
AV_ACAD_SUMM |
Contributor Relations, Constituent Information, People, Academic Information, Academic Information Summary |
View a summary of information about a constituent's internal, external, and legacy degrees. |
|
AV_INT_DEGREE |
Contributor Relations, Constituent Information, People, Academic Information, Class Year, Preferred Class Year |
Enter a constituent's class year at your institution. Preferred year displays on pages throughout the system when a person is the Level 0 key. |
|
AV_LEGACY_DEG |
Contributor Relations, Constituent Information, People, Academic Information, Class Year, Internal Legacy Degrees |
Enter information about degrees earned at your institution without setting up the entire academic structure for each degree. |
Access the External Degrees page.
Org ID (organization ID) |
Select the institution from which the constituent earned the external degree. |
Degree Nbr (degree number) |
This value is automatically calculated by the system. The first record that you enter has a degree number of 1, the next 2, and so on. |
Data Source |
Select the name of the organization from which you obtained information about the degree. Data source values are delivered with the system as translate values. You can modify these translate values. |
Degree |
Select the type of external degree received or in progress. Degrees are defined on the Degree Table page. Note. To enter a degree that is not defined in the Degree table, leave the Degree field blank and type the appropriate information in the Description field. |
Honors Category |
If the person received an honor for this degree, select the appropriate value. Honors categories are delivered with the system as translate values. You can modify these translate values. |
Degree Status |
Select the current status of the degree. Degree statuses are delivered with the system as translate values. You can modify these translate values. |
External Subject Area/Field of Study |
If there are subject areas or fields on which the constituent concentrated for this degree, enter them in these fields. You may prompt on these fields to access values from the External Subject table. Or, if you prefer to enter an external subject area that is not defined in the system, leave the field blank, tab to the related description field, and enter any text. |
External Career |
Select any external careers for the constituent. External careers are delivered with the system as translate values. You can modify these translate values. |
Data Nbr (data number) |
If this degree information is related to a particular transcript or source of information, enter the data number of the transcript or other source, from the External Data page. You cannot make a link to a data number until the External Data page has been saved. |
Org Primary Location (organization primary location) |
Click to view the primary address of the school to which this degree is related. On that page, click the Detail button to view additional information regarding the school. |
Access the Academic Information Summary page.
This page displays a combined view of all degree information about a constituent in the system. This includes degrees earned at your institution and at institutions other than your own.
Access the Preferred Class Year page.
Preferred Class Yr (preferred class year) |
Enter the year that the constituent wants to use as class year. For example, a constituent with both an undergraduate and graduate degree may prefer to use the graduate degree as the preferred year. This year displays on many pages throughout the system. |
Alumnus Type |
Select the constituent's alumnus type. This field supports Part IV of the CAE report. The values for this field are shipped with the system. Values are: G: Graduate. N: Non-degree. U: Undergraduate. |
Additional information about the constituent's academic career at your institution displays on this page.
Access the Internal Legacy Degrees page.
Enter values in the Class Year, Attended From and To dates, Degree, Major, Major 2, Minor, Minor 2, Campus, and Academic Organization fields. List any distinctions earned with the degree in the Distinction field.
Note. The information on this page is stored in the PeopleSoft Enterprise Student Records system.
This section lists the pages used to maintain a constituent’s work experience information.
Page Name |
Object Name |
Navigation |
Usage |
PRIOR_WORK_EXP |
|
View information about a constituent's current and past employment. |
|
AV_EMPL_HIST |
Contributor Relations, Constituent Information, People, Relationships, Work Experience History |
View a constituent's employment history. |
|
AV_EMPL_HIST_SP |
Click the Detail link on the Work Experience inquiry page. |
View detailed information about an employee’s record. |
|
AV_ORG_LOC_DTL_SP |
Click the Locations button on the Employment History Detail page. |
View information about an organization’s physical locations. |
|
AV_EMP_PHONE_SP |
Click the Phones button on the Employment History Detail page. |
View a list of all the valid phone numbers for an organization. |
|
AV_EMP_EMAIL_SP |
Click the Email/URL button on the Employment History Detail page. |
View the email addresses and URL addresses for an organization. |
Use the Organization Table component to add external organizations to the system.
See Also
Adding Organizations to Your Database
Use the Location Detail component to enter information regarding the addresses and phone numbers of the organizations in the system. Organization locations should be entered before organization departments and organization contacts.
See Also
Entering Organization Location Data
Use the Organization Department Detail component to record information at the department level for an organization. Organization departments should be entered after organization locations and before organization contacts.
See Also
Entering Organization Department Data
Use the Contact Detail component to maintain information about the contacts that your institution uses at a particular organization. You may have several contacts at one organization that are used for specific purposes, such as a Matching Gift contact and a Community Relations contact.
See Also
Entering Organization Contact Data
This section discusses how to enter organization financial information.
Access the Organization Financial Info page.
Employee Count |
Enter the number of people currently employed at the organization. |
Alumni Count |
Displays the total number of alumni who are employees of the organization. |
Stck Exch (stock exchange) |
Select the name of the stock exchange in which the organization's stock trades, if applicable. Values are: AMEX, NASDAQ, and NYSE. |
Symbol |
Enter the stock exchange symbol under which the organization's stock trades, if applicable. You can enter up to 10 characters. |
Description |
Enter a description of the organization and the type of business it runs. You can enter up to 30 characters. |
SIC |
Select the Standard Industrial Code for the organization. |
Fiscal Year |
Enter the four-digit fiscal year for which you are recording financial information. |
From Date and To Date |
Select the from date and to date that define the fiscal year that you selected. The fiscal year should reflect the organization's fiscal year and not necessarily that of your institution. If information on this page is entered in a currency other than base currency, the system calculates conversion based on the exchange rates on the date in the To Date field. |
Revenue Amount |
Enter the total amount that the organization received in revenues during the fiscal year. |
Base |
Click to convert the amounts on this page to your institution’s base currency. The system converts the values by using the exchange rate that is in effect on the date that you selected. The button label changes to Entry. Click the button again to toggle back to entry mode, where you can change the values. |
Expenses Amount |
Enter the total amount that the organization incurred as expenses during the fiscal year. |
Profit/Loss Amount |
Displays the organization's profit or loss for the fiscal year that you selected, based on revenue minus expenses. |
Assets Amount |
Enter the total worth of all assets held by the organization during the fiscal year. |
Liability Amount |
Enter the total amount of all liabilities owed by the organization during the fiscal year. |
Equity Amount |
Displays the organization's total equity for the fiscal year that you entered, based on assets minus liability. |
Source Description and Date |
Enter the person or publication that provides organization financial information to your institution, and the date on which organization financial information was obtained. |
Contributions Total |
Enter the total amount of all contributions made by the organization to your institution and other entities during the fiscal year. |
Use the Organization Foundation component to define and manage foundation-specific information for external organizations that may be approached for foundation support. You can track and view foundation interests and proposal requirements.
This section discusses how to:
Define basic foundation information.
Define foundation support information.
Define proposal information.
See Also
Viewing Organization Foundation Information
Page Name |
Object Name |
Navigation |
Usage |
AV_ORG_FND_INFO |
Contributor Relations, Constituent Information, Organizations, Organization Information, Organization Foundation Information |
The Foundation Information component assists in tracking philanthropic foundations that support or may support your institution. It also enables you to track specific interests of the foundation that can later be used to identify prospects for particular funding projects. |
|
AV_ORG_FND_SUPP |
Contributor Relations, Constituent Information, Organizations, Organization Information, Organization Foundation Information, Support Areas |
Store data that can be used to data mine for foundation donors that have a good potential for funding a proposal for a specific project. |
|
AV_ORG_FND_PROP |
Contributor Relations, Constituent Information, Organizations, Organization Information, Organization Foundation Information, Proposal Info |
Enter information related to the application process for the foundation. |
Access the Foundation page.
Basic Information
Parent Company |
Select the external organization that is the parent of the foundation. The Create Relationship link enables you to create an organization-to-organization relationship if one is not defined in the system. |
Established |
The date on which the organization was established. |
Foundation |
Indicate whether a foundation is company-sponsored, private, family-based, and so on. Corporate, Family, and Private are delivered values. |
Purpose and Activities
Enter a brief description of the reason for the foundation’s existence and the types of activities in which it engages.
Financial Information
Use the fields in this group box to enter the foundation's financial data.
Fiscal Year |
The financial reporting year for which the financial data is pertinent. |
From Date and To Date |
The first and last date of the fiscal year to which the data pertains. |
Assets Amount |
The financial holdings of the foundation. |
Expenditures Amount |
The amount of expenses the foundation had in the related year. |
Distribution Amount |
The amount of funding available to be distributed as grants or funded proposals. |
Date |
The date the information was obtained from the source. |
Source |
The originator of the foundation financial information, for example the Foundation Directory. |
Grants Amount |
The amount actually funded, which may differ from the distribution amount if all funding is not awarded. |
Highest Grant Amount |
The largest grant awarded by the foundation. |
Lowest Grant Amount |
The smallest grant awarded by the foundation. |
Average Grant Amount |
The typical amount of a grant or proposal funded by the foundation. |
Access the Support Areas page.
Fields of Interest |
Enter areas of charitable interest involvement that the foundation is known to support financially. The involvement code description appears at the right. |
Geographic Areas |
Enter any geographic restrictions that the foundation considers when selecting proposals for funding. The description appears at the right. |
Types of Support |
Indicate the kinds of activities the foundation will support. Delivered system values include: Capital Campaigns, Building/Renovation, Equipment, Program Development, Seed Money, Curriculum Development, and Matching/Challenge. |
Access the Proposal Info page.
Contact Type and Contact |
The organization contact that is responsible for proposal reviews for the foundation. |
Deadlines |
The months and dates, such as March 15, each year that the foundation sets as the cut-off date for submitting proposals for consideration by the foundation. |
Board Meeting Dates |
The months and dates, such as March 15, when the foundation board meets to review proposals. |
Notification Dates |
The months and dates, such as March 15, by which the foundation will notify applicants of the success of their submitted proposals. |
Use the Review Organization Foundation and Foundation Summary components to view foundation information entered in the system. You can review the data that was entered in the Organization Foundation component and you can also filter and review foundation information based on your criteria.
This section discusses how to:
Review foundation information.
Filter foundation records.
See Also
Defining Organization Foundation Information
Page Name |
Object Name |
Navigation |
Usage |
AV_ORG_FND_INQ |
Contributor Relations, Constituent Information, Organizations, Organization Information, Review Foundation Information |
This component can be used to review foundation information or to search for foundations that might be prospects for a specific project based on foundation funding interests and timing. |
|
AV_ORG_FND_INQ_F |
Contributor Relations, Constituent Information, Organizations, Organization Information, Foundation Summary |
Filter the types of foundations that you view on the Foundation Summary page. |
|
AV_ORG_FND_INQ_D |
Contributor Relations, Constituent Information, Organizations, Organization Information, Foundation Summary, Foundation Summary |
View a list of the foundation records that match the filter criteria that you specify on the Foundation Filter page. |
Access the Organization Foundation Information page.
This page presents a summary of an organization's foundation details that exist in the system.
Proposal Information |
Click this link to access the Proposal Information page. |
Access the Foundation Filter page.
This page enables you to search for foundation records based on financial criteria, fields of interest, geographic area, and types of support. Click the Search button and view the search results on the Foundation Summary page.
Use the Matching Rules component to define the matching gift rules for an organization. You can maintain information about minimum match amounts and match ratios, the designations for which gifts can be matched, the annual matching gift budget, required information and contacts, and any matching gift restrictions that the organization has.
See Also
Defining an Organization’s Matching Gift Rules
Use the Matching Rules inquiry component to view the matching gift rules for an organization. You can view information about minimum match amounts and match ratios, the designations for which gifts can be matched, the annual matching gift budget, required information and contacts, and any matching gift restrictions that the organization has.
See Also
Viewing an Organization’s Matching Gift Rules
When you have entered the organization, location, department, and contact information for an organization, you can review that information quickly and easily through Campus Community pages.
See Also
This section discusses how to view employee lists.
Page Name |
Object Name |
Navigation |
Usage |
AV_EMPL_LIST_E AV_EMPL_LIST_W |
|
View a list of all the constituents in the system who are employed by an organization. You can view both current and historical lists of an organization's employees. |
Access the Employee List page. Each employee name appears as a link. Click any name link to access the Person Profile page for that employee and read more about the person.
Click the Details button to view detailed information about a specific employment record on the Employment History Detail page.
You can build a workset from this page.
See Also
Building a Workset From a Page in the System
Profiles for people and organizations enable you to view a summary of information in the system about a particular constituent. The system includes both a Person Profile and an Organization Profile page.
This section provides an overview of person profile views and discusses how to:
View general person profile information.
View a biographic profile.
View a commitment profile.
View a participation profile.
See Also
Each profile view contains several data regions with summary information. This table lists each data region and the profile view that contains it:
Data Region |
Profile View |
Address |
Biographic |
Phone / Email |
Biographic |
Biographic Information |
Biographic |
Work Experience |
Biographic |
Relationships |
Biographic |
Lifetime Giving |
Commitment |
Historical Giving |
Commitment |
Involvement |
Participation |
Volunteer Activities |
Participation |
Memberships |
Participation |
As you collapse and expand each profile view, the system populates the data regions within the view.
Page Name |
Object Name |
Navigation |
Usage |
AV_PRSN_PROFILE AV_PRSN_PROFILE_W |
|
View summary information about a constituent who is a person, without having to navigate through the menus in the system. |
Access the Person Profile page.
The default settings that determine what you see—which profile views expand, as well as the address, phone, and email views that appear—are defined on the Operator Defaults page.
Common Fields
Some fields on this page are not dependent on which profile view is expanded. The system always displays the following information at the top of the page: constituent name, ID, constituent type, class year, institution, spouse button (if a spousal relationship exists), 3Cs buttons, and a button to access the FERPA Bio Demo page.
Constituent Type |
Click to access the Constituent Type Summary page, which lists all types assigned to a constituent. |
Year |
If academic information exists for the constituent in the system, the class year appears as a link. Click the link to access the Academic Information inquiry component. If no class year exists, but the system has academic information for the constituent, None appears here as a link. Click the link to access the Academic Information inquiry component. |
Profile View |
Select a profile view—Biographic, Commitment, or Participation—to expand it below and populate its data regions. Click the arrow next to the region’s name to expand or collapse data regions manually. |
Printer Friendly Version |
Click to access a read-only version of the page that expands all rows of all populated data regions. You can print this page by using your browser’s print functionality. Click the Return button to return to the Person Profile page. |
Expand All and Collapse All |
Click to either expand or collapse all data regions below. |
Clearance Required |
If this check box is selected, clearance is required before contacting the constituent. Clearances are set on the Clearance page. |
Prospect Manager |
Displays the name of the constituent’s assigned prospect manager. Prospect managers are assigned on the Staff Assignment, Volunteer Assignment, and Unit Assignment pages. If the prospect manager has an active email address on the Electronic Addresses page, the name appears as a link. Click the link to launch your email application and send a message to that person. |
Additional Information
The system displays messages at the bottom of the page based on the following conditions:
Note. Where no data exists, the system hides the data region.
Data Region |
Condition |
Message |
Membership |
No data exists. |
No Membership History on file. |
Data exists, but user does not have access to the Person Membership History page from any menu. |
Membership History on file. |
|
Lifetime Giving Historical Giving |
No data exists. |
No Giving Information on file. |
Data exists, but user does not have access to the Person Giving Profile page from any menu. |
Giving Information on file. |
|
Work Experience |
No data exists. |
No Work Experience on file. |
Relationships |
No data exists. |
No Relationship information on file. |
Involvement |
No data exists. |
No Involvement information on file. |
Volunteer Activities |
No data exists. |
No Volunteer Activity information on file. |
The system also displays messages in this area related to the following information:
Additional Information |
Condition |
Message |
Academic Information |
No data exists, and the Class Year link is inactive. |
No Academic Information on file. |
Planned Giving |
No data exists. |
No Planned Giving Donor information on file. |
Data exists. |
Planned Giving Donor information on file. |
|
Ratings |
No data exists. |
No Ratings information on file. |
Data exists. |
Ratings information on file. |
|
Assigned Resources |
No data exists. |
No Resources are assigned to constituent. |
Data exists. |
Resources are assigned to constituent. |
See Also
Managing FERPA Privacy Control
Access the Person Profile page, Biographic Profile view.
This table lists the information sections in this view and the pages from which the system derives the information:
Information Section |
Page |
Address |
Addresses |
Phone / Email |
Phone Numbers Electronic Addresses |
Biographic Information |
Bio/Demo Data Religious Preferences Relationships Decedent Data |
Work Experience |
Work Experience |
Relationships |
Relationships Person to Org Relationships |
Address
Address Type |
Select the type of address that you want to display. The system displays active addresses; inactive addresses will not appear. If a seasonal address is in effect, the system indicates that by displaying a “Seasonal” message. |
Phone / E-mail
Phone Type and Email Type |
Select the types of phone and email address information that you want to display. |
Email Address |
If the constituent has an active email address in the system, it appears as a link. Click the link to launch your email application and send a message to the constituent. |
Biographic Information
This data region displays compiled biographical data, including date of death.
Date of Death |
If the constituent is deceased, and there is a date of death on the Decedent Data page, the system displays it here. |
Work Experience
Employer |
Click a link to access the Employment History Detail page for the constituent. |
Relationships
Relationship |
Click a link to access the Relationship Detail page for the constituent. |
Note. If an existing relationship is a Joint relationship, it is noted next to the Relationship link.
See Also
Maintaining Work Experience Information
Access the Person Profile page, Commitment Profile view.
The system derives information for the Commitment Profile view from the Giving Profile page.
Lifetime Giving
Lifetime Commitments |
Click to access the Giving Profile page for the constituent. |
Historical Giving
Total Year-to-Date Giving |
Click to access the Giving Profile page for the constituent. |
See Also
Access the Person Profile page, Participation Profile view.
This table lists the information sections in this view and the pages from which the system derives the information:
Information Section |
Page |
Involvement |
Involvement Summary |
Volunteer Activities |
Volunteer History |
Membership |
Membership History Prsn (membership history person) |
Involvement
Involvement |
Click a link to access the Involvement Detail page for the constituent. |
Volunteer Activities
Volunteer Role |
Click a link to access the Volunteer Assignment Detail page for the constituent. |
Volunteer Group and Volunteer Sub Group |
These columns display the group or subgroup to which the volunteer belongs. |
Memberships
Membership Organization |
Click a link to access the Membership Detail page for the constituent. If business unit security is active, the system only displays member organizations for accessible business units. |
See Also
Maintaining Involvement Information
This section provides an overview of organization profile views and discusses how to:
View a general organization profile.
View organization details.
View organization financial details.
View commitments.
View organization participation.
Each profile view contains several data regions with summary information. The table below lists each data region and the profile view that contains it:
Data Region |
Profile View |
Location |
Organization Detail |
Organization Departments |
Organization Detail |
Organization Contacts |
Organization Detail |
Relationships |
Organization Detail |
Organization Attributes |
Organization Financial Info |
Organization Financial Information |
Organization Financial Info |
Lifetime Giving |
Commitment |
Historical Giving |
Commitment |
Matching Gifts |
Commitment |
Involvement |
Participation |
Memberships |
Participation |
As you collapse and expand each profile view, the system populates the data regions within the view.
Page Name |
Object Name |
Navigation |
Usage |
AV_ORG_PROFILE AV_ORG_PROFILE_W |
|
View summary information about a constituent that is an organization, without having to navigate through the menus in the system. |
Access the Organization Profile page. The default settings that determine what you see—which profile views expand, as well as the address, phone, and email views that appear—are defined on the Operator Defaults page.
Common Fields
Some fields on this page are not dependent on which profile view is expanded. The system always displays the following information at the top of the page: constituent name, ID, constituent type, institution, and 3Cs buttons.
Profile View |
Select a profile view—Organization Detail, Organization Financial Info, Commitment, or Participation—to expand it below and populate its data regions. Click the arrowhead next to the region’s name to manually expand or collapse data regions. |
Printer Friendly Version |
Click to access a read-only version of the page that expands all rows of all populated data regions. You can print this page using your browser’s print functionality. Click the Return button to return to the Organization Profile page. |
Expand All and Collapse All |
Click to either expand or collapse all data regions below. |
Clearance Required |
If this check box is selected, clearance is required before contacting the organization. Clearances are set on the Clearance page. |
Prospect Manager |
Displays the name of the organization’s assigned prospect manager. Prospect managers are assigned on the Staff Assignment, Volunteer Assignment, and Unit Assignment pages. If the prospect manager has an active email address on the Electronic Addresses page, the name appears as a link. Click the link to launch your email application and send a message to that person’s preferred email address. |
Additional Information
The system displays messages at the bottom of the page based on the following conditions:
Note. Where no data exists, the system hides the data region.
Data Region |
Condition |
Message |
Location |
No data exists. |
No Locations on file |
Organization Departments |
No data exists. |
No Organization Departments on file |
Organization Contacts |
No data exists. |
No Organization Contacts on file |
Relationships |
No data exists. |
No Relationships on file |
Organization Attributes |
No data exists. |
No Organization Attributes on file |
Organization Financial Information |
No data exists. |
No Organization Financial Information on file |
Lifetime Giving Historical Giving |
No data exists. |
Constituent is not a donor |
Data exists but user does not have access to the Giving Profile - Org page from any menu. |
Constituent is a donor |
|
Matching Gifts |
No data exists. |
Not a Matching Gift donor |
Data exists but user does not have access to the Giving Profile - Org page from any menu. |
Constituent is a Matching Gift donor |
|
Involvement |
No data exists. |
No Involvement information on file |
Memberships |
No data exists. |
No Membership information on file |
Data exists but user does not have access to the Membership History page from any menu. |
Membership information on file |
The system also displays messages in this area related to the following information:
Additional Information |
Condition |
Message |
Ratings |
Data exists on the AV_PRSN_RATING_E record. |
Ratings information on file |
No data exists. |
No Ratings information on file |
|
Assigned Resources |
Data exists on the AV_ASGN_STAFF, AV_ASGN_VOL, or AV_ASGN_UNIT records. |
Prospect resources are assigned to the constituent |
No data exists. |
No Resources are assigned to the constituent |
Access the Organization Profile page, Organization Detail view.
The following table lists the information sections in this view and the pages from which the system derives the information:
Information Section |
Page |
Location |
Location Detail |
Organization Departments |
Department Detail |
Organization Contacts |
Contact Detail |
Relationships |
Organization Relationships Org/Person Relationships |
Location
Location |
When you select a location, the system populates the address, phone, email, and URL address information. |
Phone Type |
The system displays the selected phone type. |
Email ID |
If the organization has an active email address in the system, it appears as a link. Click the link to launch your email application and send a message to the constituent. |
URL Address |
If the organization has an active website address on file, it appears as a link. |
Note. The phone, email, and URL information that the system displays changes based on the location selected.
Organization Departments
Phone |
Click the link to access the Department Phone Information page. |
Location |
Click the link to access the Department Location Information page. |
Organization Contacts
Contact Name |
Click to access the Organization Contact Phone information page. |
Location |
Click the link to access the Contact Location Information page. |
Relationships
This group box displays a combination of organization-to-person and organization-to-organization relationships defined in the system.
Relationship |
Click to access the Relationship Detail page and view more details. |
Access the Organization Profile page, Organization Financial Info view.
The following table lists the information sections in this view and the pages from which the system derives the information:
Information Section |
Page |
Organization Attributes |
Organization Financial Information |
Organization Financial Information |
Organization Financial Information |
Organization Attributes
Stock Exchange and Symbol |
Displays the name of the stock exchange and the stock exchange symbol under which the organization's stock trades. |
Industry Code (SIC) |
Displays the Standard Industrial Code for the organization. |
Employee Count and Alumni Count |
Displays the number of people currently employed at the organization and the total number of alumni who are employees of the organization based on a system ID and a work experience record. |
Organization Financial Information
Revenue Amount |
Displays the total amount the organization received in revenues during the fiscal year. |
Expenses Amount |
Displays the total amount the organization incurred as expenses during the fiscal year. |
Assets Amount |
Displays the total worth of all assets held by the organization during the fiscal year. |
Liability Amount |
Displays the total amount of all liabilities owed by the organization during the fiscal year. |
Contributions Total |
Displays the total amount of all contributions made by the organization to the institution as well as other entities during the fiscal year. |
See Also
Maintaining Organization Financial Information
Access the Organization Profile page, Commitment view.
The following table lists the information sections in this view and the pages from which the system derives the information:
Information Section |
Page |
Lifetime Giving |
Giving Profile |
Historical Giving |
Giving Profile |
Matching Gifts |
Ext Org Matching Gifts |
Note. If giving profile security is active, the system may not display the Lifetime Giving or Historical Giving group boxes. Instead, the system displays messages in the Additional Information group box. The messages indicate that the organization is a donor, but provide no giving details.
Lifetime Giving
Lifetime Commitments |
Click to access the Giving Profile page for the organization. |
Historical Giving
Total Year-to-Date Giving |
Click to access the Giving Profile page for the organization. |
Transaction Register |
Click to access the Transaction Register - Org page to view more giving details. |
Matching Gifts
Lifetime Match |
Click to access the Ext Org Matching Gifts page for the organization. |
Matching Gift Rules |
Click to access the Matching Rules page for the organization. |
See Also
Access the Organization Profile page, Participation view.
The following table lists the information sections in this view and the pages from which the system derives the information:
Information Section |
Page |
Involvement |
Involvement Summary |
Memberships |
Membership History Org (membership history organization) |
Involvement
Involvement |
Click a link to access the Involvement Detail page for the organization. |
Memberships
Membership Organization |
Click a link to access the Membership Detail page for the organization. Note. If business unit security is active, the system only displays member organizations for accessible business units. |
See Also
Contributor Relations provides a Prospect Profile page that presents a 360-degree view of a prospect’s connections with your institution. The page contains a large amount of information as well as links to other pages in the system to enable you to find more detailed information. The data regions available on the page will change depending on whether the prospect is a person or an organization.
This section provides an overview of prospect profile views and discusses how to:
View a general prospect profile.
View prospect management details.
View prospect philanthropic interests.
Note. If prospect management security is active, the system may not display this page at all. Instead, the system displays messages in the Additional Information group box at the bottom of the Person Profile or Organization Profile page. These messages provide information about the amount and type of prospect information in the system, but reveal no details.
Each profile view contains several data regions with summary information. The table below lists each data region and the profile view that contains it:
Data Region |
Profile View |
Assigned Resources |
Prospect Management |
Clearances |
Prospect Management |
Strategies |
Prospect Management |
Recent Actions |
Prospect Management |
Next Actions |
Prospect Management |
Ratings |
Prospect Management |
Charitable Involvement |
Philanthropic Interests |
Designations Supported |
Philanthropic Interests |
Personal Assets |
Prospect Management (people only) |
Planned Giving |
Philanthropic Interests (people only) |
As you collapse and expand each profile view, the system populates the data regions within them.
Page Name |
Object Name |
Navigation |
Usage |
AV_PROSPROF_P, AV_PROSPROF_E, AV_PROSPROF_W, AV_PROSPROF_WE |
|
View summary information about a prospect, without having to navigate through the menus in the system. |
Access the Prospect Profile page. The default settings that determine what you see—which profile views expand, as well as the address, phone, and email views that appear—are defined on the Operator Defaults page.
Common Fields
Some fields on this page are not dependent on which profile view is expanded. The system always displays the following information at the top of the page: constituent name, ID, constituent type, class year (for people), institution, spouse button (for people, if a spousal relationship exists), and 3Cs/Service Indicator buttons.
Constituent Type |
Click to access the Constituent Type Summary page for a person, which lists all types assigned to a constituent. |
Year |
If academic information exists for the person in the system, the class year appears as a link. Click the link to access the Academic Information inquiry component. If no class year exists, but the system has academic information for the prospect, None appears here as a link. Click the link to access the Academic Information inquiry component. |
FERPA (Family Educational Rights and Privacy Act) |
Click to access the FERPA display component for the person, which lists the prospect’s personal data and specifies which information is releasable. |
Profile View |
Select a profile view—Prospect Management or Philanthropic Interests—to expand it below and populate its data regions. Click the arrow next to the region’s name to manually expand or collapse data regions. |
Printer Friendly Version |
Click to access a read-only version of the page that expands all rows of all populated data regions. You can print this page using your browser’s print functionality. Note. Set narrow print margins for your printer. Click the Return button to return to the Prospect Profile page. |
Expand All and Collapse All |
Click to either expand or collapse all data regions below. |
Clearance Required |
If this check box is selected, clearance is required before contacting the prospect. Clearances are set on the Clearance page. |
Prospect Manager |
Displays the name of the constituent’s assigned prospect manager. Prospect managers are assigned on the Staff Assignment, Volunteer Assignment, and Unit Assignment pages. If the prospect manager has an active email address on the Electronic Addresses page, the name appears as a link. Click the link to launch your email application and send a message to that person. |
Additional Information
The system displays messages at the bottom of the page based on the following conditions:
Note. Where no data exists, the system hides the data region.
Data Region |
Condition |
Message |
Assigned Resources |
No data exists. |
No resources are assigned to the constituent |
Clearances |
No data exists. |
No current Clearances for this constituent |
Strategies |
No data exists. |
No current Strategies for this constituent |
Recent Actions |
No data exists. |
No actions for this constituent have occurred in the last year |
Next Actions |
No data exists. |
No future actions are scheduled for this constituent |
Ratings |
No data exists. |
No Ratings information on file |
Charitable Involvement |
No data exists. |
No Charitable Involvement information on file |
Designations Supported |
No data exists. |
Constituent is not a donor |
Personal Assets |
No data exists. |
No Personal Assets on file |
Planned Giving |
No data exists. |
No Planned Giving information on file |
Access the Prospect Profile page, Prospect Management view. The system does not display the Personal Assets section for organizations.
For person records, the Personal Assets grid will appear in the Prospect Management view.
The following table lists the information sections in this view and the pages from which the system derives the information:
Information Section |
Page |
Assigned Resources |
Prospect Assignments |
Clearances |
Clearance |
Strategies |
Strategy Summary |
Recent Actions |
Action Summary |
Next Actions |
Action Summary |
Ratings |
Ratings Summary |
Personal Assets |
Personal Assets |
Assigned Resources
This group box displays current and future assignments.
Role |
Click to access the Assignment Detail page. |
Spouse |
If this check box is selected, indicates that the prospect and spouse are linked, and have the same resources assigned to them. This check box appears only for prospects that are people. |
Clearances
Detail |
Click to access the Clearance page to view more details. |
Strategies
Strategy Name |
Click to access the Prospect Strategy Detail page. |
Spouse Link |
If this check box is selected, it indicates that a linked strategy exists for a spouse in the system. |
Linked Actions |
Click to access the Strategy Linked Actions page. |
Recent Actions
This group box displays actions completed within the last year.
Action Description |
Click to access the Action Detail page. |
Next Actions
This group box displays incomplete actions scheduled in the past year as well as those with a planned date greater than today’s date.
Action Description |
Click to access the Action Detail page. |
Ratings
Rating Category |
Click to access the Ratings Detail page to view more ratings information. |
Personal Assets
This group box appears only for prospects that are people.
Description |
Click to access the Personal Asset Detail page for the prospect. |
See Also
Access the Prospect Profile page, Philanthropic Interests view. The system does not display the Planned Gifts section for organizations.
The following table lists the information sections in this view and the pages from which the system derives the information:
Information Section |
Page |
Charitable Involvement |
Philanthropic Interests |
Designations Supported |
Philanthropic Interests |
Planned Gifts |
Planned Giving Summary |
Charitable Involvement
This group box displays all details about any charitable activities, interests, affiliations, honors/awards, or other involvement for the prospect.
Designations Supported
This group box displays a sum of all gifts to a designation. This summary provides a picture of a prospect’s giving trends.
Designation Name |
Click to access the Account Details page for the designation. |
Planned Gifts
This group box appears only for prospects that are people.
Planned Gift Name |
Click to access the Bequest, Trust, Gift Annuity, or Pooled Income Fund Detail page for the prospect, depending on the type of planned gift that is selected. |
Use the Update Information pages to either update an existing donor’s record or add a new donor to the system.
See Also
Updating or Adding a Constituent Who is a Person
Updating or Adding a Constituent Who is an Organization
This section discusses how to review audience history.
Note. Separate Update Information pages exist for donors who are people and donors that are organizations.
Page Name |
Object Name |
Navigation |
Usage |
AV_AUD_HISTORY AV_AUD_HISTORY_E |
|
Assess the ways in which a constituent is being solicited. This page displays all the target audiences to which the constituent belongs. Audiences are defined for both initiatives and membership organizations, and are based on a variety of attributes. For example, an audience might consist of all constituents who have an involvement of GOLF. |
Access the Audience History page.
Audience |
Lists the name of the initiative audience to which the constituent belongs. |
Audience Type |
Indicates whether the audience is for the purpose of Administration, Segmentation, or Reporting. |
Initiative |
Lists the name of the initiative to which the audience is associated. |
Initiative Type |
Indicates whether the initiative is a campaign, volunteer effort, event, membership effort, or other type. |
This section provides an overview of involvement and discusses how to:
Add involvement records.
Filter involvement records.
Create an involvement roster.
The Involvement component of Contributor Relations enables you to maintain information about a constituent’s activities, affiliations, interests, and awards and honors. When you create an involvement record, you identify the involvement type, a description of the involvement, a category such as charitable or political, an institution, and start and end dates.
Page Name |
Object Name |
Navigation |
Usage |
AV_INVLV AV_INVLV_E AV_INVLV_W |
|
Add new involvement records for a constituent. |
|
AV_INVLV_FLTR AV_INVLV_FLTR_E AV_INVLV_FLTR_W |
|
Filter the types of involvement that you view on the Involvement Summary page. |
|
AV_INVLV_SMRY AV_INVLV_SMRY_E AV_INVLV_SMRY_W |
|
View a list of the involvement records that match the filter criteria that you specify on the Involvement Filter page. |
|
AV_INVLV_DTL_SP |
|
View additional information about an involvement record. |
|
AV_I_INVLV_FLTR |
Contributor Relations, CR Reports, Involvement Roster, Roster Filter |
Create a list of all the constituents who share common involvement. For example, you can generate a list of the constituents who participated in the annual 10K walk on your campus, or a list of those constituents with an interest in golfing. |
|
AV_I_INVLV_SMRY |
Contributor Relations, CR Reports, Involvement Roster, Roster List |
View a list of the constituents who share a common involvement based on the selections that you made on the Involvement Roster page. |
Access the Involvement page.
Involvement Type |
Select an involvement type, such as a constituent's interest, activities, awards, or affiliations. Its description appears to the right. |
Involvement Category |
Select a category of involvement information such as professional, charitable, academic, social, religious, and so on. The category's description appears to the right. |
Involvement |
Select an involvement code from the available options, which are defined by your institution. The code's description appears to the right. |
Institution |
Indicate with which institution the involvement is associated. |
Received Date |
If the involvement type is Award and Honor or another type that requires a received date rather than a date range, enter the date in the Rcvd Dt field. Make this determination when defining involvement types. |
Source Description |
The person or publication that alerted you to the constituent's involvement. |
Last Modified Date |
The date on which this information was most recently updated. |
Access the Involvement Filter page.
Institution |
Select the institution for which you want to view involvement information. |
Involvement Type |
Select the involvement types about which you want to view information on the Involvement Summary page. |
Involvement Category |
Select the involvement categories about which you want to view information on the Involvement Summary page. Involvement categories describe the nature of the involvement. |
Search |
Click to retrieve a list of the involvement records that match the criteria that you selected on the Involvement Summary page. |
Access the Roster Filter page.
Involvement Type |
Select the involvement type for which you want to create a roster. Its description appears to the right. |
Involvement Category |
Select the involvement category for which you want to create a roster. Involvement categories describe the nature of the involvement, such as Professional, Political, Charitable, and so on. The category's description appears to the right. |
Involvement Code |
Select the involvement code for which you want to create a roster. Involvement codes describe the specific involvement, such as Golf, Hunting, Dancing, Kiwanis Club, and so on. The code's description appears to the right. |
Search |
Click to retrieve a list of involvement records that make up your roster on the Roster List page. Note. The maximum retrieval value, set on the Institution Installation page, determines the maximum number of results returned per search. |
You can build a workset from the records that you retrieve on the Roster List page.
See Also
Building a Workset From a Page in the System
This section provides an overview of relationships, lists common elements, and discusses how to:
Establish a person-to-person relationship.
Establish an organization-to-organization relationship.
Establish a person-to-organization relationship.
Establish an organization-to-person relationship.
You can establish relationships between two people, two organizations, or a person and an organization.
The relationships that you establish can be reciprocal—that is, when you indicate a relationship in one record, the system creates the relationship in the corresponding record. For example, if you are working with Shawn Gallegher and you create a relationship for him as a trustee of Ford Motor Foundation, the system automatically creates the corresponding relationship in Ford Motor Company's record.
Relationship Nbr (relationship number) |
The system automatically generates a relationship number when you establish and save a relationship. |
Related ID |
Enter the ID of the person or organization to which this constituent is related. Select a related ID if the organization exists in the system. |
Relationship |
Select the nature of the relationship, such as person to organization, organization to organization, or organization to person. Relationship types are shipped with the system as translate values. Do not modify these translate values. Any modifications to these values requires substantial programming. |
Source Description |
Enter the name of the person or publication that provides your institution with information about this relationship. |
Access the Relationships page.
Use the Relationships page to record information about relationships between two people.
See Also
Access the Relationships page.
Reciprocal Relation |
Select the corresponding relationship. For example, if an organization is a parent company, the reciprocal relation might be Subsidiary. You define reciprocal relations using the Reciprocal Relationship page. |
Description |
If you do not select a related ID, enter the name of the related organization. If you select a related ID, the name of the organization appears. |
Address |
If the related organization does not have an ID in the system, click to enter address information on the Address Detail page. |
See Also
Managing Addresses and Phone Data
Access the Person / Org Relationships page.
Relationship |
Enter the relationship that the person has with the organization. For example, if you are defining a trustee/foundation relationship, the person relationship is Trustee or Officer. |
Description |
Displays the name of the related organization. |
Access the Org / Person Relationships page.
Relationship |
Enter the relationship that the organization has with the person. For example, if you are defining a trustee/foundation relationship, the person's relationship to the organization is Trustee. |
Related ID |
Select the name of the related person. |
Prefix |
If you do not select an ID, select a name prefix. If you select an ID, the person’s name prefix appears. |
Suffix |
If you do not select an ID, select a name suffix. If you select an ID, the person’s name suffix appears. |
SSN (social security number) |
If you do not select an ID, enter the person’s SSN. If you select an ID, the person’s SSN appears. |