Skip to main content

WA Module Analysis: Work Abroad Reporting

1. Overview​

WA (Work Abroad) appears to be a specialized module, possibly for specific functional reporting.

Key Metrics​

  • Scope: WADataFeeder, WAYTDFeeder (Year To Date), WAGlobalKPI.
  • Complexity: Medium to High (Calculation heavy).
  • Role: Reporting Engine. It calculates KPIs, Turnovers, and Enrollments.

2. Architectural Archeology​

2.1 Embedded BI (Business Intelligence)​

The module is full of "Feeders" (WAYTDFeeder.cs - 36KB) and "ReportHandlers".

  • Anti-Pattern: Hardcoded Analytics.
  • Issue: Calculating "Year To Date Turnover" in C# Code within the transactional monolith is resource-intensive and inflexible.
  • Performance Risk: Running these reports might lock tables used by OMTG/CRM.

2.2 "Feeder" Pattern​

It seems to use a "Feeder" pattern to pre-calculate or aggregate data.

  • Observation: WADataFeederBiz.
  • Pros: improved Read performance if results are stored.
  • Cons: Complexity of keeping aggregates in sync.

3. Evolution Strategy​

Step 1: Extract to BI Tool​

Move this logic to Zoho Analytics (as per Strategic Pivot).

  • Action: Use SQL Views or an ETL process to push raw data to a Data Warehouse. Let the BI tool handle YTD calculations.

Step 2: Read-Only Replica​

If this logic MUST stay in code, ensure it runs against a Read-Only Database Replica to avoid locking the transactional DB.