Architecture review — LUCT CMS / Portal compatibility

1. Keep the canonical academic model clean — do not copy the legacy schema.
2. Upgrade CAP-53 from “CMS database adapter” to a documented anti-corruption / integration layer.
3. Make historical academic state immutable/auditable and calculations reproducible.
4. Explicitly model statuses, curriculum versions, repeats, transfers, exemptions, and credit/CGPA rules — do not hide them in SQL.
5. One authoritative owner per domain; cross-system operations must be idempotent, recoverable, and reconcilable.
6. Assume legacy data is imperfect — detect and expose inconsistencies rather than silently guessing.

flowchart TB
  subgraph Portals
    ST[Student]
    LE[Lecturer]
    SF[Staff]
    AP[Applicant]
  end

  API[Portal API]

  subgraph Domains
    AC[Academic domain]
    FI[Finance domain]
    AD[Admissions domain]
  end

  CAN[(Canonical domain model)]
  PG[(Postgres owned data)]

  subgraph ACL["CMS Anti-Corruption Layer CAP-53"]
    MAP[Mapping]
    VAL[Validation]
    OPS[Operations]
  end

  CMS[(Existing CMS SoR)]

  ST --> API
  LE --> API
  SF --> API
  AP --> API
  API --> AC
  API --> FI
  API --> AD
  AC --> CAN
  FI --> CAN
  AD --> CAN
  CAN --> PG
  CAN --> ACL
  MAP --> CMS
  VAL --> CMS
  OPS --> CMS
          

flowchart TB
  SP[StudentProfile] --> PE[ProgrammeEnrolment]
  PE --> PV[ProgrammeVersion]
  PV --> CM[CurriculumModules]
  PE --> STU[StudyPeriod]
  STU --> MR[ModuleRegistration]
  MR --> RES[ModuleResult]

  MOD[Module] --> MO[ModuleOffering]
  MO --> CAM[Campus]
  MO --> AT[AcademicTerm]
  MO --> TA[TeachingAssignment]

  PV --> APS[AcademicProgressService]
  CM --> APS
  MR --> APS
  RES --> APS
  APS --> TR[TermResult / Progress snapshots]
  TR --> PUB[ResultPublication]
  PUB --> TX[Transcript presentation]
          

flowchart LR
  P[Programme] --> PV[ProgrammeVersion]
  PV --> PCO[ProgrammeCampusOffering]
  PCO --> B[Botswana]
  PCO --> U[Uganda]
  PCO --> S[Sierra Leone]
          

Valid example: Grade PASS · Credits earned 3 · CGPA points 0 · Included in CGPA false.

Also support: normal, repeat, exemption, credit transfer, pass/fail, audit/non-credit, replacement, additional elective, transferred programme credit — via registration type + result flags, not ad-hoc SQL.

Named queries: isCurrentlyEnrolled(), isAcademicallyActive(), hasCurrentStudyPeriod(), isRegisteredForModules(), hasActiveImmigrationStatus(), isEligibleForStudentPortal(). Every report must state which definition it uses. Demo draft of the cohort definition and open Registry questions: canonical schema confirmations (CS-01–CS-03; Schema v3 policy Demo seeded).

flowchart LR
  P[PENDING] --> PR[PROCESSING]
  PR --> C[CMS_COMMITTED]
  C --> F[FINANCE_PENDING]
  F --> OK[COMPLETED]
  PR --> FAIL[FAILED]
  C --> REC[REQUIRES_RECONCILIATION]
  F --> REC