NovaWayfinder
Framework Studio
Framework Mapping
External frameworks to L3ED

Map external competency frameworks into the L3ED model.

Create batches, upload Excel workbooks, process source framework data, inspect staged items, and review generated proficiency statements for PLAR decisions.

Typical workflow

For external framework ingestion, create a batch with the target L3ED framework, upload the workbook, process it, then inspect the staged items and proficiency rows.

  1. Create a batch with a BatchName, source metadata, ImportFormat, and optional TargetFrameworkID.
  2. Upload Excel to batch using the ImportBatchID and an .xlsx or .xlsm workbook.
  3. Process Excel to parse the workbook and load framework links and statements.
  4. Load items to view the staging table for that batch.
  5. Load proficiencies to review generated level statements.

Column reference

What each table column means when you load import items or proficiencies.

Import items

#
The row number within the import batch.
SourceCode
The external framework identifier, such as a SFIA skill code.
Title
The source item name.
LevelLabel
Any source level or range label from the workbook.
Suggested type
A proposed L3 competency type, when available.
Dedupe candidate
A possible existing L3 competency match.
Confidence
A 0-1 confidence score for the suggestion.
Status
Review workflow status such as Pending, Review, Mapped, or Rejected.

Competency proficiency statements

Competency
The competency name, code, and internal CompetencyID.
Level
The framework level number and optional level name.
Statement
The proficiency statement text for that competency at that level.
Status
Governance status such as Draft, Approved, Published, or Archived.
Source
The source framework or version label.

Health

Checks whether framework mapping tables are installed.

Import batches

Calls /api/competency/translation/import-batches.
Create new batch

Import items

Calls /api/competency/translation/import-batches/{id}/items. Upload Excel, then run Process to load the Skills sheet into L3 tables.

Competency proficiency statements

Calls /api/competency/translation/proficiencies.