v_fire_dept_user

v_fire_dept_user

Purpose

  1. Fire department user information.

Relationships

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

    • One user links to one personnel record

    • Referenced through id/user_id

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

    • One user can have many schedules

    • Referenced through user_id

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

    • One user can participate in many events

    • Referenced through user_id



Table



Column

Type

Description

id

integer

Primary key

public_name

varchar(255)

Public name

first_name

varchar(64)

First name

middle_name

varchar(64)

Middle name

last_name

varchar(64)

Last name

name_suffix

varchar(8)

Name suffix

is_active

boolean

Active status

phone

varchar(12)

Contact phone

user_subtype_code

varchar(25)

User subtype

client_code

varchar(28)

Organization ID

lock_to_device

boolean

Device lock

locked_to_device_identifier

varchar(40)

Device ID

is_sso_user

boolean

SSO status

email

varchar(255)

Email contact

role

text

User role





    • Related Articles

    • v_personnel

      Purpose Personnel information and assignments. Relationships v_fire_dept_user: One-to-One (1:1) One personnel links to one user account Referenced through id/personnel_id f_all_schedule: One-to-Many (1:N) One personnel can have many schedules ...

    • v_personnel_pay_rate

      Purpose Personnel pay rate history. Relationships v_personnel: Many-to-One (N:1) Many pay rates link to one personnel Referenced through personnel_id v_fire_dept_user: Many-to-One (N:1) Many pay rates link to one user Referenced through user_id Table ...

    • v_personnel_employment_history

      Purpose Personnel employment history records. Relationships v_personnel: Many-to-One (N:1) Many history records link to one personnel Referenced through user_id v_fire_dept_user: Many-to-One (N:1) Many history records created by one user Referenced ...

    • Calculate Needed Fire Flow

      Purpose The purpose of this Knowledge Base Article is to demonstrate the process for calculating the Needed Fire Flow for an Occupancy. Video Instructions 1. Navigate to Admin then click on Roles. 2. Select edit for the Role to enable "Calculate ...

    • Calculate Needed Fire Flow

      Purpose The purpose of this Knowledge Base Article is to demonstrate the process for calculating the Needed Fire Flow for an Occupancy. Video Instructions 1. Navigate to Admin then click on Roles. 2. Select edit for the Role to enable "Calculate ...