dodil/erp-brick-payroll

DODIL ERP brick: payroll

src/brick_payroll/migrations/00004_period_rows/up.sql

-- 00004_period_rows - data only (slice B item 2): the Class 1 and auto-enrolment bands for fortnightly and four-weekly pay periods, each flagged to_confirm and
-- checked 2026-10-26 (multi-week Class 1 bands = weekly band x weeks; auto-enrolment = DWP's pay reference period figures). Plain INSERTs: the migration journal runs this once.

INSERT INTO prl_statutory_rate (rate_key, region, frequency, valid_from, value, unit, source, to_confirm, set_by, created_at, updated_at) VALUES
    ('ni_primary_threshold', 'uk', 'fortnightly', DATE '2026-04-06', 484.0000, 'amount', 'weekly band x weeks (HMRC period tables) / DWP auto-enrolment pay reference period figures, checked 2026-10-26', TRUE, 'seed', NOW(), NOW()),
    ('ni_primary_threshold', 'uk', 'four_weekly', DATE '2026-04-06', 968.0000, 'amount', 'weekly band x weeks (HMRC period tables) / DWP auto-enrolment pay reference period figures, checked 2026-10-26', TRUE, 'seed', NOW(), NOW()),
    ('ni_upper_earnings_limit', 'uk', 'fortnightly', DATE '2026-04-06', 1934.0000, 'amount', 'weekly band x weeks (HMRC period tables) / DWP auto-enrolment pay reference period figures, checked 2026-10-26', TRUE, 'seed', NOW(), NOW()),
    ('ni_upper_earnings_limit', 'uk', 'four_weekly', DATE '2026-04-06', 3868.0000, 'amount', 'weekly band x weeks (HMRC period tables) / DWP auto-enrolment pay reference period figures, checked 2026-10-26', TRUE, 'seed', NOW(), NOW()),
    ('ni_secondary_threshold', 'uk', 'fortnightly', DATE '2026-04-06', 192.0000, 'amount', 'weekly band x weeks (HMRC period tables) / DWP auto-enrolment pay reference period figures, checked 2026-10-26', TRUE, 'seed', NOW(), NOW()),
    ('ni_secondary_threshold', 'uk', 'four_weekly', DATE '2026-04-06', 384.0000, 'amount', 'weekly band x weeks (HMRC period tables) / DWP auto-enrolment pay reference period figures, checked 2026-10-26', TRUE, 'seed', NOW(), NOW()),
    ('ae_qualifying_lower', 'uk', 'fortnightly', DATE '2026-04-06', 240.0000, 'amount', 'weekly band x weeks (HMRC period tables) / DWP auto-enrolment pay reference period figures, checked 2026-10-26', TRUE, 'seed', NOW(), NOW()),
    ('ae_qualifying_lower', 'uk', 'four_weekly', DATE '2026-04-06', 480.0000, 'amount', 'weekly band x weeks (HMRC period tables) / DWP auto-enrolment pay reference period figures, checked 2026-10-26', TRUE, 'seed', NOW(), NOW()),
    ('ae_qualifying_upper', 'uk', 'fortnightly', DATE '2026-04-06', 1934.0000, 'amount', 'weekly band x weeks (HMRC period tables) / DWP auto-enrolment pay reference period figures, checked 2026-10-26', TRUE, 'seed', NOW(), NOW()),
    ('ae_qualifying_upper', 'uk', 'four_weekly', DATE '2026-04-06', 3867.0000, 'amount', 'weekly band x weeks (HMRC period tables) / DWP auto-enrolment pay reference period figures, checked 2026-10-26', TRUE, 'seed', NOW(), NOW());