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 SITS BAU Production Defects
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
No | Type | Description | Source Systems | 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) |
|
| 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 |
|
| 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.
| SITS/Mulesoft |
|
| 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
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 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 :
| SITS/Mulesoft
|
| 10
| Update | 10 |
| Manpreet Sidhu , 4 | Address Interface Fix | SITS integration - Removal of PO type address error | SITS/Mulesoft||||||||||||||||||
7 | Business Logic | Integration Logic |
| 886
| 4
|
|
| ||||||||||||||||||||||
8 | Education Reference Table | Increase area of study field to 100 characters | SITS/Mulesoft
| 15
|
| 3 | Business Logic: Not pushing in-scope data | SITS Integration - Alumni Records in SITs but not in Jarvis/Salesforce | SITS/MulesoftAQ 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 |
| 4 |
| ||||||||||||||||||||||||
11 | Business Logic: Not pushing in-scope data | SITS Integration - Multiple error records for the same student IDSITS/Mulesoft |
|
|
| 8 | 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 | 9 |
| |||||||||||||||||
12 | Address Interface Fix | Corrupted : Address | SITS/Mulesoft | - International addresses corrupted by Non-English characters, or foreign keyboard. |
|
|
| ||||||||||||||||||||||
| 10 |
| |||||||||||||||||||||||||||
13 | Address Interface Fix | Corrupted : City Absent-Missing Integration data : 1. City / Suburb 2. Country. Push data without : Country / City / Suburb. | SITS/Mulesoft |
|
|
| 11 | 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 | 12 | Address Interface Fix | SITS Integration- Address is being marked incorrectly as English Address. | SITS/Mulesoft
| |||||||||||||||
14 | Business Logic: Not pushing in-scope data | SITS Integration - Alumni Records in SITs but not in Jarvis/Salesforce |
| satparkash.kaushik / Tested by Manpreet Sidhu |
| 14
|
|
| |||||||||||||||||||||
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.
| SITS/Mulesoft | 16 | 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 :
| SF |
| satparkash.kaushik / |
| |||||||||||||||||||
17 | 18 | Education Reference Table | Education Object : Duplicate Education records captured. ie duplicate education ID’s | SITS/Mulesoft | |||||||||||||||||||||||||
1819 | 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 | SITS/Mulesoft | 19 | 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 |
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 | ||||||||