Home Page | Back 

 

User's Manual For Reporting Customer Transactions Using the MSRB PC Transaction Reporting System (PC TRS)

 

Version 1.1

MUNICIPAL SECURITIES RULEMAKING BOARD

Alexandria, VA 22307

(709) 797-6600


 

TABLE OF CONTENTS

1 INTRODUCTION

Purpose of Dial-up Reporting

Concept of Operations

Additional Information Sources



2 ENTERING AND REVIEWING TRANSACTION DATA

Starting the Software

Instructions for the Data Entry Screen

Completing Data Entry for One Transaction

Entering a Series of Transactions

Printing and Reviewing Trade Records

Changing Transaction Data

Entering Data for Certain "When-issued" Trades

Entering Data for Trades in Securities with a Non-fixed Rate



3  SUBMITTING FILES TO THE MSRB

Submitting Files that You Entered

Submitting Files Created Externally

Error Messages

Further Information on Submitting Files

Technical Note on File Sequence Numbers and File Names



4 RECEIPTS AND ERROR REPORTS

Amending, Canceling and Verifying Trades



5 SECURITY CONSIDERATIONS FOR THE DEALER

FIGURES

2-1 MAIN SCREEN
2-2 DATA ENTRY SCREEN
2-3 SCREEN COMPLETION OPTIONS
2-4 AUTOMATIC UPDATE OF CONTROL NUMBER
2-5 ERROR MESSAGE SCREEN
2-6 DISPLAY OF TRADES BEFORE TRANSMISSION
2-7 LOCAL TRADE HISTORY SCREEN
3-1 FILE OPTIONS
4-1 SAMPLE FAX
4-2 SAMPLE FILE


APPENDIXES

A DATA ELEMENT AND FILE FORMAT SPECIFICATION
B ERROR MESSAGES RELATED TO CUSTOMER TRADE RECORDS
C ERROR MESSAGES RELATED TO FILE TRANSMISSION



SECTION 1

INTRODUCTION

This manual describes how to report customer trades in municipal securities to the MSRB by using the free personal
computer transaction reporting system (PC TRS). The manual discusses:

  • Using PC TRS to enter data and transmit the file to the MSRB
  • Receiving error reports from the MSRB
  • Correcting errors in customer trade data.

Supplementary instructions provided separately describe:

  • Obtaining the software from the MSRB
  • Installing the software
  • Testing your firm's ability to use the software for customer transaction reporting.

 

PURPOSE OF DIAL-UP REPORTING

MSRB's rule G-14 requires dealers to report all transactions in municipal securities to the MSRB. Inter-dealer transactions
have been, and will continue to be, reported since 1995 as an automatic consequence of dealers' submission of trade
information to the automated comparison system operated by National Securities Clearing Corporation (NSCC). Transactions
between dealers and customers - termed "customer transactions" - will be reported separately beginning on March 1, 1998.

Most customer trades are reported to the MSRB by dealers who submit the required data directly to NSCC using
telecommunications lines that they also employ for inter-dealer reporting. However, because some dealers have neither
a telecommunications connection with NSCC nor a relationship with a firm that has such a connection,1 the MSRB provides
an alternative method: PC TRS. The PC TRS method is intended for dealers with a low volume of municipal securities customer
transactions (generally no more than three such transactions per day on average), and for dealers that currently use NSCC's
"NETSOFT" PC software as their exclusive connection to NSCC. NSCC's NETSOFT cannot be used for customer transaction
reporting, since all direct reporting of these trades must be done by connecting to the MSRB system. Dealers with higher volumes
of customer transactions may also use the PC TRS to supplement data that they transmit to NSCC from their mainframe computers
or record-keeping systems.

 

CONCEPT OF OPERATIONS

Overview of the Transaction Reporting System

The Transaction Reporting System, or TRS, operates at the MSRB's offices in the Washington, DC area. It contains a centralized
database that stores details, as reported by dealers, of all municipal securities transactions. Two TRS subsystems store data
about different types of trades: the Customer Transaction Reporting Subsystem (CTRS) handles customer trades and the Dealer
Transaction Reporting Subsystem (DTRS) handles inter-dealer trades. Customer trade data is submitted by dealers directly to
the CTRS or in files that are forwarded to CTRS by NSCC. Inter-dealer trade data is submitted by dealers to the NSCC automated
comparison system (known as the Fixed Income Transaction System or FITS), and FITS automatically transmits certain data about
each inter-dealer trade to DTRS.

The PC method for reporting customer trades is not designed to support inter-dealer trade reporting. Dealers must continue to
report inter-dealer trades in municipal securities to the MSRB via the FITS system as they have been doing since 1995. Dealers
will report customer trades to the MSRB in addition to the inter-dealer trades, using file formats designed solely for customer trade
data.

The TRS produces a daily report that reflects municipal securities market activity for the preceding business day. MSRB disseminates
this report to TRS subscribers who, in turn, broadly redistribute the information to the industry and the public. NASD and the bank
regulatory agencies use the TRS database to support their market surveillance activities and their inspection of dealers for
enforcement of MSRB rules.

 

PC TRS Capabilities

A dealer may use the PC TRS software to:

  • Enter customer trade data on a screen that identifies each data element required by MSRB rule G-14
  • Check (edit) the data for compliance with the TRS format specifications.

The dealer has the choice to use the above data entry features to create an input file for transmission to CTRS, or to use non-MSRB
software to extract data from its record-keeping system and reformat it according to CTRS specifications. In either case, the dealer
will use the PC software to:

  • Transmit a file of customer transaction data to the TRS
  • Download, from the TRS computer, a "receipt file" that acknowledges a file previously sent to the TRS and describes any errors
    found.

As an alternative or supplement to the downloaded receipt file, dealers may opt to receive a faxed report from TRS that has the same
information as the receipt file.

The TRS Host Computer and the Dealer's Client Computer

