Sierra Leone CMS — end-to-end functional flow

flowchart LR
  subgraph Recruit["1 · Recruit"]
    ENQ[Application centre
ac_enquiry]
  end
  subgraph Admit["2 · Admit"]
    AC[Application centre
ac_application*]
    REG1[Registry
offer letters]
  end
  subgraph Enrol["3 · Enrol"]
    REG2[Registry
r_student / programme]
    SET[Setting
terms / fees / structures]
  end
  subgraph Study["4 · Study"]
    ACAD[Academic
timetable / results]
  end
  subgraph Money["5 · Finance"]
    FIN[Finance
invoice / pay / assist]
  end
  subgraph Life["6 · Student life"]
    SA[Student affairs
visa / insurance]
  end
  subgraph Close["7 · Close / report"]
    REP[Reports]
    MAIL[cmssupport email]
  end

  ENQ --> AC
  AC --> REG1
  REG1 --> REG2
  SET --> REG2
  REG2 --> ACAD
  REG2 --> FIN
  REG2 --> SA
  ACAD --> REP
  FIN --> REP
  REG1 -.-> MAIL
  FIN -.-> MAIL
          

mindmap
  root((Sierra Leone CMS
CMS-ICA))
    Academic
      registry
      academic
      setting
    Admissions
      applicationcenter
      lettertemplate
    Commercial
      finance
      assist_loans
    Student_life
      studentaffair
    Platform
      reports
      help
      zemail
          

flowchart TD
  A[Enquiry
ac_enquiry] --> B[Application
ac_application]
  B --> C[Course application
ac_courseapplication]
  C --> D[Eligibility / docs
ac_courseeligibility · confirmation]
  D --> E[Registry offer
r_stdofferletter · RTF templates]
  E --> F[r_student + r_stdprogram
+ r_stdsemester]
  F --> G[Academic structure
f_program / f_structure]
  F --> H[Finance fee plan
b_feestructure]
          

flowchart LR
  T[Term / structure
f_term · f_structure*] --> M[Module enrolment
r_stdmodule]
  M --> TT[Timetable
f_timetable*]
  TT --> ATT[Attendance
f_stdattendance]
  M --> MARK[Assessment
f_stdassessment*]
  MARK --> RR[Release results
f_releaseresult*]
  RR --> GPA[GPA / CGPA SPs]
  GPA --> TR[Transcripts / BOE reports]
          

flowchart TD
  FEE[Fee catalog / setting] --> INV[Invoices
b_invoice]
  INV --> PAY[Payments / details
b_payment*]
  PAY --> STMT[Statement views]
  INV --> ASSIST[Assist programmes
b_stdassistprog / sem]
  ASSIST --> SCH[b_calcsch SP]
  INV --> LOAN[Student loans / refunds]
  FEE -.-> MOD[b_calcmodule SP]
          

sequenceDiagram
  participant Desk as Staff desk / letter
  participant Mail as email.php / zemail
  participant Support as cmssupport.limkokwing.net

  Desk->>Mail: Compose outbound message
  Mail->>Support: POST /support/emailserverapi.php
  Mail->>Support: POST /support/pushsupport.php
  Support-->>Mail: Response body
  Mail-->>Desk: Success / failure
          

