TimeBack Platform / NWEAMap / 1EdTech surface

NWEA MAP Growth CDF pass-through fields plus platform-owned import, dedupe, retention, and API metadata.

This dictionary treats NWEA's MAP Growth Comprehensive Data File and MAP_Export_Field_Descriptions.xlsx as the upstream field authority. NWEA fields are passed through with their source descriptions, datatypes, lengths, and observed nullability evidence. Platform fields are clearly labeled as gap-fill metadata and linked to the approved NWEAMap architecture ITDs.

5CDF raw tables
143AssessmentResults columns
322Total documented fields
3491Assessment sample rows
0Alpha-only calculators

How to use this dictionary

Migration rule. NWEA pass-through columns preserve the CDF header spelling and workbook semantics. Platform sidecar fields are the only fields this dictionary defines locally, and each one links to an NITD.
Nullability

Every NWEA CSV header is required. Values are nullable unless the workbook and implementation tests prove otherwise; blank is often a meaningful export state.

Invalid values

Invalidity comes from the documented type, length, allowed value, and platform rule. Example: TestRITScore outside 100-350 remains visible in all-sittings reads but is invalid for test_of_record.

PII handling

Student and teacher examples are synthetic. The real vendored CSVs contain PII, so this site never publishes raw sample person values.

No Alpha leakage

No Growth X, norms table, Effective Grade, Alpha report-specific RIT50/RIT90, term parser, report-cell, report-contract, or report-oracle field appears here. Per NITD-018 and R6, PowerPath RIT-to-grade/R90 reference lookup is the NWEAMAP-owned exception, not Alpha report assembly.

Two first-class paths -- raw-DB answer must equal the API answer

Guardrails (Raw-DB = API)

An agent may answer a MAP question by calling the NWEAMap 1EdTech API or by querying these nweamap.* tables directly through this dictionary, and must get the same answer either way. NWEA CDF rows are a lossless 1:1 mirror, so the API applies the dedup, soft-delete, scope, unpivot, tenant, validity, and norms rules below on every read; a naive select * from nweamap.raw_assessment_results silently returns wrong-but-plausible rows unless it reproduces each rule. These guardrails are additive documentation only -- they do not change any field, table, or allowed value above; they document how the existing columns must be queried. The test-of-record query contract already encodes rules 1, 2, and 6 together as a worked example.

1. Test of record = highest valid RIT per (student, subject, term) -- not every sitting

Rule the API enforces: For the one-official-result-per-student question, the API returns exactly one row per (tenant_id, nwea_account_id, student, subject, term_name): the row with the highest valid TestRITScore. A valid MAP RIT is the integer range 100 through 350. Ties break by latest TestStartDate/TestStartTime, then by larger TestID. This is the nweamap.assessment_result_projection row where is_test_of_record = true; the sittingScope = test_of_record read never returns more than that one row per grouping.

Why the API enforces it: AssessmentResults.csv is a lossless mirror of the NWEA export, so it carries every sitting, retake, and survey attempt for the same student/subject/term. A raw `select * from nweamap.raw_assessment_results` returns ALL of them; counting or averaging those rows, or trusting GrowthMeasureYN as the selector, gives a wrong-but-plausible answer the API never returns. Highest valid RIT (not latest, not GrowthMeasureYN) is the deterministic selector.

Raw-DB path must do: For the test-of-record answer, read nweamap.assessment_result_projection and filter `is_test_of_record = true` (already deduped, exactly one per grouping). To reproduce it from raw rows, group raw_assessment_results by (tenant_id, nwea_account_id, term_name, student_id, student_state_id, subject), keep only rows with TestRITScore numeric and between 100 and 350, then ORDER BY TestRITScore DESC, test_start_at DESC, TestID DESC and take the first row per group. Never trust GrowthMeasureYN to pick the row, and never let an invalid-RIT row win.

2. Soft-delete -- exclude deleted_at rows from every live read

Rule the API enforces: When a previously ingested row disappears from the next authoritative export (or is replaced by a changed row with the same natural identity), it is soft-deleted: deleted_at is stamped and deletion_import_id / deletion_reason are recorded. The row is RETAINED for audit and retake history but is NOT part of the live roster. Every live API read filters `deleted_at is null`; the projection is rebuilt only from non-deleted rows.

Why the API enforces it: The platform never hard-deletes through the public surface, so retired and replaced rows physically remain in nweamap.raw_assessment_results and the other raw tables. A raw `select *` returns those tombstoned rows, inflating sitting counts, resurrecting invalidated results, and double-counting students whose row was replaced by a corrected re-export.

Raw-DB path must do: For any current/live answer, add `and deleted_at is null` to every raw_* query and to every join (the API's listRawRows uses `and ($includeDeleted::boolean or deleted_at is null)`). To audit retirements, select `deleted_at is not null` explicitly and read deletion_import_id / deletion_reason; never silently include deleted rows in a current count.

3. Sitting scope -- all-sittings vs test-of-record is an explicit choice

Rule the API enforces: Assessment-result reads expose the sittingScope parameter with two documented values: test_of_record (one deduped highest-RIT row per grouping, backed by assessment_result_projection) and all (every in-scope sitting, backed by the raw rows). includeDeleted=true is a separate, additional opt-in that surfaces soft-deleted rows; default is includeDeleted=false. Choosing the scope is the client's explicit decision, not a hidden default the raw path can ignore.

Why the API enforces it: These are two different questions over the same data. Reading raw rows answers the all-sittings question; reading the projection answers the test-of-record question. Mixing them (e.g. answering 'how many students tested' from all-sittings, or 'show every retake' from the projection) silently disagrees with whichever scope the API caller asked for.

Raw-DB path must do: Decide the scope first. For sittingScope=test_of_record: query assessment_result_projection (where is_test_of_record = true, deleted_at is null). For sittingScope=all: query raw_assessment_results (deleted_at is null unless includeDeleted=true). Do not blend the two row sets in one answer, and do not let includeDeleted leak into a default live read.

4. Goal-strand unpivot -- positional Goal1..Goal8 columns are one row per strand

Rule the API enforces: AssessmentResults.csv carries goal/instructional-area sub-scores as positional column blocks: Goal1Name/Goal1RitScore/Goal1StdErr/Goal1Range/Goal1Adjective, then Goal2*, ... up to Goal8* (the workbook expresses Goal2-8 as shorthand for the same five-field block). Position N is not a fixed strand: GoalNName is the strand label for that test. The per-strand answer is one logical row per non-blank GoalNName, carrying that strand's RIT and adjective; a goal_gap (overall RIT minus that strand's GoalNRitScore) is derived per strand, not stored as a column.

Why the API enforces it: A raw `select Goal1Name, Goal2Name, ...` keeps the data wide and positional, so Goal1 for a Reading test and Goal1 for a Math test are unrelated strands sharing a column index. Treating column position as a strand identity, or ignoring blank goal blocks (which are valid for Survey tests without goals), produces a wrong-but-plausible per-strand report. The strand identity lives in GoalNName, not in N.

Raw-DB path must do: Unpivot the eight positional blocks into one row per strand: for N in 1..8, emit (student, subject, term, strand_name = GoalNName, strand_rit = GoalNRitScore, strand_adjective = GoalNAdjective) only WHERE GoalNName is not blank. Derive goal_gap per emitted strand as overall test RIT minus GoalNRitScore. Key strand rows by GoalNName, never by N. Skip blank goal blocks (Survey tests legitimately have none).

5. Tenant + NWEA-account scope -- filter tenant_id and nwea_account_id on every read

Rule the API enforces: Every read is scoped to the caller's tenant_id (the platform isolation boundary, taken from the authenticated JWT tenant_id/tenantId claim, never from a query string) AND to nwea_account_id (a required tenant-local partition, not a platform tenant). One tenant can manage multiple NWEA accounts, and the same student_id / TestID values recur across accounts and tenants.

Why the API enforces it: tenant_id is not an NWEA CDF field; it is the multi-tenant boundary. student_id, TestID, and natural keys are only unique within (tenant_id, nwea_account_id, term). An unscoped raw read mixes tenants and NWEA accounts and can collide on student/test identifiers, returning rows no API endpoint ever crosses.

Raw-DB path must do: Add `where tenant_id = $tenant and nwea_account_id = $account` to EVERY query and to every JOIN's ON clause (e.g. `on p.tenant_id = r.tenant_id and p.nwea_account_id = r.nwea_account_id`). Never join nweamap.* tables on student_id or TestID alone -- always pair with (tenant_id, nwea_account_id). Resolve $tenant from the same JWT identity the API uses; ignore any tenant value passed alongside the data.

6. Real-student / valid-RIT filter -- invalid-RIT rows are visible but never test-of-record

Rule the API enforces: A row is eligible to be a test of record only when TestRITScore is a numeric MAP RIT in 100 through 350 (is_valid_rit_for_record = true). Out-of-range, non-numeric, or blank-RIT rows remain visible through all-sittings reads but can never become the test of record, and a grouping whose only rows are invalid-RIT produces no projection row at all.

Why the API enforces it: The lossless mirror retains diagnostic, voided, and partial sittings with junk or out-of-range RIT values. A raw query that averages or ranks TestRITScore without the 100-350 validity gate will pick an impossible RIT as the official result, disagreeing with the API which excludes those rows from test-of-record selection.

Raw-DB path must do: Before selecting a test of record, keep only rows where TestRITScore is numeric AND between 100 and 350 (`TestRITScore ~ '^[0-9]+$' and TestRITScore::int between 100 and 350`). Invalid-RIT rows may appear in sittingScope=all reads but must be excluded from any highest-RIT/test-of-record computation; read is_valid_rit_for_record / test_of_record_reason on the projection rather than re-deriving silently.

7. Norms-set tagging -- never mix 2020 and 2025 NormsReferenceData

Rule the API enforces: NormsReferenceData is preserved verbatim per row (2020, 2025, USER, blank, or future NWEA values). It identifies which NWEA norms study a row's norm-referenced figures belong to. Rows tagged with different norms sets describe incomparable reference populations; the API passes the tag through so consumers can keep them apart.

Why the API enforces it: MAP percentile/growth context shifts between the 2020 and 2025 norms studies, so combining rows of different NormsReferenceData into one percentile or growth comparison is statistically wrong even though the RIT columns look identical. A raw `select *` that aggregates across norms sets silently blends incomparable populations.

Raw-DB path must do: When a question is norm-referenced (percentile, growth, comparison), filter or group by NormsReferenceData (`and norms_reference_data = '2025'`) so a single answer never mixes norms sets. When merely passing through raw RIT values, preserve the tag verbatim; never default, rewrite, or coalesce a blank norms value into a specific study.

Surface boundary: no 1EdTech report oracle

nweamap_report_oracle_boundary

DEFER report-oracle, report-contract, golden-cell, and report-verification primitives on the 1EdTech surface; exact MAP Quadrants report cells, norms=2020|2025 verification, Growth X, Alpha report-specific RIT50/RIT90/Effective Grade assembly, and Alpha report graphs belong to the Alpha surface. R6 carves out the module-owned PowerPath RIT-to-grade reference table/lookup as NWEAMAP-owned portable MAP reference data, not a report oracle. Any skill-pack eval asking 1edtech/skill_pack to regenerate Alpha reports must move to alpha/skill_pack

What this 1EdTech dictionary supports
  • CDF import and idempotent read-back.
  • Raw all-sittings reads, including soft-deleted rows when requested.
  • Current test-of-record projection through sittingScope=test_of_record.
  • Source-fidelity, header-parity, row-count, and import validation evidence.
  • Module-owned PowerPath RIT-to-grade/R90 reference table and lookup through /nweamap/v1/rit-to-grade*; /nweamap/v1/r90* remains a compatibility alias.
Where exact report work routes

Requests for MAP Quadrants exact report regeneration, Growth X, Alpha report-specific RIT50/RIT90/Effective Grade assembly, norms-flipped golden cells, or report graphs route to Alpha architecture; observed RIT-to-grade/R90 reference lookup routes to NWEAMAP.

Boundary labelDictionary meaning
exact report-contract boundaryNo 1EdTech table, field, or endpoint defines exact MAP Quadrants report families, report cells, or canonical report filters.
golden-cell boundaryNo 1EdTech persistence object stores expected report-cell values or a report-verification oracle.
Alpha outcome-metric boundaryNo Growth X field is defined on the 1EdTech surface; that Alpha outcome metric must be pinned on the Alpha surface before use.
Alpha RIT-derived boundaryNo Alpha report-specific RIT50/RIT90/Effective Grade, Alpha minimum RIT, or Alpha predicted RIT field is defined here; the R6 PowerPath RIT-to-grade/R90 reference table/lookup is NWEAMAP-owned portable MAP reference data, not report assembly.
norms-calculation boundaryNo local norms table or term-string parser is part of the 1EdTech data dictionary; NWEA NormsReferenceData is preserved only as a pass-through value.

Source contract and CDF files

NWEA's workbook compresses repeated AssessmentResults.csv blocks with shorthand. This dictionary expands the actual vendored CSV headers so every 143-column AssessmentResults field has its own anchor while preserving the workbook shorthand as provenance. The workbook also includes a Combined-export sheet; the approved raw mirror uses only the Comprehensive export files below.

CDF fileWorkbook sheetFieldsLocal data rows
StudentsBySchool.csvStudentBySchool.csv161124
AssessmentResults.csvAssessmentResults.csv1433491
ClassAssignments.csvClassAssignments.csv111128
ProgramAssignments.csvProgramAssignments.csv50
AccommodationAssignment.csvAccommodationAssignment.csv61412

Workbook sheets intentionally not mirrored as raw tables

Workbook sheetWhy excluded from raw persistenceArchitecture trace
ComboStudentAssessment.csvNWEA documents this as the Combined export. The approved NWEAMap 1EdTech raw mirror commits to the five Comprehensive export files only, so this sheet is cited as source context but is not persisted as a raw table.NITD-001

Test-of-record query contract

Cold query path. A client that needs one row per student, subject, and term calls GET /nweamap/v1/assessment-results?sittingScope=test_of_record. The response is backed by nweamap.assessment_result_projection; clients do not sort, dedupe, or reinterpret GrowthMeasureYN.
Grouping key
Selector, in order
  • Exclude soft-deleted rows from test_of_record.
  • Exclude rows whose TestRITScore is not numeric MAP RIT from 100 through 350.
  • Within each grouping key, choose the highest valid TestRITScore.
  • Break equal-RIT ties by later parsed TestStartDate/TestStartTime.
  • Break remaining ties by larger TestID for determinism.
  • Preserve NWEA GrowthMeasureYN as audit evidence; it does not override the highest-RIT rule.
Migration minimum
  • Create one raw AssessmentResults mirror row per source CSV row plus the common platform sidecar fields.
  • Create one projection row per raw AssessmentResults row with is_test_of_record, test_of_record_rank, and test_of_record_reason.
  • Enforce at most one active is_test_of_record=true row per tenant/account/student/subject/term grouping.
  • Expose sittingScope=test_of_record through the API so client agents do not re-implement dedupe.
Projection fields to inspect

is_test_of_record, test_of_record_rank, test_of_record_reason, is_valid_rit_for_record, deleted_at, and assessment_result_row_id.

API parameter dictionary

Query parameters, scopes, and Problems

These are not NWEA CDF fields. They are platform-owned request and error contract fields that prevent clients from re-implementing dedupe, deleted-row selection, auth, or import repair logic.

FieldType and nullabilityMeaning and constraintsAllowed valuesRelationships and edge casesExample and provenance
sittingScopePlatform gap-fill query enum
Platform-owned
Required on assessment-result reads.

Selects whether the response returns the TimeBack test of record or all raw sittings.

Constraints
  • Must be test_of_record or all.
  • Skill packs must use this parameter instead of implementing dedupe.
  • test_of_record - Only the highest valid, non-deleted result per tenant/account/student/subject/term.
  • all - All raw sittings in scope, including retakes and soft-deleted rows when includeDeleted=true.
RelationshipsNone specified.Edge casesNone specified.

Example
test_of_record

Source
NWEAMap architecture gap fill

Platform-owned field

includeDeletedPlatform gap-fill query boolean
Platform-owned
Optional; default false.

Includes soft-deleted raw rows for audit reads when sittingScope=all.

Constraints
  • Only meaningful with sittingScope=all.
  • Must not include deleted rows in test_of_record responses.
  • false - Default; soft-deleted rows are excluded.
  • true - Include soft-deleted rows for audit reads when sittingScope=all.
RelationshipsNone specified.Edge casesNone specified.

Example
false

Source
NWEAMap architecture gap fill

Platform-owned field

subjectPlatform gap-fill query string
Platform-owned
Required on /nweamap/v1/rit-to-grade and legacy /nweamap/v1/r90; optional on /nweamap/v1/rit-to-grade/table and assessment-result reads.

MAP subject filter. RIT-to-grade accepts Math, Reading, Language, Science, and module-owned aliases such as FastMath mapping to the Math table.

Constraints
  • Do not use a local subject-specific RIT-to-grade table.
  • The API returns requested_subject_id and table_subject_id when aliases map to a table subject.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
math

Source
NWEAMap architecture gap fill

Platform-owned field

ritPlatform gap-fill query number
Platform-owned
Required on /nweamap/v1/rit-to-grade and legacy /nweamap/v1/r90.

Input RIT score for the module-owned PowerPath RIT-to-grade/R90 lookup.

Constraints
  • Must be numeric.
  • Observed RIT-to-grade uses the PowerPath mirror, not grade2rit.csv.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
239

Source
NWEAMap architecture gap fill

Platform-owned field

tableVersionPlatform gap-fill query string
Platform-owned
Optional.

Pins the served RIT-to-grade reference version. If supplied, it must equal the current NWEAMAP table version.

Constraints
  • Current value is nweamap.rit_to_grade.powerpath.v2026-06-15.
  • Older or unknown versions return a typed validation error.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
nweamap.rit_to_grade.powerpath.v2026-06-15

Source
NWEAMap architecture gap fill

Platform-owned field

modifiedSincePlatform gap-fill query timestamp
Platform-owned
Optional.

Returns rows or import records changed after the timestamp.

Constraints
  • UTC ISO-8601 timestamp.
  • Unsupported on endpoints not listed in the customer website.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
2026-06-03T11:00:00Z

Source
NWEAMap architecture gap fill

Platform-owned field

limitPlatform gap-fill query integer
Platform-owned
Optional; service default.

Maximum number of rows returned before an opaque cursor is issued.

Constraints
  • Positive integer; implementation chooses documented maximum.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
100

Source
NWEAMap architecture gap fill

Platform-owned field

cursorPlatform gap-fill query string
Platform-owned
Optional.

Opaque pagination token returned by the previous list response.

Constraints
  • Clients must not parse or construct cursor values.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
eyJwYWdlIjoyfQ

Source
NWEAMap architecture gap fill

Platform-owned field

scopePlatform gap-fill JWT claim enum
Platform-owned
Required by route family.

NWEAMap authorization scope inside the platform HS256 Bearer token.

Constraints
  • Import routes require nweamap:import; read routes require nweamap:read.
  • nweamap:import - May submit CDF imports.
  • nweamap:read - May read NWEAMap rows and projections.
  • nweamap:admin - May inspect import diagnostics and administrative state.
RelationshipsNone specified.Edge casesNone specified.

Example
nweamap:read

Source
NWEAMap architecture gap fill

Platform-owned field

problem_codePlatform gap-fill RFC 7807 type code
Platform-owned
Required in NWEAMap Problem responses.

Stable error code used by agents to repair import and query failures.

Constraints
  • Must be one of the documented NWEAMap Problem codes.
  • nweamap:invalid_bundle - Submitted bundle is not a valid CDF bundle.
  • nweamap:missing_file - Required CDF file is absent.
  • nweamap:header_mismatch - File header differs from the NWEA workbook/CSV contract.
  • nweamap:row_validation_failed - One or more row values violate the documented field contract.
  • nweamap:idempotency_conflict - Idempotency-Key was reused for different bundle content.
  • nweamap:unsupported_query_parameter - Request used a filter or sort key outside this dictionary.
  • nweamap:not_found - Requested import or row was not found in the caller's tenant/account scope.
RelationshipsNone specified.Edge casesNone specified.

Example
nweamap:header_mismatch

Source
NWEAMap architecture gap fill

Platform-owned field

platform table

nweamap.import CDF import bundle

Purpose

One submitted Comprehensive Data File bundle for one tenant, NWEA account, and term.

Lifecycle

Received, validated, applied, failed, or no-op through idempotency replay. Import rows are audit evidence and are not deleted through the public surface.

Public endpoint

POST /nweamap/v1/imports and GET /nweamap/v1/imports/{importId}

Relationships
  • Parent of import_file and every raw CDF row written by the bundle.
  • References platform.idempotency_key when an Idempotency-Key was supplied.

Fields

FieldType and nullabilityMeaning and constraintsAllowed valuesRelationships and edge casesExample and provenance
import_idPlatform gap-fill UUID
Platform-owned
Required; primary key.

Stable identifier for one submitted CDF bundle.

Constraints
  • Unique within nweamap.import.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
018f4b4e-9c7a-7d3d-8b2f-2f673a000001

Source
NWEAMap architecture gap fill

Platform-owned field

tenant_idPlatform gap-fill UUID
Platform-owned
Required.

Platform tenant boundary for this import.

Constraints
  • Must match JWT tenantId.
  • References platform.tenant(tenant_id).

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
018f4b4e-9c7a-7d3d-8b2f-2f673a000001

Source
NWEAMap architecture gap fill

