FINRA CAT Reporting
FINRA_CATfree10 data-quality rules for the FINRA Consolidated Audit Trail (CAT) — order and trade event reporting by broker-dealers. Covers required event fields, event-type and side value sets, symbol and MPID validity, nanosecond timestamp format, non-negative price/quantity, event-time ordering, and duplicate suppression. Use it to validate CAT events before submission to avoid rejections and repairs.
Checks included (10)
Event Type Is Valid(event_type)
Event type must be a CAT event (new order MENO, route MEOR, modify MEOM, cancel MEOC, trade MEOT, fill).
Side Is Valid(side)
The order side must be a valid CAT side code (B buy, S sell, SS sell short, SX sell short exempt).
Event Timestamp Is Nanosecond ISO 8601(event_timestamp)
Event timestamps must be ISO 8601 to the granularity the firm captures (up to nanoseconds), in UTC.
Required Event Fields Present
Each CAT event must carry the order id, symbol, event type, event timestamp, and reporting MPID.
Reporting MPID Present(reporting_mpid)
The reporting Market Participant Identifier (MPID) must be present.
Order Quantity Is Positive(quantity)
Order/trade quantity must be greater than zero.
Price Is Non-Negative(price)
Limit/trade price, when present, cannot be negative.
Symbol Is a Known CAT-Reportable Security
The symbol must exist in the CAT reportable-securities reference (symbol master).
No Duplicate Events(event_key)
Each event (order id + event type + timestamp) must be reported once.
Route Events Carry a Destination
A route event (MEOR) must carry the destination (exchange or MPID it was routed to).