Pre-built cornerstone learning data migration for the full Learning Suite: 6 Learning Object types, multi-decade transcripts, certifications, Learning Paths, SCORM/xAPI/AICC/CMI5 content libraries, ILT/VILT sessions, xAPI statement archives. Audit-defensible from completion event to regulator export.
The Learning Suite is the largest, deepest, most compliance-critical data domain in any Cornerstone tenant. Cornerstone learning data migration done right preserves the chain from regulator-visible certification back to the originating SCORM completion statement.
Cornerstone Learning Suite (LMS) is the original Cornerstone product line — founded 1999, expanded through 25 years of feature accretion, supplemented by the 2020 Saba merger (Saba Cloud, Saba Enterprise) and the 2022 EdCast and SumTotal acquisitions. Mature tenants carry the full inheritance: native Cornerstone Learning Objects, Saba-heritage course content, EdCast learning-experience content alongside Anytime/Inspire/Curated marketplace licensing. The data layer reflects that complexity — six Learning Object types, multi-decade transcripts, hundreds of Custom Fields driving Learning Audiences, certification rules tied to OSHA/HIPAA/FDA/SOX retention obligations, ILT/VILT session metadata, xAPI statement archives from xAPI-enabled content delivery.
Cornerstone learning data migration to Oracle Fusion Learn means translating all of that into the Fusion model: Learning Item (with type Course / Reading / Assessment), Learning Path (ordered sequence), Learning Record (per-user enrollment + progress + completion), Certification (with validity rules and renewal chains), Activity (for instructor-led training scheduling and rosters). Fusion's content engine has its own packaging and tracking model — SCORM bundles repackage with completion-rule preservation, xAPI statements route through xAPI proxy. None of this is trivial in custom-code form. All of it is pre-built in Syntra ETL.
The compliance dimension is the load-bearing wall. Every regulator-visible certification has to trace back through its supporting transcript record to the originating SCORM or xAPI completion statement to the original assessment score to the user's identity-of-record. Cornerstone learning data migration that breaks any link in that chain creates an audit-defensibility gap that surfaces at the worst possible moment — when an OSHA inspector arrives, when an FDA Form 483 is issued, or when SOX external auditors request training evidence for a key control. Syntra ETL preserves every link of that chain, signed and timestamped, ready for regulator export.
Each LO type maps to a specific Fusion construct with completion semantics, prerequisite chain and certification linkage preserved.
SCORM/xAPI/AICC/CMI5 content packages map to Fusion Learning Item type Course. Content uploaded to Fusion Learn content store, completion-rule semantics (passing score, attempts, time-in-course) preserved exactly.
Ordered Cornerstone Curriculum maps to Fusion Learning Path with ordered Learning Item references, prerequisite chain, branch logic and completion thresholds. Mid-curriculum learner progress preserved.
Downloadable PDF, reference docs, policy documents map to Fusion Learning Item type Reading. File uploaded to Fusion content store, acknowledgement-completion rules preserved.
Standalone assessments (without preceding content) map to Fusion Learning Item type Assessment. Question banks, scoring rules, passing thresholds and retake policies preserved.
Single ILT/VILT session instance maps to Fusion Activity with schedule, instructor, location/virtual URL, capacity, waitlist. Future sessions migrate as scheduled; past sessions migrate as completion records.
Recurring ILT/VILT event maps to Fusion Activity with recurrence rules. Future event instances scheduled in Fusion; historical instances migrate as Learning Records with attendance proof.
A repeatable load order that respects Fusion Learn dependencies. Skip a step and the next step's load fails.
Fusion Learn enterprise structures, learning categories, audience criteria framework, certification configuration framework, Activity venue setup, ILT/VILT integration (Zoom, Teams, Webex) configured. Loaded via FSM tasks — not user-facing data, but everything downstream depends on it.
Worker context loaded first (HDL Worker.dat) with Custom Field-derived DFFs and OU-derived department/location. Learning Audiences derived from Worker DFF criteria, pre-built before any Learning Item assignment.
All six Learning Object types loaded via HDL Learning Item. SCORM/xAPI/AICC/CMI5 content packages repackaged and uploaded to Fusion Learn content store. Learning Paths assembled with ordered LO references and prerequisite chains.
Certification configuration (validity periods, renewal sources) loaded via HDL Certification. Active and expired certifications loaded with full chain (course, date, score, instructor, cert number, expiry, renewal chain) preserved.
Current transcripts (trailing 2 years) loaded via HDL Learning Record from Cornerstone Edge stream. Historical transcripts (3–25 years) loaded via HDL Learning Record from RDW SQL bulk stream. Hash-signed and reconciled per user-course pair.
Future ILT/VILT sessions loaded as Fusion Activities with rosters, instructors, venues. xAPI LRS statement archive streamed to compliance archive in raw Tin Can format. Final delta replay and reconciliation pack issued.
Every regulator-visible certification traces back to its supporting evidence. Each link signed and timestamped for OSHA / HIPAA / FDA 21 CFR Part 11 / SOX defensibility.
Fusion Learn Certification with original course, completion date, score, instructor, cert number, expiry, renewal chain — the artefact OSHA inspector or FDA auditor sees first.
Fusion Learning Record linked to certification: enrollment date, completion date, status, score, attempts. Hash-signed at extract from Cornerstone, re-hashed post-load for reconciliation.
Original SCORM or xAPI completion statement preserved — for SCORM, the cmi.core.* tracking data; for xAPI, the original Tin Can statement. Routes to Fusion Learn content store or compliance archive.
Question-level response data, answer choices, scoring rationale, time-per-question. Preserved with the SCORM/xAPI data for full assessment substantiation under FDA 21 CFR Part 11 GxP review.
Worker identity at time of completion (name, employee ID, department, manager) preserved — not the current Worker record. Audit defensibility requires identity-at-time-of-completion, not as-of-today.
OSHA 5+ yr, HIPAA 6 yr, SOX 7 yr, FDA 21 CFR Part 11 life-of-product retention enforced per record class. Records past retention can be defensibly purged; records within retention immutable.
Cornerstone learning data migration covers the full Learning Suite (LMS) data domain: the six Learning Object types (Online Course, Curriculum, Material, Test, Session, Event), the per-user Transcript register, Certifications (active and expired), Learning Paths, SCORM 1.2 / SCORM 2004 / xAPI (Tin Can) / AICC / CMI5 content packages, ILT/VILT session metadata and rosters, content metadata (vendor licensing, tags, language variants, accessibility flags), Learning Audiences (the eligibility-rule layer), and the certification expiry rules that drive renewal reminders. Each domain has its own extraction pattern (Cornerstone Edge REST/GraphQL or RDW SQL), its own target shape in Oracle Fusion Learn (Learning Item, Learning Record, Certification, Learning Path), and its own compliance retention obligation (OSHA 5+ yr, HIPAA 6 yr, SOX 7 yr, FDA 21 CFR Part 11 life-of-product).
Cornerstone's six Learning Object (LO) types — Online Course, Curriculum, Material, Test, Session, Event — don't map 1:1 to Fusion Learn. Online Course (SCORM/xAPI content) maps to Fusion Learning Item type Course. Curriculum (ordered learning sequence) maps to Fusion Learning Path with ordered Learning Item references. Material (downloadable PDF, reference doc) maps to Fusion Learning Item type Reading. Test (assessment without content) maps to Fusion Learning Item type Assessment. Session (single instance of ILT/VILT) maps to Fusion Activity. Event (recurring ILT/VILT) maps to Fusion Activity with recurrence rules. Syntra ETL's cornerstone learning data migration engine ships pre-built mappings for all six LO types with prerequisite chain preservation, completion-rule translation (passing score, attempts, time-in-course), and certification linkage preservation.
Transcript depth is the largest data volume in any cornerstone learning data migration — 15-to-25-year transcripts are routine on long-tenured tenants, with single users carrying 5,000+ completion events spanning multiple decades of regulated training (compliance refreshers, certification renewals, mandatory annual training). Syntra ETL pulls transcripts in two parallel streams: structured transcript records through Cornerstone Edge REST/GraphQL for current and in-flight history (trailing 2 years typically); bulk historical transcripts through RDW SQL queries against the analytical replica for older completion data. Both streams hash-signed at extract, partitioned by user and fiscal year. Active and operational transcripts route to Fusion Learning Record via HDL; older regulated transcripts route to the long-term compliance archive with regulator-format export.
Courseware portability is the highest-risk technical workstream in cornerstone learning data migration. SCORM 1.2, SCORM 2004 (with its 4 editions), xAPI (Tin Can) statements, AICC HACP and CMI5 packages each carry different completion-rule semantics: passing score thresholds, allowed attempts, time-in-course tracking, bookmark resumption, sequencing rules. Syntra ETL's SCORM/xAPI engine inventories every package in the Cornerstone content library with its standard, version, file size, and completion-rule metadata; classifies by reuse value (gold/silver/retire); repackages gold-tier content into Fusion-compatible SCORM bundles preserving completion-rule semantics; uploads to Fusion Learn content store with score-band fidelity; routes xAPI statements through xAPI proxy to Fusion Learn. xAPI statement archives stream to compliance archive in raw form for regulator substantiation.
Yes — Learning Paths (the Cornerstone term for ordered multi-LO learning sequences) and Curriculum (the older curriculum-builder version of the same concept) are core to most enterprise tenants. They drive onboarding programmes, role-based skill development, compliance-training tracks and certification renewal cycles. Syntra ETL's cornerstone learning data migration walks every active Learning Path and Curriculum in the source tenant, captures the ordered LO references, prerequisite chains, branch logic and completion thresholds, and rebuilds equivalent structures in Fusion Learning Path. User progress against active Learning Paths is preserved — a learner mid-way through a 12-step compliance certification on Cornerstone resumes from step 7 on Fusion at cutover, no progress loss. Completion records for fully-completed Learning Paths route to Fusion Learning Record + Certification as appropriate.
Instructor-Led Training (ILT) and Virtual ILT (VILT) sessions in Cornerstone carry significant operational data: session schedules, instructor assignments, location/virtual-meeting URLs, capacity limits, waitlists, attendance records, completion sign-offs. Cornerstone learning data migration treats this as two flows: future scheduled sessions (transferred to Fusion Activity with full schedule, instructor, location, roster — sessions scheduled post-cutover run from Fusion); historical session-completion records (transferred to Fusion Learning Record with session metadata preserved — attendance proof, score, instructor sign-off). Waitlists are migrated with priority order preserved. Cancellation policies and refund rules carry across into Fusion Activity configuration.
Cornerstone Certifications carry the highest audit stakes in any cornerstone learning data migration — they're the regulator-visible artefact for OSHA, HIPAA, FDA 21 CFR Part 11 and SOX compliance. Each certification has: the originating course, completion date, score, instructor, certification number, expiry date, renewal chain (link to prior certification of the same type), and the certification rule (validity period, renewal source). Syntra ETL preserves all of this. Active certifications route to Fusion Learn Certification with full audit metadata. Expired certifications route to the long-term compliance archive with regulator-format export ready for OSHA inspector or FDA auditor delivery. Certification rules (validity period, renewal source LO) rebuild in Fusion Certification configuration so renewal reminders continue uninterrupted post-cutover.
xAPI (Tin Can) statements are the granular activity-tracking events emitted by xAPI-enabled content — every interaction, every answer, every micro-completion. Mature tenants accumulate billions of xAPI statements in the Learning Record Store (LRS). Cornerstone learning data migration handles xAPI in two ways: active xAPI streams (for content still in active delivery) repoint to Fusion Learn's xAPI LRS or to an external LRS proxy (Watershed, Veracity) with continuity preserved; historical xAPI statement archives (for content being retired or for compliance retention) stream to the long-term compliance archive in raw Tin Can statement format. xAPI is particularly important for FDA 21 CFR Part 11 substantiation where granular interaction trace is required — those statements route to the archive with the full assessment record alongside.
Book a 30-minute scoping call. We will walk through your Learning Suite profile — LO type counts, transcript history depth, SCORM/xAPI library size, certification rule count, ILT/VILT session volume — and outline the cornerstone learning data migration plan with timeline, compliance-archive routing and audit-evidence pack scope.