Skip to content

Archived Brief

This brief has been completed and is retained as a build record.

B-PATH-01 — Pathway Assembler: Landing Page Teaser + Workspace Feature

SURFACE: rtopacks.com.au (main Next.js app) — new section on homepage + new workspace tool
DO NOT TOUCH: trust.rtopacks.com.au · mcp.rtopacks.com.au · api.rtopacks.com.au
Cloudflare Account ID: e5a9830215a8d88961dc6c80a8c7442a
Database: rtopacks-db (D1: 334ac8fb-9850-48c0-9da0-b56c55640e98)

The Insight (read this first)

We ran the query against the live database. The data confirms a powerful pattern:

If an RTO holds a higher qualification on scope, they almost certainly already deliver the core units of the qualifications below it in the same stream — because the higher qual builds on them.

Real data from rtopacks-db:

Interior Design (MSF training package): - Advanced Diploma of Interior Design (MSF60122) has 16 core units - 11 of those 16 core units also appear in the Diploma of Interior Design (MSF50222) - That's 69% overlap — an RTO delivering the Adv Diploma already covers the entire Diploma core - Diploma → Cert IV overlap: 4 of 10 core units (40%)

Community Services (CHC training package): - Diploma of Community Services (CHC52025) has 12 core units - 8 of those appear in Cert IV in Community Services (CHC42021) — 67% overlap - Cert IV → Cert III overlap: 5 of 7 core units (71% — nearly the entire Cert III core)

The commercial implication: An RTO with the Diploma of Community Services on scope could formally add Certificate IV and Certificate III with minimal new resource development. They're already delivering most of the core units. The gap is administrative (ASQA registration) not capability.

RTOpacks can identify this automatically. No other tool does this.

Part 1 — Landing Page Teaser

A new section on the homepage, below the hero/search area. Purpose: show the insight, create the "oh wow" moment, require sign-in to see the full analysis.

Visual design

A pathway stack — a real example using live data. Show the Interior Design stream or Community Services stream as a worked example.

Layout concept: 

┌─────────────────────────────────────────────────────┐
│  YOUR SCOPE MIGHT BE BIGGER THAN YOU THINK          │
│                                                     │
│  If you deliver this:                               │
│  ┌─────────────────────────────────────── L6 ──┐   │
│  │ Advanced Diploma of Interior Design         │   │
│  │ MSF60122 · 16 core units                    │   │
│  └─────────────────────────────────────────────┘   │
│                                                     │
│  You already cover most of these:                   │
│  ┌─────────────────────────────────── L5 · 69% ─┐  │
│  │ Diploma of Interior Design                   │  │
│  │ 11 of 10 core units already on scope  ████░  │  │
│  └──────────────────────────────────────────────┘  │
│  ┌─────────────────────────────────── L4 · 40% ─┐  │
│  │ Certificate IV in Interior Decoration        │  │
│  │ 4 of 7 core units already on scope    ███░░  │  │
│  └──────────────────────────────────────────────┘  │
│                                                     │
│  [Sign in to run this analysis on your scope →]     │
└─────────────────────────────────────────────────────┘

The progress bars are the visual hook — colour-coded by overlap percentage: - 60%+ → green - 30–59% → amber
- Under 30% → grey (still shown, just less exciting)

The CTA: "Sign in to run this analysis on your scope →" - This is the DDR-04 gate — RTO verified users only - Non-verified users see the teaser but the CTA takes them to the sign-up/verification flow

Data source for teaser

Use the Interior Design stream hardcoded for the landing page teaser — it's the cleanest example and the data is confirmed. No live query needed on the homepage, just static display of real data.

Three qualifications in the stack: - MSF60122 · Advanced Diploma of Interior Design · L6 · 16 core units (anchor) - MSF50222 · Diploma of Interior Design · L5 · 11/10 core overlap · 69% - MSF40122 · Certificate IV in Interior Decoration · L4 · 4/7 core overlap · 40%

