Versions Compared

Version Old Version 83 New Version 84
Changes made by

albie.roets

albie.roets

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

HOME PAGE: Data Quality Management
EPIC:
Jira Legacy
serverSystem JIRA
serverIde9de0c6d-9ef6-3ada-b4ce-7168c44d7e8a
keyTAP-907
DOCUMENTATION: /wiki/spaces/IP/pages/1352368226

Timeline

Roadmap Planner
maplinks
timelinetrue
source%7B%22title%22%3A%22Roadmap%20Planner%22%2C%22timeline%22%3A%7B%22startDate%22%3A%222022-12-09%2000%3A00%3A00%22%2C%22endDate%22%3A%222023-08-31%2000%3A00%3A00%22%2C%22displayOption%22%3A%22MONTH%22%7D%2C%22lanes%22%3A%5B%7B%22title%22%3A%22Analysis%22%2C%22color%22%3A%7B%22lane%22%3A%22%23f6c342%22%2C%22bar%22%3A%22%23fadb8e%22%2C%22text%22%3A%22%23594300%22%2C%22count%22%3A1%7D%2C%22bars%22%3A%5B%7B%22title%22%3A%22Def%20Scope%22%2C%22description%22%3A%22This%20is%20the%20first%20bar.%22%2C%22startDate%22%3A%222022-12-01%2000%3A01%3A43%22%2C%22duration%22%3A0.9702970297029703%2C%22rowIndex%22%3A0%2C%22id%22%3A%22727558c1-419c-4a2c-ad8f-643c387c1d7e%22%2C%22pageLink%22%3A%7B%7D%7D%5D%7D%2C%7B%22title%22%3A%22DevOps%22%2C%22color%22%3A%7B%22lane%22%3A%22%23d04437%22%2C%22bar%22%3A%22%23dc7369%22%2C%22text%22%3A%22%23ffffff%22%2C%22count%22%3A1%7D%2C%22bars%22%3A%5B%7B%22rowIndex%22%3A0%2C%22startDate%22%3A%222022-12-31%2016%3A38%3A01%22%2C%22id%22%3A%229eefde59-7605-4457-b134-f7bf5addefdc%22%2C%22title%22%3A%22Fix%20Implementation%20SITS%22%2C%22description%22%3A%22%22%2C%22duration%22%3A1.99009900990099%2C%22pageLink%22%3A%7B%7D%7D%2C%7B%22rowIndex%22%3A1%2C%22startDate%22%3A%222023-02-01%2021%3A32%3A44%22%2C%22id%22%3A%2232bfcf96-1ab8-483d-a368-dc3bd6b056a9%22%2C%22title%22%3A%22Fix%20Implementation%20SWIFT%22%2C%22description%22%3A%22%22%2C%22duration%22%3A1.9603960396039604%2C%22pageLink%22%3A%7B%7D%7D%5D%7D%2C%7B%22title%22%3A%22Data%20Fixes%22%2C%22color%22%3A%7B%22lane%22%3A%22%233b7fc4%22%2C%22bar%22%3A%22%236c9fd3%22%2C%22text%22%3A%22%23ffffff%22%2C%22count%22%3A1%7D%2C%22bars%22%3A%5B%7B%22rowIndex%22%3A0%2C%22startDate%22%3A%222023-04-02%2002%3A33%3A56%22%2C%22id%22%3A%22fdecc921-f7e2-44f8-a9aa-26f329651dff%22%2C%22title%22%3A%22Data%20Fixes%22%2C%22description%22%3A%22%22%2C%22duration%22%3A1.9504950495049505%2C%22pageLink%22%3A%7B%7D%7D%5D%7D%5D%2C%22markers%22%3A%5B%7B%22markerDate%22%3A%222022-12-31%2023%3A58%3A16%22%2C%22title%22%3A%22Analysis%20Complete%22%7D%2C%7B%22markerDate%22%3A%222023-03-31%2023%3A58%3A16%22%2C%22title%22%3A%22System%20Fixes%20Completed%22%7D%2C%7B%22markerDate%22%3A%222023-06-01%2007%3A04%3A22%22%2C%22title%22%3A%22Completed%2030%2F05%2F2023%22%7D%5D%7D
pagelinks
titleRoadmap%20Planner
hash3388d88ba76cdd20e500c4ac7b3e57c3

