New Order, Cancel/Replace, Combined Order/Route and Combined Order/Execution Reports

May 2, 2003

 

Below are the order report formats for the New Report, Cancel/Replace Report, Combined Order/Route Report, Combined Order Execution Report, Route Report, and Execution Report, which will be effective in the OATS Testing environment on July 14, 2003 and in the OATS Production environment on July 28, 2003.

 

New Order Report

 

Seq. NameData Type (Length)M/CPermissible Values and Instructions
1Record TypeAlphanumeric (4)M'#OE#'—identifies a order event record. Case sensitive, must be capital letters.
2Order Event Type CodeAlphanumeric (2)M'NW'—identifies the order event record type as a new order. Case sensitive, must be capital letters.
3Action Type CodeAlphanumeric (1)MValues: 'N,' 'C,' 'D',or 'R'. Case sensitive, must be a capital letter.
4Firm ROE IDAlphanumeric (12)CValues: Any alphanumeric not containing a delimiter.
5Correction/ Deletion TimestampNumeric (14)CRequired if the Action Type Code is 'C,' 'D,' or 'R.' Format: YYYYMMDDHHMMSS.
6Rejected ROE Resubmit FlagAlphanumeric (1)CRequired when the ROE has been rejected by OATS and has been corrected for resubmission. Value: 'Y'. Case sensitive, must be a capital letter.
7Order Receiving Firm MPIDAlphanumeric(4)CMust be supplied if the MPID in effect on the Order Received Date is different from the MPID in the Header Record. Case sensitive, must be capital letters.
8Order Receiving Firm Order Received DateNumeric (14)MFormat: YYYYMMDDHHMMSS.
9Order Receiving Firm Order IDAlphanumeric (20)MValues: Any alphanumeric not containing a delimiter. Must be unique for the firm within the Order Received Date.
10Routing Firm MPIDAlphanumeric (4)CRequired if a wholesale order is received from another member firm. ECNs are required to include this value for all orders received from NASD members. Must be a valid MPID for the Order Received Timestamp. Required if the Account Type Code is 'W', and the Member Type Code is 'C' or 'M'. If the Account Type Code is 'W' and the Member Type Code is 'N', this field must contain a non-member firm MPID for the Order Received Timestamp or must be blank. If the Member Type Code is 'M' and the Account Type Code is 'P', this field must be blank. Case sensitive, must be capital letters.
11Routed Order IDAlphanumeric (20)CRequired if the order received is an electronic wholesale order from a member firm. Not required if the order is received by an ECN, a non-member firm, or if the order is a non-electronic order. Values: Any alphanumeric not containing a delimiter. Required when the Account Type Code is 'W', the Received Method Code is 'E', and the Member Type Code is 'M'. If the Member Type Code is 'M' and the Account Type Code is 'P', this field must be blank.
12Order Received TimestampNumeric (14)MFormat: YYYYMMDDHHMMSS.‡
13Received Method CodeAlphanumeric (1)MValues: 'E' (Electronic), 'N' (Non-Electronic). Case sensitive, must be a capital letter.
14Issue Symbol IDAlphanumeric (14 )MMust be a symbol for a valid Nasdaq security, including convertible bonds, for the Order Received Date. Case sensitive, must be capital letters.
15Buy/Sell CodeAlphanumeric (2)MValues: 'B,' 'SL,' 'SS,' or 'SX.' ECNs are not required to differentiate between Short Sale Exempt ('SX') and Short Sale ('SS') when reporting a Sell order. Case sensitive, must be capital letters.
16Shares QuantityNumeric (9)MFor reserved size orders, must be the sum of displayed size and reserved size. Values are any integer greater than zero.
17Limit PriceNumeric (18,8)CIf entered, must be greater than 0. If entered, a Time in Force Code must be provided.
18Limit Order Display IndicatorAlphanumeric (1)CFor Non-ECNs, must exist if either a Limit Price, or a Limit Price and a Stop Price, is provided. Not mandatory for orders received by an ECN. Values are 'Y' or 'N.' Case sensitive, must be a capital letter.
19Stop PriceNumeric (18,8)CIf entered, a Time in Force Code must be provided.
20Time in Force CodeAlphanumeric (3)CValues: 'DAY,' 'GTD,' 'GTT,' 'GTC,' or 'GTM.' blank is interpreted by OATS as a market order. Case sensitive, must be capital letters.
21Expiration DateDate (8)CRequired if the Time in Force is 'GTD.' If the Time in Force Code is 'DAY,' an Expiration Date, if entered, must be equal to or one day greater than the Order Received Date. If the Time in Force code is 'GTM' the expiration date will be derived by OATS as the last business day of the month. Format: YYYYMMDD.
22Expiration TimeNumeric (6)CRequired if the Time in Force is 'GTT.' The format is HHMMSS. Must be greater than the time in the Order Received Timestamp.
23Do Not Reduce/Do Not Increase CodeAlphanumeric (3)CValues: 'DNR', 'DNI', or 'DIR.' Case sensitive, must be capital letters.
24First Special Handling CodeAlphanumeric (3)CValues: 'FOK', 'AON', 'NH', 'IOC', 'MAO', 'LOC','MAC', 'MOO', 'MOC', 'OVD', 'SCL', 'WRK', 'PEG', 'MQT', 'TS', or 'RSV'. NOTE: Any other special handling codes should not be reported to OATS. Case sensitive, must be capital letters.
25Second Special Handling CodeAlphanumeric (3)CValues: 'FOK', 'AON', 'NH', 'IOC', 'MAO', 'LOC', 'MAC', 'MOO', 'MOC', 'OVD', 'SCL', 'WRK', 'PEG', 'MQT', 'TS', or 'RSV'. Case sensitive, must be capital letters.
26Third Special Handling CodeAlphanumeric (3)CValues are: 'FOK', 'AON', 'NH', 'IOC', 'MAO', 'LOC', 'MAC', 'MOO', 'MOC', 'OVD', 'SCL', 'WRK', 'PEG', 'MQT', 'TS', or 'RSV'. Case sensitive, must be capital letters.
27Fourth Special Handling CodeAlphanumeric (3)CValues are: 'FOK', 'AON', 'NH', 'IOC', 'MAO', 'LOC', 'MAC', 'MOO', 'MOC', 'OVD', 'SCL', 'WRK', 'PEG', 'MQT', 'TS', or 'RSV'. Case sensitive, must be capital letters.
28Fifth Special Handling CodeAlphanumeric (3)CValues are: 'FOK', 'AON', 'NH', 'IOC', 'MAO', 'LOC', 'MAC', 'MOO', 'MOC', 'OVD', 'SCL', 'WRK', 'PEG', 'MQT', 'TS', or 'RSV'. Case sensitive, must be capital letters.
29Receiving Terminal IDAlphanumeric (12)CEither the Receiving Terminal ID or the Receiving Department ID must be provided when an order received directly from a customer is captured electronically. Not required for ECNs or non-electronic orders. Format: Any alphanumeric not containing a delimiter.
30Receiving Department IDAlphanumeric (12)CEither the Receiving Terminal ID or the Receiving Department ID must be provided when an order received directly from a customer is captured electronically. Not required for ECNs or non-electronic orders. Values: Any alphanumeric not containing a delimiter.
31Originating Department IDAlphanumeric (12)CMust be provided when an Account Type Code value exists and is 'P.' Not required for ECNs or non-electronic orders. Values: Any alphanumeric not containing a delimiter.*
32Account Type CodeAlphanumeric (1)CRequired if an electronic order submitted by a non-ECN. Values: 'R' (Retail), 'W' (Wholesale), 'P' (Proprietary), 'E' (Employee), or 'C' (Combined). If an order is an electronic order and is submitted by an ECN, this must be blank or a valid value. 'W' may be used for orders received from both NASD member and non-member broker/dealers. Case sensitive, must be a capital letter.
33Program Trading CodeAlphanumeric (1)MValues: 'Y', 'N', or 'X'. ECNs are not required to report this information under the Rules; therefore, they may always provide a value of 'X' (unknown). Case sensitive, must be a capital letter.
34Arbitrage CodeAlphanumeric (1)MValues: 'Y', 'N', 'X'. ECNs are not required to report this information under the Rules; therefore, they may always provide a value of 'X' (unknown). Case sensitive, must be a capital letter.
35Member Type CodeAlphanumeric (1)MValues: 'C' (ECN), 'M' (Member Firm), 'N' (Non-Member Firm). Case sensitive, must be a capital letter.
36ECN FlagAlphanumeric (1)CRequired if the submitting organization is an ECN. Valid value is 'Y'. Case sensitive, must be a capital letter.
37End of Record Marker(1 or 2)MValues: LF (Line Feed) or CR/LF (Carriage Return/Line Feed).

 

