v_personnel

v_personnel

Purpose

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

    • Referenced through personnel_id

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

    • One personnel can have many pay rates

    • Referenced through personnel_id



Table



Column

Type

Description

id

integer

Primary key

personnel_id

integer

Personnel ID

batt_dept_id

integer

Department ID

client_code

varchar(28)

Organization ID

personnel_created_at

timestamp

Creation time

personnel_birth_date

date

Birth date

personnel_start_date

date

Start date

personnel_status_code

varchar(15)

Status code

personnel_gender_code

varchar(15)

Gender code

personnel_career_volunteer

varchar(40)

Career status

personnel_agency_id

varchar(9)

Agency ID

personnel_cad_id

varchar(36)

CAD ID

personnel_badge_number

varchar(15)

Badge number

personnel_rank

varchar(100)

Rank

personnel_apparatus

varchar(40)

Apparatus

admin_account_public_name

varchar(255)

Public name

email_is_approved

boolean

Email status

personnel_qualifiers

text

Qualifications

personnel_groups

text

Group memberships





    • Related Articles

    • v_personnel_nemsis_licensure

      Purpose Personnel NEMSIS licensure records. Relationships v_personnel_nemsis: Many-to-One (N:1) Many licenses link to one NEMSIS record Referenced through personnel_nemsis_id v_personnel: Many-to-One (N:1) Many licenses link to one personnel ...

    • v_personnel_nemsis

      Purpose Personnel NEMSIS certification details. Relationships v_personnel: Many-to-One (N:1) Many NEMSIS records link to one personnel Referenced through personnel_id v_personnel_nemsis_licensure: One-to-Many (1:N) One NEMSIS record can have many ...

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

    • v_incident_report_personnel

      Purpose Personnel response records for incidents. Relationships v_incident_report_apparatus: Many-to-One (N:1) Many personnel link to one apparatus response Referenced through incident_report_apparatus_id v_personnel: Many-to-One (N:1) Many responses ...