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.
How to use this dictionary
Every NWEA CSV header is required. Values are nullable unless the workbook and implementation tests prove otherwise; blank is often a meaningful export state.
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.
Student and teacher examples are synthetic. The real vendored CSVs contain PII, so this site never publishes raw sample person values.
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
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
- 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.
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 label | Dictionary meaning |
|---|---|
| exact report-contract boundary | No 1EdTech table, field, or endpoint defines exact MAP Quadrants report families, report cells, or canonical report filters. |
| golden-cell boundary | No 1EdTech persistence object stores expected report-cell values or a report-verification oracle. |
| Alpha outcome-metric boundary | No 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 boundary | No 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 boundary | No 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 file | Workbook sheet | Fields | Local data rows |
|---|---|---|---|
StudentsBySchool.csv | StudentBySchool.csv | 16 | 1124 |
AssessmentResults.csv | AssessmentResults.csv | 143 | 3491 |
ClassAssignments.csv | ClassAssignments.csv | 11 | 1128 |
ProgramAssignments.csv | ProgramAssignments.csv | 5 | 0 |
AccommodationAssignment.csv | AccommodationAssignment.csv | 6 | 1412 |
Workbook sheets intentionally not mirrored as raw tables
| Workbook sheet | Why excluded from raw persistence | Architecture trace |
|---|---|---|
ComboStudentAssessment.csv | NWEA 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
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.
tenant_idnwea_account_idstudent_idsubjectterm_name
- 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.
- 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.
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.
| Field | Type and nullability | Meaning and constraints | Allowed values | Relationships and edge cases | Example 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
|
|
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
|
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
modifiedSincePlatform gap-fill |
query timestamp Platform-owned Optional. |
Returns rows or import records changed after the timestamp. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
cursorPlatform gap-fill |
query string Platform-owned Optional. |
Opaque pagination token returned by the previous list response. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
|
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
|
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
platform table
nweamap.import CDF import bundle
One submitted Comprehensive Data File bundle for one tenant, NWEA account, and term.
Received, validated, applied, failed, or no-op through idempotency replay. Import rows are audit evidence and are not deleted through the public surface.
POST /nweamap/v1/imports and GET /nweamap/v1/imports/{importId}
- Parent of import_file and every raw CDF row written by the bundle.
- References platform.idempotency_key when an Idempotency-Key was supplied.
Fields
| Field | Type and nullability | Meaning and constraints | Allowed values | Relationships and edge cases | Example and provenance |
|---|---|---|---|---|---|
import_idPlatform gap-fill |
UUID Platform-owned Required; primary key. |
Stable identifier for one submitted CDF bundle. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
tenant_idPlatform gap-fill |
UUID Platform-owned Required. |
Platform tenant boundary for this import. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
nwea_account_idPlatform gap-fill |
TEXT Platform-owned Required. |
Tenant-local NWEA account represented by the submitted bundle. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
term_namePlatform gap-fill |
TEXT Platform-owned Required. |
NWEA TermName scope for the submitted CDF bundle. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
statusPlatform gap-fill |
TEXT enum Platform-owned Required. |
Import lifecycle state. Constraints
|
|
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
idempotency_keyPlatform gap-fill |
TEXT Platform-owned Nullable. |
Optional caller-provided Idempotency-Key stored in the platform retry ledger. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
row_countsPlatform gap-fill |
JSONB Platform-owned Required. |
Per-file row counts observed during validation and application. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
problem_summaryPlatform gap-fill |
JSONB Platform-owned Nullable. |
Redacted import-level validation summary for failed or partially rejected bundles. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
received_atPlatform gap-fill |
TIMESTAMPTZ Platform-owned Required. |
Timestamp when the bundle arrived. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
applied_atPlatform gap-fill |
TIMESTAMPTZ Platform-owned Nullable. |
Timestamp when rows and projections finished applying. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
modified_atPlatform gap-fill |
TIMESTAMPTZ Platform-owned Required. |
Timestamp when import status or summary last changed. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
platform table
nweamap.import_file CDF import file evidence
Header, row-count, and validation evidence for one file inside an import bundle.
Created during validation before raw rows are applied; retained as conformance evidence.
GET /nweamap/v1/imports/{importId}
- Child of nweamap.import.
- Parent of raw CDF rows through import_file_id.
Fields
| Field | Type and nullability | Meaning and constraints | Allowed values | Relationships and edge cases | Example and provenance |
|---|---|---|---|---|---|
import_file_idPlatform gap-fill |
UUID Platform-owned Required; primary key. |
Stable identifier for one file inside an import bundle. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
import_idPlatform gap-fill |
UUID Platform-owned Required. |
Parent import bundle. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
source_filePlatform gap-fill |
TEXT enum Platform-owned Required. |
CDF file name. Constraints
|
|
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
header_hashPlatform gap-fill |
TEXT Platform-owned Required. |
Canonical hash of the submitted file header. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
row_countPlatform gap-fill |
INTEGER Platform-owned Required. |
Number of data rows in the file, excluding the header. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
validation_statusPlatform gap-fill |
TEXT enum Platform-owned Required. |
File-level validation state. Constraints
|
|
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
source_headerPlatform gap-fill |
JSONB Platform-owned Required. |
Ordered array of submitted column headers. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
field_error_countPlatform gap-fill |
INTEGER Platform-owned Required. |
Number of field-level validation errors found in this file. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
created_atPlatform gap-fill |
TIMESTAMPTZ Platform-owned Required. |
Timestamp when the file record was created. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
modified_atPlatform gap-fill |
TIMESTAMPTZ Platform-owned Required. |
Timestamp when validation status last changed. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
NWEA pass-through raw table
nweamap.raw_students_by_school Students by school raw CDF rows
Lossless mirror of NWEA student-by-school rows for one tenant, NWEA account, term, and import.
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.
GET /nweamap/v1/students
- 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.
StudentsBySchool.csv / workbook sheet StudentBySchool.csv
16 NWEA fields, 1124 local sample rows.
Platform sidecar fields
| Field | Type and nullability | Meaning and constraints | Allowed values | Relationships and edge cases | Example 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
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
Platform-owned values are closed when listed here. |
Relationships
|
Example Source Platform-owned field |
nwea_account_idPlatform gap-fill |
TEXT Platform-owned Required. |
Tenant-local NWEA account partition for the imported bundle. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
import_idPlatform gap-fill |
UUID Platform-owned Required. |
Import bundle that created or last refreshed this row. Constraints
|
Platform-owned values are closed when listed here. |
Relationships
|
Example Source Platform-owned field |
import_file_idPlatform gap-fill |
UUID Platform-owned Required. |
Import-file record for the CDF file that carried this row. Constraints
|
Platform-owned values are closed when listed here. |
Relationships
|
Example Source 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
|
|
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
ingested_atPlatform gap-fill |
TIMESTAMPTZ Platform-owned Required. |
Timestamp when the platform accepted this row into tenant-scoped persistence. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
modified_atPlatform gap-fill |
TIMESTAMPTZ Platform-owned Required. |
Timestamp when the row or its deletion/projection state last changed. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge cases
|
Example Source Platform-owned field |
deleted_by_import_idPlatform gap-fill |
UUID Platform-owned Nullable. |
Replacement import that caused this row to be marked deleted. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
|
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
NWEA pass-through fields
| Field | Type and nullability | Meaning and constraints | Allowed values | Relationships and edge cases | Example 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
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 Source 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
|
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
|
Example Source 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
|
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 Source 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
|
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 Source 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
|
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 Source 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
|
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 Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
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 Source 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
|
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 Source 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
|
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 Source 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
|
|
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
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 Source 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
|
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 Source 1124 nonblank / 0 blank in local sample |
NWEA pass-through raw table
nweamap.raw_assessment_results Assessment results raw CDF rows
Lossless mirror of NWEA assessment result rows, including growth-window, goal, Lexile/Quantile, norms, and projected-proficiency columns.
Created by CDF import or refreshed by later CDF backfill; rows remain visible to authorized audit reads with sittingScope=all and includeDeleted=true.
GET /nweamap/v1/assessment-results?sittingScope=all
- TestID connects one assessment result to zero or more accommodation assignment rows.
- TestRITScore, TestStartDate, TestStartTime, and TestID drive the test-of-record selector.
AssessmentResults.csv / workbook sheet AssessmentResults.csv
143 NWEA fields, 3491 local sample rows.
Platform sidecar fields
| Field | Type and nullability | Meaning and constraints | Allowed values | Relationships and edge cases | Example 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
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
Platform-owned values are closed when listed here. |
Relationships
|
Example Source Platform-owned field |
nwea_account_idPlatform gap-fill |
TEXT Platform-owned Required. |
Tenant-local NWEA account partition for the imported bundle. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
import_idPlatform gap-fill |
UUID Platform-owned Required. |
Import bundle that created or last refreshed this row. Constraints
|
Platform-owned values are closed when listed here. |
Relationships
|
Example Source Platform-owned field |
import_file_idPlatform gap-fill |
UUID Platform-owned Required. |
Import-file record for the CDF file that carried this row. Constraints
|
Platform-owned values are closed when listed here. |
Relationships
|
Example Source 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
|
|
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
ingested_atPlatform gap-fill |
TIMESTAMPTZ Platform-owned Required. |
Timestamp when the platform accepted this row into tenant-scoped persistence. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
modified_atPlatform gap-fill |
TIMESTAMPTZ Platform-owned Required. |
Timestamp when the row or its deletion/projection state last changed. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge cases
|
Example Source Platform-owned field |
deleted_by_import_idPlatform gap-fill |
UUID Platform-owned Nullable. |
Replacement import that caused this row to be marked deleted. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
|
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
NWEA pass-through fields
| Field | Type and nullability | Meaning and constraints | Allowed values | Relationships and edge cases | Example 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
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 Source 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
|
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
|
Example Source 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
|
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 Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
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 Source 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
|
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 Source 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
|
|
RelationshipsNone specified.Edge cases
|
Example Source 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
|
|
RelationshipsNone specified.Edge cases
|
Example Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
|
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
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 Source 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
|
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
|
Example Source 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
|
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 Source 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
|
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 Source 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
|
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 Source 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
|
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
|
Example Source 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
|
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 Source 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
|
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 Source 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
|
|
RelationshipsNone specified.Edge cases
|
Example Source 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
|
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 Source 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
|
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 Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
|
RelationshipsNone specified.Edge cases
|
Example Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
|
RelationshipsNone specified.Edge cases
|
Example Source 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
|
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 Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
|
RelationshipsNone specified.Edge cases
|
Example Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
|
RelationshipsNone specified.Edge cases
|
Example Source 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
|
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 Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
|
RelationshipsNone specified.Edge cases
|
Example Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
|
RelationshipsNone specified.Edge cases
|
Example Source 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
|
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 Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
|
RelationshipsNone specified.Edge cases
|
Example Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
|
RelationshipsNone specified.Edge cases
|
Example Source 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
|
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 Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
|
RelationshipsNone specified.Edge cases
|
Example Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
|
RelationshipsNone specified.Edge cases
|
Example Source 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
|
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 Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
|
RelationshipsNone specified.Edge cases
|
Example Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
|
RelationshipsNone specified.Edge cases
|
Example Source 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
|
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 Source 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
|
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 Source 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
|
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 Source 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
|
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 Source 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
|
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 Source 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
|
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 Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
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 Source 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
|
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 Source 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
|
|
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
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 Source 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
|
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 Source 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
|
|
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
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 Source 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
|
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 Source 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
|
|
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
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 Source 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
|
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 Source 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
|
|
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
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 Source 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
|
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 Source 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
|
|
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
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 Source 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
|
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 Source 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
|
|
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
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 Source 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
|
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 Source 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
|
|
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
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 Source 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
|
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 Source 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
|
|
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
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
|
Example Source 0 nonblank / 3491 blank in local sample |
NWEA pass-through raw table
nweamap.raw_class_assignments Class assignment raw CDF rows
Lossless mirror of NWEA class and teacher assignment rows.
Created by CDF import and retained as the class/teacher assignment evidence for the import scope.
GET /nweamap/v1/class-assignments
- 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.
ClassAssignments.csv / workbook sheet ClassAssignments.csv
11 NWEA fields, 1128 local sample rows.
Platform sidecar fields
| Field | Type and nullability | Meaning and constraints | Allowed values | Relationships and edge cases | Example 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
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
Platform-owned values are closed when listed here. |
Relationships
|
Example Source Platform-owned field |
nwea_account_idPlatform gap-fill |
TEXT Platform-owned Required. |
Tenant-local NWEA account partition for the imported bundle. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
import_idPlatform gap-fill |
UUID Platform-owned Required. |
Import bundle that created or last refreshed this row. Constraints
|
Platform-owned values are closed when listed here. |
Relationships
|
Example Source Platform-owned field |
import_file_idPlatform gap-fill |
UUID Platform-owned Required. |
Import-file record for the CDF file that carried this row. Constraints
|
Platform-owned values are closed when listed here. |
Relationships
|
Example Source 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
|
|
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
ingested_atPlatform gap-fill |
TIMESTAMPTZ Platform-owned Required. |
Timestamp when the platform accepted this row into tenant-scoped persistence. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
modified_atPlatform gap-fill |
TIMESTAMPTZ Platform-owned Required. |
Timestamp when the row or its deletion/projection state last changed. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge cases
|
Example Source Platform-owned field |
deleted_by_import_idPlatform gap-fill |
UUID Platform-owned Nullable. |
Replacement import that caused this row to be marked deleted. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
|
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
NWEA pass-through fields
| Field | Type and nullability | Meaning and constraints | Allowed values | Relationships and edge cases | Example 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
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 Source 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
|
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
|
Example Source 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
|
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 Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
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 Source 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
|
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 Source 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
|
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 Source 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
|
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 Source 0 nonblank / 1128 blank in local sample |
NWEA pass-through raw table
nweamap.raw_program_assignments Program assignment raw CDF rows
Lossless mirror of optional NWEA program assignment rows. An export with only headers is a valid empty file.
Created by CDF import when rows are present; header-only files still produce import-file evidence and zero raw rows.
GET /nweamap/v1/program-assignments
- 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.
ProgramAssignments.csv / workbook sheet ProgramAssignments.csv
5 NWEA fields, 0 local sample rows.
Platform sidecar fields
| Field | Type and nullability | Meaning and constraints | Allowed values | Relationships and edge cases | Example 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
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
Platform-owned values are closed when listed here. |
Relationships
|
Example Source Platform-owned field |
nwea_account_idPlatform gap-fill |
TEXT Platform-owned Required. |
Tenant-local NWEA account partition for the imported bundle. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
import_idPlatform gap-fill |
UUID Platform-owned Required. |
Import bundle that created or last refreshed this row. Constraints
|
Platform-owned values are closed when listed here. |
Relationships
|
Example Source Platform-owned field |
import_file_idPlatform gap-fill |
UUID Platform-owned Required. |
Import-file record for the CDF file that carried this row. Constraints
|
Platform-owned values are closed when listed here. |
Relationships
|
Example Source 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
|
|
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
ingested_atPlatform gap-fill |
TIMESTAMPTZ Platform-owned Required. |
Timestamp when the platform accepted this row into tenant-scoped persistence. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
modified_atPlatform gap-fill |
TIMESTAMPTZ Platform-owned Required. |
Timestamp when the row or its deletion/projection state last changed. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge cases
|
Example Source Platform-owned field |
deleted_by_import_idPlatform gap-fill |
UUID Platform-owned Nullable. |
Replacement import that caused this row to be marked deleted. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
|
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
NWEA pass-through fields
| Field | Type and nullability | Meaning and constraints | Allowed values | Relationships and edge cases | Example 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
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 Source 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
|
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 Source 0 nonblank / 0 blank in local sample |
NWEA pass-through raw table
nweamap.raw_accommodation_assignments Accommodation assignment raw CDF rows
Lossless mirror of NWEA accommodation rows, one row per accommodation selected by a proctor for a test event.
Created by CDF import and retained for audit even if a later export no longer carries the accommodation row.
GET /nweamap/v1/accommodations
- 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.
AccommodationAssignment.csv / workbook sheet AccommodationAssignment.csv
6 NWEA fields, 1412 local sample rows.
Platform sidecar fields
| Field | Type and nullability | Meaning and constraints | Allowed values | Relationships and edge cases | Example 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
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
Platform-owned values are closed when listed here. |
Relationships
|
Example Source Platform-owned field |
nwea_account_idPlatform gap-fill |
TEXT Platform-owned Required. |
Tenant-local NWEA account partition for the imported bundle. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
import_idPlatform gap-fill |
UUID Platform-owned Required. |
Import bundle that created or last refreshed this row. Constraints
|
Platform-owned values are closed when listed here. |
Relationships
|
Example Source Platform-owned field |
import_file_idPlatform gap-fill |
UUID Platform-owned Required. |
Import-file record for the CDF file that carried this row. Constraints
|
Platform-owned values are closed when listed here. |
Relationships
|
Example Source 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
|
|
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
ingested_atPlatform gap-fill |
TIMESTAMPTZ Platform-owned Required. |
Timestamp when the platform accepted this row into tenant-scoped persistence. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
modified_atPlatform gap-fill |
TIMESTAMPTZ Platform-owned Required. |
Timestamp when the row or its deletion/projection state last changed. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge cases
|
Example Source Platform-owned field |
deleted_by_import_idPlatform gap-fill |
UUID Platform-owned Nullable. |
Replacement import that caused this row to be marked deleted. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
|
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
NWEA pass-through fields
| Field | Type and nullability | Meaning and constraints | Allowed values | Relationships and edge cases | Example 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
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
|
Example Source 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
|
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 Source 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
|
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 Source 1412 nonblank / 0 blank in local sample |
platform projection
nweamap.assessment_result_projection Current assessment result projection
Single always-up-to-date result projection fed by real-time observations and CDF backfill. It does not create a second helper store.
Updated after imports and real-time observations; sittingScope chooses all rows or the selected test_of_record without client-side dedupe.
GET /nweamap/v1/assessment-results?sittingScope=test_of_record
- 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
| Field | Type and nullability | Meaning and constraints | Allowed values | Relationships and edge cases | Example and provenance |
|---|---|---|---|---|---|
projection_idPlatform gap-fill |
UUID Platform-owned Required; primary key. |
Stable identifier for one row in the current assessment-result projection. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
tenant_idPlatform gap-fill |
UUID Platform-owned Required. |
Platform tenant boundary for the projected result. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
nwea_account_idPlatform gap-fill |
TEXT Platform-owned Required. |
Tenant-local NWEA account partition. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
assessment_result_row_idPlatform gap-fill |
UUID Platform-owned Required. |
Raw assessment result row this projection currently represents. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
student_state_idPlatform gap-fill |
TEXT Platform-owned Nullable. |
Copied from AssessmentResults.Student_StateID for filters when NWEA supplied it. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
term_namePlatform gap-fill |
TEXT Platform-owned Required. |
Copied NWEA term for grouping and API filters. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
subjectPlatform gap-fill |
TEXT Platform-owned Required. |
Copied AssessmentResults.Subject for grouping by student, subject, and term. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
coursePlatform gap-fill |
TEXT Platform-owned Nullable. |
Copied AssessmentResults.Course for filters and source-reconciliation context. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
test_start_atPlatform gap-fill |
TIMESTAMPTZ Platform-owned Nullable. |
Parsed timestamp from TestStartDate and TestStartTime when both are parseable. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
test_rit_scorePlatform gap-fill |
INTEGER Platform-owned Nullable. |
Parsed integer from AssessmentResults.TestRITScore. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
growth_measure_ynPlatform gap-fill |
TEXT Platform-owned Nullable. |
Copied NWEA GrowthMeasureYN flag for comparison and audit. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
norms_reference_dataPlatform gap-fill |
TEXT Platform-owned Nullable. |
Copied NWEA NormsReferenceData for downstream norms-aware consumers. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
|
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
|
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
modified_atPlatform gap-fill |
TIMESTAMPTZ Platform-owned Required. |
Timestamp when this projection row last changed. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
deleted_atPlatform gap-fill |
TIMESTAMPTZ Platform-owned Nullable. |
Soft-delete state inherited from the raw row. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
platform reference data
nweamap.r90_table PowerPath RIT-to-grade reference table
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.
Versioned with NWEAMAP source data. Consumers pin table_version when they need reproducibility.
GET /nweamap/v1/rit-to-grade/table
- 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
| Field | Type and nullability | Meaning and constraints | Allowed values | Relationships and edge cases | Example and provenance |
|---|---|---|---|---|---|
idPlatform gap-fill |
TEXT Platform-owned Required. |
Stable row id for one subject/RIT source point. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
table_versionPlatform gap-fill |
TEXT Platform-owned Required. |
NWEAMAP-owned RIT-to-grade table version. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
table_subject_idPlatform gap-fill |
TEXT enum Platform-owned Required. |
Subject used by the source table. Constraints
|
|
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
subject_idPlatform gap-fill |
TEXT enum Platform-owned Required. |
Alias for table_subject_id on table rows. Constraints
|
|
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
rit_scorePlatform gap-fill |
INTEGER Platform-owned Required. |
Source RIT score for this R90 row. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
r50_gradePlatform gap-fill |
NUMERIC Platform-owned Required. |
R50 grade position from the PowerPath RIT-to-grade source. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
r90_gradePlatform gap-fill |
NUMERIC Platform-owned Required. |
R90 grade position from the PowerPath RIT-to-grade source. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
r90_grade_levelPlatform gap-fill |
INTEGER Platform-owned Required. |
Whole-number floor of r90_grade. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
source_refPlatform gap-fill |
TEXT Platform-owned Required. |
Canonical NWEAMAP source reference for the PowerPath RIT-to-grade data. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
platform reference response
nweamap.r90_lookup PowerPath RIT-to-grade lookup response
Lookup response for one subject/RIT pair, including the grade position and percent-complete fields GOALS and Analytics need without local R90 logic.
Computed at read time from nweamap.r90_table; not a persisted Alpha report object.
GET /nweamap/v1/rit-to-grade
- 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
| Field | Type and nullability | Meaning and constraints | Allowed values | Relationships and edge cases | Example and provenance |
|---|---|---|---|---|---|
objectPlatform gap-fill |
TEXT const Platform-owned Required. |
Response object marker. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
table_versionPlatform gap-fill |
TEXT Platform-owned Required. |
NWEAMAP-owned RIT-to-grade table version used by the lookup. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
requested_subject_idPlatform gap-fill |
TEXT Platform-owned Required. |
Normalized subject requested by the caller. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
table_subject_idPlatform gap-fill |
TEXT enum Platform-owned Required. |
Subject curve actually used for lookup. Constraints
|
|
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
subject_idPlatform gap-fill |
TEXT Platform-owned Required. |
Compatibility alias for requested_subject_id. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
rit_scorePlatform gap-fill |
NUMERIC Platform-owned Required. |
Input RIT value supplied by the caller. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
table_rit_scorePlatform gap-fill |
INTEGER Platform-owned Nullable. |
Source RIT point selected from the PowerPath RIT-to-grade table. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
r50_gradePlatform gap-fill |
NUMERIC Platform-owned Nullable. |
R50 grade position returned for the selected source point. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
r90_gradePlatform gap-fill |
NUMERIC Platform-owned Nullable. |
R90 grade position returned for the selected source point. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
effective_gradePlatform gap-fill |
INTEGER Platform-owned Nullable. |
Integer grade bucket derived from r90_grade. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
r90_grade_levelPlatform gap-fill |
INTEGER Platform-owned Nullable. |
Whole-number floor of r90_grade. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source 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
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
source_point_kindPlatform gap-fill |
TEXT enum Platform-owned Required. |
How the lookup matched the source table. Constraints
|
|
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
interpolation_rit_rangePlatform gap-fill |
JSONB Platform-owned Nullable. |
Reserved interpolation metadata. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
calculator_versionPlatform gap-fill |
TEXT Platform-owned Required. |
Compatibility alias for table_version. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
source_refPlatform gap-fill |
TEXT Platform-owned Nullable. |
Canonical NWEAMAP source reference for the selected point. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |
linksPlatform gap-fill |
JSONB Platform-owned Required. |
Related RIT-to-grade table endpoint. Constraints
|
Platform-owned values are closed when listed here. |
RelationshipsNone specified.Edge casesNone specified. | Example Source Platform-owned field |