MP Capital CDM ISDA Data Mapping System

A comprehensive system for banks and financial institutions to submit and map data to the CDM (Common Domain Model) ISDA standard. This application provides intelligent field mapping, external data validation, and a complete manual entry interface with drill-down capabilities.

• Multi-Format File Upload: Support for Excel (.xlsx, .xls, .csv), SQL Server, and Oracle data formats
• Intelligent Field Mapping: AI-powered mapping to CDM ISDA model with confidence scoring
• External Data Validation: Real-time validation against external data sources (currency codes, business centers, rate indices)
• Manual Entry Interface: Complete CDM model with expandable drill-down sections
• Real-time Validation: Comprehensive validation with error and warning reporting
• Multiple Export Formats: Export to JSON, XML, and CSV formats

• MP Capital Branding: Professional branding with custom styling and logo
• Responsive Design: Works seamlessly on desktop and mobile devices
• Progress Tracking: Visual progress indicators throughout the workflow
• Template System: Pre-built templates for common trade types (Interest Rate Swaps, Cap/Floor)
• Search & Filter: Advanced search and filtering capabilities
• Drag & Drop: Intuitive file upload with drag-and-drop support

• External API Integration: Validates currencies, business centers, and rate indices
• CDM Compliance: Full compliance with CDM ISDA standards
• Error Handling: Comprehensive error handling with detailed feedback
• Performance Optimized: Efficient processing of large data files
• Security: Secure file handling and data processing

backend/
├── index.ts                 # Main Hono server with CORS and error handling
├── routes/
│   ├── upload.ts           # File upload, processing, and export
│   └── mapping.ts          # CDM structure, validation, and templates
└── services/
    ├── cdm-parser.ts       # CDM model parsing and validation
    ├── file-processor.ts   # Multi-format file processing
    └── external-data.ts    # External data source integration

frontend/
├── index.html              # Main HTML with MP Capital styling
├── index.tsx              # React application entry point
└── components/
    ├── App.tsx            # Main application with routing
    ├── Header.tsx         # Navigation with progress tracking
    ├── FileUpload.tsx     # File upload with drag-and-drop
    ├── MappingView.tsx    # Interactive field mapping interface
    └── ManualEntry.tsx    # CDM manual entry with drill-down

shared/
├── types.ts               # Complete CDM type definitions
└── utils.ts              # Utility functions and validation

• Drag & Drop Interface: Users can drag files directly onto the upload area
• Format Detection: Automatic detection of file format (Excel, SQL, Oracle)
• Validation: File size and format validation before processing
• Progress Tracking: Real-time upload and processing progress

• Automatic Mapping: AI-powered field mapping with confidence scores
• Manual Adjustment: Users can review and adjust mappings
• External Validation: Real-time validation against external data sources
• Mapping Suggestions: Intelligent suggestions for unmapped fields

• Complete CDM Structure: Full CDM model with all sections
• Drill-Down Interface: Expandable sections for detailed data entry
• Template Support: Pre-built templates for common trade types
• Field Validation: Real-time validation with error highlighting

• Data Preview: Complete review of mapped CDM data
• Validation Summary: Overview of errors and warnings
• Multiple Export Formats: JSON, XML, and CSV export options
• Download: Direct download of processed data

• POST /api/upload/file - Upload and process data files
• GET /api/upload/formats - Get supported file formats
• POST /api/upload/validate-field - Validate individual fields
• POST /api/upload/suggest-mapping - Get mapping suggestions
• POST /api/upload/export - Export processed data

• GET /api/mapping/structure - Get complete CDM structure
• POST /api/mapping/validate - Validate CDM trade data
• POST /api/mapping/validate-field - Validate specific fields
• GET /api/mapping/suggestions/:fieldPath - Get field suggestions
• GET /api/mapping/templates - Get trade templates

• GET /api/health - System health status

• Requirements: Headers in first row, data from second row
• Sample Headers: trade_id, trade_date, counterparty_name, notional, currency
• Max Size: 10MB

• Formats: INSERT statements or tab-separated query results
• Encoding: UTF-8
• Sample: INSERT INTO trades (trade_id, trade_date) VALUES ('TRD001', '2024-01-15');

• Formats: Oracle INSERT statements or pipe-separated exports
• Encoding: UTF-8
• Sample: INSERT INTO "TRADES" ("TRADE_ID") VALUES ('TRD001');

• Source: ExchangeRate-API and static currency lists
• Validates: ISO 4217 currency codes
• Examples: USD, EUR, GBP, JPY

• Source: ISDA standard business centers
• Validates: Business center codes
• Examples: GBLO, USNY, JPTO, FRPA

• Source: Standard floating rate indices
• Validates: Rate index names
• Examples: USD-SOFR, EUR-ESTR, GBP-SONIA

• Source: GLEIF API (when available)
• Validates: Legal Entity Identifiers
• Format: 20 alphanumeric characters

• Primary Color: #1e40af (Blue)
• Secondary Color: #3b82f6 (Light Blue)
• Accent Color: #f59e0b (Amber)
• Typography: Professional, clean fonts
• Logo: MP Capital with data visualization elements

• Cards: Rounded corners with subtle shadows
• Buttons: Primary and secondary button styles
• Forms: Consistent input styling with focus states
• Progress: Animated progress bars and spinners
• Status: Color-coded validation status indicators

1. Main Interface: Visit the application URL
2. File Upload: Start with the file upload interface
3. Manual Entry: Or use the manual entry for direct CDM input

A sample CSV file is included (sample-data.csv) with example trade data:

trade_id,trade_date,counterparty_name,notional,currency,fixed_rate,floating_rate_index,maturity_date,product_type
TRD001,2024-01-15,Bank ABC,1000000,USD,0.0325,USD-SOFR,2029-01-15,InterestRateSwap

1. Upload Sample File: Use the provided sample CSV
2. Review Mappings: Check the automatic field mappings
3. Validate Data: Run validation to see external data checks
4. Export Results: Download the mapped CDM data

• Backend: Hono.js for high-performance API
• Frontend: React 18 with TypeScript
• Styling: TailwindCSS with custom MP Capital theme
• File Processing: Custom parsers for multiple formats
• Validation: External API integration for data validation

• Streaming: Large file processing with progress tracking
• Caching: Intelligent caching of validation results
• Lazy Loading: Components loaded on demand
• Debouncing: Optimized API calls for real-time validation

• File Validation: Comprehensive file type and size validation
• Input Sanitization: All user inputs are sanitized
• Error Handling: Secure error messages without sensitive data
• CORS: Proper CORS configuration for API access

• Version: 1.0.0
• Status: Production Ready
• Last Updated: December 2024
• Compatibility: Modern browsers, mobile responsive

• In-App Help: Context-sensitive help throughout the interface
• Sample Files: Example files for testing different formats
• Error Messages: Detailed error messages with suggestions
• Validation Feedback: Real-time feedback on data quality

• Support: Available through the application interface
• Documentation: Comprehensive in-app documentation
• Updates: Regular updates with new features and improvements

MP Capital CDM ISDA Data Mapping System - Transforming financial data mapping with intelligence and precision.