CheckListResults
Name: Checklist Results
Type: Ancillary
Modules: MDC, Reporting
Description: Contains the results of checklist questions returned from a vehicle.
| Field | Documentation |
|---|---|
| CheckListID | Numeric identifier of the checklist used (from the CheckLists table). |
| QuestionId | Numeric identifier of the checklist question (from the CheckListQuestions table). |
| CheckListAnswer | Result received for the question. |
| MdtId | MDT ID of the vehicle that sent the checklist results. |
| SchId | Numeric identifier of the schedule date of the booking (from the Schedules table). |
| CheckListEvent | Event type that the checklist question is about (e.g., Pre or Post inspection). |
| CheckListActivity | Activity type that the checklist question is about (e.g., Login). |
| EventId | Numeric identifier of the event that the checklist is about (e.g., event ID of the pullout) ( from the Events table). |
| ClientId | Numeric identifier of the client that the checklist question is about (from the Clients table). |
| EmployeeId | Numeric identifier of the employee that the checklist was completed by (from the Employees table). |
| Comments | Comments about the record. |
| VehicleId | Vehicle associated with the checklist results. |
| RecordDate | Date the record was added. |
| RecordTime | Time the checklist was completed (in seconds from midnight). |
| ResultId | Numeric identifier of driver checklist result or the supervisor checklist result. |
| EvStrId | Daily run associated with the checklist results. |