`spd_user_type`¶

small_user or large_user small_user or large_user, from PostcodeType

Table	Type	Nullable	Category	In the CSV export	SQL Server type
history table (`postcode_simd_history`, SPD)	string	no	derived from the NRS record	yes	`nvarchar(200)`
main table (`postcode_simd`, SSPL)	string	no	derived from the NRS record	yes	`nvarchar(200)`

Provenance in the history table (`postcode_simd_history`, SPD)¶

Where it comes from

Input	Field	Condition	Reaches the row by
`SPD/spd_postcodeindex_cut_26_2_csv/SmallUser.csv` (pinned, SHA256 `fc82f1091ac1…`)	`(which file the record is in)`	small_user for every record of this file	the row itself
`SPD/spd_postcodeindex_cut_26_2_csv/LargeUser.csv` (pinned, SHA256 `dcb060cbce01…`)	`(which file the record is in)`	large_user for every record of this file	the row itself

Scope: the row itself.

What was done to it: classified. Which of the two SPD files the record comes from. (code: simd_ingest/core/spd.py)

How it is checked (what each check tests; whether a build passed it is in that build's manifest.json["checks"])

spd.primary_key_unique: the key (pc_norm, introduced_on) is unique and never null
spd.primary_key_nonnull: the key (pc_norm, introduced_on) is unique and never null
readback.history.index_columns: the saved file's NRS columns equal the source, re-read

Why: single-combined-output

Where it comes from

Input	Field	Condition	Reaches the row by
`SSPL/sspl-2026-2/SingleRecord.csv` (pinned, SHA256 `a6b23a9abfbd…`)	`PostcodeType`		the row itself

Scope: the row itself.

What was done to it: classified. PostcodeType S is small_user, L is large_user. (code: simd_ingest/core/sspl.py)

How it is checked (what each check tests; whether a build passed it is in that build's manifest.json["checks"])

sspl.primary_key_unique: pc_norm is unique in the SSPL
sspl.postcode_type: PostcodeType takes only the values S and L
readback.main.index_columns: the saved file's NRS columns equal the source, re-read

Why: sspl-main-table