dodil/erp-brick-payroll

DODIL ERP brick: payroll

src/brick_payroll/migrations/00005_p45/up.sql

-- 00005_p45 - slice B item 3: the P45 of an employment as data, in (from the previous employer) and out (issued at leaving). Additive only.

CREATE TABLE IF NOT EXISTS prl_p45 (
    payroll_id    VARCHAR NOT NULL,
    direction     VARCHAR NOT NULL,
    paye_ref      VARCHAR,
    leaving_date  DATE,
    tax_code      VARCHAR,
    basis         VARCHAR,
    pay_to_date   NUMERIC(18,2),
    tax_to_date   NUMERIC(18,2),
    student_loan  BOOLEAN,
    ni_category   VARCHAR,
    source_ref    VARCHAR,
    document_key  VARCHAR,
    recorded_by   VARCHAR,
    created_at    TIMESTAMP,
    updated_at    TIMESTAMP,
    PRIMARY KEY (payroll_id, direction)
);