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

    • 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 ...

    • Documenting a Plan Review for a Permit

      Purpose Statement This feature enables Fire/EMS personnel to properly document plan reviews as part of the permit issuance process. Plan review documentation ensures regulatory compliance, creates an audit trail for permit activities, and streamlines ...

    • Create and Edit Plan Review Types

      Purpose Statement The Plan Review Types feature allows administrators to create, manage, and customize the categories used for organizing different types of plan reviews within the permit system. This functionality enables fire departments to ...

    • Permits: Creating a New Permit

      Purpose Statement The Create a New Permit feature allows authorized users to initiate and manage fire department permits within the First Due platform. This functionality streamlines the permit application process, enables efficient tracking of ...

    • Create and Edit Permit Type

      Purpose Statement The Create and Edit Permit Types feature allows fire prevention administrators to establish and modify permit categories within the system. This functionality enables agencies to customize permit workflows, set response deadlines, ...