vehicle_checks_and_defects_v1
Vehicle checks and defects refer to the records of inspections performed on a vehicle, typically conducted at the beginning of the day using the vehicle check worksheets prior to the vehicle being used for tasks or assignments. Note that legacy ticksheets are not included in this mart.
| Column | Data type | Description |
|---|---|---|
| id | VARCHAR(32) | The unique identifier of the vehicle checks and defects. |
| vehicle_registration_number | VARCHAR(100) | The registration number of the inspected vehicle. |
| resource_name | VARCHAR(100) | The name of the resource assigned to the vehicle at the time of inspection. |
| checked_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of when the inspection occurred. |
| vehicle_check_note | VARCHAR(1000) | This is a free text field where any notes or observations made during the completion of the vehicle check can be entered. |
| question_text | VARCHAR(2000) | This field details the specific textual representation of the question from the inspection worksheet associated with the vehicle check. |
| answer_text | VARCHAR(4000) | The textual representation of the answer given to the corresponding worksheet question during the vehicle check. |
| answer_note | VARCHAR(8144) | Additional textual notes provided for the worksheet answer. |
| answered_at | TIMESTAMP_TZ(9) | The timestamp with the timezone offset of when the worksheet question was answered. |
| has_defect | VARCHAR(3) | This field specifies whether a defect was identified and raised in response to the inspection question. Possible values: 'Yes', 'No'. |
| defect_created_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset when the defect record was created. |
| defect_due_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset when the defect is due. |
| defect_status | VARCHAR(20) | The current state of the defect. Possible values: 'Unactioned', 'Actioned', 'Archived'. |
| defect_severity | VARCHAR(100) | This field indicates the criticality of the defect or how urgently action may be required. |
| defect_flag | VARCHAR(100) | The 'Defect Flag' field is used to mark the status of the defect, often used for quick visual reference. |
| defect_note | VARCHAR(500) | Additional details or observations about the defect inputted as free text. |
| defect_comment | VARCHAR(500) | This is a free text field where comments can be entered when a defect is raised. |
| _vehicle_id | NUMBER(38,0) | The identifier of the vehicle associated with the vehicle check. |
| _resource_id | NUMBER(38,0) | The identifier of the resource associated with the vehicle check. |
| _last_sync_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of when the vehicle check data was last refreshed. |