1. Business Rules Meetings Minutes

BR-001

Deceased Contacts

Deceased Contacts: It was agreed on Nov 9, 2022 to:

1. reduce report age to 105;

2. mark the Contact as Do Not Contact until Deceased Contact can be actioned;

3. find the deceased date from https://ryersonindex.org/ ;

4. If cannot find in Ryerson Index, then assume deceased - check https://gerontology.fandom.com/wiki/List_of_oldest_living_people_in_Australia to make sure not alive - make the deceased date the action date.

5. Use Deceased Utility to decease. (Monthly Process)

6. If deceased, then needs to be removed from any Primary Contact roles.

Nov 9, 2022

@Monica Kluegel

open

BR-002

Accounts with No Primary Contact

Household accounts MUST always have at least a primary contact. Corporations need to have a direct contact to receipt gifts. Not needed otherwise. Contact can only have 1x direct linkage to account.

Nov 9, 2022

CLOSED

BR-003

Households without a Primary/Sec contact

Household accounts must always have a Primary Contact. If more than one person on the account, then the one is Primary and the other is secondary. Kids on the account need to have their own account when they turn 18. (Less than 18 cannot have own account).

If only 1x contact and deceased, the account name gets moved to the estate. (Estate of the late …) → Harpreet does that.

Nov 9, 2022

CLOSED

BR-004

Account Naming Conventions

Dec 7, 2022

CLOSED

BR-005

Address Preferences

Open

1. Auto Default * Household = ‘Account Mailing’ * Corporations = Business

Nov 9, 2022

CLOSED

BR-006

Country Picklist

Full due diligence and impact analysis - difference between SITS and Jarvis (Google Based)

Nov 9, 2022

open

BR-007

TAP-860

https://sydneyuni.atlassian.net/browse/TAP-860

• Phone preference be defaulted to mobile (because iMod leads are coming in with Mobile numbers)

• Email preference defaulted to Personal email.

Nov 30, 2022

CLOSED

BR-008

Address Type

Default to “Home Address” for Household and “Business Address” for Organisations.

Nov 9, 2022

CLOSED

BR-009

Duplicate Accounts

1. Gather rules - make decision if rules are accurate or not;

2. Analyse how do 'Duplicate Record Set' functionality work, Rules, audit the rules to make sure they are accurate, @Manpreet Sidhu , Mar 10, 2023 → TAP-1214 Jarvis Duplicate Rule Sets

Dec 14, 2022

open

BR-010

Mobile Phone Field

What details should be in the mobile phone field ? Aust mobile vs international mobile

Present: @rommel.ngo , @Monica Kluegel , @jessica.wood , @Yeng Sembrano , @Nick Kellaway , @Polina Nikulina ,

FYI: @AlainGasquet @Manpreet Sidhu

Agreed in principle:

1. Mobile phone should be for Australian mobile phones - Mar 15, 2023 - @AlainGasquet , @Monica Kluegel

1. Account phone should be for Australian landline numbers - Mar 15, 2023 - @AlainGasquet , @Monica Kluegel

Next steps:

1. We need some rigour around international numbers; - Where do they go ??

2. We need a clear view of how the phones fields are populated and to review why (eg why SITS populates Account and not Contact),

3. The preference of the business is to create new fields for international landline and mobile numbers as the alternate channels are not used by the majority of users but we need to decide if it is feasible

Mar 15, 2023

open

BR-011

Address Preference

If Address is blank on Contact & Account, should Address Preference be Blank too ? (Next Steps:- create a validation rule for address preference, should be blank for blank addresses)

Present Mar 22, 2023 : @Monica Kluegel , @Manpreet Sidhu , @Yeng Sembrano ,@AlainGasquet , @Nick Kellaway , @albie.roets

Absent: @Miranda Adams , @jessica.wood , @rommel.ngo

1. Set Address Preference to blank when address is blank - Mar 22, 2023 - @AlainGasquet , @Monica Kluegel

1. Next steps: Auto update the field when user updates: Set default based on contact and account type - engage community giving - prepare options (exhaustive) - @albie.roets ,

2. Done ticket https://sydneyuni.atlassian.net/browse/TAP-1018 already completed.

Mar 22, 2023

open

BR-012

Student ID

If the student ID cannot be verified, then should we mark it as type='other'? or leave it as it is i.e, type='Sydney Student ID'.

Present: @Monica Kluegel , @AlainGasquet , @Nick Kellaway , @albie.roets , @Manpreet Sidhu ,

1. Validate manually against SS - #119

2. Does not harm integration - fix manually - @Manpreet Sidhu

Mar 22, 2023

open

BR-013

Staff are associated to which faculties

• Is there a way to map Development Staff to faculties in Jarvis? (Does anything exist) -

• Background - Mapping Exercise - Work with Donor Relations - which team are they dealing with

• Mar 22, 2023,@AlainGasquet says - Should not deal with this on Jarvis level.

1. Mar 22, 2023 Should not deal with this on Jarvis level.

Mar 22, 2023

CLOSED

BR-014

Address Status for Deceased = Deceased ?

• Mar 22, 2023, @Monica Kluegel says check what deceased utility does and copy !

1. Address Status for Deceased = Deceased

Mar 22, 2023

CLOSED

BR-015

Unit Addresses not Unit x<space>, but “/”

Address Formatting Business Rules - what to do about 150 k aperture updated units in the wrong format - need to get a view on that ?

Mar 29, 2023

NOT STARTED

BR-016

Is Influential Alumni

Definition of Influential Alumni ?

Mar 29, 2023

NOT STARTED

BR-017

Define Address Statuses

Define Address Statuses ?

• Active =

• Inactive =

• Last Known =

• Needs Verification =

• Return to Sender (RTS) =

• Partial Address =

What about Deceased ?

Mar 29, 2023

NOT STARTED

BR-018

Address Type consolidation

1. Define each address type

2. https://sydneyuni.atlassian.net/browse/TAP-1364

Mar 29, 2023

NOT STARTED