Attention: Confluence is not suitable for the storage of highly confidential data. Please ensure that any data classified as Highly Protected is stored using a more secure platform.
If you have any questions, please refer to the University's data classification guide or contact ict.askcyber@sydney.edu.au
5.1 SITS-Jarvis Integration BAU Production Defects
- albie.roets
- pat.dennis
- Mai Ha
- Manpreet Sidhu
HOME PAGE: Data Quality Management
Timeline
Integration Business Requirements
Date | System | Documents | Comments |
|---|---|---|---|
Jul 23, 2020 | SITS | Original SITS/Jarvis Interface Business Requirements | |
Nov 30, 2021 | SWIFT Update your Details |
| |
Jan 18, 2023 | All | https://sydneyuni.atlassian.net/wiki/spaces/IP/pages/1352368226 | Integration Documentation |
Jarvis SITS BAU Production Defects
https://sydneyuni.atlassian.net/browse/TAP-907
No | Type | Description | Jira Ticket (EPIC AVE-133) | Due Date | Assignee | Comments / Status Update |
1 | Google Address API | Salesforce Unit / Apartment addresses - enhance Google API integration to deal with Unit / Apartment addresses | Raise Jira Ticket for Salesforce Unit address enhancement, @Yeng Sembrano , Jan 31, 2023 | Mar 31, 2023 | @Yeng Sembrano | Salesforce will implement in Q1 2023 |
2 | Business Logic: Overwriting more recent Jarvis Data | Deceased - Account Object : mule_svc incorrectly = changing Account Status from Deceased to Active on Account only. Not changing Contact object. | Jan 31, 2023 | @satparkash.kaushik / Tested by @Manpreet Sidhu | Testing completed- Deployment into production in Jan 2023 | |
3 | Business Logic: Overwriting more recent Jarvis Data | SITS emails and telephone numbers logic: SITS integration destroying cleaned data. | Jan 31, 2023 | @satparkash.kaushik / Tested by @Manpreet Sidhu | Logic defined and approved - implementation Jan 2023 | |
4 | Link between Account and Contact | Contact Object level: preferences are not “ set” - upon the Contact Object = not drawing the datapoints through …from the Account Object, …. onto the Contact , leaving fields blank. Preferences not set : on the Contact Object
Result in :
| Jan 31, 2023 | @satparkash.kaushik / | Testing completed- Deployment into production in Jan 2023 | |
5 | Error Report Logic | SITS Integration- Address is being marked incorrectly as Non English Address. | Jan 31, 2023 | @satparkash.kaushik / Tested by @Manpreet Sidhu | ||
6 | Education Reference Table | Education Object - Area Of Studies : Areas of Studies ( i.e. education “Pathway” ) = education “major / minor / program” not being created for select Areas of Studies, on Education Object. Eg :
| Feb 8, 2023 | @Swathi Inapakolla |
| |
7 | Business Logic | Integration Logic | Feb 28, 2023 | @Manpreet Sidhu | ||
8 | Education Reference Table | Increase area of study field to 100 characters | Feb 28, 2023 | AQ Ticket #4715 | ||
9 | Error Report Logic | SITS integration - Removal of PO type address error message | Feb 15, 2023 | @satparkash.kaushik
| ||
10 | Address Enhancement | Update Address Type for PO Box addresses to Postal Address | Mar 31, 2023 | @satparkash.kaushik | TAP-1355 Set backlog refining session with Sat for Integration tickets, @Prabhu Kannan , Mar 3, 2023 | |
11 | Business Logic: Not pushing in-scope data | SITS Integration - Multiple error records for the same student ID | Mar 31, 2023 | @satparkash.kaushik | TAP-108 Multiple error records for the same student ID - Make sure the ticket details are there + Ticket status = ‘04 Refine’ @pat.dennis , Mar 3, 2023 TAP-108 Set backlog refining session with Sat for Integration tickets, @Prabhu Kannan , Mar 3, 2023 | |
12 | Address Interface Fix | Corrupted : Address - International addresses corrupted by Non-English characters, or foreign keyboard. | Feb 28, 2023 | @satparkash.kaushik | TAP-109 SITS Integration: Corrupted Address - Make sure the ticket details are there + Ticket status = ‘04 Refine’, @pat.dennis , Mar 3, 2023 TAP-109 Set backlog refining session with Sat for Integration tickets, @Prabhu Kannan , Mar 3, 2023 | |
13 | Address Interface Fix | Corrupted : City Absent-Missing Integration data : 1. City / Suburb 2. Country. Push data without : Country / City / Suburb. | Feb 28, 2023 | @satparkash.kaushik | TAP-110 SITS Integration: Corrupted City - Make sure the ticket details are there + Ticket status = ‘04 Refine’, @pat.dennis , Mar 3, 2023 TAP-110 Set backlog refining session with Sat for Integration tickets, @Prabhu Kannan , Mar 3, 2023 | |
14 | Business Logic: Not pushing in-scope data | SITS Integration - Alumni Records in SITs but not in Jarvis/Salesforce | Mar 31, 2023 |
| TAP-305 Alumni Records in SITs but not in Jarvis/Salesforce - Reconciliation, @Manpreet Sidhu , Mar 31, 2023 | |
15 | Address Enhancement | Country Codes in SITS are different to Google API country codes used in SF, i.e. China vs … |
|
|
| NEW TRIAGE |
16 | Address Interface Fix | Push Failed to write Unit Number as part of the address, on both Account & Contact. - Unit number present in raw push data. |
|
|
|
|
17 | Link between Account and Contact | Account Object level: push datapoints not writing to Account in many instances.
|
|
|
|
|
18 | Education Reference Table | Education Object : Duplicate Education records captured. ie duplicate education ID’s |
|
|
|
|
19 | Education Reference Table | Education Object : Duplicate capture of - Double Degrees. 1st capture when converted from Advance to Salesforce = AQConversion. 2nd capture from SITS Push feed = mule-svc |
|
|
|
|
Meeting Minutes / Actions:
Date | Description | Comments |
|---|---|---|
Dec 16, 2022 |
| |
Dec 16, 2022 | This cannot be verified until the next batch runs first week of 2023. Changed due date to next year. | |
Dec 16, 2022 | ||
Dec 16, 2022 |
| |
Dec 16, 2022 |
| |
Dec 20, 2022 | Done. Current logic provided by @Manpreet Sidhu on Dec 20, 2022
| |
Dec 21, 2022 |
| |
Dec 22, 2022 |
| |
Dec 22, 2022 | Early new year meeting | |
|
|
|