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

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