Given a trade ticket containing discrepancies between execution parameters and clearing details, determine the appropriate sequence of actions to resolve the break.
Use the provided execution and clearing tables to identify every field-level discrepancy and assign its remediation action. Sequence actions within each ticket by priority: missing clearing record, quantity, price, venue, then settlement date.
ticket_id, sequence_number, discrepancy_type, recommended_actionticket_id, then sequence_number| Column | Type | Description |
|---|---|---|
| ticket_idPK | INT | Unique trade ticket identifier |
| execution_venue | VARCHAR(20) | Venue where the trade executed |
| execution_quantity | INT | Executed quantity |
| execution_price | NUMERIC(12,4) | Executed price |
| execution_settlement_date | DATE | Expected settlement date |
| trade_status | VARCHAR(20) | Execution status |
| Column | Type | Description |
|---|---|---|
| clearing_idPK | INT | Unique clearing record identifier |
| ticket_id | INT | Trade ticket referenced by the clearing record |
| clearing_venue | VARCHAR(20) | Venue recorded for clearing |
| clearing_quantity | INT | Quantity recorded for clearing |
| clearing_price | NUMERIC(12,4) | Price recorded for clearing |
| clearing_settlement_date | DATE | Settlement date recorded for clearing |