Platform-owned field

nwea_account_idPlatform gap-fill TEXT
Platform-owned
Required.

Tenant-local NWEA account represented by the submitted bundle.

Constraints
  • Required for every import and read-back filter.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
nwea-account-demo

Source
NWEAMap architecture gap fill

Platform-owned field

term_namePlatform gap-fill TEXT
Platform-owned
Required.

NWEA TermName scope for the submitted CDF bundle.

Constraints
  • Must equal the TermName represented by file rows when rows are present.
  • Header-only optional files inherit this manifest term.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
Spring 2025-2026

Source
NWEAMap architecture gap fill

Platform-owned field

statusPlatform gap-fill TEXT enum
Platform-owned
Required.

Import lifecycle state.

Constraints
  • Must be one of the documented import status values.
  • received - Bundle accepted and queued for validation.
  • validating - Headers and row values are being checked.
  • applied - Rows were written and projections updated.
  • failed - Import failed; row/file Problems identify the repair work.
  • no_op - Equivalent bundle was already applied for the same tenant/account/term.
RelationshipsNone specified.Edge casesNone specified.

Example
applied

Source
NWEAMap architecture gap fill

Platform-owned field

bundle_hashPlatform gap-fill TEXT
Platform-owned
Required.

Canonical hash of file names, headers, row order, and row content for the bundle.

Constraints
  • Used with tenant_id, nwea_account_id, and term_name for idempotent re-import.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
sha256:2d3f6b4e8c1a0f9b7e6d5c4b3a291807060504030201000ffeeddbbccaa9988

Source
NWEAMap architecture gap fill

Platform-owned field

idempotency_keyPlatform gap-fill TEXT
Platform-owned
Nullable.

Optional caller-provided Idempotency-Key stored in the platform retry ledger.

Constraints
  • If reused with different bundle content, API returns 409.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
import-2026-06-03-demo

Source
NWEAMap architecture gap fill

Platform-owned field

row_countsPlatform gap-fill JSONB
Platform-owned
Required.

Per-file row counts observed during validation and application.

Constraints
  • Must contain one key per submitted CDF file.
  • ProgramAssignments.csv can validly be zero.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
{"AssessmentResults.csv":3491}

Source
NWEAMap architecture gap fill

Platform-owned field

problem_summaryPlatform gap-fill JSONB
Platform-owned
Nullable.

Redacted import-level validation summary for failed or partially rejected bundles.

Constraints
  • Must not include raw student names, student IDs, or full row payloads.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
{"code":"nweamap:header_mismatch"}

Source
NWEAMap architecture gap fill

Platform-owned field

received_atPlatform gap-fill TIMESTAMPTZ
Platform-owned
Required.

Timestamp when the bundle arrived.

Constraints
  • UTC timestamp.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
2026-06-03T11:00:00Z

Source
NWEAMap architecture gap fill

Platform-owned field

applied_atPlatform gap-fill TIMESTAMPTZ
Platform-owned
Nullable.

Timestamp when rows and projections finished applying.

Constraints
  • Null until status is applied or no_op.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
2026-06-03T11:00:00Z

Source
NWEAMap architecture gap fill

Platform-owned field

modified_atPlatform gap-fill TIMESTAMPTZ
Platform-owned
Required.

Timestamp when import status or summary last changed.

Constraints
  • Powers modifiedSince polling.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
2026-06-03T11:00:00Z

Source
NWEAMap architecture gap fill

Platform-owned field

platform table

nweamap.import_file CDF import file evidence

Purpose

Header, row-count, and validation evidence for one file inside an import bundle.

Lifecycle

Created during validation before raw rows are applied; retained as conformance evidence.

Public endpoint

GET /nweamap/v1/imports/{importId}

Relationships
  • Child of nweamap.import.
  • Parent of raw CDF rows through import_file_id.

Fields

FieldType and nullabilityMeaning and constraintsAllowed valuesRelationships and edge casesExample and provenance
import_file_idPlatform gap-fill UUID
Platform-owned
Required; primary key.

Stable identifier for one file inside an import bundle.

Constraints
  • Unique within nweamap.import_file.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
018f4b4e-9c7a-7d3d-8b2f-2f673a000001

Source
NWEAMap architecture gap fill

Platform-owned field

import_idPlatform gap-fill UUID
Platform-owned
Required.

Parent import bundle.

Constraints
  • References nweamap.import(import_id).

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
018f4b4e-9c7a-7d3d-8b2f-2f673a000001

Source
NWEAMap architecture gap fill

Platform-owned field

source_filePlatform gap-fill TEXT enum
Platform-owned
Required.

CDF file name.

Constraints
  • Must be one of the five Comprehensive Data File names.
  • StudentsBySchool.csv - One required or optional file in the Comprehensive Data File bundle.
  • AssessmentResults.csv - One required or optional file in the Comprehensive Data File bundle.
  • ClassAssignments.csv - One required or optional file in the Comprehensive Data File bundle.
  • ProgramAssignments.csv - One required or optional file in the Comprehensive Data File bundle.
  • AccommodationAssignment.csv - One required or optional file in the Comprehensive Data File bundle.
RelationshipsNone specified.Edge casesNone specified.

Example
StudentsBySchool.csv

Source
NWEAMap architecture gap fill

Platform-owned field

header_hashPlatform gap-fill TEXT
Platform-owned
Required.

Canonical hash of the submitted file header.

Constraints
  • Compared to the vendored NWEA workbook/CSV header contract.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
sha256:2d3f6b4e8c1a0f9b7e6d5c4b3a291807060504030201000ffeeddbbccaa9988

Source
NWEAMap architecture gap fill

Platform-owned field

row_countPlatform gap-fill INTEGER
Platform-owned
Required.

Number of data rows in the file, excluding the header.

Constraints
  • Must be >= 0.
  • Zero is valid for ProgramAssignments.csv.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
1124

Source
NWEAMap architecture gap fill

Platform-owned field

validation_statusPlatform gap-fill TEXT enum
Platform-owned
Required.

File-level validation state.

Constraints
  • Must be one of the documented validation statuses.
  • pending - File has not completed validation.
  • valid - Header and rows passed validation.
  • invalid - File failed header or row validation.
  • missing - Required file was not present in the submitted bundle.
  • empty_valid - Optional file was present with a correct header and zero data rows.
RelationshipsNone specified.Edge casesNone specified.

Example
valid

Source
NWEAMap architecture gap fill

Platform-owned field

source_headerPlatform gap-fill JSONB
Platform-owned
Required.

Ordered array of submitted column headers.

Constraints
  • Must preserve header order exactly.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
["TermName","StudentID"]

Source
NWEAMap architecture gap fill

Platform-owned field

field_error_countPlatform gap-fill INTEGER
Platform-owned
Required.

Number of field-level validation errors found in this file.

Constraints
  • Must be >= 0.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
0

Source
NWEAMap architecture gap fill

Platform-owned field

created_atPlatform gap-fill TIMESTAMPTZ
Platform-owned
Required.

Timestamp when the file record was created.

Constraints
  • UTC timestamp.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
2026-06-03T11:00:00Z

Source
NWEAMap architecture gap fill

Platform-owned field

modified_atPlatform gap-fill TIMESTAMPTZ
Platform-owned
Required.

Timestamp when validation status last changed.

Constraints
  • Powers modifiedSince polling.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
2026-06-03T11:00:00Z

Source
NWEAMap architecture gap fill

Platform-owned field

NWEA pass-through raw table

nweamap.raw_students_by_school Students by school raw CDF rows

Purpose

Lossless mirror of NWEA student-by-school rows for one tenant, NWEA account, term, and import.

Lifecycle

Created by bulk CDF import; soft-deleted when a replacement export for the same scope stops sending the row; never hard-deleted by the public surface.

Public endpoint

GET /nweamap/v1/students

Relationships
  • StudentID and Student_StateID connect to assessment, class, program, and accommodation rows when NWEA supplied them.
  • tenant_id and nwea_account_id scope every row before any student identifier is interpreted.
CDF source StudentsBySchool.csv / workbook sheet StudentBySchool.csv 16 NWEA fields, 1124 local sample rows.

Platform sidecar fields

FieldType and nullabilityMeaning and constraintsAllowed valuesRelationships and edge casesExample and provenance
row_idPlatform gap-fill UUID
Platform-owned
Required; primary key.

Stable row identifier assigned by the platform for this mirrored CDF row.

Constraints
  • Unique within this table.
  • Never derived from student identity or NWEA row text.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
018f4b4e-9c7a-7d3d-8b2f-2f673a000001

Source
NWEAMap architecture gap fill

Platform-owned field

tenant_idPlatform gap-fill UUID
Platform-owned
Required.

Platform tenant boundary from the verified JWT; this is the authorization scope for the row.

Constraints
  • Must match the caller's JWT tenantId for writes and reads.
  • References platform.tenant(tenant_id).

Platform-owned values are closed when listed here.

Relationships
  • Belongs to exactly one platform.tenant row.
Edge casesNone specified.

Example
018f4b4e-9c7a-7d3d-8b2f-2f673a000001

Source
NWEAMap architecture gap fill

Platform-owned field

nwea_account_idPlatform gap-fill TEXT
Platform-owned
Required.

Tenant-local NWEA account partition for the imported bundle.

Constraints
  • Required for imports and list filters.
  • Not globally unique outside tenant_id.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
nwea-account-demo

Source
NWEAMap architecture gap fill

Platform-owned field

import_idPlatform gap-fill UUID
Platform-owned
Required.

Import bundle that created or last refreshed this row.

Constraints
  • References nweamap.import(import_id).

Platform-owned values are closed when listed here.

Relationships
  • Many raw rows belong to one import bundle.
Edge casesNone specified.

Example
018f4b4e-9c7a-7d3d-8b2f-2f673a000001

Source
NWEAMap architecture gap fill

Platform-owned field

import_file_idPlatform gap-fill UUID
Platform-owned
Required.

Import-file record for the CDF file that carried this row.

Constraints
  • References nweamap.import_file(import_file_id).

Platform-owned values are closed when listed here.

Relationships
  • Many raw rows belong to one import file.
Edge casesNone specified.

Example
018f4b4e-9c7a-7d3d-8b2f-2f673a000001

Source
NWEAMap architecture gap fill

Platform-owned field

source_filePlatform gap-fill TEXT enum
Platform-owned
Required.

Exact CDF file name whose header and row content produced this row.

Constraints
  • Must be one of the five Comprehensive Data File names.
  • StudentsBySchool.csv - One required or optional file in the Comprehensive Data File bundle.
  • AssessmentResults.csv - One required or optional file in the Comprehensive Data File bundle.
  • ClassAssignments.csv - One required or optional file in the Comprehensive Data File bundle.
  • ProgramAssignments.csv - One required or optional file in the Comprehensive Data File bundle.
  • AccommodationAssignment.csv - One required or optional file in the Comprehensive Data File bundle.
RelationshipsNone specified.Edge casesNone specified.

Example
AssessmentResults.csv

Source
NWEAMap architecture gap fill

Platform-owned field

source_row_numberPlatform gap-fill INTEGER
Platform-owned
Required.

One-based data-row number inside the CDF file, excluding the header.

Constraints
  • Must be >= 1.
  • Stable only within the import_file_id.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
42

Source
NWEAMap architecture gap fill

Platform-owned field

source_row_hashPlatform gap-fill TEXT
Platform-owned
Required.

Canonical hash of the source-file name, header position, and row values used for idempotent re-import and missing-row detection.

Constraints
  • SHA-256 hex or sha256-prefixed digest.
  • Same row content in the same file scope must produce the same hash.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
sha256:2d3f6b4e8c1a0f9b7e6d5c4b3a291807060504030201000ffeeddbbccaa9988

Source
NWEAMap architecture gap fill

Platform-owned field

ingested_atPlatform gap-fill TIMESTAMPTZ
Platform-owned
Required.

Timestamp when the platform accepted this row into tenant-scoped persistence.

Constraints
  • Must be UTC.
  • Used for audit and modifiedSince behavior.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
2026-06-03T11:00:00Z

Source
NWEAMap architecture gap fill

Platform-owned field

modified_atPlatform gap-fill TIMESTAMPTZ
Platform-owned
Required.

Timestamp when the row or its deletion/projection state last changed.

Constraints
  • Must be UTC.
  • Must be greater than or equal to ingested_at.
  • Powers modifiedSince polling.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
2026-06-03T11:00:00Z

Source
NWEAMap architecture gap fill

Platform-owned field

deleted_atPlatform gap-fill TIMESTAMPTZ
Platform-owned
Nullable.

Soft-delete timestamp set when a replacement authoritative export stops sending this source row.

Constraints
  • Null means active.
  • Non-null rows are excluded from test_of_record.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge cases
  • Soft delete is retention evidence, not a legal erasure API.

Example
2026-06-03T11:00:00Z

Source
NWEAMap architecture gap fill

Platform-owned field

deleted_by_import_idPlatform gap-fill UUID
Platform-owned
Nullable.

Replacement import that caused this row to be marked deleted.

Constraints
  • References nweamap.import(import_id) when present.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
018f4b4e-9c7a-7d3d-8b2f-2f673a000001

Source
NWEAMap architecture gap fill

Platform-owned field

delete_reasonPlatform gap-fill TEXT enum
Platform-owned
Nullable.

Platform explanation for why the row disappeared from a later authoritative export, when inferable.

Constraints
  • Must be null or one of the documented delete_reason values.
  • missing_from_replacement_export - A later authoritative export for the same scope stopped sending the row.
  • retake_superseded - Import evidence indicates the row was replaced by a retake.
  • invalidated_or_suppressed_by_nwea - Import evidence indicates NWEA invalidated or suppressed the sitting.
  • unknown - The row disappeared but the specific reason was not inferable.
RelationshipsNone specified.Edge casesNone specified.

Example
missing_from_replacement_export

Source
NWEAMap architecture gap fill

Platform-owned field

NWEA pass-through fields

FieldType and nullabilityMeaning and constraintsAllowed valuesRelationships and edge casesExample and provenance
#1TermNameNWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Term chosen for the export.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • No blanks observed in the local sample, but NWEA pass-through columns remain nullable unless NWEA explicitly requires otherwise.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

Relationships
  • Term scope is paired with tenant_id and nwea_account_id; term strings are pass-through NWEA values, not parsed by client skill packs.
Edge casesNone specified.

Example
Spring 2025-2026

Source
MAP_Export_Field_Descriptions.xlsx / field 1

1124 nonblank / 0 blank in local sample

#2DistrictNameNWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Name defined in your MAP preferences.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • No blanks observed in the local sample, but NWEA pass-through columns remain nullable unless NWEA explicitly requires otherwise.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

Relationships
  • Reconciliation field from NWEA/MAP preferences; not canonical tenant routing.
Edge casesNone specified.

Example
Example District

Source
MAP_Export_Field_Descriptions.xlsx / field 2

1124 nonblank / 0 blank in local sample

#3District_StateIDNWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

District code you have set in MAP preferences.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 1124 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
Example District

Source
MAP_Export_Field_Descriptions.xlsx / field 3

0 nonblank / 1124 blank in local sample

#4SchoolNameNWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Name defined in your MAP preferences. If a student has multiple schools, this is the student's School of Record.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • No blanks observed in the local sample, but NWEA pass-through columns remain nullable unless NWEA explicitly requires otherwise.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

Relationships
  • NWEA school-of-record label; not canonical tenant routing.
Edge casesNone specified.

Example
Example School

Source
MAP_Export_Field_Descriptions.xlsx / field 4

1124 nonblank / 0 blank in local sample

#5School_StateIDNWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

State code for the school associated with the student.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 1124 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
Example School

Source
MAP_Export_Field_Descriptions.xlsx / field 5

0 nonblank / 1124 blank in local sample

#6StudentLastNameNWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Name in student's MAP profile.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • No blanks observed in the local sample, but NWEA pass-through columns remain nullable unless NWEA explicitly requires otherwise.
  • Student/teacher identifiers and names are tenant-scoped PII or quasi-identifiers; redact from logs and public error bodies.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
Example

Source
MAP_Export_Field_Descriptions.xlsx / field 6

1124 nonblank / 0 blank in local sample

#7StudentFirstNameNWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Name in student's MAP profile.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • No blanks observed in the local sample, but NWEA pass-through columns remain nullable unless NWEA explicitly requires otherwise.
  • Student/teacher identifiers and names are tenant-scoped PII or quasi-identifiers; redact from logs and public error bodies.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
Example

Source
MAP_Export_Field_Descriptions.xlsx / field 7

1124 nonblank / 0 blank in local sample

#8StudentMINWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Student's middle initial or middle name.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 1124 blank value(s); migration must allow blank/null.
  • Student/teacher identifiers and names are tenant-scoped PII or quasi-identifiers; redact from logs and public error bodies.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
example-value

Source
MAP_Export_Field_Descriptions.xlsx / field 8

0 nonblank / 1124 blank in local sample

#9StudentIDNWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

ID your district provided in the student's MAP profile.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • No blanks observed in the local sample, but NWEA pass-through columns remain nullable unless NWEA explicitly requires otherwise.
  • Student/teacher identifiers and names are tenant-scoped PII or quasi-identifiers; redact from logs and public error bodies.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

Relationships
  • Student identifier repeats across CDF collections inside the same tenant, NWEA account, and term; it is not globally unique.
Edge casesNone specified.

Example
stu-12345

Source
MAP_Export_Field_Descriptions.xlsx / field 9

1124 nonblank / 0 blank in local sample

#10Student_StateIDNWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

ID your state uses to identify the student.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 1124 blank value(s); migration must allow blank/null.
  • Student/teacher identifiers and names are tenant-scoped PII or quasi-identifiers; redact from logs and public error bodies.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

Relationships
  • State student identifier is optional and may be blank; never use it as the only join key.
Edge casesNone specified.

Example
example-value

Source
MAP_Export_Field_Descriptions.xlsx / field 10

0 nonblank / 1124 blank in local sample

#11StudentDateOfBirthNWEA pass-through String
10 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Birth date in student's MAP profile.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 10 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • No blanks observed in the local sample, but NWEA pass-through columns remain nullable unless NWEA explicitly requires otherwise.
  • Student birth date is PII; preserve source value only in tenant-authorized storage and never expose in logs or Problem detail.
  • Student/teacher identifiers and names are tenant-scoped PII or quasi-identifiers; redact from logs and public error bodies.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
01/15/2012

Source
MAP_Export_Field_Descriptions.xlsx / field 11

1124 nonblank / 0 blank in local sample

#12StudentEthnicGroupNWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Name defined in your MAP preferences and assigned to this student.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • No blanks observed in the local sample, but NWEA pass-through columns remain nullable unless NWEA explicitly requires otherwise.
  • Student/teacher identifiers and names are tenant-scoped PII or quasi-identifiers; redact from logs and public error bodies.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
example-value

Source
MAP_Export_Field_Descriptions.xlsx / field 12

1124 nonblank / 0 blank in local sample

#13NWEAStandard_EthnicGroupNWEA pass-through String
50 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Default name from NWEA that is associated with your custom Ethnic Group name. Included here to help clarify the data shown in the prior column.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 50 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • No blanks observed in the local sample, but NWEA pass-through columns remain nullable unless NWEA explicitly requires otherwise.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
example-value

Source
MAP_Export_Field_Descriptions.xlsx / field 13

1124 nonblank / 0 blank in local sample

#14StudentGenderNWEA pass-through String
50 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Either M (male), F (female), or X.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 50 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • No blanks observed in the local sample, but NWEA pass-through columns remain nullable unless NWEA explicitly requires otherwise.
  • Student/teacher identifiers and names are tenant-scoped PII or quasi-identifiers; redact from logs and public error bodies.
  • M - Male, as exported by NWEA.
  • F - Female, as exported by NWEA.
  • X - NWEA's non-binary/other gender code.
  • blank - No value was exported; preserve blank rather than guessing.
RelationshipsNone specified.Edge casesNone specified.

Example
F

Source
MAP_Export_Field_Descriptions.xlsx / field 14

1124 nonblank / 0 blank in local sample

#15GradeNWEA pass-through String
2 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Grade assigned to this student, based on the names defined in your MAP preferences.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 2 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • No blanks observed in the local sample, but NWEA pass-through columns remain nullable unless NWEA explicitly requires otherwise.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
3

Source
MAP_Export_Field_Descriptions.xlsx / field 15

1124 nonblank / 0 blank in local sample

#16NWEAStandard_GradeNWEA pass-through String
2 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Default name from NWEA that is associated with your custom Grade name. Included here to help clarify the data shown in the Grade column.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 2 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • No blanks observed in the local sample, but NWEA pass-through columns remain nullable unless NWEA explicitly requires otherwise.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
3

Source
MAP_Export_Field_Descriptions.xlsx / field 16

1124 nonblank / 0 blank in local sample

NWEA pass-through raw table

nweamap.raw_assessment_results Assessment results raw CDF rows

Purpose

Lossless mirror of NWEA assessment result rows, including growth-window, goal, Lexile/Quantile, norms, and projected-proficiency columns.

Lifecycle

Created by CDF import or refreshed by later CDF backfill; rows remain visible to authorized audit reads with sittingScope=all and includeDeleted=true.

Public endpoint

GET /nweamap/v1/assessment-results?sittingScope=all

Relationships
  • TestID connects one assessment result to zero or more accommodation assignment rows.
  • TestRITScore, TestStartDate, TestStartTime, and TestID drive the test-of-record selector.
CDF source AssessmentResults.csv / workbook sheet AssessmentResults.csv 143 NWEA fields, 3491 local sample rows.

