Telemetry Fields Reference

The bwts_iot_telemetry table contains 65+ fields. All field names below use the frontend underscore format as returned by the API (not the raw PostgreSQL column names). See Schema Overview for the column naming convention.

System metadata

Field	Type	Description
`timestamp`	datetime	UTC timestamp of the reading
`system_id`	string	BWTS system identifier
`operation_type`	string	`BALLAST` or `DEBALLAST`
`location`	string	Port name where the operation occurred
`month`	integer	Month number (1–12)

UV Reactor (UVR_)

Field	Unit	Description
`UVR_INTENSITY`	W/m²	Raw UV sensor reading — primary compliance metric
`UVR_INTENSITY_NORMALIZED`	W/m²	Temperature and turbidity corrected intensity
`UVR_POWER_OUTPUT`	% of rated	Active power delivered to the lamp array
`UVR_POWER_SETPOINT`	%	Target power level commanded to the LDC
`UVR_WATER_TEMP`	°C	Ballast water temperature at the reactor
`UVR_LEVEL`	string	UV level descriptor (e.g., HIGH, MED, LOW)

Lamp Drive Controller (LDC_)

Field	Unit	Description
`LDC_AIR_TEMP`	°C	Compartment air temperature
`LDC_FAN_SPEED`	RPM	Cooling fan speed
`LDC_FAN_STATUS`	string	Fan operational state
`LDC_WATER_ALARM`	boolean	Water ingress alarm — true if alarm active

Filter System (FLT_)

Field	Unit	Description
`FLT_DIFF_PRESSURE`	bar	Differential pressure across the filter element
`FLT_MOTOR_STATUS`	string	Filter motor state
`FLT_BACKFLUSH_ACTIVE`	boolean	True when automatic backflush is in progress
`FLT_BACKFLUSH_COUNT`	integer	Cumulative number of backflush cycles

Flow and Pressure (SYS_)

Field	Unit	Description
`SYS_FLOW_RATE`	m³/h	Ballast water flow rate
`SYS_PRESSURE`	bar	System pressure
`SYS_VALVE_POSITION`	%	Control valve opening (0 = closed, 100 = fully open)
`SYS_TOTAL_BALLAST_VOL`	m³	Cumulative ballast volume processed
`SYS_TOTAL_DEBALLAST_VOL`	m³	Cumulative deballast volume processed
`SYS_EXTERNAL_FEED`	boolean	True when external water feed is active

PLC Controller (PLC_)

Field	Unit	Description
`PLC_CPU_USAGE`	%	PLC processor utilisation
`PLC_RAM_USAGE`	%	PLC memory utilisation
`PLC_CPU_TEMP`	°C	PLC processor temperature

Process State

Field	Type	Description
`PROCESS_STATE`	string	Controller state machine value
`COMPLIANCE_MODE`	string	Operating compliance mode
`WATER_QUALITY`	string	Water quality descriptor
`WATER_QUALITY_FACTOR`	number	Numeric multiplier for intensity normalisation
`CIP_HOURS_SINCE_LAST`	hours	Hours since last Clean-in-Place cycle

Lamp Summary (aggregate across all 16 lamps)

Field	Unit	Description
`AVG_LAMP_EFFICIENCY`	%	Mean efficiency of all 16 lamps
`FAILED_LAMP_COUNT`	integer	Count of lamps with STATUS = FAILED
`DEGRADATION_IMPACT_PCT`	%	UV output reduction attributable to lamp aging
`POWER_COMPENSATION_PCT`	%	Extra power consumed to compensate for degradation

Per-lamp fields (× 16 lamps)

Each lamp XX (01 through 16) has four fields following the pattern LAMP_XX_FIELD:

Field pattern	Unit	Description
`LAMP_XX_STATUS`	string	`ACTIVE`, `STANDBY`, or `FAILED`
`LAMP_XX_EFFICIENCY`	%	Current lamp efficiency (0–100)
`LAMP_XX_RUNTIME`	hours	Cumulative operating hours
`LAMP_XX_POWER`	W	Current power draw

Access dynamically in TypeScript:

const lampId = 5
const status = telemetry[`LAMP_${String(lampId).padStart(2, '0')}_STATUS`]
const efficiency = telemetry[`LAMP_${String(lampId).padStart(2, '0')}_EFFICIENCY`]

This pattern is used throughout the dashboard components to iterate over all 16 lamps without repetition.