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