返回 Papers
AI 扩展计划 / Playbooks

AI Regulatory Reporting / Risk Data Aggregation / Attestation Playbook

边界说明: 本手册不是法律意见、合规结论、审计结论、财务确认、监管报送建议或模型验证报告。exact applicability、报告义务、解释口径、提交时限、更正/重报判断和对外沟通由 Legal / Compliance / Regulatory Affairs / Finance / Risk / Internal Audit / authorized management 负责。本文只把官

667AI_REGULATORY_REPORTING_RISK_DATA_AGGREGATION_ATTESTATION_PLAYBOOK.md

AI Regulatory Reporting / Risk Data Aggregation / Attestation Playbook

定位: 面向 AI PM / Senior BA / Regulatory Reporting Product Lead / Risk Data Architect / Enterprise Architect / Data Governance / Finance-Risk Tech / AI Governance 的高级落地手册。 目标: 把 regulatory reporting、risk data aggregation、BCBS 239、Call Report / FR Y-14 style reporting、report lineage、transformation controls、metric definitions、reconciliations、attestation、submission evidence、issue management、correction/restatement、data quality、AI assist boundaries 和 generated narrative controls 连接成可上线、可审计、可运营的 reporting data product。 核心观点: 报送系统的产品不是"报表", 而是被定义、被控制、被签署、被提交、被追溯、可纠错的 reportable fact。

边界说明: 本手册不是法律意见、合规结论、审计结论、财务确认、监管报送建议或模型验证报告。exact applicability、报告义务、解释口径、提交时限、更正/重报判断和对外沟通由 Legal / Compliance / Regulatory Affairs / Finance / Risk / Internal Audit / authorized management 负责。本文只把官方锚点和架构实践转成产品、BA 和架构可执行 artifact。访问日期: 2026-06-30。


1. Source Anchors

AnchorOfficial link本手册使用方式
BCBS 239 Principleshttps://www.bis.org/publ/bcbs239.pdf风险数据聚合和风险报告的 governance、architecture、accuracy、completeness、timeliness、adaptability 和 review/remediation 框架。
BCBS 239 implementation updatehttps://www.bis.org/publ/bcbs_nl36.htm校准 RDARR 不是一次性项目, 而是持续数据治理和报告能力。
FDIC Current Quarter Call Report materialshttps://www.fdic.gov/bank-financial-reports/current-quarter-call-report-forms-instructions-and-related-materials作为 Call Report forms、instructions 和 updates 的官方入口之一。
FFIEC 041 Current Informationhttps://www.ffiec.gov/resources/reporting-forms/ffiec041支持 FFIEC Call Report instruction/form version management。
Federal Reserve FR Y-14Ahttps://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14Aannual capital assessment / stress testing reporting 架构锚点。
Federal Reserve FR Y-14Qhttps://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14Qquarterly detailed data schedule、asset class、capital、PPNR、retail/wholesale data 架构锚点。
Federal Reserve FR Y-14Mhttps://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14Mmonthly loan portfolio / account-level data reporting 架构锚点。
Federal Reserve SR 26-2https://www.federalreserve.gov/supervisionreg/srletters/SR2602.htm对报表模型、估计、AI 辅助分析使用 risk-based model risk 管理语言。
OCC Bulletin 2026-13https://www.occ.gov/news-issuances/bulletins/2026/bulletin-2026-13.html与 SR 26-2 交叉锚定模型风险、第三方产品和治理控制。
OCC Corporate and Risk Governancehttps://www.occ.gov/publications-and-resources/publications/comptrollers-handbook/files/corporate-risk-governance/index-corporate-and-risk-governance.html支撑 board/senior management oversight、risk governance、roles/responsibilities。
NIST AI RMFhttps://www.nist.gov/itl/ai-risk-management-framework用 Govern / Map / Measure / Manage 组织 AI 辅助报送风险管理。
ISO/IEC 42001https://www.iso.org/standard/81230.html用 AIMS、traceability、transparency、reliability 和 continual improvement 组织 AI 管理体系证据。

