The System of Trust · Beyond Healthcare

    Audit‑Grade Data Mapping for Regulated Industries

    The same append‑only, tamper‑evident ledger architecture engineered for HIPAA and 21 CFR Part 11 produces evidence in the shape SOX, GxP, GDPR, FedRAMP, and ISO 27001 reviewers already know how to read.

    SOX §404 / PCAOB AS 2201EU GMP Annex 11GDPR Art. 30 / 32FedRAMP / NIST SP 800‑53ISO/IEC 27001 Annex A

    One architecture, many narratives. Magellan's ledger doesn't ship a SOX module, a GxP module, and a GDPR module. It ships four primitives — append‑only ULID storage, a SHA‑256 hash chain, role‑at‑time‑of‑action, and two‑component e‑signatures — and each regulatory framework is a different vocabulary over the same evidence. That's why the same ledger row that satisfies HIPAA §164.312(b) also satisfies ISO 27001 A.12.4.2.

    The Four Pillars

    Same primitives, every framework

    Each pillar is a property of the data structure — not a process the application has to remember to follow, and not a checkbox tied to one regulator's wording.

    SHA‑256 Hash Chain

    • SOX §404 (ICFR — change integrity)
    • GxP · EU Annex 11 §9 (audit trail integrity)
    • ISO/IEC 27001 A.12.4.2 (log protection)

    Every ledger entry stores a SHA‑256 hash of the previous entry's content. Tampering with any historical row invalidates every hash from that row forward. ICFR walkthroughs, GxP data‑integrity reviews, and ISMS log‑protection controls all reduce to the same operation: re‑walk the chain, in O(n).

    ULID Audit Ledger

    • SOX §404 (point‑in‑time evidence)
    • GDPR Art. 30(1) (records of processing — temporal completeness)
    • FedRAMP AU‑11 (audit record retention)

    Every row is keyed by a ULID, not a UUID. The first 48 bits are a millisecond timestamp, so the primary key itself is the order. "Show me the ICFR control state on the last day of Q3" or "reconstruct the processing record at the time of the breach" becomes a primary‑key range scan — no separate timestamp index to keep honest under independent review.

    Role‑at‑Time‑of‑Action

    • SOX §404 (segregation of duties, retroactively provable)
    • GxP · EU Annex 11 §2 (personnel qualifications at the time)
    • GDPR Art. 32(4) (instructions of the controller)
    • FedRAMP AC‑5 (separation of duties)

    Each ledger entry records the actor's role at the moment of action — not just the role they hold today. If a contributor is later promoted to approver, last quarter's ledger still shows them acting as a contributor. Segregation‑of‑duties testing, GxP qualification checks, and processor‑instruction audits work against the role that was in effect, not the role that exists now.

    Two‑Component E‑Signatures

    • GxP · EU Annex 11 §14 (electronic signatures)
    • SOX §302 / §906 (officer attestation)
    • ISO/IEC 27001 A.12.1.2 (change management approval)
    • FedRAMP CM‑3 (configuration change control)

    Production releases require a Contributor's draft signature plus an Approver's release signature — and the two signers must be distinct identities. Quarterly attestations require a Compliance Officer signature. Both signatures are themselves ledger entries, which means SOX §302 sub‑certifications, GxP release approvals, and ISMS change‑advisory‑board sign‑offs all leave the same evidence shape.

    Live Demo

    Verify the chain in your browser

    Four sample ledger entries, hashed with SHA‑256 in the Web Crypto API. Toggle a row to tamper with its content and watch every downstream hash fail.

    Computing SHA‑256…

      Hashes computed with crypto.subtle.digest("SHA-256") · chain link = SHA‑256(ulid|ts|actor|role|action|prevHash)

      The Vocabulary Choice That Matters

      Predictive mapping vs. "AI‑powered"

      Why audit committees, control owners, and regulators respond to one of these phrases — and recoil from the other.

      CIO / CMIO Brief — Predictive vs. AI‑powered, in 80 seconds.

      Specificity

      "AI‑powered": Generic — applies to any product

      "Predictive mapping": Names the technique: candidate prediction over schemas

      Audit committee fatigue

      "AI‑powered": Triggers buzzword filtering

      "Predictive mapping": Reads as engineering vocabulary, not marketing

      Audit posture

      "AI‑powered": Suggests autonomous decisions

      "Predictive mapping": Implies proposals reviewed and signed by humans

      Segregation of duties

      "AI‑powered": Vendor implied accountable for the output

      "Predictive mapping": Named SME signs each mapping; SoD is explicit

      Regulator‑safe

      "AI‑powered": Triggers transparency questions

      "Predictive mapping": Aligns with predicate‑logic and human‑in‑the‑loop framing

      ICFR / GxP fit

      "AI‑powered": Implies model‑driven control execution

      "Predictive mapping": Frames AI as an upstream accelerator, not the control

      Magellan is a predictive mapping platform — the Semantic Match Engine proposes; named SMEs approve; the SHA‑256 ledger proves it.

      Multi‑Framework Crosswalk

      From clause to control, across five frameworks

      The shortest defense of any audit system: the evidence already exists in the form the auditor needs it — regardless of which auditor walks in.

      SOXSarbanes‑Oxley §404 / PCAOB AS 2201

      Internal control over financial reporting — change integrity

      Append‑only ULID ledger + SHA‑256 hash chain over every mapping change

      Download SOX brief (PDF)
      SOXPCAOB AS 2201 (entity‑level controls)

      Segregation of duties between preparer and approver

      Two‑component e‑signature: distinct Contributor and Approver identities, RBAC‑enforced

      Download SOX brief (PDF)
      GxPEU GMP Annex 11 §9

      Audit trails generated independently and protected from alteration

      Append‑only ULID ledger + SHA‑256 hash chain (verifier walks O(n) to detect any silent rewrite)

      Download GxP brief (PDF)
      GxPEU GMP Annex 11 §14 / FDA 21 CFR Part 11 §11.70

      Electronic signatures linked to their records

      Signatures are themselves ledger entries, hash‑chained to the record they sign

      Download GxP brief (PDF)
      GDPRGDPR Art. 30(1)

      Records of processing — categories, recipients, retention, transfers

      Schema, mapping target, and downstream system are first‑class ledger fields, primary‑key‑ordered by ULID

      Download GDPR brief (PDF)
      GDPRGDPR Art. 32(4)

      Demonstrate that processing follows controller instructions

      Role‑at‑time‑of‑action shows which controller‑authorized identity made each change

      Download GDPR brief (PDF)
      FedRAMPNIST SP 800‑53 CM‑3

      Configuration change control with approval workflow

      Contributor draft + distinct Approver release, both captured as signed ledger entries

      Download FedRAMP brief (PDF)
      FedRAMPNIST SP 800‑53 AU‑9 / AU‑11

      Audit record retention with integrity protection

      ULID‑keyed retention by date range; SHA‑256 chain detects any post‑hoc modification

      Download FedRAMP brief (PDF)
      ISO 27001ISO/IEC 27001 Annex A.12.4.2

      Logging facilities and log information protected against tampering

      SHA‑256 hash chain over append‑only ledger; tamper attempts are mathematically detectable

      Download ISO 27001 brief (PDF)
      ISO 27001ISO/IEC 27001 Annex A.12.1.2

      Change management approval evidence

      Two‑component e‑signature on every release, recorded as ledger entries

      Download ISO 27001 brief (PDF)

      The Auditor's View

      What a regulator actually sees

      The first three questions don't change much between an SOX walkthrough, a GxP inspection, and an ISO 27001 surveillance audit.

      01

      Show me every change to this mapping in the audit window.

      Filter by mapping ULID and date range. Result is in chronological order because the primary key is the order — works the same for an SOX walkthrough, a GxP data‑integrity review, or a GDPR Art. 30 records‑of‑processing request.

      02

      Prove this row hasn't been edited since it was written.

      Export the ledger range with its SHA‑256 hash chain. Re‑walk the chain. A single altered character would break every downstream hash — the same evidence satisfies ISO 27001 A.12.4.2, FedRAMP AU‑9, and Annex 11 §9.

      03

      Who approved this release? Were there two distinct people?

      The release row carries both the Contributor's draft signature and the Approver's release signature, and RBAC enforces that the two identities differ — directly addressing SOX segregation‑of‑duties, FedRAMP CM‑3, and GxP §14.

      Per‑Framework Briefs

      One‑pager for the framework you have to defend

      Same shape as the Audit Ledger Brief, recast against the specific clauses your assessor will cite. Hand the right one to the right room.

      For procurement

      Need a single attachment? All 6 briefs (Audit Ledger + 5 frameworks) bookmarked in one PDF.

      Download bundle (PDF)

      Healthcare framing

      Came here from a hospital RFP?

      Read the same architecture under HIPAA §164.312(b) and 21 CFR Part 11, with the four‑post audit blog cluster and the SME briefs your compliance team will ask for.

      Audit · Healthcare

      See it against your own framework

      Bring a sample mapping and the regulator your team is preparing for. We'll walk the ledger, the role split, and the hash‑chain verification end‑to‑end against the clause you have to defend.