Part 2 — Workspace Feature (Pathway Assembler)

Available to RTO-verified users only (DDR-04 Lane 1). Lives inside the workspace.

What it does

  1. User inputs one qualification code (or selects from their scope)
  2. System finds all qualifications in the same training package stream at adjacent AQF levels
  3. Runs the core unit overlap query for each pair
  4. Returns a pathway stack showing:
  5. Each qualification in the stream
  6. AQF level
  7. Core unit overlap % against the anchor qualification
  8. How many new core units would be needed to formally offer each lower qualification
  9. Visual progress bar

The query pattern (confirmed working)

-- Find qualifications in the same stream (same training_package_code prefix)
SELECT qual_code, title, qualification_level
FROM qualifications
WHERE training_package_code = ?
AND status = 'Current'
ORDER BY qualification_level;

-- Core unit overlap between two qualifications
SELECT COUNT(*) as overlap
FROM qualification_units a
JOIN qualification_units b ON a.unit_code = b.unit_code
WHERE a.qualification_code = ? AND a.role = 'core'
AND b.qualification_code = ?;

Output format

For each qualification in the stream below the anchor:

Qualification title          AQF Level    Core overlap    Gap units
Diploma of Interior Design      L5           69%              0 new
Cert IV in Interior Decoration  L4           40%              3 new

"Gap units" = core units in the lower qual NOT already in the anchor. These are the ones an RTO would need to add to scope to formally offer that qualification.

Gap unit detail

When the user clicks a qualification in the stack, expand to show: - Units already covered (green) — already on scope via the anchor qual - Gap units (amber) — need to be added to scope

This is the actionable output. An RTO looking at this knows exactly what they'd need to submit to ASQA to expand their registration.

Scope integration (Phase 2 — not this brief)

Eventually the Pathway Assembler will take the RTO's actual scope (from ASQA National Register via the RTO verification flow) and run against real registered qualifications. For now, user manually inputs the anchor qualification code.

API endpoint

New endpoint on api.rtopacks.com.au:

GET /v1/pathway?anchor={qual_code}

Returns: 

{
  "anchor": {
    "code": "MSF60122",
    "title": "Advanced Diploma of Interior Design",
    "level": "Advanced Diploma",
    "core_units": 16
  },
  "pathway": [
    {
      "code": "MSF50222",
      "title": "Diploma of Interior Design", 
      "level": "Diploma",
      "core_total": 10,
      "overlap": 11,
      "overlap_pct": 69,
      "gap_units": 0,
      "gap_unit_codes": []
    },
    {
      "code": "MSF40122",
      "title": "Certificate IV in Interior Decoration",
      "level": "Certificate IV",
      "core_total": 7,
      "overlap": 4,
      "overlap_pct": 40,
      "gap_units": 3,
      "gap_unit_codes": ["CUAACD311", "CUAACD313", "MSFID4012"]
    }
  ]
}

OPS SURFACE RULE: ops stub for /v1/pathway must be deployed at ops.rtopacks.com.au at the same time.

Acceptance Criteria

Landing page teaser: - [ ] New section visible on homepage below hero - [ ] Shows Interior Design pathway stack with real data (hardcoded) - [ ] Progress bars colour-coded by overlap % - [ ] CTA routes to sign-in/verification flow - [ ] Mobile responsive

Workspace feature: - [ ] Pathway Assembler accessible to RTO-verified users - [ ] Accepts qualification code input - [ ] Returns pathway stack for same training package - [ ] Shows overlap % and gap unit count per qualification - [ ] Click to expand shows covered vs gap units - [ ] Handles training packages with no clear ladder gracefully (e.g. "No pathway found in this stream")

API: - [ ] GET /v1/pathway?anchor={qual_code} live on api.rtopacks.com.au - [ ] Ops stub deployed on ops.rtopacks.com.au

Drip rule: Confirm deployed before next brief drops.