Twill Brain

Data Insights

3 min read

Data Insights

Date: 2025-10-15 · Duration: 32.400001525878906 min Organizer: Nader Attendees: Nader, Ahmad, Mike, Martin

Summary

  • The MCA tracking system is advancing with integration of accurate merchant identification, critical for reliable data processing due to complexities with batch references outlined by Ahmadreza Abdoli and clarified by Michael Wright.
  • Lack of unique MID values in the merchant table is limiting end-to-end testing; EMS reports currently lack valid MIDs due to unboarded test merchants, necessitating manual data insertions.
  • Ongoing negotiations led by Michael Wright aim to enhance EMS data delivery by receiving comprehensive merchant payout information in containerized reports, improving data coverage.
  • A schema and design investigation is underway to determine how initial MCA data such as amounts and start dates will be stored, with a decision to create a separate log table for historical records reaffirmed.
  • Automation challenges persist with SF2P payout file uploads; the manual process is causing delays and lack of real-time data as highlighted by Michael Wright.
  • A design for the UI and backend for capturing MCA agreements is pending due to missing columns in the merchant table; current designs do not align with database needs as emphasized by Martin Elias Costa.
  • The approach of retaining historical MCA records in a separate log reinforces audit trails and supports financial accuracy as confirmed by Michael Wright.
  • Strategic interest in the MCA solution has increased, with potential partnerships noted by Michael Wright, pointing to a market gap in integrated tools that connect payment data.
  • A clarifying process is being initiated for ticket prioritization focused on investigations and design tasks, improving workflow efficiency as led by Nader Atrchin.
  • Regular

Action Items

  • Ahmadreza Abdoli Add GROUP BY batch reference in MCA script to handle batches containing multiple merchants and finalize pull request (03:15) Investigate and fix the document upload functionality bug preventing testing of address extraction from merchant documents (26:54) Review current merchant table columns and update Confluence with database schema changes and endpoint impacts related to MCA data storage (20:00)

Nader Atrchin Rename and update ticket to focus on investigation and design of MCA database schema and required API endpoint changes (19:22) Create bug report for document upload failure and move related tickets to bug status for prioritization (27:25) Prioritize ticketing and plan next steps for database and endpoint design related to MCA (30:30)

Martin Elias Costa Confirm that MID referenced in pay engine and EMS reports corresponds to the gateway MID and validate code logic on force updates accordingly (30:30) Assist Ahmadreza in documenting necessary schema changes on Confluence related to MCA data tracking (20:00)

Michael Wright Continue follow-up with EMS partners to automate payout report submissions and push for inclusion of all payout files, transaction reporting, and chargeback data for comprehensive view (12:19) Provide clarification on MID sources and merchant onboarding process for MCA reporting integration (06:00) Participate in upcoming call with MCA CRM system to demo platform and seek potential partnership or customer opportunity (22:15)

Graph View

Backlinks