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

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

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

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