ISO20022 Resolution of Investigation (camt.029)

This dataset provides detailed records of responses to payment investigations and inquiries, including resolution status, corrective actions taken, and outcomes of claims. It is structured for traceability and compliance, enabling financial institutions to efficiently manage, audit, and analyze payment dispute resolutions and operational risk. The dataset is ideal for regulatory reporting, process optimization, and fraud detection.

  • last updated 29 Oct 2025
  • by GoMask
The brief that made it

Regulatory reporting and compliance tracking

Sample rows

preview · 8 of 200 rows · all 17 columns
investigation_idstringinvestigation_typestringclaim_amountfloatcorrective_action_codestringoriginal_payment_idstringinitiator_party_idstringinitiator_party_namestringrespondent_party_idstringrespondent_party_namestringresponse_datetimedatetimeresolution_statusstringclaim_outcomestringclaim_currencystringresolution_datedateresolution_descriptionstringcorrective_action_descriptionstringadditional_informationstring
INV-20210315-001claim1245.5CREDPAY-98234715CUST105Johnathan MilesBANKF21First Trust Bank2021-03-15T09:47:22ZresolvedacceptedUSD2021-03-16Claim accepted. Funds credited to beneficiary as per review of transaction.Funds credited to beneficiary account after resolution.Initial payment failed due to beneficiary account number mismatch.
INV-20210420-002status_inquiryblankblankPAY-20958324CORP401Alpine Holdings Ltd.BANKB13Blue Ridge Bank2021-04-20T13:05:10Zpendingnot_applicableblankblankPayment is pending due to intermediary bank investigation.blankPayment routed via two intermediary banks, awaiting confirmation.
INV-20210708-003correction329BNFCHGPAY-38562041BUS203Sunrise Retail Co.BANKD99Diamond National Bank2021-07-08T11:32:44Zresolvedpartially_acceptedEUR2021-07-09Beneficiary details updated and payment reprocessed.Beneficiary name and account details corrected for payment.Original payment rejected due to incorrect beneficiary name.
INV-20210921-004claim89.99blankPAY-57120486CUST118Samantha GreenBANKC88Capital River Bank2021-09-21T17:22:08ZrejectedrejectedGBP2021-09-22Claim rejected. Payment successfully processed as per transaction logs.blankCustomer alleges double payment, but only one transaction found.
INV-20211204-005otherblankblankPAY-64891023BUS315Global Exporters Inc.BANKG65Gateway Commercial Bank2021-12-04T14:51:12Zresolvednot_applicableblank2021-12-05Investigation closed. Delay due to public holiday, now resolved.blankTransaction delayed due to regional holiday in receiving country.
INV-20220115-006claim600000COMPPAY-13479852CORP413Apex Technologies PLCBANKH41Horizon Federal Bank2022-01-15T10:29:35ZresolvedacceptedINR2022-01-16Claim accepted. Corporate funds released after regulatory approval.Compliance check completed. Funds credited.Large corporate wire held for regulatory review, now released.
INV-20220302-007status_inquiryblankblankPAY-31245987CORP425Mariner Shipping LLCBANKA14Anchor City Bank2022-03-02T15:16:03Zpendingnot_applicableblankblankAwaiting confirmation from correspondent bank.blankFunds transferred internationally, awaiting intermediary bank response.
INV-20220531-008correction1800PRFPAY-47023819BUS221Eastern Wholesale Ltd.BANKE77Emerald Savings Bank2022-05-31T08:45:59Zpartially_resolvedpartially_acceptedUSD2022-06-01Correction applied, partial refund issued.Partial refund processed for duplicate charge.Duplicate charge identified; partial refund authorized.

What the 200 rows show

from the 200-row sample
  • 600.0median claim_amount
  • 4resolution statuses
  • 4claim outcomes
  • 10claim currencies
investigation_type200 rows by value
0408073claim37%54correcti…27%37status_i…19%36other18%
claim_amount121 rows, in bands of 100k
0601201152110020400k700kclaim_amount →

Median 600.0, from 0.0 to 700,000.

corrective_action_code102 rows with a value · 98 left blank
  1. CRED24
  2. BNFCHG17
  3. MEMO14
  4. COMP12
  5. PRF12
  6. REV11
  7. TRC7
  8. ADVER3
  9. EXCHCOR2
17 columns by typefrom the column list below
  • string 14
  • float 1
  • date 1
  • datetime 1

Columns

17 columns in three groups
blueprint · 17 columns
columntypedescriptionexample
Text 14 columns
investigation_idstringUnique identifier for the payment investigation or inquiry.uniqueINV-20210315-001
original_payment_idstringIdentifier for the original payment transaction being investigated.PAY-98234715
investigation_typestringType of investigation or inquiry (e.g., claim, correction, status inquiry).claim · correction · status_inquiry · otherclaim
initiator_party_idstringIdentifier for the party initiating the investigation.CUST105
initiator_party_namestringName of the party initiating the investigation.Johnathan Miles
respondent_party_idstringIdentifier for the party responding to the investigation.BANKF21
respondent_party_namestringName of the party responding to the investigation.First Trust Bank
resolution_statusstringStatus of the investigation resolution (e.g., resolved, pending, rejected, partially_resolved).resolved · pending · rejected · partially_resolvedresolved
resolution_descriptionstringDetailed description of the resolution or outcome.optionalClaim accepted. Funds cre…
corrective_action_codestringCode representing the corrective action taken (if any).9 codes · optionalCRED
corrective_action_descriptionstringDescription of the corrective action taken.optionalFunds credited to benefic…
claim_outcomestringOutcome of the claim (e.g., accepted, rejected, partially_accepted, not_applicable).accepted · rejected · partially_accepted · not_applicable · optionalaccepted
claim_currencystringCurrency of the claimed amount (ISO 4217 code).10 currencies · optionalUSD
additional_informationstringAny additional information or notes related to the investigation.optionalInitial payment failed du…
Numbers 1 column
claim_amountfloatAmount claimed in the investigation (if applicable).0 or more · optional1245.5
Dates and times 2 columns
response_datetimedatetimeTimestamp when the response to the investigation was issued.2021-03-15T09:47:22Z
resolution_datedateDate when the investigation was resolved.optional2021-03-16

Use it for

  • median claim a…600.0121 rowsrows by investigation…73claim54corr…37stat…36other

    A finance dashboard

    Claim_amount by investigation_type and a breakdown of corrective_action_code. Excel, Power BI or Tableau.

  • What pattern can you find in 200 rows?

    A class exercise

    Hand out the rows and one question. Everyone works from the same 200 rows.

  • A software demo

    Believable investigations with original_payment_id, investigation_type and initiator_party_id to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 17 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset200 rows17 columns
Yours1,000 rows17 columns

blueprint · iso20022-resolution-of-investigation-camt029

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 17 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • Investigation case reference
  • Resolution status: resolved, partially resolved, rejected
  • Original payment details referenced
  • Resolution action taken documented
  • Corrective payment if applicable
  • Claim amount if compensation
  • Resolution date timestamp
Rows
Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
iso20022-resolution-of-investigation-camt029

More in Finance

Browse all
Also in FinanceISO20022 Payment Reversal (pacs.007)Credit Card Fraud DetectionFinancial Statement Fraud IndicatorsAll 1,958 datasets

What should your data show?

Preview 20 rows free
No signup. No card.