Content Comparison

DQA-001

Missing Account Types

Yeng Sembrano

Existing

Where Account Type = ””

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

DQA-002

Accounts with No Primary Contact

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 contact

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

DQCAVE-00116

Contact Types

jessica.wood

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 Type

Yeng SembranoExisting

DQC-003

Contact with Grad Year but not Alumni

Yeng Sembrano

Existing

DQC-004

Living Contact Attached to an Estate

Yeng SembranoExisting

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

Yeng SembranoExisting

DQC-006

Age <18

Yeng Sembrano

Existing

DQC-007

Alumni no primary degree

Yeng SembranoExisting

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 School

Yeng Sembrano

Existing

DQC-009

Alumni with Address = Student Centre

Yeng SembranoExisting

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 Preference

Yeng SembranoExisting

DQC-011

Missing Contact Mailing Suburbs-AU only

Yeng Sembrano

Existing

DQC-012

Blank Contact Mailing Address Preference

Yeng SembranoExisting

DQC-013

Blank Contact Mailing Address Status

Yeng Sembrano

Existing

DQC-014

Blank Contact Mailing Address Type

Yeng SembranoExisting

DQC-015

Volunteer Positions without Start Date

Yeng SembranoExisting

DQG-001

GA - Transactions Blank Acknowledgement

Yeng Sembrano

Existing

Contacts

AVE-422

Email typosAVE-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