23 Jul 2020

SITS

Original SITS/Jarvis Interface Business Requirements

30 Nov 2021

SWIFT Update your Details

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

2Business Logic: (

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

13 Jan 2023

rommel.ngo

3Business Logic: (

Not pushing in-scope data

Business Logic : (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 )

SITS/Mulesoft

19Business Logic: (

Not pushing in-scope data

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

SITS/Mulesoft

3

Business Logic: (18

Not pushing in-scope data

SITS Integration - Multiple error records for the same student ID

SITS/Mulesoft

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.

SITS/Mulesoft

satparkash.kaushik / Tested by Manpreet Sidhu

4

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

13 Jan 2023

2

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

satparkash.kaushik /
Tested by Manpreet Sidhu

1015

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

10

Corrupted Address Data Interfacing

Corrupted : Address

SITS/Mulesoft

satparkash.kaushik

11

Corrupted Address Data Interfacing

Corrupted : City

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

SITS/Mulesoft

satparkash.kaushik

4

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

SITS/Mulesoft

6

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

SITS/Mulesoft

7

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 Object - Area Of Studies : Areas of Studies ( education “Pathway” ) =  education “major / minor” not currently included within salesforce picklist. Update SF.

Salesforce

(SF)

14

Push 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

15

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

SITS/Mulesoft

1616

Corrupted Address Data Interfacing

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

SITS/Mulesoft

satparkash.kaushik / Tested by Manpreet Sidhu

17

Corrupted Address Data Interfacing

SITS integration - Removal of PO type address error

SITS/Mulesoft

satparkash.kaushik

18

SITS Integration - Multiple error records for the same student ID

SITS/Mulesoft

4

Address Enhancement

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

SITS/Mulesoft

2

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

20 /
Tested by Manpreet Sidhu

6

Education Reference Table

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

SITS/Mulesoft

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