v_personnel_nemsis

v_personnel_nemsis

Purpose

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

    • Referenced through personnel_nemsis_id



Table



Column

Type

Description

id

integer

Primary key

personnel_id

integer

Personnel reference

national_registry_number

varchar(8)

Registry number

national_registry_certification_level_code

varchar(20)

Certification level

current_national_registry_expiration_at

date

Expiration date

employment_status_code

varchar(20)

Employment status

employment_status_at

timestamp

Status date

hire_at

timestamp

Hire date

total_length_service_years

integer

Years of service

extra_phone_number

text

Additional phone

extra_email

text

Additional email

client_code

varchar(28)

Organization ID

user_id

integer

User reference





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

    • Personnel Record: NEMSIS Tab

      Purpose Statement The NEMSIS (National Emergency Medical Services Information System) tab in personnel records allows departments to document and maintain comprehensive EMS certification and licensing data for each individual. This feature ensures ...

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

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