* Was not required for electronic orders until 8/1/1999.

 

‡ For the first two phases of OATS, Order Received Timestamp will reflect the date and time an order was captured in an electronic order routing or trading system. By the third phase of OATS, Order Received Timestamp must reflect the date and time the order was received in any form from a customer or another firm. If the order is immediately captured in an electronic system, the order entry time is acceptable for the order received time.

 

§ Account Type Code is reportable by 3/1/1999 for electronic orders and by Phase 3 for manual orders only to the extent it is available. It was fully reportable for electronic orders on 8/1/1999.

 

 

Cancel/Replace Report

 

Seq. NameData Type/ LengthM/CPermissible Values and Instructions
1Record TypeAlphanumeric (4)M'#OE#' Case sensitive, must be capital letters.
2Order Event Type CodeAlphanumeric (2)M'CR' is the value for this report. Case sensitive, must be capital letters.
3Action Type CodeAlphanumeric (1)MValues are: 'N,' 'C,' 'D,' or 'R.' Case sensitive, must be a capital letter.
4Firm ROE IDAlphanumeric (12)CAny alphanumeric not containing a delimiter.
5Correction/ Deletion TimestampNumeric (14)CRequired if the Action Type Code is 'C,' 'D,' or 'R.' The format is YYYYMMDDHHMMSS.
6Rejected ROE Resubmit FlagAlphanumeric (1)CRequired when the ROE has been Rejected by OATS and has been corrected for resubmission. Value is: 'Y.' Case sensitive, must be a capital letter.
7Order Receiving Firm MPIDAlphanumeric( 4)CMust be supplied if the MPID in effect on the Replaced Order Received Date is different from the MPID in the Header Record. Must be a valid MPID for the Order Receiving Firm Order Received Date. Case sensitive, must be capital letters.
8Replaced Order Received DateNumeric (14)MOrder received date for the canceled order. Format is YYYYMMDDHHMMSS.
9Replaced Firm Order IDAlphanumeric (20)MOrder ID for the canceled order. Values: Any alphanumeric not containing a delimiter.
10Order Receiving Firm Order Received DateNumeric (14)MOrder received date for the replacement order. Date Format is YYYYMMDDHHMMSS.
11Order Receiving Firm Order IDAlphanumeric (20)MOrder ID for the replacement order. Values: Any alphanumeric not containing a delimiter. Must be unique for the firm within the Order Received Date.
12Routing Firm MPIDAlphanumeric (4)CRequired if a wholesale order is received from another member firm. ECNs are required to include this value for all orders received from NASD members. Must be a valid MPID for the Order Received Timestamp. Required if the Account Type Code is 'W', and the Member Type Code is 'C' or 'M'. If the Account Type Code is 'W' and the Member Type Code is 'N', this field must contain a non-member firm MPID for the Order Received Timestamp or must be blank. If the Member Type Code is 'M' and the Account Type Code is 'P', this field must be blank. Case sensitive, must be capital letters.
13Routed Order IDAlphanumeric (20)CRequired if the order received is an electronic wholesale order from a member firm. Not required if the order is received by an ECN, a non-member firm, or if the order is a non-electronic order. Values: Any alphanumeric not containing a delimiter. Required when the Account Type Code is 'W', the Received Method Code is 'E', and the Member Type Code is 'M'. If the Member Type Code is 'M' and the Account Type Code is 'P', this field must be blank.
14Order Received TimestampNumeric (14)MFormat: YYYYMMDDHHMMSS.‡
15Received Method CodeAlphanumeric (1)MValues: 'E' (Electronic), 'N' (Non-Electronic). Case sensitive, must be a capital letter.
16Issue Symbol IDAlphanumeric (14 )MMust be a symbol for a valid Nasdaq security, including convertible bonds, for the replacement Order Received Date. Case sensitive, must be capital letters.
17Buy/Sell CodeAlphanumeric (2)MValues are: 'B', 'SL', 'SS', or 'SX'. ECNs are not required to differentiate between Short Sale Exempt ('SX') and Short Sale ('SS') when reporting a Sell order. Case sensitive, must be capital letters.
18Shares QuantityNumeric (9)MFor reserved size orders, must be the sum of displayed size and reserved size. Values are any integer greater than zero.
19Limit PriceNumeric (18,8)CIf entered, must be greater than 0. If entered, a Time in Force Code should be provided.
20Limit Order Display IndicatorAlphanumeric (1)CFor Non-ECNs, must exist if either a Limit Price, or a Limit Price and a Stop Price, is provided. Not mandatory for orders received by an ECN. Values are 'Y' or 'N.' Case sensitive, must be a capital letter.
21Stop PriceNumeric (18,8)CIf entered, a Time in Force Code must be provided.
22Time in Force CodeAlphanumeric (3)CValues are 'DAY,' 'GTD,' 'GTT,' 'GTC,' or 'GTM.' A blank is interpreted by OATS as a market order. If the Time in Force code is 'GTM' the expiration date will be derived by OATS as the last business day of the month. Case sensitive, must be capital letters.
23Expiration DateDate (8)CRequired if the Time in Force is 'GTD.' If the Time in Force Code is 'DAY,' an Expiration Date, if entered, must be equal to or one day greater than the Order Received Date. If the Time in Force code is 'GTM' the expiration date will be derived by OATS as the last business day of the month. The format is YYYYMMDD.
24Expiration TimeNumeric (6)CRequired if the Time in Force is 'GTT.' The format is HHMMSS. Must be greater than the time in the Order Received Timestamp.
25Do Not Reduce/Do Not Increase CodeAlphanumeric (3)CValues are: 'DNR,' 'DNI,' or 'DIR'. Case sensitive, must be capital letters.
26First Special Handling CodeAlphanumeric (3)CValues are: 'FOK', 'AON', 'NH', 'IOC', 'MAO', 'LOC', 'MAC', 'MOO', 'MOC', 'OVD', 'SCL', 'WRK', 'PEG', 'MQT', 'TS', or 'RSV'. Note: Any other special handling codes should not be reported to OATS. Case sensitive, must be capital letters.
27Second Special Handling CodeAlphanumeric (3)CValues are: 'FOK', 'AON', 'NH', 'IOC', 'MAO', 'LOC', 'MAC', 'MOO', 'MOC', 'OVD', 'SCL', 'WRK', 'PEG', 'MQT', 'TS', or 'RSV'. Case sensitive, must be capital letters.
28Third Special Handling CodeAlphanumeric (3)CValues are: 'FOK', 'AON', 'NH', 'IOC', 'MAO', 'LOC', 'MAC', 'MOO', 'MOC', 'OVD', 'SCL', 'WRK', 'PEG', 'MQT', 'TS', or 'RSV'. Case sensitive, must be capital letters.
29Fourth Special Handling CodeAlphanumeric (3)CValues are: 'FOK', 'AON', 'NH', 'IOC', 'MAO', 'LOC', 'MAC', 'MOO', 'MOC', 'OVD', 'SCL', 'WRK', 'PEG', 'MQT', 'TS', or 'RSV'. Case sensitive, must be capital letters.
30Fifth Special Handling CodeAlphanumeric (3)CValues are: 'FOK', 'AON', 'NH', 'IOC', 'MAO', 'LOC', 'MAC', 'MOO', 'MOC', 'OVD', 'SCL', 'WRK', 'PEG', 'MQT', 'TS', or 'RSV'. Case sensitive, must be capital letters.
31Receiving Terminal IDAlphanumeric (12)CEither the Receiving Terminal ID or the Receiving Department ID must be provided when an order received directly from a customer is captured electronically. Not required for ECNs or non-electronic orders. Values: Any alphanumeric not containing a delimiter.
32Receiving Department IDAlphanumeric (12)CEither the Receiving Terminal ID or the Receiving Department ID must be provided when an order received directly from a customer is captured electronically. Not required for ECNs or non-electronic orders. Values: Any alphanumeric not containing a delimiter.
33Originating Department IDAlphanumeric (12)CMust be provided when an Account Type Code value exists and is 'P.' Not required for ECNs or non-electronic orders. Values: Any alphanumeric not containing a delimiter.*
34Account Type CodeAlphanumeric (1)CRequired if an electronic order submitted by a non-ECN. Values: 'R' (Retail), 'W' (Wholesale), 'P' (Proprietary), 'E' (Employee), or 'C' (Combined). If an order is an electronic order and is submitted by an ECN, this must be blank or a valid value. 'W' may be used for orders received from both NASD member and non member broker/dealers. Case sensitive, must be a capital letter.
35Program Trading CodeAlphanumeric (1)MValues are: 'Y', 'N', or 'X'. ECNs are not required to report this information under the Rules; therefore, they may always provide a value of 'X' (unknown). Case sensitive, must be a capital letter.
36Arbitrage CodeAlphanumeric (1)MValues are: 'Y', 'N', 'X'. ECNs are not required to report this information under the Rules; therefore, they may always provide a value of 'X' (unknown). Case sensitive, must be a capital letter.
37Member Type CodeAlphanumeric (1)MValues: 'C' (ECN), 'M' (Member Firm), 'N' (Non-Member Firm). Case sensitive, must be a capital letter.
38ECN FlagAlphanumeric (1)CRequired if the submitting organization is an ECN. Valid value is 'Y'. Case sensitive, must be a capital letter.
39End of Record Marker(1 or 2)MValues: LF (Line Feed) or CR/LF (Carriage Return/Line Feed).

 

