A
5285 - July 3, 2001
P&S 4855
TO: ALL PARTICIPANTS
ATTENTION: MANAGING
PARTNER / OFFICER, OPERATIONS PARTNER / OFFICER, DIRECTOR OF OPERATIONS, DATA
PROCESSING MANAGER, MANAGER P & S DEPARTMENT, COMPLIANCE OFFICER SUBJECT:
MODIFIED
NSCC SPECIFICATIONS AND SYSTEMS INTERFACE TO NASD TRACE SYSTEM
NSCC has made some minor modifications to the NSCC/NASD TRACE (The Trade Reporting and Compliance Engine) formats for OTC Corporate Bonds that were issued in Important Notice A5274, dated June 7, 2001. The formats have been enhanced to provide more definitive explanations of trade input. In addition, some field lengths have been modified. The fields whose record lengths have changed are have been shaded.
The modified formats are attached to this notice. In addition, the formats can be accessed at NSCC’s website at http://formats.nscc.com/. The formats attached to the June 7, 2001 notice on NSCC’s website have also been modified.
The Street Side Datatrak system IDs for T input are: 17030 (non RJE) and 17037 (RJE). For As Of input they are: 17441 (non RJE) and 17447 (RJE). The Customer Datatrak system IDs are: 29695 (non RJE) and 29696 (RJE).
Questions on the modifications can be directed to the undersigned at (212) 855-5683.
Ed Fanning
Vice President, Product Marketing & Development
NASD TRANSACTION DETAIL (RJE) - Datatrak Header
|
FILE NAME |
DATA TRACK HEADER FOR NASD TRANSACTION DETAIL (RJE) # 29696 |
|||
| ORGANIZATION | SEQUENTIAL | |||
| RECORD LENGTH | 80 | |||
| BLOCK SIZE | 27920 June 25, 2001 |
|||
|
Start |
End |
Length |
Type |
Field Description |
|
1 |
5 |
5 |
A/N |
Constant 'HDR.S' |
|
6 |
10 |
5 |
N |
Sysid '29696' |
|
11 |
12 |
2 |
A/N |
Constant '.E' |
|
13 |
14 |
2 |
N |
Constant '00' |
|
15 |
16 |
2 |
A/N |
Constant '.C' |
|
17 |
20 |
4 |
A/N |
Submitting Party - Originator |
|
21 |
22 |
2 |
A/N |
Constant '.S' |
|
23 |
26 |
4 |
N |
Submitted For Party - Suboriginator |
|
27 |
27 |
1 |
A/N |
Future Use - Spaces |
|
28 |
33 |
6 |
N |
Processing Date MM/DD/YY Reflects NSCC Output Date |
|
34 |
34 |
1 |
A/N |
Future Use - Spaces |
NASD TRANSACTION DETAIL (RJE) - Datatrak Header
|
FILE NAME |
DATA TRACK HEADER FOR NASD TRANSACTION DETAIL (RJE) # 29696 |
|||
| ORGANIZATION | SEQUENTIAL | |||
| RECORD LENGTH | 80 | |||
| BLOCK SIZE |
27920 |
|||
|
Start |
End |
Length |
Type |
Field Description |
|
35 |
59 |
25 |
A/N |
Constant ‘NASD Trade Report’ |
|
60 |
60 |
1 |
A/N |
Multi-batch Indicator ‘N’ = No ‘Y’= Yes |
|
61
|
63 |
3 |
N |
Sequence Number |
|
64 |
80 |
17 |
A/N |
Future Use – Spaces |
NASD TRANSACTION DETAIL (RJE) - Detail [RECORD ONE]
|
FILE NAME |
NASD TRANSACTION DETAIL (RJE) # 29696 |
|||
| ORGANIZATION | SEQUENTIAL | |||
| RECORD LENGTH | 80 | |||
| BLOCK SIZE |
27920 |
|||
|
Start |
End |
Length |
Type |
Field Description |
|
1 |
1 |
1 |
A/N |
NASD Customer Trade Indicator Constant = 'R' RJE NASD Customer Trade |
|
2 |
11 |
10 |
A/N |
Filler |
|
12 |
12 |
1 |
A/N |
Trade Modifier 'W' = Weighted Average PriceSpace = Not Weighted Average Price |
|
13 |
13 |
1 |
A/N |
Price Override 'Y' = Price Override OptionSpace or ‘N’ = No Price Override (Used for resubmission of a previously rejected TRACE trade to indicate the entered price/yield is valid although it may fall outside the reasonability check). |
|
14 |
14 |
1 |
A/N |
Special Price Indicator ‘Y’ = Trade executed at a special price not reflective of the current market price. Space or ‘N’ = Trade was not executed at a special price. |
|
15 |
16 |
2 |
A/N |
Filler |
|
17 |
25 |
9 |
A/N |
CUSIP Number (TRACE Required) |
|
26 |
33 |
8 |
N |
Trade Date ‘CCYYMMDD’ (TRACE Required) |
|
34 |
37 |
4 |
N |
Time-of-Trade Execution HHMM, Military format, Eastern Time (34-35 = Hours)(36-37 = Minutes) (TRACE Required) |
NASD TRANSACTION DETAIL (RJE) - Detail [RECORD ONE]
|
FILE NAME |
NASD TRANSACTION DETAIL (RJE) # 29696 RECORD ONE |
|||
| ORGANIZATION | SEQUENTIAL | |||
| RECORD LENGTH | 80 | |||
| BLOCK SIZE |
27920 |
|||
|
Start |
End |
Length |
Type |
Field Description |
|
38 |
41 |
4 |
A |
Dealer Identifier Firm Dealing Directly with End Customer - Valid NASD Symbol (MPID) required.(TRACE Required) |
|
42 |
42 |
1 |
A |
Buy/Sell Code ‘B’ = Dealer is Buyer ‘S’ = Dealer is Seller (TRACE Required) |
|
43 |
51 |
9 |
N |
Quantity 9(9) Par Value Traded Integer, no commas or decimal point (TRACE Required) |
|
52 |
61 |
10 |
A/N |
Dollar Price Includes explicit decimal point. Position of decimal point may vary. All of the following are valid 100.123456 89.1234567 099.50000 (TRACE Required. For WI trades, the price is not required if a yield is provided). |
|
62 |
70 |
9 |
A/N |
Yield Includes explicit decimal point. Position of decimal point may vary, e.g.03.45678, or 3.45678. Units are percent, e.g. 03.5 denotes 3.5% ( TRACE required. For WI trades, Yield is not required if Dollar Price is provided). |
|
71 |
74 |
4 |
A/N |
Clearing Number |
|
75 |
78 |
4 |
A/N |
Filler |
|
79 |
80 |
2 |
N |
Constant ‘01' First physical record of this transaction. |
NASD TRANSACTION DETAIL (RJE) - Detail [RECORD TWO]
|
FILE NAME |
NASD TRANSACTION DETAIL (RJE) # 29696 RECORD TWO |
|||
| ORGANIZATION | SEQUENTIAL | |||
| RECORD LENGTH | 80 | |||
| BLOCK SIZE |
27920 |
|||
|
Start |
End |
Length |
Type |
Field Description |
|
1 |
1 |
1 |
A/N |
NASD Customer Trade Indicator Constant = 'R' RJE NASD Customer Trade |
|
2 |
16 |
15 |
A/N |
Filler |
|
17 |
17 |
1 |
A |
Dealer’s Capacity ‘A’ = Agent for Customer‘P’ = Principal(TRACE Required) |
|
18 |
25 |
8 |
A/N |
Commission In Points per Bond. Field may be Blank or Zeroes when there is no commission. Includes explicit decimal point. Zero-filled at left. E.G: 000.0500 (TRACE required if charged to customer). |
|
26 |
33 |
8 |
N |
Settlement Date 'CCYYMMDD' (For Regular Way trades, can be blank if three business days settlement. For When Issued, Blank or zeroes if date is unknown). |
|
34 |
34 |
1 |
A |
Constant = 'F' |
|
35 |
50 |
16 |
A/N |
Dealer Transaction Control Number An identifier of the transaction sufficient to associate all its data in the system. Format of control number is determined by dealer. |
|
51 |
78 |
28 |
A/N |
Filler |
|
79 |
80 |
2 |
N |
Constant '02' Second physical record of this transaction |
NASD TRANSACTION DETAIL (RJE) - Datatrak End Record
|
FILE NAME |
DATA TRACK END RECORD FOR NASD TRANSACTION DETAIL (RJE) # 29696 |
|||
| ORGANIZATION | SEQUENTIAL | |||
| RECORD LENGTH | 80 | |||
| BLOCK SIZE |
27920 |
|||
|
Start |
End |
Length |
Type |
Field Description |
|
1 |
5 |
5 |
A/N |
Constant 'END.S' |
|
6 |
10 |
5 |
N |
Sysid '29696' |
|
11 |
12 |
2 |
A/N |
Constant '.E' |
|
13 |
14 |
2 |
N |
Constant '00' |
|
15 |
16 |
2 |
A/N |
Constant '.C' |
|
17 |
20 |
4 |
A/N |
Submitting Party - Originator |
|
21 |
22 |
2 |
A/N |
Constant '.S' |
|
23 |
26 |
4 |
N |
Submitted For Party - Suboriginator |
|
27 |
80 |
54 |
A/N |
Future Use - Spaces |
NASD TRANSACTION DETAIL - Datatrak Header
|
FILE NAME |
DATA TRACK HEADER FOR NASD TRANSACTION DETAIL # 29695 |
|||
| ORGANIZATION |
SEQUENTIAL
|
|||
| RECORD LENGTH | 160 | |||
| BLOCK SIZE |
27840 |
|||
|
Start |
End |
Length |
Type |
Field Description |
|
1 |
5 |
5 |
A/N |
Constant 'HDR.S' |
|
6 |
10 |
5 |
N |
Sysid '29695' |
|
11 |
12 |
2 |
A/N |
Constant '.E' |
|
13 |
14 |
2 |
N |
Constant '00' |
|
15 |
16 |
2 |
A/N |
Constant '.C' |
|
17 |
20 |
4 |
A/N |
Submitting Party - Originator |
|
21 |
22 |
2 |
A/N |
Constant '.S' |
|
23 |
26 |
4 |
N |
Submitted For Party - Suboriginator |
|
27 |
27 |
1 |
A/N |
Future Use - Spaces |
|
28 |
33 |
6 |
N |
Processing Date MM/DD/YY Reflects NSCC Output Date |
|
34 |
34 |
1 |
A/N |
Future Use - Spaces |
|
35 |
59 |
25 |
A/N |
Constant 'NASD Trade Report' |
|
60 |
60 |
1 |
A/N |
Multi-batch indicator ‘N’ = No ‘Y’ = Yes |
|
61 |
63 |
3 |
N |
Sequence Number |
|
64 |
160 |
97 |
A/N |
Future Use - Spaces |
NASD TRANSACTION DETAIL - Detail
|
FILE NAME |
NASD TRANSACTION DETAIL (NJE) # 29695 |
|||
| ORGANIZATION | SEQUENTIAL | |||
|
RECORD LENGTH
|
160
|
|||
| BLOCK SIZE |
27840 |
|||
|
Start |
End |
Length |
Type |
Field Description |
|
1 |
1 |
1 |
A/N |
NASD Customer Trade Indicator Constant = 'N' NJE NASD Customer Trade |
|
2 |
11 |
10 |
A/N |
Filler |
|
12 |
12 |
1 |
A/N |
Trade Modifier 'W' = Weighted Average PriceSpace = Not Weighted Average Price |
|
13 |
13 |
1 |
A/N |
Price Override 'Y' = Price Override OptionSpace or ‘N’ = No Price Override (Used for resubmission of a previously rejected TRACE trade to indicate the entered price/yield is valid although it may fall outside the reasonability check). |
|
14 |
14 |
1 |
A/N |
Special Price Indicator ‘Y’ = Trade executed at a special price not reflective of the current market price. Space or ‘N’ = Trade was not executed at a special price |
|
15 |
22 |
8 |
A/N |
Filler |
|
23 |
31 |
9 |
A/N |
CUSIP Number (TRACE Required) |
|
32 |
39 |
8 |
N |
Trade Date ‘CCYYMMDD’ (TRACE Required) |
|
40 |
43 |
4 |
N |
Time-of-Trade Execution HHMM, Military format, Eastern Time (40-41 = Hours) (42-43 = Minutes) (TRACE Required) |
NASD TRANSACTION DETAIL - Detail
|
FILE NAME |
NASD TRANSACTION DETAIL # 29695 |
|||
| ORGANIZATION | SEQUENTIAL | |||
| RECORD LENGTH | 160 | |||
| BLOCK SIZE |
27840 |
|||
|
Start |
End |
Length |
Type |
Field Description |
|
44 |
47 |
4 |
A |
Dealer Identifier Firm Dealing Directly with End Customer - Valid NASD Symbol (MPID) required. (TRACE Required) |
|
48 |
48 |
1 |
A |
Buy/Sell Code ‘B’ = Dealer is Buyer‘S’ = Dealer is Seller (TRACE Required) |
|
49 |
57 |
9 |
N |
Quantity 9(9) Par Value Traded Integer, no commas or decimal point (TRACE Required) |
|
58 |
67 |
10 |
A/N |
Dollar Price Includes explicit decimal point. Position of decimal point may vary. All of the following are valid 100.123456 89.1234567 099.50000 (TRACE Required. For WI trades, the price is not required if a yield is provided). |
|
68 |
76 |
9 |
A/N |
Yield Includes explicit decimal point. Position of decimal point may vary, e.g.03.45678, or 3.45678. Zero filled at left Units are percent, e.g. 03.5 denotes 3.5% ( TRACE required. For WI trades, Yield is not required if Dollar Price is provided). |
|
77 |
77 |
1 |
A |
Dealers Capacity ‘A’ = Agent for customer ‘P’ = Principal (TRACE Required) |
|
78 |
85 |
8 |
A/N |
Commission In Points per Bond. Field may be Blank or Zeroes when there is no commission. Includes explicit decimal point. Zero-filled at left. E.G: 000.0500 (TRACE required if charged to customer). |
NASD TRANSACTION DETAIL - Detail
|
FILE NAME |
NASD TRANSACTION DETAIL # 29695 |
|||
| ORGANIZATION | SEQUENTIAL | |||
| RECORD LENGTH | 160 | |||
| BLOCK SIZE |
27840 |
|||
|
Start |
End |
Length |
Type |
Field Description |
|
86 |
93 |
8 |
N |
Settlement Date ‘CCYYMMDD’ (For Regular Way trades, can be blank if three business days settlement. For When Issued, Blank or zeroes if date is unknown). |
|
94 |
94 |
1 |
A |
Constant = 'F' |
|
95 |
110 |
16 |
A/N |
Dealer Transaction Control Number An identifier of the transaction sufficient to associate all its data in the system. Format of control number is determined by dealer. |
|
111 |
134 |
24 |
A/N |
Filler |
|
135 |
138 |
4 |
A/N |
Clearing Number |
|
139 |
160 |
22 |
A/N |
Filler |
NASD TRANSACTION DETAIL - Datatrak End Record
|
FILE NAME |
NASD TRANSACTION DETAIL # 29695 |
|||
| ORGANIZATION | SEQUENTIAL | |||
| RECORD LENGTH | 160 | |||
| BLOCK SIZE |
27840 |
|||
|
Start |
End |
Length |
Type |
Field Description |
|
1 |
5 |
5 |
A/N |
Constant 'END.S' |
|
6 |
10 |
5 |
N |
Sysid '29695' |
|
11 |
12 |
2 |
A/N |
Constant '.E' |
|
13 |
14 |
2 |
N |
Constant '00' |
|
15 |
16 |
2 |
A/N |
Constant '.C' |
|
17 |
20 |
4 |
A/N |
Submitting Party - Originator |
|
21 |
22 |
2 |
A/N |
Constant '.S' |
|
23 |
26 |
4 |
N |
Submitted For Party - Suboriginator |
|
27 |
160 |
134 |
A/N |
Future Use - Spaces |
|
FITS CORPORATE/UIT TRADE DETAIL - NJE |
Detail |
||||
|
DATATRAK ID 17030 |
Record Length 160 |
||||
|
|
|||||
|
Description |
Length |
Start |
End |
Type |
Comments |
|
System Code |
1 |
1 |
1 |
N |
1 = Comparison |
|
Sub System Code |
1 |
2 |
2 |
N |
3 = Bonds |
|
Buy/Sell Code |
1 |
3 |
3 |
N |
2 = Buy (TRACE Required) |
|
Transaction Code |
1 |
4 |
4 |
A/N |
1 = Trade Day Input (TRACE Required) |
|
Future Use |
1 |
5 |
5 |
A/N |
RESERVED |
|
Major Clearing Participant |
4 |
6 |
9 |
N |
|
|
Major Executing Participant |
4 |
10 |
13 |
A/N |
(TRACE Requires Valid NASD Symbol - MPID) |
|
Contra Clearing Participant |
4 |
14 |
17 |
N |
(Minor) |
|
Contra Executing Participant |
4 |
18 |
21 |
A/N |
(Minor) (TRACE Requires Valid NASD Symbol - MPID) |
|
Trade Date |
8 |
22 |
29 |
N |
MMDDCCYY (TRACE Required) |
|
CUSIP |
9 |
30 |
38 |
A/N |
(30 - 35 Issuer) (TRACE Required) |
|
Future Use |
2 |
39 |
40 |
A/N |
RESERVED |
|
Market Of Execution |
1 |
41 |
41 |
N |
2 = OTC |
|
Quantity |
9 |
42 |
50 |
N |
999,999,999 (TRACE Required) |
|
Currency Indicator |
3 |
51 |
53 |
A/N |
USD = US Dollars |
|
Contract Amount |
12 |
54 |
65 |
N |
9,999,999,999.99 (TRACE Required) |
|
Dollar Price |
12 |
54 |
65 |
N |
9,999.99999999 (TRACE Required only for WI trade if firm submits Dollar Price rather than Contract Money). |
|
Price Indicator |
1 |
66 |
66 |
A/N |
Space Or 0 = Dollar Price (TRACE Required) |
|
FITS CORPORATE/UIT TRADE DETAIL - NJE |
Detail |
||||
|
DATATRAK ID 17030 |
Record Length 160 |
||||
| Description | Length | Start | End | Type | Comments |
|
Settlement Type Indicator |
1 |
67 |
67 |
A/N |
Space = Regular Way |
|
Settlement Date |
8 |
68 |
75 |
A/N |
MMDDCCYY |
|
Future Use |
7 |
76 |
82 |
A/N |
RESERVED |
|
Accrued Interest |
8 |
83 |
90 |
N |
999,999.99 (TRACE Required if Contract Amount Submitted) |
|
Future Use |
2 |
91 |
92 |
A/N |
RESERVED |
|
Settlement Date Adjustment |
2 |
93 |
94 |
A/N |
Space = Regular Settlement |
|
Time Of Trade |
4 |
95 |
98 |
A/N |
(95 - 96 Hours) (TRACE Required) |
|
QSR Indicator |
1 |
99 |
99 |
A/N |
Q = QSR Submission R = QSR Reversal Submission (Only Q submitted to TRACE) |
|
Future Use |
2 |
100 |
101 |
A/N |
RESERVED |
|
Trade Report Indicator |
1 |
102 |
102 |
A/N |
TRACE 'R' = Report Only 'C' = Clearing Only 'B' = Report & Clearing Space = Clearing Only |
Future Use |
1 |
103 |
103 |
A/N |
RESERVED |
|
Price Override |
1 |
104 |
104 |
A/N |
TRACE 'Y' = Price override Option ‘N’ or Space = No Price overrideUsed for resubmission of a previously TRACE rejected trade to indicate the entered price/yield is valid although it may fall outside the reasonability check. |
|
Trade Modifier |
1 |
105 |
105 |
A/N |
TRACE 'W' = Weighted Average Price Space = Not Weighted Avg. Price |
|
FITS CORPORATE/UIT TRADE DETAIL - NJE |
Detail |
|||||||||
|
DATATRAK ID 17030 |
Record Length 160 |
|||||||||
|
|
||||||||||
|
Description |
Length |
Start |
End |
Type |
Comments |
|||||
|
Yield |
9 |
106 |
114 |
A/N |
TRACE Includes explicit decimal point. Position of decimal point may vary, e.g. 03.45678, or 3.45678. Zero filled at left. Units are percent, e.g. 03.5 denotes 3.5% (TRACE Required. For WI trades, Yield is not required if Dollar Price is provided). |
|||||
|
Capacity |
1 |
115 |
115 |
A/N |
TRACE 'P' = Principal 'A' = Agent (TRACE Required) |
|||||
|
Commission |
8 |
116 |
123 |
A/N |
TRACE In Points per Bond Field may be Blank or Zeroes when there is no commission. Includes explicit decimal point. Zero-filled at left E.G. 00.05000. (TRACE required only if capacity is 'agent,' otherwise, may be zeros or blank.) |
|||||
|
Broker Dealer Transaction Number |
16 |
124 |
139 |
A/N |
TRACE A control number determined by the Dealer, used to uniquely identify the trade record. |
|||||
|
Future Use |
14 |
140 |
153 |
A/N |
RESERVED |
|||||
|
Special Price Indicator |
1 |
154 |
154 |
A/N |
TRACE ‘Y’ = Trade executed at a special price not reflective of the current market price. ‘N’ or Space = Trade was not executed at a special price. |
|||||
|
Contra Capacity |
1 |
155 |
155 |
A/N |
TRACE 'P' = Principal 'A' = Agent Leave Blank if not QSR (TRACE required for QSR submission). |
|||||
|
Future Use |
5 |
156 |
160 |
A/N |
RESERVED |
|||||
|
June 25, 2001 |
END OF RECORD |
|||||||||
|
FITS CORPORATE/UIT TRADE DETAIL - RJE RECORD 1 |
Detail 1 |
||||
|
DATATRAK ID 17037 |
Record Length 80 |
||||
|
|
|||||
|
Description |
Length |
Start |
End |
Type |
Comments |
|
System Code |
1 |
1 |
1 |
N |
1 = Comparison |
|
Subsystem Code |
1 |
2 |
2 |
N |
3 = Bonds |
|
Buy/Sell Code |
1 |
3 |
3 |
N |
2 = Buy (TRACE Required) |
|
Transaction Code |
1 |
4 |
4 |
A/N |
1 = Trade Day Input (TRACE Required) |
|
Future Use |
1 |
5 |
5 |
A/N |
RESERVED |
|
Major Clearing Participant |
4 |
6 |
9 |
N |
|
|
Major Executing Participant |
4 |
10 |
13 |
A/N |
(TRACE Requires Valid NASD Symbol - MPID) |
|
Contra Clearing Participant |
4 |
14 |
17 |
N |
(Minor) |
|
Contra Executing Participant |
4 |
18 |
21 |
A/N |
(Minor) (TRACE Requires Valid NASD Symbol - MPID) |
|
Trade Date |
8 |
22 |
29 |
A/N |
MMDDCCYY (TRACE Required) |
|
CUSIP |
9 |
30 |
38 |
A/N |
(30-35 ISSUER) (TRACE Required) |
|
Future Use |
2 |
39 |
40 |
A/N |
RESERVED |
|
Market Of Execution |
1 |
41 |
41 |
A/N |
2 = OTC |
|
Quantity |
9 |
42 |
50 |
N |
999,999,999 (TRACE Required) |
|
Currency Indicator |
3 |
51 |
53 |
A/N |
USD = US Dollars |
|
Contract Amount |
12 |
54 |
65 |
N |
9,999,999,999.99 (TRACE Required) |
|
Dollar Price |
12 |
54 |
65 |
N |
9,999.99999999 (TRACE Required only for WI trade if firm submits Dollar Price rather than Contract Money). |
|
Price Indicator |
1 |
66 |
66 |
A/N |
Space Or 0 = Dollar Price (TRACE Required) |
|
Settlement Type Indicator |
1 |
67 |
67 |
A/N |
Space = Regular Way |
|
Settlement Date |
8 |
68 |
75 |
A/N |
MMDDCCYY |
|
Future Use |
4 |
76 |
79 |
A/N |
RESERVED |
|
Record Identification |
1 |
80 |
80 |
N |
|