Integration Business Requirements

Date

System

Documents

Comments

SITS

View file
nameSITS validation rules - test data.xlsx
View file
nameSITS-AQ-interface-business-req.docx

Original SITS/Jarvis Interface Business Requirements

SWIFT Update your Details

View file
nameSWIFT_Update_Your_Details - Mapping.csv
View file
nameSwift to Jarvis Integration Process 2021_revised_30112021.pdf

All

/wiki/spaces/IP/pages/1352368226

Integration Documentation

(error) Jarvis SITS BAU Production Defects

Not pushing in-scope dataBusiness Logic: Decision (Business Rule decision ) as to = when to accept push data, or not to accept. When Re: 1. Graduand.  2. SITS = No Conferred Date of any award.  3. Award Status = flagged as only "calculated" or "eligible" . 4. Award Code = present.  5. Push carries/created Education record data. 90813 SITS/MulesoftTAP305108Deceased - Account Object : mule_svc incorrectly = changing Account Status from Deceased to Active on Account only.   Not changing Contact object.465 / Tested by Manpreet Sidhu 7SITS emails and telephone numbers logic: SITS integration destroying cleaned data.Logic defined and approved - implementation Jan 2023

No

Type

Description

Source Systems

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

Salesforce (SF)

  •  Raise Jira Ticket for Salesforce Unit address enhancement, Yeng Sembrano ,

Yeng Sembrano

Salesforce will implement in Q1 20232

5

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.

SITS/Mulesoft

Jira Legacy
serverSystem JIRA
serverIde9de0c6d-9ef6-3ada-b4ce-7168c44d7e8a
keyTAP-

465

rommel.ngo

Status
colourRed
titleNEW TRIAGE
- Need to define business logic for an overall fix

3

Business Logic: Not pushing in-scope data

SITS Integration - Alumni Records in SITs but not in Jarvis/Salesforce

satparkash.kaushik / Tested by Manpreet Sidhu

Tip

Testing completed- Deployment into production in Jan 2023

7

Business Logic: Overwriting more recent Jarvis Data

SITS emails and telephone numbers logic: SITS integration destroying cleaned data.

  • Jira Legacy
    serverSystem JIRA
    serverIde9de0c6d-9ef6-3ada-b4ce-7168c44d7e8a
    key

  • AVE-

4

Business Logic: Not pushing in-scope data

SITS Integration - Multiple error records for the same student ID

  • 531

SITS/Mulesoft

Jira Legacy
serverSystem JIRA
serverIde9de0c6d-9ef6-3ada-b4ce-7168c44d7e8a
keyTAP-

111

satparkash.kaushik / Tested by Manpreet Sidhu

Status
colourRed
titleNEW TRIAGE

5

Business Logic: Overwriting more recent Jarvis Data

Tip

Logic defined and approved - implementation Jan 2023

Education Reference Table

Increase area of study field to 100 characters

SITS/Mulesoft

Jira Legacy
serverSystem JIRA
serverIde9de0c6d-9ef6-3ada-b4ce-7168c44d7e8a
keyTAP-

1177

Tip

Testing completed- Deployment into production in Jan 2023

3

Business Logic: Overwriting more recent Jarvis Data

Not pushing in-scope data

SITS Integration - Alumni Records in SITs but not in Jarvis/Salesforce

SITS/Mulesoft

Jira Legacy
serverSystem JIRA
serverIde9de0c6d-9ef6-3ada-b4ce-7168c44d7e8a
key

AVE-531

TAP-305

4

Business Logic: Not pushing in-scope data

SITS Integration - Multiple error records for the same student ID

SITS/Mulesoft

Jira Legacy
serverSystem JIRA
serverIde9de0c6d-9ef6-3ada-b4ce-7168c44d7e8a
keyTAP-111

Tip
108

satparkash.kaushik

Status
colourRed
titleNEW TRIAGE

8

Business Logic: Overwriting more recent Jarvis Data

Push: Overwriting with partial address, on both Account & Contact - removing already corrected, full address.

SITS/Mulesoft

Same as email and phone TAP-111

9

Address Interface Fix

Corrupted : Address

SITS/Mulesoft

Jira Legacy
serverSystem JIRA
serverIde9de0c6d-9ef6-3ada-b4ce-7168c44d7e8a
keyTAP-109

satparkash.kaushik

