v_personnel_nemsis_licensure
Purpose
- Personnel NEMSIS licensure records.
Relationships
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 ...