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
Skip to end of banner
Go to start of banner

Jarvis SITS Integration BAU Production Defects

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

« Previous Version 96 Next »

HOME PAGE: Data Quality Management
EPIC: TAP-907 - Getting issue details... STATUS
DOCUMENTATION: /wiki/spaces/IP/pages/1352368226

Timeline

Dec2022Jan2023FebMarAprMayJunJulAugAnalysis CompleteSystem Fixes CompletedCompleted 30/05/2023
Analysis
DevOps
Data Fixes

Def Scope

Fix Implementation SITS

Fix Implementation SWIFT

Data Fixes

Integration Business Requirements

Date

System

Documents

Comments

SITS

Original SITS/Jarvis Interface Business Requirements

SWIFT Update your Details

All

/wiki/spaces/IP/pages/1352368226

Integration Documentation

(error) Jarvis SITS BAU Production Defects

TAP-907 - Getting issue details... STATUS

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 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.

SITS/Mulesoft

TAP-465 - Getting issue details... STATUS

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.

  • AVE-531 - Getting issue details... STATUS

SITS/Mulesoft

TAP-111 - Getting issue details... STATUS

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

  • Address preference.

  • Phone Preference.

  • Email Preference

Result in  :

  • Blank  :  Mailing Address type

  • Blank  : Address Preference

SITS/Mulesoft

AVE-25 - Getting issue details... STATUS

satparkash.kaushik /
Tested by Manpreet Sidhu

Testing completed- Deployment into production in Jan 2023

5

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

  • Advanced Computing

  • Advanced Economics (major in Economics)

SITS/Mulesoft

TAP-1180 - Getting issue details... STATUS

Manpreet Sidhu

5

Education Reference Table

Increase area of study field to 100 characters

SITS/Mulesoft

TAP-1177 - Getting issue details... STATUS

??

  • Who to allocate ticket TAP-1177 to albie.roets to raise at refinement for prioritisation,

6

Address Interface Fix

SITS integration - Removal of PO type address error message

SITS/Mulesoft

TAP-886 - Getting issue details... STATUS

satparkash.kaushik

  • SITS integration - Removal of PO type address error update Manpreet Sidhu ,

7

Address Interface Fix

Corrupted : Address

SITS/Mulesoft

TAP-109 - Getting issue details... STATUS

satparkash.kaushik

NEW TRIAGE

8

Address Interface Fix

Corrupted : City

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

SITS/Mulesoft

TAP-110 - Getting issue details... STATUS

satparkash.kaushik

NEW TRIAGE

Business Logic: Not pushing in-scope data

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

SITS/Mulesoft

TAP-305 - Getting issue details... STATUS

Business Logic: Not pushing in-scope data

SITS Integration - Multiple error records for the same student ID

SITS/Mulesoft

TAP-108 - Getting issue details... STATUS

satparkash.kaushik

NEW TRIAGE

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

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

Address Interface Fix

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

SITS/Mulesoft

TAP-30 - Getting issue details... STATUS

satparkash.kaushik / Tested by Manpreet Sidhu

Testing completed- Deployment into production in Jan 2023

Address Enhancement

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

SITS/Mulesoft

NEW 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

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

Create “Award Type” field in Jarvis + Integration enhancement.

  • Create ticket for “Award Type” in Jarvis, Manpreet Sidhu ,

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 ,

TAP-903 - Getting issue details... STATUS 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

  • 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

  • No labels