Data Quality Dashboards
Contacts and Accounts | Mailing Addresses | Opportunities | Campaigns | Education | Charts of Accounts | Gift And Pledges |
|---|---|---|---|---|---|---|
https://sydneyuni-adv.lightning.force.com/lightning/r/Dashboard/01Z8v0000005ayGEAQ/view | https://sydneyuni-adv.lightning.force.com/lightning/r/Dashboard/01Z8v0000005ayLEAQ/view | https://sydneyuni-adv.lightning.force.com/lightning/r/Dashboard/01Z8v0000005ayfEAA/view |
Reports
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 | 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 | Accounts |
| 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 | Contacts |
|
|
| ||||||||||
DQC-002 | Contacts without Primary Contact Type | Contacts |
| Existing | |||||||||||
DQC-003 | Contact with Grad Year but not Alumni | Contacts |
| Existing | |||||||||||
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 |
| Existing | |||||||||||
DQC-006 | Age <18 | Contacts |
| Existing | |||||||||||
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-008 | Education with Empty School | Contacts |
| Existing | |||||||||||
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 | |||||||||
DQC-010 | Primary Contact - Address Preference | Contacts |
| Existing | |||||||||||
DQC-011 | Missing Contact Mailing Suburbs-AU only | Contacts |
| Existing | |||||||||||
DQC-012 | Blank Contact Mailing Address Preference | Contacts |
| Existing | |||||||||||
DQC-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 | |||||||||||
DQG-001 | GA - Transactions Blank Acknowledgement | Gift Admin |
| Existing | |||||||||||