erDiagram
  r_student {
    int SIdx PK
    int StudentID UK
    string StudentNo
    string PortalActive
  }
  r_stdpersonal {
    int StudentID PK
  }
  r_stdprogram {
    int StdProgramID PK
    int SIdx FK
    int ProgramID FK
    int FeeStructureID FK
  }
  r_stdsemester {
    int StdSemesterID PK
    int StdProgramID FK
    int TermID FK
    float GPA
    float CGPA
  }
  r_stdmodule {
    int StdModuleID PK
    int StdSemesterID FK
    int ModuleID FK
    string FinalGrade
  }
  f_program {
    int ProgramID PK
    string ProgramCode
  }
  r_student ||--|| r_stdpersonal : StudentID
  r_student ||--o{ r_stdprogram : SIdx
  r_stdprogram ||--o{ r_stdsemester : StdProgramID
  r_stdsemester ||--o{ r_stdmodule : StdSemesterID
  r_stdprogram }o--|| f_program : ProgramID
          

erDiagram
  ac_enquiry {
    int EnquiryID PK
  }
  ac_application {
    int ApplicationID PK
    string ApplicantName
    string ICPassportNo
  }
  ac_courseapplication {
    int CourseApplicationID PK
    int ApplicationID FK
    int ProgramID FK
    int SIdx FK
  }
  r_stdofferletter {
    int StudentID FK
  }
  r_student {
    int SIdx PK
    int StudentID UK
  }
  ac_enquiry ||--o| ac_application : may_become
  ac_application ||--o{ ac_courseapplication : ApplicationID
  ac_courseapplication ||--o| r_student : SIdx
  r_student ||--o{ r_stdofferletter : StudentID
          

erDiagram
  r_stdprogram {
    int StdProgramID PK
    int FeeStructureID FK
  }
  b_feestructure {
    int FeeStructureID PK
    int ProgramID FK
  }
  b_invoice {
    int InvoiceID PK
    int SIdx FK
  }
  b_payment {
    int PaymentID PK
    int SIdx FK
    float Amount
  }
  b_stdassistprog {
    int AssistProgID PK
    int StdProgramID FK
    int AssistProviderID FK
  }
  b_stdassistsem {
    int AssistProgID FK
    int StdSemesterID FK
  }
  r_stdprogram }o--|| b_feestructure : FeeStructureID
  r_stdprogram ||--o{ b_stdassistprog : StdProgramID
  b_stdassistprog ||--o{ b_stdassistsem : AssistProgID
  b_invoice ||--o{ b_payment : applied_to
          

erDiagram
  r_student {
    int SIdx PK
  }
  r_stdpassport {
    int StdPassportID PK
    int SIdx FK
  }
  sa_studentvisa {
    int StudentVisaID PK
    int StdPassportID FK
  }
  sa_insurance {
    int StdInsuranceID PK
    int SIdx FK
  }
  sa_insuranceclaim {
    int InsuranceClaimID PK
    int StdInsuranceID FK
  }
  r_student ||--o{ r_stdpassport : SIdx
  r_stdpassport ||--o{ sa_studentvisa : StdPassportID
  r_student ||--o{ sa_insurance : SIdx
  sa_insurance ||--o{ sa_insuranceclaim : StdInsuranceID
          

flowchart TB
  APPLICANT([Applicant / enquirer])
  STAFF([Registry · Academic · Finance · Affairs])
  SUPPORT([cmssupport.limkokwing.net])
  CMS[["Sierra Leone CMS
PHPMaker desks + ems_sierraleone"]]

  APPLICANT -->|enquiry / application| CMS
  STAFF -->|operational writes| CMS
  CMS -->|letters / statements| APPLICANT
  CMS -->|email / push| SUPPORT
          

flowchart LR
  EXT([Applicant]) --> AC[Application centre]
  AC --> APP[(ac_application*)]
  APP --> REG[Registry desk]
  REG --> OFF[(r_stdofferletter)]
  REG --> STU[(r_student / r_stdprogram)]
  STU --> ACAD[Academic structures]
  STU --> FIN[Finance fee plan]
          

flowchart LR
  SET[Setting / Academic
term · structure] --> ENR[(r_stdmodule)]
  ENR --> TT[Timetable / attendance]
  ENR --> ASS[Assessment marks]
  ASS --> RES[(results / GPA)]
  RES --> REP[Reports / BOE]
          

flowchart TB
  STU[(r_student / SIdx)] --> FIN[Finance desk]
  FIN --> LED[(b_invoice / b_payment / b_assist*)]
  LED --> VIEW[[statement* views]]
  FIN --> SP[["b_calcmodule / b_calcsch"]]
  SP --> LED
          

flowchart LR
  BATCH[[sleonebatch
empty in package]] -.-> DB[(ems_sierraleone)]
  PORT[[portal/*.sql.gz
ops extracts]] -.-> DB
  DB -.-> EXT([Future Portal API / M5])
          

flowchart TB
  subgraph SL["ICA Sierra Leone CMS"]
    AC[Application centre]
    REG[Registry]
    ACAD[Academic]
    FIN[Finance]
    SA[Student affairs]
    REP[Reports]
    DB[("ems_sierraleone")]
    AC --> DB
    REG --> DB
    ACAD --> DB
    FIN --> DB
    SA --> DB
    REP --> 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 -.->|"campus-keyed CAP-53"| DB
  end
          

flowchart TB
  FAMILY["LUCT / ICA EMS family
PHPMaker · r_/f_/b_"]
  CYB["Cyberjaya
cmscbj · ADR-1 SoR"]
  BWA["Botswana
cmsbotswana · DTEF"]
  SLE["Sierra Leone
ems_sierraleone · CMS-ICA"]
  RAISD["Raisd portals
Portal API · CAP-53"]

  FAMILY --> CYB
  FAMILY --> BWA
  FAMILY --> SLE
  CYB -->|launch ACL| RAISD
  BWA -.->|M5 expansion| RAISD
  SLE -.->|M5 expansion| RAISD