Eswatini CMS — end-to-end functional flow

flowchart LR
  subgraph Recruit["1 · Recruit"]
    MKT[Marketing
app_*]
    CDU[CDU / AQA]
  end
  subgraph Admit["2 · Admit"]
    REG1[Registry
offer letters]
    APP[Online / staff
application]
  end
  subgraph Enrol["3 · Enrol"]
    REG2[Registry
r_student / programme]
    FAC1[Faculty
structure / modules]
    SET[Setup
terms / fees]
  end
  subgraph Study["4 · Study"]
    FAC2[Faculty
timetable / results]
    LEC[Lecturer
marks / attendance]
  end
  subgraph Money["5 · Finance"]
    BUR[Bursary
invoice / pay / assist]
    ASSIST[ssb · limkokwing
b_assistbilling*]
  end
  subgraph Life["6 · Student life"]
    SVC[Services
visa / welfare]
    ACC[Accommodation
w_occupant / w_room]
  end
  subgraph Close["7 · Close / report"]
    REP[Reporting]
    BATCH[eswatinibatch]
  end

  MKT --> APP
  CDU -.-> APP
  APP --> REG1
  REG1 --> REG2
  SET --> REG2
  FAC1 --> REG2
  REG2 --> FAC2
  FAC2 --> LEC
  REG2 --> BUR
  BUR --> ASSIST
  REG2 --> SVC
  REG2 --> ACC
  FAC2 --> REP
  BUR --> REP
  BATCH -.-> REP
          

mindmap
  root((Eswatini CMS
campus2_eswatini))
    Academic
      registry
      faculty
      lecturer
      cdu
      modulemat
    Student_life
      services
      accommodation
      notice
    Commercial
      bursary
      marketing
      assist_ssb_limkokwing
    Platform
      setup
      reporting
      eswatinibatch
      api_service
      AdBeConnect
      portal_api_hooks
          

flowchart TD
  A[Marketing / online app
app_applicationform*] --> B[Docs / education
app_docfile · app_applicationeducation]
  B --> C[Registry offer
r_stdofferletter · FetchOfferLetters]
  C --> D[Confirm / enrol SPs
OnlineRegNotification]
  D --> E[r_student + r_stdprogram
+ r_stdsemester]
  E --> F[Faculty structure
f_program / gb_*]
  E --> G[Bursary fee plan]
          

flowchart LR
  T[Term / structure
setup · faculty] --> M[Module enrolment
r_stdmodule]
  M --> TT[Timetable / IH]
  TT --> ATT[Attendance
r_stdattendance · ih_*]
  M --> MARK[Lecturer marks]
  MARK --> RR[Results / transcripts]
  RR --> TR[Reporting / BOE]
          

flowchart TD
  FEE[Fee catalog / setup] --> INV[Invoices / billing
b_*]
  INV --> PAY[Payments / receipts]
  PAY --> STMT[Statement views]
  INV --> ASSIST[Assist programmes
r_assistscheme* · b_assistbilling*]
  ASSIST --> CODE[Provider codes
ssb · limkokwing]
  FEE -.-> UPD[b_Update_billing / b_Update_Student]
          

flowchart LR
  subgraph Assist["Assist / CAP-48 adjacent"]
    PROV[r_assistprovider]
    SCH[r_assistscheme*]
    BILL[b_assistbilling*]
    PROV --> SCH --> BILL
    CODE[["codes: ssb · limkokwing"]]
    PROV -.-> CODE
  end
  subgraph Portal["Portal projection"]
    API[["api_student_* · api_faculty_*"]]
    PT[(portal_*_eswatini)]
    LEG[(portal_student_swaziland)]
  end
  subgraph Batch["Night batch"]
    SH[swazilandbatchnight.sh]
    SQL[portal · registry · bursary
examination · billing SQL]
    SH --> SQL
  end
  DB[(campus2_eswatini)]
  BILL --> DB
  API --> DB
  PT --> DB
  LEG --> DB
  SQL --> DB
          