Platform sidecar fields

FieldType and nullabilityMeaning and constraintsAllowed valuesRelationships and edge casesExample and provenance
row_idPlatform gap-fill UUID
Platform-owned
Required; primary key.

Stable row identifier assigned by the platform for this mirrored CDF row.

Constraints
  • Unique within this table.
  • Never derived from student identity or NWEA row text.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
018f4b4e-9c7a-7d3d-8b2f-2f673a000001

Source
NWEAMap architecture gap fill

Platform-owned field

tenant_idPlatform gap-fill UUID
Platform-owned
Required.

Platform tenant boundary from the verified JWT; this is the authorization scope for the row.

Constraints
  • Must match the caller's JWT tenantId for writes and reads.
  • References platform.tenant(tenant_id).

Platform-owned values are closed when listed here.

Relationships
  • Belongs to exactly one platform.tenant row.
Edge casesNone specified.

Example
018f4b4e-9c7a-7d3d-8b2f-2f673a000001

Source
NWEAMap architecture gap fill

Platform-owned field

nwea_account_idPlatform gap-fill TEXT
Platform-owned
Required.

Tenant-local NWEA account partition for the imported bundle.

Constraints
  • Required for imports and list filters.
  • Not globally unique outside tenant_id.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
nwea-account-demo

Source
NWEAMap architecture gap fill

Platform-owned field

import_idPlatform gap-fill UUID
Platform-owned
Required.

Import bundle that created or last refreshed this row.

Constraints
  • References nweamap.import(import_id).

Platform-owned values are closed when listed here.

Relationships
  • Many raw rows belong to one import bundle.
Edge casesNone specified.

Example
018f4b4e-9c7a-7d3d-8b2f-2f673a000001

Source
NWEAMap architecture gap fill

Platform-owned field

import_file_idPlatform gap-fill UUID
Platform-owned
Required.

Import-file record for the CDF file that carried this row.

Constraints
  • References nweamap.import_file(import_file_id).

Platform-owned values are closed when listed here.

Relationships
  • Many raw rows belong to one import file.
Edge casesNone specified.

Example
018f4b4e-9c7a-7d3d-8b2f-2f673a000001

Source
NWEAMap architecture gap fill

Platform-owned field

source_filePlatform gap-fill TEXT enum
Platform-owned
Required.

Exact CDF file name whose header and row content produced this row.

Constraints
  • Must be one of the five Comprehensive Data File names.
  • StudentsBySchool.csv - One required or optional file in the Comprehensive Data File bundle.
  • AssessmentResults.csv - One required or optional file in the Comprehensive Data File bundle.
  • ClassAssignments.csv - One required or optional file in the Comprehensive Data File bundle.
  • ProgramAssignments.csv - One required or optional file in the Comprehensive Data File bundle.
  • AccommodationAssignment.csv - One required or optional file in the Comprehensive Data File bundle.
RelationshipsNone specified.Edge casesNone specified.

Example
AssessmentResults.csv

Source
NWEAMap architecture gap fill

Platform-owned field

source_row_numberPlatform gap-fill INTEGER
Platform-owned
Required.

One-based data-row number inside the CDF file, excluding the header.

Constraints
  • Must be >= 1.
  • Stable only within the import_file_id.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
42

Source
NWEAMap architecture gap fill

Platform-owned field

source_row_hashPlatform gap-fill TEXT
Platform-owned
Required.

Canonical hash of the source-file name, header position, and row values used for idempotent re-import and missing-row detection.

Constraints
  • SHA-256 hex or sha256-prefixed digest.
  • Same row content in the same file scope must produce the same hash.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
sha256:2d3f6b4e8c1a0f9b7e6d5c4b3a291807060504030201000ffeeddbbccaa9988

Source
NWEAMap architecture gap fill

Platform-owned field

ingested_atPlatform gap-fill TIMESTAMPTZ
Platform-owned
Required.

Timestamp when the platform accepted this row into tenant-scoped persistence.

Constraints
  • Must be UTC.
  • Used for audit and modifiedSince behavior.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
2026-06-03T11:00:00Z

Source
NWEAMap architecture gap fill

Platform-owned field

modified_atPlatform gap-fill TIMESTAMPTZ
Platform-owned
Required.

Timestamp when the row or its deletion/projection state last changed.

Constraints
  • Must be UTC.
  • Must be greater than or equal to ingested_at.
  • Powers modifiedSince polling.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
2026-06-03T11:00:00Z

Source
NWEAMap architecture gap fill

Platform-owned field

deleted_atPlatform gap-fill TIMESTAMPTZ
Platform-owned
Nullable.

Soft-delete timestamp set when a replacement authoritative export stops sending this source row.

Constraints
  • Null means active.
  • Non-null rows are excluded from test_of_record.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge cases
  • Soft delete is retention evidence, not a legal erasure API.

Example
2026-06-03T11:00:00Z

Source
NWEAMap architecture gap fill

Platform-owned field

deleted_by_import_idPlatform gap-fill UUID
Platform-owned
Nullable.

Replacement import that caused this row to be marked deleted.

Constraints
  • References nweamap.import(import_id) when present.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
018f4b4e-9c7a-7d3d-8b2f-2f673a000001

Source
NWEAMap architecture gap fill

Platform-owned field

delete_reasonPlatform gap-fill TEXT enum
Platform-owned
Nullable.

Platform explanation for why the row disappeared from a later authoritative export, when inferable.

Constraints
  • Must be null or one of the documented delete_reason values.
  • missing_from_replacement_export - A later authoritative export for the same scope stopped sending the row.
  • retake_superseded - Import evidence indicates the row was replaced by a retake.
  • invalidated_or_suppressed_by_nwea - Import evidence indicates NWEA invalidated or suppressed the sitting.
  • unknown - The row disappeared but the specific reason was not inferable.
RelationshipsNone specified.Edge casesNone specified.

Example
missing_from_replacement_export

Source
NWEAMap architecture gap fill

Platform-owned field

NWEA pass-through fields

FieldType and nullabilityMeaning and constraintsAllowed valuesRelationships and edge casesExample and provenance
#1TermNameNWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Term chosen for the export.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • No blanks observed in the local sample, but NWEA pass-through columns remain nullable unless NWEA explicitly requires otherwise.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

Relationships
  • Term scope is paired with tenant_id and nwea_account_id; term strings are pass-through NWEA values, not parsed by client skill packs.
Edge casesNone specified.

Example
Spring 2025-2026

Source
MAP_Export_Field_Descriptions.xlsx / field 1

3491 nonblank / 0 blank in local sample

#2DistrictNameNWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Name defined in your MAP preferences.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • No blanks observed in the local sample, but NWEA pass-through columns remain nullable unless NWEA explicitly requires otherwise.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

Relationships
  • Reconciliation field from NWEA/MAP preferences; not canonical tenant routing.
Edge casesNone specified.

Example
Example District

Source
MAP_Export_Field_Descriptions.xlsx / field 2

3491 nonblank / 0 blank in local sample

#3District_StateIDNWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

District code you have set in MAP preferences.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
Example District

Source
MAP_Export_Field_Descriptions.xlsx / field 3

0 nonblank / 3491 blank in local sample

#4SchoolNameNWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Name defined in your MAP preferences. If a student has multiple schools, this is the student's School of Record.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • No blanks observed in the local sample, but NWEA pass-through columns remain nullable unless NWEA explicitly requires otherwise.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

Relationships
  • NWEA school-of-record label; not canonical tenant routing.
Edge casesNone specified.

Example
Example School

Source
MAP_Export_Field_Descriptions.xlsx / field 4

3491 nonblank / 0 blank in local sample

#5School_StateIDNWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

State code for the school associated with the student.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
Example School

Source
MAP_Export_Field_Descriptions.xlsx / field 5

0 nonblank / 3491 blank in local sample

#6StudentIDNWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

ID your district provided in the student's MAP profile.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • No blanks observed in the local sample, but NWEA pass-through columns remain nullable unless NWEA explicitly requires otherwise.
  • Student/teacher identifiers and names are tenant-scoped PII or quasi-identifiers; redact from logs and public error bodies.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

Relationships
  • Student identifier repeats across CDF collections inside the same tenant, NWEA account, and term; it is not globally unique.
Edge casesNone specified.

Example
stu-12345

Source
MAP_Export_Field_Descriptions.xlsx / field 6

3491 nonblank / 0 blank in local sample

#7Student_StateIDNWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

ID your state uses to identify the student.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.
  • Student/teacher identifiers and names are tenant-scoped PII or quasi-identifiers; redact from logs and public error bodies.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

Relationships
  • State student identifier is optional and may be blank; never use it as the only join key.
Edge casesNone specified.

Example
example-value

Source
MAP_Export_Field_Descriptions.xlsx / field 7

0 nonblank / 3491 blank in local sample

#8SubjectNWEA pass-through String
65 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

The test content area.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 65 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • No blanks observed in the local sample, but NWEA pass-through columns remain nullable unless NWEA explicitly requires otherwise.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
Math

Source
MAP_Export_Field_Descriptions.xlsx / field 8

3491 nonblank / 0 blank in local sample

#9CourseNWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Specific content and RIT scale.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • No blanks observed in the local sample, but NWEA pass-through columns remain nullable unless NWEA explicitly requires otherwise.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
Growth: Math 6+

Source
MAP_Export_Field_Descriptions.xlsx / field 9

3491 nonblank / 0 blank in local sample

#10GrowthMeasureYNNWEA pass-through String
5 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Indicates which test result counts toward a student's growth measure, marked TRUE. If a student has multiple results for the same test and term, then the other results will appear FALSE.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 5 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • No blanks observed in the local sample, but NWEA pass-through columns remain nullable unless NWEA explicitly requires otherwise.
  • TRUE - NWEA marks this test event as counting toward its growth measure.
  • FALSE - NWEA marks this as an additional result for the same test/term.
  • blank - No official flag was exported; TimeBack still evaluates test_of_record by highest valid RIT.
RelationshipsNone specified.Edge cases
  • NWEA's TRUE flag is preserved, but TimeBack test_of_record can choose a different sitting when highest valid RIT wins.

Example
TRUE

Source
MAP_Export_Field_Descriptions.xlsx / field 10

3491 nonblank / 0 blank in local sample

#11NormsReferenceDataNWEA pass-through Integer
4 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Indicates which NWEA norms study applies to cacluations like projected growth. For most tests, norms are 2020. The 2015 norms option was removed December 2023. Other tests utilize "USER" norms. In a few cases, tests have no related norms and will appear blank here.

Constraints
  • NWEA datatype: Integer.
  • NWEA length/range: 4 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • No blanks observed in the local sample, but NWEA pass-through columns remain nullable unless NWEA explicitly requires otherwise.
  • 2020 - NWEA 2020 norms reference data.
  • 2025 - NWEA 2025 norms reference data observed in the local CDF sample and preserved verbatim.
  • USER - NWEA user-defined norms, when exported.
  • blank - NWEA exported no related norms study for the test.
RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.
  • Preserve the exported norms identifier verbatim; any norms-flipped report calculation belongs to a separately approved Alpha surface.

Example
2025

Source
MAP_Export_Field_Descriptions.xlsx / field 11

3491 nonblank / 0 blank in local sample

#12WISelectedAYFallNWEA pass-through Integer
2 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Weeks of Instruction (WI) before testing in the fall term of the same academic year (AY) as the term selected at export. The WI number comes from the Manage Terms settings within MAP. --Value is blank if the student did not have a valid test event in fall.

Constraints
  • NWEA datatype: Integer.
  • NWEA length/range: 2 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 2256 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.

Example
1

Source
MAP_Export_Field_Descriptions.xlsx / field 12

1235 nonblank / 2256 blank in local sample

#13WISelectedAYWinterNWEA pass-through Integer
2 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Weeks of Instruction (WI) before testing in the winter term of the same academic year (AY) as the term selected at export. The WI number comes from the Manage Terms settings within MAP. --Value is blank if the student did not have a valid test event in winter.

Constraints
  • NWEA datatype: Integer.
  • NWEA length/range: 2 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 1973 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.

Example
1

Source
MAP_Export_Field_Descriptions.xlsx / field 13

1518 nonblank / 1973 blank in local sample

#14WISelectedAYSpringNWEA pass-through Integer
2 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Weeks of Instruction (WI) before testing in the spring term of the same academic year (AY) as the term selected at export. The WI number comes from the Manage Terms settings within MAP. --Value is blank if the student did not have a valid test event in spring.

Constraints
  • NWEA datatype: Integer.
  • NWEA length/range: 2 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • No blanks observed in the local sample, but NWEA pass-through columns remain nullable unless NWEA explicitly requires otherwise.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.

Example
1

Source
MAP_Export_Field_Descriptions.xlsx / field 14

3491 nonblank / 0 blank in local sample

#15WIPreviousAYFallNWEA pass-through Integer
2 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Weeks of Instruction (WI) before testing in the fall term of the academic year (AY) previous to the term selected at export. The WI number comes from the Manage Terms settings within MAP. --Value is blank if the student did not have a valid test event in fall.

Constraints
  • NWEA datatype: Integer.
  • NWEA length/range: 2 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.

Example
1

Source
MAP_Export_Field_Descriptions.xlsx / field 15

0 nonblank / 3491 blank in local sample

#16WIPreviousAYWinterNWEA pass-through Integer
2 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Weeks of Instruction (WI) before testing in the winter term of the academic year (AY) previous to the term selected at export. The WI number comes from the Manage Terms settings within MAP. --Value is blank if the student did not have a valid test event in winter.

Constraints
  • NWEA datatype: Integer.
  • NWEA length/range: 2 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.

Example
1

Source
MAP_Export_Field_Descriptions.xlsx / field 16

0 nonblank / 3491 blank in local sample

#17WIPreviousAYSpringNWEA pass-through Integer
2 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Weeks of Instruction (WI) before testing in the spring term of the academic year (AY) previous to the term selected at export. The WI number comes from the Manage Terms settings within MAP. --Value is blank if the student did not have a valid test event in spring.

Constraints
  • NWEA datatype: Integer.
  • NWEA length/range: 2 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 2944 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.

Example
1

Source
MAP_Export_Field_Descriptions.xlsx / field 17

547 nonblank / 2944 blank in local sample

#18TestTypeNWEA pass-through String
50 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Description of the test type (either "Survey with Goals" or "Survey").

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 50 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • No blanks observed in the local sample, but NWEA pass-through columns remain nullable unless NWEA explicitly requires otherwise.
  • Survey With Goals - MAP test type with goal-area rows available.
  • Survey - MAP survey test type; goal fields may be blank.
RelationshipsNone specified.Edge casesNone specified.

Example
Survey With Goals

Source
MAP_Export_Field_Descriptions.xlsx / field 18

3491 nonblank / 0 blank in local sample

#19TestNameNWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Full name of the test.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • No blanks observed in the local sample, but NWEA pass-through columns remain nullable unless NWEA explicitly requires otherwise.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
Growth: Math 6+

Source
MAP_Export_Field_Descriptions.xlsx / field 19

3491 nonblank / 0 blank in local sample

#20TestIDNWEA pass-through Integer
10 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Unique identifier for the test event. This ID also appears in the AccommodationAssignment.csv file so you can connect that data to this test event.

Constraints
  • NWEA datatype: Integer.
  • NWEA length/range: 10 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • No blanks observed in the local sample, but NWEA pass-through columns remain nullable unless NWEA explicitly requires otherwise.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

Relationships
  • Parent test event for AccommodationAssignment.TestID; also the final tie-breaker for test_of_record when RIT and start time tie.
Edge casesNone specified.

Example
1110000001

Source
MAP_Export_Field_Descriptions.xlsx / field 20

3491 nonblank / 0 blank in local sample

#21TestStartDateNWEA pass-through String
10 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Date the test was started, as recorded by the workstation where the test was taken.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 10 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • No blanks observed in the local sample, but NWEA pass-through columns remain nullable unless NWEA explicitly requires otherwise.
  • NWEA workbook uses an MM/DD/YYYY-style date string in the CDF export.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
05/21/2026

Source
MAP_Export_Field_Descriptions.xlsx / field 21

3491 nonblank / 0 blank in local sample

#22TestStartTimeNWEA pass-through String
8 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Time the test was started with the format hh:mm:ss.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 8 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • No blanks observed in the local sample, but NWEA pass-through columns remain nullable unless NWEA explicitly requires otherwise.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
09:14:33

Source
MAP_Export_Field_Descriptions.xlsx / field 22

3491 nonblank / 0 blank in local sample

#23TestDurationMinutesNWEA pass-through Integer
13 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Total testing time.

Constraints
  • NWEA datatype: Integer.
  • NWEA length/range: 13 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • No blanks observed in the local sample, but NWEA pass-through columns remain nullable unless NWEA explicitly requires otherwise.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
43

Source
MAP_Export_Field_Descriptions.xlsx / field 23

3491 nonblank / 0 blank in local sample

#24TestRITScoreNWEA pass-through Integer
3 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Overall RIT score of the test. Appears as a whole, integer number.

Constraints
  • NWEA datatype: Integer.
  • NWEA length/range: 3 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • No blanks observed in the local sample, but NWEA pass-through columns remain nullable unless NWEA explicitly requires otherwise.
  • TimeBack test_of_record eligibility requires numeric MAP RIT from 100 through 350; invalid values remain visible only in all-sittings reads.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Rows outside valid RIT 100-350 are retained in all-sittings audit reads but excluded from test_of_record.

Example
238

Source
MAP_Export_Field_Descriptions.xlsx / field 24

3491 nonblank / 0 blank in local sample

#25TestStandardErrorNWEA pass-through Number
3 characters, 1 decimal
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

RIT score variance.

Constraints
  • NWEA datatype: Number.
  • NWEA length/range: 3 characters, 1 decimal.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • No blanks observed in the local sample, but NWEA pass-through columns remain nullable unless NWEA explicitly requires otherwise.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
3.4

Source
MAP_Export_Field_Descriptions.xlsx / field 25

3491 nonblank / 0 blank in local sample

#26TestPercentileNWEA pass-through Integer
2 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Student ranking, based on the RIT score of this test as compared to the NWEA norm study.

Constraints
  • NWEA datatype: Integer.
  • NWEA length/range: 2 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 52 blank value(s); migration must allow blank/null.
  • Percentile-like values are expected to be whole-number national percentile ranks when populated.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
54

Source
MAP_Export_Field_Descriptions.xlsx / field 26

3439 nonblank / 52 blank in local sample

#27AchievementQuintileNWEA pass-through String
12 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Up to 20th percentile = “Low" 21st to 40th percentile = “LoAvg" 41st to 60th percentile = “Avg" 61st to 80th percentile = "HiAvg" 81st percentile and above = “High" If the TestPercentile is blank, this field will also be blank.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 12 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 52 blank value(s); migration must allow blank/null.
  • Low - Up to 20th percentile.
  • LoAvg - 21st through 40th percentile.
  • Avg - 41st through 60th percentile.
  • HiAvg - 61st through 80th percentile.
  • High - 81st percentile and above.
  • blank - No percentile/adjective was exported for this field.
RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.

Example
Avg

Source
MAP_Export_Field_Descriptions.xlsx / field 27

3439 nonblank / 52 blank in local sample

#28PercentCorrectNWEA pass-through Integer
2 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Number of items answered correctly divided by the total number of items in the test, multiplied by 100. Items that are not scored, such as field test and familiarity items, are not included in the calculation. This field provides an additional reference point for those assessing the confidence level of a test event's RIT score. When approximately 40% to 60% of items are answered correctly, the student’s responses are consistent with the adaptive test model and the level of confidence in the validity of the RIT score is increased. Used in conjunction with the test duration and standard error of measure, the percent correct can identify test event scores that may be suspect. A test event with too many items answered correctly (for example, more than 60%) can be an indicator that the test was not well targeted for the student’s performance level. In other words, the items presented were not sufficiently appropriate for the student’s level of proficiency (generally too easy). A test event with too few items answered correctly can be an indicator that the student was not fully engaged. For example, the student may have given random answers to questions or may have purposely answered questions incorrectly.

Constraints
  • NWEA datatype: Integer.
  • NWEA length/range: 2 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • No blanks observed in the local sample, but NWEA pass-through columns remain nullable unless NWEA explicitly requires otherwise.
  • Percent-like values are expected to be 0 through 100 when populated.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
60

Source
MAP_Export_Field_Descriptions.xlsx / field 28

3491 nonblank / 0 blank in local sample

#29RapidGuessingPercentageNWEA pass-through Number
9 characters, 4 decimals
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Percentage of questions the student completed with rapid guesses, which are well below the average response time measured by NWEA for each test question.

Constraints
  • NWEA datatype: Number.
  • NWEA length/range: 9 characters, 4 decimals.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • No blanks observed in the local sample, but NWEA pass-through columns remain nullable unless NWEA explicitly requires otherwise.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
60

Source
MAP_Export_Field_Descriptions.xlsx / field 29

3491 nonblank / 0 blank in local sample

#30FallToFallProjectedGrowthNWEA pass-through Integer
3 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Projected RIT growth from previous academic year fall term to the fall term chosen at export. Based on previous fall term RIT score and weeks of instruction. --Value is only available if the selected term for export is fall and if growth projection norms exist. --Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: Integer.
  • NWEA length/range: 3 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.

Example
2

Source
MAP_Export_Field_Descriptions.xlsx / field 30

0 nonblank / 3491 blank in local sample

