Botswana CMS — end-to-end functional flow

flowchart LR
  subgraph Recruit["1 · Recruit"]
    MKT[Marketing
app_* / agents]
    CDU[CDU / AQA
entry rules]
  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]
    STU[Student desk
self-service]
  end
  subgraph Money["5 · Finance"]
    BUR[Bursary
invoice / pay / assist]
    DTEF[DTEF queue
r_scholarshipapp]
    TEF[tef.gov.bw]
  end
  subgraph Life["6 · Student life"]
    SVC[Services
visa / welfare]
    ACC[Accommodation]
    LIB[Library]
  end
  subgraph Close["7 · Close / report"]
    REP[Reporting]
    BATCH[botsbatch]
  end

  MKT --> APP
  CDU -.-> APP
  APP --> REG1
  REG1 --> REG2
  SET --> REG2
  FAC1 --> REG2
  REG2 --> FAC2
  FAC2 --> LEC
  FAC2 --> STU
  REG2 --> BUR
  BUR --> DTEF
  DTEF -->|status 31 POST| TEF
  REG2 --> SVC
  REG2 --> ACC
  REG2 --> LIB
  FAC2 --> REP
  BUR --> REP
  BATCH -.-> REP
          

mindmap
  root((Botswana CMS
BWA-GBE))
    Academic
      registry
      faculty
      lecturer
      cdu
      training
    Student life
      services
      accommodation
      library
      notice
      student
    Commercial
      bursary
      marketing
      DTEF_TEF_sync
    Platform
      setup
      reporting
      botsbatch
      portal_api_hooks
          

flowchart TD
  A[Marketing / online app
app_applicationform*] --> B[Docs / eligibility
app_docfile · letters]
  B --> C[Registry offer
r_stdofferletter* · FetchOfferLetters]
  C --> D[Confirm registration
confirmReg SP]
  D --> E[r_student + r_stdprogram
+ r_stdsemester]
  E --> F[Faculty structure
f_program / bots_program*]
  E --> G[Bursary fee plan]
          

flowchart LR
  T[Term / structure
f_term · bots_structuresemester*] --> M[Module enrolment
r_stdmodule]
  M --> TT[Timetable
GetTimetable]
  TT --> ATT[Attendance]
  M --> MARK[Lecturer marks]
  MARK --> RR[Release results
f_releaseresult*]
  RR --> TR[Transcripts / BOE views]
          

flowchart TD
  FEE[Fee catalog / setup] --> INV[Invoices / instalments
b_*]
  INV --> PAY[Payments / receipts]
  PAY --> STMT[Statements / ageing views]
  INV --> ASSIST[Assist programmes
b_stdassistprog / sem]
  ASSIST --> DSCH[dtef_scholarship view
AssistProviderCode=DTEF]
  ASSIST --> GSTAT[getSCholarshipStatus fn]
  REGQ[Registry r_scholarshipapp] -->|status 31| TEF[tef.gov.bw]
  TEF -.->|34/35 outcomes| REGQ
          

sequenceDiagram
  actor Reg as Registry officer
  participant Edit as Scholarship edit
  participant DB as r_scholarshipapp
  participant TEF as tef.gov.bw

  Reg->>Edit: Edit row · set status 31 · Save
  Edit->>TEF: GET /rest/session/token
  TEF-->>Edit: CSRF token
  Edit->>TEF: POST /api/post/studentadmissions
(HAL+JSON program_of_study)
  alt success or duplicate admission
    Edit->>DB: app_status=32 · remark=SUCCESS!
  else API / curl error
    Edit->>DB: app_status=33 · remark=error
    Edit-->>Reg: Alert — contact support
  end
  Note over DB,TEF: 34 Approved / 35 Rejected
recorded later (outcome path)
          

flowchart LR
  subgraph Registry["Registry"]
    L1[Active list]
    L2[Dropout list]
    E[Edit · status 31]
    L1 --> E
    L2 --> E
  end
  subgraph Store["cmsbotswana"]
    T[(r_scholarshipapp)]
    A[(b_stdassistprog / sem)]
    V[[dtef_scholarship]]
  end
  subgraph Gov["Government"]
    TEF[tef.gov.bw]
    DTEF[DTEF financing]
  end
  E -->|POST program_of_study| TEF
  E -->|UPDATE 32/33| T
  TEF -.->|34/35| T
  A --> V
  T -.->|ID overlap| A
  DTEF -.-> TEF
          

