Session 26 Final
⏱ TIME MACHINE UCCA / UCCO Build Session Handover 20 March 2026 — Session 26 (FINAL)
"The data moat is now deep. The gate is open. Monday the letter goes."
1. Session 26 Summary¶
The biggest strategic session yet. No single brief dominated — instead this session built the institutional foundations that make everything else defensible: government engagement, data governance, policy alignment, and the full VOCSTATS data layer mapped and briefed. Six briefs shipped or ready to drop. Three strategic documents written. Two government registrations completed. One DEWR letter drafted and sitting in drafts.
rtopacks.com.au now has: - Auth gate live (magic link, users table, sessions in KV) - 7,845 of 8,007 quals with ANZSCO codes (98% coverage) - Employment tab data wiring complete (IVI, projections, OSL) - Transport & Logistics video pipeline started (15 clips ingested) - Trust surface fully rebuilt — AU entity throughout, PO Box added, Industry Linkages page drafted - B-AUTH-01, B-DETAIL-05, B-DETAIL-06, B-ENRICH-02, B-ENRICH-03 all confirmed deployed
2. Context — Where We Are¶
Product: RTOpacks.com.au is the primary commercial priority. Qual detail page (/qual/[code]/) is the main product surface. The HUD is genuinely differentiated — instrument panel aesthetic, JSA data live, auth gate working.
The Monday gate: DEWR email goes out Monday. Gate condition: auth live ✅, rtopacks looking solid ✅, trust surface rebuilt ✅. The email and PDF attachment are formatted and sitting in drafts at admin@ucca.com.au.
Personas: - Tim — Founder/CEO/architect. Brisbane. Pace = AI Advisor. - Alex — Developer. Full-auto terminal mode. One brief at a time. - Jimmy — NYC. Director/Treasurer UCCO Foundation. MCP Dev Summit NYC April 2–3.
3. Standing Rules — ALL UNCHANGED¶
- BRIEF DRIP RULE: one brief to Alex at a time
- Every brief must declare: SURFACE, DO NOT TOUCH, Cloudflare account ID
- OPS-AS-OS RULE: every deployed Worker/API must have ops stub
- Two Cloudflare accounts must never be crossed (UCCA e5a9830215a8d88961dc6c80a8c7442a vs UCCO aed3398a4e698767328cc3a9e698721d)
- HONEST INSTRUMENT RULE: no theatre for its own sake
- PREFERS-REDUCED-MOTION: all animations must respect this
- VNDA ATTRIBUTION: every Recon Panel view must show VNDA attribution
- CC BY-ND: TGA content verbatim, no derivatives
4. DB State — rtopacks-db (334ac8fb-9850-48c0-9da0-b56c55640e98)¶
| Table | Rows | Notes |
|---|---|---|
| qualifications | 8,007 | 1,167 current; 7,845 with ANZSCO |
| units | 75,189 | Full elements, PC, KE, AE |
| qualification_units | 244,874 | Core/elective mapped |
| osl_ratings | 9,454 | Shortage occupation list |
| ivi_vacancies | 37,908 | Monthly by ANZSCO × state |
| emp_projections | 358 | To 2035 |
| recon_vnda | 494 | Graduate outcomes |
| vnda_atlas | 785 | Deviation scores |
| glmd_regional | 96 | Regional labour market |
| users | 1 | Auth table live (test user) |
| magic_tokens | 1 | Magic link auth working |
| video_clips | 15 | Transport & Logistics theme — 01 only |
| video_themes | 31 | Package → theme_slug mapping |
| subscribers | 0 | Legacy email capture — superseded by users |
New tables needed (B-ENRICH-04 onwards): - vocstats_enrolments - vocstats_completions - vocstats_outcomes - vocstats_apprentices - vocstats_vis_enrolments
5. Brief Queue — Current State¶
| Brief | Status | Notes |
|---|---|---|
| B-DETAIL-05 | ✅ Deployed | HUD polish — text centering, cycle toggle, Z3 height, unit drawer, MCP badge |
| B-DETAIL-06 | ✅ Deployed | Layout restructure — Zone 1 expansion, line-in-sand, responsive |
| B-ENRICH-02 | ✅ Deployed | IVI vacancies + employment projections |
| B-ENRICH-03 | ✅ Deployed | ANZSCO bulk ingest — 7,845 quals covered |
| B-AUTH-01 | ✅ Deployed | Magic link auth, /auth page, /account stub, KV sessions |
| Video Pipeline 01 | 🔄 In progress | Transport & Logistics — 15 clips ingested, dissolve wiring in progress |
| B-ENRICH-04 | 📋 Ready to drop | VOCSTATS TVA enrolments — brief written, API key confirmed |
| B-ENRICH-04bcde | 📋 Ready after 04 | All remaining VOCSTATS collections |
| Trust surface rebuild | ✅ Deployed | Entity cleanup, PO Box, Industry Linkages page |
| B-DETAIL-07 | 📋 Queued | Mobile polish micro-fixes (description collapse) |
| B-ENRICH-05 | 📋 Queued | Plain speak enrichment — 2,805 quals missing descriptions |
| B-VIDEO-01 | 📋 Waiting | Portrait video wire — waiting on Tim reviewing 01 Transport visuals live |
| B-DETAIL-08 | 📋 Future | Display VOCSTATS data on qual page Employment tab |
6. Auth System — Current State¶
Live at rtopacks.com.au/auth
- Users table:
id, email, created_at, last_login, source - Magic tokens:
token, user_id, expires_at, used(15 min TTL) - Sessions: Cloudflare KV namespace
RTOPACKS_SESSIONS(30 day TTL) - Cookie:
rtopacks_sessionHttpOnly Secure SameSite=Lax - Email provider: Resend (same as keys.ucca.online)
- /account: post-login dashboard stub — shows welcome message + scope analysis teaser (locked)
- Homepage CTA wired → /auth
- Qual page Sign up journey circle wired → /auth
7. Video Pipeline — Current State¶
Architecture:
- video_themes table: maps training_package_code → theme_slug → video_url (legacy, stays)
- video_clips table: NEW — theme_slug, video_url_wide, video_url_tall, duration_seconds, active
- Dissolve logic: duration - 2.5s trigger, 2.5s crossfade, random next clip selection
- Media CDN: media.rtopacks.com.au/videos/
- Naming convention: rtopacks-{theme-slug}-{orientation}-{sequence}.mp4
Theme 01 (Transport & Logistics) in progress. Tim reviewing visuals before buying other 9 themes.
10 themes total: 01 Transport and Logistics (TLI, MAR) 02 Education and Training (TAE, BSB general) 03 Agriculture and Environment (ACM, AHC, AMP, SFI) 04 Health and Care (CHC, HLT) 05 Tourism and Hospitality (AVI, SIT) 06 Construction and Trades (CPC, MEM, MSM, UEE) 07 Technology and Automotive (AUR, ICT, MEA) 08 Creative Arts (CUA, MSF, MST) 09 Resources and Infrastructure (CPP, FBP, RGR, RII, SIS) 10 Business and Finance (BSB, FNS, PSP)
Source: Envato Elements. Processing SOP at VIDEO-PIPELINE-SOP.md. Shell folders created at ~/Downloads/ by Alex.
8. VOCSTATS — Full Picture¶
Account: RignoldT / RignoldT at vocstats.ncver.edu.au
API: SuperWEB2 Open Data REST API — https://vocstats.ncver.edu.au/webapi/rest/v1/
API key: In 1Password as "VOCSTATS API Key — RignoldT" / Cloudflare secret VOCSTATS_API_KEY
Five collections accessible: 1. Total VET students and courses (TVA) — enrolments, completions, subject enrolments 2015–2024 2. Government-funded students and courses — funded activity only 3. Student outcomes — employment, further study, satisfaction survey 4. Apprentices and trainees — quarterly training contracts by ANZSCO 5. VET in Schools — secondary school VET 2006–2024 ← strategic priority, nobody has this wired commercially
Reference docs written this session:
- VOCSTATS-Data-Architecture.md — internal knowledge base
- VET-in-Schools-Strategic-Note.md — Tim-only strategic note
- RTOpacks-Data-Currency-Policy.md — public-facing, goes on trust surface
9. Government Registrations — Session 26¶
VDS Developer Portal (NCVER): Registered March 2026 - Entity: United Central Colleges of Australia Pty Ltd - Type: Other (not SMS vendor, not RTO) - Email: admin@ucca.com.au - Credentials land within 5 business days
NTR Modernised Webservices Working Group (DEWR): Email drafted - To: NTRReform@dewr.gov.au - Status: Sitting in drafts — send Monday - Attachment: UCCA-NTR-Reform-Profile.pdf (A4, ready)
10. Monday Send — DEWR Letter¶
Condition: rtopacks.com.au auth live + polished ✅
Action: Send email from admin@ucca.com.au to NTRReform@dewr.gov.au
Attachment: UCCA-NTR-Reform-Profile.pdf
Also Monday: Resubmit AWS Activate credits (account 485098663204) — website now live, previous rejection reason gone
11. Entity & Address — Canonical¶
AU entity (all public-facing): United Central Colleges of Australia Pty Ltd ABN 59 168 872 535 PO Box 5377, Stafford Heights QLD 4053 ucca.com.au / admin@ucca.com.au
US entity (internal use, UCCA Inc infrastructure only): UCCA Inc (DBA: Universal Capability Certification Authority) 1207 Delaware Ave #1678, Wilmington DE 19806 EIN 84-4522608 · USPTO Reg. No. 7,619,705
Entity cleanup completed this session — all trust docs, legal pages, security.txt updated to AU entity. Internal Workers/ops console still reference UCCA Inc correctly as the US legal entity — do not change those.
12. Documents Produced This Session¶
All in /mnt/user-data/outputs/:
| File | Purpose |
|---|---|
| B-DETAIL-05.md | ✅ Deployed |
| B-DETAIL-06.md | ✅ Deployed |
| B-AUTH-01.md | ✅ Deployed |
| B-ENRICH-03.md | ✅ Deployed |
| B-ENRICH-04.md | 📋 Ready to drop |
| B-ENRICH-04bcde.md | 📋 Ready after 04 |
| VIDEO-PIPELINE-SOP.md | Reference for Alex |
| RTOpacks-Video-Shopping-Guide.pdf | Tim — Envato purchasing guide |
| UCCA-NTR-Reform-Profile.md + .pdf | DEWR letter attachment |
| trust-industry-linkages.md | Drop into MkDocs trust surface |
| VOCSTATS-Data-Architecture.md | Internal knowledge base |
| VET-in-Schools-Strategic-Note.md | Tim — strategic reference |
| RTOpacks-Data-Currency-Policy.md | New trust surface page |
13. Pending Decisions / Tim Queue¶
- MONDAY: Send DEWR email + attachment
- MONDAY: Resubmit AWS Activate (account 485098663204)
- Video review: Check Transport & Logistics clips live on rtopacks.com.au/qual/TLI41222 — approve before buying remaining 9 themes
- Envato: Buy remaining 9 themes once 01 approved. Shopping guide in downloads.
- Domain renewals: ucca.com.au + ucca.asia — Tim confirmed lodged ✅
- Apple Developer: Distribution cert still shows dead entity name — low priority remediation
- GitHub org: ucca-inc — reserve before public repos go live
- Search Console: Submit rtopacks.com.au sitemap.xml — 30 seconds, still pending
- VOCSTATS API key: Store in 1Password as "VOCSTATS API Key — RignoldT" if not done
14. Context Window Note for Next Claude¶
Session 26. Tim calls Claude 'Pace'. High trust, high velocity. No time alerts ever. Direct, fast, dry humour. Austin Powers/Goldmember references are a running in-joke. 'Shmoke and a pancake' = reset button.
Design philosophy (established Session 25, carried forward): - The HUD is an instrument panel, not a webpage - Every element has state — the HUD narrates itself through motion - Beauty is load-bearing — the design respects the weight of what it's showing - HONEST INSTRUMENT RULE: if it doesn't earn its place on the HUD, it doesn't ship
This session's additions: - We are not a mirror — we are a licensed downstream consumer of public government data - Every data element shows its vintage — the source period, not our ingest date - The L3 account dashboard is the audit trail — data sources panel shows provenance for every element - VET in Schools is the niche moat — 18 years of data, nobody has it wired commercially
CONTEXT WINDOW MONITORING: every 10 messages check length. YELLOW = start handover prep. RED = write Time Machine immediately.
UCCA Inc · Session 26 (FINAL) · 20 March 2026 · "The data moat is now deep. The gate is open. Monday the letter goes."