* Was not required for electronic orders until 8/1/1999.

 

‡ For the first two phases of OATS, Order Received Timestamp will reflect the date and time an order was captured in an electronic order routing or trading system. By the third phase of OATS, Order Received Timestamp must reflect the date and time the order was received in any form from a customer or another firm. If the order is immediately captured in an electronic system, the order entry time is acceptable for the order received time.

 

§ Account Type Code is reportable by 3/1/1999 for electronic orders and by Phase 3 for manual orders only to the extent it is available. It was fully reportable for electronic orders on 8/1/1999.

 

Combined Order/Route Report

 

Seq. NameData Type (Length)M/CPermissible Values and Instructions
1Record TypeAlphanumeric (4)M'#OE#'—identifies an order event record. Case sensitive, must be capital letters.
2Order Event Type CodeAlphanumeric (2)M'OR'—identifies the order event record type as a combined new/routing order. Case sensitive, must be capital letters.
3Action Type CodeAlphanumeric (1)MValues: 'N,' 'C,' 'D,',or 'R.' Case sensitive, must be a capital letter.
4Firm ROE IDAlphanumeric (12)CValues: Any alphanumeric not containing a delimiter.
5Correction/ Deletion TimestampNumeric (14)CRequired if the Action Type Code is 'C,' 'D,' or 'R.' Format: YYYYMMDDHHMMSS.
6Rejected ROE Resubmit FlagAlphanumeric (1)CRequired when the ROE has been rejected by OATS and has been corrected for resubmission. Value: 'Y'. Case sensitive, must be a capital letter.
7Order Receiving Firm MPIDAlphanumeric(4)CMust be supplied if the MPID in effect on the Order Received Date is different from the MPID in the Header Record. Case sensitive, must be capital letters.
8Order Receiving Firm Order Received DateNumeric (14)MFormat: YYYYMMDDHHMMSS.
9Order Receiving Firm Order IDAlphanumeric (20)MValues: Any alphanumeric not containing a delimiter. Must be unique for the firm within the Order Received Date.
10Routing Firm MPIDAlphanumeric (4)CRequired if a wholesale order is received from another member firm. ECNs are required to include this value for all orders received from NASD members. Must be a valid MPID for the Order Received Timestamp. Required if the Account Type Code is 'W', and the Member Type Code is 'C' or 'M'. If the Account Type Code is 'W' and the Member Type Code is 'N', this field must contain a non-member firm MPID for the Order Received Timestamp or must be blank. If the Member Type Code is 'M' and the Account Type Code is 'P', this field must be blank. Case sensitive, must be capital letters.
11Routed Order IDAlphanumeric (20)CRequired if the order received is an electronic wholesale order from a member firm. Not required if the order is received by an ECN, a non-member firm, or if the order is a non-electronic order. Values: Any alphanumeric not containing a delimiter. Required when the Account Type Code is 'W', the Received Method Code is 'E', and the Member Type Code is 'M'. If the Member Type Code is 'M' and the Account Type Code is 'P', this field must be blank.
12Order Received TimestampNumeric (14)MFormat: YYYYMMDDHHMMSS.‡
13Received Method CodeAlphanumeric (1)MValues: 'E' (Electronic), 'N' (Non-Electronic). Case sensitive, must be a capital letter.
14Issue Symbol IDAlphanumeric (14 )MMust be a symbol for a valid Nasdaq security, including convertible bonds, for the Order Received Date. Case sensitive, must be capital letters.
15Buy/Sell CodeAlphanumeric (2)MValues: 'B,' 'SL,' 'SS,' or 'SX.' ECNs are not required to differentiate between Short Sale Exempt ('SX') and Short Sale ('SS') when reporting a Sell order. Case sensitive, must be capital letters.
16Limit PriceNumeric (18,8)CIf entered, must be greater than 0. If entered, a Time in Force Code must be provided.
17Limit Order Display IndicatorAlphanumeric (1)CFor Non-ECNs, must exist if either a Limit Price, or a Limit Price and a Stop Price, is provided. Not mandatory for orders received by an ECN. Values are 'Y' or 'N.' Case sensitive, must be a capital letter.
18Stop PriceNumeric (18,8)CIf entered, a Time in Force Code must be provided.
19Time in Force CodeAlphanumeric (3)CValues: 'DAY,' 'GTD,' 'GTT,' 'GTC,' or 'GTM.' Blank is interpreted by OATS as a market order. Case sensitive, must be capital letters.
20Expiration DateDate (8)CRequired if the Time in Force is 'GTD.' If the Time in Force Code is 'DAY,' an Expiration Date, if entered, must be equal to or one day greater than the Order Received Date. If the Time in Force code is 'GTM' the expiration date will be derived by OATS as the last business day of the month. Format: YYYYMMDD.
21Expiration TimeNumeric (6)CRequired if the Time in Force is 'GTT.' The format is HHMMSS. Must be greater than the time in the Order Received Timestamp.
22Do Not Reduce/Do Not Increase CodeAlphanumeric (3)CValues: 'DNR', 'DNI', or 'DIR.' Case sensitive, must be capital letters.
23First Special Handling CodeAlphanumeric (3)CValues: 'FOK', 'AON', 'NH', 'IOC', 'MAO', 'LOC','MAC', 'MOO', 'MOC', 'OVD', 'SCL', 'WRK', 'PEG', 'MQT', 'TS', or 'RSV'. NOTE: Any other special handling codes should not be reported to OATS. Case sensitive, must be capital letters.
24Second Special Handling CodeAlphanumeric (3)CValues: 'FOK', 'AON', 'NH', 'IOC', 'MAO', 'LOC', 'MAC', 'MOO', 'MOC', 'OVD', 'SCL', 'WRK', 'PEG', 'MQT', 'TS', or 'RSV'. Case sensitive, must be capital letters.
25Third Special Handling CodeAlphanumeric (3)CValues are: 'FOK', 'AON', 'NH', 'IOC', 'MAO', 'LOC', 'MAC', 'MOO', 'MOC', 'OVD', 'SCL', 'WRK', 'PEG', 'MQT', 'TS', or 'RSV'. Case sensitive, must be capital letters.
26Fourth Special Handling CodeAlphanumeric (3)CValues are: 'FOK', 'AON', 'NH', 'IOC', 'MAO', 'LOC', 'MAC', 'MOO', 'MOC', 'OVD', 'SCL', 'WRK', 'PEG', 'MQT', 'TS', or 'RSV'. Case sensitive, must be capital letters.
27Fifth Special Handling CodeAlphanumeric (3)CValues are: 'FOK', 'AON', 'NH', 'IOC', 'MAO', 'LOC', 'MAC', 'MOO', 'MOC', 'OVD', 'SCL', 'WRK', 'PEG', 'MQT', 'TS', or 'RSV'. Case sensitive, must be capital letters.
28Receiving Terminal IDAlphanumeric (12)CEither the Receiving Terminal ID or the Receiving Department ID must be provided when an order received directly from a customer is captured electronically. Not required for ECNs or non-electronic orders. Format: Any alphanumeric not containing a delimiter.
29Receiving Department IDAlphanumeric (12)CEither the Receiving Terminal ID or the Receiving Department ID must be provided when an order received directly from a customer is captured electronically. Not required for ECNs or non-electronic orders. Values: Any alphanumeric not containing a delimiter.
30Originating Department IDAlphanumeric (12)CMust be provided when an Account Type Code value exists and is 'P.' Not required for ECNs or non-electronic orders. Values: Any alphanumeric not containing a delimiter.*
31Account Type CodeAlphanumeric (1)CRequired if an electronic order submitted by a non-ECN. Values: 'R' (Retail), 'W' (Wholesale), 'P' (Proprietary), 'E' (Employee), or 'C' (Combined). If an order is an electronic order and is submitted by an ECN, this must be blank or a valid value. 'W' may be used for orders received from both NASD member and non member broker/dealers. Case sensitive, must be a capital letter.
32Program Trading CodeAlphanumeric (1)MValues: 'Y', 'N', or 'X'. ECNs are not required to report this information under the Rules; therefore, they may always provide a value of 'X' (unknown). Case sensitive, must be a capital letter.
33Arbitrage CodeAlphanumeric (1)MValues: 'Y', 'N', 'X'. ECNs are not required to report this information under the Rules; therefore, they may always provide a value of 'X' (unknown). Case sensitive, must be a capital letter.
34Sent To Routed Order IDAlphanumeric (20)CRequired if an electronic order is routed to a member firm or Nasdaq execution system. If an order is routed to the same destination within the same second, the Routed Order ID passed to the receiving firm must be different for each route having the same shares quantity. Values: Any alphanumeric not containing a delimiter.
35Sent to Firm MPIDAlphanumeric (4)CRequired if the order was routed to a member firm or ECN. Optional if the order was routed to a Nasdaq execution system or to a non-member firm. Must be a valid MPID for the Order Sent Timestamp. Should not be a valid MPID if the order was routed to a non-member firm. Case sensitive, must be capital letters.
36Order Sent TimestampNumeric (14)MFormat: YYYYMMDDHHMMSS.
37Routed Shares QuantityNumeric (9)MThe number of shares routed. If the order was bunched, this would be the total number of bunched shares routed. Values are any integer greater than zero.
38Routing Method CodeAlphanumeric (1)MValues: 'E' (Electronic), 'N' (Non-Electronic). Case sensitive, must be a capital letter.
39Bunched Order IndicatorAlphanumeric (1)CRequired for orders when the identified order is bunched with other orders and routed to another firm or ECN. Values: Y or blank. Case sensitive, must be a capital letter.
40Member Type CodeAlphanumeric (1)MValues: 'C' (ECN), 'M' (Member Firm), 'N' (Non-Member Firm). Case sensitive, must be a capital letter.
41Destination CodeAlphanumeric (1)MValues: 'E' (ECN), 'L' (SelectNet), 'M' (Member Firm), 'N' (Non-Member Firm), 'P' (Primex), 'U' (SuperMontage), 'X' (Exchange). Case sensitive, must be a capital letter.
42ECN FlagAlphanumeric (1)CRequired if the submitting organization is an ECN. Valid value is 'Y'. Case sensitive, must be a capital letter.
43End of Record Marker(1 or 2)MValues: LF (Line Feed) or CR/LF (Carriage Return/Line Feed).

 

