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