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

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

Not pushing in-scope data

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

SITS/Mulesoft

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

rommel.ngo

3

Not pushing in-scope data

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 )

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

19

Not pushing in-scope data

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

SITS/Mulesoft

• AVE-531

18

Not pushing in-scope data

SITS Integration - Multiple error records for the same student ID

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

31 Jan 2023

satparkash.kaushik /

3

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.

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

4

Overwriting more recent Jarvis Data

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)

08 Feb 2023

Swathi Inapakolla

7

Business Logic

Integration Logic

28 Feb 2023

Manpreet Sidhu

10

Corrupted Address Data Interfacing

Corrupted : Address

15

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

8

Education Reference Table

Increase area of study field to 100 characters

28 Feb 2023

AQ Ticket #4715

9

Error Report Logic

SITS integration - Removal of PO type address error message

15 Feb 2023

satparkash.kaushik

11

Corrupted Address Data Interfacing

Corrupted : City

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

10

Address Enhancement

Update Address Type for PO Box addresses to Postal Address

31 Mar 2023

satparkash.kaushik

•  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

•  TAP-108 Multiple error records for the same student ID - Make sure the ticket details are there + Ticket status

14

Corrupted Address Data Interfacing

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

SITS/Mulesoft

16

Corrupted Address Data Interfacing

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

• = ‘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 = ‘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 / Tested by Manpreet Sidhu

17

Corrupted Address Data Interfacing

SITS integration - Removal of PO type address error

SITS/Mulesoft

•  TAP-110 SITS Integration: Corrupted City - Make sure the ticket details are there + Ticket status = ‘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

satparkash.kaushik

4

31 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 …SITS/Mulesoft

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

SITS/Mulesoft

13

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

satparkash.kaushik /
Tested by Manpreet Sidhu

6

18

Education Reference Table

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

SITS/Mulesoft19

7

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

8

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

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