Timeline
| Roadmap Planner | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Integration Business Requirements
Date | System | Documents | Comments | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| SITS |
| Original SITS/Jarvis Interface Business Requirements | ||||||||
| SWIFT Update your Details |
| |||||||||
| All | Integration Documentation |
Jarvis
Integration SITS BAU Production Defects
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
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 will implement in Q1 2023 |
1
Swift Update Your Details Form
SWIFT
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. |
|
|
|
| Status | ||||
|---|---|---|---|---|
|
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.
|
|
| satparkash.kaushik / Tested by Manpreet Sidhu |
|
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
| Status | ||||
|---|---|---|---|---|
|
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 )
SITS/Mulesoft
| Status | ||||
|---|---|---|---|---|
|
4
Country Codes in SITS are different to Google API country codes used in SF, i.e. China vs …
SITS/Mulesoft
| Status | ||||
|---|---|---|---|---|
|
5
Absent-Missing Integration data : 1. City / Suburb 2. Country. Push data without : Country / City / Suburb.
SITS/Mulesoft
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
Result in :
|
|
| satparkash.kaushik / |
| ||||||||||
5 | Error Report Logic | SITS Integration- Address is being marked incorrectly as Non English Address. |
|
|
| satparkash.kaushik / Tested by Manpreet Sidhu |
| ||
6 | Education |
SITS/Mulesoft
7
Education Object : Duplicate capture of - Double Degrees.
1st capture when converted from Advance to Salesforce = AQConversion.
2nd capture from SITS Push feed = mule-svc
SITS/Mulesoft
8
Reference Table | Education Object - Area Of Studies : Areas of Studies ( i.e. education “Pathway” ) = education “major / minor / |
Salesforce
(SF)
9
Deceased - Account Object : mule_svc incorrectly = changing Account Status from Deceased to Active on Account only. Not changing Contact object.
program” not being created for select Areas of Studies, on Education Object. Eg :
|
|
satparkash.kaushik / Tested by Manpreet Sidhu
| Tip |
|---|
Testing completed- Deployment into production in Jan 2023 |
10
Corrupted : Address
|
|
| |||||||||
7 | Business Logic | Integration Logic |
|
| Status | ||||
|---|---|---|---|---|
|
11
Corrupted : City
SITS/Mulesoft
|
|
| |||||||||
8 | Education Reference Table | Increase area of study field to 100 characters |
|
| Status | ||||
|---|---|---|---|---|
|
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
|
| AQ Ticket #4715 |
| |||||||||||||
9 | Error Report Logic | SITS integration - Removal of PO type address error message |
|
|
| |||||||||||
10 | Address Enhancement | Update Address Type for PO Box addresses to Postal Address |
|
|
|
Tested by Manpreet Sidhu
| Tip |
|---|
Testing completed- Deployment into production in Jan 2023 |
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.
| |||||||||||
11 | Business Logic: Not pushing in-scope data | SITS Integration - Multiple error records for the same student ID |
|
|
|
| Tip |
|---|
Testing completed- Deployment into production in Jan 2023 |
17
SITS integration - Removal of PO type address error
SITS/Mulesoft
| |||||||||||
12 | Address Interface Fix | Corrupted : Address - International addresses corrupted by Non-English characters, or foreign keyboard. |
|
|
|
|
| colour | Red |
|---|---|
| title | NEW TRIAGE |
18
SITS Integration - Multiple error records for the same student ID
| |||||||||||
13 | Address Interface Fix | Corrupted : City Absent-Missing Integration data : 1. City / Suburb 2. Country. Push data without : Country / City / Suburb. |
|
|
|
|
| colour | Red |
|---|---|
| title | NEW TRIAGE |
19
| ||
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
| ||||||||||||
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.
| ||||||||||
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 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
| |||||||||
|
| This cannot be verified until the next batch runs first week of 2023. Changed due date to next year. | ||||||||
|
|
| ||||||||
|
| |||||||||
|
| |||||||||
|
| Done. Current logic provided by Manpreet Sidhu on
| ||||||||
|
| |||||||||
|
| |||||||||
|
| Early new year meeting | ||||||||