The TRS includes a computer that is dedicated to telecommunications, i.e., to communicating over telephone lines with the NSCC and
dealers. This computer is referred to as a "host," or "server," in distinction to the dealers' PCs, which are termed "clients" of the host.

The client computer in the dealer's office must use either Microsoft's Windows 95 or the Windows NT® operating system (version 4 or
better) in order to run the MSRB software.2 (The client computer is referred to as a PC, although other types of computers may run
Windows operating systems and therefore may also run the PC TRS.) The client computer must have a modem running at least
14,400 bps connected to a telephone line. At least 7.5 megabytes (MB) of disk storage must be available for the software, in addition
to space for any transaction data the dealer may wish to store on the computer's hard disk. There are no requirements for the dealer
to have other software or a particular type of chip (processor).

The client computer does not have to be dedicated to transaction reporting and therefore can be used for other purposes in the dealer
organization. However, MSRB's software is designed for use on stand-alone computers. It has not been tested on a variety of local
area networks (LANs) and hence it is not guaranteed to be compatible with the dealer's LAN.

Remote Access Services (RAS)

Windows 95 and Windows NT both have a feature called Remote Access Services (RAS), which enables a remote client computer to
connect easily to the TRS. Under the control of the PC software, RAS programs on the client will dial the telephone and establish a
connection, verify the user's identity, transfer files, and report the outcome of the telecommunications session.

Security

It is important that the dealer's computer and data are not compromised by any activities required by the transaction reporting
process. To this end, security safeguards have been designed into the TRS. In addition, dealer staff must employ certain manual
procedures to ensure security.

Programs. When the PC software installs itself, it creates a directory on the dealer's computer called CTRS to hold the
programs and the data entered by dealer staff. The client software will access only this CTRS directory. The software
cannot be used for any other purpose than data entry and file transmission to and from the TRS - it has no commands
that could affect non-CTRS data on the dealer's computer and it provides no means for a staff member to access other
programs or directories.

User identifiers and passwords. The user must enter an identifier (ID) and a password, assigned specifically for TRS
usage, each time he or she begins sending a file to the TRS. The TRS ID and password are additional to any dealer-
established password entered when logging in to Windows. The host system verifies that the ID and password used
during a telecommunications session are those assigned to the dealer.

Manual procedures. Dealer staff must coordinate with the MSRB in assigning the ID and password. Thereafter, dealer
staff must protect the ID and password to ensure it is used only by authorized persons, change the password periodically,
and control physical access to the client PC. Dealer personnel responsible for computer security and data integrity should
refer to the section of this manual entitled "Security Considerations for the Dealer."

 

ADDITIONAL INFORMATION SOURCES

Testing and installation of PC TRS are described in separate documents.

For additional information on the Transaction Reporting Program, see the following. "Q&A" refers to the document, "MSRB Transaction
Reporting Program: Questions and Answers," March 1997.

Rule G-14 Compliance

Q&A nos. 1-4

Inter-dealer Transaction Reporting

MSRB Reports, Vol. 14, No. 5 (December 1994) at 3-6

Q&A nos. 5, 6, 47-59

Guidelines for Reporting Inter-dealer Transactions

MSRB Reports, Vol. 16, No. 2 (June 1996) at 9-12

Customer Transaction Reporting

MSRB Reports, Vol. 17, No. 1 (January 1997) at 3-8, and Vol. 17, No. 3 (October 1997) at 9.

 

SECTION 2

ENTERING AND REVIEWING TRANSACTION DATA

 

STARTING THE SOFTWARE

To start the software, click CTRS under Programs on the Windows Start Menu.

You will see the Main screen (Figure 2-1). This screen controls data entry and file transmission.

NOTE: Overlaid on the Main screen is a box informing you whether there are records awaiting transmission to MSRB. The first time
you use the software there will be no such records. See "Submitting Files to the MSRB" below for information on this topic.

To enter data for a trade "from scratch," click on New Trade.

This choice appears on a button at the bottom of the Main screen and also under the Trade menu at the top of the screen.
The button and the menu choice are equivalent.

Figure 2-1        Figure 2-1

 

 

INSTRUCTIONS FOR THE DATA ENTRY SCREEN

Clicking on New Trade makes the screen entitled "First Report of Trade" appear. We refer to this as the Data Entry screen.
See Figure 2-2.

When the Data Entry screen first appears, the Dealer, Trade Date and Capacity fields are filled with default values: the executing
broker symbol typed in during setup and the current date, taken from your PC's system clock. You may type over these values, or
accept them.

Typing a different dealer symbol allows you to report trades that were effected by a different dealer. Typing over the trade
date allows you to report a trade to the MSRB after the date of the trade (which should be needed infrequently, since rule
G-14 requires trades to be reported by midnight of trade date). Typing "A" or "agent" over the Capacity field allows you to
report an agency trade.

Figure 2-2        Figure 2-2

When you position the cursor on any field in the screen, a prompt will appear on the bottom of the screen. This provides a "tip"
about the field. For example, the tip for the field CUSIP™ is "CUSIP number maximum length is 9 characters (required)."3

After you enter a value in a field, press TAB and the cursor will move to the next field. To move to the previous field, use the
mouse or press SHIFT-TAB.

Before you leave the screen (see "Completing Data Entry for One Transaction," below), you may change any value you have
entered by returning the cursor to the field. After you have filled out all the fields required and leave the screen, the system will
check the data and inform you if it finds certain errors, as described below in "Changing Transaction Data."

The formal definition of each field is given in Table 1 of Appendix A. Please review the definitions to be sure you provide the
required values for all fields. The following guidelines for each field will assist you in data entry. After the guidelines there is a
discussion of how to report some specific types of trades: "when-issued" trades and trades in securities that do not pay a fixed
rate of interest.

CUSIP (required)

Enter the nine-character CUSIP number, e.g., 123456AB9. Do not enter any spaces, as these would be counted as extra characters.

