...
Rule Number | Rule Name | Object | Date | Owner | Confluence Jira Number | Business Logic | Jarvis Report Link | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
DQA-001 | Missing Account Types | Accounts |
| Existing | Where Account Type = ”” | https://sydneyuni-adv.lightning.force.com/lightning/r/Report/00O8v000000K2RlEAK/view | ||||||||||||||
DQA-002 | Accounts with No Primary Contact | Accounts |
| Existing | ||||||||||||||||
DQA-003 | Households without a Primary/Sec contact | Accounts |
| Existing | ||||||||||||||||
DQC-001 | Contact Types | Contacts |
|
|
| |||||||||||||||
DQC-002 | Contacts without Primary Contact Type | Contacts | ||||||||||||||||||
DQC-003 | Contact with Grad Year but not Alumni | Contacts | ||||||||||||||||||
DQC-004 | Living Contact Attached to an Estate | Contacts |
| 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 | Contacts | ||||||||||||||||||
DQC-006 | Age <18 | Contacts | ||||||||||||||||||
DQC-007 | Alumni no primary degree | Contacts |
| Existing | Where Contact Type = “Alumni” or “Graduand” and EducationID = NULL | https://sydneyuni-adv.lightning.force.com/lightning/r/Report/00O8v000000JYknEAG/view | ||||||||||||||
DQC-005008 | Education with Empty School | Contacts | ||||||||||||||||||
DQC-009 | Alumni with Address = Student Centre | Contacts |
| 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 | ||||||||||||||
Volunteer Positions without Start Date | ContactsDQC-010 | Primary Contact - Address Preference | Contacts83k |
| Existing | |||||||||||||||
DQC-003 | Contact with Grad Year but not Alumni | Contacts | 011 | Missing Contact Mailing Suburbs-AU only | Contacts | DQ-002 | Living Contact Attached to an Estate | Existing | ||||||||||||
DQC-012 | Blank Contact Mailing Address Preference | Contacts | Jun | Existing | Where Account Type = “Estate” and Contact Type not in (“Corporate Contact”, “Executor”, “Solicitor”) and Deceased = “False) | |||||||||||||||
Education with Empty School | Contacts | Age >= 110 | Contacts | Age <18 | Contacts | Contacts without Primary Contact Type | Contacts | Blank Contact Mailing Address Preference | Contacts | Blank Contact Mailing Address Status | Contacts | Blank Contact Mailing Address Type | ContactsDQC-013 | Blank Contact Mailing Address Status | Contacts |
| Existing | |||
DQC-014 | Blank Contact Mailing Address Type | Contacts |
| Existing | ||||||||||||||||
DQC-015 | Volunteer Positions without Start Date | Contacts |
| Existing | ||||||||||||||||