flag_rules
Data license: Verejne udaje Slovenskej republiky · Data source: Centralny register zmluv
- id
- Jedinecny identifikator pravidla (slug)
- label
- Kratky nazov pravidla
- description
- Popis co pravidlo deteguje
- severity
- Zavaznost: info, warning alebo danger
- sql_condition
- SQL WHERE podmienka (pouziva z.* pre zmluvy, e.* pre extractions)
- needs_extraction
- Ci pravidlo vyzaduje JOIN na extractions tabulku (1=ano, 0=nie)
- enabled
- Ci je pravidlo aktivne (1=ano, 0=nie)
- created_at
- Datum vytvorenia pravidla
36 rows
This data as json, CSV (advanced)
Suggested facets: severity, sql_condition, needs_extraction, created_at, created_at (date)
| id ▼ | label | description | severity | sql_condition | needs_extraction | enabled | created_at |
|---|---|---|---|---|---|---|---|
| amount_outlier | Neobvykle vysoka suma | Suma zmluvy je viac ako 3 standardne odchylky nad priemerom pre danu kategoriu sluzieb | warning | __custom__ | 1 | 1 | 2026-03-07 20:38:29 |
| bezodplatne | Bezodplatna zmluva | Zmluva je bezodplatna (bez financnej odplaty) | warning | e.bezodplatne = 1 | 1 | 1 | 2026-03-07 11:24:17 |
| contract_splitting | Delenie zakazky | Dodavatel ma 5+ zmluv pod 15 000 EUR s rovnakym objednavatelom za rok, spolu nad 15 000 EUR | warning | __custom__ | 0 | 1 | 2026-03-07 20:38:29 |
| dodatok_price_inflation | Navysenie ceny dodatkami | Celkova suma zmluvy je o viac ako 50% vyssia nez povodna suma a navysenie presahuje 50 000 EUR | warning | z.suma_celkom IS NOT NULL AND z.suma IS NOT NULL AND z.suma > 0 AND z.suma_celkom > z.suma * 1.5 AND (z.suma_celkom - z.suma) > 50000 | 0 | 1 | 2026-03-07 20:38:29 |
| dormant_then_active | Spaca firma | Dodavatel nemal ziadnu zmluvu 2+ roky a naraz dostal velku zakazku (nad 50 000 EUR) | warning | __custom__ | 0 | 1 | 2026-03-07 20:38:29 |
| excessive_penalties | Nadmerny pocet pokut | Zmluva obsahuje neobvykle vysoky pocet zmluvnych pokut (viac ako 5) | info | e.penalty_count > 5 | 1 | 1 | 2026-03-07 20:38:29 |
| foreign_supplier | Zahranicny dodavatel | Dodavatel je registrovany v zahranici podla registra uctovnych zavierok (RUZ) | info | z.dodavatel_ico IS NOT NULL AND z.dodavatel_ico != '' AND z.dodavatel_ico IN (SELECT cin FROM ruz_entities WHERE region = 'Zahraničie' AND cin IS NOT NULL) | 0 | 1 | 2026-03-07 20:38:29 |
| fresh_company | Cerstve zalozena firma | Dodavatel bol zalozeny menej ako 1 rok pred podpisom zmluvy | warning | __custom__ | 0 | 1 | 2026-03-07 20:16:08 |
| fresh_micro_large | Nova mikro firma, velka zmluva | Dodavatel bol zalozeny menej ako 1 rok pred podpisom, ma 0-1 zamestnancov a zmluva je nad 50 000 EUR | danger | z.suma > 50000 AND z.id IN (SELECT zmluva_id FROM red_flags WHERE flag_type = 'fresh_company') AND z.dodavatel_ico IN (SELECT cin FROM ruz_entities WHERE organization_size_id IN (1, 2) AND cin IS NOT NULL AND terminated_on IS NULL) | 0 | 1 | 2026-03-07 20:38:29 |
| fs_tax_debtor | Danovy dlznik FS | Dodavatel je na zozname danovych dlznikov Financnej spravy SR (podla nazvu firmy) | danger | __custom__ | 0 | 1 | 2026-03-08 12:32:45 |
| fs_vat_dereg_risk | Dovody na zrusenie DPH | U dodavatela nastali dovody na zrusenie registracie pre DPH (podla ICO) | danger | __custom__ | 0 | 1 | 2026-03-08 12:32:45 |
| fs_vat_deregistered | Vymazany z DPH registra | Dodavatel bol vymazany zo zoznamu platitelov DPH (podla ICO) | danger | __custom__ | 0 | 1 | 2026-03-08 12:32:45 |
| hidden_entities | Skryte entity | Zmluva obsahuje tretie strany okrem hlavnych zmluvnych stran | warning | e.hidden_entity_count > 0 | 1 | 1 | 2026-03-07 11:24:17 |
| hidden_entity_is_supplier | Skryta entita je dodavatel | Skryta entita v zmluve (ICO) je zaroven dodavatelom v inych zmluvach | warning | __custom__ | 1 | 1 | 2026-03-07 20:38:29 |
| hidden_price | Skryta cena | Zmluva nema uvedenu sumu (suma je NULL) | warning | z.suma IS NULL | 0 | 1 | 2026-03-07 11:24:17 |
| high_subcontracting | Vysoka miera subdodavok | Maximalny podiel subdodavatela je 80% a viac — dodavatel vykonava len malu cast zakazky sam | warning | CAST(e.subcontractor_max_percentage AS REAL) >= 80 | 1 | 1 | 2026-03-07 21:08:50 |
| micro_supplier_large_contract | Mikro dodavatel, velka zmluva | Dodavatel ma 0-1 zamestnancov podla RUZ, ale zmluva presahuje 100 000 EUR | warning | z.suma > 100000 AND z.dodavatel_ico IS NOT NULL AND z.dodavatel_ico != '' AND z.dodavatel_ico IN (SELECT cin FROM ruz_entities WHERE organization_size_id IN (1, 2) AND cin IS NOT NULL AND terminated_on IS NULL) | 0 | 1 | 2026-03-07 20:16:08 |
| missing_attachment | Chybajuca priloha | Zmluva nema ziadnu prilohu — dokument zmluvy nebol zverejneny | warning | z.id NOT IN (SELECT zmluva_id FROM prilohy) | 0 | 1 | 2026-03-07 20:38:29 |
| missing_expiry | Neuvedena platnost | Zmluva nema uvedeny datum platnosti (platnost_do) | info | z.platnost_do IS NULL OR z.platnost_do = '' | 0 | 1 | 2026-03-07 11:24:17 |
| missing_ico | Dodavatel bez ICO | Dodavatel nema uvedene ICO (identifikacne cislo organizacie) | info | z.dodavatel_ico IS NULL OR z.dodavatel_ico = '' | 0 | 1 | 2026-03-07 11:24:17 |
| nace_mismatch | Nesulad odvetvia | Registrovane odvetvie dodavatela (NACE) nezodpoveda predmetu zmluvy | warning | __custom__ | 1 | 1 | 2026-03-07 20:38:29 |
| negative_equity | Zaporne vlastne imanie | Dodavatel vykazuje zaporne vlastne imanie v poslednej uctovnej zavierke (podla RUZ) | danger | __custom__ | 0 | 1 | 2026-03-08 12:32:45 |
| nonprofit_large_contract | Neziskovka s velkou zmluvou | Dodavatel je neziskova organizacia, nadacia alebo fond s zmluvou nad 100 000 EUR | warning | z.suma > 100000 AND z.dodavatel_ico IS NOT NULL AND z.dodavatel_ico != '' AND z.dodavatel_ico IN (SELECT cin FROM ruz_entities WHERE legal_form_id IN (117, 118, 119) AND cin IS NOT NULL) | 0 | 1 | 2026-03-07 20:38:29 |
| not_in_ruz | Dodavatel nie je v RUZ | Dodavatel s ICO nie je evidovany v registri uctovnych zavierok | info | z.dodavatel_ico IS NOT NULL AND z.dodavatel_ico != '' AND length(z.dodavatel_ico) = 8 AND z.dodavatel_ico NOT IN (SELECT cin FROM ruz_entities WHERE cin IS NOT NULL) | 0 | 1 | 2026-03-07 20:16:08 |
| rapid_succession | Zmluvy v rychlom slede | Dodavatel dostal 3+ zmluvy od rovnakeho objednavatela v priebehu 14 dni | warning | __custom__ | 0 | 1 | 2026-03-07 20:38:29 |
| signatory_overlap | Zdielany podpisujuci | Osoba podpisujuca zmluvu za dodavatela sa nachadza aj v zmluvach inych dodavatelov (3+ firmy) | warning | __custom__ | 1 | 1 | 2026-03-07 20:38:29 |
| socpoist_debtor | Dlznik Socialnej poistovne | Dodavatel je dlznik Socialnej poistovne (podla nazvu firmy) | danger | __custom__ | 0 | 1 | 2026-03-07 18:57:50 |
| supplier_advantage | Pokuty zvyhodnuju dodavatela | Zmluvne pokuty su nastavene v prospech dodavatela (neobvykle v statnych zmluvach) | danger | e.penalty_asymmetry = 'supplier_advantage' | 1 | 1 | 2026-03-07 11:24:17 |
| supplier_monopoly | Monopolny dodavatel | Dodavatel ma 10+ zmluv s rovnakym objednavatelom | info | __custom__ | 0 | 1 | 2026-03-07 20:38:29 |
| tax_unreliable | Danovo nespolahlivy dodavatel | Dodavatel ma status 'menej spolahlivy' podla Financnej spravy SR | danger | z.dodavatel_ico IN (SELECT ico FROM tax_reliability WHERE status = 'menej spoľahlivý') | 0 | 1 | 2026-03-07 17:20:39 |
| tax_unreliable_entity | Danovo nespolahlivy subjekt v zmluve | Zmluva obsahuje tretiu stranu (skrytu entitu) s ICO, ktora je 'menej spolahlivy' podla Financnej spravy SR | danger | __custom__ | 1 | 1 | 2026-03-07 17:20:39 |
| terminated_company | Zrusena firma | Dodavatel je zruseny/zaniknuty podla registra uctovnych zavierok (RUZ) | danger | z.dodavatel_ico IS NOT NULL AND z.dodavatel_ico != '' AND z.dodavatel_ico IN (SELECT cin FROM ruz_entities WHERE terminated_on IS NOT NULL AND cin IS NOT NULL) | 0 | 1 | 2026-03-07 20:16:08 |
| threshold_gaming | Tesne pod limitom EU sutaze | Suma zmluvy je tesne pod hranicou 215 000 EUR pre povinnu EU sutaz (210-215K banda), co moze naznacovat umyselne vyhybanie sa transparentnejsiemu obstaravaniu | warning | __custom__ | 0 | 1 | 2026-03-07 22:37:12 |
| vszp_debtor | Dlznik VSZP | Dodavatel je dlznik Vseobecnej zdravotnej poistovne (podla ICO) | danger | z.dodavatel_ico IN (SELECT cin FROM vszp_debtors WHERE cin IS NOT NULL) | 0 | 1 | 2026-03-07 18:57:50 |
| vszp_debtor_entity | Skryta entita dlznik VSZP | Zmluva obsahuje skrytu entitu ktora je dlznikom VSZP (podla ICO) | danger | __custom__ | 1 | 1 | 2026-03-07 18:57:50 |
| weekend_signing | Podpis cez vikend | Zmluva bola podpisana v sobotu alebo nedelu | info | z.datum_podpisu IS NOT NULL AND z.datum_podpisu != '' AND cast(strftime('%w', z.datum_podpisu) as integer) IN (0, 6) | 0 | 1 | 2026-03-07 20:38:29 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE flag_rules (
id TEXT PRIMARY KEY, label TEXT NOT NULL, description TEXT,
severity TEXT NOT NULL DEFAULT 'warning', sql_condition TEXT NOT NULL,
needs_extraction INTEGER NOT NULL DEFAULT 0, enabled INTEGER NOT NULL DEFAULT 1,
created_at TEXT DEFAULT (datetime('now'))
);