v_cc_burn_permit

v_cc_burn_permit

Purpose

  1. Community burn permit records view. 

Relationships


  • v_occupancy: Many-to-One (N:1)

    • Many permits link to one location

    • Referenced through place_id

  • v_cc_burn_permit_question: One-to-Many (1:N)

    • One permit can have many questions

    • Referenced through permit_id



Table


Column

Type

Description

permit_id

integer

Primary key

client_code

varchar(28)

Organization ID

address

text

Permit address

contact_name

varchar(255)

Contact name

contact_phone

char(12)

Contact phone

contact_email

varchar(255)

Contact email

permit_type_name

varchar(255)

Permit type

permit_type

integer

Type reference

burn_permit_status

varchar(128)

Status

issue_date

date

Issue date

start_date

date

Start date

expiration_date

date

Expiration date

rejected_date

date

Rejection date

admin_account_type_code

varchar(20)

Admin type

place_id

integer

Location reference





    • Related Articles

    • v_cc_burn_permit_question

      Purpose Burn permit questions and answers view. Relationships v_cc_burn_permit: Many-to-One (N:1) Many questions link to one permit Referenced through permit_id Table Column Type Description permit_answer_id integer Primary key question text Question ...

    • Fixed Burn Permit Expiration Date

      Purpose To explain how to set a fixed expiration date for Burn Permits Video Directions 1. Navigate to Historic Permits Module 2. Click on Permit Types 3. Navigate to the Actions Column 4. Click on Edit 5. Update Permit Type Window will open 6. ...

    • Community Connect: Creating a New Burn Permit

      Purpose To explain to users how to create a new burn permit in the Community Connect Module Video Directions 1. Navigate to the Community Connect Module 2. Select Community Connect 3. Click on Burn Permits 4. The current Community Connect Permit List ...

    • Creating a Historical Permit Type

      Purpose To explain how to create a Historical Permit Type on the First Due Platform Video Instructions 1. Navigate to the Historic Permits Module Users will need to have the correct permissions to access. 2. Select Permit Types 3. This will bring up ...

    • Community Connect: Managing Burn Permits

      Purpose To explain how to manage the burn permits in the Community Connect Module Video Directions 1. Users can always use the advanced search feature at the top of the page to filter the permit list. 2. Once you have filled out the advanced search ...