Only CUSIP numbers assigned by the CUSIP Service Bureau of Standard & Poor's may be reported to CTRS. Do not enter security
numbers assigned by a dealer or by an information service. However, the PC software does not check whether the entered CUSIP
number has been officially assigned. Unofficial "CUSIP numbers" will be flagged as errors when the host CTRS processes your file,
and you will have to cancel these trades with those CUSIPs.

Do not report trades in securities other than municipal securities, such as tax-free mutual funds or UITs. If you do, you will have to
cancel these trades later.

Buy/Sell (required)

Enter "buy" if you are reporting a purchase of a security from a customer. Enter "sell" if you are reporting a sale to a customer. You
may make the entry either by typing "B" or "S" or by using the cursor to pull down the list of values and selecting a value.

NOTE: The CTRS convention regarding "buy" and 'sell" may differ from the convention used on your firm's customer
confirmations.

Par (required)

Enter the par value (quantity) of securities traded. Enter the number of dollars (for example, 15000). After you go to another field,
the system adds commas to the display (15,000) so you can check what you have entered.

If the transaction is in zero coupon securities, enter the maturity value of the securities.

In nearly every trade, the par value will be an exact multiple of one thousand dollars. If you enter a par value that is not a multiple
of $1,000, the system will display, "Par is normally a multiple of $1,000. Override?" If the entered value is correct, answer "Yes" and
the value you entered will be stored. The same applies if the par value of the transaction is less than $1,000. Both these messages
are intended to ensure against accidentally entering the number of bonds traded (e.g., $50), when the par amount in dollars should
be entered ($50,000).

Dollar price (required except in certain "when-issued" trades)

Enter the price at which the trade was effected. The units are dollars per hundred dollars par value. Enter the decimal point, e.g.,
101.50. You may use a total of 10 characters including the decimal, but you do not have to type leading zeros or trailing zeroes.
Thus, all of the following are valid:

100.
100.00
99.5
100.123456
89.1234567
099.500000

If the dollar price is not required to be reported for a when-issued trade (see below), leave the field blank or enter "0.0".

Do not include the effect of any commission in the dollar price value. You will report commission later, in the same units as the dollar price.

We recommend typing the decimal point even when entering dollar prices such as "99." or "100.". The same holds true for integral values of yield and commission.

Yield (required except in certain trades)

Enter the yield at which the trade was effected. The units are per cent. Enter the decimal point, e.g., 5.5 for 5.5%. You may use a total of 9 characters including the decimal, but you do not have to type leading zeroes or trailing zeroes. Thus, all of the following are valid:

3.
3.00
3.5
3.4567899
03.45678

The yield value reported is the same "net" yield that is reported on customer confirmations. Therefore, it should include the effect of any commission (see MSRB rule G-15(a)). Rule G-15(a) in most cases requires the yield to be computed to the lower of call or nominal maturity date.

If the transaction was effected at par, the yield (coupon rate) should be reported on this screen, even though rule G-15(a) allows the yield to be omitted from the confirmation in such a case.

If a yield cannot not be computed for a transaction done on a dollar price basis, for example, because the trade is in a variable rate security or in a defaulted security, then the yield may be omitted (left blank or reported as zero).4

If reporting the yield is not possible because the transaction was done on a dollar price basis and no settlement date has been set for a "when-issued" security (see below), leave the yield blank or enter zero.

Commission (a value must be entered for agency trades)

Report the commission in the same units as the dollar price, i.e., in dollars per hundred dollars par value. Do not report the total amount of commission, e.g., $50.00. If the trade was effected on an agency basis, report the commission value, even if it is zero. If the trade was a principal trade, leave the commission blank or enter zero.

Time of trade (required)

Enter the time at which the trade was executed, in hours and minutes. Use the military convention, for example, 2:00 pm is 14:00 hours. The system provides a colon ":" between the hours and minutes. Report the time as Eastern time.

Do not report the time the data was entered into this system or another system. Instead, be sure to report the execution time, that is, the time the dealer and customer formed a contract to trade.

Trade date (required)

In this field, the system displays the current date as stored in your PC's clock. If the trade date of the transaction being reported differs from the current date, enter the date on which the trade was executed, in the format month/day/year (e.g., 12/01/98). The system stores four digits, e.g., 1998. (Whether it displays a two- or a four-digit year depends on the format used by the operating system. Use Window NT Settings. . . Control panel. . . Regional settings if you wish to change the format.)

Settlement date (required except in certain when-issued trades)

Enter the date on which the trade will settle, using the same format as trade date.

Dealer (required)

In this field, the system displays the executing broker symbol that you entered when you set up the client software. If this is accurate, you may skip the cursor over this field. Otherwise, you may type over the default symbol.

This field must contain the four-letter executing broker symbol (also known as market maker ID, or MMID) that identifies the dealer effecting the trade. To be accepted, this symbol must be known to the MSRB and the NASD.

An executing dealer may enter data on behalf of one of its correspondents that effected the trade with the customer. It is important to enter the symbol that identifies the dealer that effected the trade, which may not be the same as the dealer that executed the trade.

Capacity (required)

Enter the dealer's capacity with respect to the customer on this trade, i.e., whether the dealer acted as agent for the customer or as principal with respect to this customer. You may make the entry either by typing "P" or "A" or by using the cursor to pull down the list of values and selecting a value. The default value shown is "Principal".

Transaction control number (required unless the previous reference control number is provided)

When reporting a trade to the MSRB, you must report a transaction control number. The dealer may assign its own transaction control numbers, but must be sure that all records pertaining to a transaction share the same control number. This allows the CTRS to know which records to update if the transaction data changes, or the transaction is canceled, after it is first reported.

If you are reporting a transaction to the CTRS for the first time, enter its transaction control number. As described below, the PC software may assign a default number if you are entering a series of transactions. You may accept the default or type over it.

The transaction control number format is unrestricted except for a maximum length of 20 characters. The transaction control number must be one that has not been used for any other transaction reported by the firm in the previous three years, unless the firm has canceled the earlier transaction. You may submit a transaction with a certain transaction control number, cancel the transaction, and then submit different data with the original control number. Cancelling and resubmitting is equivalent to submitting an Amend record.

