xpms.jurisdiction_agency
TableRow level security on
The agency serving each function in a jurisdiction, reached through the project's venue (decisions D15 and D19).
Primary key: jurisdiction_id, function
| Column | Type | Nullable | Description |
|---|---|---|---|
| jurisdiction_id | xpms.canon_code | No | Jurisdiction served.References xpms.jurisdiction.jurisdiction_id |
| function | xpms.canon_code | No | Function served.References xpms.agency_function.function |
| agency | xpms.canon_text | No | Agency name, as canon names it. |
| contact | xpms.canon_text | Yes | Contact number, where stated. |