#31FallToFallObservedGrowthNWEA pass-through Integer
3 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Actual growth from previous academic year fall term to the fall term chosen at export. --Value is only available if selected term for export is fall AND if valid RIT score exists for previous academic year fall term. --Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: Integer.
  • NWEA length/range: 3 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.
  • Growth-window fields depend on selected export term and may be blank for windows NWEA cannot calculate.

Example
2

Source
MAP_Export_Field_Descriptions.xlsx / field 31

0 nonblank / 3491 blank in local sample

#32FallToFallObservedGrowthSENWEA pass-through Number
3 characters, 2 decimal
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Standard Error associated with calculation for FalltoFallObservedGrowth. --Value is only available if selected term is fall AND FalltoFallObservedGrowth has a value. --Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: Number.
  • NWEA length/range: 3 characters, 2 decimal.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.
  • Growth-window fields depend on selected export term and may be blank for windows NWEA cannot calculate.

Example
2

Source
MAP_Export_Field_Descriptions.xlsx / field 32

0 nonblank / 3491 blank in local sample

#33FallToFallMetProjectedGrowthNWEA pass-through String
4 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Yes = Student met the projected growth from the previous academic year fall term to the fall term chosen at export. No = Growth projection not met. Asterisk (*) = Observed Growth Standard Error (SE) could be large enough to put the outcome in question, so evaluate in combination with other points of data. --Value is only available if selected term is fall AND FalltoFallObservedGrowth has a value. --Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 4 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.
  • Yes - Observed growth met or exceeded NWEA's projected growth.
  • No - Observed growth did not meet NWEA's projected growth.
  • No* - NWEA-exported not-met value with an asterisk; preserve verbatim and do not collapse to No.
  • blank - NWEA did not export this growth-window calculation for the row.
RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.

Example
2

Source
MAP_Export_Field_Descriptions.xlsx / field 33

0 nonblank / 3491 blank in local sample

#34FallToFallConditionalGrowthIndexNWEA pass-through Number
3 characters, 2 decimal
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Calculation that enables you to compare student growth. Measures growth from the previous academic year fall term to the fall term chosen at export. It incorporates: --weeks of instruction before testing --how high students scored in the first term A value of zero (0) corresponds to the mean (typical) growth, indicating that growth exactly matched projections. --Value is only available if selected term is fall AND FalltoFallObservedGrowth has a value. --Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: Number.
  • NWEA length/range: 3 characters, 2 decimal.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.

Example
1.0

Source
MAP_Export_Field_Descriptions.xlsx / field 34

0 nonblank / 3491 blank in local sample

#35FallToFallConditionalGrowthPercentileNWEA pass-through Number
2 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Translates the Conditional Growth Index to national percentile rankings for growth. Measures growth from the previous academic year fall term to the fall term chosen at export. --Value is only available if selected term is fall AND FalltoFallObservedGrowth has a value. --Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: Number.
  • NWEA length/range: 2 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.
  • Percentile-like values are expected to be whole-number national percentile ranks when populated.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.

Example
54

Source
MAP_Export_Field_Descriptions.xlsx / field 35

0 nonblank / 3491 blank in local sample

#36FallToFallGrowthQuintileNWEA pass-through String
12 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Indicates a quintile for the FalltoFallConditionalGrowthPercentile: Up to 20th percentile = “Low" 21st to 40th percentile = “LoAvg" 41st to 60th percentile = “Avg" 61st to 80th percentile = "HiAvg" 81st percentile and above = “High" If the FalltoFallConditionalGrowthPercentile is blank, this field will also be blank.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 12 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.
  • Low - Up to 20th percentile.
  • LoAvg - 21st through 40th percentile.
  • Avg - 41st through 60th percentile.
  • HiAvg - 61st through 80th percentile.
  • High - 81st percentile and above.
  • blank - No percentile/adjective was exported for this field.
RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.

Example
Avg

Source
MAP_Export_Field_Descriptions.xlsx / field 36

0 nonblank / 3491 blank in local sample

#37FallToWinterProjectedGrowthNWEA pass-through Same as prior 7 columns.
Not specified by NWEA workbook
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Same six fields as for FalltoFall, but comparing fall to winter. See the prior columns for descriptions: FalltoWinterProjectedGrowth FalltoWinterObservedGrowth FalltoWinterObservedGrowthSE FalltoWinterMetProjectedGrowth FalltoWinterConditionalGrowthIndex FalltoWinterConditionalGrowthPercentile FalltoWinterGrowthQuintile

Constraints
  • NWEA datatype: Same as prior 7 columns..
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
2

Source
MAP_Export_Field_Descriptions.xlsx / field 37

0 nonblank / 3491 blank in local sample

#38FallToWinterObservedGrowthNWEA pass-through Integer
3 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for the fall-to-winter growth window. Actual growth from previous academic year fall term to the fall term chosen at export. --Value is only available if selected term for export is fall AND if valid RIT score exists for previous academic year fall term. --Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: Integer.
  • NWEA length/range: 3 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.
  • Growth-window fields depend on selected export term and may be blank for windows NWEA cannot calculate.

Example
2

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv shorthand for FallToWinter; base field 31

0 nonblank / 3491 blank in local sample

#39FallToWinterObservedGrowthSENWEA pass-through Number
3 characters, 2 decimal
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for the fall-to-winter growth window. Standard Error associated with calculation for FalltoFallObservedGrowth. --Value is only available if selected term is fall AND FalltoFallObservedGrowth has a value. --Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: Number.
  • NWEA length/range: 3 characters, 2 decimal.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.
  • Growth-window fields depend on selected export term and may be blank for windows NWEA cannot calculate.

Example
2

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv shorthand for FallToWinter; base field 32

0 nonblank / 3491 blank in local sample

#40FallToWinterMetProjectedGrowthNWEA pass-through String
4 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for the fall-to-winter growth window. Yes = Student met the projected growth from the previous academic year fall term to the fall term chosen at export. No = Growth projection not met. Asterisk (*) = Observed Growth Standard Error (SE) could be large enough to put the outcome in question, so evaluate in combination with other points of data. --Value is only available if selected term is fall AND FalltoFallObservedGrowth has a value. --Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 4 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.
  • Yes - Observed growth met or exceeded NWEA's projected growth.
  • No - Observed growth did not meet NWEA's projected growth.
  • No* - NWEA-exported not-met value with an asterisk; preserve verbatim and do not collapse to No.
  • blank - NWEA did not export this growth-window calculation for the row.
RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.

Example
2

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv shorthand for FallToWinter; base field 33

0 nonblank / 3491 blank in local sample

#41FallToWinterConditionalGrowthIndexNWEA pass-through Number
3 characters, 2 decimal
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for the fall-to-winter growth window. Calculation that enables you to compare student growth. Measures growth from the previous academic year fall term to the fall term chosen at export. It incorporates: --weeks of instruction before testing --how high students scored in the first term A value of zero (0) corresponds to the mean (typical) growth, indicating that growth exactly matched projections. --Value is only available if selected term is fall AND FalltoFallObservedGrowth has a value. --Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: Number.
  • NWEA length/range: 3 characters, 2 decimal.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.

Example
1.0

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv shorthand for FallToWinter; base field 34

0 nonblank / 3491 blank in local sample

#42FallToWinterConditionalGrowthPercentileNWEA pass-through Number
2 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for the fall-to-winter growth window. Translates the Conditional Growth Index to national percentile rankings for growth. Measures growth from the previous academic year fall term to the fall term chosen at export. --Value is only available if selected term is fall AND FalltoFallObservedGrowth has a value. --Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: Number.
  • NWEA length/range: 2 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.
  • Percentile-like values are expected to be whole-number national percentile ranks when populated.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.

Example
54

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv shorthand for FallToWinter; base field 35

0 nonblank / 3491 blank in local sample

#43FallToWinterGrowthQuintileNWEA pass-through String
12 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for the fall-to-winter growth window. Indicates a quintile for the FalltoFallConditionalGrowthPercentile: Up to 20th percentile = “Low" 21st to 40th percentile = “LoAvg" 41st to 60th percentile = “Avg" 61st to 80th percentile = "HiAvg" 81st percentile and above = “High" If the FalltoFallConditionalGrowthPercentile is blank, this field will also be blank.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 12 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.
  • Low - Up to 20th percentile.
  • LoAvg - 21st through 40th percentile.
  • Avg - 41st through 60th percentile.
  • HiAvg - 61st through 80th percentile.
  • High - 81st percentile and above.
  • blank - No percentile/adjective was exported for this field.
RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.

Example
Avg

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv shorthand for FallToWinter; base field 36

0 nonblank / 3491 blank in local sample

#44FallToSpringProjectedGrowthNWEA pass-through Same as prior 7 columns.
Not specified by NWEA workbook
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Same six fields as for FalltoFall, but comparing fall to spring. See the prior columns for descriptions: FalltoSpringProjectedGrowth FalltoSpringObservedGrowth FalltoSpringObservedGrowthSE FalltoSpringMetProjectedGrowth FalltoSpringConditionalGrowthIndex FalltoSpringConditionalGrowthPercentile FalltoSpringGrowthQuintile

Constraints
  • NWEA datatype: Same as prior 7 columns..
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 2280 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
2

Source
MAP_Export_Field_Descriptions.xlsx / field 44

1211 nonblank / 2280 blank in local sample

#45FallToSpringObservedGrowthNWEA pass-through Integer
3 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for the fall-to-spring growth window. Actual growth from previous academic year fall term to the fall term chosen at export. --Value is only available if selected term for export is fall AND if valid RIT score exists for previous academic year fall term. --Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: Integer.
  • NWEA length/range: 3 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 2256 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.
  • Growth-window fields depend on selected export term and may be blank for windows NWEA cannot calculate.

Example
2

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv shorthand for FallToSpring; base field 31

1235 nonblank / 2256 blank in local sample

#46FallToSpringObservedGrowthSENWEA pass-through Number
3 characters, 2 decimal
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for the fall-to-spring growth window. Standard Error associated with calculation for FalltoFallObservedGrowth. --Value is only available if selected term is fall AND FalltoFallObservedGrowth has a value. --Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: Number.
  • NWEA length/range: 3 characters, 2 decimal.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 2256 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.
  • Growth-window fields depend on selected export term and may be blank for windows NWEA cannot calculate.

Example
2

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv shorthand for FallToSpring; base field 32

1235 nonblank / 2256 blank in local sample

#47FallToSpringMetProjectedGrowthNWEA pass-through String
4 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for the fall-to-spring growth window. Yes = Student met the projected growth from the previous academic year fall term to the fall term chosen at export. No = Growth projection not met. Asterisk (*) = Observed Growth Standard Error (SE) could be large enough to put the outcome in question, so evaluate in combination with other points of data. --Value is only available if selected term is fall AND FalltoFallObservedGrowth has a value. --Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 4 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 2280 blank value(s); migration must allow blank/null.
  • Yes - Observed growth met or exceeded NWEA's projected growth.
  • No - Observed growth did not meet NWEA's projected growth.
  • No* - NWEA-exported not-met value with an asterisk; preserve verbatim and do not collapse to No.
  • blank - NWEA did not export this growth-window calculation for the row.
RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.

Example
2

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv shorthand for FallToSpring; base field 33

1211 nonblank / 2280 blank in local sample

#48FallToSpringConditionalGrowthIndexNWEA pass-through Number
3 characters, 2 decimal
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for the fall-to-spring growth window. Calculation that enables you to compare student growth. Measures growth from the previous academic year fall term to the fall term chosen at export. It incorporates: --weeks of instruction before testing --how high students scored in the first term A value of zero (0) corresponds to the mean (typical) growth, indicating that growth exactly matched projections. --Value is only available if selected term is fall AND FalltoFallObservedGrowth has a value. --Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: Number.
  • NWEA length/range: 3 characters, 2 decimal.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 2280 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.

Example
1.0

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv shorthand for FallToSpring; base field 34

1211 nonblank / 2280 blank in local sample

#49FallToSpringConditionalGrowthPercentileNWEA pass-through Number
2 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for the fall-to-spring growth window. Translates the Conditional Growth Index to national percentile rankings for growth. Measures growth from the previous academic year fall term to the fall term chosen at export. --Value is only available if selected term is fall AND FalltoFallObservedGrowth has a value. --Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: Number.
  • NWEA length/range: 2 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 2280 blank value(s); migration must allow blank/null.
  • Percentile-like values are expected to be whole-number national percentile ranks when populated.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.

Example
54

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv shorthand for FallToSpring; base field 35

1211 nonblank / 2280 blank in local sample

#50FallToSpringGrowthQuintileNWEA pass-through String
12 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for the fall-to-spring growth window. Indicates a quintile for the FalltoFallConditionalGrowthPercentile: Up to 20th percentile = “Low" 21st to 40th percentile = “LoAvg" 41st to 60th percentile = “Avg" 61st to 80th percentile = "HiAvg" 81st percentile and above = “High" If the FalltoFallConditionalGrowthPercentile is blank, this field will also be blank.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 12 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 2280 blank value(s); migration must allow blank/null.
  • Low - Up to 20th percentile.
  • LoAvg - 21st through 40th percentile.
  • Avg - 41st through 60th percentile.
  • HiAvg - 61st through 80th percentile.
  • High - 81st percentile and above.
  • blank - No percentile/adjective was exported for this field.
RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.

Example
Avg

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv shorthand for FallToSpring; base field 36

1211 nonblank / 2280 blank in local sample

#51WinterToWinterProjectedGrowthNWEA pass-through Same as prior 7 columns.
Not specified by NWEA workbook
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Same six fields as for FalltoFall, but comparing winter to winter. See the prior columns for descriptions: WintertoWinterProjectedGrowth WintertoWinterObservedGrowth WintertoWinterObservedGrowthSE WintertoWinterMetProjectedGrowth WintertoWinterConditionalGrowthIndex WintertoWinterConditionalGrowthPercentile WintertoWinterGrowthQuintile

Constraints
  • NWEA datatype: Same as prior 7 columns..
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
2

Source
MAP_Export_Field_Descriptions.xlsx / field 51

0 nonblank / 3491 blank in local sample

#52WinterToWinterObservedGrowthNWEA pass-through Integer
3 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for the winter-to-winter growth window. Actual growth from previous academic year fall term to the fall term chosen at export. --Value is only available if selected term for export is fall AND if valid RIT score exists for previous academic year fall term. --Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: Integer.
  • NWEA length/range: 3 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.
  • Growth-window fields depend on selected export term and may be blank for windows NWEA cannot calculate.

Example
2

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv shorthand for WinterToWinter; base field 31

0 nonblank / 3491 blank in local sample

#53WinterToWinterObservedGrowthSENWEA pass-through Number
3 characters, 2 decimal
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for the winter-to-winter growth window. Standard Error associated with calculation for FalltoFallObservedGrowth. --Value is only available if selected term is fall AND FalltoFallObservedGrowth has a value. --Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: Number.
  • NWEA length/range: 3 characters, 2 decimal.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.
  • Growth-window fields depend on selected export term and may be blank for windows NWEA cannot calculate.

Example
2

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv shorthand for WinterToWinter; base field 32

0 nonblank / 3491 blank in local sample

#54WinterToWinterMetProjectedGrowthNWEA pass-through String
4 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for the winter-to-winter growth window. Yes = Student met the projected growth from the previous academic year fall term to the fall term chosen at export. No = Growth projection not met. Asterisk (*) = Observed Growth Standard Error (SE) could be large enough to put the outcome in question, so evaluate in combination with other points of data. --Value is only available if selected term is fall AND FalltoFallObservedGrowth has a value. --Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 4 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.
  • Yes - Observed growth met or exceeded NWEA's projected growth.
  • No - Observed growth did not meet NWEA's projected growth.
  • No* - NWEA-exported not-met value with an asterisk; preserve verbatim and do not collapse to No.
  • blank - NWEA did not export this growth-window calculation for the row.
RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.

Example
2

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv shorthand for WinterToWinter; base field 33

0 nonblank / 3491 blank in local sample

#55WinterToWinterConditionalGrowthIndexNWEA pass-through Number
3 characters, 2 decimal
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for the winter-to-winter growth window. Calculation that enables you to compare student growth. Measures growth from the previous academic year fall term to the fall term chosen at export. It incorporates: --weeks of instruction before testing --how high students scored in the first term A value of zero (0) corresponds to the mean (typical) growth, indicating that growth exactly matched projections. --Value is only available if selected term is fall AND FalltoFallObservedGrowth has a value. --Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: Number.
  • NWEA length/range: 3 characters, 2 decimal.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.

Example
1.0

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv shorthand for WinterToWinter; base field 34

0 nonblank / 3491 blank in local sample

#56WinterToWinterConditionalGrowthPercentileNWEA pass-through Number
2 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for the winter-to-winter growth window. Translates the Conditional Growth Index to national percentile rankings for growth. Measures growth from the previous academic year fall term to the fall term chosen at export. --Value is only available if selected term is fall AND FalltoFallObservedGrowth has a value. --Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: Number.
  • NWEA length/range: 2 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.
  • Percentile-like values are expected to be whole-number national percentile ranks when populated.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.

Example
54

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv shorthand for WinterToWinter; base field 35

0 nonblank / 3491 blank in local sample

#57WinterToWinterGrowthQuintileNWEA pass-through String
12 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for the winter-to-winter growth window. Indicates a quintile for the FalltoFallConditionalGrowthPercentile: Up to 20th percentile = “Low" 21st to 40th percentile = “LoAvg" 41st to 60th percentile = “Avg" 61st to 80th percentile = "HiAvg" 81st percentile and above = “High" If the FalltoFallConditionalGrowthPercentile is blank, this field will also be blank.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 12 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.
  • Low - Up to 20th percentile.
  • LoAvg - 21st through 40th percentile.
  • Avg - 41st through 60th percentile.
  • HiAvg - 61st through 80th percentile.
  • High - 81st percentile and above.
  • blank - No percentile/adjective was exported for this field.
RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.

Example
Avg

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv shorthand for WinterToWinter; base field 36

0 nonblank / 3491 blank in local sample

#58WinterToSpringProjectedGrowthNWEA pass-through Same as prior 7 columns.
Not specified by NWEA workbook
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Same six fields as for FalltoFall, but comparing winter to spring. See the prior columns for descriptions: WintertoSpringProjectedGrowth WintertoSpringObservedGrowth WintertoSpringObservedGrowthSE WintertoSpringMetProjectedGrowth WintertoSpringConditionalGrowthIndex WintertoSpringConditionalGrowthPercentile WintertoSpringGrowthQuintile

Constraints
  • NWEA datatype: Same as prior 7 columns..
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 2003 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
2

Source
MAP_Export_Field_Descriptions.xlsx / field 58

1488 nonblank / 2003 blank in local sample

#59WinterToSpringObservedGrowthNWEA pass-through Integer
3 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for the winter-to-spring growth window. Actual growth from previous academic year fall term to the fall term chosen at export. --Value is only available if selected term for export is fall AND if valid RIT score exists for previous academic year fall term. --Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: Integer.
  • NWEA length/range: 3 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 1973 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.
  • Growth-window fields depend on selected export term and may be blank for windows NWEA cannot calculate.

Example
2

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv shorthand for WinterToSpring; base field 31

1518 nonblank / 1973 blank in local sample

#60WinterToSpringObservedGrowthSENWEA pass-through Number
3 characters, 2 decimal
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for the winter-to-spring growth window. Standard Error associated with calculation for FalltoFallObservedGrowth. --Value is only available if selected term is fall AND FalltoFallObservedGrowth has a value. --Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: Number.
  • NWEA length/range: 3 characters, 2 decimal.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 1973 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.
  • Growth-window fields depend on selected export term and may be blank for windows NWEA cannot calculate.

Example
2

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv shorthand for WinterToSpring; base field 32

1518 nonblank / 1973 blank in local sample

#61WinterToSpringMetProjectedGrowthNWEA pass-through String
4 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for the winter-to-spring growth window. Yes = Student met the projected growth from the previous academic year fall term to the fall term chosen at export. No = Growth projection not met. Asterisk (*) = Observed Growth Standard Error (SE) could be large enough to put the outcome in question, so evaluate in combination with other points of data. --Value is only available if selected term is fall AND FalltoFallObservedGrowth has a value. --Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 4 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 2003 blank value(s); migration must allow blank/null.
  • Yes - Observed growth met or exceeded NWEA's projected growth.
  • No - Observed growth did not meet NWEA's projected growth.
  • No* - NWEA-exported not-met value with an asterisk; preserve verbatim and do not collapse to No.
  • blank - NWEA did not export this growth-window calculation for the row.
RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.

Example
2

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv shorthand for WinterToSpring; base field 33

1488 nonblank / 2003 blank in local sample

#62WinterToSpringConditionalGrowthIndexNWEA pass-through Number
3 characters, 2 decimal
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for the winter-to-spring growth window. Calculation that enables you to compare student growth. Measures growth from the previous academic year fall term to the fall term chosen at export. It incorporates: --weeks of instruction before testing --how high students scored in the first term A value of zero (0) corresponds to the mean (typical) growth, indicating that growth exactly matched projections. --Value is only available if selected term is fall AND FalltoFallObservedGrowth has a value. --Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: Number.
  • NWEA length/range: 3 characters, 2 decimal.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 2003 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.

Example
1.0

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv shorthand for WinterToSpring; base field 34

1488 nonblank / 2003 blank in local sample

#63WinterToSpringConditionalGrowthPercentileNWEA pass-through Number
2 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for the winter-to-spring growth window. Translates the Conditional Growth Index to national percentile rankings for growth. Measures growth from the previous academic year fall term to the fall term chosen at export. --Value is only available if selected term is fall AND FalltoFallObservedGrowth has a value. --Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: Number.
  • NWEA length/range: 2 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 2003 blank value(s); migration must allow blank/null.
  • Percentile-like values are expected to be whole-number national percentile ranks when populated.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.