Previous reference (optional)

If you are reporting a change to a transaction - an Amend, Cancel, or Verify - you must report the transaction control number with which the transaction was first reported (the "original" control number). There are two alternative ways to do this while completing the Data Entry screen:

  • You may enter the original control number in the Transaction Control Number field, and leave the Previous Reference field blank. This is the simpler way and is recommended.
  • You may enter a new control number (one that has not previously been used) in the Transaction Control Number field, and enter the original control number in the Previous Reference field. You might wish to do this if, for example, your firm's record-keeping system requires a unique number for every transaction record.

NOTE: All records that pertain to a transaction must have the same control number. If you (1) report the trade (using an "F" record), then (2) amend the trade, then (3) Amend the trade again, or cancel the trade, then you must provide the same transaction control number on all of these records.

Cancel/Amend Code (automatically set by the software)

Every trade record sent to CTRS must have a cancel/amend code ("F" for first report of trade, "C" for cancel, etc.). However, this data item is not visible on the Data Entry screen, because it is added by the system based on the type of action you choose before you enter data (New Trade, Delete Trade, etc.). The screen displays the action chosen.

Further Information on Data Elements

Further information on the data elements just discussed may be found in MSRB Reports and the "Questions and Answers" document as follows:

Executing broker symbol

MSRB Reports, Vol. 15, No. 3 (October 1995) at 35-37

MSRB Reports, Vol. 17, No. 2 (January 1997) at 9

Q&A nos. 69-75

Time-of-trade

MSRB Reports, Vol. 16, No. 21 (June 1996) at 7-8

MSRB Reports, Vol. 16, No. 3 (September 1994) at 17-18

Q&A nos. 30-31

Price and yield: Nos. 17-20.

Settlement date: Nos. 21-23.

Capacity as agent/principal: Nos. 24-26.

Transaction control number: No. 28.

Cancel/amend code: Nos. 34-46.

 

COMPLETING DATA ENTRY FOR ONE TRANSACTION

Saving the data

After you have filled in all the required fields for the transaction, choose one of the actions listed at the bottom of the Data Entry screen. As shown in Figure 2-3, these are:

  • Save & add another
  • Save & close
  • Cancel & close

 

Figure 2-3        Figure 2-3

 

Choosing Save & add another saves the data you have entered and returns you to the Data Entry screen to add another transaction record. The saved records are held until you dial up to the CTRS host computer to transmit a file of records.

Choosing Save & close saves the data you have entered and leaves the Data Entry screen. You may then close the CTRS application and use the PC for other work, or you may transmit a file to the CTRS host.

Choosing Cancel & close does not save the data you have just entered. It closes the Data Entry screen and discards the data. You may choose this option at any time while the Data Entry screen is displayed, for example, if you wish to "erase" the values you have entered.

 

ENTERING A SERIES OF TRANSACTIONS

The option to Save & add another returns you to the Data Entry screen to enter another transaction. The system redisplays the data that was on the screen before you saved it (except the transaction control number). This supports data entry of a series of transactions that have similar data, such as several trades which all share the same CUSIP, trade date, settlement date, etc.

If the next trade you enter has different data, be sure to overlay all the appropriate fields.

Since every transaction must have a unique control number, when you begin to enter a trade, the system displays a new transaction control number if possible. This happens if you have just completed entering a trade and the control number of the previously entered trade is all numeric. In this way, the system may assign control numbers automatically to a series of transactions. To remind you of this feature, after you Save & add another, the system displays the prompt shown in Figure 2-4.

 

Figure 2-4        Figure 2-4

 

If the previous transaction's control number is not all numeric (i.e., it contains any letters or spaces, the system cannot increment it and displays the message "Transaction number NOT updated." Instead, the previous transaction control number remains on the screen unchanged. If you are entering a series of transactions, be sure that each control number is accurately entered and that it differs from all the others.

 

PRINTING AND REVIEWING TRADE RECORDS

To print out trade records that you have entered before you transmit them to the CTRS, from the Main screen select File . . . Print. The screen displays a list of all untransmitted files. Alternatively, the Edit feature described below enables you to review the records without printing them out.

Note that the print feature applies only to records not already transmitted to the CTRS. After the records are assembled into a file and transmitted, they are saved in a text file that you can print as you print any other file.

 

CHANGING TRANSACTION DATA

The method to use for changing data about a transaction depends on what you have done since you entered the data.5

Correcting format errors immediately after data entry

As soon as you choose a Save or Cancel option to leave the Data Entry screen, the client software checks the entries. If it finds questionable data, it will display messages as shown in the sample screen of Figure 2-5.

 

Figure 2-5        Figure 2-5

 

After you click on "OK," the Data Entry screen reappears. You may change any field on the screen and repeat the checking step. If there are no errors when the data is checked, it is stored and the next screen appears.

Editing data before transmission to the host CTRS

If you need to change a transaction record after it has been saved but before it is transmitted to the MSRB, look at the display of records on the Main screen (see Figure 2-6). Put the cursor on the record to be changed (scroll the display vertically or horizontally to see the data you want). Click the cursor on the record to highlight it, then select Edit Trade at the bottom of the screen. The record will be displayed on the Data Entry screen, where any field can be changed. (This also is an online method to review the data you have entered, rather than printing the records.)

 

Figure 2-6        Figure 2-6

 

 

You may select Delete Trade at the bottom of the screen to delete a highlighted record before sending the file to the MSRB.

As an alternative to the selections at the bottom of the Main screen, you may activate the Trade menu at the top of the screen. The menu is divided into two portions; the upper portion offers the same Edit and Delete choices just described.

You may sort the records on the Main screen. Put the cursor on any column heading and click it to sort all records on that column. By sorting on fields such as CUSIP number or settlement date, you can review a group of trades. In order to find a particular record, assuming that you know (for example) its control number, sort on control number and scroll up or down to find the number you need.