2. Capability Map

Regulatory instructions and obligations
  -> reporting product catalog
  -> metric contracts and semantic layer
  -> source-of-record and as-of snapshots
  -> transformation and data quality controls
  -> reconciliation and variance management
  -> report build and generated narrative controls
  -> layered attestation
  -> immutable submission evidence
  -> issue / correction / restatement loop
  -> management readiness MI
CapabilityWhy it mattersCore artifacts
Obligation management报表说明、schedule、line item、适用范围和版本必须可管理obligation register、instruction impact memo
Metric definition同一术语在风险、财务、运营和监管报送中可能不同report metric contract、semantic layer
Source and as-of control报送关心报告期事实, 不是当前数据库状态source-of-record register、freeze snapshot
Transformation control抽取、映射、分类、聚合、分摊、调整都要可测试transformation spec、rule registry、test suite
Data quality报送数据质量要覆盖准确、完整、及时、一致、有效DQ SLO matrix、exception workflow
Reconciliation对账证明数字可依赖, 不是事后解释recon rule card、break register
Attestation签署必须绑定 scope、版本、控制结果和例外attestation packet、sign-off ledger
Submission evidence提交物必须 immutable、可查、可复盘package manifest、checksum、portal confirmation
Issue and correction提交前后问题必须进入同一闭环issue ledger、impact assessment、CAPA
AI assist governanceAI 提效但不能接管责任链AI use register、prompt/output log、human approval

3. Operating Model

3.1 Reporting Product Line

把 regulatory reporting 当成产品线管理, 而不是每季度临时项目。

Product layerOwnerBacklog examples
Reporting obligation productRegulatory Reporting / Compliancenew instruction intake, schedule change, applicability workflow
Metric and semantic productFinance/Risk Data Product Ownermetric contract, taxonomy, hierarchy, line item mapping
Source data productBusiness Data Owner / Data Governancesource certification, DQ SLO, late data policy
Transformation productData Engineering / Reporting Technologypipeline control, code release, parameter governance
Reconciliation productFinance/Risk Control Ownerrecon rules, tolerance, break workflow, variance analytics
Attestation productRegulatory Reporting Ownersign-off scopes, packet templates, escalation
Evidence productArchitecture / Records / Audit Liaisonevidence vault, retention, access, audit extract
AI assist productAI Governance / Product / Model Riskapproved AI use cases, prompt registry, narrative QA

3.2 RACI

ActivityPMSenior BAArchitectData OwnerReg ReportingFinance/RiskLegal/ComplianceInternal Audit
Obligation intakeCRCCA/RCA/RI
Metric contractA/RRCCA/RA/RCI
Source certificationCCCA/RCCII
Transformation designCRA/RCCCII
Control designCRA/RCA/RA/RCC
Reconciliation dispositionICCCA/RA/RCI
AI assist approvalA/RRCCCCCI
AttestationICCA/R by scopeA/RA/RCI
SubmissionICCIA/RCCI
Issue / correction decisionCRCCA/RA/RA/RC
Control effectiveness reviewICCCCCIA/R

Legend: A = accountable, R = responsible, C = consulted, I = informed.


4. Reference Architecture

Instruction and obligation registry
  - forms, schedules, line items, instructions, Q&A, internal interpretations
        |
        v
Reporting semantic layer
  - metric contracts, data dictionary, legal entity/product/customer/account taxonomy
        |
        v
As-of reporting data platform
  - source extracts, freeze snapshots, record counts, checksums, late-arrival handling
        |
        v
Transformation and control plane
  - mapping, classification, aggregation, allocation, model/estimate feeds, manual adjustments
  - DQ, edit checks, reconciliations, variance, lineage, EUC controls
        |
        v
Report build workbench
  - schedule population, validation, narrative draft, exception disclosure, reviewer workflow
        |
        v
Attestation workflow
  - source owner, transformation owner, control owner, business/finance/risk owner, executive signer
        |
        v