Example
54

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv shorthand for WinterToSpring; base field 35

1488 nonblank / 2003 blank in local sample

#64WinterToSpringGrowthQuintileNWEA pass-through String
12 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for the winter-to-spring growth window. Indicates a quintile for the FalltoFallConditionalGrowthPercentile: Up to 20th percentile = “Low" 21st to 40th percentile = “LoAvg" 41st to 60th percentile = “Avg" 61st to 80th percentile = "HiAvg" 81st percentile and above = “High" If the FalltoFallConditionalGrowthPercentile is blank, this field will also be blank.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 12 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 2003 blank value(s); migration must allow blank/null.
  • Low - Up to 20th percentile.
  • LoAvg - 21st through 40th percentile.
  • Avg - 41st through 60th percentile.
  • HiAvg - 61st through 80th percentile.
  • High - 81st percentile and above.
  • blank - No percentile/adjective was exported for this field.
RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.

Example
Avg

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv shorthand for WinterToSpring; base field 36

1488 nonblank / 2003 blank in local sample

#65SpringToSpringProjectedGrowthNWEA pass-through Same as prior 7 columns.
Not specified by NWEA workbook
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Same six fields as for FalltoFall, but comparing spring to spring. See the prior columns for descriptions: SpringtoSpringProjectedGrowth SpringtoSpringObservedGrowth SpringtoSpringObservedGrowthSE SpringtoSpringMetProjectedGrowth SpringtoSpringConditionalGrowthIndex SpringtoSpringConditionalGrowthPercentile SpringtoSpringGrowthQuintile

Constraints
  • NWEA datatype: Same as prior 7 columns..
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 2965 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
2

Source
MAP_Export_Field_Descriptions.xlsx / field 65

526 nonblank / 2965 blank in local sample

#66SpringToSpringObservedGrowthNWEA pass-through Integer
3 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for the spring-to-spring growth window. Actual growth from previous academic year fall term to the fall term chosen at export. --Value is only available if selected term for export is fall AND if valid RIT score exists for previous academic year fall term. --Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: Integer.
  • NWEA length/range: 3 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 2944 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.
  • Growth-window fields depend on selected export term and may be blank for windows NWEA cannot calculate.

Example
2

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv shorthand for SpringToSpring; base field 31

547 nonblank / 2944 blank in local sample

#67SpringToSpringObservedGrowthSENWEA pass-through Number
3 characters, 2 decimal
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for the spring-to-spring growth window. Standard Error associated with calculation for FalltoFallObservedGrowth. --Value is only available if selected term is fall AND FalltoFallObservedGrowth has a value. --Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: Number.
  • NWEA length/range: 3 characters, 2 decimal.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 2944 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.
  • Growth-window fields depend on selected export term and may be blank for windows NWEA cannot calculate.

Example
2

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv shorthand for SpringToSpring; base field 32

547 nonblank / 2944 blank in local sample

#68SpringToSpringMetProjectedGrowthNWEA pass-through String
4 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for the spring-to-spring growth window. Yes = Student met the projected growth from the previous academic year fall term to the fall term chosen at export. No = Growth projection not met. Asterisk (*) = Observed Growth Standard Error (SE) could be large enough to put the outcome in question, so evaluate in combination with other points of data. --Value is only available if selected term is fall AND FalltoFallObservedGrowth has a value. --Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 4 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 2965 blank value(s); migration must allow blank/null.
  • Yes - Observed growth met or exceeded NWEA's projected growth.
  • No - Observed growth did not meet NWEA's projected growth.
  • No* - NWEA-exported not-met value with an asterisk; preserve verbatim and do not collapse to No.
  • blank - NWEA did not export this growth-window calculation for the row.
RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.

Example
2

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv shorthand for SpringToSpring; base field 33

526 nonblank / 2965 blank in local sample

#69SpringToSpringConditionalGrowthIndexNWEA pass-through Number
3 characters, 2 decimal
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for the spring-to-spring growth window. Calculation that enables you to compare student growth. Measures growth from the previous academic year fall term to the fall term chosen at export. It incorporates: --weeks of instruction before testing --how high students scored in the first term A value of zero (0) corresponds to the mean (typical) growth, indicating that growth exactly matched projections. --Value is only available if selected term is fall AND FalltoFallObservedGrowth has a value. --Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: Number.
  • NWEA length/range: 3 characters, 2 decimal.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 2965 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.

Example
1.0

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv shorthand for SpringToSpring; base field 34

526 nonblank / 2965 blank in local sample

#70SpringToSpringConditionalGrowthPercentileNWEA pass-through Number
2 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for the spring-to-spring growth window. Translates the Conditional Growth Index to national percentile rankings for growth. Measures growth from the previous academic year fall term to the fall term chosen at export. --Value is only available if selected term is fall AND FalltoFallObservedGrowth has a value. --Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: Number.
  • NWEA length/range: 2 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 2965 blank value(s); migration must allow blank/null.
  • Percentile-like values are expected to be whole-number national percentile ranks when populated.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.

Example
54

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv shorthand for SpringToSpring; base field 35

526 nonblank / 2965 blank in local sample

#71SpringToSpringGrowthQuintileNWEA pass-through String
12 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for the spring-to-spring growth window. Indicates a quintile for the FalltoFallConditionalGrowthPercentile: Up to 20th percentile = “Low" 21st to 40th percentile = “LoAvg" 41st to 60th percentile = “Avg" 61st to 80th percentile = "HiAvg" 81st percentile and above = “High" If the FalltoFallConditionalGrowthPercentile is blank, this field will also be blank.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 12 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 2965 blank value(s); migration must allow blank/null.
  • Low - Up to 20th percentile.
  • LoAvg - 21st through 40th percentile.
  • Avg - 41st through 60th percentile.
  • HiAvg - 61st through 80th percentile.
  • High - 81st percentile and above.
  • blank - No percentile/adjective was exported for this field.
RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.

Example
Avg

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv shorthand for SpringToSpring; base field 36

526 nonblank / 2965 blank in local sample

#72LexileScoreNWEA pass-through String
6 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Available only for Reading tests. Estimated score within the range of Lexile® reading scores resulting from a correlation to NWEA’s RIT score. Lexile® and MetaMetrics® are trademarks of MetaMetrics, Inc., and are registered in the United States and abroad. (Previously named RITtoReadingScore.)

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 6 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 2270 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
830L

Source
MAP_Export_Field_Descriptions.xlsx / field 72

1221 nonblank / 2270 blank in local sample

#73LexileMinNWEA pass-through String
6 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Lower end of the range. (Previously named RITtoReadingMin.)

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 6 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 2270 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
830L

Source
MAP_Export_Field_Descriptions.xlsx / field 73

1221 nonblank / 2270 blank in local sample

#74LexileMaxNWEA pass-through String
6 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Upper end of the range. (Previously named RITtoReadingMax.)

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 6 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 2270 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
830L

Source
MAP_Export_Field_Descriptions.xlsx / field 74

1221 nonblank / 2270 blank in local sample

#75QuantileScoreNWEA pass-through String
6 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Available only for Math K-12 tests. Estimated score within the range of Quantile® mathematics scores resulting from a correlation to NWEA’s RIT score. Quantile® and MetaMetrics® are trademarks of MetaMetrics, Inc., and are registered in the United States and abroad.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 6 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 2223 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
780Q

Source
MAP_Export_Field_Descriptions.xlsx / field 75

1268 nonblank / 2223 blank in local sample

#76QuantileMinNWEA pass-through String
6 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Lower end of the range.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 6 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 2223 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
780Q

Source
MAP_Export_Field_Descriptions.xlsx / field 76

1268 nonblank / 2223 blank in local sample

#77QuantileMaxNWEA pass-through String
6 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Upper end of the range.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 6 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 2223 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
780Q

Source
MAP_Export_Field_Descriptions.xlsx / field 77

1268 nonblank / 2223 blank in local sample

#78Goal1NameNWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Name of first goal section of the test. Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 833 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.
  • Goal fields can be blank for Survey tests without goals.

Example
example-value

Source
MAP_Export_Field_Descriptions.xlsx / field 78

2658 nonblank / 833 blank in local sample

#79Goal1RitScoreNWEA pass-through Integer
3 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

RIT score for the first goal section of the test. Value is rounded to whole, integer value.

Constraints
  • NWEA datatype: Integer.
  • NWEA length/range: 3 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 833 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Goal fields can be blank for Survey tests without goals.

Example
238

Source
MAP_Export_Field_Descriptions.xlsx / field 79

2658 nonblank / 833 blank in local sample

#80Goal1StdErrNWEA pass-through Number
9 characters, 1 decimal
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Standard error for first goal section of the test.

Constraints
  • NWEA datatype: Number.
  • NWEA length/range: 9 characters, 1 decimal.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 833 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
3.4

Source
MAP_Export_Field_Descriptions.xlsx / field 80

2658 nonblank / 833 blank in local sample

#81Goal1RangeNWEA pass-through String
7 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

RIT range based on the standard error and RIT score. *–* indicates that no value range computed.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 7 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 833 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
example-value

Source
MAP_Export_Field_Descriptions.xlsx / field 81

2658 nonblank / 833 blank in local sample

#82Goal1AdjectiveNWEA pass-through String
12 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Goal adjective related to the first goal score. This is defined using the goal score percentile as it relates to a norm set and its associative cut sheet. Values: Low (percentile <= 20) LoAvg (percentile > 20 to <= 40) Avg (percentile > 40 to <= 60) HiAvg (percentile > 60 to <= 80) High (percentile > 80) * (goal adjective could not be computed)

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 12 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 885 blank value(s); migration must allow blank/null.
  • Low - Up to 20th percentile.
  • LoAvg - 21st through 40th percentile.
  • Avg - 41st through 60th percentile.
  • HiAvg - 61st through 80th percentile.
  • High - 81st percentile and above.
  • blank - No percentile/adjective was exported for this field.
RelationshipsNone specified.Edge casesNone specified.

Example
Avg

Source
MAP_Export_Field_Descriptions.xlsx / field 82

2606 nonblank / 885 blank in local sample

#83Goal2NameNWEA pass-through Same five fields as for Goal 1. See the prior 5 columns.
Not specified by NWEA workbook
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Same five fields as Goal 1. See the prior 5 columns.

Constraints
  • NWEA datatype: Same five fields as for Goal 1. See the prior 5 columns..
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 833 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Goal fields can be blank for Survey tests without goals.

Example
example-value

Source
MAP_Export_Field_Descriptions.xlsx / field 83

2658 nonblank / 833 blank in local sample

#84Goal2RitScoreNWEA pass-through Integer
3 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for goal 2. Same field meaning as Goal1RitScore. RIT score for the first goal section of the test. Value is rounded to whole, integer value.

Constraints
  • NWEA datatype: Integer.
  • NWEA length/range: 3 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 833 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Goal fields can be blank for Survey tests without goals.

Example
238

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv Goal2-8 shorthand; base Goal1 field

2658 nonblank / 833 blank in local sample

#85Goal2StdErrNWEA pass-through Number
9 characters, 1 decimal
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for goal 2. Same field meaning as Goal1StdErr. Standard error for first goal section of the test.

Constraints
  • NWEA datatype: Number.
  • NWEA length/range: 9 characters, 1 decimal.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 833 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
3.4

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv Goal2-8 shorthand; base Goal1 field

2658 nonblank / 833 blank in local sample

#86Goal2RangeNWEA pass-through String
7 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for goal 2. Same field meaning as Goal1Range. RIT range based on the standard error and RIT score. *–* indicates that no value range computed.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 7 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 833 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
example-value

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv Goal2-8 shorthand; base Goal1 field

2658 nonblank / 833 blank in local sample

#87Goal2AdjectiveNWEA pass-through String
12 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for goal 2. Same field meaning as Goal1Adjective. Goal adjective related to the first goal score. This is defined using the goal score percentile as it relates to a norm set and its associative cut sheet. Values: Low (percentile <= 20) LoAvg (percentile > 20 to <= 40) Avg (percentile > 40 to <= 60) HiAvg (percentile > 60 to <= 80) High (percentile > 80) * (goal adjective could not be computed)

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 12 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 885 blank value(s); migration must allow blank/null.
  • Low - Up to 20th percentile.
  • LoAvg - 21st through 40th percentile.
  • Avg - 41st through 60th percentile.
  • HiAvg - 61st through 80th percentile.
  • High - 81st percentile and above.
  • blank - No percentile/adjective was exported for this field.
RelationshipsNone specified.Edge casesNone specified.

Example
Avg

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv Goal2-8 shorthand; base Goal1 field

2606 nonblank / 885 blank in local sample

#88Goal3NameNWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for goal 3. Same field meaning as Goal1Name. Name of first goal section of the test. Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 833 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.
  • Goal fields can be blank for Survey tests without goals.

Example
example-value

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv Goal2-8 shorthand; base Goal1 field

2658 nonblank / 833 blank in local sample

#89Goal3RitScoreNWEA pass-through Integer
3 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for goal 3. Same field meaning as Goal1RitScore. RIT score for the first goal section of the test. Value is rounded to whole, integer value.

Constraints
  • NWEA datatype: Integer.
  • NWEA length/range: 3 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 833 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Goal fields can be blank for Survey tests without goals.

Example
238

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv Goal2-8 shorthand; base Goal1 field

2658 nonblank / 833 blank in local sample

#90Goal3StdErrNWEA pass-through Number
9 characters, 1 decimal
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for goal 3. Same field meaning as Goal1StdErr. Standard error for first goal section of the test.

Constraints
  • NWEA datatype: Number.
  • NWEA length/range: 9 characters, 1 decimal.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 833 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
3.4

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv Goal2-8 shorthand; base Goal1 field

2658 nonblank / 833 blank in local sample

#91Goal3RangeNWEA pass-through String
7 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for goal 3. Same field meaning as Goal1Range. RIT range based on the standard error and RIT score. *–* indicates that no value range computed.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 7 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 833 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
example-value

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv Goal2-8 shorthand; base Goal1 field

2658 nonblank / 833 blank in local sample

#92Goal3AdjectiveNWEA pass-through String
12 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for goal 3. Same field meaning as Goal1Adjective. Goal adjective related to the first goal score. This is defined using the goal score percentile as it relates to a norm set and its associative cut sheet. Values: Low (percentile <= 20) LoAvg (percentile > 20 to <= 40) Avg (percentile > 40 to <= 60) HiAvg (percentile > 60 to <= 80) High (percentile > 80) * (goal adjective could not be computed)

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 12 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 885 blank value(s); migration must allow blank/null.
  • Low - Up to 20th percentile.
  • LoAvg - 21st through 40th percentile.
  • Avg - 41st through 60th percentile.
  • HiAvg - 61st through 80th percentile.
  • High - 81st percentile and above.
  • blank - No percentile/adjective was exported for this field.
RelationshipsNone specified.Edge casesNone specified.

Example
Avg

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv Goal2-8 shorthand; base Goal1 field

2606 nonblank / 885 blank in local sample

#93Goal4NameNWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for goal 4. Same field meaning as Goal1Name. Name of first goal section of the test. Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 2374 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.
  • Goal fields can be blank for Survey tests without goals.

Example
example-value

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv Goal2-8 shorthand; base Goal1 field

1117 nonblank / 2374 blank in local sample

#94Goal4RitScoreNWEA pass-through Integer
3 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for goal 4. Same field meaning as Goal1RitScore. RIT score for the first goal section of the test. Value is rounded to whole, integer value.

Constraints
  • NWEA datatype: Integer.
  • NWEA length/range: 3 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 2374 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Goal fields can be blank for Survey tests without goals.

Example
238

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv Goal2-8 shorthand; base Goal1 field

1117 nonblank / 2374 blank in local sample

#95Goal4StdErrNWEA pass-through Number
9 characters, 1 decimal
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for goal 4. Same field meaning as Goal1StdErr. Standard error for first goal section of the test.

Constraints
  • NWEA datatype: Number.
  • NWEA length/range: 9 characters, 1 decimal.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 2374 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
3.4

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv Goal2-8 shorthand; base Goal1 field

1117 nonblank / 2374 blank in local sample

#96Goal4RangeNWEA pass-through String
7 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for goal 4. Same field meaning as Goal1Range. RIT range based on the standard error and RIT score. *–* indicates that no value range computed.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 7 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 2374 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
example-value

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv Goal2-8 shorthand; base Goal1 field

1117 nonblank / 2374 blank in local sample

#97Goal4AdjectiveNWEA pass-through String
12 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for goal 4. Same field meaning as Goal1Adjective. Goal adjective related to the first goal score. This is defined using the goal score percentile as it relates to a norm set and its associative cut sheet. Values: Low (percentile <= 20) LoAvg (percentile > 20 to <= 40) Avg (percentile > 40 to <= 60) HiAvg (percentile > 60 to <= 80) High (percentile > 80) * (goal adjective could not be computed)

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 12 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 2426 blank value(s); migration must allow blank/null.
  • Low - Up to 20th percentile.
  • LoAvg - 21st through 40th percentile.
  • Avg - 41st through 60th percentile.
  • HiAvg - 61st through 80th percentile.
  • High - 81st percentile and above.
  • blank - No percentile/adjective was exported for this field.
RelationshipsNone specified.Edge casesNone specified.

Example
Avg

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv Goal2-8 shorthand; base Goal1 field

1065 nonblank / 2426 blank in local sample

#98Goal5NameNWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for goal 5. Same field meaning as Goal1Name. Name of first goal section of the test. Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.
  • Goal fields can be blank for Survey tests without goals.

Example
example-value

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv Goal2-8 shorthand; base Goal1 field

0 nonblank / 3491 blank in local sample

#99Goal5RitScoreNWEA pass-through Integer
3 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for goal 5. Same field meaning as Goal1RitScore. RIT score for the first goal section of the test. Value is rounded to whole, integer value.

Constraints
  • NWEA datatype: Integer.
  • NWEA length/range: 3 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Goal fields can be blank for Survey tests without goals.

Example
238

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv Goal2-8 shorthand; base Goal1 field

0 nonblank / 3491 blank in local sample

#100Goal5StdErrNWEA pass-through Number
9 characters, 1 decimal
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for goal 5. Same field meaning as Goal1StdErr. Standard error for first goal section of the test.

Constraints
  • NWEA datatype: Number.
  • NWEA length/range: 9 characters, 1 decimal.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
3.4

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv Goal2-8 shorthand; base Goal1 field

0 nonblank / 3491 blank in local sample

#101Goal5RangeNWEA pass-through String
7 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for goal 5. Same field meaning as Goal1Range. RIT range based on the standard error and RIT score. *–* indicates that no value range computed.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 7 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
example-value

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv Goal2-8 shorthand; base Goal1 field

0 nonblank / 3491 blank in local sample

#102Goal5AdjectiveNWEA pass-through String
12 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for goal 5. Same field meaning as Goal1Adjective. Goal adjective related to the first goal score. This is defined using the goal score percentile as it relates to a norm set and its associative cut sheet. Values: Low (percentile <= 20) LoAvg (percentile > 20 to <= 40) Avg (percentile > 40 to <= 60) HiAvg (percentile > 60 to <= 80) High (percentile > 80) * (goal adjective could not be computed)

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 12 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.
  • Low - Up to 20th percentile.
  • LoAvg - 21st through 40th percentile.
  • Avg - 41st through 60th percentile.
  • HiAvg - 61st through 80th percentile.
  • High - 81st percentile and above.
  • blank - No percentile/adjective was exported for this field.
RelationshipsNone specified.Edge casesNone specified.

Example
Avg

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv Goal2-8 shorthand; base Goal1 field

0 nonblank / 3491 blank in local sample

#103Goal6NameNWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for goal 6. Same field meaning as Goal1Name. Name of first goal section of the test. Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.
  • Goal fields can be blank for Survey tests without goals.

Example
example-value

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv Goal2-8 shorthand; base Goal1 field

0 nonblank / 3491 blank in local sample

#104Goal6RitScoreNWEA pass-through Integer
3 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for goal 6. Same field meaning as Goal1RitScore. RIT score for the first goal section of the test. Value is rounded to whole, integer value.

Constraints
  • NWEA datatype: Integer.
  • NWEA length/range: 3 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Goal fields can be blank for Survey tests without goals.

Example
238

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv Goal2-8 shorthand; base Goal1 field

0 nonblank / 3491 blank in local sample

#105Goal6StdErrNWEA pass-through Number
9 characters, 1 decimal
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for goal 6. Same field meaning as Goal1StdErr. Standard error for first goal section of the test.

Constraints
  • NWEA datatype: Number.
  • NWEA length/range: 9 characters, 1 decimal.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
3.4

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv Goal2-8 shorthand; base Goal1 field

0 nonblank / 3491 blank in local sample

#106Goal6RangeNWEA pass-through String
7 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for goal 6. Same field meaning as Goal1Range. RIT range based on the standard error and RIT score. *–* indicates that no value range computed.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 7 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
example-value

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv Goal2-8 shorthand; base Goal1 field

0 nonblank / 3491 blank in local sample

#107Goal6AdjectiveNWEA pass-through String
12 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for goal 6. Same field meaning as Goal1Adjective. Goal adjective related to the first goal score. This is defined using the goal score percentile as it relates to a norm set and its associative cut sheet. Values: Low (percentile <= 20) LoAvg (percentile > 20 to <= 40) Avg (percentile > 40 to <= 60) HiAvg (percentile > 60 to <= 80) High (percentile > 80) * (goal adjective could not be computed)

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 12 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.
  • Low - Up to 20th percentile.
  • LoAvg - 21st through 40th percentile.
  • Avg - 41st through 60th percentile.
  • HiAvg - 61st through 80th percentile.
  • High - 81st percentile and above.
  • blank - No percentile/adjective was exported for this field.