Editing data after transmission to the host CTRS

The PC software cannot change a record after it is transmitted to the host system, because it would then differ from the record stored in the central CTRS. However, a record already transmitted to CTRS can be used as the basis of a new record that will amend (i.e., update), cancel or verify CTRS data. A record may have to be amended or canceled because your firm has initiated a change (such as a cancel-and-rebill), or it may have to be amended, canceled or verified in response to an error message from the host CTRS. See the section "Receipts and Error Reports" below for more information on responding to error messages from the host.

Reviewing data after transmission to the host

You can review trade records after transmitting them to the CTRS host through the screen entitled "Local Client Trade History"6   (See Figure 2-7) Bring up this screen by selecting Trade . . . Amend or Cancel or Verify from the Main screen.

 

Figure 2-7         Figure 2-7

The Local Client Trade History screen displays all fields of the Data Entry screen, as well as data about the name and sequence number of the file in which a record was included when transmitted to the CTRS host. Only a few fields fit on the screen at any one time, but the scroll bars can be used to move the window horizontally or vertically to see more fields or records. You can sort all the records based on any field by clicking on the column heading of that field.

 

ENTERING DATA FOR CERTAIN "WHEN-ISSUED" TRADES

Sometimes customer trades are done in securities that are in "when-issued" (WI) or "new issue" (NI) status before the first settlement date is determined. In this case, the dealer must report either the trade's dollar price or the yield to CTRS, but may omit the other parameter (since settlement date is needed to calculate price from yield, or yield from price). Simply enter the price or yield, whichever is known.

When the initial settlement date is determined, the host CTRS will update the trade record in the central database by calculating the missing parameter. In this case it is not necessary for the dealer to submit an Amend record to provide the dollar price or yield.

Note that, if the settlement date is known, you must report both the price and the yield for a when-issued trade. The only exception is described in the next paragraph.

 

ENTERING DATA FOR TRADES IN SECURITIES WITH A NON-FIXED RATE

If a municipal security does not have a fixed rate of interest, you should report the dollar price for the trade, but report the yield as blank or zero. Examples of such securities are: variable rate securities, municipal collateralized mortgage obligations, and securities that prepay principal. You should also report the dollar price but no yield for trades in defaulted securities and securities traded on a discounted basis.

SECTION 3

SUBMITTING FILES TO THE MSRB

 

SUBMITTING FILES THAT YOU ENTERED

Once you finish entering trade records and close the Data Entry screen, you can have the system assemble the records into a file and transmit them to the host CTRS at the MSRB's offices.

From the Main screen, select File. . . Transfer trades to MSRB.

 

Figure 3-1

NOTE: When you start the CTRS client application (by clicking on the CTRS icon), the system checks for any existing trade records that have not yet been transmitted to the host CTRS. If any records are found, the system displays ATTENTION PLEASE! There are nnn trades that have not been transmitted to MSRB! This message serves as a reminder that trades must be reported by midnight (Eastern time) of trade date, and suggests that there are untransmitted records "left over" from the last data entry session. You may transmit the records before starting to make a new file, or you may add, change or delete some records before transmitting.

Before starting a transmission, the system requests you to enter the "account ID" and password. The account ID is the submitter ID followed by the site code, which you entered during the setup procedure. Guidelines for entering the account ID:

  • Enter the submitter ID and site code without any spaces between them, for example, BRKR01. The submitter ID is always four characters, and the site code is always two digits.
  • If you are unsure of the account ID, you can display it by selecting View...Dealer Setup.
  • Viewing the Dealer Setup screen will display the submitter ID and site code, but not the password.
  • The submitter ID does not have to be the same as the user name that was entered when you (or the computer=s owner) logged onto Windows after the computer was turned on. The system will accept any valid account ID and password known to the host computer.

If the entered information is incorrect, "Invalid account" is displayed. Verify the information and try changing the position of the CAPS LOCK key, because the system distinguishes FIRM01 from Firm01. The account ID and password typically are both all upper case.

The system then displays, Enter the file sequence number. In almost all circumstances you should select OK to accept the default sequence number. This number will be inserted into the header record of your file. (See the "Technical Note" at the end of this section for more information about the file sequence number.)

The system then displays a Save as. . . screen with a default file name and folder. In almost all circumstances you should select the default file name shown after Save to. However, if your computer is not able to save file names longer than eight characters, you may get an error message, "The above file name is invalid." If so, see the "Technical Note".

The system then displays, Transaction file generated - Start MSRB Transfer? Answer Yes to have the file transmitted to the host CTRS computer. Answer No to defer file transmission.

If you answer Yes, the system displays, Connecting to MSRB CTRS. It displays the status of the file transmission.

While connected to the CTRS host, the client software retrieves any receipt files that the host created in response to your previous transmissions. See the "Receipts and Error Reports" section below.

 

SUBMITTING FILES CREATED EXTERNALLY

The CTRS client software can be used to transmit customer transaction files that you create outside the Data Entry screen, i.e., "externally." An externally created file must conform to the MSRB's file specifications (see Appendix A). For example, a dealer may wish to create files externally by extracting data from its record-keeping system.

To transmit such a file to the CTRS host, from the Main screen select File . . . Transfer external file to MSRB. You will be prompted to enter the account ID and password (see "Submitting Files That You Entered"). The system will display a list of files in the CTRS folder. Click on a file to select it, and choose Open. The file transmission process will start and you will see the Connecting to MSRB CTRS screen mentioned above.

ERROR MESSAGES

Appendix C contains error messages related to file transmission. If you receive a message not shown in this appendix, call the MSRB.

FURTHER INFORMATION ON SUBMITTING FILES

Further information on the file submission process may be found in the"Questions and Answers" document in items 13-16.

 

TECHNICAL NOTE ON FILE SEQUENCE NUMBERS AND FILE NAMES

This section provides technical details describing how CTRS identifies and names files. If you send files by accepting the system defaults as to file sequence number and file name, you may skip this section.

File sequence numbers

