v_fd_permit_plan_review

v_fd_permit_plan_review

Purpose

  1. Permit plan review records.


Relationships

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

    • Many reviews link to one permit

    • Referenced through fd_permit_id

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

    • Many reviews assigned to one personnel

    • Referenced through assigned_to




Table



Column

Type

Description

id

integer

Primary key

fd_permit_id

integer

Permit reference

client_code

varchar(28)

Organization ID

address

text

Location

plan_review_type_id

integer

Review type

assigned_to

integer

Reviewer ID

received_date

date

Receipt date

completed_date

date

Completion date

total_time_review

integer

Review duration





    • Related Articles

    • Documenting a Plan Review for a Permit

      Purpose To demonstrate how to document a Plan Review when issuing a Permit. Related Articles Create and Edit Plan Review Types Creating a New Permit Invoicing Video Instructions 1. Click on Permits. 2. Click on Permits. 3. Click on New Permit. 4. ...
    • v_fd_permit

      Purpose Fire department permit records. Relationships v_occupancy: Many-to-One (N:1) Many permits link to one location Referenced through address_id v_fd_permit_plan_review: One-to-Many (1:N) One permit can have many plan reviews Referenced through ...
    • Permits: Creating a New Permit

      Purpose To provide instructions on how to Create a New Permit in the First Due Platform. Video Instructions 1. Click on Permits. 2. Click on Permits. 3. Click on New Permit. 4. Enter and select the correct address. 5. Select the correct date for ...
    • Create and Edit Permit Type

      Purpose The purpose of this Knowledge Base Article is to learn how to create and edit permit types. Related Article Adding Custom Data Fields to Permit Type Inspection Type - Part 4: Email Video Instructions 1. Click on Permits. 2. Click on Permit ...
    • Pre-Plans: Review Process

      Purpose To explain the process of a user submitting a pre-plan for review and the administrator managing that pre-plan. Video This workflow is intended for agencies that grant permission for users to add or edit a pre-plan but not publish them until ...