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