Content Comparison

DQA-001

Missing Account Types01 Jul 2022

Yeng Sembrano

Existing

Where Account Type = ””

https://sydneyuni-adv.lightning.force.com/lightning/r/Report/00O8v000000K2RlEAK/view

DQA-002

Accounts with No Primary Contact

01 Jul 2022

Yeng Sembrano

Existing

Account Status = Active

Primary Contact ID = ““

https://sydneyuni-adv.lightning.force.com/lightning/r/Report/00O8v000000K2TcEAK/view

DQA-003

Households without a Primary/Sec contact01 Jul 2022

Yeng Sembrano

Existing

Account Record Type = Household

Full Name start with ““

Primary Contact: Full Name = ““

Account Status = Active

https://sydneyuni-adv.lightning.force.com/lightning/r/Report/00O8v000000K2ThEAK/view

DQC-001

Contact Types

16 Sep 2022

jessica.wood

• Jira Legacy
  server System JIRA serverId e9de0c6d-9ef6-3ada-b4ce-7168c44d7e8a key AVE-16

• AVE-16 Contact Types

1. No empty primary contact type

2. Primary contacts can only be as per the list in AVE-16

3. “Parent of Student - Alumni” cannot be primary, only secondary

4. Secondary contact type is as per the table values in Jira ticket (AVE-16 Contact Types )

5. Never have friend as secondary contact

6. If contact empty, then should default to Friend.

DQC-002

Contacts without Primary Contact Type01 Jul 2022

Yeng Sembrano

Existing

DQC-003

Contact with Grad Year but not Alumni01 Jul 2022

Yeng Sembrano

Existing

DQC-004

Living Contact Attached to an Estate01 Jun 2022

Yeng Sembrano

Existing

Where Account Type = “Estate” and Contact Type not in (“Corporate Contact”, “Executor”, “Solicitor”) and Deceased = “False)

https://sydneyuni-adv.lightning.force.com/lightning/r/Report/00O8v000000K2QxEAK/view

DQC-005

Age >= 110

01 Jul 2022

Yeng Sembrano

Existing

DQC-006

Age <18

01 Jul 2022

Yeng Sembrano

Existing

DQC-007

Alumni no primary degree01 Jun 2022

Yeng Sembrano

Existing

Where Contact Type = “Alumni” or “Graduand” and EducationID = NULL

https://sydneyuni-adv.lightning.force.com/lightning/r/Report/00O8v000000JYknEAG/view

DQC-008

Education with Empty School01 Jul 2022

Yeng Sembrano

Existing

DQC-009

Alumni with Address = Student Centre01 Jul 2022

Yeng Sembrano

Existing

Where Contact Type = (Alumni, Graduant) and Contact Mailing Address contains G02 or contains UNIVERSITY OF SYDNEY or Contains Student Centre and Mailing Adress Status = Active and Employer Name does not contain “University of Sydney, Sydney University)

https://sydneyuni-adv.lightning.force.com/lightning/r/Report/00O8v000000K2SZEA0/view

DQC-010

Primary Contact - Address Preference01 Jul 2022

Yeng Sembrano

Existing

DQC-011

Missing Contact Mailing Suburbs-AU only

01 Jul 2022

Yeng Sembrano

Existing

DQC-012

Blank Contact Mailing Address Preference

01 Jul 2022

Yeng Sembrano

Existing

DQC-013

Blank Contact Mailing Address Status01 Jul 2022

Yeng Sembrano

Existing

DQC-014

Blank Contact Mailing Address Type01 Jul 2022

Yeng Sembrano

Existing

DQC-015

Volunteer Positions without Start Date01 Jul 2022

Yeng Sembrano

Existing

DQG-001

GA - Transactions Blank Acknowledgement

01 Jul 2022

Yeng Sembrano

Existing

Contacts

AVE-422

Email typos

AVE-422

Email addresses with typo’s in them:

hotmail.com.au, gmail.com.au, .comn; .comm; .con;

hotmail.com.au = hotmail.com

gmail.com.au = gmail.com

comn; .comm; .con; .coom = .com

https://sydneyuni-adv.lightning.force.com/lightning/r/Report/00O8v000000K6FAEA0/view