Emergency lighting compliance is one of the few areas of facilities management where the failure mode is not an equipment cost — it is a coroner's inquest. BS 5266-1 requires monthly functional tests, a 1-hour discharge test every six months, and a 3-hour full-duration test annually. The question is whether your record-keeping can prove all three are happening, per fitting, with results.
The Cost of Losing Track of a Single Fitting
A building with 60 emergency light fittings managed through a shared spreadsheet will develop gaps within three months. Someone forgets to update April for the stairwell bulkhead. The 6-monthly test date for the server room LED panel gets overwritten by the person who booked the contractor. A "Failed" result from October disappears when the file is re-sorted by location. The fitting stays in service in a degraded state, no one knows, and when the October-to-April gap shows up during a local authority audit, the responsible person has no defence.
A database record per fitting stops the drift. Each entry carries the full asset identity — site name, fitting reference, location, fitting type, circuit — and the compliance calendar is embedded in the same record. Monthly check results for January through December sit in the same row as the asset's install date and next scheduled test dates. The gap does not disappear; it shows as blank where a Pass or Fail should be.
The 1-Hour and 3-Hour Test Fields
The 6-monthly discharge test block records three sub-results: Lamp, Charge LED, and Battery — each assessed independently at the 1-hour mark. This matters because a fitting can pass the lamp test and still show a battery degradation that will cause it to fail a 3-hour duration test. The Overall (1 hour) field captures the aggregate result, but the sub-fields are the technical evidence. A lamp that passes at 1 hour but whose charge LED indicator is dim or flickering at the 50-minute mark is a fitting whose battery is approaching end-of-life, even if the Overall result is logged as Pass today.
The annual 3-hour test block repeats this structure — Lamp, Charge LED, Battery — at the full 3-hour endurance mark. The battery capacity under a sustained load is the definitive measure of whether the fitting will actually illuminate an escape route for the full required duration in a power-cut scenario. Fittings that pass the 1-hour test in June and then fail the 3-hour Lamp test in December are usually batteries that were marginal in summer but degraded through higher-load winter operation. The data makes that trajectory visible.
Fitting Type as a Maintenance Classifier
The Fitting Type field covers 13 variants: T5 Bulkhead, LED Bulkhead, LED Pin Spot, LED Downlight, LED Panel, T8 Fitting, Round LED Panel, LED Running Man, Twin Spot LED, LED Round Bulkhead, LED Fitting, and LED Running Man Exit. These are not cosmetic categories. T5 fluorescent bulkheads and LED fittings have fundamentally different failure modes and battery chemistries, and their replacement part sourcing is different. Filtering the database by fitting type before a maintenance run lets the contractor arrive with the right lamp stock for the right sites rather than dispatching a van that cannot service half the fittings it encounters.
The Status field — In Service, Failed, or Missing — flags fittings that are out of compliance at the asset level. A fitting logged as Missing means it was removed and not replaced, which is a specific regulatory gap separate from a Failed result on a test date.