Timeline
| Roadmap Planner | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Integration Business Requirements
Date | System | Documents | Comments | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| SITS |
| Original SITS/Jarvis Interface Business Requirements | ||||||||
| SWIFT Update your Details |
| |||||||||
| aLLAll | Integration Documentation |
Jarvis SITS BAU Production Defects
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
No | Type | Description | Source SystemsJira 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 addressesSalesforce (SF) |
|
| Salesforce will implement in Q1 2023 | |||||||||||||||||||||||||||
2 | Business Logic: | Not pushing in-scope dataBusiness 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/MulesoftOverwriting more recent Jarvis Data | Deceased - Account Object : mule_svc incorrectly = changing Account Status from Deceased to Active on Account only. Not changing Contact object. |
| 908
| 13
|
| Status | ||||
|---|---|---|---|---|
|
satparkash.kaushik / Tested by Manpreet Sidhu
| Tip |
|---|
Testing completed- Deployment into production in Jan 2023 |
3
Business Logic:
SITS Integration - Alumni Records in SITs but not in Jarvis/Salesforce
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
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
4
Business Logic: Not pushing in-scope data
SITS Integration - Multiple error records for the same student ID
|
satparkash.kaushik / Tested by Manpreet Sidhu
| Tip |
|---|
Logic defined and approved - implementation Jan 2023 |
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
| Jira Legacy | |||||
|---|---|---|---|---|---|
|
|
| Status | ||||
|---|---|---|---|---|
|
5
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
Tested by Manpreet Sidhu
| Tip |
|---|
Testing completed- Deployment into production in Jan 2023 |
5
Error Report Logic
SITS Integration- Address is being marked incorrectly as Non English Address.
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
|
satparkash.kaushik / Tested by Manpreet Sidhu
| Tip |
|---|
Testing completed- Deployment into production in Jan 2023 |
7
Business Logic: 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)
| Jira Legacy | |||||
|---|---|---|---|---|---|
|
|
| Tip |
|---|
Swathi Inapakolla updated Jarvis AoS Picklist |
7
Business Logic
Integration Logic
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
|
9
Address Interface Fix
Corrupted : Address
| Tip |
|---|
Logic defined and approved - implementation Jan 2023
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
8
Education Reference Table
Increase area of study field to 100 characters
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
AQ Ticket #4715
| Note |
|---|
AQ Ticket raised #4715. Await AQ Fix and deployment. |
9
Error Report Logic
SITS integration - Removal of PO type address error message
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
|
| Status | ||||
|---|---|---|---|---|
|
10
Address Interface Fix
Corrupted : City
Absent-Missing Integration data : 1. City / Suburb 2. Country. Push data without : Country / City / Suburb.
| Tip |
|---|
SITS integration - Removal of PO type address error update - TAP-886 |
10
Address Enhancement
Update Address Type for PO Box addresses to Postal Address
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
- TAP-1355 Set backlog refining session with Sat for Integration tickets, Prabhu Kannan ,
11
Business Logic: Not pushing in-scope data
SITS Integration - Multiple error records for the same student ID
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
| Status | ||||
|---|---|---|---|---|
|
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.
- TAP-108 Multiple error records for the same student ID - Make sure the ticket details are there + Ticket status = ‘04 Refine’ pat.dennis ,
- TAP-108 Set backlog refining session with Sat for Integration tickets, Prabhu Kannan ,
12
Address Interface Fix
SITS Integration- Address is being marked incorrectly as English Address.
SITS/MulesoftCorrupted : Address - International addresses corrupted by Non-English characters, or foreign keyboard.
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
satparkash.kaushik / Tested by Manpreet Sidhu
- TAP-109 SITS Integration: Corrupted Address - Make sure the ticket details are there + Ticket status = ‘04 Refine’, pat.dennis ,
- TAP-109 Set backlog refining session with Sat for Integration tickets, Prabhu Kannan ,
13
Address Interface Fix
SITS integration - Removal of PO type address error
SITS/Mulesoft
Corrupted : City
Absent-Missing Integration data : 1. City / Suburb 2. Country. Push data without : Country / City / Suburb.
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
- TAP-110 SITS Integration: Corrupted City - Make sure the ticket details are there + Ticket status
| colour | Red |
|---|---|
| title | NEW TRIAGE |
- = ‘04 Refine’, pat.dennis ,
- TAP-110 Set backlog refining session with Sat for Integration tickets, Prabhu Kannan ,
14
Business Logic: Not pushing in-scope data
SITS Integration - Alumni Records in SITs but not in Jarvis/Salesforce
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
- TAP-305 Alumni Records in SITs but not in Jarvis/Salesforce - Reconciliation, Manpreet Sidhu ,
15
Address Enhancement
Country Codes in SITS are different to Google API country codes used in SF, i.e. China vs …SITS/Mulesoft
| Status | ||||
|---|---|---|---|---|
|
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
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
Address preference.
Phone Preference.
Email Preference
Result in :
Blank : Mailing Address type
Blank : Address Preference
SF
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
satparkash.kaushik /
Tested by Manpreet Sidhu
| Tip |
|---|
Testing completed- Deployment into production in Jan 2023 |
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
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
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 | ||||||||