v_personnel_nemsis
Table Name: v_personnel_nemsis
Last Updated: June 01, 2026 at 01:22 AM
Columns
| Column Name | Data Type | Nullable | Default |
|---|---|---|---|
| id | integer | Yes | - |
| personnel_id | integer | Yes | - |
| address2 | character | Yes | - |
| county_code | character | Yes | - |
| national_registry_number | character | Yes | - |
| national_registry_certification_level_code | character | Yes | - |
| current_national_registry_expiration_at | date | Yes | - |
| employment_status_code | character | Yes | - |
| employment_status_at | timestamp | Yes | - |
| hire_at | timestamp | Yes | - |
| total_length_service_years | integer | Yes | - |
| date_length_service_documented_at | timestamp | Yes | - |
| extra_phone_number | text | Yes | - |
| extra_email | text | Yes | - |
| client_code | character | Yes | - |
| user_id | integer | Yes | - |
This documentation is automatically generated from the ODBC Data Warehouse schema.