IoL Workflows
Capture to Score
Institute of Learning · MBRU · Reference architecture, 2 September 2026

Capture to Score

The concept in one sentence: a learner's placement becomes a Ministry data point because the form that approved it would not save without the fields the KPI needs. Nothing is reported afterwards. The work leaves evidence as it happens, one data model holds it, flows route and remind, and the score is a query.

1. The mechanism, traced through one placement

Figure 1 follows a single event, a learner starting a clinical placement under WF-13, from the moment it happens to the moment it appears on the Ministry's OBEF dashboard. Every other workflow uses the same five layers.

WORKCAPTURE GATEDATAAUTOMATIONOUTPUT A learner starts a placement at a Dubai Health site WF-13 step 4 · Placement Coordinator allocates the learner Also true for: an event booked (WF-23), a project registered (WF-15), an impact observed (WF-19), a contract signed (AW-23), a purchase received (AW-10) opens the form Model-driven Power App · Placement form Business rules block Save until the KPI fields exist. This is the whole idea. Supervisor · required In study plan · required Organisation · lookup No free text for the site: the lookup matches an alias to the canonical record, so the 12-month employer match (KPI 3.1) is possible later. writes one row, audited PlacementEpisode type · dates · credits actual hours · completion Internship_* columns Personsupervisor, learner Programme Organisationpartner type · aliases Agreement lookup EvidenceItem points to SharePoint site agreement · sign-off Purview retention label Files live in libraries. Tables hold data. The row holds the link. completion status changes F9 · on completion issues the EmployerWork-placement Survey linkwith the Placement IDpre-filled; chases at 7, 14 d Microsoft Forms the supervisor is outsideMBRU, so Forms is righthere and nowhere elsein this trace F10 · on response writes raw per-question rowsto SupervisorEvaluation withissue and collection dates.Appendix B can demand them. F12 · monthlyexpected vs captured F14 · on demandCHEDS export Flows route,remind, compute,export. Theynever decide whata human owns. Power BI · OBEF prospective, KPI 3.2 Placement participation 0507090100 95% registered · top anchor 100 · evidence readiness 100% Students - Internship.xlsxplus OBF Self Report 3.2 HEDB / Master APIMoHESR OBEF Dashboard3.2 · 2.3 · 3.1 · 3.3 published result reconciled KPI by KPI against the internal figure (WF-26)
Figure 1. One placement, five layers. The blue box is the only place the concept lives: a form that refuses to save without the KPI fields turns capture into a gate instead of a request. Everything below it is plumbing that follows from the row existing.
Dataverse and the app that writes to itOutside MBRU: Forms for people who cannot log inScore outputsFile, not data

2. Which door the data comes through

The mistake to avoid is a Microsoft Form for everything. The route is decided by who is typing and what they are referring to, not by convenience.

Who enters it, and what does it refer to? apply to every data element in every workflow's data section MBRU staff · refers to a recordoutsider or anonymousa central system holds itit is a file App form model-driven, lookups enforced Mobile app canvas, QR-launched, two minutes placement · project · event · agreement impact unit · credential · document event sign-in · supervised hours Microsoft Forms pre-filled ID links the answer to a row Forms, restricted table anonymity when required employer survey · course evaluation event feedback · alumni census complaint · grievance · disclosure Dataflow Power Query on a schedule into staging, then upsert the diff between runs is a trigger SIS enrolment · HR establishment finance ledger · IT access never a stored file SharePoint library metadata columns, Purview label Dataverse row holds the link retention and legal hold live here certificate · MoU · attendance sheet valuation · audit report marked assessment Two more routes without a branch: reference vocabularies load once from the HEDB dictionary as choice sets or lookup tables;an existing spreadsheet register is imported once, then archived under AW-04.
Figure 2. Four doors. Forms is the door for people who cannot log in, which is why it sits on one branch and not four.

3. What makes a workflow start

Fifty-one documented triggers fall into four classes. Only one class is cheap to automate fully, and it is not the class where points are lost.

CLASS ASystem event enrolment created · HR joinerpurchase order · invoice matched detected bydataflow diff, nightly (F11) firesa task on the owner automatableyes, where MBRU IT grants extracts CLASS BCalendar review due · renewal · expiry12 months post-graduation · 3-year cohort detected byone TriggerCalendar table, read daily (F1) firestask, reminder, chase at intervals automatablefully, in a day. Build this first. CLASS CUpstream hand-off study plan approved → map itin-kind received → value it detected byrow status change (F6, F7, F8) firestask on the receiving workflow automatableyes; the 65 one-sided hand-offs live here CLASS DHuman-observed an impact occurred · an event happeneda partner contributed · a licence obtained detected bysomeone noticing managed bythe gate (Figure 1) and the mobile app,plus a monthly completeness nudge (F12) automatableno. This is where OBEF points die.
Figure 3. Classes A to C are engineering. Class D is design: the only defence is a form faster than not filling it in, and a number on the operational dashboard that makes non-capture visible and owned.

4. Where it lives, and who can see what

IoL-Devbuild here IoL-Testowners try it exportimport IoL-Prod · solution iol_ · never edited directly 22 tablescanonical model · HEDB choice setsauditing on every table Security rolesOwner · Steward · ContributorRead only · Quality and Audit Column security (AW-16) graduate and former-staff contact data · complaint and grievance content contract values · and the whole accessibility table, in its own role, never as columns on Person SharePoint · Purview Controlled Documents library (AW-03)Evidence library (AW-04, Appendix B)versioning · approval · retention labels Microsoft Formsoutside the boundary; reaches a tableonly through a flow, never directly Four checks with MBRU ITbefore the first table: licence (full Dataverse, not for Teams)environment ownership and CoE policyDLP connector groupingdata residency
Figure 4. One solution moves Dev to Test to Prod; nothing is built in the tenant default environment. Forms is drawn outside the boundary on purpose.

5. Three pictures of the same data

Dataverserow-level securitymirrors the roles Operational · monthly · ownerscapture completeness as the hero number OBEF prospective · semester · governancebullet charts vs anchors, per KPI per programme Governance · quarterly · management reviewaudit and CAPA ageing, risk, document control KpiAnchor tablethe scoring assumption, one edit Ministry resultpublished OBEF dashboard reconciled KPI by KPI after every refresh; unexplained variance is a WF-26 exception
Figure 5. Three audiences, three cadences. A dashboard that shows IoL a better number than the Ministry shows MBRU is a disagreement to resolve, not a picture to display.

6. What the design refuses to do

Sources: Architecture/00_Visualisation_and_Data_Architecture.md, 01_M365_Solution_Design.md, 02_Dataverse_Schema.xlsx. OBEF anchors from the University Guide v11.5, Appendix A; the band-to-score mapping is an assumption until MoHESR publishes it.