| Info |
|---|
Capturing centralised knowledge Centralising the knowledge from various sources (Jira, Confluence, Business Analysis, Salesforce, Business Knowledge) on a field by field basis ensuring uniformity and data quality |
PLEASE COLLABORATE / PLEASE MAKE CHANGES - TEAM EFFORT !!
with the Business Rules - i.e. Address needs to follow Australia Post Standards, etc, etc, etc. Starts with Section for Systems Logic, Contact Utilities / Reports, then field by field starting with Account and intending to capture all major fields from there on, including all the Objects and business rules / knowledge per field. Village effort - Please collaborate and please add the knowledge that you have - feel free to make changes / add important knowledge. |
Salesforce Object | Field Name/s | Contains Custom Code / Workflow | Field Description | Business Rule | Data Quality Rule | Business Rule Committee Approval Date | Reports / Contacts | Lost  | Lost: a contact who does not have any active modes of contact (excludes LinkedIn URL) | Official USyd definition of “Lost Contact” : Strict - All fields in all the contact methods must be blank, (as opposed to incomplete addresses where some fields are blank and make the contact uncontactable). IF( |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Reports | Contactable Alumni ReportSystem Logic | Wellbeing Data | 
| .png?version=1&modificationDate=1677627310626&cacheVersion=1&api=v2) | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
System Logic | Duplicate Accounts / Contacts / Leads |
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Lightning Contact Utilities | Lightning Contact Utilities - Join | Duplicate Contacts |
| https://sydneyuni-adv.lightning.force.com/lightning/r/Report/00O8v000000KQ0aEAG/view https://sydneyuni-adv.lightning.force.com/lightning/r/Report/00O8v000000KQ0fEAG/view | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Lightning Contact Utilities | Lightning Contact Utilities - Separate | Separate |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Lightning Contact Utilities | Lightning Contact Utilities - Decease | Deceased |
| https://sydneyuni-adv.lightning.force.com/lightning/r/Report/00O8v000000K2juEAC/view https://sydneyuni-adv.lightning.force.com/lightning/r/Report/00O8v000000KIfiEAG00O8v000000KNPEEA4/view?queryScope=userFolders | Official report in the Executive folder | Total Alumni | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Lightning Contact Utilities | Account Create | Utility to create account and contact. | AQ Managed - Can only use for household records / Cant use for organizational records - Cant restrict | ?? | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Reports | Contactable Alumni Report | Official report in the Executive folder | Total Alumni minus:
| Contact | Alternate ID’s (Nonunique Alternative id) | Store Student, Staff, Seymore Centre, etc ID’s .png?version=1&modificationDate=1676512800766&cacheVersion=1&api=v2) Values are captured in field Nonunique Alternative id (Not Alternative Id’s) |
|
| Data Dictionary approve “Alternate ID’s” logic AlainGasquet , 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 |
| Account | Account Mailing Address | Account Mailing Address Formatting: Aust Post Mailing 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 | The Prospect Manager for this Account. | Lightning Contact Utilities | Join |
| Lightning Contact Utilities | Separate |
| Lightning Contact Utilities | Decease |
| Contact | Salutation | Title | Contact | Name | Name | Contact | Contact Types | Contact | Contact | Contact | Contact | Address | 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 |
Salesforce Object
Field Name/s
Field Description
Business Rule
Data Rules (Input and Output)
Rule Violations (Jarvis Report)
Fix Instruction
Approval
Knowledge Now Uploaded?
Contact
Contact
Email / Email Preference
Account | Account Name |
| |||||||||||||||||||||||||||||||||
Account | Account Mailing Address
| Rules:
| |||||||||||||||||||||||||||||||||
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) | N/A | |||||||||||||||||||||||||||||||
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.
| This is a standard Salesforce field. All Household Accounts are set as Type = Household All Non-Household Accounts are set as Type = Organisation | https://sydneyuni-adv.lightning.force.com/lightning/r/Report/00O8v000000K2RlEAK/view | |||||||||||||||||||||||||||||||
Account | Is Active Prospect? | Checkbox, Describes whether a prospect is active or Inactive. For example, inactive in case of deceased. | Checkbox, Describes whether a prospect is active or Inactive. For example, inactive in case of deceased. | ||||||||||||||||||||||||||||||||
Account Information | Prospect Manager | The Prospect Manager for this Account. | The Prospect Manager for this Account. | ||||||||||||||||||||||||||||||||
Account Information | Account Name Override | ||||||||||||||||||||||||||||||||||
Account Information | Primary Contact / Secondary Contact
| This account does not have a Primary or Secondary Contact assigned. |
| https://sydneyuni-adv.lightning.force.com/lightning/r/Report/00O8v000000K2ThEAK/view |
| ||||||||||||||||||||||||||||||
Account Information | Do Not Contact (AQB__DoNotContact__c) | None | Boolean Y/N |
| |||||||||||||||||||||||||||||||
Account Information | Do Not Solicit | ||||||||||||||||||||||||||||||||||
Account Information | Do Not Mail | ||||||||||||||||||||||||||||||||||
Account Information | Account Record Type |  | |||||||||||||||||||||||||||||||||
Account Mailing Address | Account Mailing Address | Rules:
| |||||||||||||||||||||||||||||||||
Account Mailing Address | Account Mailing Address Type |
| Drop Down List:  |
|
|
https://sydneyuni.atlassian.net/jira/software/projects/AVE/boards/1066?selectedIssue=AVE-351
Email is a standard Salesforce field.Email is a linked field, syncing to the value on the associated ‘Email Preference’ selection. eg Personal Email.
When an ‘Email Preference’ is selected, a link is formed with the value in the email fields, changes to the associated email field or into ‘Email’ directly will affect a change to the the corresponding linked field value.
In reports, field ‘Preferred Email 'suppresses the field value in reports when a contact is marked as either do not email or do not contact. Value will still be visible on screen, and can still be extracted in reports from Field 'Email’ or specific email type.
Validations are in place to prevent a preference being selected with a null value.
Email is locked to read only on USYD Contact Lightning Page Layout to reduce integrity errors. To understand how the Email field is populated, please watch this video:
Input:
Email address data should be added to the specific email fields. The contacts preferred email address for communications should then be selected in 'Email Preference'.
Same process should occur from both a single or mass entry.
Output:When exporting email details, best practise is to export ‘Preferred Email’ field value. While this field applies a validation on suppressing DNC and No Email flags, all Handling Preferences should be applied relevant to the communication type.
In addition a USYD formula field 'Best Contact Email'has been created to follow the below logic to identify email addresses where no preference is selected.
'Best Contact Email' formula: IF(NOT ISBLANK(Email) && FIND("uni.sydney.edu.au",Email)=0, Email, IF(NOT ISBLANK( AQB__PersonalEmail__c) && FIND("uni.sydney.edu.au",AQB__PersonalEmail__c)=0, AQB__PersonalEmail__c, IF(NOT ISBLANK(AQB__BusinessEmail__c) && FIND("uni.sydney.edu.au",AQB__BusinessEmail__c)=0, AQB__BusinessEmail__c , IF(NOT ISBLANK( AQB__OtherEmail__c) && FIND("uni.sydney.edu.au",AQB__OtherEmail__c)=0, AQB__OtherEmail__c, IF(NOT ISBLANK(AQB__SchoolEmail__c) && FIND("uni.sydney.edu.au",AQB__SchoolEmail__c)=0, AQB__SchoolEmail__c ,'') ) ) ) )
https://sydneyuni-adv.lightning.force.com/lightning/r/Report/00O8v000000K5TkEAK/view
https://sydneyuni-adv.lightning.force.com/lightning/r/Report/00O8v000000K5sfEAC/view
Single Instance:
Copy the value in ‘Email’ to the appropriate email field below, (i.e. “Personal Email”)
Select the email preference based on the field that it was copied to, (i.e. “Personal Email”)
Save
Mass Fix:
Export values from ‘Email' field. Note, Preferred email will suppress any DNC and Do Not email values
Import email address to correct email field eg, Personal Email
Set ‘Preferred Email’ based on step 2
- AlainGasquet
- Jessica
- Rommel
- Miranda
- Yeng/Manpreet
- Liz (Single CRM)
- Adriana (PO)
- Api
- SME/Business Owner
Contact
Phone / Phone Preference
AVE-417
Phone is a linked field, syncing to the value on the associated ‘Phone Preference’ selection. eg Mobile.
- rommel.ngo as discussed, can you please investigate ? (FI jessica.wood , AlainGasquet , Miranda Adams , Yeng Sembrano )
Contact
Contact Type
TAP-211
Primary & Secondary Contact Type - How to define donor- as soon give legal credit amount < 0.01 - problem is people with soft credit - gift attached to another account - what do we do with people who only has a soft credit ?? soft credit = donor ?? GRC ?? Gift Recognition Credit always 100% ?? (Only Household account)
Contact/Account
Mailing Address Preference
A read only field used to indicate what type of address the contact current mailing address is associated. The valid values are “Account Mailing”, “Business”, or “Alternate”,
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
Contact/Account
Mailing Address Type
A Description of the nature of the address information, such as residence, business, etc. [Drop down list with selection: Home, Business, Vacation, Other Sydney Student Mailing Address, etc.
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
Permanent address = Home Address;
Business address = Business Address;
SITS Address = Sydney Student Contact Address
Internal USYD Address
PO Boxes = Postal Address
https://sydneyuni-adv.lightning.force.com/lightning/r/Report/00O8v000000K2kOEAS/view
Contact
Mailing Address Status
AVE-177
Mailing Address Status indicates whether the Mailing Address is Active, Inactive, RTS etc.
For manual data entry, if a standard TAP user updates the address, the Mailing Address Status is automatically set to ‘Active’
For mass data activity such as re-formatting and data cleansing, it is imperative that users extract the Mailing Address Status along with the address details and re-upload the reformatted data with the pre-existing status. This will prevent Inactive, Last Known, RTS data being incorrectly marked as Active.
Contact
Deceased
| View file | ||
|---|---|---|
|
| View file | ||
|---|---|---|
|
https://sydneyuni-adv.lightning.force.com/lightning/r/Report/00O8v000000K2juEAC/view
| View file | ||
|---|---|---|
|
Contact/Account
Account/Contact
Account Phone
Phone can be found on both the Household and the Non-Household Account.
Contact
Business Phone
Business Phone is a linked field pulling from the contacts employment record.
Account/Contact
Address
Contact Mailing City (State), Contact Mailing State/Province (Suburb) and Contact Mailing Country (Country) fields have a validation applied to capitalise all input values.Australian addresses should be formatting in line with Australia Post Guidelines.
Contact Mailing City (State), Contact Mailing State/Province (Suburb) and Contact Mailing Country (Country) should all be capitalised.
Contact Mailing Country should not be printed on local mail.
Validate Address Data through Experian to gain correct Australia Post Formatting and missing values.
Account/Contact
Address Updates
Contact
Address Preference
Account Mailing is linking to the Account Address
Business Mailing
Alternate Mailing
Account/Contact
Address DPID
This field contains the eight digit Delivery Point Identifier (DPID) associated with a unique address in Australia. The Delivery Point Identifier (DPID) is a randomly generated, unique 8-digit number, which is allocated for every new address added to the Australia Post source address database. All DPIDs for complete addresses fall within the range of 30000000 to 99999999.
A workflow is in place that if the Address is updated to a new value, the DPID will be stripped from the field to ensure it remains consistent with the address. DPID will not be added uniquely by a user, without an on screen validation tool within salesforce, this field will be updated on mass through the validation of address data through applications like Experian.
Address data will be validated and DPID supplied to associated address by validation tools. DPID numerical value will be imported into the ‘Address DPID’ field.
Address DPID should be exported along with address fields on all print mail lists eg Direct Mail Appeals, SAM Print
Account
Account
Account Type
All household Accounts are set as Type = Household
All non household Accounts are set as Type = OrganisationHousehold Accounts are for individual residences, grouping people together at one address.
Organisation Accounts are for any type of entity record that is not a residential home eg Businesses, Private or Family Foundations, Member Groups or Associations, Estate’s
Account
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
Household Accounts should have at least 1 contact that is directly linked to it (no empty household), and should be set to Primary Contact. Second directly linked contact should be linked as Secondary Contact.
Household Accounts should NOT have any contact that is indirectly linked to it (Affiliation relationship is only for non Household)Household Account should have the primary and secondary contact directly linked to it.
| Code Block |
|---|
select id, AQB__AccountStatus__c, Name, AQB__PrimaryContact__r.name, AQB__SecondaryContact__r.name
from account where id not in (select AccountId from contact)
and RecordType.name = 'Household'
and AQB__AccountStatus__c <> 'INACTIVE' |
| Code Block |
|---|
select id, AQB__AccountStatus__c, Name, AQB__PrimaryContact__r.name, AQB__SecondaryContact__r.name
from account where id in (select AQB__Account__c from AQB__Affiliation__c)
and RecordType.name = 'Household' |
andStatus colour Red title 138 RECORDS EXIST
respectively (for secondary, maybe we leave it for now and understand why)Status colour Yellow title 511,825 RECORDS EXIST
| Code Block |
|---|
select id, AQB__AccountStatus__c, Name, AQB__PrimaryContact__r.name, AQB__SecondaryContact__r.name
from account where AQB__PrimaryContact__c not in (select id from contact)
and RecordType.name = 'Household'
and AQB__AccountStatus__c <> 'INACTIVE' |
| Code Block |
|---|
select id, AQB__AccountStatus__c, Name, AQB__PrimaryContact__r.name, AQB__SecondaryContact__r.name
from account where AQB__SecondaryContact__c not in (select id from contact)
and RecordType.name = 'Household'
and AQB__AccountStatus__c <> 'INACTIVE' |
Status colour Red title 138 RECORDS EXIST
| Code Block |
|---|
select id, AQB__AccountStatus__c, Name, AQB__PrimaryContact__r.name, AQB__SecondaryContact__r.name
from account where AQB__PrimaryContact__C = null
and RecordType.name = 'Household'
and AQB__AccountStatus__c <> 'INACTIVE' |
Account
Account Names
Age >= 110
Mark as Deceased
Contact with Grad Year but not Alumni
go to manpreet to investigate
Schools / Faculty Mapping
N/A
| View file | ||
|---|---|---|
|
Contact Mailing Address w/o City
Experian data
Contact Types
Rules: Home Address = Default for Household Contacts (Merge “Home” + “Home Address - Unverified” + “Residential Address” to here) Business Address = Default for Business Contacts (Merge “Business” to here) Postal Address = Where the address is a PO Box Internal USYD Address = Staff, etc that uses USyd Addresses SITS Contact Address = the address is coming from SITS with a type of "Contact Address". Basically this is the address preferred by Student to communicate to them. Other Student Address = Student Accommodation Other - Seasonal + Vacation |
|
| ||||||||||||||||||||||||||||||||||
Account Mailing Address | Account Mailing Address Status | TEXT( Account.AQB__BillingStatus__c ) | Picklist:
| For manual data entry, if a standard TAP user updates the address, the Mailing Address Status is automatically set to ‘Active’ For mass data activity such as re-formatting and data cleansing, it is imperative that users extract the Mailing Address Status along with the address details and re-upload the reformatted data with the pre-existing status. This will prevent Inactive, Last Known, RTS data being incorrectly marked as Active. Picklist:
| https://sydneyuni-adv.lightning.force.com/lightning/r/Report/00O8v000000K2kJEAS/view |
| ||||||||||||||||||||||||||||||
Account Mailing Address | RTS Reason | |||||||||||||||||||||||||||||||||||
Account Mailing Address | Phone | Account Phone is designed to represent the Phone number of the Physical Location eg The Household/Home Phone number, Non-Household Account the Business number. This number will be displayed on direct contacts. Phone can be found on both the Household and the Non-Household Account. | Account Phone = Home Phone Mobile Phone = Mobile Phone |
| ||||||||||||||||||||||||||||||||
Account Permanent Address | ||||||||||||||||||||||||||||||||||||
Contact | Name | |||||||||||||||||||||||||||||||||||
Contact | Contact Type / Secondary Contact Type | Categorisation of the contact & contact pairs: Alumni = Graduated with a Sydney University Award (Diploma/Undergraduate/Post Graduate) and they have an Award Date + Award Conferred (Conferred Date). Alumni Affiliate = Graduated from one of the various institutions that Sydney Uni acquired over the years. Graduand = Fulfilled all course requirements, and assessed as eligible, have an Award date, but Award yet to be conferred (No conferred date). Donor = TAP-211 Definition of Donor Staff / Former Staff = Staff / Former Staff Organisation Contact = Organisation Contact Friend = Associated with Sydney University through volunteering, etc. Student = Enrolled as Student with Sydney University |
Rules:
|
| ||||||||||||||||||||||||||||||||
Contact | Salutation | Salutation | ||||||||||||||||||||||||||||||||||
Contact | Do Not Contact (AQB__DoNotContact__c) | None | Boolean Y/N |
| ||||||||||||||||||||||||||||||||
Contact | Do Not Solicit | Boolean Y/N | ||||||||||||||||||||||||||||||||||
Contact | Deceased | Lightning Contact Utilities | Lightning Contact Utilities | Can only be done by the GA Team
| ||||||||||||||||||||||||||||||||
Contact | Is Influential Alumni | |||||||||||||||||||||||||||||||||||
Contact | Lost  | System Calculated Y/N Field: IF( | Lost: a contact who does not have any active modes of contact (excludes LinkedIn URL) | Official USyd definition of “Lost Contact” : Strict - All fields in all the contact methods must be blank, (as opposed to incomplete addresses where some fields are blank and make the contact uncontactable). | ||||||||||||||||||||||||||||||||
Contact: Primary Diploma/Degree | ||||||||||||||||||||||||||||||||||||
Contact: Address Preference | Contact Mailing Address | Rules:
| ||||||||||||||||||||||||||||||||||
Contact: Address Preference | Address Preference  |
| A read only field used to indicate what type of address the contact current mailing address is associated. Pick List:
| Rules:
|
|
| ||||||||||||||||||||||||||||||
Contact: Address Preference | Mailing Address Status | Picklist:
| For manual data entry, if a standard TAP user updates the address, the Mailing Address Status is automatically set to ‘Active’ For mass data activity such as re-formatting and data cleansing, it is imperative that users extract the Mailing Address Status along with the address details and re-upload the reformatted data with the pre-existing status. This will prevent Inactive, Last Known, RTS data being incorrectly marked as Active. Picklist:
| https://sydneyuni-adv.lightning.force.com/lightning/r/Report/00O8v000000K2kJEAS/view | ||||||||||||||||||||||||||||||||
Contact: Address Preference | Mailing Address Type | Drop Down List:  |
Rules: Home Address = Default for Household Contacts (Merge “Home” + “Home Address - Unverified” + “Residential Address” to here) Business Address = Default for Business Contacts (Merge “Business” to here) Postal Address = Where the address is a PO Box Internal USYD Address = Staff, etc that uses USyd Addresses SITS Contact Address = the address is coming from SITS with a type of "Contact Address". Basically this is the address preferred by Student to communicate to them. Other Student Address = Student Accommodation Other - Seasonal + Vacation |
|
| |||||||||||||||||||||||||||||||
Contact: Address Preference | RTS Reason | |||||||||||||||||||||||||||||||||||
Account/Contact | Address DPID | ‘Address DPID’ is a USYD Custom field. It holds an eight digit numerical value. This field contains the eight digit Delivery Point Identifier (DPID) associated with a unique address in Australia. The Delivery Point Identifier (DPID) is a randomly generated, unique 8-digit number, which is allocated for every new address added to the Australia Post source address database. All DPIDs for complete addresses fall within the range of 30000000 to 99999999. A workflow is in place that if the Address is updated to a new value, the DPID will be stripped from the field to ensure it remains consistent with the address. | DPID will not be added uniquely by a user, without an on screen validation tool within salesforce, this field will be updated on mass through the validation of address data through applications like Experian. Address data will be validated and DPID supplied to associated address by validation tools. DPID numerical value will be imported into the ‘Address DPID’ field. Address DPID should be exported along with address fields on all print mail lists eg Direct Mail Appeals, SAM Print | |||||||||||||||||||||||||||||||||
Contact: Phone and Email Preference | Phone Preference | Managed field that populates Phone field | AVE-106 Phone Number and Email integrity Drop Down box with the values of the 4x Telephone types below.  Phone is a linked field, syncing to the value on the associated ‘Phone Preference’ selection. eg Mobile. If Do Not Call box are ticked, it will not display a Preferred Telephone Number. | Business Rule:
|
| |||||||||||||||||||||||||||||||
Contact: Phone and Email Preference | Phone | AVE-106 Phone Number and Email integrity Phone is calculated field, pulling the values from the corresponding fields below. If Do Not Call box are ticked, it will not display a telephone number.
| Phone is a standard Salesforce field. Phone is a linked field, syncing to the value on the associated ‘Phone Preference’ selection. eg Mobile. If Do Not Call box are ticked, it will not display a Preferred Telephone Number. |
| ||||||||||||||||||||||||||||||||
Contact: Phone and Email Preference | Account Phone | No | AVE-106 Phone Number and Email integrity Phone at Account Mailing Address | Business Rules Meetings Minutes :
| ||||||||||||||||||||||||||||||||
Contact: Phone and Email Preference | Business Phone | No | AVE-106 Phone Number and Email integrity Phone at Contacts Primary Business Location |
| ||||||||||||||||||||||||||||||||
Contact: Phone and Email Preference | Mobile Phone | No | Business Rules Meetings Minutes :
Within Australia, mobile phone numbers begin with 04 or 05 – the Australian national trunk code 0, plus the mobile indicator 4 or 5 – followed by eight digits. This is generally written as 04XX XXX XXX within Australia, or as +61 4XX XXX XXX for an international audience |
|
| |||||||||||||||||||||||||||||||
Contact: Phone and Email Preference | Fax | No | ||||||||||||||||||||||||||||||||||
Contact: Phone and Email Preference | Email Preference | Managed field that populates Email field | AVE-106 Phone Number and Email integrity Managed Picklist: values of the 4x email types below.  In reports, field ‘Preferred Email 'suppresses the field value in reports when a contact is marked as either do not email or do not contact. Value will still be visible on screen, and can still be extracted in reports from Field 'Email’ or specific email type. | Business Rule:
|
See Contact Types: AVE-16 Contact Types
Rules:
No empty primary contact type
Primary contacts can only be as per the list in AVE-16
“Parent of Student - Alumni” cannot be primary, only secondary
Secondary contact type is as per the table values in Jira ticket (AVE-16 Contact Types )
Never have friend as secondary contact
If contact type is empty, then should default to Friend.
Contact Pairs
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
- jessica.wood please attach once agreed
- rommel.ngo to convert the contact pair spreadsheet into confluence page
Industry Types
- beha.parsa please attach
Address - Town
Needs to be capitals
| View file | ||
|---|---|---|
|
Address - State
Abbreviated
Address - Postcode
Address - Country
Mailing Address
Address - Singapore
Generally, there are only two address formats in Singapore: one for buildings and another for landed properties:
Buildings:
| Code Block |
|---|
[Block Number] [Street Name]
#[Unit Level]-[Unit Number] [Building Name]
Singapore [Postal Code] |
101 Marlow Street
#12-05 Clife Parkview
Singapore 059020
Landed Properties
| Code Block |
|---|
[Unit Number] [Street Name]
Singapore [Postal Code] |
60 Aria Street
Singapore 602580
Generally, there are only two address formats in Singapore: one for buildings and another for landed properties:
Buildings:
| Code Block |
|---|
[Block Number] [Street Name]
#[Unit Level]-[Unit Number] [Building Name]
Singapore [Postal Code] |
101 Marlow Street
#12-05 Clife Parkview
Singapore 059020
Landed Properties
| Code Block |
|---|
[Unit Number] [Street Name]
Singapore [Postal Code] |
60 Aria Street
Singapore 602580
Student Accomodations/Emails (@uni.sydney)
At the point, contact type is moved from Graduand to Alumni, all Student Accomodation addresses/Emails (@uni.sydney) should be deactivated and deleted from the main page.
Account Name
Account Types
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
Account Name
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
Award
Award
- beha.parsa ,
- Binila Russel - please capture the final outcome here !!
Account, Contact, Alternate Channels
Account
Contact
Alternate Channels
| https://sydneyuni-adv.lightning.force.com/lightning/r/Report/00O8v000000K5TkEAK/view |
| ||||||||||
Contact: Phone and Email Preference | AVE-106 Phone Number and Email integrity Email is calculated field, pulling the values from the corresponding fields below. If Email Opt Out box are ticked, it will not display an email address. | Email is a standard Salesforce field. Email is a linked field, syncing to the value on the associated ‘Email Preference’ selection. eg Personal Email. When an ‘Email Preference’ is selected, a link is formed with the value in the email fields, changes to the associated email field or into ‘Email’ directly will affect a change to the the corresponding linked field value. In reports, field ‘Preferred Email 'suppresses the field value in reports when a contact is marked as either do not email or do not contact. Value will still be visible on screen, and can still be extracted in reports from Field 'Email’ or specific email type. Validations are in place to prevent a preference being selected with a null value. Rules:
|
|
| ||||||||
Contact: Phone and Email Preference | Business Email | Managed Field - Email at contact's primary place of employment - AQB__BusinessEmail__c | AVE-106 Phone Number and Email integrity Email at contact's primary place of employment | |||||||||
Contact: Phone and Email Preference | Preferred Email | Captures Email if either or both Do Not Email and Do Not Contact are unchecked: IF(OR(HasOptedOutOfEmail = TRUE,AQB__DoNotContact__c= TRUE) ,"",USYD_Best_Contact_Email__c) | ||||||||||
Alternate ID’s | Alternate ID’s (Nonunique Alternative id) | Store Student, Staff, Seymore Centre, etc ID’s Values are captured in field Nonunique Alternative id (Not Alternative Id’s) |
|
| ||||||||
Award Recipients | Award | |||||||||||
Education | Schools / Faculty Mapping |
| ||||||||||
Employment | Industry | |||||||||||
Gift Recognition Credits | ||||||||||||
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 | |||||||||
| Anchor | ||||
|---|---|---|---|---|
|
Address Formatting Business Rules