Background
There are 60 fields in the existing Opportunity page layout. Many of these fields are not used by the business and even more are not populated until the Solicitation stage.
Scope:
Enahnced page layout for Gift/Pledge Opportunity
Enhanced Guidance for Success and Key Fields for each Gift/Pledge Opportunity Stage
Out of Scope:
No changes will be made to the Gifts in Will Opportunity page layout
Business Requirement
Please check this miro page for detailed changes
AS IS | TO BE |
|---|---|
 |
Re-layout the fields accordingly
The following fields are no longer in the layout :
Table 1.1
Field | Field Created By | Purpose | Comments | Reason |
|---|---|---|---|---|
Anonymous | Affinaquest | If checked, this Opportunity should be considered anonymous | 16 Opportunities have this flag ticked (18) | This data can be acquired in the anonymity level field. |
Do Not Contact | Affinaquest | If checked, this field indicates that the donor should not be contacted at the present time, regarding this Opportunity | 50 Opportunities have this flag ticked | If the donor does not wish to be contacted regarding the opportunity, the opportunity should be closed lost. |
Private | Salesforce | A private Opportunity will only be visible to the owner and those with View/Modify all access on Opportunities | 0 Opportunities have this flag ticked | Field not used |
OMI | Affinaquest | The Opportunity Management Index (OMI) is a visual indicator of progress of the Opportunity toward funding, based on the number of stars. It is based on the Date, the Probability, the amount of time in the current Stage, and the last and next Activity | Does not populate as Advancement doesn’t use Activity | Remove as not used. |
Next Task | Affinaquest | The flag indicates status of the next Task for the Opportunity. Green - Task due date is at least 14 days away. Yellow - Task due date is within 14 days. Red - Task is overdue or no Activity is scheduled | Doesn’t populated as Advancement doesn’t use Activity | Tasks are currently set as private to mitigate risks associated with well-being data. As a result of the tasks being private DO’s cannot track tasks once they have been assigned. The task related fields should be removed from the opportunity page-layout, and we can consider adding them back in when we implement SF Activity. |
Next Task Date | Affinaquest | The date of the next Task that is scheduled for this Opportunity | 251 Opportunities have Next Task Date populated | Same as above. |
Credited Date | Advancement | There is no documentation in Salesforce or Jira to indicate the purpose of this field | 12 Opportunities have the Credited Date populated | GI advised that this was a GA field and GA have stated that they do not operate in the opportunity. As only 12 opportunities have this field populated, the field will be removed. |
Highlights Section will not be used anymore
Key fields per stage
Table 1.2
Stage | Identification | Qualification | Planning | Solicitation | Lost | Gift handover | Won |
|---|---|---|---|---|---|---|---|
KF1 | Amount | Amount | Acceptance from delegate | Verbal acceptance
| Closed date | Verbal acceptance | Amount |
KF2 | Lead source | Strategy | Ask made? | Gift date | Closed lost reason | Donor expectations apply | Funding complete |
KF2 | Primary campaign source | Next step | Ask amount | Gift Amount |
| Chart of accounts |
|
KF4 | Strategy |
| Strategy | Gift theme |
| Type |
|
Analysis on Persona
Why are we doing this?
We need to have a complete list of all Persona who will be using or exposed to Opportunity for this change as well as full analysis on page layout for changes to be applied (or not)
Impact? (e.g. number of users or records affected)
Development Officer:
Prospect Development:
Donor Relations:
Proposals:
Development Officers and Prospect Development team should be the only ones creating Opportunities.
Profile/Page layout matrix that needs changes (please do not make any changes on page layout if not specified below)
Persona | User Name (example) | Profile | Permissionset/group | Recordtype | Pagelayout |
Development Officer: | Shayan Quinlan | USyd Standard User |
| ||
Prospect Development: | Natalia Uribe | USyd Standard User - Prospect Development | USYD Gift Update - Selected Fields,USYD Opportunity Admin, Prospect Development | ||
Donor Relations | Keri Bell | USyd Standard User | Donor Relations | ||
Proposals | Jemima Rohekar | USyd Standard User | Development | ||
Data Admin - BI-DRS |
| USyd Data Admin - BI-DRS |
|
TBD - System Administrator, USYD Superuser page layout allocation.
A lot of people across the Portfolio would view Opportunities to ensure they're across all the activities etc. associated with a Contact. This is usually just to be aware IF there is an Opportunity against a Contact/Account, rather than looking at the specificities of that Opportunity. Donor Relations and Proposals teams might be interested in the Activity Reports attached to that Opportunity to gather information to assist in preparing proposal documents and stewardship reports. Most of the fields on the Opportunity page are only of interest to Development Officers (and to a limited extent Prospect Development).
Analysis on inactive Opportunity Page Layout
Why are we doing this?
We want to analyze currently available opportunity page layouts and identify any inactive page layout, assess the purpose of them, discuss with PO for further action.
There are 17 record types and 18 page layouts for Opportunity object.
Record Type:
Record Type Label | Description |
Bargain Sale | Property interest sold to an organization for less than the market price. |
Bequest | Giving by will. |
Charitable Lead Annuity Trust | Charitable lead trusts make payments of a fixed amount to charity during its term. |
Charitable Lead Unitrust | Charitable lead trusts make payments of a percentage of trust principal to charity during its term. |
Charitable Remainder Annuity Trust | The trust then pays a fixed amount of income each year to the donor or the donor's specified beneficiary. When the donor dies, the remainder of the trust is transferred to the charity. |
Charitable Remainder Unitrust | The trust distributes a fixed percentage of the value of its assets to a non-charitable beneficiary; at the expiration of a specified time, the remaining balance is distributed to charity. |
Gift Annuity | The donor transfers cash or property to the charity in exchange for a partial tax deduction and a lifetime stream of annual income from the charity. When the donor dies, the charity keeps the gift. |
Gift/Pledge | Direct gift of cash or assets. |
Gifts in Will | Giving by Wills |
Goal | Utilized for reporting goals for opportunities. |
Major Gift Opportunity |
|
Net Income Unitrust |
|
Pooled Income Fund | A type of charitable mutual fund which is then invested to provide dividends for both the donor and charity. Upon the death of the donor, the remaining balance is retained by the charity. |
Real Property |
|
Retained Life Estate | A gift of real estate in which the donor retains the right to occupy the real estate until death. |
Trust |
|
Unsolicited | Unsolicited Opportunity |
Page Layout
Page Layout Name |
AQ Bargain Sale 3.17 |
AQ Bequest 3.17 |
AQ Charitable Lead Annuity Trust 3.17 |
AQ Charitable Lead Unitrust 3.17 |
AQ Charitable Remainder Annuity Trust 3.17 |
AQ Charitable Remainder Unitrust 3.17 |
AQ Gift Annuity 3.17 |
AQ Lightning Outright Gift |
AQ Opportunity Layout 3.17 |
AQ Outright Gift 3.17 |
AQ Pooled Income Fund 3.17 |
AQ Retained Life Interest 3.17 |
Billing Opportunity Layout |
Opportunity Layout |
Usyd - AQ Bequest 3.17 |
Usyd - AQ Bequest 3.17 Admin |
USyd - AQ Lightning Outright Gift |
USyd - AQ Lightning Outright Gift Admin |
Total opportunity in Jarvis and their records type name
Count | RecordTypeId | Record Type Name |
|---|---|---|
5207 | Giving by Wills | |
7127 | Gift/Pledge |
Currently the only records type used for opportunities are the above 2, all other record types and page layouts are not in use.
For this enhancement, we are making change to only 2 page layouts under 1 Record Type ‘Gift/Pledge’