CTRS customer transaction files consist of a header record followed by detail records (one detail record per transaction). The header record format includes the submission date (actually the date the client software created the file) and a file sequence number to distinguish among files created on a given day. The default sequence number is 0001 for the first file created in a day.

As currently designed and operated, it should not be necessary for you to set the sequence number of a file to anything different than the default number. The system provides the opportunity for you to override the default in case it should become necessary. It is strongly recommended that you accept the default sequence number.

File names

The CTRS system requires unique names for all transaction files. The client software assigns a name to a transaction file when it is created. The name consists of the submitter ID, the site code, a sequential number, and the date. The file extension is CT (customer transaction). A typical file name and extension for submitter SUBM would be:

SUBM010001_09151997.CT

If your computer is not configured to display file names of more than eight characters (plus a three-character extension), your system might automatically convert the longer file name to a shorter one, such as:

SUBM01~1.CT

Store the file with the automatically created file name if possible. If your system does not store long file names and does not automatically convert long names to short ones, you should type in a short name in the Save screen. Be sure the name you use is unique, i.e., different from any other customer trade file.

After the host CTRS computer processes a file you submit, it creates a receipt file for downloading to your PC (see "Receipt and Error Reports," below). It assigns a name to the receipt file that corresponds to the .CT file you submitted. For example, if your trade file name is SUBM01~1.CT, the corresponding receipt file name will be SUBM01~1.RCT. The header record of the receipt file also repeats information taken from the header of the submitted file, to enable you to match the receipt with the original file.

 

SECTION 4

RECEIPTS AND ERROR REPORTS

 

The host CTRS produces a receipt file for every customer transaction file it receives. The purpose of the receipt file is to acknowledge that your file was received and to list any errors or apparent errors that the host detected. You may obtain the acknowledgement and error information by requesting the MSRB to send it automatically as a fax to your firm's fax machine, or you may dial up to the host CTRS to download it to your PC as a computer file (the "receipt").

A sample fax is shown in Figure 4-1. MSRB plans to send the fax by 6:00 am for files received by midnight. To get the fax you must inform the MSRB of the person and phone number to which the fax should be sent.

The computer file version of the receipt contains the same information as the fax; a sample is shown in Figure 4-2 in printed form. Normally, within a few minutes after you transmit a file to the CTRS, the receipt file is available for downloading. The next time you dial in to the host - either to submit a file or after you select Retrieve Receipts from MSRB - the receipt file is transmitted to your PC and stored in the CTRS folder. To see a list of all files sent to and received from the MSRB, select View . . . Submitted files. On the next screen, the column "Client Filename" shows the name of the submitted file and "Receipt Filename" is the name of the receipt file as stored on your PC. The receipt file is formatted in ASCII and can be displayed or printed by the Windows editor program or by a word processing package.

 

AMENDING, CANCELING AND VERIFYING TRADES

This section describes how to change data about a trade stored in the host system after the trade has been first reported. As noted above in "Changing Transaction Data," the need for a change may arise from conditions detected by your firm or from an error message reported back to you by the host CTRS.

Types of Errors

Some conditions detected during CTRS processing make the trade unsuitable for public reporting or for storage in the surveillance database - for example, a trade without either price or yield cannot be publicly reported. When such an error is reported back to you, you must correct the information by sending CTRS an Amend, Cancel or Verify record. Other conditions are less serious and do not necessarily make a trade unsuitable for reporting purposes - for example, a "principal" trade that is reported with a non-zero commission (which CTRS handles as though it is an agency trade). The less serious conditions are indicated by error messages that include the words "ATTENTION" or "POSSIBLE ERROR." A response to these messages is not required unless there is an actual error.

 

Fig 4-1 Sample Fax

Figure 4-1 Sample Fax

 

Fig 4-2 Sample File

Figure 4-2 Sample File

 

The list of error messages in Appendix B distinguishes the more serious error conditions from the less serious ones.

Before describing the procedure for creating Amend, Cancel and Verify records, we will note the differences between them.

Amend record. The Amend record is a correct version of the record in which errors were found. All fields of the Amend record should contain correct data (whether the field was originally in error or not). The host CTRS logically replaces the original record with the Amend record.

