sspl_release¶
lookup release this record came from
| Table | Type | Nullable | Category | In the CSV export | SQL Server type |
|---|---|---|---|---|---|
main table (postcode_simd, SSPL) |
string | no | derived from the NRS record | yes | nvarchar(200) |
Provenance in the main table (postcode_simd, SSPL)¶
Where it comes from
| Input | Field | Condition | Reaches the row by |
|---|---|---|---|
simd_ingest/sources.yaml: sspl_release (registry) |
sspl_release |
the row itself |
Scope: the row itself.
What was done to it: registry. The SSPL release the registry pins, the same on every row. (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 SSPLsspl.postcode_type: PostcodeType takes only the values S and Lreadback.main.index_columns: the saved file's NRS columns equal the source, re-read
Why: two-nrs-cuts