23 Jul 2020

SITS

Original SITS/Jarvis Interface Business Requirements

30 Nov 2021

SWIFT Update your Details

18 Jan 2023

All

/wiki/spaces/IP/pages/1352368226

Integration Documentation

Assignee

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 , 31 Jan 2023

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

SITS/Mulesoft

31 Jan 2023

satparkash.kaushik / Tested by Manpreet Sidhu

3

Business Logic: Overwriting more recent Jarvis Data

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

• Jira Legacy
  server System JIRA serverId e9de0c6d-9ef6-3ada-b4ce-7168c44d7e8a key AVE-531

SITS/Mulesoft

31 Jan 2023

satparkash.kaushik / Tested by Manpreet Sidhu

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

31 Jan 2023

satparkash.kaushik /
Tested by Manpreet Sidhu

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

10 Feb 2023

Manpreet Sidhu

•  Update Jarvis AoS Picklist Swathi Inapakolla , 10 Feb 2023

5

Education Reference Table

Increase area of study field to 100 characters

SITS/Mulesoft

15 Feb 2023

??

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

6

Address Interface Fix

SITS integration - Removal of PO type address error message

SITS/Mulesoft

15 Feb 2023

satparkash.kaushik

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

7

Address Interface Fix

Corrupted : Address

SITS/Mulesoft

satparkash.kaushik

8

Address Interface Fix

Corrupted : City

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

SITS/Mulesoft

satparkash.kaushik

Business Logic: Not pushing in-scope data

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

SITS/Mulesoft

Business Logic: Not pushing in-scope data

SITS Integration - Multiple error records for the same student ID

SITS/Mulesoft

satparkash.kaushik

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

satparkash.kaushik / Tested by Manpreet Sidhu

Address Enhancement

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

SITS/Mulesoft

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.

1^st capture when converted from Advance to Salesforce = AQConversion.

2^nd 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 , 10 Feb 2023

16 Dec 2022

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

16 Dec 2022

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

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

16 Dec 2022

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

16 Dec 2022

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

16 Dec 2022

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

20 Dec 2022

•  Provide SITS integration logic, Manpreet Sidhu , 20 Dec 2022

Done. Current logic provided by Manpreet Sidhu on 20 Dec 2022

21 Dec 2022

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

22 Dec 2022

•  Integration enablement - find person / process for turning on on 15 Jan 2023/ 16 Jan 2023 , Manpreet Sidhu , 23 Dec 2022

22 Dec 2022

•  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 , 09 Jan 2023

Early new year meeting