Cancel record. The Cancel record causes the CTRS host to logically delete a previously reported trade. Two formats are available: Either use the Cancel screen to resend the original trade data (the Cancel screen automatically sets the record's Cancel/Amend code to "C") or use the Cancel screen to send only the dealer identifier and the control number (plus the automatically-set "C" code).7 The table below shows an original record and the alternative Cancel formats.

RECORD TYPE
CUSIP
DEALER
PAR
PRICE
(etc.)
CANCEL/AMEND
CODE*
CONTROL

NUMBER


ORIGINAL
123456JJ0
ABCD
10000
99.5
. . . .
F
12345
CANCEL (Format 1)
123456JJ0
ABCD
10000
99.5
. . . .
C
12345
CANCEL (Format 2)
              
ABCD
         
          
        
C
12345

*The cancel/amend code is not displayed on the Data Entry screen.

Verify record. The host CTRS may produce an error message stating that the price and yield you reported as inconsistent - based upon securities information (coupon, etc.) stored in the host C but in some cases you may find, after review, that the price and yield are consistent based upon your firm's securities information. In this case, you must send a Verify record to the host to indicate that you have verified the originally reported data. The same two formats are available for Verify records as for Cancel records, with a "V" code instead of the "C".

Procedure for Amending, Canceling or Verifying

From the Main screen's Trade menu, choose the action you wish to carry out:

  • Amend trade
  • Cancel trade
  • Verify trade

Since these actions will be performed on a record already transmitted to the CTRS, the system now displays the Local Trade History screen. When you find the desired record on this screen, click on Select trade. The record appears on the Data Entry screen.

To amend: Change only the field(s) that were incorrect in the first report of the trade. Leave all the other fields unchanged from the first report. Do not change the transaction control number, as this must be part of the amend to inform the CTRS host which transaction is affected. However, if required by your firm's procedures, you may copy the original control number into the Previous Reference number field and enter a new control number in the Transaction Control Number field.

Note: You may not change the CUSIP number of a trade. If the incorrect CUSIP was reported, cancel the trade and submit a new trade. Similarly, you may not change the symbol of the dealer that effected the trade; if necessary, cancel and resubmit the trade.

To cancel: To submit a Cancel record, you do not need to change any data on the Cancel screen. Saving this screen creates a new record whose Cancel/Amend code is "C".

To verify: As noted above, "verify" record is submitted when the host CTRS has issued an message showing an apparent error but, in fact, the trade was originally reported correctly. This may happen if, for example, the dealer and the host CTRS have different information about a security, causing the dollar price and yield to appear inconsistent, and it is found that the dealer's information is correct. To submit a "verify," leave the original data unchanged and store the new "verify" record.

If the record you wish to change is not displayed in the Local Trade History - because, for example, it was originally reported via a mainframe - choose Not listed - Add at the bottom of the screen. A blank Data Entry screen will appear. Filling out this screen will create a new record with "A", "C" or "V" as its Cancel/Amend code. Follow the same rules as above.

 

SECTION 5

SECURITY CONSIDERATIONS FOR THE DEALER

 

The security features of the CTRS client software are meant to prevent unauthorized persons from submitting information or accessing the dealer's proprietary information. As noted in the "Introduction," these "built-in" security features must be coordinated with manual procedures. Some necessary manual procedures are:

Protect the user ID and password. The usual precautions against writing down the password and sharing it with unauthorized persons apply to the CTRS password. This is because an unauthorized person with the ID and password who can access the CTRS client computer can submit false information to the MSRB.

Change the password periodically. To guard against promulgation of the password within the firm, and to ensure that personnel who leave the firm do not continue to have a valid password, the password should be changed periodically. The dealer firm can determine how frequently this should be done, based upon its staff turnover rate and similar factors. To change the password, call the MSRB. Changes to the submitter ID or site code may be made in the same way. You may be asked for the name of the person in your firm who authorizes the change.

Control physical access to the PC. An additional safeguard against the submission of incorrect information is to control access to the PC. This is because data entry is not protected by the CTRS password, so an unauthorized person with access might enter records into the PC that later could be transmitted unknowingly to the MSRB by an authorized person.

If you suspect that the password has been compromised and need to prevent all persons from using PC software until a new password is assigned, delete the file CTRS.EXE from the CTRS directory. Use a program such as Norton Utilities to ensure that no one can restore the file after you delete it.

 

APPENDIX A

DATA ELEMENT AND FILE FORMAT SPECIFICATION

Please follow the link above.

 

 

APPENDIX B

ERROR MESSAGES RELATED TO CUSTOMER TRADE RECORDS

Following are the error codes used in the original implementation of PC TRS.  For a current list of error codes, please see  Appendix J of the main TRS User's Manual.

The CTRS host generates the following error messages, which are displayed in the fax version of the receipt and error report. Shorter and slightly different messages appear in the file version. In the file, "ATTN:" is substituted for the words "POSSIBLE ERROR."

These messages refer to the trade records or the file header record. If you receive one of these messages, review the data in the file, determine if it should be corrected, and transmit the appropriate response to the CTRS host (Amend, Cancel or Verify record), unless a response is unnecessary, as noted below.

The messages and their IDs are subject to change as the CTRS system is refined.

 

MINOR ERRORS

The following messages alert the dealer to trade data that may be in error or (in the case of late submissions) that cannot be corrected. If the record is actually in error and is correctable, the dealer must respond by sending an "A" record to correct the error. If the dealer determines that the trade was reported correctly or was submitted late, no response is necessary, but the dealer may send a "V" (verify) record to inform MSRB that the data is valid.

ID



TEXT


193

POSSIBLE ERROR: Trade reported at least one day after trade date
194

POSSIBLE ERROR: File was submitted late
200

POSSIBLE ERROR: Time of trade missing
201

POSSIBLE ERROR: Time of trade invalid
202

POSSIBLE ERROR: Time of trade <> 6AM - 9PM
231

POSSIBLE ERROR: Par value is less than $1000
232

POSSIBLE ERROR: Par value is not a multiple of $1000
234

POSSIBLE ERROR: Par value is greater than $20 million
242

POSSIBLE ERROR: Dollar price is less than $1.00
250

POSSIBLE ERROR: Yield required when SD is known
251

POSSIBLE ERROR: Yield is less than 1% or greater than 30%
260

POSSIBLE ERROR: Dealers capacity missing
261

POSSIBLE ERROR: Dealers capacity invalid must be "A" or "P"
270

POSSIBLE ERROR: Commission is missing for an agency trade
271

POSSIBLE ERROR: Commission is present for a principal trade
272

POSSIBLE ERROR: Commission is greater than 10%
281

POSSIBLE ERROR: Settlement date is earlier than trade date
282

POSSIBLE ERROR: Settlement date is invalid
300

POSSIBLE ERROR: Possible duplicate inter-dealer trade

MAJOR ERRORS ("REJECTS")

Trades with these errors are "rejected," that is, they are not acceptable, as reported, for transaction reporting purposes. The dealer must send a record to amend (correct), cancel or verify any record that has one of these errors. If the dealer reviews the trade and determines that it was correctly reported, he or she must send a "V" (verify) record. For example, error 182 may be shown for a valid CUSIP number assigned by the CUSIP Service Bureau of S&P too late on trade date to be entered into the MSRB master file - in this case the dealer should respond to the error message by sending a "V" record.

 

ID



TEXT


180

CUSIP number missing
182

9 digit CUSIP is not in MSRB master file
183

Invalid CUSIP check digit
190

Trade date missing
191

Trade date invalid
192

Trade date in the future
210

Executing broker symbol missing
220

Buy/sell indicator missing
221

Buy/sell indicator is not "B" or "S"
230

Par value missing
233

Par value is not numeric
240

Dollar price is required when SD known
241

Dollar price and yield missing
243

Dollar price is not numeric
244

Dollar price greater than $200.00
245

Calculated dollar price discrepancy
246

No decimal point found in dollar price
252

Yield is not numeric
253

Yield and calculated yield do not agree
262

Executing broker symbol is all numeric
263

Executing broker symbol is not alphabetic
264

Executing broker symbol is not in MSRB master file
273

Commission is not numeric
274

No decimal point found in commission
280

Settlement date is more than two years from current date
290

Cancel/amend code missing
291

Cancel/amend invalid. Must be F/C/A or V
292

No matching transaction for a cancel/amend or verify record
301

Control number already in use
302

Prior cancel found for control number reported here
310

Previous transaction control number missing for cancel/amend or verify record
311

Dealer control number missing
400

More than 4 errors were found

 

NO-ERROR MESSAGE

If no errors are found in the file, the following record is sent. No other error messages are sent. Note: In the receipt file downloaded to the client PC, error messages are tagged as type "D" records. However, this "no-error" record is tagged as a type "G" record. (The original MSRB file specification did not include type "G" or "H" records.) Instead of being followed by a type "T" record containing the transaction, the no-error message is followed by a type "H" record, which is blank. Thus the receipt/error file's body has a consistent structure (pairs of detail records), to support dealers who process the error file automatically.

001         FYI: All records were successfully processed (no errors were found)

 

HEADER ERROR MESSAGES

Messages regarding the application header record will appear in the fax or file in the same format as transaction error messages. If the dealer determines there is an error, he or she should call the MSRB. It may be necessary for the dealer to resubmit the entire file. Do not call the MSRB if the only error is number 194, late submission of file.

 

ID



TEXT


090

There were no records in this file
091

Header record is missing - Validation process terminated
092

File contains multiple header records
093

Duplicate header record
100

Submitter identifier missing
101

Invalid submitter Identifier. NOTHING PROCESSED
110

Invalid submitter site
111

Non numeric submitter site
120

Invalid submission date
121

Submission date missing
130

Submission time missing
131

Invalid submission time
140

Invalid sequential file number
141

Have not processed file with previous sequence number
150

Invalid version identifier
160

File type missing
161

Invalid file type must be S/R or T
170

Record count discrepancy - should match number of trades
171

Record count is not numeric
172

Record count is zero
173

No transaction detail records in file
194

POSSIBLE ERROR: Late submission of file

 

APPENDIX C

ERROR MESSAGES RELATED TO FILE TRANSMISSION

The CTRS client generates the following error messages, which are displayed on the screen during attempts to transmit a file to the host. If you receive one of these messages, take the action noted below.

2         ERROR_FILE_NOT_FOUND - Receipt file not present on host.

Action: Wait a few minutes for the host to complete processing of your file and generate a receipt file, then dial in again.

5         ERROR_ACCESS_DENIED - Client does not have privilege to write to its home directory.

Action: Call the MSRB.

11         ERROR_BAD_FORMAT - header is not correct length. This message refers to a file created outside the CTRS PC software which is being checked before transmission to the host.

Action: Make sure the header record in your file conforms to the file format specification.

13         ERROR_INVALID_DATA - Submitter ID and site in header were entered just before transmission; these do not match user ID client used for setup

Action: Select View. . . Dealer setup and change the data there, or enter the setup information when requested immediately before dialing in to the host. Be sure your account ID is six characters long and that the last two characters are your site ID (01, 02, etc.).

24         ERROR_BAD_LENGTH - file is larger than max file size accepted. This refers to a file created outside the CTRS PC software.

Action: Break up your customer transaction file into two smaller files. (Call MSRB for assistance if necessary).

87         ERROR_INVALID_PARAMETER - file type in header is not "T" or "S" or user ID is not 6 characters or password won't fit into 50 characters (including the string terminator 0). This refers to a file created outside the CTRS PC software.

Action: Change the file as indicated in the message and retransmit.

110         ERROR_OPEN_FAILED - Unable to open file on server.

Action: Call the MSRB.

267         ERROR_DIRECTORY - The submitter/site code does not have a corresponding home directory on the server.

Action: Call the MSRB.

1315         ERROR_INVALID_ACCOUNT_NAME - userid not 6 characters

Action: Recheck the dealer setup information and the ID entered immediately before file transmission. (See message 13 above.)

1392         ERROR_FILE_CORRUPT - MSRBCTRS.ini can't be found or no server names could be extracted.

Action: Exit from the CTRS software environment. Look on your hard disk for a file named MSRBCTRS.INI. If it is not in the same directory as the client software, move it there. If this does not work, call the MSRB.

1722         RPC_S_SERVER_UNAVAILABLE - Host is not responding. You could try to bind again if you want to. It may have timed out.

Action: Wait a few minutes and try again.

OTHER

Action: Call the MSRB if you receive any message not shown above.


ENDNOTES

1. In this manual, Afirm@ refers to any organization involved in customer transaction reporting, whether a broker/dealer, a bank dealer, or a service bureau.

2. Windows 95 and Windows NT are registered trademarks of Microsoft Corporation. MSRB will support operation of the PC TRS software under versions of operating systems that are supported by Microsoft.

3. ACUSIP@ is a trademark of the American Bankers Association.

4. Note: If the security is not known to the MSRB host system as one which is a variable rate instrument or in default, the MSRB may contact the firm reporting the trade to ensure

5. Before transmission, the records are stored in an Access database. They can be viewed and printed only from a CTRS screen or an Access screen while in this database. After transmission, they are copied into a text file which is stored separately from the database.

6. The screen shows all transmitted records that were entered through the Data Entry screen, but not records in external files (files made outside the Data Entry screen).

7. The initial version of the PC software does not support the second format. This format will be added in the next version.

Back to TRS User's Manual
MSRB Home Page

 

©2008 Municipal Securities Rulemaking Board. All Rights Reserved. Terms and Conditions of Use.