RelationshipsNone specified.Edge casesNone specified.

Example
Avg

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv Goal2-8 shorthand; base Goal1 field

0 nonblank / 3491 blank in local sample

#108Goal7NameNWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for goal 7. Same field meaning as Goal1Name. Name of first goal section of the test. Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.
  • Goal fields can be blank for Survey tests without goals.

Example
example-value

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv Goal2-8 shorthand; base Goal1 field

0 nonblank / 3491 blank in local sample

#109Goal7RitScoreNWEA pass-through Integer
3 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for goal 7. Same field meaning as Goal1RitScore. RIT score for the first goal section of the test. Value is rounded to whole, integer value.

Constraints
  • NWEA datatype: Integer.
  • NWEA length/range: 3 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Goal fields can be blank for Survey tests without goals.

Example
238

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv Goal2-8 shorthand; base Goal1 field

0 nonblank / 3491 blank in local sample

#110Goal7StdErrNWEA pass-through Number
9 characters, 1 decimal
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for goal 7. Same field meaning as Goal1StdErr. Standard error for first goal section of the test.

Constraints
  • NWEA datatype: Number.
  • NWEA length/range: 9 characters, 1 decimal.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
3.4

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv Goal2-8 shorthand; base Goal1 field

0 nonblank / 3491 blank in local sample

#111Goal7RangeNWEA pass-through String
7 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for goal 7. Same field meaning as Goal1Range. RIT range based on the standard error and RIT score. *–* indicates that no value range computed.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 7 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
example-value

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv Goal2-8 shorthand; base Goal1 field

0 nonblank / 3491 blank in local sample

#112Goal7AdjectiveNWEA pass-through String
12 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for goal 7. Same field meaning as Goal1Adjective. Goal adjective related to the first goal score. This is defined using the goal score percentile as it relates to a norm set and its associative cut sheet. Values: Low (percentile <= 20) LoAvg (percentile > 20 to <= 40) Avg (percentile > 40 to <= 60) HiAvg (percentile > 60 to <= 80) High (percentile > 80) * (goal adjective could not be computed)

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 12 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.
  • Low - Up to 20th percentile.
  • LoAvg - 21st through 40th percentile.
  • Avg - 41st through 60th percentile.
  • HiAvg - 61st through 80th percentile.
  • High - 81st percentile and above.
  • blank - No percentile/adjective was exported for this field.
RelationshipsNone specified.Edge casesNone specified.

Example
Avg

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv Goal2-8 shorthand; base Goal1 field

0 nonblank / 3491 blank in local sample

#113Goal8NameNWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for goal 8. Same field meaning as Goal1Name. Name of first goal section of the test. Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.
  • Goal fields can be blank for Survey tests without goals.

Example
example-value

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv Goal2-8 shorthand; base Goal1 field

0 nonblank / 3491 blank in local sample

#114Goal8RitScoreNWEA pass-through Integer
3 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for goal 8. Same field meaning as Goal1RitScore. RIT score for the first goal section of the test. Value is rounded to whole, integer value.

Constraints
  • NWEA datatype: Integer.
  • NWEA length/range: 3 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Goal fields can be blank for Survey tests without goals.

Example
238

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv Goal2-8 shorthand; base Goal1 field

0 nonblank / 3491 blank in local sample

#115Goal8StdErrNWEA pass-through Number
9 characters, 1 decimal
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for goal 8. Same field meaning as Goal1StdErr. Standard error for first goal section of the test.

Constraints
  • NWEA datatype: Number.
  • NWEA length/range: 9 characters, 1 decimal.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
3.4

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv Goal2-8 shorthand; base Goal1 field

0 nonblank / 3491 blank in local sample

#116Goal8RangeNWEA pass-through String
7 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for goal 8. Same field meaning as Goal1Range. RIT range based on the standard error and RIT score. *–* indicates that no value range computed.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 7 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
example-value

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv Goal2-8 shorthand; base Goal1 field

0 nonblank / 3491 blank in local sample

#117Goal8AdjectiveNWEA pass-through String
12 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for goal 8. Same field meaning as Goal1Adjective. Goal adjective related to the first goal score. This is defined using the goal score percentile as it relates to a norm set and its associative cut sheet. Values: Low (percentile <= 20) LoAvg (percentile > 20 to <= 40) Avg (percentile > 40 to <= 60) HiAvg (percentile > 60 to <= 80) High (percentile > 80) * (goal adjective could not be computed)

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 12 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.
  • Low - Up to 20th percentile.
  • LoAvg - 21st through 40th percentile.
  • Avg - 41st through 60th percentile.
  • HiAvg - 61st through 80th percentile.
  • High - 81st percentile and above.
  • blank - No percentile/adjective was exported for this field.
RelationshipsNone specified.Edge casesNone specified.

Example
Avg

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv Goal2-8 shorthand; base Goal1 field

0 nonblank / 3491 blank in local sample

#118TypicalFallToFallGrowthNWEA pass-through Integer
3 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Projected RIT growth from the fall term chosen at export to the next academic year fall term. --Value is only available if the selected term for export is fall and if growth projection norms exist. --Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: Integer.
  • NWEA length/range: 3 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.

Example
2

Source
MAP_Export_Field_Descriptions.xlsx / field 118

0 nonblank / 3491 blank in local sample

#119TypicalFallToWinterGrowthNWEA pass-through Integer
3 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Projected RIT growth from the fall term chosen at export to the next winter term. --Value is only available if the selected term for export is fall and if growth projection norms exist. --Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: Integer.
  • NWEA length/range: 3 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.

Example
2

Source
MAP_Export_Field_Descriptions.xlsx / field 119

0 nonblank / 3491 blank in local sample

#120TypicalFallToSpringGrowthNWEA pass-through Integer
3 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Projected RIT growth from the fall term chosen at export to the next spring term. --Value is only available if the selected term for export is fall and if growth projection norms exist. --Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: Integer.
  • NWEA length/range: 3 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.

Example
2

Source
MAP_Export_Field_Descriptions.xlsx / field 120

0 nonblank / 3491 blank in local sample

#121TypicalWinterToWinterGrowthNWEA pass-through Integer
3 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Projected RIT growth from the winter term chosen at export to the next academic year winter term. --Value is only available if the selected term for export is winter and if growth projection norms exist. --Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: Integer.
  • NWEA length/range: 3 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.

Example
2

Source
MAP_Export_Field_Descriptions.xlsx / field 121

0 nonblank / 3491 blank in local sample

#122TypicalWinterToSpringGrowthNWEA pass-through Integer
3 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Projected RIT growth from the winter term chosen at export to the next spring term. --Value is only available if the selected term for export is winter and if growth projection norms exist. --Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: Integer.
  • NWEA length/range: 3 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.

Example
2

Source
MAP_Export_Field_Descriptions.xlsx / field 122

0 nonblank / 3491 blank in local sample

#123TypicalSpringToSpringGrowthNWEA pass-through Integer
3 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Projected RIT growth from the spring term chosen at export to the next academic year spring term. --Value is only available if the selected term for export is spring and if growth projection norms exist. --Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: Integer.
  • NWEA length/range: 3 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 885 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.

Example
2

Source
MAP_Export_Field_Descriptions.xlsx / field 123

2606 nonblank / 885 blank in local sample

#124ProjectedProficiencyStudy1NWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Name of the first NWEA linking study associated with the MAP test taken. Linking studies form the basis for projected proficiency on separate assessments, such as your state summative test. --Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 2382 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.
  • NWEA appends only applicable linking studies; later study/level columns may be blank.

Example
Example State Linking Study

Source
MAP_Export_Field_Descriptions.xlsx / field 124

1109 nonblank / 2382 blank in local sample

#125ProjectedProficiencyLevel1NWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Projected proficiency level, or category, such as Unsatisfactory, Partially Proficient, and so on. Corresponds to the first linking study.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 2382 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • NWEA appends only applicable linking studies; later study/level columns may be blank.

Example
Proficient

Source
MAP_Export_Field_Descriptions.xlsx / field 125

1109 nonblank / 2382 blank in local sample

#126ProjectedProficiencyStudy2NWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Name of the second NWEA linking study, if available.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 2417 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.
  • NWEA appends only applicable linking studies; later study/level columns may be blank.

Example
Example State Linking Study

Source
MAP_Export_Field_Descriptions.xlsx / field 126

1074 nonblank / 2417 blank in local sample

#127ProjectedProficiencyLevel2NWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Projected proficiency level, or category, that corresponds to the second linking study.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 2417 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • NWEA appends only applicable linking studies; later study/level columns may be blank.

Example
Proficient

Source
MAP_Export_Field_Descriptions.xlsx / field 127

1074 nonblank / 2417 blank in local sample

#128ProjectedProficiencyStudy3NWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Name of the third NWEA linking study, if available.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 1403 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.
  • NWEA appends only applicable linking studies; later study/level columns may be blank.

Example
Example State Linking Study

Source
MAP_Export_Field_Descriptions.xlsx / field 128

2088 nonblank / 1403 blank in local sample

#129ProjectedProficiencyLevel3NWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Projected proficiency level, or category, that corresponds to the third linking study.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 1403 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • NWEA appends only applicable linking studies; later study/level columns may be blank.

Example
Proficient

Source
MAP_Export_Field_Descriptions.xlsx / field 129

2088 nonblank / 1403 blank in local sample

#130ProjectedProficiencyStudy4NWEA pass-through Same as prior columns.
Not specified by NWEA workbook
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

If there are additional proficiency projections applicable to the MAP test, they will appear at the end of the export.

Constraints
  • NWEA datatype: Same as prior columns..
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3105 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • NWEA appends only applicable linking studies; later study/level columns may be blank.

Example
Example State Linking Study

Source
MAP_Export_Field_Descriptions.xlsx / field 130

386 nonblank / 3105 blank in local sample

#131ProjectedProficiencyLevel4NWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for projected-proficiency pair 4. Projected proficiency level, or category, such as Unsatisfactory, Partially Proficient, and so on. Corresponds to the first linking study.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3105 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • NWEA appends only applicable linking studies; later study/level columns may be blank.

Example
Proficient

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv ProjectedProficiency 4 to 10 shorthand; base pair 1 field

386 nonblank / 3105 blank in local sample

#132ProjectedProficiencyStudy5NWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for projected-proficiency pair 5. Name of the first NWEA linking study associated with the MAP test taken. Linking studies form the basis for projected proficiency on separate assessments, such as your state summative test. --Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.
  • NWEA appends only applicable linking studies; later study/level columns may be blank.

Example
Example State Linking Study

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv ProjectedProficiency 4 to 10 shorthand; base pair 1 field

0 nonblank / 3491 blank in local sample

#133ProjectedProficiencyLevel5NWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for projected-proficiency pair 5. Projected proficiency level, or category, such as Unsatisfactory, Partially Proficient, and so on. Corresponds to the first linking study.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • NWEA appends only applicable linking studies; later study/level columns may be blank.

Example
Proficient

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv ProjectedProficiency 4 to 10 shorthand; base pair 1 field

0 nonblank / 3491 blank in local sample

#134ProjectedProficiencyStudy6NWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for projected-proficiency pair 6. Name of the first NWEA linking study associated with the MAP test taken. Linking studies form the basis for projected proficiency on separate assessments, such as your state summative test. --Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.
  • NWEA appends only applicable linking studies; later study/level columns may be blank.

Example
Example State Linking Study

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv ProjectedProficiency 4 to 10 shorthand; base pair 1 field

0 nonblank / 3491 blank in local sample

#135ProjectedProficiencyLevel6NWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for projected-proficiency pair 6. Projected proficiency level, or category, such as Unsatisfactory, Partially Proficient, and so on. Corresponds to the first linking study.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • NWEA appends only applicable linking studies; later study/level columns may be blank.

Example
Proficient

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv ProjectedProficiency 4 to 10 shorthand; base pair 1 field

0 nonblank / 3491 blank in local sample

#136ProjectedProficiencyStudy7NWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for projected-proficiency pair 7. Name of the first NWEA linking study associated with the MAP test taken. Linking studies form the basis for projected proficiency on separate assessments, such as your state summative test. --Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.
  • NWEA appends only applicable linking studies; later study/level columns may be blank.

Example
Example State Linking Study

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv ProjectedProficiency 4 to 10 shorthand; base pair 1 field

0 nonblank / 3491 blank in local sample

#137ProjectedProficiencyLevel7NWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for projected-proficiency pair 7. Projected proficiency level, or category, such as Unsatisfactory, Partially Proficient, and so on. Corresponds to the first linking study.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • NWEA appends only applicable linking studies; later study/level columns may be blank.

Example
Proficient

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv ProjectedProficiency 4 to 10 shorthand; base pair 1 field

0 nonblank / 3491 blank in local sample

#138ProjectedProficiencyStudy8NWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for projected-proficiency pair 8. Name of the first NWEA linking study associated with the MAP test taken. Linking studies form the basis for projected proficiency on separate assessments, such as your state summative test. --Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.
  • NWEA appends only applicable linking studies; later study/level columns may be blank.

Example
Example State Linking Study

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv ProjectedProficiency 4 to 10 shorthand; base pair 1 field

0 nonblank / 3491 blank in local sample

#139ProjectedProficiencyLevel8NWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for projected-proficiency pair 8. Projected proficiency level, or category, such as Unsatisfactory, Partially Proficient, and so on. Corresponds to the first linking study.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • NWEA appends only applicable linking studies; later study/level columns may be blank.

Example
Proficient

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv ProjectedProficiency 4 to 10 shorthand; base pair 1 field

0 nonblank / 3491 blank in local sample

#140ProjectedProficiencyStudy9NWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for projected-proficiency pair 9. Name of the first NWEA linking study associated with the MAP test taken. Linking studies form the basis for projected proficiency on separate assessments, such as your state summative test. --Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.
  • NWEA appends only applicable linking studies; later study/level columns may be blank.

Example
Example State Linking Study

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv ProjectedProficiency 4 to 10 shorthand; base pair 1 field

0 nonblank / 3491 blank in local sample

#141ProjectedProficiencyLevel9NWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for projected-proficiency pair 9. Projected proficiency level, or category, such as Unsatisfactory, Partially Proficient, and so on. Corresponds to the first linking study.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • NWEA appends only applicable linking studies; later study/level columns may be blank.

Example
Proficient

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv ProjectedProficiency 4 to 10 shorthand; base pair 1 field

0 nonblank / 3491 blank in local sample

#142ProjectedProficiencyStudy10NWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for projected-proficiency pair 10. Name of the first NWEA linking study associated with the MAP test taken. Linking studies form the basis for projected proficiency on separate assessments, such as your state summative test. --Value is blank if the MAP test type is "Survey."

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • Conditionally populated by NWEA; blank is a meaningful exported state.
  • NWEA appends only applicable linking studies; later study/level columns may be blank.

Example
Example State Linking Study

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv ProjectedProficiency 4 to 10 shorthand; base pair 1 field

0 nonblank / 3491 blank in local sample

#143ProjectedProficiencyLevel10NWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

NWEA shorthand expansion for projected-proficiency pair 10. Projected proficiency level, or category, such as Unsatisfactory, Partially Proficient, and so on. Corresponds to the first linking study.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 3491 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge cases
  • NWEA appends only applicable linking studies; later study/level columns may be blank.

Example
Proficient

Source
MAP_Export_Field_Descriptions.xlsx / AssessmentResults.csv ProjectedProficiency 4 to 10 shorthand; base pair 1 field

0 nonblank / 3491 blank in local sample

NWEA pass-through raw table

nweamap.raw_class_assignments Class assignment raw CDF rows

Purpose

Lossless mirror of NWEA class and teacher assignment rows.

Lifecycle

Created by CDF import and retained as the class/teacher assignment evidence for the import scope.

Public endpoint

GET /nweamap/v1/class-assignments

Relationships
  • StudentID connects class assignment rows to the student and assessment rows in the same tenant/account/term.
  • TeacherID is NWEA/district supplied; this surface does not invent a teacher directory table.
CDF source ClassAssignments.csv / workbook sheet ClassAssignments.csv 11 NWEA fields, 1128 local sample rows.

Platform sidecar fields

FieldType and nullabilityMeaning and constraintsAllowed valuesRelationships and edge casesExample and provenance
row_idPlatform gap-fill UUID
Platform-owned
Required; primary key.

Stable row identifier assigned by the platform for this mirrored CDF row.

Constraints
  • Unique within this table.
  • Never derived from student identity or NWEA row text.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
018f4b4e-9c7a-7d3d-8b2f-2f673a000001

Source
NWEAMap architecture gap fill

Platform-owned field

tenant_idPlatform gap-fill UUID
Platform-owned
Required.

Platform tenant boundary from the verified JWT; this is the authorization scope for the row.

Constraints
  • Must match the caller's JWT tenantId for writes and reads.
  • References platform.tenant(tenant_id).

Platform-owned values are closed when listed here.

Relationships
  • Belongs to exactly one platform.tenant row.
Edge casesNone specified.

Example
018f4b4e-9c7a-7d3d-8b2f-2f673a000001

Source
NWEAMap architecture gap fill

Platform-owned field

nwea_account_idPlatform gap-fill TEXT
Platform-owned
Required.

Tenant-local NWEA account partition for the imported bundle.

Constraints
  • Required for imports and list filters.
  • Not globally unique outside tenant_id.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
nwea-account-demo

Source
NWEAMap architecture gap fill

Platform-owned field

import_idPlatform gap-fill UUID
Platform-owned
Required.

Import bundle that created or last refreshed this row.

Constraints
  • References nweamap.import(import_id).

Platform-owned values are closed when listed here.

Relationships
  • Many raw rows belong to one import bundle.
Edge casesNone specified.

Example
018f4b4e-9c7a-7d3d-8b2f-2f673a000001

Source
NWEAMap architecture gap fill

Platform-owned field

import_file_idPlatform gap-fill UUID
Platform-owned
Required.

Import-file record for the CDF file that carried this row.

Constraints
  • References nweamap.import_file(import_file_id).

Platform-owned values are closed when listed here.

Relationships
  • Many raw rows belong to one import file.
Edge casesNone specified.

Example
018f4b4e-9c7a-7d3d-8b2f-2f673a000001

Source
NWEAMap architecture gap fill

Platform-owned field

source_filePlatform gap-fill TEXT enum
Platform-owned
Required.

Exact CDF file name whose header and row content produced this row.

Constraints
  • Must be one of the five Comprehensive Data File names.
  • StudentsBySchool.csv - One required or optional file in the Comprehensive Data File bundle.
  • AssessmentResults.csv - One required or optional file in the Comprehensive Data File bundle.
  • ClassAssignments.csv - One required or optional file in the Comprehensive Data File bundle.
  • ProgramAssignments.csv - One required or optional file in the Comprehensive Data File bundle.
  • AccommodationAssignment.csv - One required or optional file in the Comprehensive Data File bundle.
RelationshipsNone specified.Edge casesNone specified.

Example
AssessmentResults.csv

Source
NWEAMap architecture gap fill

Platform-owned field

source_row_numberPlatform gap-fill INTEGER
Platform-owned
Required.

One-based data-row number inside the CDF file, excluding the header.

Constraints
  • Must be >= 1.
  • Stable only within the import_file_id.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
42

Source
NWEAMap architecture gap fill

Platform-owned field

source_row_hashPlatform gap-fill TEXT
Platform-owned
Required.

Canonical hash of the source-file name, header position, and row values used for idempotent re-import and missing-row detection.

Constraints
  • SHA-256 hex or sha256-prefixed digest.
  • Same row content in the same file scope must produce the same hash.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
sha256:2d3f6b4e8c1a0f9b7e6d5c4b3a291807060504030201000ffeeddbbccaa9988

Source
NWEAMap architecture gap fill

Platform-owned field

ingested_atPlatform gap-fill TIMESTAMPTZ
Platform-owned
Required.

Timestamp when the platform accepted this row into tenant-scoped persistence.

Constraints
  • Must be UTC.
  • Used for audit and modifiedSince behavior.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
2026-06-03T11:00:00Z

Source
NWEAMap architecture gap fill

Platform-owned field

modified_atPlatform gap-fill TIMESTAMPTZ
Platform-owned
Required.

Timestamp when the row or its deletion/projection state last changed.

Constraints
  • Must be UTC.
  • Must be greater than or equal to ingested_at.
  • Powers modifiedSince polling.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
2026-06-03T11:00:00Z

Source
NWEAMap architecture gap fill

Platform-owned field

deleted_atPlatform gap-fill TIMESTAMPTZ
Platform-owned
Nullable.

Soft-delete timestamp set when a replacement authoritative export stops sending this source row.

Constraints
  • Null means active.
  • Non-null rows are excluded from test_of_record.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge cases
  • Soft delete is retention evidence, not a legal erasure API.

Example
2026-06-03T11:00:00Z

Source
NWEAMap architecture gap fill

Platform-owned field

deleted_by_import_idPlatform gap-fill UUID
Platform-owned
Nullable.

Replacement import that caused this row to be marked deleted.

Constraints
  • References nweamap.import(import_id) when present.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
018f4b4e-9c7a-7d3d-8b2f-2f673a000001

Source
NWEAMap architecture gap fill

Platform-owned field

delete_reasonPlatform gap-fill TEXT enum
Platform-owned
Nullable.

