Templates and runs live in the same table; the isTemplate flag tells
SteadyOn which is which. The fields below apply to both unless noted.
| Field | Required | Notes |
|---|
| Title | Yes | Run titles auto-fill from template name + date. |
| Description | No | Free text. |
| Category | Yes | Lookup. Defaults: General workplace, Fire safety, Equipment, First aid, Hazardous substances, Manual handling. |
| Sections | Yes | Inline list, ordered. Each has a stable ID. |
| Items | Yes | Inline list within a section, ordered. Each has a stable ID and a question text. |
| Field | Required | Notes |
|---|
| Site | Yes | Picks from Sites. |
| Scheduled date | Yes | Drives BRAG before completion. |
| Inspector | No (recommended) | Picks from People or members. |
For each item, the inspector records:
| Field | Notes |
|---|
| Result | One of Pass, Fail, N-A. |
| Note | Free text. May be required-on-fail per template. |
| Linked actions | Auto-populated when actions are raised from the item. |
| Field | Required | Notes |
|---|
| Status | Yes | Lookup. Defaults for runs: Scheduled, In progress, Complete, Cancelled. Templates have their own status (Active / Archived). |
| Field | Notes |
|---|
| Pass count | Items marked Pass. |
| Fail count | Items marked Fail. |
| N-A count | Items marked N-A. |
| Score % | Pass / (Pass + Fail) × 100. |
| Field | Set by | Notes |
|---|
| Created / Modified | System | Snapshots; see Audit metadata. |