Understanding InitiativesThis chapter provides an overview of initiative management and discusses how to:
Define an initiative.
Define an initiative audience.
Link related initiatives.
Designate initiative resources.
Define a public relations (PR) plan.
Create an initiative budget and track expenses.
View initiative action summary information.
View related goals.
Viewing responsible staff for related initiatives.
Use mass change for communications to initiative audiences.
See Also
Understanding InitiativesThis section lists prerequisites and discusses initiative management.
PrerequisitesBefore you can manage any type of initiative, you must have completed its setup. All initiatives use a few common setup pages, and some initiatives require additional setup that is specific to their function.
See Also
Initiative Management
To manage any type of initiative (campaign, volunteer effort, membership initiative, event, or other type of initiative):
Create the initiative.
(Optional) Define the audience.
(Optional) Link related initiatives.
(Optional) Assign resources.
(Optional) Create a public relations (PR) plan.
(Optional) Create a budget.
(Optional) Track budget expenses.
(Optional) Create initiative actions.
(Optional) View action summary information.
(Optional) View related goals.
(Optional) View responsible staff for related initiatives.
(Optional) Create initiative or membership letters.
Defining an InitiativeThis section discusses how to create any type of initiative.
Pages Used to Define an Initiative
|
Page Name |
Object Name |
Navigation |
Usage |
|
AV_INTV_CMPGN_MAIN |
Contributor Relations, Initiatives, Campaign Initiatives, Manage Campaigns, Campaign Initiatives |
Begin the process of defining a new campaign initiative at your institution. |
|
|
AV_INTV_MEMBR_MAIN |
Contributor Relations, Initiatives, Membership Initiatives, Membership Initiatives |
Begin the process of defining a membership initiative at your institution. |
|
|
AV_INTV_VOL_MAIN |
Contributor Relations, Initiatives, Volunteer Initiatives, Manage Volunteer Initiatives, Volunteer Initiatives |
Begin the process of defining a new volunteer initiative at your institution. |
|
|
AV_INTV_EVNT_MAIN |
Contributor Relations, Initiatives, Event Initiatives, Manage Events, Event Initiatives |
Begin the process of defining a new event initiative at your institution. |
|
|
AV_INTV_OTHR_MAIN |
Contributor Relations, Initiatives, Other Initiatives, Manage Other Initiatives, Other Initiatives |
Begin the process of defining a new initiative at your institution that is not a campaign, membership initiative, event initiative, or volunteer effort. |
Creating an InitiativeDepending on the type of initiative you want to create, access the Campaign, Membership, Volunteers, Event, or Other Initiatives page.
Fields Common to All Initiatives
|
Name |
Name the initiative, up to 60 characters. |
|
Reporting Level |
Enter a reporting level for the initiative. The highest reporting level is 1. The lowest reporting level is 999. You will receive an error message if you enter an incorrect reporting level. A level 1 initiative cannot be related to another level 1 initiative of the same type. For example, a level 1 campaign cannot be related to another level 1 campaign. Reporting levels are critical when relating other initiatives to an initiative on the Related Initiatives page. Note that you cannot relate any campaigns to events. Events must be in context of the larger campaign; a campaign drives what is related to it. |
|
Business Unit |
Note. Your selection determines the values you can choose from when selecting a responsible department, creating department goals, selecting a public relations appeal, and selecting an appeal for a budget expense. |
|
% Particptn Goal (percent participation goal) and Financial Goal |
Enter a participation goal percentage and a financial goal for the initiative. Goals indicate the amount of or percentage increase in participation that you expect to receive as a result of the initiative. For campaign initiatives, these fields are used in the Campaign Progress Report. For memberships, these fields are used in the Membership Progress page. |
|
Person |
Select a responsible person for the initiative. This field populates by default to the user ID of the person defining the initiative, but can be overridden. To select a new responsible person, click the Quick Search button and select the appropriate ID. When a responsible person is selected, his or her name appears to the right of this field. Only one person can be responsible for an initiative at a given time. |
|
Department |
Select a responsible department for the initiative. The prompt box displays a listing of all the departments associated with the setID for the business unit that you select for this initiative. |
If You Are Creating a Campaign Initiative
|
Phase |
Select a phase to indicate whether the initiative is currently Private or Public. You may want to begin the campaign privately, identifying the pace-setting gifts that form the nucleus fund of the campaign. When the campaign has some momentum from the private phase, you can take it public to complete its goals. |
If You Are Creating a Membership Initiative
|
Mbr Org (member organization) |
Enter the member organization. This code identifies which member organization at your institution owns the membership initiative. The first initiative that you create might not have values in this field because no values might have been set up yet. If so, leave this field blank and return to complete it after you create the appropriate member organization. |
If You Are Creating a Volunteer Initiative
|
Nbr Vol Goal (number of volunteers goal) |
Enter the number of volunteers you want to be involved in the initiative. |
|
Vol Pool Goal (volunteer pool goal) |
Enter the number of constituents you must invite to participate to generate the number of volunteers goal. |
If You are Creating an Event Initiative
|
Event ID |
If you have already created this event on the Event page, select the event ID to link it to this event initiative. Otherwise, click the New ID button to create an event. After you create an event and save the Event page, the system creates an event ID and automatically enters the new ID here. |
|
New ID |
Click to create an event for this event initiative. When you click this button, the system automatically populates the Event page with key values that you entered here. To assist you in creating the event record, the system transfers the event code that you are defining to the Short Description field, the name that you enter to the Description field, and the institution that you select to the Institution field. |
|
Attendance Goal |
Enter a goal that states the expected number of constituents who will attend the event. |
If You Are Creating an Other Initiative
|
Intv Type (initiative type) |
Enter an initiative type. The type you enter should be one not defined by your institution as Campaign, Membership, Volunteer, or Event. |
Defining an Initiative AudienceThis section discusses how to create an audience for an initiative. Audiences are populations and sub-populations of constituents related to an initiative.
Understanding Audiences
You need an audience to communicate; the Audience page helps you identify the target market. There are three types of audiences:
Reporting audience
An example is the need to report quarterly to the Board of Regents.
Administrative audience
An example is the need to notify the group of people managing the initiative.
Segmentation
This piece is tied to communications.
Pages Used to Define an Initiative Audience
|
Page Name |
Object Name |
Navigation |
Usage |
|
AV_INTV_CMPGN_AUD AV_INTV_EVNT_AUD AV_INTV_MEMBR_AUD AV_INTV_VOL_AUD AV_INTV_OTHR_AUD |
|
Define the target audiences, or populations and sub-populations of constituents related to an initiative. |
|
|
AV_AUD_CRIT_SP |
Click the Audience Detail button on the Audience page. |
View additional information about an audience. |
|
|
AV_RUNCTL_INTV |
Contributor Relations, Initiatives, Process Initiatives, Initiative Audience Build |
Run the AVPINT process that builds the audiences that are used for initiatives. |
|
|
AV_RUNCTL_INTV_MRG |
Contributor Relations, Initiatives, Process Initiatives, Initiative Audience Merge |
Run the AVPIMRG COBOL process that moves audiences from the temporary table AV_INTV_TMP_TBL to the permanent table AV_INITIATIVES. |
Defining the AudienceAccess the Audience page.
Note. Before assigning an audience to an initiative, you must create the audience by defining attribute types, then define audience criteria based on those attribute types.
When you define an audience, you specify which particular group of constituents to reach through the initiative. For example, a reunion event might target all the constituents in the Class of 1990.
Use the audiences that you define to identify who receives particular messages as a result of the public relations plan and to set intermediate goals for the initiative. However, to actually build the audience for the initiative, you must use the Initiative Audience Build and Initiative Audience Merge pages.
Note. Audiences must be linked to an initiative to use Mass Change to assign communications to audience members.
|
Audience |
Make a selection from the prompt box containing a list of all the audiences for either persons or organizations defined by your institution. This list includes only those defined on the Audience Criteria page. |
|
Audience Type |
Select the reason that the audience you entered has been chosen. Values for this field (Segmentation, Reporting, and Administrative) are delivered with the system as translate values. Segmentation is a required value. Do not modify these values in any way. Any modifications to these values will require a substantial programming effort. Use Reporting to report the progress of the campaign. Use Administrative to create an audience of those responsible for the campaign. Use Segmentation for marketing purposes. Note. Segmentation is the only type available for setting campaign goals. Select Segmentation to include this audience for this initiative in the list of Audience Code values on the Initiative Goals page and PR Plan page. Reporting and Administration are not relevant to the Initiative Goals page. |
|
Query Name |
If desired for future reference, enter the current query name used in your reporting tool when running reports on the audience. |
|
Workset Name |
If you use a workset containing the members of the audience, enter the name. Enter only those worksets that you have access to. |
|
Audience Detail |
Click to open the Audience Detail page. This page displays the criteria that defines the audience. Review this information to ensure that you select the correct audience. |
See Also
Building the AudienceAccess the Initiative Audience Build page.
The Initiative Audience Build SQL process (AVPINT) generates the actual list of audience members and stores it in a temporary table called AV_INTV_TMP_TBL. After the records are in this table you can analyze them to determine if the audience is acceptable.
To build the audience initially, click Run to run the Initiative Audience Build process. This process builds the audiences that you select on this page and any defined audiences that have not previously been built.
Note. After you build an audience, audience members are not purged if they no longer meet the audience criteria.
If you have already built an audience, to rebuild it use the Rebuild Audience group box to enter your criteria. When you rebuild an audience the process adds any additional constituents that meet the audience criteria since the time the audience was last built.
After you run the Initiative Audience Build process you must manually purge the AV_INTV_TMP_TBL table.
|
Initiative |
Select the initiative to which the audience applies. |
|
Total Build Count |
Displays the number of audiences that are built when you run this process. If the total build count is 0, an error message appears. This number increases with each rebuild you specify. Note. The Total Build Count field must have a count of at least 1 before you can run the Initiative Audience Build process. |
Merging the AudienceWhen you click the Run button, Process Scheduler runs the Initiative Audience Merge Application Engine process (AVPIMRG COBOL) at user-defined intervals.
This process merges any audiences in the temporary table with the permanent table.
Linking Related InitiativesThis section discusses how to link additional, related initiatives to the one you are creating.
Page Used to Link Related Initiatives
|
Page Name |
Object Name |
Navigation |
Usage |
|
AV_INTV_CMPGN_RLTD AV_INTV_EVNT_RLTD AV_INTV_MEMBR_RLTD AV_INTV_VOL_RLTD AV_INTV_OTHR_RLTD |
|
Link the initiative you are creating or updating to existing active initiatives. |
Assigning Related InitiativesAccess the Related Initiative page.
You can link campaigns, volunteer efforts, membership initiatives, events, or other institution-defined initiative types as a sub-unit of an initiative.
|
Type |
Select the initiative type to relate to the initiative with which you are working, such as Campaign, Event, Membership, Other, and Volunteer. |
|
Level |
Select the reporting level of the initiative to relate to the initiative that you are working with. Select a level from 1 to 999. Level 1 is the highest reporting level; you cannot relate same-type initiatives with the same reporting level. |
|
Intv Cd (initiative code) |
Select the initiative code for the initiative to relate to the initiative with which you are working. Important! Event, volunteer, membership, and other initiatives can be related to a campaign only when the campaign is retrieved on this page. This ensures the correct hierarchy for campaign reporting. |
Assigning Initiative ResourcesThis section discusses how to assign initiative resources.
Page Used to Assign Initiative Resources
|
Page Name |
Object Name |
Navigation |
Usage |
|
AV_INTV_CMPGN_RSRC AV_INTV_EVNT_RSRC AV_INTV_MEMBR_RSRC AV_INTV_VOL_RSRC AV_INTV_OTHR_RSRC |
|
Maintain information about the human resources that support an initiative. |
Assigning Initiative ResourcesAccess the Resources page.
You assign the responsible person for an initiative on the initial definition page in the component, but you maintain information about other resources associated with the initiative on this page.
|
Responsible Manager |
This is the person, above the responsible person, who should get reports and notifications related to the initiative. Only valid defined staff and units are available for assignment. |
|
Staff Role |
Enter the role of the responsible manager at the institution. Examples of staff roles are Prospect Manager, Campaign Manager, Solicitor, and so on. Roles are defined by your institution using the Roles page. Only valid defined staff and units are available for assignment. |
|
Other Primary Staff Resources |
Enter any other staff members who are participating in the initiative, such as the class giving officer or the reunion manager. Only valid defined staff and units are available for assignment. Important! These resources only need to be linked here if the person’s assignment has not been established as the responsible person for a related initiative. |
|
Staff Role |
Enter the role of the staff member at the institution. Examples of staff roles are Prospect Manager, Campaign Manager, Solicitor, and so on. Roles are determined by your institution. |
|
Responsible Unit |
Enter the name of the unit that is responsible for the initiative. |
|
Unit Role |
Enter the purpose of the unit at the institution. Roles are determined by your institution. |
|
Resource Type |
Assign a volunteer as a resource. Values include Initiative or Mbr Org (member organization). |
|
Initiative Type |
If you selected Initiative as a resource type, select an initiative type associated with the volunteer. |
|
Initiative |
If you selected Initiative as a resource type, select the initiative with which the volunteer is associated. |
|
Mbr Org Code |
If you selected Mbr Org as a resource type, select the code with which the volunteer is associated. |
|
Volunteer Structure |
To assign a volunteer as a resource, select a volunteer structure code for the volunteer. This prompt is only active if you have a defined volunteer structure assigned to this initiative. If you do not have a volunteer structure defined, click the New Vol button to create one. |
|
New Vol (new volunteer) |
Click to access the Volunteer Structure page, where you can structure a new volunteer leadership group to assign specifically to this initiative. |
Defining a Public Relations PlanThis section discusses how to define a public relations plan for an initiative.
Page Used to Define a PR Plan
|
Page Name |
Object Name |
Navigation |
Usage |
|
AV_INTV_CMPGN_PLAN AV_INTV_EVNT_PLAN AV_INTV_MEMBR_PLAN AV_INTV_VOL_PLAN AV_INTV_OTHR_PLAN |
|
Define an overall plan for communicating the purpose and progress of an initiative to a variety of audiences. |
Defining a Public Relations PlanAccess the PR Plan page.
When you create a public relations plan, the system generates a to do list record for the people assigned to particular steps or tasks within the plan. In addition, the public relations plan is written to the overall action plan for the initiative.
|
Message |
Enter information about the content of the actual communication that is sent. |
|
Method |
Select how the message is delivered, such as an invitation, newsletter, meeting, report, email, and so on. Methods are defined by your institution using the Methods page. |
|
Frequency |
Select how often a communication is sent. Frequencies include Daily, Weekly, Monthly, Quarterly, Bi-Annually, or Annually. The values for this field are delivered with the system as translate values. You can modify these translate values. Important! The combination of frequency and start date establishes the dates that actions are triggered to a to do list for the people who are assigned the responsibility for carrying out the task |
|
Appeal |
Select an appeal to relate the public relations plan to a specific appeal defined for the initiative. For example, Annual Honor Roll may be the message and the enclosed envelope for an additional gift may have a defined appeal to track. Appeals are defined by your institution using the Appeals page. Available options include all the valid appeals for the setID associated with the business unit that you select for the initiative. |
|
Completed |
Select to indicate that a communication has already been generated and sent and that the planned cycle (start date to end date) is complete or the step is no longer needed in the plan. |
|
Audience Type and Audience |
Select an audience type and an audience for the communication. Audiences include only those defined on the Audience page for this initiative. |
|
Seq Nbr (sequence number) |
Indicates which step you are creating in the public relations plan. |
|
Build Actions |
After you have specified a message, method, frequency, appeal, assigned ID, and audience, click this button. The system generates initiative actions that correspond with the public relations tasks. For example, if you create a task of sending a monthly letter to alumni, the system creates an initiative action for the assigned staff for each date that the letter is to be sent. This date is based on the start and end dates of the public relations plan step. Important! You can only build actions for a step once, so plan the steps carefully. Be certain that the dates and frequency—as well as the values in the Message, Appeal, and Responsible Person fields—are correct before directing the system to build actions. You do not have to build actions until you are ready. You can save the page and build the public relations plan actions later. After actions are built, any subsequent changes to an action require you to manually update them using the Initiative Action page. |
Important! If you do not click the Build Actions button, you receive a message when you save the page asking to build actions for the initiative. If you click Yes, actions are created for all of the steps that have not yet been built. If you click No, the plan data is saved and no actions are created at this time. If you add steps to the public relations plan at a later date, the Build Actions button becomes active and you can build actions for the new steps. The actions that display on the To Do List are determined by the setting you make in the Reminder Days field on the Institution Installation 2 page.
Creating an Initiative Budget and Tracking ExpensesThis section discusses how to:
Create a budget.
Track budget expenses.
You can create a simple expense budget for an initiative. A budget can be broken down into budget categories, and a portion of the budget can be allocated to each category. In addition, you can track specific expenses associated with the initiative.
Note. Your Contributor Relations budget system does not support links to your institution's financial system.
Pages Used to Create a Budget and Track Expenses
|
Page Name |
Object Name |
Navigation |
Usage |
|
AV_INTV_CMPGN_BDGT AV_INTV_EVNT_BDGT AV_INTV_MEMBR_BDGT AV_INTV_VOL_BDGT AV_INTV_OTHR_BDGT |
|
Create a simple expense budget for an initiative. |
|
|
AV_INTV_CMPGN_BDTL AV_INTV_EVNT_BDTL AV_INTV_MEMBR_BDTL AV_INTV_VOL_BDTL AV_INTV_OTHR_BDTL |
|
Track the specific expenses for an initiative. |
Creating a BudgetAccess the Budget page.
You can break down a budget into budget categories and allocate a portion of the budget to each category.
|
Overall Budget |
Enter the total amount allocated as the expense budget for the initiative. |
|
Budget Category |
Enter the category to which you want to allocate a portion of the overall budget. Categories are defined by your institution using the Budget Table page. When you select a category, its description displays to the right of this field. |
|
Category Budget |
Enter the amount of the overall budget allocated to the category that you selected. |
An error message displays if the total amount budgeted to specific categories does not equal the overall budget. You cannot save a budget that exceeds the overall budget.
Warning! The system does not prevent overspending of your budget. The Budget feature within Contributor Relations does not link to the Financials system.
Tracking Budget ExpensesAccess the Budget Detail page.
|
Budget Category |
Select the category to which the expense or refund is assigned. Only those budget categories defined for the initiative type you are working with appear. |
|
Description |
Describe the expense, entering up to 25 characters. |
|
Appeal |
(Optional) If the expense relates to a specific appeal, select the appropriate one. Appeals are defined by your institution using the Appeals page. The appeals from which you can select are determined by the setID associated with the business unit that you select for the initiative. You must link each expense with an appeal to accurately track expenses for that appeal. |
|
Expense Amount |
Enter the amount of the expense. If you are entering a refund from a vendor, enter the item as a negative number. |
Warning! When you save this page, a warning message displays if the total of the expenses exceeds the overall budget. However, click the OK button on the warning dialog box to save the budget detail. The system does not prevent you from overspending your budget.
Creating Initiative ActionsThis section discusses how to:
Create actions associated with an initiative.
Add action information.
Pages Used to Create Initiative Actions
|
Page Name |
Object Name |
Navigation |
Usage |
|
AV_INTV_ACTN |
|
Create actions associated with an initiative. |
|
|
AV_INTV_ACTN2 |
|
Continue the process of adding actions associated with an initiative. |
Entering Initiative Action InformationAccess the Initiative Action page.
|
Action |
Describe the action, using up to 30 characters. |
|
Action Type |
Select a classification for the action. Actions are typically things such as Design Session, Hire Contractor, and so on. Action types are defined on the Action Types page. |
|
Expiration Date |
(Optional) Enter the date on which the action is no longer valid, regardless of whether or not it is completed. If the action is not completed by the expiration date, it no longer appears on the To Do List after the expiration date. |
|
Contact Type |
Determine whether the action is made through a telephone call, letter, email, personal visit, and so on. Contact types are defined by your institution. |
|
Description |
Describe the action, using up to 250 characters. Your description can include information about the purpose and goal of the action, and any other information needed to complete the action such as a contact phone number. |
|
Responsible Person |
Select the name and ID of the person overseeing the action. |
|
Initiative Responsible Person |
The person responsible for the initiative appears. |
Adding Action InformationAccess the Action Info page.
|
Initiative Type and Initiative |
Select these to add this action to the To Do List for another initiative. |
|
Type, Resource Assigned, and Role |
Select the resource type, resource ID, and role. Type values are delivered with the system as translate values. Do not modify these translate values in any way. Any modifications to these values will require a substantial programming effort. |
|
Result Code |
When the action status has been changed to Complete, select the appropriate result code. Action result codes are defined by your institution. |
Viewing Initiative Action Summary InformationThis section discusses how to:
View to do lists.
View initiative action summary information.
View action details.
View other initiatives and others assigned to an action.
Pages Used to View Action Summary Information
|
Page Name |
Object Name |
Navigation |
Usage |
|
AV_INTV_ACTN_SMRY |
Contributor Relations, Initiatives, Initiative Actions, Initiative Action Summary |
View information about the existing actions for an initiative at your institution. |
|
|
AV_INTV_ACTN_SP |
Click the Details link on the Action Summary page. |
View additional information about an initiative action. |
|
|
AV_INTV_ACTN2_SP |
Click the Resource Assignment button on the Action Detail page. |
View additional information about related initiatives and those assigned to the action. |
Viewing To Do Lists
Use the Staff, Volunteer, and Unit To Do List pages to view lists of all the initiative actions a resource is responsible for during a particular time frame or for a particular designee.
See Viewing To Do Lists.
Viewing Initiative Action Summary InformationClick the Details link to access detailed information about a particular initiative action on the Action Detail page.
Viewing Action DetailsClick the Edit Action button to access the Initiative Action page where you can make changes to the existing action. Click the Intv/Rsrc Asgn (initiative/resource assignments) button to view information about other initiatives linked to this action and about the resources at your institution that are assigned to the action.
Viewing Related GoalsThis section discusses how to view goals related to an initiative.
Page Used to View Related Goals
|
Page Name |
Object Name |
Navigation |
Usage |
|
AV_INTV_CMPGN_R_G AV_INTV_EVNT_R_G AV_INTV_MEMBR_R_G AV_INTV_VOL_R_G AV_INTV_OTHR_R_G |
|
View information about goals for initiatives related to the initiative you are working with. |
Viewing Related Goal Information
Access the Related Goals page. Some related initiatives may not have a financial goal. They still display on this page.
Viewing Responsible Staff for Related InitiativesThis section discusses how to view staff members assigned to related initiatives.
Page Used to View Responsible Staff for Related Initiatives
|
Page Name |
Object Name |
Navigation |
Usage |
|
AV_INTV_CMPGN_R_S AV_INTV_EVNT_R_S AV_INTV_MEMBR_R_S AV_INTV_VOL_R_S AV_INTV_OTHR_R_S |
|
View information about the staff members that are responsible for initiatives related to the current initiative. |
Using Mass Change for Initiative and Membership LettersThis section provides overviews of mass change and the initiative and membership mass change templates, and also discusses how to:
Select mass change criteria and defaults.
Run mass change processes.
Note. You must set up communications in the system prior to working with mass change.
Understanding Mass ChangeContributor Relations provides four mass change templates that enable you to generate communications for initiative audiences and membership organization members.
You can generate communications for audiences of a campaign appeal, membership campaign, volunteer program, event, and so on. When you create an initiative audience, you can run that audience through the mass change template and send a communication to those audience members who meet your selection criteria.
Or, you can select specific members of an organization based on their expiration date and send out renewal notices and membership cards. In addition, you can select recipients and mail benefits to those groups that have earned them.
Note. Templates for membership and initiative communications are shipped with the Contributor Relations system. You can modify templates for your institution.
Understanding the Initiative Mass Change TemplateThere are two mass change definitions in the initiative mass change process − CR-Intv-Delete and CR-Intv-Insert3CEngine.
The two mass change definitions are described below:
CR-Intv-Delete
The first portion of this definition deletes temporary initiative records from the ADM_TMP_MC, ADM_TMP2_MC, and EVNT_SPDKEY_MC tables if OPRID is equal to the person who selected the records and MC_DEFN_ID is equal to CR-Intv-Insert3CEngine. This criterion prevents the membership and initiative mass change functions from deleting records belonging to the other function.
CR-Intv-Insert3CEngine
This definition joins the AV_INITIATIVE table with the PERSONAL_DATA table based on EMPLID. This step is done to find the DT_OF_DEATH value for each record. If a person has a date of death, a communication record is not created when joint letter generator is run. In addition, the ADDRESSES table is checked and communication records are written only for those people who have an address with an effective status of Active. The records resulting from this join are inserted into the ADM_TMP_MC table.
Next, data from the EVNT_COMM_MC_VW is copied to the EVNT_SPDKEY_MC temporary table. This view breaks out the Comm Speed Key data for each Comm Key defined on the Event Definition Setup page. There may be one or more Comm Keys associated with the Event ID selected, thus creating one or more communication records for each Event ID. The following fields are then updated on the EVNT_SPDKEY_MC table:
|
Field Name |
Value taken from this field |
|
COMPLETED_COMM |
ACTIVITY_COMPLETED |
|
COMPLETED_DT |
COMM_DT |
|
COMPLETED_ID |
COMM_ID |
Note. Before this step can take place, you must define letter codes, communication context including a method and direction, and categories. These key values are combined to create communication Event IDs. You must also set up communication 3C groups and 3C group security.
Finally, the EVNT_SPDKEY_MC and ADM_TMP_MC tables are copied and joined in ADM_TMP2_MC.
You can select criteria based on the following fields to target your audience. At a minimum, you must select criteria for key fields. PeopleSoft recommends that you narrow the criteria by using all the fields. This ensures that you identify the correct records.
|
Table |
Field |
Key |
|
AV_INITIATIVE |
INSTITUTION |
|
|
AV_INITIATIVE |
AV_AUDIENCE |
Yes |
|
AV_INITIATIVE |
AUD_TYPE |
Yes |
|
AV_INITIATIVE |
INTV_CD |
Yes |
|
AV_INITIATIVE |
START_DT |
|
|
AV_INITIATIVE |
END_DT |
|
|
EVNT_3C_GRP_VW |
EVENT_3CS_ID |
|
After the CR-Intv-Insert3Cengine step has run, run the 3C Engine and choose your options for processing joint records. This generates all communication records for processing by the letter generator.
Understanding the Membership Mass Change TemplateThere are two mass change definitions in the membership mass change process − CR-Mbrshp-Delete and CR-Mbrshp-Insert3CEngine.
The two mass change definitions are described below:
CR-Mbrshp-Delete
The first portion of this definition deletes temporary membership records from the ADM_TMP_MC, ADM_TMP2_MC, and EVNT_SPDKEY_MC tables if OPRID is equal to the person who selected the records and MC_DEFN_ID is equal to CR-Mbrshp-Insert3CEngine. This criterion prevents the membership and initiative mass change functions from deleting records belonging to the other function.
CR-Mbrshp-Insert3CEngine
This definition joins the AV_MEMBER7_VW table with the PERSONAL_DATA table based on EMPL_ID. This step is done to find the DT_OF_DEATH value for each record. If a person has a date of death, a communication record is not created when joint letter generator is run. In addition, the ADDRESSES table is checked and communication records are written only for those people who have an address with an effective status of Active. The records resulting from this join are inserted into the ADM_TMP_MC table.
Next, data from the EVNT_COMM_MC_VW table is copied to the EVNT_SPDKEY_MC temporary table. This view breaks out the Comm Speed Key data for each Comm Key defined on the Event Definition Setup page. There may be one or more Comm Keys associated with the Event ID selected, thus creating one or more communication records for each Event ID. The following fields are then updated on the EVNT_SPDKEY_MC table:
|
Field Name |
Value taken from this field |
|
COMPLETED_COMM |
ACTIVITY_COMPLETED |
|
COMPLETED_DT |
COMM_DT |
|
COMPLETED_ID |
COMM_ID |
Note. Before this step can take place, you must define letter codes, communication context including a method and direction, and categories. These key values are combined to create communication Event IDs. You must also set up communication 3C groups and 3C group security.
Finally, the EVNT_SPDKEY_MC and ADM_TMP_MC tables are copied and joined in ADM_TMP2_MC.
You can select criteria based on the following fields to target your audience. At a minimum, you must select criteria for key fields. PeopleSoft recommends that you narrow the criteria by using all the fields. This ensures that you identify the correct records.
|
Table |
Field |
Key |
|
AV_MEMBERSHIP |
INSTITUTION |
Yes |
|
AV_MEMBERSHIP |
AV_MBR_ORG_COD |
Yes |
|
AV_MEMBERSHIP |
AV_DUES_LVL |
|
|
AV_MEMBERSHIP |
AV_MBRSHP_TYP |
|
|
AV_MEMBERSHIP |
START_DT |
|
|
AV_MEMBERSHIP |
EXPIRATION_DT |
|
|
AV_MEMBERSHIP |
MBR_TYPE |
|
|
AV_MEMBERSHIP |
MOTIVATION_CD |
|
|
AV_MEMBERSHIP |
SESSION_NO |
|
|
EVNT_3C_GRP_VW |
EVENT_3CS_ID |
|
After the CR-Mbrshp-Insert3CEngine step has run, run the 3C Engine and choose your options for processing joint records. This generates all communication records for processing by the letter generator.
Page Used to Use Mass Change for Initiative and Membership Letters
|
Page Name |
Object Name |
Navigation |
Usage |
|
MC_DEFN_01 |
Contributor Relations, Initiatives, Process Initiatives, Initiative Mass Change, Criteria and Defaults |
Specify the field criteria to use for selecting records from the database and identify which fields are populated and what values they contain by default. Also identify the Event ID required to generate the communication record. |
Selecting Criteria and DefaultsAccess the Criteria and Defaults page.
Note. If you are running mass change for an initiative, select the CR-Intv-Insert3CEngine mass change definition. If you are running mass change for a membership organization, select the CR-Mbrshp-Insert3CEngine mass change definition.
|
Criteria |
Set criteria values using SQL operators and values. For example, to select an audience type of Segmentation, you would choose Equal To and enter a field value of S. You must have a thorough understanding of your data and dependencies before selecting criteria. Many codes are not intuitive, and many fields are dependent upon others. For example, a dues level must be related to a specific member organization, but the prompts are not hierarchical. |
|
Field |
You can enter only one SQL operator per criteria. However, if you select a criteria option such as In, you can list multiple values by placing the cursor in the Field Value field and inserting rows. |
Note. Do not run the mass change process from within this component. Run the process using the Run Mass Change page.
Running the Mass Change SQR Process (MASSCHNG)Access the Run Mass Change page. To generate mass communications changes for Contributor Relations, only use these fields:
Mass Change Run Type
|
Execute Single Mass Change |
To run each mass change definition individually, select Execute Single Mass Change. If you select this option, you must run each of the four mass change definitions in the process separately. |
|
Execute Mass Change Group |
To run more than one mass change definition at one time, select Execute Mass Change Group as the mass change run type. If you select Execute Mass Change Group and you are running mass change for an initiative, run AV-Initiative-Step1 followed by AV-Initiative-Step2. If you select Execute Mass Change Group and you are running mass change for a membership organization, run AV-Membership-Step1 followed by AV-Membership-Step2. Note. You can verify the data by running an SQL statement against the temporary table or the communication table. |
|
Mass Change Definition |
Enter the name of the mass change definition to run. |
After the Mass Change process runs, data is written to the communications record.