{"type":"doc","content":[{"type":"paragraph"},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"user ","type":"text"},{"text":"mule_svc ","type":"text","marks":[{"type":"strong"}]},{"text":"is used in the intergration","type":"text"}]}]},{"type":"table","attrs":{"layout":"wide","localId":"4dfdee9d-8bb0-4240-84da-b7910a0a89b5"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[100.0]},"content":[{"type":"paragraph","content":[{"text":"Source","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[332.0]},"content":[{"type":"paragraph","content":[{"text":"Purpose","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[388.0]},"content":[{"type":"paragraph","content":[{"text":"Scenarios","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[100.0]},"content":[{"type":"paragraph","content":[{"text":"SITS","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[332.0]},"content":[{"type":"paragraph","content":[{"text":"sync ALumnis - From SITS to Salesforce","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[388.0]},"content":[{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"New Alumni - Create as per ","type":"text"},{"text":"mapping rules.","type":"text","marks":[{"type":"link","attrs":{"href":"https://teams.microsoft.com/l/file/819D8650-B2B7-4328-927A-96384D0E115B?tenantId=82b3e37e-8171-485d-b10b-38dae7ed14a8&fileType=docx&objectUrl=https%3A%2F%2Funisyd.sharepoint.com%2Fteams%2FProjectPhoenixImplementation-Technology_%2FShared%20Documents%2FTechnology_%2FSITS-AQ-interface-business-req.docx&baseUrl=https%3A%2F%2Funisyd.sharepoint.com%2Fteams%2FProjectPhoenixImplementation-Technology_&serviceName=teams&threadId=19:d2aa910c7add4209b6d1773390579c35@thread.tacv2&groupId=41fcd160-95ca-48c3-a5b4-aa65363527b5"}}]},{"type":"hardBreak"},{"text":"New record created on the following objects:","type":"text"},{"type":"hardBreak"},{"text":"> ","type":"text"},{"text":"Account","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"},{"text":"> ","type":"text"},{"text":"Contact","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"},{"text":"> ","type":"text"},{"text":"AQB__AlternateID__c","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"},{"text":"> ","type":"text"},{"text":"AQB__AQAddress__c","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"},{"text":"> ","type":"text"},{"text":"AQB__Education__c","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"},{"text":"> ","type":"text"},{"text":"AQB__AreaOfStudy__c","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Existing Alumni","type":"text"},{"type":"hardBreak"},{"text":"> update ","type":"text"},{"text":"Account ","type":"text","marks":[{"type":"strong"}]},{"text":"and ","type":"text"},{"text":"Contact ","type":"text","marks":[{"type":"strong"}]},{"text":"if SITS date is later than salesforce modified date","type":"text"},{"type":"hardBreak"},{"text":"> Upsert on other objects using external id","type":"text"},{"type":"hardBreak"},{"text":"> For ","type":"text"},{"text":"AQB__AQAddress__c ","type":"text","marks":[{"type":"strong"}]},{"text":"object upsert need to fetch the RecordTypeId for Email and Phone type from RecordType object.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Errors","type":"text"},{"type":"hardBreak"},{"text":"NON-ENGLISH-ADDRESS - if Address contains non English asci characters.","type":"text"},{"type":"hardBreak"},{"text":"NO-EDUCATION - if SITS doesn’t send any Education data","type":"text"},{"type":"hardBreak"},{"text":"POBOX-ADDRESS - if address starts with PO or P O or P.O strings (case insensitive)","type":"text"},{"type":"hardBreak"},{"text":"ERROR - All others. This could contain if any updates, creations failed or any other data quality issues.","type":"text"}]}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[100.0]},"content":[{"type":"paragraph","content":[{"text":"iModules","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[332.0]},"content":[{"type":"paragraph","content":[{"text":"Receive online donations","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[388.0]},"content":[{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Batch with more than 5 different transactions","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Donor is matched","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"iModule id in alternate id.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"donor firstname and lastName and email","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"alternate channel using email","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"found check for bioupdates (updates to biographical data) by comparing FirstName, LastName, Email and Postcode fields between iModules and Salesforce.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"create a new batch in AQB__Batch__c","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"create transactions on batch item","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"if Donor doesn’t exist - create new Lead","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"if BIO update are relevant - log it for manual verification.","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"below exceptions are logged for iModules integration.","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"BIO-UPDATE - It indicates one of the fields (FirstName, LastName, Email and Postcode) in iModules have changed","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph"}]}]}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[100.0]},"content":[{"type":"paragraph","content":[{"text":"Peoplesoft","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[332.0]},"content":[{"type":"paragraph","content":[{"text":"validate the COA in Peoplesoft","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"cc = transaction.USYD_Class_Code__c","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"rc = transaction.USYD_Responsibility_Centre__c","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"pc = transaction.USYD_Project_Code__c","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"ac = transaction.USYD_Analysis_Code__c","type":"text"}]}]}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"?xml version=\"1.0\"?>","type":"text"},{"type":"hardBreak"},{"text":"","type":"text","marks":[{"type":"link","attrs":{"href":"#"}}]},{"type":"hardBreak"},{"text":" ","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"},{"type":"hardBreak"},{"text":" UNSYD","type":"text"},{"type":"hardBreak"},{"text":" ACTUALS","type":"text"},{"type":"hardBreak"},{"text":" 2022-10-14","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"},{"type":"hardBreak"},{"text":" <","type":"text"},{"text":"syd:Classification","type":"text","marks":[{"type":"strong"}]},{"text":"/>","type":"text"},{"type":"hardBreak"},{"text":" <","type":"text"},{"text":"syd:ResponsibilityCentre","type":"text","marks":[{"type":"strong"}]},{"text":">61006","type":"text"},{"type":"hardBreak"},{"text":" <","type":"text"},{"text":"syd:AnalysisCode","type":"text","marks":[{"type":"strong"}]},{"text":"/>","type":"text"},{"type":"hardBreak"},{"text":" <","type":"text"},{"text":"syd:Project","type":"text","marks":[{"type":"strong"}]},{"text":">00000","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"},{"type":"hardBreak"},{"text":"","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[388.0]},"content":[{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"validate a Batch with valid COA","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"validate a Batch with invalid COA data","type":"text"}]}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[100.0]},"content":[{"type":"paragraph","content":[{"text":"Swift","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[332.0]},"content":[{"type":"paragraph","content":[{"text":"Bio update and unsubscibes","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[388.0]},"content":[{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Unsubscribe a contact","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"},{"text":"find contact in campaign and populate the stop date","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Bio Update is working as expected:","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error log","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"contact not found","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Reactivated","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error","type":"text"}]}]}]}]}]}]}]}]},{"type":"paragraph"},{"type":"paragraph"},{"type":"paragraph"}],"version":1}

Browser not supported