erDiagram
  r_student {
    int StudentID PK
    string StudentNo
  }
  r_stdpersonal {
    int StudentID PK
  }
  r_stdprogram {
    int StdProgramID PK
    int StudentID FK
    int ProgramID FK
  }
  r_stdsemester {
    int StdSemesterID PK
    int StdProgramID FK
    int TermID FK
  }
  r_stdmodule {
    int StdModuleID PK
    int StdSemesterID FK
    int ModuleID FK
  }
  r_student ||--|| r_stdpersonal : StudentID
  r_student ||--o{ r_stdprogram : StudentID
  r_stdprogram ||--o{ r_stdsemester : StdProgramID
  r_stdsemester ||--o{ r_stdmodule : StdSemesterID
          

erDiagram
  app_applicationform {
    int ApplicationID PK
  }
  app_applicationform_online {
    int ApplicationID PK
  }
  app_docfile {
    int ApplicationID FK
  }
  app_applicationeducation {
    int ApplicationID FK
  }
  r_stdofferletter {
    int StudentID FK
    int ApplicationID FK
  }
  r_student {
    int StudentID PK
  }
  app_applicationform ||--o{ app_docfile : ApplicationID
  app_applicationform ||--o{ app_applicationeducation : ApplicationID
  app_applicationform ||--o| r_stdofferletter : ApplicationID
  app_applicationform_online ||--o| app_applicationform : may_promote
  r_student ||--o{ r_stdofferletter : StudentID
          

erDiagram
  r_student {
    int StudentID PK
  }
  r_stdprogram {
    int StdProgramID PK
    int StudentID FK
  }
  r_assistprovider {
    int AssistProviderID PK
    string AssistProviderCode
  }
  r_assistscheme {
    int AssistSchemeID PK
    int AssistProviderID FK
  }
  r_assistschemedetail {
    int AssistSchemeID FK
  }
  b_assistbilling {
    int AssistBillingID PK
    int StudentID FK
  }
  b_assistbillingdetail {
    int AssistBillingID FK
  }
  r_student ||--o{ r_stdprogram : StudentID
  r_assistprovider ||--o{ r_assistscheme : AssistProviderID
  r_assistscheme ||--o{ r_assistschemedetail : AssistSchemeID
  r_student ||--o{ b_assistbilling : StudentID
  b_assistbilling ||--o{ b_assistbillingdetail : AssistBillingID
          

erDiagram
  r_student {
    int StudentID PK
  }
  w_occupant {
    int OccupantID PK
    int StudentID FK
  }
  w_room {
    int RoomID PK
  }
  w_visa {
    int StudentID FK
  }
  w_insurance {
    int StudentID FK
  }
  portal_student_eswatini {
    int StudentID FK
  }
  portal_student_program_eswatini {
    int StudentID FK
  }
  portal_student_swaziland {
    int StudentID FK
  }
  r_student ||--o{ w_occupant : StudentID
  w_room ||--o{ w_occupant : houses
  r_student ||--o{ w_visa : StudentID
  r_student ||--o{ w_insurance : StudentID
  r_student ||--o| portal_student_eswatini : sync
  portal_student_eswatini ||--o{ portal_student_program_eswatini : programme
  r_student ||--o| portal_student_swaziland : legacy
          

flowchart TB
  APPLICANT([Applicant / agent])
  STUDENT([Student])
  LECTURER([Lecturer])
  STAFF([Registry · Faculty · Bursary · Services])
  CMS[["Eswatini CMS
PHPMaker desks + campus2_eswatini"]]

  APPLICANT -->|application / docs| CMS
  STAFF -->|operational writes| CMS
  STUDENT -->|portal reads via api_*| CMS
  LECTURER -->|marks / attendance| CMS
  CMS -->|invoices / letters / portal data| STUDENT
          

flowchart LR
  EXT([Applicant]) --> MKT[Marketing desk]
  MKT --> APP[(app_applicationform*)]
  APP --> REG[Registry desk]
  REG --> OFF[(r_stdofferletter)]
  REG --> STU[(r_student / r_stdprogram)]
  STU --> FAC[Faculty structures]
  STU --> BUR[Bursary fee plan]
          

flowchart LR
  SET[Setup / Faculty
term · structure] --> ENR[(r_stdmodule)]
  ENR --> TT[Timetable / attendance]
  ENR --> LEC[Lecturer marks]
  LEC --> RES[(results / transcript views)]
  RES --> REP[Reporting]
          

flowchart TB
  STU[(r_student)] --> BUR[Bursary desk]
  BUR --> LED[(b_* / b_assistbilling*)]
  LED --> PROV[[r_assistprovider
ssb · limkokwing]]
  BUR --> SP[["b_Update_billing / b_Update_Student"]]
  SP --> LED
          

flowchart LR
  BATCH[[eswatinibatch
portal · registry · bursary · exam · billing]] --> DB[(campus2_eswatini)]
  DB --> API[["api_student_* / api_faculty_*"]]
  DB --> PORT[(portal_*_eswatini)]
  DB --> LEG[(portal_student_swaziland)]
  API -.-> EXT([Future Portal API / M5])
  PORT -.-> EXT
  LEG -.-> EXT
          

flowchart TB
  subgraph SZ["LUCT Eswatini CMS"]
    DESKS[Marketing · Registry · Faculty · Bursary
Services · Accommodation · Setup · Reporting]
    DB[("campus2_eswatini")]
    DESKS --> DB
  end
  subgraph Raisd["Raisd — M5"]
    API[Portal API / ACL]
    AP[Applicant]
    SP[Student]
    LP[Lecturer]
    ST[Staff]
    AP --> API
    SP --> API
    LP --> API
    ST --> API
    API -.->|"CAP-53 · ESWATINI"| DB
  end
          

flowchart TB
  FAMILY["LUCT CMS / PHPMaker family
r_ · f_ · b_ · app_*"]
  CYB["Cyberjaya · cmscbj"]
  LSO["Lesotho · campus2_lesotho · M4"]
  BWA["Botswana · cmsbotswana · DTEF"]
  SZ["Eswatini · campus2_eswatini · M5"]
  KHM["Cambodia · ~481 tables"]
  SLE["Sierra Leone · EMS · ac_*"]
  RAISD["Raisd portals · CAP-53"]

  FAMILY --> CYB
  FAMILY --> LSO
  FAMILY --> BWA
  FAMILY --> SZ
  FAMILY --> KHM
  FAMILY -.-> SLE
  LSO ==>|M4 SoR| RAISD
  SZ -.->|M5 expansion| RAISD
  BWA -.->|M5| RAISD