n8n: SWMS

3 active flows.

Summary

Flow	Trigger	Calls	Procs	Tables
SWMS Daily Decision Report	schedule: cron 0 30 6 * * *	0	0	5
SWMS Stage Three Judgement	schedule: every 1 hours	0	1	6
SWMS table refresh	schedule: every undefined	0	1	0

Flows

SWMS Daily Decision Report

• Triggers: schedule: cron 0 30 6 * * *
• Nodes: 6 · Integrations: SQL
• Tables/views read or written: EthSwmsWorkOrderDecision, primeWorkOrders, EthSwmsStage3Judgement, ethEmailMessage, primeWorkOrderItems

SWMS Stage Three Judgement

• Triggers: schedule: every 1 hours
• Nodes: 8 · Integrations: SQL, OpenAI
• Stored procedures: spEthSwmsStage3SaveJudgements
• Tables/views read or written: EthSwmsWorkOrderDecision, primeWorkOrders, primeWorkOrderItems, primeSiteForms, EthSwmsStage3Judgement, primeSiteFormItems

SWMS table refresh

• Triggers: schedule: every undefined
• Nodes: 3 · Integrations: SQL
• Stored procedures: spPopulateEthSwmsJobStatus