Combined Order/Execution Report

 

Seq. NameData Type (Length)M/CPermissible Values and Instructions
1Record TypeAlphanumeric (4)M'#OE#' Case sensitive, must be capital letters.
2Order Event Type CodeAlphanumeric (2)M'OE' is the value for this report. Case sensitive, must be capital letters.
3Action Type CodeAlphanumeric (1)MValues are: 'N', 'C', 'D', or 'R.” Case sensitive, must be a capital letter.
4Firm ROE IDAlphanumeric (12)CAny alphanumeric not containing a delimiter.
5Correction/ Deletion TimestampNumeric (14)CRequired if the Action Type Code is 'C' 'D' or 'R'. Format is YYYYMMDDHHMMSS.
6Rejected ROE Resubmit FlagAlphanumeric (1)CRequired when the ROE has been Rejected by OATS and has been corrected for resubmission. Value is: 'Y'. Case sensitive, must be a capital letter.
7Order Receiving Firm MPIDAlphanumeric (4)CMust be supplied if the MPID in effect on the Order Received Date is different from the MPID in the Header Record. Case sensitive, must be capital letters.
8Order Receiving Firm Order Received DateDate (14)MFormat is YYYYMMDDHHMMSS.
9Order Receiving Firm Order IDAlphanumeric (20)MValues: Any alphanumeric not containing a delimiter. Must be unique for the firm within the Order Received Date.
10Routing Firm MPIDAlphanumeric (4)CRequired if a wholesale order is received from another member firm. ECNs are required to include this value for all orders received from NASD members. Must be a valid MPID for the Order Received Timestamp. Required if the Account Type Code is 'W', and the Member Type Code is 'C' or 'M'. If the Account Type Code is 'W' and the Member Type Code is 'N', this field must contain a non-member firm MPID for the Order Received Timestamp or must be blank. If the Member Type Code is 'M' and the Account Type Code is 'P', this field must be blank. Case sensitive, must be capital letters.
11Routed Order IDAlphanumeric (20)CRequired if the order received is an electronic wholesale order from a member firm. Not required if the order is received by an ECN, a non-member firm, or if the order is a non-electronic order. Values: Any alphanumeric not containing a delimiter. Required when the Account Type Code is 'W', the Received Method Code is 'E', and the Member Type Code is 'M'. If the Member Type Code is 'M' and the Account Type Code is 'P', this field must be blank.
12Order Received TimestampNumeric (14)MThe format is YYYYMMDDHHMMSS. If a contemporaneous execution, will be identical to the Execution Timestamp. ‡
13Received Method CodeAlphanumeric (1)MValues: 'E' (Electronic), 'N' (Non-Electronic). Case sensitive, must be a capital letter.
14Issue Symbol IDAlphanumeric (14 )MMust be a symbol for a valid Nasdaq security, including convertible bonds, for the Order Received Date. Case sensitive, must be capital letters.
15Buy/Sell CodeAlphanumeric (2)MValues are: 'B', 'SL', 'SS', or 'SX'. ECNs are not required to differentiate between Short Sale Exempt ('SX') and Short Sale ('SS') when reporting a Sell order. Case sensitive, must be capital letters.
16Limit PriceNumeric (18,8)CIf entered, must be greater than 0. If entered, a Time in Force Code must be provided.
17Limit Order Display IndicatorAlphanumeric (1)CFor Non-ECNs, must exist if either a Limit Price, or a Limit Price and a Stop Price, is provided. Not mandatory for orders received by an ECN. Values are 'Y' or 'N'. Case sensitive, must be a capital letter.
18Stop PriceNumeric (18,8)CIf entered, a Time in Force Code must be provided.
19Time in Force CodeAlphanumeric (3)CValues are 'DAY,' 'GTD,' 'GTT,' 'GTC' or 'GTM'. A blank is interpreted by OATS as a market order. If the Time in Force code is 'GTM' the expiration date will be derived by OATS as the last business day of the month. Case sensitive, must be capital letters.
20Expiration DateDate (8)CRequired if the Time in Force is 'GTD.' If the Time in Force Code is 'DAY,' an Expiration Date, if entered, must be equal to or one day greater than the Order Received Date. If the Time in Force code is 'GTM' the expiration date will be derived by OATS as the last business day of the month. The format is YYYYMMDD.
21Expiration TimeNumeric (6)CRequired if the Time in Force is 'GTT.' The format is HHMMSS. Must be greater than the time in the Order Received Timestamp.
22Do Not Reduce/Do Not Increase CodeAlphanumeric (3)CValues are: 'DNR', 'DNI', or 'DIR'. Case sensitive, must be capital letters.
23First Special Handling CodeAlphanumeric (3)CValues are: 'FOK', 'AON', 'NH', 'IOC', 'MAO', 'LOC', 'MAC', 'MOO', 'MOC', 'OVD', 'SCL', 'WRK', 'PEG', 'MQT', 'TS', or 'RSV'. NOTE: Any other special handling codes should not be reported to OATS. Case sensitive, must be capital letters.
24Second Special Handling CodeAlphanumeric (3)CValues are: 'FOK', 'AON', 'NH', 'IOC', 'MAO', 'LOC', 'MAC', 'MOO', 'MOC', 'OVD', 'SCL', 'WRK', 'PEG', 'MQT', 'TS', or 'RSV'. Case sensitive, must be capital letters.
25Third Special Handling CodeAlphanumeric (3)CValues are: 'FOK', 'AON', 'NH', 'IOC', 'MAO', 'LOC', 'MAC', 'MOO', 'MOC', 'OVD', 'SCL', 'WRK', 'PEG', 'MQT', 'TS', or 'RSV'. Case sensitive, must be capital letters.
26Fourth Special Handling CodeAlphanumeric (3)CValues are: 'FOK', 'AON', 'NH', 'IOC', 'MAO', 'LOC', 'MAC', 'MOO', 'MOC', 'OVD', 'SCL', 'WRK', 'PEG', 'MQT', 'TS', or 'RSV'. Case sensitive, must be capital letters.
27Fifth Special Handling CodeAlphanumeric (3)CValues are: 'FOK', 'AON', 'NH', 'IOC', 'MAO', 'LOC', 'MAC', 'MOO', 'MOC', 'OVD', 'SCL', 'WRK', 'PEG', 'MQT', 'TS', or 'RSV'. Case sensitive, must be capital letters.
28Receiving Terminal IDAlphanumeric (12)CEither the Receiving Terminal ID or the Receiving Department ID must be provided when an order received directly from a customer is captured electronically. Not required for ECNs or non-electronic orders. Values: Any alphanumeric not containing a delimiter.
29Receiving Department IDAlphanumeric (12)CEither the Receiving Terminal ID or the Receiving Department ID must be provided when an order received directly from a customer is captured electronically. Values: Any alphanumeric not containing a delimiter.
30Originating Department IDAlphanumeric (12)CMust be provided when an Account Type Code value exists and is 'P'. Not required for ECNs or non-electronic orders. Values: Any alphanumeric not containing a delimiter.*
31Account Type CodeAlphanumeric (1)CRequired if an electronic order submitted by a non-ECN. Values: 'R' (Retail), 'W' (Wholesale), 'P' (Proprietary), 'E' (Employee), or 'C' (Combined). If an order is an electronic order and is submitted by an ECN, this must be blank or a valid value. 'W' may be used for orders received from both NASD member and non member broker/dealers. Case sensitive, must be a capital letter.
32Program Trading CodeAlphanumeric (1)MValues are: 'Y', 'N', or 'X'. ECNs are not required to report this information under the Rules; therefore, they may always provide a value of 'X' (unknown). Case sensitive, must be a capital letter.
33Arbitrage CodeAlphanumeric (1)MValues are: 'Y', 'N', 'X'. ECNs are not required to report this information under the Rules; therefore, they may always provide a value of 'X' (unknown). Case sensitive, must be a capital letter.
34Execution TimestampNumeric (14)MThe format is YYYYMMDDHHMMSS. If a contemporaneous execution, will be identical to the Order Received Timestamp.
35Branch/
Sequence Number
Alphanumeric (8)CMust be provided when a trade is reported to ACT or TRACS. Not required if a Reporting Exception Code value or a Market Center ID of A, B, C, M, P, or X is supplied.
36Execution QuantityNumeric (9)MThe number of shares executed. Values are any integer greater than zero.
37Trader Terminal IDAlphanumeric (12)CValues: Any alphanumeric not containing a delimiter. Required for electronic orders that were executed by a trader. Optional for trades made through an automated system without trader intervention.*
38Reporting Exception CodeAlphanumeric (1)CValues: 'P', 'M', 'C', 'O', 'S', 'R', 'A'. Must be provided if the execution is not required to be reported to ACT or TRACS.
39Market Center IDAlphanumeric (1)CValues: 'A', 'B', 'C', 'D', 'M', 'P', 'Q', or 'X'. Case sensitive, must be a capital letter.
40Member Type CodeAlphanumeric (1)MValues: 'C' (ECN), 'M' (Member Firm), 'N' (Non-Member Firm). Case sensitive, must be a capital letter.
41ECN FlagAlphanumeric (1)CRequired if the submitting organization is an ECN. Valid value is 'Y'. Case sensitive, must be a capital letter.
42End of Record Marker(1 or 2)MValues: LF (Line Feed), or CR/LF (Carriage Return/Line Feed)

 