Submission evidence vault
  - final files, hashes, validation results, approvals, portal confirmation, regulator Q&A
        |
        v
Issue and remediation system
  - breaks, defects, correction assessment, resubmission evidence, CAPA, control enhancement

4.1 Non-Functional Requirements

NFRReporting-specific requirement
Traceabilitymaterial report items trace to metric contract, source dataset, transformation, controls, attestation and submission package
Reproducibilityselected report period can be rebuilt from frozen inputs and versioned logic
Integrityfinal package cannot be overwritten; evidence has hash/timestamp/owner
Timelinessclose calendar, data freshness and escalation aligned to filing deadline
Resiliencecritical reporting process supports contingency, rerun and manual fallback with controls
Access controlsource data, report drafts, evidence, AI prompts and submission packages have role-based access
Segregation of dutiespreparer, reviewer, approver, submitter and evidence admin responsibilities separated where required by policy
Observabilitypipeline status, DQ, recon, attestation, issue aging and AI assist events visible
Retentionreport evidence retained according to records policy and legal hold requirements

5. Artifact Templates

5.1 Obligation Register

FieldDescription
obligation_idStable ID, e.g. OBL-CALL-031-RC-C-001
regulator / agencyFFIEC, Federal Reserve, OCC-related supervisory request, internal committee
report_familyCall Report, FR Y-14A/Q/M, internal risk report
form / schedule / itemExact form, schedule, line item or cell reference
instruction_versionOfficial instruction version and effective date
applicability ownerLegal/Compliance/Reg Reporting owner for applicability confirmation
reporting frequencymonthly, quarterly, annual, event-driven
legal entity / consolidation scopeentities and consolidation basis under confirmed scope
data ownerowner of source facts
metric_idlinked report metric contract
control_idslinked DQ, transformation, reconciliation, attestation controls
change historyinstruction change, interpretation change, implementation impact

5.2 Report Metric Contract

FieldRequired content
metric_id and nameStable name used across reports
report mappingform, schedule, line item, cell, internal MI mapping
definitionapproved business and reporting definition
numerator / denominatorexact inclusion and exclusion rules
grain and dimensionsaccount, loan, customer, legal entity, product, scenario, period
time basisas-of date, event time, posting time, available time, freeze time
source of recordauthoritative source and fallback hierarchy
transformation logicmappings, classifications, aggregations, allocations, rounding
data quality rulescompleteness, validity, freshness, consistency, uniqueness
reconciliationsource-to-source, source-to-report, cross-schedule, period variance
materiality and tolerancethreshold, rationale, approval owner
attestation ownersource, report, finance/risk and executive roles
AI usageallowed assist use, prohibited use, review requirement
versioningeffective date, approver, prior version, change impact

5.3 Transformation Control Card

FieldRequired content
rule_idStable transformation ID
linked metricaffected metric IDs and schedule items
input datasetsdataset IDs, source versions, freeze times
output datasetsreporting mart table or file
logic descriptionbusiness-readable rule
code / parameter versionrepository, release, mapping table, calendar, threshold
test casesnormal, edge, missing data, late data, negative/zero, currency, consolidation
validation ownerpreparer, reviewer, approver
change triggerinstruction change, source change, defect, optimization
rollback / rerunhow to rebuild and restore prior version

5.4 Reconciliation Rule Card

FieldRequired content
recon_idStable ID
recon typesource-to-source, source-to-report, cross-schedule, cross-report, period-over-period
compared objectsdatasets, metrics, schedules, periods
toleranceabsolute, percentage, materiality, zero tolerance
frequencydaily during close, monthly, quarterly, pre-submit
break categoriestiming, mapping, source defect, transformation, manual adjustment, instruction interpretation
owner and revieweraccountable roles
escalationthreshold, SLA, forum
evidencereport, screenshot-free data extract, ticket, approval

5.5 Attestation Packet

