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 NEMSIS Information

      Purpose To explain the NEMSIS section of the personnel record. Video Directions 1. Navigate to Personnel > Personnel List. 2. Next, select the pencil to the right of the individual whose NEMSIS information you need to update. 3. Select the NEMSIS ...

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

    • EMS Setup - Adding Custom Values for NEMSIS Questions

      Purpose The purpose of this article is to demonstrate how to create custom values for your NEMSIS questions within an EMS report. Video Coming Soon Instructions 1. Navigate to the EMS Setup found in the Incident Documentation module. 2. Select on ...

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