* Was not required for electronic orders until 8/1/1999.

 

‡ For the first two phases of OATS, Order Received Timestamp will reflect the date and time an order was captured in an electronic order routing or trading system. By the third phase of OATS, Order Received Timestamp must reflect the date and time the order was received in any form from a customer or another firm. If the order is immediately captured in an electronic system, the order entry time is acceptable for the order received time.

 

§ Account Type Code is reportable by 3/1/1999 for electronic orders and by Phase 3 for manual orders only to the extent it is available. It was fully reportable for electronic orders on 8/1/1999.

 

Routing Report*

 

Seq. NameData Type (Length)M/CPermissible Values and Instructions
1Record TypeAlphanumeric (4)M'#OE#'—identifies an order event record. Case sensitive, must be capital letters.
2Order Event Type CodeAlphanumeric (2)M'RT'—identifies the order event record type as a routing record. Case sensitive, must be capital letters.
3Action Type CodeAlphanumeric (1)MValues: 'N,' 'C,' 'D,' or 'R.' Case sensitive, must be a capital letter.
4Firm ROE IDAlphanumeric (12)CValues: Any alphanumeric not containing a delimiter.
5Correction/
Deletion Timestamp
Numeric (14)CRequired if the Action Type Code is 'C,' 'D,' or 'R.' The format is YYYYMMDDHHMMSS.
6Rejected ROE Resubmit FlagAlphanumeric (1)CRequired when the ROE has been Rejected by OATS and has been corrected for resubmission. Value is: 'Y.' Case sensitive, must be a capital letter.
7Order Receiving Firm MPIDAlphanumeric (4)CMust be supplied if the MPID in effect on the Order Sent Date is different from the MPID in the Header Record. Must be a valid MPID for the Order Sent Date. Case sensitive, must be capital letters.
8Order Receiving Firm Order Received DateNumeric (14)MFormat: YYYYMMDDHHMMSS.
9Order Receiving Firm Order IDAlphanumeric (20)MValues: Any alphanumeric not containing a delimiter.
10Sent to Firm MPIDAlphanumeric (4)CRequired if the order was routed to a member firm or ECN. Optional if the order was routed to a Nasdaq execution system or to a non-member firm. Must be a valid MPID for the Order Sent Timestamp. Should not be a valid MPID if the order was routed to a non-member firm. Case sensitive, must be capital letters.
11Routed Order IDAlphanumeric (20)CRequired if an electronic order is routed to a member or Nasdaq execution system. If an order is routed to the same destination within the same second, the Routed Order ID passed to the receiving firm must be different for each route having the same shares quantity. Values: Any alphanumeric not containing a delimiter.
12Issue Symbol IDAlphanumeric (14)MMust be a symbol for a valid Nasdaq security, including convertible bonds, for the Order Sent Date. Case sensitive, must be capital letters.
13Order Sent TimestampNumeric (14)MFormat: YYYYMMDDHHMMSS.
14Routed Shares QuantityNumeric (9)MThe number of shares routed. If the order was bunched, this would be the total number of bunched shares routed. Values are any integer greater than zero.
15Routing Method CodeAlphanumeric (1)MValues: 'E' (Electronic), 'N' (Non-Electronic). Case sensitive, must be a capital letter.
16Bunched Order IndicatorAlphanumeric (1)CRequired for orders when the identified order is bunched with other orders and routed to another firm or ECN. Values: Y or blank. Case sensitive, must be a capital letter.
17Originating MPIDAlphanumeric (4)CMust be provided if this ROE needs to link to a previously submitted ROE with a different Order Receiving Firm MPID. Firms may include or exclude the field from the report. Case sensitive, must be capital letters.
18Destination CodeAlphanumeric (1)MValues: 'E' (ECN), 'L' (SelectNet), 'M' (Member Firm), 'N' (Non-Member Firm), 'P' (Primex), 'U' (SuperMontage), 'X' (Exchange). Case sensitive, must be a capital letter.
19End of Record Marker(1 or 2)MValues: LF (Line Feed) or CR/LF (Carriage Return/Line Feed).

 