SectionMinimum content
Scopereport, period, legal entity, schedules, metrics
Data versionsource snapshots, record counts, checksums, freeze time
ControlsDQ, edit checks, recon, variance, manual adjustment status
Open exceptionsbreaks, issues, late data, EUC dependency, AI narrative defects
Changesinstruction, mapping, model/estimate, source, transformation, threshold
AI assistuse cases, prompts/models, outputs, reviewers, approvals
Signer statementsigner role, responsibility boundary, data version, exception acknowledgement
Evidence referencesimmutable links to logs, reports, tickets, package manifest

5.6 Submission Manifest

FieldRequired content
package_idStable package ID
report / periodform, schedules, period, legal entity scope
final filesfilenames, formats, row counts, cell counts
checksumshash for each final artifact
validation resultsinternal validation and portal validation outputs
approvalsattestation IDs and submission authorization
submitterauthorized submitter and timestamp
confirmationportal confirmation ID, receipt, warnings/errors
post-submit notesregulator questions, corrections, issue links

6. End-to-End Workflow

6.1 Obligation Intake and Impact Analysis

official instruction / form update / regulator Q&A
  -> obligation register update
  -> applicability and interpretation routed to Legal/Compliance/Reg Reporting
  -> impacted metrics, sources, transformations, controls identified
  -> implementation stories created
  -> approval and effective date recorded

Control questions:

  • Which reports, schedules and periods are affected?
  • Which metric contracts require definition changes?
  • Which source systems and mappings are impacted?
  • Is historical restatement or comparative period adjustment in scope?
  • Which attestations and evidence templates need to change?
  • Does AI assist prompt/retrieval corpus need updating?

6.2 Data Sourcing and Freeze

StepControl
Extract source datarecord count, checksum, cutoff, source owner confirmation
Freeze as-of snapshotimmutable version, reporting period, available time
Validate source qualitycompleteness, validity, uniqueness, freshness, source reconciliation
Handle late datalate-arrival policy, impact assessment, owner approval
Certify sourcesource data attestation packet

6.3 Transformation and Report Build

StepControl
Apply mappingsmapping table version, unmapped item report
Classify products/entitiestaxonomy version, exception queue
Aggregate and allocaterule version, sample replay, rounding validation
Apply model/estimate outputmodel version, parameter version, model-risk evidence where applicable
Apply manual adjustmentsreason code, evidence, dual approval, roll-forward/reversal
Populate report schedulesschedule/cell validation, precision, edit checks

6.4 Validation and Reconciliation

ValidationExamples
DQ validationmissing critical field, invalid code, stale feed, duplicate account
Edit checksallowed values, mathematical relationships, row/column totals
Source reconciliationsubledger to GL, servicing to GL, risk engine to source exposure
Cross-schedule reconciliationschedule totals and shared line items
Variance analysisperiod-over-period, budget/stress/scenario, expected trend
Narrative-to-fact checkexplanation cites approved facts and issue references

6.5 Attestation and Submission

control results complete
  -> exceptions disclosed
  -> source / transformation / control / business attestations captured
  -> final package generated
  -> package manifest and checksum created
  -> authorized submission
  -> confirmation archived

Stop rules:

  • critical reconciliation break open.
  • required source attestation missing.
  • material metric lacks approved definition.
  • final package checksum missing.
  • AI-generated narrative not reviewed.
  • issue impact not dispositioned.

6.6 Post-Submit Monitoring

TriggerAction
Regulator validation errorissue ticket, scope assessment, corrected package if authorized
Regulator questionevidence retrieval, source fact package, approved response workflow
Internal defect discoveryissue classification, impact analysis, correction decision
Audit findingcontrol remediation plan, owner, due date, closure evidence
Repeat breakroot cause review, platform backlog, management MI

7. Control Library

