Statistical returns & survey engine¶


ID	`MOD-057`
System	SD06
Repo	`bank-risk-platform`
Build status	Deployed
Deployed	Yes
Last commit	`54197c02fff0ca78a988e6140d31778e59f05b46`

Approval gate (FR-807)¶

This module does not submit automatically. The submission orchestrator checks REGULATORY.RETURN_APPROVALS before posting to RBNZ or APRA. If no approval record exists for the current (run_id, return_code), the orchestrator aborts and alerts the Finance team. The approval is written by MOD-170 (Regulatory Submissions Portal) — a Finance officer reviews the assembled return in the portal Streamlit and clicks Approve. No code path in this module can bypass the gate.

Purpose¶

Automate the preparation and submission of statistical and survey returns to RBNZ and APRA from the governed data pipeline, replacing manual spreadsheet-based submissions.

What it does¶

The module connects to the governed regulatory reporting pipeline and extracts the data required for each statistical return obligation — RBNZ Statistical Returns and APRA EFS collections — on the schedule defined in the reporting obligation register.

For each return, the module performs pre-submission validation: checking completeness, applying regulator-specified business rules, and reconciling submission totals to internal management accounts. Returns that fail validation are quarantined and the responsible officer is alerted.

Approved returns are submitted electronically to the relevant regulator via the prescribed submission channel (RBNZ data portal and APRA RAAP). Submission confirmation receipts are retained and cross-referenced against the obligation register to confirm on-time lodgement.

The module maintains a register of all statistical reporting obligations with next due dates, enabling the CCO and CFO to confirm the annual schedule sign-off required by REP-008.

Compliance reason¶

REP-008 requires statistical returns to be sourced from the governed pipeline and submitted on time to RBNZ and APRA. Manual submission processes are error-prone and lack the reconciliation and on-time tracking controls required by the policy.

Commercial reason¶

Automated statistical return preparation reduces the manual effort in the Finance and Risk functions and eliminates the risk of late submission penalties and regulatory findings arising from manual process failures.

Module dependencies¶

Depends on¶

Module	Title	Required?	Contract	Reason
MOD-042	CDC pipeline — Neon logical replication to S3 Iceberg	Required	—	Statistical returns are assembled from the governed Snowflake data pipeline fed by CDC replication.
MOD-104	AWS shared infrastructure bootstrap	Required	—	MOD-104 provisions the S3 Iceberg bucket (Snowflake external tables), KMS key, and bank-risk-platform EventBridge bus ARN. Required before this module can be deployed.
MOD-102	Snowflake account configuration & governance	Required	—	Snowflake account and governance provisioned by MOD-102 must exist before this module can read or write Snowflake.
MOD-170	Regulatory Submissions Portal	Required	—	Regulatory Submissions Portal owns the approval workflow and writes to REGULATORY.RETURN_APPROVALS; the submission orchestrator in this module gates on that table — MOD-170 must be deployed for any return to progress from VALIDATED to SUBMITTED.

Required by¶

Module	Title	As	Contract
MOD-170	Regulatory Submissions Portal	Optional enhancement	—

Policies satisfied¶

Policy	Title	Mode	How
REP-008	Statistical & survey reporting	`AUTO`	Automates the preparation and submission of RBNZ and APRA statistical returns from the governed data pipeline.
REP-005	Data Quality & Assurance Policy	`GATE`	Submission is gated by Finance officer approval in REGULATORY.RETURN_APPROVALS (via MOD-170); the submission orchestrator aborts if no approval record exists for the current (run_id, return_code) before posting to RBNZ or APRA.

Capabilities satisfied¶

(No capabilities mapped)

Part of SD06 — Snowflake Analytics & Risk Platform Compiled 2026-05-22 from source/entities/modules/MOD-057.yaml