erDiagram
  r_student {
    int StudentID PK
    string StudentNo
    string LoginActive
  }
  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
  }
  bots_program {
    int ProgramID FK
  }
  r_student ||--|| r_stdpersonal : StudentID
  r_student ||--o{ r_stdprogram : StudentID
  r_stdprogram ||--o{ r_stdsemester : StdProgramID
  r_stdsemester ||--o{ r_stdmodule : StdSemesterID
  r_stdprogram }o--|| bots_program : Botswana_mirror
          

erDiagram
  app_applicationform {
    int ApplicationID PK
  }
  app_docfile {
    int ApplicationID FK
  }
  app_eligibilityletter {
    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_eligibilityletter : ApplicationID
  app_applicationform ||--o| r_stdofferletter : ApplicationID
  r_student ||--o{ r_stdofferletter : StudentID
          

erDiagram
  r_student {
    int StudentID PK
    string StudentNo
  }
  r_stdprogram {
    int StdProgramID PK
    int StudentID FK
  }
  b_stdassistprog {
    int AssistProgID PK
    int StdProgramID FK
    int AssistProviderID FK
  }
  b_stdassistsem {
    int AssistProgID FK
    int StdSemesterID FK
  }
  r_assistprovider {
    int AssistProviderID PK
    string AssistProviderCode
  }
  r_scholarshipapp {
    int schctr PK
    int applicationid
    string IDNumber
    string app_status
    double programCost
  }
  r_student ||--o{ r_stdprogram : StudentID
  r_stdprogram ||--o{ b_stdassistprog : StdProgramID
  b_stdassistprog ||--o{ b_stdassistsem : AssistProgID
  r_assistprovider ||--o{ b_stdassistprog : AssistProviderID
  r_student ||--o{ r_scholarshipapp : "IDNumber=StudentNo"
          

erDiagram
  r_student {
    int StudentID PK
  }
  acc_dorm {
    int DormID PK
  }
  acc_occupant {
    int OccupantID PK
    int StudentID FK
  }
  w_visa {
    int StudentID FK
  }
  w_insurance {
    int StudentID FK
  }
  portal_r_student_botswana {
    int StudentID FK
  }
  r_student ||--o{ acc_occupant : StudentID
  acc_dorm ||--o{ acc_occupant : houses
  r_student ||--o{ w_visa : StudentID
  r_student ||--o{ w_insurance : StudentID
  r_student ||--o| portal_r_student_botswana : sync
          

flowchart TB
  APPLICANT([Applicant / agent])
  STUDENT([Student])
  LECTURER([Lecturer])
  STAFF([Registry · Faculty · Bursary · Services])
  TEF([tef.gov.bw / DTEF])
  CMS[["Botswana CMS
PHPMaker desks + cmsbotswana"]]

  APPLICANT -->|application / docs| CMS
  STAFF -->|operational writes| CMS
  STUDENT -->|self-service reads / confirms| CMS
  LECTURER -->|marks / attendance| CMS
  CMS -->|invoices / letters / portal data| STUDENT
  CMS -->|HAL+JSON admissions| TEF
  TEF -.->|approval outcomes 34/35| CMS
          

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 · bots_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_payment / receipt / assist*)]
  LED --> VIEW[[dtef_scholarship view]]
  STU --> REG[Registry scholarship desks]
  REG --> QUEUE[(r_scholarshipapp)]
  QUEUE -->|status 31 POST| TEF([tef.gov.bw])
  TEF -.->|34/35| QUEUE
  BATCH[[botsbatch SQL]] -.-> LED
  BATCH -.-> STU
          

flowchart LR
  BATCH[[botsbatch
portal · registry · bursary · exam]] --> DB[(cmsbotswana)]
  DB --> API[["api_student_* / api_faculty_*"]]
  DB --> PORT[(portal_*_botswana)]
  API -.-> EXT([Future Portal API / M5])
  PORT -.-> EXT
          

flowchart TB
  subgraph BW["LUCT Botswana CMS"]
    DESKS[Registry · Faculty · Bursary · Marketing
Lecturer · Services · Accommodation · Setup · Reporting]
    DB[("cmsbotswana")]
    DESKS --> DB
    DESKS -.->|DTEF POST| TEFext[tef.gov.bw]
  end
  subgraph Raisd["Raisd — M5+"]
    API[Portal API]
    AP[Applicant]
    SP[Student]
    LP[Lecturer]
    ST[Staff]
    AP --> API
    SP --> API
    LP --> API
    ST --> API
    API -.->|"campus-keyed"| DB
  end
          

flowchart LR
  subgraph Family["Same product family"]
    CYB["Cyberjaya
cmscbj · LUCT · app_*"]
    BWA["Botswana
cmsbotswana · LUCT · app_*"]
    SLE["Sierra Leone
ems_sierraleone · EMS · ac_*"]
  end
  CYB -->|closest sister| BWA
  CYB -.->|same EMS roots
different admissions prefix| SLE
  CYB ==>|ADR-1 launch SoR| LAUNCH([Raisd portals])
  BWA -.->|M5 expansion| LAUNCH
  SLE -.->|M5 expansion| LAUNCH
  BWA -->|TEF.gov.bw| GOV([DTEF government])