Control IDControl objectiveControl activityEvidence
RPT-001报送义务版本受控official forms/instructions 进入 obligation register, 记录版本和 effective dateobligation change log
RPT-002适用性判断权责清晰applicability 由 Legal/Compliance/Reg Reporting 确认, PM/BA 只提供事实底稿applicability memo
RPT-003指标定义唯一material line items 有 approved metric contractmetric contract approval
RPT-004来源数据权威source-of-record register 说明系统优先级和 ownersource register
RPT-005as-of 版本冻结每期 source snapshots 有 freeze time、record count、checksumsnapshot manifest
RPT-006数据质量可度量critical fields 有 DQ SLO 和 failure workflowDQ report
RPT-007转换逻辑可测试mappings、classifications、aggregations 有 rule version and teststest result, rule registry
RPT-008参数变更受控thresholds、mapping tables、calendars、scenarios 走审批parameter change log
RPT-009模型/估计输出受控report-used model outputs 连接 model version、input、validation/monitoring evidence where applicablemodel output evidence
RPT-010EUC 风险受控reporting spreadsheets/databases inventory, access, version, reviewEUC register
RPT-011对账覆盖关键风险material metrics 有 source-to-report and cross-check rulesreconciliation report
RPT-012break disposition 可追溯every break has category, owner, decision, approver, evidencebreak ticket
RPT-013manual adjustment 双控adjustment requires reason, evidence, preparer, approveradjustment register
RPT-014narrative 有事实支撑generated or manual narrative references approved factsnarrative QA log
RPT-015AI assist 受限AI usage registered, outputs reviewed, no direct write to report cellsAI assist log
RPT-016attestation 绑定版本sign-off references data version, controls, exceptionsattestation packet
RPT-017final package 不可覆盖final files stored with checksum and manifestsubmission manifest
RPT-018regulator Q&A 有证据链responses cite source facts and approval workflowQ&A package
RPT-019correction decision 可审计issue impact and correction/restatement decision recorded by authorized ownerscorrection decision record
RPT-020CAPA 关闭有证明root cause remediation tested and closure approvedCAPA closure evidence

8. Decision Tables

8.1 Lineage Depth by Materiality

Materiality / riskMinimum lineageAdditional requirement
Low internal reportdataset-levelowner and definition required
Standard regulatory line itemmetric-to-source datasetDQ and reconciliation evidence
Material regulatory line itemcolumn-level and transformation-levelattestation and sample replay
Loan/account-level schedulerecord-level for sample and populationfreeze snapshot and source record version
Regulator question / correctionevidence lineagesubmission package, issue, approval, response history

8.2 AI Assist Approval

AI activityDefault decisionRequired controls
Search approved instructions and evidenceAllowaccess control, retrieval log
Suggest line item mappingAllow with reviewsource citation, mapping owner approval
Generate DQ rule candidatesAllow with reviewengineer/control owner approval before deployment
Cluster reconciliation breaksAllow with reviewno auto-close, precision monitoring
Draft variance narrativeAllow with strict controlsgrounded facts, citation, human approval
Rewrite regulatory responseRestrictLegal/Compliance/Reg Reporting workflow
Change metric definitionNot allowedowner/governance only
Write final report cellNot allowedcontrolled reporting data product only
Sign attestationNot allowedhuman authorized signer only
Submit reportNot allowedauthorized submission workflow only

8.3 Correction / Restatement Severity

SeveritySignalGovernance action
Criticalmaterial submitted error, key schedule impacted, regulator validation failure, executive attestation affectedimmediate escalation, evidence freeze, authorized correction decision
Hightolerance breach or repeated defect with potential filing impactissue committee review, remediation plan, possible correction assessment
Mediumcontained data/control defect below tolerance but recurringRCA, backlog, management MI
Lowdocumentation, taxonomy, minor control improvementnormal change cycle

8.4 Manual Adjustment Approval

Adjustment typeApproval
mechanical timing adjustment below tolerancepreparer + reviewer
business classification adjustmentbusiness owner + reporting owner
material amount adjustmentfinance/risk owner + regulatory reporting owner
post-freeze adjustmentreporting owner + control owner + documented exception
adjustment affecting submitted periodcorrection governance workflow

