xpms.jurisdiction
TablaSeguridad a nivel de fila activa
Jurisdictions (Bible tab 11) in third normal form (decision D19): the country derives from the ID; unit system and currency are stored on the country and inherited; code sets are rows of jurisdiction_code_set; jurisdiction_resolved returns tab 11 exactly. An unpopulated jurisdiction returns no answer; it never passes.
Clave primaria: jurisdiction_id
| Columna | Tipo | Admite nulos | Descripción |
|---|---|---|---|
| jurisdiction_id | xpms.canon_code | No | Jurisdiction code, country first (US, US-FL, US-FL-MIAMI-DADE). |
| ordinal | integer | No | Position of the jurisdiction in its Bible tab; the canonical display order where the code is not numeric. |
| level | xpms.canon_code | No | country, region or ahj. |
| country | xpms.canon_code | No | ISO 3166-1 alpha-2 country, derived from the ID. |
| parent | xpms.canon_code | Sí | Enclosing jurisdiction; NULL for a country.Hace referencia a xpms.jurisdiction.jurisdiction_id |
| unit_system | xpms.canon_code | Sí | imperial or metric; stated on the country and inherited unless a lower level states its own. |
| currency | xpms.currency_code | Sí | ISO 4217 currency; stated on the country and inherited unless a lower level states its own. |
| status | xpms.canon_code | No | populated or declared-unpopulated. |
| note | xpms.canon_text | Sí | Canon note. |