xpms.jurisdiction_resolved
View
Jurisdictions with inherited unit system and currency resolved and code sets listed in order: Bible tab 11 exactly.
| Column | Type | Nullable | Description |
|---|---|---|---|
| jurisdiction_id | xpms.canon_code | Yes | Jurisdiction. |
| level | xpms.canon_code | Yes | country, region or ahj. |
| country | xpms.canon_code | Yes | Country, derived from the ID. |
| parent | xpms.canon_code | Yes | Enclosing jurisdiction. |
| unit_system | xpms.canon_code | Yes | Unit system, inherited down the chain. |
| currency | xpms.currency_code | Yes | Currency, inherited down the chain. |
| primary_code_sets | text | Yes | Adopted code sets, comma separated as tab 11 writes them. |
| status | xpms.canon_code | Yes | populated or declared-unpopulated. |
| note | xpms.canon_text | Yes | Canon note. |