Primary Key

FK of a jobs

Foreign key of the work instruction template step (see ) this outcome was recorded against.

Foreign key of the user who recorded this outcome.

Foreign key of the action type recorded for this step (see ).

Display name of the action type (e.g. "repair", "change"), a denormalized copy of 's value.

Name of the checklist step, copied from the work instruction step this outcome was recorded against.

One of the constant value, can be Ok,NotOk,Replaced,NotApplicable

When going to a status (like ok, not ok, replace , notapplicable) this date is set

Free-text remark entered by the technician about this outcome.

In case of a problem, an advice can be asked

Order field, sequence asc (0 is first)

Foreign key of the job_work_instruction header record (see ) this step outcome belongs to.

Foreign key of the job_work_instruction_details step (the per-job generated checklist step) this outcome belongs to.

Readonly system field managed by database, filled with GetUtcDate when adding,updating

Comma-separated list of foreign keys of files attached as evidence for this outcome (e.g. photos taken by the technician).

Foreign key of the filled in for this step, when requires one.

Foreign key of the parent job_work_instruction_list row when this step belongs to a group (see ).

Indicates this row represents a group header for child steps (see ), rather than an actual outcome entry.

Kind of checklist step this outcome represents (e.g. a simple check vs a measurement step), copied from the work instruction step's configuration.

Foreign key of the report type required for this step, copied from the work instruction step's configuration (see for the resulting filled-in report).

Number of reference documents attached to the work instruction step this outcome was recorded against.

Indicates the "OK" outcome option was offered to the technician for this step.

Indicates the "Not OK" outcome option was offered to the technician for this step.

Indicates the "Replaced" outcome option was offered to the technician for this step.

Indicates the "Not Applicable" outcome option was offered to the technician for this step.

Foreign key of a reference file/document attached to the work instruction step this outcome was recorded against.

Foreign key of the work instruction type controlling which outcome options are available (see ).

Serialized set of outcome options enabled for this step, when they differ from the defaults defined by .

Indicates this step's details were manually customized rather than copied as-is from the work instruction template.