Skip to content

xpms.dim_permit_rule

TableRow level security on

Permit rules (Bible tab 15), stamped to their jurisdiction.

Primary key: rule

Columns of xpms.dim_permit_rule
ColumnTypeNullableDescription
rulexpms.canon_textNoRule name; unique within canon.
ordinalintegerNoPosition of the rule in its Bible tab; the canonical display order where the code is not numeric.
trigger_typexpms.canon_codeNoWhat triggers the rule: threshold, project, element or condition.
conditionxpms.canon_textNoTriggering condition.
permitxpms.canon_textNoPermit or instrument required.
ahjxpms.canon_textNoAuthority having jurisdiction.
lead_timexpms.canon_textNoLead time as canon states it.
jurisdiction_idxpms.canon_codeNoJurisdiction the rule binds to.References xpms.jurisdiction.jurisdiction_id
provenancexpms.canon_codeNoProvenance of the rule.References xpms.dim_provenance.provenance
notexpms.canon_textYesCanon note.