9. Data Quality and Reconciliation Checklist

9.1 Critical DQ Rules

DimensionExample checks
Completenessrequired accounts/loans/transactions present; no missing legal entity/product/risk code
Accuracysource balance matches control account; numeric precision and sign convention correct
Validityallowed code values, date ranges, currency, product taxonomy
Consistencycustomer/account/legal entity IDs consistent across systems
Freshnessfeed arrives before freeze; stale data flagged
Uniquenessno duplicate contributing records unless explicitly allowed
Populationincluded/excluded population has reason codes
Referential integrityforeign keys to customer, product, legal entity, scenario and source records valid
Distributionmaterial shifts in balances/counts/rates flagged
Access correctnessrestricted fields not exposed to unauthorized report users or AI retrieval

9.2 Reconciliation Pack

Pack elementRequired content
Recon summarypass/fail, total breaks, amount/count, severity
Break detailbreak_id, metric, source, amount, tolerance, owner
Root causetiming, source defect, mapping, transformation, manual adjustment, instruction interpretation
Dispositioncorrected, accepted with rationale, monitored, escalated
Approvalapprover role, date, evidence
Trendrepeat breaks, aging, concentration by source/system/metric
MI impactwhether management/readiness report should show amber/red

10. AI-Generated Narrative Control

Generated narrative appears in variance explanation, management commentary, regulator Q&A draft, issue summary and attestation exception summary. It must be controlled like any other report artifact.

10.1 Narrative Contract

narrative_contract:
  purpose: variance_explanation | issue_summary | evidence_summary | q_and_a_draft
  allowed_sources:
    - approved_metric_contract
    - reconciliation_result
    - variance_table
    - issue_ledger
    - owner_comment
  required_output:
    - factual_summary
    - source_references
    - uncertainty_or_exception
    - reviewer_action
  prohibited_output:
    - legal_conclusion
    - regulatory_commitment
    - unsupported_root_cause
    - blame_assignment
    - invented_amount_or_trend

10.2 Narrative QA

QA testPass condition
Fact groundingall material claims trace to approved facts
Number consistencyvalues and direction agree with report data
Source precisionreferences point to metric/period/break/evidence ID
Scope disciplinenarrative does not explain outside approved period/report
Legal boundaryno applicability or compliance conclusion unless approved owner inserted it
Human edit recordAI output, edits and approval retained
Repeat defect monitoringfactual defects, unsupported claims and tone issues tracked

11. Issue Management and CAPA

11.1 Issue Workflow

detection
  -> triage severity
  -> freeze relevant evidence
  -> identify impacted reports / periods / metrics / entities
  -> quantify impact
  -> classify root cause
  -> decide disposition through authorized governance
  -> implement correction or remediation
  -> retest controls
  -> close with evidence

11.2 Root Cause Taxonomy

Root causeExamplePreventive control
Source datalate booking, source defect, missing fieldsource DQ SLO, feed certification
Mappingproduct/legal entity/counterparty category wrongmapping approval and unmapped report
TransformationSQL/rule/allocation bugcode review, regression test, sample replay
Metric definitionambiguous inclusion/exclusionmetric contract governance
Reconciliationtolerance too loose or break not escalatedtolerance review, break aging MI
Manual processspreadsheet overwrite, undocumented adjustmentEUC controls, dual approval
Model/estimatemodel output stale, parameter not approvedmodel output evidence, parameter governance
AI assistgenerated narrative unsupported or wrong sourcenarrative contract, QA sampling
Governanceowner unclear, attestation missingRACI, mandatory sign-off gate

11.3 CAPA Closure Criteria

CriterionRequired evidence
Root cause verifiedRCA record and supporting facts
Impact assessedimpacted reports, periods, metrics, amounts/counts
Fix implementedcode/mapping/contract/control change
Regression passedrerun result and comparison
Control strengthenednew or changed control ID
Owner attestedaccountable owner closure sign-off
Management informedMI update for high/critical issues

