Purpose
What SOQ actually sells today -> what the TMS must own. Full requirements: 4.1 Attachment A .
SOQ product lines (from live site + PEI)
Line Examples Mode / pattern Business diplomas Intl Business Development / Management (+ Mandarin) Blended - ~208 hrs - 6 mo Beauty diplomas Beauty Specialist (SOQ-DBS) - Make Up - Lash - SMPU - Aromatherapy (+ ZH) Blended - 192–224 hrs - 6–8 mo - instalments (“From $499.77/mo”) Care diplomas Maternal, Newborn & Infant Care (+ Mandarin) Blended - ~252 hrs iTEC / VTCT Holistic Massage - Fashion/Theatre/Media Make-up (+ Express/ZH) Classroom / blended - international cert WSQ / Gen AI short Integrated Digital Marketing with Gen AI (TGS-2023041023) - Campaign Mgmt with Gen AI Classroom - 16 hrs - funded nets - SFC Workshops Brand Management - Product Demo - Meridian/Bojin - Dementia Care - … 1–12 sessions - classroom
Rules that must live in TMS (not brochure copy): >=75% attendance for subsidy - GST separate - diploma instalments - Mandarin = separate SKU - max completion windows (e.g. Beauty Specialist 18 mo ) - no Student Pass / Work Pass learners only where stated.
Today’s stack (replace / integrate)
Piece Live clue TMS action Marketing site Laravel - soq.edu.sg - /course/{slug} Public catalogue + SEO import Student / enrol TrainingSystemSG TMS - /TMS/program/{id}P0 cutover Schedules Google Drive PDFs on course pages Native course runs Leads Web form + WhatsApp + (Privyr — confirm) CRM Finance Xero (CRD) - PayNow/NETS/cards/SFC (FAQ) Orders in TMS -> Xero GL Funding rail SWDA ATP UEN 201723514D Hub — APIs confirm in discovery
Application boundary
App SOQ job Public + Registration Catalogue filters - course detail (Overview/Cert/Trainer/FAQ) - enquiry - Enroll - funded fee estimate Admin Workspace Programmes - IP rooms - runs - admissions - Student 360 - attendance - orders - SWDA ops Student Portal Replace TrainingSystemSG login — timetable - check-in - assessments - pay - certs Trainer Portal Roster - mark attendance/assessment - fee claims - bios from /trainer/* SWDA Hub Grant / attendance / completion / SFC payloads (entitlements TBD) Xero adapter Invoices - payments - credit notes
Data ownership
Domain SoR Pricing - subsidy lines - orders TMS Enrolment - attendance - assessment evidence TMS Enquiry -> offer -> enrolment history TMS (CRM pre-enrol)Invoices - payments - GL Xero Gov grant / claim payloads SWDA hub
Related