Status
colourRed
titleNEW TRIAGE

10

Address Interface Fix

Corrupted : City

Absent-Missing Integration data : 1. City / Suburb 2. Country. Push data without : Country / City / Suburb.

SITS/Mulesoft

Jira Legacy
serverSystem JIRA
serverIde9de0c6d-9ef6-3ada-b4ce-7168c44d7e8a
keyTAP-110

satparkash.kaushik

Status
colourRed
titleNEW TRIAGE

11

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.

SITS/Mulesoft

12

Address Interface Fix

SITS Integration- Address is being marked incorrectly as English Address.

SITS/Mulesoft

Jira Legacy
serverSystem JIRA
serverIde9de0c6d-9ef6-3ada-b4ce-7168c44d7e8a
keyTAP-30

satparkash.kaushik / Tested by Manpreet Sidhu

Tip

Testing completed- Deployment into production in Jan 2023

13

Address Interface Fix

SITS integration - Removal of PO type address error

SITS/Mulesoft

Jira Legacy
serverSystem JIRA
serverIde9de0c6d-9ef6-3ada-b4ce-7168c44d7e8a
keyTAP-886

satparkash.kaushik

Status
colourRed
titleNEW TRIAGE

14

Address Enhancement

Country Codes in SITS are different to Google API country codes used in SF, i.e. China vs …

SITS/Mulesoft

Status
colourRed
titleNEW TRIAGE

15

Link between Account and Contact

Account Object level: push datapoints not writing to Account in many instances.

  • Mailing Address  ( flagged in the raw data as Correspondence: “Y”).

  • Mailing Address Type.

  • Phone   ( flagged in the raw data as Correspondence: “Y”).

  • Email address  ( flagged in the raw data as Correspondence: “Y”)

SITS/Mulesoft

16

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

  • Address preference.

  • Phone Preference.

  • Email Preference

Result in  :

  • Blank  :  Mailing Address type

  • Blank  : Address Preference

SF

Jira Legacy
serverSystem JIRA
serverIde9de0c6d-9ef6-3ada-b4ce-7168c44d7e8a
keyAVE-25

satparkash.kaushik /
Tested by Manpreet Sidhu

Tip

Testing completed- Deployment into production in Jan 2023

17

Education Reference Table

Education Object : Duplicate Education records captured.  ie duplicate education ID’s

SITS/Mulesoft

18

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

SITS/Mulesoft

19

Education Reference Table

Education Object - Area Of Studies : Areas of Studies ( education “Pathway” ) =  education “major / minor” not currently included within salesforce picklist. Update SF.

SITS/Mulesoft

20

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 :

*Taronga Wildlife Conservation (major in Wildlife Conservation)
*Politics and International Relations (major in Politics and International Relations)

  • Management and Leadership

SITS/Mulesoft

Meeting Minutes / Actions:

Date

Description

Comments

  •  Scale of integration issues, run report on daily numbers and issue types, Manpreet Sidhu ,

  •  Binila needs to map out most common SWIFT Integration errors, Binila Russel ,

This cannot be verified until the next batch runs first week of 2023. Changed due date to next year.

  •  Turn SITS / Jarvis integration off until the integration issues are fixed. Manpreet to raise ticket to have this done, Manpreet Sidhu ,

Jira Legacy
serverSystem JIRA
serverIde9de0c6d-9ef6-3ada-b4ce-7168c44d7e8a
keyTAP-903
raised.

  •  Triage and Clean integration tickets up and make sure that all integration tickets are raised in Jira, albie.roets ,

  •  Raise Sev 1 BAU Production Defect Ticket (SNOW) for SITS BAU Integration Defect Fixes, Manpreet Sidhu ,

Done. Current logic provided by Manpreet Sidhu on

View file
nameSITS validation rules - test data.xlsx
View file
nameSITS-AQ-interface-business-req.docx

  •  Analysis and Define overall SITS Integration logic (Delta vs full, etc, etc), rommel.ngo ,

  •  Integration enablement - find person / process for turning on on / , Manpreet Sidhu ,

  •  SWIFT process is that a person drops a file in a folder and then integration picks that up - lately nobody has been dropping file in folder. Needs to tighten process with Phil. Put meeting in diary (Binila, Pat, Manpreet, The Ho, Alain), albie.roets ,

Early new year meeting