v_checklist_question_answers
Purpose
- Checklist completion records view.
Relationships
Table
Column | Type | Description |
id | integer | Primary key |
client_code | varchar(28) | Organization ID |
completed_at | timestamp | Completion time |
question | varchar(255) | Question text |
section | varchar(255) | Section name |
personnel_id | integer | Personnel reference |
schedule_date | timestamp | Schedule date |
personnel_name | varchar(255) | Personnel name |
answer_type_code | varchar(32) | Answer type |
checklist_id | integer | Checklist reference |
checklist_name | varchar(255) | Checklist name |
asset_name | varchar | Asset name |
asset_type | text | Asset type |
question_result | text | Answer result |
duration | integer | Duration
|
Related Articles
Assets Module Setup: Creating an Asset Checklist
Purpose The purpose of this article is to inform users how to create an asset checklist in the Assets Module Setup. Video Directions 1. Click on Assets. 2. Click on Setup. 3. Click on Check List. 4. Click on Add Check List. 5. Complete the following ...
Creating and Importing an Inspection Checklist
Purpose To demonstrate how to create an Inspection Checklist Template for importing into an account. Video Instructions 1. Click on Inspections. 2. Click on Inspection Types. 3. Click on Import XLS to download the template. 4. Click on Download ...
Inspection Type - Part 2: Creating and Editing an Inspection Checklist
Purpose To demonstrate how to create and edit an Inspection Checklist. Related Articles Inspection Type - Part 1: Creating and Editing Inspection Type Inspection Type - Part 3: Forms Inspection Type - Part 4: Email Inspection Type - Part 5: Billing ...
Assets Module Setup: Importing an Asset Checklist Via a .csv File
Purpose The purpose of this article is to inform users how to import an asset checklist in the Assets Module Setup using the First Due Checklist Import Template. Video Directions 1. Click on Assets. 2. Click on Setup. 3. Click on Check List. 4. Click ...
Inspection Record - Completing the Checklist
Purpose To demonstrate how to complete a Checklist within an Inspection Record. Related Article Adding Standard Remarks to Codes Adding Ad Hoc Violations to a Checklist Video Instructions 1. Select Checklists and Checklist sections with Inspection ...