dodil/erp-brick-payroll

DODIL ERP brick: payroll

src/brick_payroll/migrations/00006_rti_submission/up.sql

-- 00006_rti_submission - slice B item 4: the FPS, EPS and pension contribution files sent (or waiting for a person to send) through a capability. Additive only.

CREATE TABLE IF NOT EXISTS prl_rti_submission (
    submission_id   VARCHAR NOT NULL,
    kind            VARCHAR,
    pay_run_id      VARCHAR,
    company_code    VARCHAR,
    paye_ref        VARCHAR,
    tax_year        VARCHAR,
    tax_period      INTEGER,
    scheme_code     VARCHAR,
    n               INTEGER,
    object_key      VARCHAR,
    sha256          VARCHAR,
    status          VARCHAR,
    correlation_id  VARCHAR,
    message         VARCHAR,
    errors_json     VARCHAR,
    totals_json     VARCHAR,
    attempts        INTEGER,
    due_on          DATE,
    sent_at         TIMESTAMP,
    created_at      TIMESTAMP,
    updated_at      TIMESTAMP,
    PRIMARY KEY (submission_id)
);