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

No

Type

Description

Jira Ticket (EPIC AVE-133)

Due Date

Assignee

Comments / Status Update

10

Google Address API

Salesforce Unit / Apartment addresses - enhance Google API integration to deal with Unit / Apartment addressesSalesforce (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

1

Swift Update Your Details Form

Image Removed

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.

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

1. A.

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.

SITS/Mulesoft

3.B.

Logic - When pushing ? Issue = Graduand & No Contact Created. 1. No Contact Created. 2. Graduand 3. SITS : No Conferred Date of any Award. (Defining Factor Conferral of award = Alumni )

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

4

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

SITS/Mulesoft

5

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

SITS/Mulesoft

31 Jan 2023

satparkash.kaushik /
Tested by Manpreet Sidhu

5

Error Report Logic

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

31 Jan 2023

satparkash.kaushik / Tested by Manpreet Sidhu

6

Education

SITS/Mulesoft

Reference Table

Education Object

SITS/Mulesoft

8

-

Area Of Studies : Areas of Studies ( i.e. education “Pathway” ) =  education “major /

Salesforce

(SF)

9

Deceased - Account Object : mule_svc incorrectly = changing Account Status from Deceased to Active on Account only.   Not changing Contact object.

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)

satparkash.kaushik / Tested by Manpreet Sidhu

10

Corrupted : Address

08 Feb 2023

Swathi Inapakolla

7

Business Logic

Integration Logic

satparkash.kaushik

11

Corrupted : City

SITS/Mulesoft

28 Feb 2023

Manpreet Sidhu

8

Education Reference Table

Increase area of study field to 100 characters

satparkash.kaushik

12

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

13

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

28 Feb 2023

AQ Ticket #4715

9

Error Report Logic

SITS integration - Removal of PO type address error message

15 Feb 2023

satparkash.kaushik

10

Address Enhancement

Update Address Type for PO Box addresses to Postal Address

31 Mar 2023

satparkash.kaushik /
Tested by Manpreet Sidhu

14

Push Failed to write Unit Number as part of the address, on both Account & Contact. - Unit number present in raw push data.

SITS/Mulesoft

15

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

SITS/Mulesoft

16

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

SITS/Mulesoft

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

11

Business Logic: Not pushing in-scope data

SITS Integration - Multiple error records for the same student ID

31 Mar 2023

satparkash.kaushik / Tested by Manpreet Sidhu

17

SITS integration - Removal of PO type address error

SITS/Mulesoft

•  TAP-108 Multiple error records for the same student ID - Make sure the ticket details are there + Ticket status = ‘04 Refine’ pat.dennis , 03 Mar 2023
•  TAP-108 Set backlog refining session with Sat for Integration tickets, Prabhu Kannan , 03 Mar 2023

12

Address Interface Fix

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

28 Feb 2023

satparkash.kaushik

•  TAP-109 SITS Integration: Corrupted Address - Make sure the ticket details are there + Ticket status

18

SITS Integration - Multiple error records for the same student ID

• = ‘04 Refine’, pat.dennis , 03 Mar 2023
•  TAP-109 Set backlog refining session with Sat for Integration tickets, Prabhu Kannan , 03 Mar 2023

13

Address Interface Fix

Corrupted : City

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

28 Feb 2023

satparkash.kaushik

•  TAP-110 SITS Integration: Corrupted City - Make sure the ticket details are there + Ticket status

19

• = ‘04 Refine’, pat.dennis , 03 Mar 2023
•  TAP-110 Set backlog refining session with Sat for Integration tickets, Prabhu Kannan , 03 Mar 2023

14

Business Logic: Not pushing in-scope data

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

SITS/Mulesoft

20

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/Mulesoft31 Mar 2023

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

15

Address Enhancement

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

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.

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

2^nd capture from SITS Push feed = mule-svc

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 , 17 Mar 2023

Early new year meeting