v_personnel_nemsis_licensure

v_personnel_nemsis_licensure

Purpose

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

    • Referenced through personnel_id



Table



Column

Type

Description

id

integer

Primary key

licensure_state_code

varchar(20)

State code

state_licensure_id_number

varchar(50)

License number

state_ems_certification_licensure_level_code

varchar(20)

Level code

state_ems_certification_licensure_level_description

varchar

Level description

state_ems_current_certification_at

date

Current cert date

initial_state_licensure_issue_at

date

Initial issue date

current_state_licensure_expiration_at

date

Expiration date

is_current

boolean

Current status

personnel_nemsis_id

integer

NEMSIS reference

personnel_id

integer

Personnel reference

client_code

varchar(28)

Organization ID

user_id

integer

User reference




    • Related Articles

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

    • Importing Nemsis Licensure/Certification

      Purpose Statement The purpose of this article is to guide users through the process of importing personnel NEMSIS Licensure/Certification data using the Import Wizard in the Admin module. Background Information Importing personnel licensure and ...

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