Platform explanation for why the row disappeared from a later authoritative export, when inferable.

Constraints
  • Must be null or one of the documented delete_reason values.
  • missing_from_replacement_export - A later authoritative export for the same scope stopped sending the row.
  • retake_superseded - Import evidence indicates the row was replaced by a retake.
  • invalidated_or_suppressed_by_nwea - Import evidence indicates NWEA invalidated or suppressed the sitting.
  • unknown - The row disappeared but the specific reason was not inferable.
RelationshipsNone specified.Edge casesNone specified.

Example
missing_from_replacement_export

Source
NWEAMap architecture gap fill

Platform-owned field

NWEA pass-through fields

FieldType and nullabilityMeaning and constraintsAllowed valuesRelationships and edge casesExample and provenance
#1TermNameNWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Term chosen for the export.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • No blanks observed in the local sample, but NWEA pass-through columns remain nullable unless NWEA explicitly requires otherwise.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

Relationships
  • Term scope is paired with tenant_id and nwea_account_id; term strings are pass-through NWEA values, not parsed by client skill packs.
Edge casesNone specified.

Example
Spring 2025-2026

Source
MAP_Export_Field_Descriptions.xlsx / field 1

1128 nonblank / 0 blank in local sample

#2DistrictNameNWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Name defined in your MAP preferences.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • No blanks observed in the local sample, but NWEA pass-through columns remain nullable unless NWEA explicitly requires otherwise.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

Relationships
  • Reconciliation field from NWEA/MAP preferences; not canonical tenant routing.
Edge casesNone specified.

Example
Example District

Source
MAP_Export_Field_Descriptions.xlsx / field 2

1128 nonblank / 0 blank in local sample

#3District_StateIDNWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

District code you have set in MAP preferences.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 1128 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
Example District

Source
MAP_Export_Field_Descriptions.xlsx / field 3

0 nonblank / 1128 blank in local sample

#4SchoolNameNWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Name defined in your MAP preferences. If a student has multiple schools, this is the student's School of Record.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • No blanks observed in the local sample, but NWEA pass-through columns remain nullable unless NWEA explicitly requires otherwise.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

Relationships
  • NWEA school-of-record label; not canonical tenant routing.
Edge casesNone specified.

Example
Example School

Source
MAP_Export_Field_Descriptions.xlsx / field 4

1128 nonblank / 0 blank in local sample

#5School_StateIDNWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

State code for the school associated with the student.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 1128 blank value(s); migration must allow blank/null.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
Example School

Source
MAP_Export_Field_Descriptions.xlsx / field 5

0 nonblank / 1128 blank in local sample

#6StudentIDNWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

ID your district provided in the student's MAP profile.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • No blanks observed in the local sample, but NWEA pass-through columns remain nullable unless NWEA explicitly requires otherwise.
  • Student/teacher identifiers and names are tenant-scoped PII or quasi-identifiers; redact from logs and public error bodies.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

Relationships
  • Student identifier repeats across CDF collections inside the same tenant, NWEA account, and term; it is not globally unique.
Edge casesNone specified.

Example
stu-12345

Source
MAP_Export_Field_Descriptions.xlsx / field 6

1128 nonblank / 0 blank in local sample

#7Student_StateIDNWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

ID your state uses to identify the student.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 1128 blank value(s); migration must allow blank/null.
  • Student/teacher identifiers and names are tenant-scoped PII or quasi-identifiers; redact from logs and public error bodies.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

Relationships
  • State student identifier is optional and may be blank; never use it as the only join key.
Edge casesNone specified.

Example
example-value

Source
MAP_Export_Field_Descriptions.xlsx / field 7

0 nonblank / 1128 blank in local sample

#8ClassNameNWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Class your district provided in the student's MAP profile.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • No blanks observed in the local sample, but NWEA pass-through columns remain nullable unless NWEA explicitly requires otherwise.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
example-value

Source
MAP_Export_Field_Descriptions.xlsx / field 8

1128 nonblank / 0 blank in local sample

#9TeacherNameNWEA pass-through String
303 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Teacher (Instructor) your district provided in the student's MAP profile.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 303 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • No blanks observed in the local sample, but NWEA pass-through columns remain nullable unless NWEA explicitly requires otherwise.
  • Student/teacher identifiers and names are tenant-scoped PII or quasi-identifiers; redact from logs and public error bodies.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
Example Teacher

Source
MAP_Export_Field_Descriptions.xlsx / field 9

1128 nonblank / 0 blank in local sample

#10TeacherIDNWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Unique identifier assigned to the teacher by your district or school.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 41 blank value(s); migration must allow blank/null.
  • Student/teacher identifiers and names are tenant-scoped PII or quasi-identifiers; redact from logs and public error bodies.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
teacher-123

Source
MAP_Export_Field_Descriptions.xlsx / field 10

1087 nonblank / 41 blank in local sample

#11Teacher_StateIDNWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Additional identifier your state uses to identify the teacher.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 1128 blank value(s); migration must allow blank/null.
  • Student/teacher identifiers and names are tenant-scoped PII or quasi-identifiers; redact from logs and public error bodies.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
teacher-123

Source
MAP_Export_Field_Descriptions.xlsx / field 11

0 nonblank / 1128 blank in local sample

NWEA pass-through raw table

nweamap.raw_program_assignments Program assignment raw CDF rows

Purpose

Lossless mirror of optional NWEA program assignment rows. An export with only headers is a valid empty file.

Lifecycle

Created by CDF import when rows are present; header-only files still produce import-file evidence and zero raw rows.

Public endpoint

GET /nweamap/v1/program-assignments

Relationships
  • StudentID connects program rows to the student rows in the same tenant/account/term.
  • NWEAStandard_Program clarifies the local Program value; it is not a platform-owned enum.
CDF source ProgramAssignments.csv / workbook sheet ProgramAssignments.csv 5 NWEA fields, 0 local sample rows.

Platform sidecar fields

FieldType and nullabilityMeaning and constraintsAllowed valuesRelationships and edge casesExample and provenance
row_idPlatform gap-fill UUID
Platform-owned
Required; primary key.

Stable row identifier assigned by the platform for this mirrored CDF row.

Constraints
  • Unique within this table.
  • Never derived from student identity or NWEA row text.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
018f4b4e-9c7a-7d3d-8b2f-2f673a000001

Source
NWEAMap architecture gap fill

Platform-owned field

tenant_idPlatform gap-fill UUID
Platform-owned
Required.

Platform tenant boundary from the verified JWT; this is the authorization scope for the row.

Constraints
  • Must match the caller's JWT tenantId for writes and reads.
  • References platform.tenant(tenant_id).

Platform-owned values are closed when listed here.

Relationships
  • Belongs to exactly one platform.tenant row.
Edge casesNone specified.

Example
018f4b4e-9c7a-7d3d-8b2f-2f673a000001

Source
NWEAMap architecture gap fill

Platform-owned field

nwea_account_idPlatform gap-fill TEXT
Platform-owned
Required.

Tenant-local NWEA account partition for the imported bundle.

Constraints
  • Required for imports and list filters.
  • Not globally unique outside tenant_id.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
nwea-account-demo

Source
NWEAMap architecture gap fill

Platform-owned field

import_idPlatform gap-fill UUID
Platform-owned
Required.

Import bundle that created or last refreshed this row.

Constraints
  • References nweamap.import(import_id).

Platform-owned values are closed when listed here.

Relationships
  • Many raw rows belong to one import bundle.
Edge casesNone specified.

Example
018f4b4e-9c7a-7d3d-8b2f-2f673a000001

Source
NWEAMap architecture gap fill

Platform-owned field

import_file_idPlatform gap-fill UUID
Platform-owned
Required.

Import-file record for the CDF file that carried this row.

Constraints
  • References nweamap.import_file(import_file_id).

Platform-owned values are closed when listed here.

Relationships
  • Many raw rows belong to one import file.
Edge casesNone specified.

Example
018f4b4e-9c7a-7d3d-8b2f-2f673a000001

Source
NWEAMap architecture gap fill

Platform-owned field

source_filePlatform gap-fill TEXT enum
Platform-owned
Required.

Exact CDF file name whose header and row content produced this row.

Constraints
  • Must be one of the five Comprehensive Data File names.
  • StudentsBySchool.csv - One required or optional file in the Comprehensive Data File bundle.
  • AssessmentResults.csv - One required or optional file in the Comprehensive Data File bundle.
  • ClassAssignments.csv - One required or optional file in the Comprehensive Data File bundle.
  • ProgramAssignments.csv - One required or optional file in the Comprehensive Data File bundle.
  • AccommodationAssignment.csv - One required or optional file in the Comprehensive Data File bundle.
RelationshipsNone specified.Edge casesNone specified.

Example
AssessmentResults.csv

Source
NWEAMap architecture gap fill

Platform-owned field

source_row_numberPlatform gap-fill INTEGER
Platform-owned
Required.

One-based data-row number inside the CDF file, excluding the header.

Constraints
  • Must be >= 1.
  • Stable only within the import_file_id.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
42

Source
NWEAMap architecture gap fill

Platform-owned field

source_row_hashPlatform gap-fill TEXT
Platform-owned
Required.

Canonical hash of the source-file name, header position, and row values used for idempotent re-import and missing-row detection.

Constraints
  • SHA-256 hex or sha256-prefixed digest.
  • Same row content in the same file scope must produce the same hash.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
sha256:2d3f6b4e8c1a0f9b7e6d5c4b3a291807060504030201000ffeeddbbccaa9988

Source
NWEAMap architecture gap fill

Platform-owned field

ingested_atPlatform gap-fill TIMESTAMPTZ
Platform-owned
Required.

Timestamp when the platform accepted this row into tenant-scoped persistence.

Constraints
  • Must be UTC.
  • Used for audit and modifiedSince behavior.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
2026-06-03T11:00:00Z

Source
NWEAMap architecture gap fill

Platform-owned field

modified_atPlatform gap-fill TIMESTAMPTZ
Platform-owned
Required.

Timestamp when the row or its deletion/projection state last changed.

Constraints
  • Must be UTC.
  • Must be greater than or equal to ingested_at.
  • Powers modifiedSince polling.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
2026-06-03T11:00:00Z

Source
NWEAMap architecture gap fill

Platform-owned field

deleted_atPlatform gap-fill TIMESTAMPTZ
Platform-owned
Nullable.

Soft-delete timestamp set when a replacement authoritative export stops sending this source row.

Constraints
  • Null means active.
  • Non-null rows are excluded from test_of_record.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge cases
  • Soft delete is retention evidence, not a legal erasure API.

Example
2026-06-03T11:00:00Z

Source
NWEAMap architecture gap fill

Platform-owned field

deleted_by_import_idPlatform gap-fill UUID
Platform-owned
Nullable.

Replacement import that caused this row to be marked deleted.

Constraints
  • References nweamap.import(import_id) when present.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
018f4b4e-9c7a-7d3d-8b2f-2f673a000001

Source
NWEAMap architecture gap fill

Platform-owned field

delete_reasonPlatform gap-fill TEXT enum
Platform-owned
Nullable.

Platform explanation for why the row disappeared from a later authoritative export, when inferable.

Constraints
  • Must be null or one of the documented delete_reason values.
  • missing_from_replacement_export - A later authoritative export for the same scope stopped sending the row.
  • retake_superseded - Import evidence indicates the row was replaced by a retake.
  • invalidated_or_suppressed_by_nwea - Import evidence indicates NWEA invalidated or suppressed the sitting.
  • unknown - The row disappeared but the specific reason was not inferable.
RelationshipsNone specified.Edge casesNone specified.

Example
missing_from_replacement_export

Source
NWEAMap architecture gap fill

Platform-owned field

NWEA pass-through fields

FieldType and nullabilityMeaning and constraintsAllowed valuesRelationships and edge casesExample and provenance
#1TermNameNWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Term chosen for the export.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample has zero data rows; do not infer NOT NULL from absence of values.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

Relationships
  • Term scope is paired with tenant_id and nwea_account_id; term strings are pass-through NWEA values, not parsed by client skill packs.
Edge casesNone specified.

Example
Spring 2025-2026

Source
MAP_Export_Field_Descriptions.xlsx / field 1

0 nonblank / 0 blank in local sample

#2StudentIDNWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

ID your district provided in the student's MAP profile.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample has zero data rows; do not infer NOT NULL from absence of values.
  • Student/teacher identifiers and names are tenant-scoped PII or quasi-identifiers; redact from logs and public error bodies.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

Relationships
  • Student identifier repeats across CDF collections inside the same tenant, NWEA account, and term; it is not globally unique.
Edge casesNone specified.

Example
stu-12345

Source
MAP_Export_Field_Descriptions.xlsx / field 2

0 nonblank / 0 blank in local sample

#3Student_StateIDNWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

ID your state uses to identify the student.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample has zero data rows; do not infer NOT NULL from absence of values.
  • Student/teacher identifiers and names are tenant-scoped PII or quasi-identifiers; redact from logs and public error bodies.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

Relationships
  • State student identifier is optional and may be blank; never use it as the only join key.
Edge casesNone specified.

Example
example-value

Source
MAP_Export_Field_Descriptions.xlsx / field 3

0 nonblank / 0 blank in local sample

#4ProgramNWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Programs, such as Head Start, that your district provided in the student's MAP profile.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample has zero data rows; do not infer NOT NULL from absence of values.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
Head Start

Source
MAP_Export_Field_Descriptions.xlsx / field 4

0 nonblank / 0 blank in local sample

#5NWEAStandard_ProgramNWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Default name from NWEA that is associated with your custom Program name. Included here to help clarify the data shown in the Program column.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample has zero data rows; do not infer NOT NULL from absence of values.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
Head Start

Source
MAP_Export_Field_Descriptions.xlsx / field 5

0 nonblank / 0 blank in local sample

NWEA pass-through raw table

nweamap.raw_accommodation_assignments Accommodation assignment raw CDF rows

Purpose

Lossless mirror of NWEA accommodation rows, one row per accommodation selected by a proctor for a test event.

Lifecycle

Created by CDF import and retained for audit even if a later export no longer carries the accommodation row.

Public endpoint

GET /nweamap/v1/accommodations

Relationships
  • TestID belongs to one AssessmentResults row in the same tenant/account/term when NWEA sent both files.
  • A single test can have many accommodation rows because NWEA emits multiple accommodations on separate rows.
CDF source AccommodationAssignment.csv / workbook sheet AccommodationAssignment.csv 6 NWEA fields, 1412 local sample rows.

Platform sidecar fields

FieldType and nullabilityMeaning and constraintsAllowed valuesRelationships and edge casesExample and provenance
row_idPlatform gap-fill UUID
Platform-owned
Required; primary key.

Stable row identifier assigned by the platform for this mirrored CDF row.

Constraints
  • Unique within this table.
  • Never derived from student identity or NWEA row text.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
018f4b4e-9c7a-7d3d-8b2f-2f673a000001

Source
NWEAMap architecture gap fill

Platform-owned field

tenant_idPlatform gap-fill UUID
Platform-owned
Required.

Platform tenant boundary from the verified JWT; this is the authorization scope for the row.

Constraints
  • Must match the caller's JWT tenantId for writes and reads.
  • References platform.tenant(tenant_id).

Platform-owned values are closed when listed here.

Relationships
  • Belongs to exactly one platform.tenant row.
Edge casesNone specified.

Example
018f4b4e-9c7a-7d3d-8b2f-2f673a000001

Source
NWEAMap architecture gap fill

Platform-owned field

nwea_account_idPlatform gap-fill TEXT
Platform-owned
Required.

Tenant-local NWEA account partition for the imported bundle.

Constraints
  • Required for imports and list filters.
  • Not globally unique outside tenant_id.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
nwea-account-demo

Source
NWEAMap architecture gap fill

Platform-owned field

import_idPlatform gap-fill UUID
Platform-owned
Required.

Import bundle that created or last refreshed this row.

Constraints
  • References nweamap.import(import_id).

Platform-owned values are closed when listed here.

Relationships
  • Many raw rows belong to one import bundle.
Edge casesNone specified.

Example
018f4b4e-9c7a-7d3d-8b2f-2f673a000001

Source
NWEAMap architecture gap fill

Platform-owned field

import_file_idPlatform gap-fill UUID
Platform-owned
Required.

Import-file record for the CDF file that carried this row.

Constraints
  • References nweamap.import_file(import_file_id).

Platform-owned values are closed when listed here.

Relationships
  • Many raw rows belong to one import file.
Edge casesNone specified.

Example
018f4b4e-9c7a-7d3d-8b2f-2f673a000001

Source
NWEAMap architecture gap fill

Platform-owned field

source_filePlatform gap-fill TEXT enum
Platform-owned
Required.

Exact CDF file name whose header and row content produced this row.

Constraints
  • Must be one of the five Comprehensive Data File names.
  • StudentsBySchool.csv - One required or optional file in the Comprehensive Data File bundle.
  • AssessmentResults.csv - One required or optional file in the Comprehensive Data File bundle.
  • ClassAssignments.csv - One required or optional file in the Comprehensive Data File bundle.
  • ProgramAssignments.csv - One required or optional file in the Comprehensive Data File bundle.
  • AccommodationAssignment.csv - One required or optional file in the Comprehensive Data File bundle.
RelationshipsNone specified.Edge casesNone specified.

Example
AssessmentResults.csv

Source
NWEAMap architecture gap fill

Platform-owned field

source_row_numberPlatform gap-fill INTEGER
Platform-owned
Required.

One-based data-row number inside the CDF file, excluding the header.

Constraints
  • Must be >= 1.
  • Stable only within the import_file_id.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
42

Source
NWEAMap architecture gap fill

Platform-owned field

source_row_hashPlatform gap-fill TEXT
Platform-owned
Required.

Canonical hash of the source-file name, header position, and row values used for idempotent re-import and missing-row detection.

Constraints
  • SHA-256 hex or sha256-prefixed digest.
  • Same row content in the same file scope must produce the same hash.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
sha256:2d3f6b4e8c1a0f9b7e6d5c4b3a291807060504030201000ffeeddbbccaa9988

Source
NWEAMap architecture gap fill

Platform-owned field

ingested_atPlatform gap-fill TIMESTAMPTZ
Platform-owned
Required.

Timestamp when the platform accepted this row into tenant-scoped persistence.

Constraints
  • Must be UTC.
  • Used for audit and modifiedSince behavior.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
2026-06-03T11:00:00Z

Source
NWEAMap architecture gap fill

Platform-owned field

modified_atPlatform gap-fill TIMESTAMPTZ
Platform-owned
Required.

Timestamp when the row or its deletion/projection state last changed.

Constraints
  • Must be UTC.
  • Must be greater than or equal to ingested_at.
  • Powers modifiedSince polling.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
2026-06-03T11:00:00Z

Source
NWEAMap architecture gap fill

Platform-owned field

deleted_atPlatform gap-fill TIMESTAMPTZ
Platform-owned
Nullable.

Soft-delete timestamp set when a replacement authoritative export stops sending this source row.

Constraints
  • Null means active.
  • Non-null rows are excluded from test_of_record.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge cases
  • Soft delete is retention evidence, not a legal erasure API.

Example
2026-06-03T11:00:00Z

Source
NWEAMap architecture gap fill

Platform-owned field

deleted_by_import_idPlatform gap-fill UUID
Platform-owned
Nullable.

Replacement import that caused this row to be marked deleted.

Constraints
  • References nweamap.import(import_id) when present.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
018f4b4e-9c7a-7d3d-8b2f-2f673a000001

Source
NWEAMap architecture gap fill

Platform-owned field

delete_reasonPlatform gap-fill TEXT enum
Platform-owned
Nullable.

Platform explanation for why the row disappeared from a later authoritative export, when inferable.

Constraints
  • Must be null or one of the documented delete_reason values.
  • missing_from_replacement_export - A later authoritative export for the same scope stopped sending the row.
  • retake_superseded - Import evidence indicates the row was replaced by a retake.
  • invalidated_or_suppressed_by_nwea - Import evidence indicates NWEA invalidated or suppressed the sitting.
  • unknown - The row disappeared but the specific reason was not inferable.
RelationshipsNone specified.Edge casesNone specified.

Example
missing_from_replacement_export

Source
NWEAMap architecture gap fill

Platform-owned field

NWEA pass-through fields

FieldType and nullabilityMeaning and constraintsAllowed valuesRelationships and edge casesExample and provenance
#1TermNameNWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Term chosen for the export.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • No blanks observed in the local sample, but NWEA pass-through columns remain nullable unless NWEA explicitly requires otherwise.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

Relationships
  • Term scope is paired with tenant_id and nwea_account_id; term strings are pass-through NWEA values, not parsed by client skill packs.
Edge casesNone specified.

Example
Spring 2025-2026

Source
MAP_Export_Field_Descriptions.xlsx / field 1

1412 nonblank / 0 blank in local sample

#2StudentIDNWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

ID your district provided in the student's MAP profile.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • No blanks observed in the local sample, but NWEA pass-through columns remain nullable unless NWEA explicitly requires otherwise.
  • Student/teacher identifiers and names are tenant-scoped PII or quasi-identifiers; redact from logs and public error bodies.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

Relationships
  • Student identifier repeats across CDF collections inside the same tenant, NWEA account, and term; it is not globally unique.
Edge casesNone specified.

Example
stu-12345

Source
MAP_Export_Field_Descriptions.xlsx / field 2

1412 nonblank / 0 blank in local sample

#3Student_StateIDNWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