* Was not required for electronic orders until 8/1/1999; not required for non-electronic orders until Phase 3.

 

Execution Report

 

Seq. NameData Type (Length)M/CPermissible Values and Instructions
1Record TypeAlphanumeric (4)M'#OE#' Case sensitive, must be capital letters.
2Order Event Type CodeAlphanumeric (2)M'EX' is the value for this report. Case sensitive, must be capital letters.
3Action Type CodeAlphanumeric (1)MValues are: 'N,' 'C,' 'D,' or 'R.' Case sensitive, must be a capital letter.
4Firm ROE IDAlphanumeric (12)CAny alphanumeric not containing a delimiter.
5Correction/ Deletion TimestampNumeric (14)CRequired if the Action Type Code is 'C,' 'D,' or 'R.' The format is YYYYMMDDHHMMSS.
6Rejected ROE Resubmit FlagAlphanumeric (1)CRequired when the ROE has been Rejected by OATS and has been corrected for resubmission. Value is: 'Y'. Case sensitive, must be a capital letter.
7Order Receiving Firm MPIDAlphanumeric (4)CMust be supplied if the MPID in effect on the Execution Date is different from the MPID in the Header Record. Must be a valid MPID for the Execution Date. Case sensitive, must be capital letters.
8Order Receiving Firm Order Received DateNumeric (14)MFormat YYYYMMDDHHMMSS.
9Order Receiving Firm Order IDAlphanumeric (20)MValues: Any alphanumeric not containing a delimiter.
10Execution TimestampNumeric (14)MThe format is YYYYMMDDHHMMSS.
11Branch/Sequence NumberAlphanumeric (8)CMust be provided when a trade is reported to ACT or TRACS. Not required if a Reporting Exception Code value or a Market Center ID of A, B, C, M, P, or X is supplied.
12Execution QuantityNumeric (9)MThe number of shares executed. Values are any integer greater than zero.
13Trader Terminal IDAlphanumeric (12)CValues: Any alphanumeric not containing a delimiter. Required for electronic orders that were executed by a trader. Optional for trades made through an automated system without trader intervention.*
14Reporting Exception CodeAlphanumeric (1)CValues: 'P', 'M', 'C', 'O', 'S', 'R', 'A'. Must be provided if the execution is not required to be reported to ACT or TRACS. Case sensitive, must be a capital letter.
15Issue Symbol IDAlphanumeric(14)MMust be a symbol for a valid Nasdaq security, including convertible bonds, for the Execution Date. Case sensitive, must be capital letters.
16Execution Type IndicatorAlphanumeric (1)MValues: 'F' or 'P'. Case sensitive, must be a capital letter.
17Leaves QuantityNumeric (9)CMust be provided when the Execution Type Indicator value is 'P.' If the partial execution reported results in the sum of all executions equaling the order quantity, the value should be zero.
18Market Center IDAlphanumeric (1)CValues: 'A', 'B', 'C', 'D', 'M', 'P', 'Q', or 'X'. Case sensitive, must be a capital letter.
19Originating MPIDAlphanumeric (4)CMust be provided if this ROE needs to link to a previously submitted ROE with a different Order Receiving Firm MPID. Firms may include or exclude the field from the report. Case sensitive, must be capital letters.
20End of Record Marker(1 or 2)MValues: LF (Line Feed) or CR/LF (Carriage Return/Line Feed).

 

* Not required for non-electronic orders.

Last Updated: 5/2/2003