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

SITS-Jarvis 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 127 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

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 ,

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.

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

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

AVE-25 - Getting issue details... STATUS

satparkash.kaushik /
Tested by Manpreet Sidhu

Testing completed- Deployment into production in Jan 2023

5

Error Report Logic

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

TAP-30 - Getting issue details... STATUS

satparkash.kaushik / Tested by Manpreet Sidhu

Testing completed- Deployment into production in Jan 2023

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 :

  • 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)

TAP-1180 - Getting issue details... STATUS

Swathi Inapakolla

Swathi Inapakolla updated Jarvis AoS Picklist

7

Business Logic

Integration Logic

TAP-908 - Getting issue details... STATUS

Manpreet Sidhu

TAP-908 SITS/Jarvis Integration - Business Logic

8

Education Reference Table

Increase area of study field to 100 characters

TAP-1177 - Getting issue details... STATUS

AQ Ticket #4715

AQ Ticket raised #4715. Await AQ Fix and deployment.

9

Error Report Logic

SITS integration - Removal of PO type address error message

TAP-886 - Getting issue details... STATUS

satparkash.kaushik

SITS integration - Removal of PO type address error update - TAP-886

10

Address Enhancement

Update Address Type for PO Box addresses to Postal Address

TAP-1355 - Getting issue details... STATUS

satparkash.kaushik

  • TAP-1355 Set backlog refining session with Sat for Integration tickets, Prabhu Kannan ,

11

Business Logic: Not pushing in-scope data

SITS Integration - Multiple error records for the same student ID

TAP-108 - Getting issue details... STATUS

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 ,
  • TAP-108 Set backlog refining session with Sat for Integration tickets, Prabhu Kannan ,

12

Address Interface Fix

Corrupted : Address - International addresses corrupted by Non-English characters, or foreign keyboard.

TAP-109 - Getting issue details... STATUS

satparkash.kaushik

  • TAP-109 SITS Integration: Corrupted Address - Make sure the ticket details are there + Ticket status = ‘04 Refine’, pat.dennis ,
  • TAP-109 Set backlog refining session with Sat for Integration tickets, Prabhu Kannan ,

13

Address Interface Fix

Corrupted : City

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

TAP-110 - Getting issue details... STATUS

satparkash.kaushik

  • TAP-110 SITS Integration: Corrupted City - Make sure the ticket details are there + Ticket status = ‘04 Refine’, pat.dennis ,
  • TAP-110 Set backlog refining session with Sat for Integration tickets, Prabhu Kannan ,

14

Business Logic: Not pushing in-scope data

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

TAP-305 - Getting issue details... STATUS

  • TAP-305 Alumni Records in SITs but not in Jarvis/Salesforce - Reconciliation, Manpreet Sidhu ,

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.

  • 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”)

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

  • 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