12. Senior Management Reporting Readiness MI

This MI is about reporting data architecture health, not generic board AI oversight.

Dashboard tileRAG signal
Filing calendar statusdue dates, build status, submission readiness
Required attestation coveragecompleted, pending, overdue by role
Critical DQ statuspass rate, failed critical rules, late feeds
Reconciliation statusopen breaks, material breaks, aging
Manual adjustment profilecount/value, late adjustments, approval exceptions
Lineage coveragecritical metrics with required lineage depth
Issue and correction statusopen critical/high issues, post-submit defects, CAPA aging
AI assist usageapproved use events, narrative QA defects, unauthorized attempts
Repeat root causestop systems, mappings, controls causing breaks

Senior management question set:

  • Which filings are blocked by data, control, attestation or submission evidence?
  • Which material metrics rely on manual workarounds or EUCs?
  • Which unresolved breaks are being accepted, by whom, and why?
  • Which source systems repeatedly produce reporting defects?
  • Which AI-generated narratives failed fact grounding?
  • Which remediation items require funding or architecture change?

13. Implementation Guardrails

GuardrailPractical rule
Contract before automationDo not automate a report item until metric contract and owner are defined
Semantic layer before AIAI reads approved metric definitions and facts, not random tables
As-of before analyticsReporting period snapshots must be frozen and reproducible
Controls in pipelineDQ, edit checks and reconciliations run before report build
Evidence by designLogs, versions, approvals and checksums are generated during workflow
No silent overrideManual adjustments, threshold changes and mapping changes require reason and approval
Dual use separationBI dashboards, management MI and regulatory filings can share data products but not uncontrolled definitions
AI low privilegeAI cannot write report cells, close breaks, approve exceptions, attest or submit
Human accountabilityevery material output has named owner and signer
Correction-readylineage and evidence must support post-submit impact analysis

14. 30-60-90 Day Roadmap

Days 1-30: Stabilize Facts

WorkstreamOutcome
Inventory top reportsCall Report / FR Y-14 / internal risk reports scoped by materiality
Identify top material metricstop schedules/line items and owner map
Build metric contract templatedefinition, source, transformation, recon, attestation fields
Map source-of-recordGL, subledger, servicing, risk engines, model outputs
Create issue registerbreaks, defects, manual adjustments, recurring root causes

Days 31-60: Engineer Controls

WorkstreamOutcome
Build as-of snapshot processfreeze, checksum, record count, late data policy
Implement critical DQ rulescompleteness, validity, freshness, consistency
Implement reconciliation packsource-to-report and period variance for material metrics
Structure attestation packetscope, version, controls, exceptions, sign-off
Define AI assist policyapproved use cases, prohibited actions, narrative QA

Days 61-90: Prove and Scale

WorkstreamOutcome
Add lineage coveragedataset/column lineage for material metrics
Create submission evidence vaultmanifest, checksum, validation, confirmation
Run mock regulator questionreconstruct number and evidence within SLA
Launch readiness MIfiling status, DQ, recon, attestation, issue, AI usage
Close repeat root causesCAPA with control enhancement and management owner

15. Interview-Ready Answers

Q1: 你如何把 BCBS 239 落到 AI regulatory reporting architecture?

30 秒版本: 我会把 BCBS 239 转成可执行架构能力: governance 变成 RACI 和 attestation, data architecture 变成 source-of-record、taxonomy、lineage 和 as-of snapshots, accuracy/completeness/timeliness/adaptability 变成 DQ、reconciliation、close calendar 和 ad hoc query capability。AI 只能在这些控制之上辅助。

2 分钟版本: BCBS 239 不是文档清单, 它要求银行能可靠、完整、及时、灵活地聚合和报告风险数据。产品上我会先建立 obligation inventory 和 report metric contracts, 确保每个 line item 有定义、source、owner、transformation、control 和 attestation。架构上建立 as-of reporting data layer, 支持报告期冻结、record count、checksum 和复算。控制上把 DQ、edit check、source-to-report reconciliation、cross-schedule reconciliation 和 variance analysis 前置到 pipeline。AI 放在 assist layer, 例如 mapping suggestion、break clustering 和 narrative draft, 但不能改变定义或签署事实。

