Sarcha LMIS — Production Edition 1.0

Connect to Sarcha LMIS

Secure connection: Enter your Supabase Project URL and publishable/anon key. Never enter a service-role key or secret key. This application uses Supabase authentication and database Row Level Security.

Supabase Project URL

Supabase publishable / anon key

Business email

Password

Not connected.

Connection URL and public key are kept in this browser session only. Your password is not saved by this application. Supabase manages the authenticated session.

Signed in Administrator

Connected to Supabase

Administrator session active. Document management is enabled for controlled fictional-file testing only. Do not upload real learner documents until operational sign-off.

Registered learners

Programmes

Enrolments

Assessments

Welcome to Sarcha LMIS

Manage learner registration, training programmes, enrolments, attendance, assessments, moderation and learner document references from one system.

The dashboard displays live counts from the structured Supabase tables. QCTO submissions are not transmitted automatically; exported data must be checked against the applicable QCTO data-load specification before submission.

Recent learners

No learner records loaded.

Register learner

Learner register

Loading learners…

Add programme

Programme register

Loading programmes…

Create enrolment

Enrolment register

Loading enrolments…

Capture attendance

Attendance register

Loading attendance…

Capture assessment

Assessment register

Loading assessments…

Capture moderation

Moderation register

Loading moderation…

Secure learner document management

Private storage is configured for controlled testing. This module uses the existing private bucket lmis-assessment-evidence and metadata table lmis_documents. Administrator access is enforced by Supabase policies.

Controlled test release: upload fictional/test files only until the end-to-end test, backup/restore process and POPIA operational controls have been signed off. Maximum file size: 10 MB. Accepted formats: PDF, DOC, DOCX, JPG, JPEG and PNG.

Checking document storage…

Secure document register

Loading document metadata…

Reports and data exports

Export current structured records to CSV for internal administration. These exports are not certified QCTO submission files; map and validate them against the current QCTO specification before submission.

Statement of Results preparation

A learner Statement of Results should only be generated after the programme's registered curriculum, module names, credits, assessment outcomes and required approvals have been checked. A local SOR print template will be added after the QCTO-specific layout and rules are confirmed. Do not treat this system export as an official QCTO certificate.

Audit activity

Loading audit records…

Administrator database access setup

Run this SQL once in Supabase SQL Editor. It grants authenticated users with an active Administrator profile access to the seven operational tables. Audit records can be read and inserted by the Administrator, but not updated or deleted through the API.

The application checks your signed-in profile in lmis_user_profiles. Access is also enforced by PostgreSQL RLS. Do not grant broad anonymous access. Later staff roles require additional role-specific policies.

Production readiness notes

Administrator-only policies are the first access layer; additional roles are not yet enabled.
Private assessment-evidence bucket and Administrator-only Storage policies are configured; controlled upload/retrieval testing is required.
Automated learner numbering, duplicate-ID controls, audit triggers and database validation are next hardening tasks.
CSV exports are internal exports, not automatic QCTO submissions.
Test with fictional data until access controls, backup/restore and POPIA procedures are verified.