Content Comparison

Contact

Lost

Image Added

A contact who do not have any active means of contact.

https://sydneyuni-adv.lightning.force.com/lightning/setup/ObjectManager/Contact/FieldsAndRelationships/00N4a000000W1yD/view

Official USyd definition of “Lost Contact” : Strict - All fields in all the contact methods are blank, (as opposed to incomplete addresses etcwhere some fields are blank and make the contact uncontactable).

IF(
AND(
ISBLANK( Phone ),
ISBLANK( MobilePhone ),
ISBLANK( HomePhone ),
ISBLANK( AQB__BusinessPhone__c ),
ISBLANK( AQB__MobileWork__c ),
ISBLANK( AssistantPhone ),
ISBLANK( Fax ),
ISBLANK( OtherPhone ),
ISBLANK( Email ),
ISBLANK( AQB__PersonalEmail__c ),
ISBLANK( AQB__BusinessEmail__c ),
ISBLANK( AQB__SchoolEmail__c ),
ISBLANK( USYD_Best_Contact_Email__c ),
ISBLANK( AQB__OtherEmail__c ),
ISBLANK( AQB__BusinessAddress__c ),
ISBLANK( USYD_Contact_Mailing_Street__c ),
ISBLANK( USYD_Contact_Mailing_City__c ),
ISBLANK( USYD_Contact_Mailing_State__c ),
ISBLANK( USYD_Contact_Mailing_Zip_Postal_Code__c ),
ISBLANK( USYD_Contact_Mailing_Country__c ),
ISBLANK( OtherStreet ),
ISBLANK( OtherCity ),
ISBLANK( OtherState ),
ISBLANK( OtherPostalCode ),
ISBLANK( OtherCountry )
),
TRUE,
FALSE
)

•  “Lost” field in Jarvis AlainGasquet , 10 Feb 2023
•  “Lost” field in Jarvis Miranda Adams , 10 Feb 2023
•  “Lost” field in Jarvis jessica.wood , 10 Feb 2023
•  “Lost” field in Jarvis apirami.kumaradevan , 10 Feb 2023

Contact

Account Create

New Account Entry

Utility to create account and contact.

AQ Managed - Can only use for household records / Cant use for organizational records - Cant restrict

Account

Account Name

Account Name

•  AVE-105 Household Account Name , Need to decide future structure, 28 Feb 2023

Account

Account Mailing Address

AVE-107 Address Management

AVE-107 Address Management,

Account Mailing Address Formatting:

Aust Post Mailing format:

• Country -> Capitalized - Need it - to excluded via formula in mailing

• State → Capitalized - Abbreviated,

• Aperture DS Format

Account

RFM

A star is awarded for each of the following five conditions: having a giving record, having a pending opportunity, having a largest gift over a defined amount, having a total amount of giving over a defined amount, and having made a payment this year.

Not used (See if can be removed from layout)

Account

Most Recent Gift/Pledge Date

The date of the most recent gift.

Pulling any gift / pledge - does it do soft credits? Hard vs Soft Credits - includes soft credits

Account

Account Type

A picklist of the highest level categorization of this Account. The category can be further described in the Secondary Type field.

Account

Account Phone

Account Phone = Home Phone

Mobile Phone = Individual Phone

Account

Is Active Prospect?

Checkbox, Describes whether a prospect is active or Inactive. For example, inactive in case of deceased.

Account

Prospect Manager

The Prospect Manager for this Account.

Lightning Contact Utilities

Join

Lightning Contact Utilities

Separate

Lightning Contact Utilities

Decease

Contact

Salutation

Title

Affinaquest Salutations Derivation

Contact

Name

Name

Contact

Contact Types

AVE-16 Contact Types

Contact

Contact

Contact

Contact

Transaction

Acknowledgement

Transaction

COA DFN

look up from COA

Transaction

COA code

look up from COA

Transaction

COA designation

look up from COA

Transaction

COA School/Unit

Used for receipting purpose

look up from COA

Transaction

Designation

The entry in the Chart of Accounts to which the donor wishes this Transaction to be deposited

look up from COA