Q2: Call Report / FR Y-14 style reporting 与普通管理报表最大的区别是什么?

30 秒版本: 监管报送不是 dashboard, 它需要说明书版本、口径解释、法律实体/合并范围、as-of 事实、严格对账、签署、提交证据和更正路径。普通管理报表可以容忍探索性分析, regulatory reporting 必须可证明。

2 分钟版本: 普通管理报表常常以决策速度和趋势洞察为中心, 但 Call Report / FR Y-14 style reporting 以 reportable facts 和 submission evidence 为中心。每个 schedule item 都要映射到官方说明书版本和内部 metric contract。数据要区分 event time、posting time、available time 和 freeze time。模型或估计输出如果进入报送, 要连接模型版本、参数、输入和控制证据。提交后还要能回答监管问题, 所以 final files、checksums、validation、attestations、portal confirmation 和 Q&A 都要进 evidence vault。

Q3: 如何控制 AI 生成 variance narrative?

30 秒版本: 把 narrative 当成受控派生产物。AI 只能基于 approved metrics、reconciliation results、variance tables、issue ledger 和 owner comments 起草, 每个关键解释要有 source reference, 人审后才能进入报表或问询材料。

2 分钟版本: 我会建立 narrative contract, 明确 allowed sources、required output 和 prohibited output。禁止 AI 写法律结论、监管承诺、责任归因或没有来源的原因。系统记录 prompt、model、retrieved sources、draft、human edits 和 approval。QA 会检查 fact grounding、number consistency、source precision、scope discipline 和 legal boundary。高风险 narrative 必须由 Reg Reporting、Finance/Risk 或 Legal/Compliance 授权角色审核。

Q4: 发现报送后错误, 产品和架构应该怎样响应?

30 秒版本: 先冻结证据, 通过 lineage 做 impact assessment, 找到受影响报告、期间、指标、源数据和提交包。是否更正或重报由授权治理决定, 系统负责复算、证据、审批、重新提交和 CAPA。

2 分钟版本: 我会创建 issue_id, 用 evidence lineage 连接 source snapshot、transformation version、report cell、attestation 和 submission manifest。然后量化影响金额、数量、期间和 legal entity, 识别 root cause: source、mapping、transformation、manual adjustment、model output、AI narrative 或 governance。Reg Reporting、Finance/Risk、Legal/Compliance 判断 correction path。架构侧生成 revised data、recon result、attestation update、submission package 和 closure evidence。最后把根因转成 control enhancement, 防止同类问题重复。

Q5: 为什么 attestation architecture 是产品问题?

30 秒版本: 因为签署不是最后一步签名, 而是对数据版本、控制结果、例外和责任范围的产品化承诺。如果没有结构化 attestation packet, 签署人无法知道自己确认了什么。

2 分钟版本: 我会把 attestation 分层: source owner 确认源数据和冻结版本, transformation owner 确认规则和运行, control owner 确认 DQ/recon/edit checks, business/finance/risk owner 确认业务解释和例外, regulatory reporting owner 确认 package readiness, executive signer 做授权批准。每个签署都引用同一个 data version、control results、exceptions 和 evidence links。这样审计或监管问询时, 不需要靠口头回忆解释当时为什么可以提交。


16. Quality Bar

一个 reporting data architecture 达标的最低标准:

For any material submitted number,
the team can reconstruct:
  obligation and instruction version,
  metric definition,
  source records or source population,
  transformation logic and version,
  data quality and reconciliation results,
  manual adjustments and exceptions,
  attestation trail,
  submitted package and confirmation,
  post-submit issues and correction decisions.

如果这个链条断了, AI 不应被用来"补解释"。正确的产品动作是修复 metric contract、lineage、control、attestation 或 evidence architecture。