ID your state uses to identify the student.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • Local sample includes 1412 blank value(s); migration must allow blank/null.
  • Student/teacher identifiers and names are tenant-scoped PII or quasi-identifiers; redact from logs and public error bodies.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

Relationships
  • State student identifier is optional and may be blank; never use it as the only join key.
Edge casesNone specified.

Example
example-value

Source
MAP_Export_Field_Descriptions.xlsx / field 3

0 nonblank / 1412 blank in local sample

#4TestIDNWEA pass-through Integer
10 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Unique identifier for the test event. This ID also appears in the AssessmentResults.csv file so you can connect the two sets of data.

Constraints
  • NWEA datatype: Integer.
  • NWEA length/range: 10 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • No blanks observed in the local sample, but NWEA pass-through columns remain nullable unless NWEA explicitly requires otherwise.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

Relationships
  • Belongs to one AssessmentResults.TestID when NWEA sent the corresponding result row; one test can have many accommodation rows.
Edge casesNone specified.

Example
1110000001

Source
MAP_Export_Field_Descriptions.xlsx / field 4

1412 nonblank / 0 blank in local sample

#5AccommodationCategoryNWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Categories of the accommodations given to the student during testing. If multiple, they are shown on separate rows.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • No blanks observed in the local sample, but NWEA pass-through columns remain nullable unless NWEA explicitly requires otherwise.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
Designated Features

Source
MAP_Export_Field_Descriptions.xlsx / field 5

1412 nonblank / 0 blank in local sample

#6AccommodationNWEA pass-through String
100 characters
Blankable/nullable in storage unless NWEA explicitly populates it; never infer NOT NULL from one sample.

Accommodation choices made by the Proctor. If multiple, they are shown on separate rows. Note: The system does not track whether an accommodation, such as Text-to-Speech, was actually performed.

Constraints
  • NWEA datatype: String.
  • NWEA length/range: 100 characters.
  • CSV header is required in the file; blank cell values are stored as null/blank rather than guessed.
  • No blanks observed in the local sample, but NWEA pass-through columns remain nullable unless NWEA explicitly requires otherwise.

Closed or behaviorally important values are listed here. If empty, NWEA does not publish a closed enumeration in the workbook; preserve the exported value within the documented type/length.

RelationshipsNone specified.Edge casesNone specified.

Example
Text-to-speech: Question directions

Source
MAP_Export_Field_Descriptions.xlsx / field 6

1412 nonblank / 0 blank in local sample

platform projection

nweamap.assessment_result_projection Current assessment result projection

Purpose

Single always-up-to-date result projection fed by real-time observations and CDF backfill. It does not create a second helper store.

Lifecycle

Updated after imports and real-time observations; sittingScope chooses all rows or the selected test_of_record without client-side dedupe.

Public endpoint

GET /nweamap/v1/assessment-results?sittingScope=test_of_record

Relationships
  • Carries every AssessmentResults pass-through field by reference to nweamap.raw_assessment_results.
  • Groups by tenant_id, nwea_account_id, student_id, subject, and term_name for test_of_record selection.

Fields

FieldType and nullabilityMeaning and constraintsAllowed valuesRelationships and edge casesExample and provenance
projection_idPlatform gap-fill UUID
Platform-owned
Required; primary key.

Stable identifier for one row in the current assessment-result projection.

Constraints
  • Unique within projection.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
018f4b4e-9c7a-7d3d-8b2f-2f673a000001

Source
NWEAMap architecture gap fill

Platform-owned field

tenant_idPlatform gap-fill UUID
Platform-owned
Required.

Platform tenant boundary for the projected result.

Constraints
  • Must match JWT tenantId.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
018f4b4e-9c7a-7d3d-8b2f-2f673a000001

Source
NWEAMap architecture gap fill

Platform-owned field

nwea_account_idPlatform gap-fill TEXT
Platform-owned
Required.

Tenant-local NWEA account partition.

Constraints
  • Required filter for import/read consistency.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
nwea-account-demo

Source
NWEAMap architecture gap fill

Platform-owned field

assessment_result_row_idPlatform gap-fill UUID
Platform-owned
Required.

Raw assessment result row this projection currently represents.

Constraints
  • References nweamap.raw_assessment_results(row_id).

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
018f4b4e-9c7a-7d3d-8b2f-2f673a000001

Source
NWEAMap architecture gap fill

Platform-owned field

student_idPlatform gap-fill TEXT
Platform-owned
Required when NWEA supplied StudentID.

Copied from AssessmentResults.StudentID for query ergonomics and test-of-record grouping.

Constraints
  • Tenant/account/term scoped; not globally unique.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
stu-12345

Source
NWEAMap architecture gap fill

Platform-owned field

student_state_idPlatform gap-fill TEXT
Platform-owned
Nullable.

Copied from AssessmentResults.Student_StateID for filters when NWEA supplied it.

Constraints
  • Optional alternate identifier; do not use as sole key.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
state-stu-12345

Source
NWEAMap architecture gap fill

Platform-owned field

term_namePlatform gap-fill TEXT
Platform-owned
Required.

Copied NWEA term for grouping and API filters.

Constraints
  • Pass-through term string; clients must not parse term text for business logic.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
Spring 2025-2026

Source
NWEAMap architecture gap fill

Platform-owned field

subjectPlatform gap-fill TEXT
Platform-owned
Required.

Copied AssessmentResults.Subject for grouping by student, subject, and term.

Constraints
  • Open NWEA subject value; not a platform enum.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
Math

Source
NWEAMap architecture gap fill

Platform-owned field

coursePlatform gap-fill TEXT
Platform-owned
Nullable.

Copied AssessmentResults.Course for filters and source-reconciliation context.

Constraints
  • Open NWEA course/test scale value.
  • Not a report-family or report-cell contract.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
Growth: Math 6+

Source
NWEAMap architecture gap fill

Platform-owned field

test_idPlatform gap-fill TEXT
Platform-owned
Required.

Copied AssessmentResults.TestID; final deterministic tie-breaker when RIT and start time tie.

Constraints
  • References the raw AssessmentResults.TestID in the same tenant/account/term.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
1110000001

Source
NWEAMap architecture gap fill

Platform-owned field

test_start_atPlatform gap-fill TIMESTAMPTZ
Platform-owned
Nullable.

Parsed timestamp from TestStartDate and TestStartTime when both are parseable.

Constraints
  • If parsing fails, raw date/time remain available in pass-through fields and this field is null.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
2026-06-03T11:00:00Z

Source
NWEAMap architecture gap fill

Platform-owned field

test_rit_scorePlatform gap-fill INTEGER
Platform-owned
Nullable.

Parsed integer from AssessmentResults.TestRITScore.

Constraints
  • Eligible for test_of_record only when numeric and 100 through 350.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
238

Source
NWEAMap architecture gap fill

Platform-owned field

growth_measure_ynPlatform gap-fill TEXT
Platform-owned
Nullable.

Copied NWEA GrowthMeasureYN flag for comparison and audit.

Constraints
  • Preserve TRUE/FALSE/blank as exported; do not let it override highest-RIT rule.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
TRUE

Source
NWEAMap architecture gap fill

Platform-owned field

norms_reference_dataPlatform gap-fill TEXT
Platform-owned
Nullable.

Copied NWEA NormsReferenceData for downstream norms-aware consumers.

Constraints
  • Preserve 2020, 2025, USER, blank, or future NWEA values verbatim.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
2025

Source
NWEAMap architecture gap fill

Platform-owned field

is_valid_rit_for_recordPlatform gap-fill BOOLEAN
Platform-owned
Required.

True only when TestRITScore is numeric MAP RIT from 100 through 350.

Constraints
  • False rows remain available through all-sittings reads but cannot be test_of_record.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
true

Source
NWEAMap architecture gap fill

Platform-owned field

is_test_of_recordPlatform gap-fill BOOLEAN
Platform-owned
Required.

True for the selected highest-RIT, non-deleted row per tenant/account/student/subject/term.

Constraints
  • At most one true row per grouping.
  • False for deleted rows and invalid RIT rows.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
true

Source
NWEAMap architecture gap fill

Platform-owned field

test_of_record_rankPlatform gap-fill INTEGER
Platform-owned
Required.

Deterministic rank inside the grouping after sorting by eligibility, RIT, start time, and TestID.

Constraints
  • Rank 1 is the test_of_record when the row is eligible and not deleted.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
1

Source
NWEAMap architecture gap fill

Platform-owned field

test_of_record_reasonPlatform gap-fill TEXT enum
Platform-owned
Required.

Reason this row was selected or excluded by the test-of-record selector.

Constraints
  • Must be one of the documented reasons.
  • highest_rit - Selected because it has the highest valid TestRITScore.
  • latest_start_time_tiebreak - Selected after a RIT tie by later TestStartDate/TestStartTime.
  • test_id_tiebreak - Selected after a start-time tie by larger TestID.
  • ineligible_invalid_rit - Not eligible because TestRITScore is outside 100-350 or nonnumeric.
  • ineligible_deleted - Not eligible because the sitting is soft-deleted.
RelationshipsNone specified.Edge casesNone specified.

Example
highest_rit

Source
NWEAMap architecture gap fill

Platform-owned field

source_kindPlatform gap-fill TEXT enum
Platform-owned
Required.

Whether the projection row is sourced from CDF, real-time observation, or merged evidence.

Constraints
  • One projection row, not separate real-time and batch stores.
  • cdf - Value came from an NWEA CDF import.
  • realtime - Value came from a real-time MAP result observation.
  • merged - Projection row carries facts from both real-time and CDF sources.
RelationshipsNone specified.Edge casesNone specified.

Example
cdf

Source
NWEAMap architecture gap fill

Platform-owned field

latest_import_idPlatform gap-fill UUID
Platform-owned
Nullable.

Most recent CDF import that supplied or refreshed fields on this projection row.

Constraints
  • References nweamap.import(import_id).

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
018f4b4e-9c7a-7d3d-8b2f-2f673a000001

Source
NWEAMap architecture gap fill

Platform-owned field

modified_atPlatform gap-fill TIMESTAMPTZ
Platform-owned
Required.

Timestamp when this projection row last changed.

Constraints
  • Powers modifiedSince and eventing by polling.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
2026-06-03T11:00:00Z

Source
NWEAMap architecture gap fill

Platform-owned field

deleted_atPlatform gap-fill TIMESTAMPTZ
Platform-owned
Nullable.

Soft-delete state inherited from the raw row.

Constraints
  • Non-null rows are excluded from test_of_record.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
2026-06-03T11:00:00Z

Source
NWEAMap architecture gap fill

Platform-owned field

platform reference data

nweamap.r90_table PowerPath RIT-to-grade reference table

Purpose

NWEAMAP-owned portable observed RIT-to-grade/R90 reference data mirrored from PowerPath/production, exposed so apps and skill packs do not carry private tables.

Lifecycle

Versioned with NWEAMAP source data. Consumers pin table_version when they need reproducibility.

Public endpoint

GET /nweamap/v1/rit-to-grade/table

Relationships
  • Lookup response object nweamap.r90_lookup selects rows from this table.
  • Source of record is src/data/powerpath-rit-to-grade.csv with source_ref powerpath:/powerpath/rit-to-grade.

Fields

FieldType and nullabilityMeaning and constraintsAllowed valuesRelationships and edge casesExample and provenance
idPlatform gap-fill TEXT
Platform-owned
Required.

Stable row id for one subject/RIT source point.

Constraints
  • Format is r90_{table_subject_id}_{rit_score}.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
r90_math_239

Source
NWEAMap architecture gap fill

Platform-owned field

table_versionPlatform gap-fill TEXT
Platform-owned
Required.

NWEAMAP-owned RIT-to-grade table version.

Constraints
  • Current value is nweamap.rit_to_grade.powerpath.v2026-06-15.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
nweamap.rit_to_grade.powerpath.v2026-06-15

Source
NWEAMap architecture gap fill

Platform-owned field

table_subject_idPlatform gap-fill TEXT enum
Platform-owned
Required.

Subject used by the source table.

Constraints
  • Must be one of the documented RIT-to-grade table subjects.
  • math - Math R90 source curve.
  • reading - Reading R90 source curve.
  • language - Language Usage R90 source curve; Vocabulary and Writing aliases may resolve here.
  • science - Science R90 source curve.
RelationshipsNone specified.Edge casesNone specified.

Example
math

Source
NWEAMap architecture gap fill

Platform-owned field

subject_idPlatform gap-fill TEXT enum
Platform-owned
Required.

Alias for table_subject_id on table rows.

Constraints
  • Lookup responses may differ when a requested subject aliases to a table subject.
  • math - Math R90 source curve.
  • reading - Reading R90 source curve.
  • language - Language Usage R90 source curve; Vocabulary and Writing aliases may resolve here.
  • science - Science R90 source curve.
RelationshipsNone specified.Edge casesNone specified.

Example
math

Source
NWEAMap architecture gap fill

Platform-owned field

source_subject_namePlatform gap-fill TEXT
Platform-owned
Required.

Subject name as it appears in the PowerPath RIT-to-grade source.

Constraints
  • Preserved for provenance; clients should filter by table_subject_id.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
Math

Source
NWEAMap architecture gap fill

Platform-owned field

rit_scorePlatform gap-fill INTEGER
Platform-owned
Required.

Source RIT score for this R90 row.

Constraints
  • Valid MAP RIT source point.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
239

Source
NWEAMap architecture gap fill

Platform-owned field

r50_gradePlatform gap-fill NUMERIC
Platform-owned
Required.

R50 grade position from the PowerPath RIT-to-grade source.

Constraints
  • For Math RIT 239, r50_grade=7.3.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
7.3

Source
NWEAMap architecture gap fill

Platform-owned field

r90_gradePlatform gap-fill NUMERIC
Platform-owned
Required.

R90 grade position from the PowerPath RIT-to-grade source.

Constraints
  • Example: 4.8 means grade-level 4 plus 80 percent complete.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
4.8

Source
NWEAMap architecture gap fill

Platform-owned field

effective_gradePlatform gap-fill INTEGER
Platform-owned
Required.

Integer grade bucket immediately above r90_grade_level for downstream school-language display.

Constraints
  • For r90_grade=4.8, effective_grade=5.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
5

Source
NWEAMap architecture gap fill

Platform-owned field

r90_grade_levelPlatform gap-fill INTEGER
Platform-owned
Required.

Whole-number floor of r90_grade.

Constraints
  • For r90_grade=4.8, r90_grade_level=4.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
4

Source
NWEAMap architecture gap fill

Platform-owned field

rit90_grade_band_percentPlatform gap-fill NUMERIC
Platform-owned
Required.

MAP-inferred position through the current r90_grade_level. This is not actual course or grade-level progress.

Constraints
  • For r90_grade=4.8, rit90_grade_band_percent=80.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
80

Source
NWEAMap architecture gap fill

Platform-owned field

r90_percent_completePlatform gap-fill NUMERIC
Platform-owned
Required.

Deprecated compatibility name for rit90_grade_band_percent; not actual course or grade-level progress.

Constraints
  • For r90_grade=4.8, r90_percent_complete=80.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
80

Source
NWEAMap architecture gap fill

Platform-owned field

observation_countPlatform gap-fill INTEGER
Platform-owned
Required.

Number of source rows collapsed into this subject/RIT point when duplicate source rows exist.

Constraints
  • At least 1.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
1

Source
NWEAMap architecture gap fill

Platform-owned field

source_refPlatform gap-fill TEXT
Platform-owned
Required.

Canonical NWEAMAP source reference for the PowerPath RIT-to-grade data.

Constraints
  • Must be powerpath:/powerpath/rit-to-grade.
  • Apps, Analytics, and skill packs must not carry a private observed RIT-to-grade copy.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
powerpath:/powerpath/rit-to-grade

Source
NWEAMap architecture gap fill

Platform-owned field

platform reference response

nweamap.r90_lookup PowerPath RIT-to-grade lookup response

Purpose

Lookup response for one subject/RIT pair, including the grade position and percent-complete fields GOALS and Analytics need without local R90 logic.

Lifecycle

Computed at read time from nweamap.r90_table; not a persisted Alpha report object.

Public endpoint

GET /nweamap/v1/rit-to-grade

Relationships
  • Links back to GET /nweamap/v1/rit-to-grade/table for the selected table_subject_id.
  • May be mirrored by Analytics for Alpha readback, but the source owner remains NWEAMAP.

Fields

FieldType and nullabilityMeaning and constraintsAllowed valuesRelationships and edge casesExample and provenance
objectPlatform gap-fill TEXT const
Platform-owned
Required.

Response object marker.

Constraints
  • Must be nweamap.r90_lookup.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
nweamap.r90_lookup

Source
NWEAMap architecture gap fill

Platform-owned field

table_versionPlatform gap-fill TEXT
Platform-owned
Required.

NWEAMAP-owned RIT-to-grade table version used by the lookup.

Constraints
  • Current value is nweamap.rit_to_grade.powerpath.v2026-06-15.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
nweamap.rit_to_grade.powerpath.v2026-06-15

Source
NWEAMap architecture gap fill

Platform-owned field

requested_subject_idPlatform gap-fill TEXT
Platform-owned
Required.

Normalized subject requested by the caller.

Constraints
  • May differ from table_subject_id when the caller uses an alias such as fastmath.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
math

Source
NWEAMap architecture gap fill

Platform-owned field

table_subject_idPlatform gap-fill TEXT enum
Platform-owned
Required.

Subject curve actually used for lookup.

Constraints
  • Must be one of the documented R90 table subjects.
  • math - Math R90 source curve.
  • reading - Reading R90 source curve.
  • language - Language Usage R90 source curve; Vocabulary and Writing aliases may resolve here.
  • science - Science R90 source curve.
RelationshipsNone specified.Edge casesNone specified.

Example
math

Source
NWEAMap architecture gap fill

Platform-owned field

subject_idPlatform gap-fill TEXT
Platform-owned
Required.

Compatibility alias for requested_subject_id.

Constraints
  • Must equal requested_subject_id.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
math

Source
NWEAMap architecture gap fill

Platform-owned field

rit_scorePlatform gap-fill NUMERIC
Platform-owned
Required.

Input RIT value supplied by the caller.

Constraints
  • May be non-integer if the caller supplies a finite number.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
239

Source
NWEAMap architecture gap fill

Platform-owned field

table_rit_scorePlatform gap-fill INTEGER
Platform-owned
Nullable.

Source RIT point selected from the PowerPath RIT-to-grade table.

Constraints
  • Equals rit_score for exact matches.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
239

Source
NWEAMap architecture gap fill

Platform-owned field

r50_gradePlatform gap-fill NUMERIC
Platform-owned
Nullable.

R50 grade position returned for the selected source point.

Constraints
  • For Math RIT 239, r50_grade=7.3.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
7.3

Source
NWEAMap architecture gap fill

Platform-owned field

r90_gradePlatform gap-fill NUMERIC
Platform-owned
Nullable.

R90 grade position returned for the selected source point.

Constraints
  • Null only when no source point exists for the input RIT and subject.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
4.8

Source
NWEAMap architecture gap fill

Platform-owned field

effective_gradePlatform gap-fill INTEGER
Platform-owned
Nullable.

Integer grade bucket derived from r90_grade.

Constraints
  • For r90_grade=4.8, effective_grade=5.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
5

Source
NWEAMap architecture gap fill

Platform-owned field

r90_grade_levelPlatform gap-fill INTEGER
Platform-owned
Nullable.

Whole-number floor of r90_grade.

Constraints
  • For r90_grade=4.8, r90_grade_level=4.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
4

Source
NWEAMap architecture gap fill

Platform-owned field

rit90_grade_band_percentPlatform gap-fill NUMERIC
Platform-owned
Nullable.

MAP-inferred position through r90_grade_level. This is not actual course or grade-level progress.

Constraints
  • For r90_grade=4.8, rit90_grade_band_percent=80.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
80

Source
NWEAMap architecture gap fill

Platform-owned field

r90_percent_completePlatform gap-fill NUMERIC
Platform-owned
Nullable.

Deprecated compatibility name for rit90_grade_band_percent; not actual course or grade-level progress.

Constraints
  • For r90_grade=4.8, r90_percent_complete=80.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
80

Source
NWEAMap architecture gap fill

Platform-owned field

source_point_kindPlatform gap-fill TEXT enum
Platform-owned
Required.

How the lookup matched the source table.

Constraints
  • exact means rit_score matched a source row.
  • source_missing means no source point exists.
  • exact - Input RIT exactly matched a source table row.
  • source_missing - No source row exists for the requested RIT.
RelationshipsNone specified.Edge casesNone specified.

Example
exact

Source
NWEAMap architecture gap fill

Platform-owned field

interpolation_rit_rangePlatform gap-fill JSONB
Platform-owned
Nullable.

Reserved interpolation metadata.

Constraints
  • Currently null; do not infer interpolation unless a future version populates it.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
null

Source
NWEAMap architecture gap fill

Platform-owned field

calculator_versionPlatform gap-fill TEXT
Platform-owned
Required.

Compatibility alias for table_version.

Constraints
  • Must equal table_version.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
nweamap.rit_to_grade.powerpath.v2026-06-15

Source
NWEAMap architecture gap fill

Platform-owned field

source_refPlatform gap-fill TEXT
Platform-owned
Nullable.

Canonical NWEAMAP source reference for the selected point.

Constraints
  • Must be powerpath:/powerpath/rit-to-grade when a source point is found.

Platform-owned values are closed when listed here.

RelationshipsNone specified.Edge casesNone specified.

Example
powerpath:/powerpath/rit-to-grade

Source
NWEAMap architecture gap fill

Platform-owned field