search

Reg-Edge / CAT-Validator

0 stars 0 forks source link

Document: Document Conditional Validations at field level #6

Open regedgejrodriguez opened 6 months ago

regedgejrodriguez commented 6 months ago

As a business analyst, I want to document all the conditional requirements for cat reporting data elements.

  1. Given that we use the excel sheet in the corresponding teams channel
  2. given that we identify all the conditional data elements in the cat schema json
    1. https://catnmsplan.com/sites/default/files/2023-08/08.24.23-IM-4.0.0-r20.json
    2. suggest a script to reduce load
      1. given that we reference this field in the cat spec, we provide a description for each condition/requirement
      2. Given that we add a column that is Y/N whether a condition can be validated programmatically
regedgejrodriguez commented 6 months ago

83 unique cat fields have conditional requirements

{'DVPCustodianID', 'RFQID', 'accountHolderType', 'aggregatedOrders', 'askAggregatedOrders', 'askPrice', 'askQty', 'atsDisplayInd', 'atsOrderType', 'bidAggregatedOrders', 'bidPrice', 'bidQty', 'buyDetails', 'cancelTimestamp', 'clearingFirm', 'clientDetails', 'correspondentCRD', 'counterparty', 'deskOrderID', 'destination', 'destinationType', 'displayPrice', 'displayQty', 'electronicTimestamp', 'errorROEID', 'exchOriginCode', 'firmDesignatedID', 'firmDetails', 'handlingInstructions', 'infoBarrierID', 'leavesQty', 'legDetails', 'manualOrderID', 'manualOrderKeyDate', 'marketCenterID', 'minQty', 'nbbPrice', 'nbbQty', 'nbboSource', 'nbboTimestamp', 'nboPrice', 'nboQty', 'netPrice', 'newOrderFDID', 'occClearingMemberID', 'openCloseIndicator', 'originatingIMID', 'pairedOrderID', 'parentOrderID', 'parentOrderKeyDate', 'price', 'priceType', 'priorAllocationID', 'priorAllocationKeyDate', 'priorDeskOrderID', 'priorFillKeyDate', 'priorFulfillmentID', 'priorOrderID', 'priorOrderKeyDate', 'priorQuoteID', 'priorQuoteKeyDate', 'priorRoutedOrderID', 'quantity', 'quoteID', 'quoteKeyDate', 'quoteWantedInd', 'receivedQuoteID', 'receiverIMID', 'reportingExceptionCode', 'representativeQuoteInd', 'requestTimestamp', 'routedOrderID', 'routedQuoteID', 'sellDetails', 'senderIMID', 'senderType', 'seqNum', 'session', 'settlementDate', 'side', 'tapeTradeID', 'triggerPrice', 'workingPrice'

regedgejrodriguez commented 6 months ago

priotize the following conditional validations for development

regedge commented 5 months ago

This list should be added as a separate table to Attribute level validation document.