Skip to content

entity-status-date-sweep-config schema

One config row for the generic engine-entity.status-date-sweep job — flip an entity's own status/flag field once its own date column crosses now (±day_offset days).

Pull the full JSON Schema: erp schema pull entity-status-date-sweep-config  ·  MCP: erp_get_schema {"name":"entity-status-date-sweep-config"}

Top-level properties

PropertyTypeRequiredNotes
entity_namestringyesEntity Engine entity to sweep, e.g. hcm_asset.
status_fieldstringColumn holding the gating status.
when_status_instringyesComma-separated statuses a row must currently be in to be eligible.
date_fieldstringyesDate/datetime column compared against now (+day_offset).
compare_opstringone of: lte, lt, gte, gt
day_offsetintegerCompare date_field against now + day_offset days (negative shifts earlier). Enables N-days-before reminders. Added 2026-09.
set_fieldstringField to WRITE when a row matches; defaults to status_field. Use a distinct flag field (e.g. warranty_alert_30d) so a reminder never corrupts the lifecycle enum.
set_status_tostringyesValue written into set_field on match (e.g. "true" for a boolean flag, or a new status enum value).
seeded_bystringProvenance stamp (the plugin id). Set automatically by PluginDataSeedInstaller from the seed file's "source".
activebooleanyes