CBRS User Guide Cost Basis Reporting Service CBRS User Guide March 2015 1 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide Table of Contents 1 ABOUT THIS USER GUIDE ......................................................................................... 6 2 GENERAL INFORMATION........................................................................................... 7 2.1 SCOPE OF THE SYSTEM: TRANSFER OF INFORMATION ONLY .......................................... 7 2.2 BASIC FUNCTIONALITY: INPUT ..................................................................................... 7 2.2.1 INPUT RECORD CONTENT INDICATOR TYPES .......................................................... 9 2.2.2 ORIGINAL ASSET AND TAX LOT RECORDS FORM A “PACKAGE” ................................ 10 2.2.3 “PACKAGE” RULE APPLIES TO CORRECTED RECORDS TOO ..................................... 10 2.2.4 EXCEPTIONS TO “PACKAGE” RULE: FIRM REJECT AND REQUEST RECORDS ............. 10 2.2.5 ASSOCIATION OF ASSET AND TAX LOT RECORDS .................................................. 10 2.3 BASIC FUNCTIONALITY: OUTPUT ................................................................................ 11 2.3.1 OUTPUT AVAILABLE THROUGH BOTH AUTOMATED CONNECTION AND W EBDIRECT .... 12 3 ELIGIBILITY FOR CBRS ............................................................................................ 13 3.1 USER ELIGIBILITY ..................................................................................................... 13 3.1.1 COST BASIS USER MASTER FILE ......................................................................... 13 3.2 ASSET ELIGIBILITY ................................................................................................... 19 3.2.1 BOTH COVERED AND NONCOVERED SECURITIES ARE ELIGIBLE .............................. 19 4 APPLICATION INPUT AND OUTPUT ........................................................................ 20 4.1 INPUT AND OUTPUT TIMING ....................................................................................... 20 4.2 GENERAL RECORD LAYOUT INFORMATION ................................................................. 20 4.2.1 FILLER FIELDS .................................................................................................... 22 4.3 USING CBRS FOR COST BASIS INFORMATION IN NON-US CURRENCY ........................... 22 4.4 INPUT GENERAL INFORMATION .................................................................................. 22 4.4.1 TRANSFER CONTROL NUMBER ............................................................................ 22 4.4.2 FIRM REJECT RECORD ....................................................................................... 24 4.4.3 FIRM NUMBER AND TYPE VS. CUSTOMER ACCOUNT NUMBER FIELDS ..................... 24 4.4.4 CONTRA FIRM NUMBER ...................................................................................... 26 4.4.5 CONTRA FIRM TYPE ........................................................................................... 26 4.4.6 NUMERIC FIELDS ................................................................................................ 28 4.4.7 ASSET CATEGORY FIELD ..................................................................................... 29 4.4.8 SUM OF THE TAX LOT QUANTITIES MUST MATCH THE ASSET QUANTITY ..................... 29 4.4.9 OPTIONAL FIELDS ............................................................................................... 29 4.4.10 BORROWED POSITION CODE ........................................................................... 29 4.4.11 ACATS ASSET SEQUENCE NUMBER ................................................................ 31 4.5 OUTPUT GENERAL INFORMATION .............................................................................. 31 4.5.1 DISTRIBUTION SIDE ............................................................................................ 32 4.5.2 COST BASIS CONTROL NUMBER .......................................................................... 32 4.5.3 SYSTEM REJECTS .............................................................................................. 32 4.5.4 SYSTEM ACTION FIELD ....................................................................................... 33 4.5.5 SYSTEM REJECT REASON FIELD .......................................................................... 33 4.5.6 STATUS FIELDS.................................................................................................. 34 4.5.7 EXAMPLE OF SYSTEM CHANGED ......................................................................... 34 4.5.8 EXAMPLE OF SYSTEM REJECTED......................................................................... 34 4.5.9 OUTPUT DROPPED RECORDS ............................................................................. 35 2 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 4.5.10 5 LPA NUMBER AND LPA TYPE.......................................................................... 35 BEST PRACTICES ..................................................................................................... 37 5.1 RESOLVE ISSUES WITH THE CONTRA PARTY ................................................................ 37 5.2 FIRMS SHOULD BOTH SUBMIT AND RECEIVE RECORDS.................................................. 37 5.3 WHEN SHOULD A FIRM SEND THE CBRS RECORD? ..................................................... 37 5.4 CORRECTED RECORD .............................................................................................. 37 5.4.1 SOME SCENARIOS ABOUT CORRECTED RECORDS .................................................. 38 5.5 FIRM REJECT AND REQUEST RECORDS ..................................................................... 38 5.6 DO NOT REQUEST BASIS FOR LOTS RECEIVED WITH UNKNOWN BASIS ............................ 40 5.7 SUBMITTING AND RECEIVING NONCOVERED ACCOUNTS AND NONCOVERED SECURITY TYPES .............................................................................................................................. 40 5.8 COVERED FIXED INCOME ASSETS THAT WERE TRANSFERRED IN 2014 ........................... 40 5.9 THE CBRS QUANTITY SHOULD EQUAL THE ORIGINAL ASSET TRANSFER QUANTITY, I.E. AVOID FRACTIONAL SHARES ............................................................................................... 41 5.10 POPULATING CBRS RECORDS FOR ACATS RECLAIM OR FAIL REVERSAL TRANSACTIONS 41 5.11 SENDING A CBRS RECORD FOR AN ASSET HELD IN MULTIPLE CURRENCIES ................... 42 5.12 SENDING COST BASIS FOR AN INVALID CERTIFICATE ..................................................... 42 5.13 FIELD SPECIFIC BEST PRACTICES ............................................................................. 42 5.13.1 TRANSACTION TYPE (A/T) ............................................................................... 43 5.13.2 TRANSFER CONTROL NUMBER (A/T) ................................................................ 43 5.13.3 ALTERNATE CONTROL NUMBER (A/T) .............................................................. 43 5.13.4 ASSET DESCRIPTION (A/T) .............................................................................. 43 5.13.5 ASSET CATEGORY (A) .................................................................................... 44 5.13.6 TRANSFERRING BASIS ON RIGHTS OR WARRANTS .............................................. 44 5.13.7 RECEIVER CUSTOMER ACCOUNT NUMBER (A/T) ............................................... 44 5.13.8 DELIVERER CUSTOMER ACCOUNT NUMBER (A/T) ............................................. 44 5.13.9 TOTAL POSITION QUANTITY/TAX LOT QUANTITY (A/T) ....................................... 44 5.13.10 DATE TRANSFER WAS INITIATED AND SETTLEMENT DATE OF TRANSFER (A) ........ 44 5.13.11 DISPOSITION METHOD USED (A) ...................................................................... 45 5.13.12 SHARES TO COVER SHORT INDICATOR (A) ....................................................... 45 5.13.13 NONCOVERED/PENDING INDICATOR (T) ............................................................ 45 5.13.14 TAXES REPORTED BY ISSUER/TRANSFER AGENT (T) ......................................... 46 5.13.15 GIFTED OR INHERITED INDICATOR (T) ............................................................... 47 5.13.16 FAIR MARKET VALUE AS OF DATE OF GIFT (T) .................................................. 47 5.13.17 POSITION CODE (T) ........................................................................................ 47 5.13.18 POSITION CODE FOR OPTIONS (T) .................................................................... 47 5.13.19 POPULATING ACQUISITION DATE OF TAX LOT FIELD WHEN DATE IS UNKNOWN (T) 47 5.13.20 ORIGINAL ACQUISITION DATE FOR W ASH SALE ADJUSTMENT (T) ....................... 48 5.13.21 WASH SALE ADJUSTMENT AMOUNT (T) ............................................................ 48 5.13.22 EXCHANGE RATE (T) ...................................................................................... 48 5.13.23 TAX LOT ORIGINAL COST (T) ........................................................................... 49 5.13.24 TAX LOT CURRENT COST (T) .......................................................................... 49 5.13.25 ZERO BASIS INDICATOR (T) ............................................................................. 50 5.13.26 TAX LOT ORIGINAL UNIT PRICE (T) .................................................................. 50 5.13.27 EMPLOYEE PLAN SHARES INDICATOR (T) ......................................................... 50 5.13.28 FIELDS FOR FIXED INCOME ELECTIONS (T) ........................................................ 50 3 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 5.13.29 5.13.30 5.13.31 5.13.32 5.13.33 5.13.34 5.13.35 5.13.36 6 FILE INPUT AND OUTPUT VIA COMMON DATA TRANSFER SERVICE (CDTS) ... 58 6.1 6.2 6.3 6.4 6.5 6.6 6.7 6.8 7 PURCHASE/ DIVIDEND REINVESTMENT INDICATOR (T) ....................................... 51 MARKET DISCOUNT (T) ................................................................................... 51 BOND PREMIUM (T) ........................................................................................ 53 ACQUISITION PREMIUM (T) .............................................................................. 54 ACCRUED OID (T) .......................................................................................... 55 LAST ADJUSTMENT DATE (T) ........................................................................... 57 CARRYOVER OFFSET FUTURE USE(T) ............................................................ 57 DISALLOWED CARRYOVER OFFSET (T)............................................................. 57 GENERAL INFORMATION ........................................................................................... 58 FILE INPUT .............................................................................................................. 58 FILE OUTPUT: TRANSACTION MRO ........................................................................... 59 FILE OUTPUT: COST BASIS USER MASTER FILE MRO ................................................ 60 LIMITS ON WHEN OUTPUT FILES AND DATA ARE AVAILABLE............................................ 60 INPUT AND OUTPUT TIMING ....................................................................................... 60 CBRS APPLICATION OUTPUT HEADER ...................................................................... 61 CBRS APPLICATION OUTPUT TRAILER ...................................................................... 61 CBRS AND WEBDIRECT ........................................................................................... 62 7.1 WEBDIRECT W ORKFLOW .......................................................................................... 62 7.2 LOGGING ON TO THE SYSTEM .................................................................................... 62 7.3 CREATING TRANSACTIONS ........................................................................................ 62 7.4 WORKING WITH PENDING TRANSACTIONS .................................................................. 67 7.4.1 ADDING MORE ASSETS TO A TRANSACTION .......................................................... 67 7.4.2 ADDING MORE TAX LOTS TO A TRANSACTION ....................................................... 71 7.4.3 LISTING AND SEARCHING PENDING TRANSACTIONS............................................... 74 7.5 DELETING TRANSACTIONS ........................................................................................ 78 7.5.1 DELETING TRANSACTIONS FROM THE TRANSFER LIST............................................ 78 7.5.2 DELETING TRANSACTIONS FROM THE TRANSFER INFORMATION UPDATE PAGE......... 79 7.6 EDITING TRANSFER INFORMATION, ASSET RECORDS, AND TAX LOT RECORDS ............. 81 7.6.1 VIEWING AND UPDATING TRANSFER INFORMATION ................................................ 81 7.6.2 VIEWING AND UPDATING ASSETS......................................................................... 84 7.6.3 DELETING ASSETS ............................................................................................. 86 7.6.4 VIEWING AND UPDATING TAX LOTS ...................................................................... 92 7.6.5 DELETING TAX LOTS .......................................................................................... 95 7.7 WORKING W ITH BATCHES ...................................................................................... 101 7.7.1 SENDING A BATCH TO DTCC ............................................................................ 101 7.7.2 VIEWING A SENT BATCH ................................................................................... 103 7.8 VERIFYING THAT YOUR FILE W AS SENT SUCCESSFULLY (USING THE CONFIRMS UTILITY) 105 7.9 RESENDING A BATCH ............................................................................................. 107 7.10 UPLOADING RECORDS TO CBRS ............................................................................ 108 7.10.1 OVERVIEW OF THE UPLOAD PROCESS ............................................................ 108 7.10.2 START W ITH THE MOST RECENT SPREADSHEET TEMPLATE ............................. 112 7.10.3 FOR EARLIER VERSIONS OF MS EXCEL ........................................................... 113 7.10.4 SPREADSHEET TEMPLATE COLUMN HEADERS .................................................. 114 7.10.5 THE SPREADSHEET AT A GLANCE .................................................................. 115 4 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 7.10.6 TIPS ............................................................................................................ 117 7.10.7 ADDING AN ASSET W ITH ONE TAX LOT .......................................................... 118 7.10.8 ADDING AN ASSET W ITH MULTIPLE TAX LOTS ................................................. 119 7.10.9 ADDING MULTIPLE ASSET RECORDS .............................................................. 120 7.10.10 ADDING AN ASSET W ITHOUT A TAX LOT (FIRM REJECT AND REQUEST RECORDS ONLY) 122 7.10.11 EXAMPLE SPREADSHEETS ............................................................................. 123 7.10.12 UPLOADING THE SPREADSHEET ..................................................................... 127 7.10.13 DISPLAYING RECORDS UPLOADED VIA SPREADSHEET ..................................... 130 7.10.14 MODIFYING UPLOADED INFORMATION............................................................. 130 7.10.15 VERIFYING THAT YOUR FILE W AS SENT SUCCESSFULLY (USING THE CONFIRMS UTILITY) 131 7.10.16 REVIEWING AND CORRECTING SPREADSHEET ERRORS ................................... 133 7.11 SEARCHING CBRS TRANSACTIONS ......................................................................... 135 7.11.1 QUICK SEARCH ............................................................................................. 136 7.11.2 ADVANCED SEARCH ...................................................................................... 140 7.11.3 DISPLAYING ASSET AND TAX LOT DETAILS ....................................................... 142 7.12 SEARCHING FOR A CBRS USER .............................................................................. 144 SEARCHING FOR AN ACTIVE CBRS ACCOUNT................................................. 144 7.12.1 7.12.2 SEARCHING FOR AN INACTIVE CBRS ACCOUNT .............................................. 146 7.13 DOWNLOADING COST BASIS FILES .......................................................................... 148 7.14 SIZE LIMIT FOR TRANSACTION DOWNLOAD FILES ...................................................... 155 7.15 TIME FRAMES FOR FILES AND DATA AVAILABILITY ..................................................... 156 7.16 WEBDIRECT DATA ENTRY ON WEEKENDS AND HOLIDAYS ............................................ 156 8 JOINING THE SERVICE ........................................................................................... 157 8.1 8.2 9 MULTIPLE OUTPUT FILE SET-UP .............................................................................. 157 CBRS BILLING ...................................................................................................... 157 USER TESTING ........................................................................................................ 159 9.1 TESTING DATA INPUT .............................................................................................. 159 9.2 TESTING DATA OUTPUT ........................................................................................... 160 9.2.1 DETAILS ABOUT TESTING THE DAILY DEPOSIT FILE FOR TRANSFER AGENTS ......... 160 9.2.2 CANNED TRANSACTION OUTPUT FILE .................................................................. 161 10 APPENDIX A: LIST AND DESCRIPTION OF FILE IDENTIFICATION NUMBERS . 162 10.1 CBRS INPUT SYS ID NUMBERS .............................................................................. 162 10.2 LIST OF CBRS OUTPUT FILE IDENTIFICATION NUMBERS ............................................. 162 10.3 DESCRIPTION OF THE CBRS OUTPUT FILES.............................................................. 162 11 APPENDIX B: LIST OF VALID CHARACTERS FOR CBRS ................................... 164 12 DISCLAIMER AND COPYRIGHT NOTICE............................................................... 165 5 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 1 About this User Guide The enhanced Cost Basis Reporting Service (CBRS) mitigates potential endless paper trails, added costs and more operational risk associated with transferring cost basis information manually. The previous version of CBRS allowed financial firms to pass customer cost basis information on assets transferred through DTCC's Automated Customer Account Transfer Service (ACATS). The current service extends its efficiencies and capabilities to equity transfer agents and issuers, mutual funds, custodian banks and broker/dealers to pass cost basis information—from one financial firm to another—for all assets transfers. This User Guide provides details of CBRS and its functionality. Also included in this User Guide are general descriptions of businesses processes and information flow in CBRS. The guide assumes that the user has prior securities industry experience and a basic knowledge of cost basis terminology and processing, and of Microsoft Excel. Changes made since the previous edition are highlighted in red. Version 3.0 4.0 4.1 Date Sept.2013 Sept.2014 March 2015 Author Lydia Midwood Janice DiTore Janice DiTore Notes – Sections edited Source document Additions to Sections 3.1; 4.4; 5.8; 5.13; 7.12;7.13 Sections 3.2.2; 5.8; 5.13.30-36 6 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 2 General Information The Depository Trust & Clearing Corporation (DTCC) initially launched the Cost Basis Reporting Service (CBRS) in 2003 to enable firms to pass cost basis on assets transferred via the Automated Customer Account Transfer Service (ACATS). In October 2008, the United States Congress passed a law requiring firms to not only report cost basis information to investors and the U.S. Internal Revenue Service, but to also pass cost basis information between financial intermediaries when assets move from one firm to another. As a result, DTCC enhanced CBRS to help firms comply with this legislation. DTCC works with a cross functional committee with members from different segments of the industry: broker-dealers, banks, transfer agents, mutual fund companies, and service bureaus to define the system’s functionality and record layouts. Since many different parties are affected by the legislation, DTCC seeks the input of these parties to make sure the system meets their cost basis passage needs. CBRS supports the passage of cost basis in many different types of asset transfers, such as Depository Trust Company (DTC) deliver orders, DTC deposits and withdrawals, and ACATS/FundSERV and Networking transactions, in addition to supporting basis transfers for ACATS transfers as it did in the previous version of the system. System capabilities include enhanced functionality over the internet: firms can perform the same tasks via WebDirect that are available via the computer to computer connection. 2.1 Scope of the System: Transfer of Information Only CBRS supports the transfer of cost basis information from one financial intermediary to another. CBRS does not tell users what transactions trigger the need to pass cost basis, or when to send the basis. CBRS does not provide any reconciliation capabilities between expected and received records. Also, CBRS does not calculate cost basis. 2.2 Basic Functionality: Input CBRS has two input record types: Asset records and Tax Lot records. A firm submits an Asset record for each asset for which it needs to pass cost basis information. The Asset record must have at least one, but can have many, associated Tax Lot records. Tax Lot records contain detailed cost basis information for each Asset record. CBRS receives the cost basis records from a computer to computer automated connection or through data input via the internet-based DTCC WebDirect. For the most part, the record types correspond to the deliverer and receiver of the security in the transaction that triggered the need to pass cost basis. The deliverer of the security submits an Original or Corrected record, and the receiver of the security submits a Firm Reject or a Request record, as needed. The one exception is the transfer of a short position (See Figure 2 for information flow on the transfer of a short position). 7 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide Figure 1 illustrates how cost basis information flows through CBRS when the original transfer was the transfer of a long position. Figure 1. How information flows on the passage of cost basis on the transfer of a long position. 8 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide When a short position moves from one firm to another, the deliverer of the short position is the receiver of the security, and the receiver of the short position is the deliverer of the security. Also, the deliverer of the short position passes the cost basis to the receiver of the short position. Figure 2 illustrates the information flow of the transfer of cost basis for a short position. Figure 2. How information flows on the passage of cost basis on the transfer of a short position. 2.2.1 Input Record Content Indicator Types CBRS input records have four different types: original, corrected, firm reject, and request. The Asset record includes all four types, and the Tax Lot record has only original and corrected record types. • • • Original asset record/Original tax lot record: the primary record used to transfer the cost basis information. Corrected asset record/Corrected tax lot record: a submitter can use the corrected record type to tell the receiver the cost basis information has changed since the original record was sent. Firm reject record (Asset level only): the receiver of the cost basis can use this type of record to let the submitter of the cost basis know that there is a problem with the information. The firm reject record is different from a system reject—a system reject occurs when some of the submitted information is rejected by the CBRS software. For example, if the submitter populates one of the date fields with 01/35/2012, CBRS will reject the record because a date of January 35, 2012 is not possible. 9 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide • Request record (Asset level only): the asset receiver can use this type of record to request cost basis from the asset deliverer. The table below summarizes the relationship between the asset deliverer and receiver for a long position and the CBRS record submitter and receiver. Record content type Original Corrected Firm reject Request Record submitter Asset deliverer Asset deliverer Asset receiver Asset receiver Record receiver Asset receiver Asset receiver Asset deliverer Asset deliverer 2.2.2 Original Asset and Tax Lot records form a “package” The Asset record and its corresponding Tax Lot record(s) are a package. The Original and Corrected Asset data in the input file must consist of the Asset record followed by at least one Tax Lot record. CBRS rejects back to the submitter any Asset record not followed by a Tax Lot record(s). Tax Lot records that do not follow an Asset record are assigned a separate Cost Basis Control Number and rejected by the system. The sum of the tax lot quantities must equal the quantity of the asset record, or CBRS rejects the package. 2.2.3 “Package” rule applies to Corrected records too A submitter must send all the tax lots for a corrected record, even if only one tax lot is corrected. For original and corrected records, the submitter must always send an asset record with all its corresponding tax lot records. CBRS looks at the asset and tax lot records as a package. If the package is not intact, CBRS rejects it. 2.2.4 Exceptions to “Package” rule: Firm Reject and Request records The Firm Reject and Request record content types exist only at the asset level, not the tax lot level. For these two record content types, there are no corresponding tax lot records. 2.2.5 Association of Asset and Tax Lot Records For all types of assets except options (Asset Category = OPT) and for all Transaction Types except 41 = Direct Presentation, CBRS establishes the association between the Asset and the Tax Lot record when the contents of these fields on the two records are equal: • • • • • • • Transfer Control Number Contra Firm Number Contra Firm Type Submitting Firm Number Submitting Firm Type Receiver Customer Account Number Deliverer Customer Account Number 10 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide • • • ISIN Country Code ISIN Security Issue ID ISIN Security Check Digit For option assets, CBRS establishes the association between the Asset and the Tax Lot record when the contents of these fields on the two records are equal: • • • • • • • • • • • • Transfer Control Number Contra Firm Number Contra Firm Type Submitting Firm Number Submitting Firm Type Receiver Customer Account Number Deliverer Customer Account Number Put/Call Indicator Option Symbol Option Expiration Date Option Strike Price Integer Option Strike Price Decimal For Transaction Type 41 = Direct Presentation when the asset is not an option, CBRS establishes the association between the Asset and the Tax Lot record when the contents of these fields on the two records are equal: • • • • • • • • • • 2.3 Transfer Control Number Contra Firm Number Contra Firm Type Submitting Firm Number Submitting Firm Type Receiver Customer Account Number Deliverer Customer Account Number ISIN Country Code ISIN Security Issue ID ISIN Security Check Digit, unless ISIN Security Issue ID is blank. In this case, CBRS uses the Asset Description instead of the ISIN Country Code, ISIN Security Issue ID, and ISIN Security Check Digit to associate the Asset and Tax Lot record. Basic Functionality: Output CBRS edits the input data, runs an end-of-day batch process to validate and produce output files, and returns the validated data to the appropriate firms. Below are the steps CBRS takes to produce its output: 1. Four times a day, CBRS collects all of the input files available at that time and runs a preliminary data edit process. During this cycle processing the system performs the following tasks: 11 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide a. b. c. d. Assigns a unique Cost Basis Control Number to each asset and its tax lots Validates that the contra firm is a valid CBRS user Validates that the submitting firm is a valid CBRS user Performs other basic validation of the input fields, such as editing of the input record length, and verifying that each field value contains valid and printable characters e. Based on this validation, the system may preliminarily accept the records, reject them, or drop them 2. After 4:00 PM, CBRS runs an end-of-day batch process. At this time the system performs an in-depth edit of cost basis data received today by applying all established validation rules. 3. CBRS sends accepted cost basis records to the submitting and contra firm. 4. CBRS sends rejected cost basis records to the submitting firm only. 2.3.1 Output available through both automated connection and WebDirect Output files are available through both the automated computer-to-computer connection and/or via WebDirect. Regardless of how a submitter enters data into the system, the entire receiver’s data is in one file that is available for retrieval via either of the methods. • Please note that the data is not automatically available through both methods: users must subscribe to either. 12 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 3 Eligibility for CBRS 3.1 User Eligibility Each user that participates in CBRS is assigned a CBRS Account Number. DTCC will link existing DTC, NSCC or transfer agent numbers to the CBRS account number. CBRS data submitted by or to an ineligible user is rejected. All financial intermediaries subject to the new IRS regulations are eligible to apply to use CBRS, including users who are not currently members of any service offered by one of DTCC’s affiliate companies. 3.1.1 Cost Basis User Master File To assist firms in identifying eligible users, the Cost Basis User Master File is available on a daily basis by 11 PM eastern time. This file lists eligible CBRS counterparties: by referring to this file before submitting a record, CBRS users can significantly reduce the number system rejects caused by cost basis records sent to ineligible counterparties. The record layout for the Cost Basis User Master File is located on the DTCC Learning website at: https://dtcclearning.com/learning/clearance/topics/cbrs/documentation.html The Machine Readable Output (MRO) file is a flat file. The WebDirect download file is a *.csv file. The Cost Basis User Master File has a CDTS header. It does not have a CBRS application header or CBRS application trailer. Record Layout fields The record layout for the Cost Basis User Master File has the following fields (please see the section below titled “Active/Inactive functionality” for a further explanation of how the various fields in the User Master File should be used): • • • CBRS User Account Number: Each user who signs up for CBRS is assigned a CBRS User Account Number. However, in most cases this is not the primary number that identifies a firm. The Active Firm Number, which corresponds to a firm’s DTC Participant Number, NSCC Participant Number, or Transfer Agent Number, is the number to use in the Receiving and Submitting Firm Number fields in CBRS data input and output. The only time the CBRS User Account Number is the primary identification number of a firm is when that firm is not a DTC Participant, nor an NSCC Participant, nor a Transfer Agent. CBRS Account Name: this field contains the name of the user. Active Firm Number: the number of the CBRS user who is the active user of the system (the user’s DTC, NSCC, or Transfer Agent (TA) number; or CBRS account number if the user does not have a DTC, NSCC, or TA number) This is the primary number that identifies 13 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide • • • • • • the Receiving and Submitting Firms in CBRS data input and output (See the Receiving and Submitting Firm Numbers section below for more information). The Cost Basis Steering Committee, that advises DTCC on the design on the system, recommended that firms be able to use their existing DTC Participant, NSCC Participant, or Transfer Agent Numbers when processing data in CBRS. This number varies based on Active Firm Type: o When Active Firm Type is NSCPRT, this number is the NSCC Participant Number o When Active Firm Type is DTCPRT, this number is the DTC Participant Number o When Active Firm Type is AGTNBR, this number is the Transfer Agent Number o When Active Firm Type is CBRACT, this number is the CBRS User Account Number Active Firm Type: the type that corresponds to the Active Firm Number. Because there is some overlap between NSCC Participant Numbers, DTC Participant Numbers, and Transfer Agent Numbers, this file includes an Active Firm Type so the system can determine the type of number populated in the Active Firm Number field. Values: o AGTNBR = Transfer Agent o DTCPRT = DTC Participant o NSCPRT = NSCC Participant o CBRACT = CBRS-only user CBRS Account Start Date: the date the firm is eligible to participate in CBRS in the production environment. Exempt Recipient Accounts Indicator with two values: Y/N. This field allows CBRS users to indicate whether they want retirement accounts excluded from the basis they receive. The field values mean the following: o Y: Exclude retirement accounts from basis sent to this user o N: Do not exclude retirement accounts from basis sent to this user. ‘N’ is the default value for this field. Search Firm Number: the number of the CBRS user associated with the Active Firm Number. In most cases, this number is the same as the Active Firm Number. In the instances when an active CBRS user has assumed cost basis responsibility for a CBRS user who has become inactive, this number is the number of the inactive Firm (the inactive user’s DTC, NSCC, or Transfer Agent (TA) number; or CBRS account number if the user does not have a DTC, NSCC, or TA number). Search Firm Type is the type that corresponds to the Search Firm Number. Values: o AGTNBR = Transfer Agent o DTCPRT = DTC Participant o NSCPRT = NSCC Participant o CBRACT = CBRS-only user o DTCOCC = DTC Participant who is also an OCC Member o DTCFED = DTC Participant who is also a FED Member In the instances when an active CBRS user has assumed cost basis responsibility for another CBRS user who has become inactive, this type is the type of the inactive Firm. Active/Inactive Indicator: indicates whether the record corresponds to an active or inactive CBRS user. o If the user is active, a CBRS user can populate the Contra Firm Number and Contra Firm Type fields with either the Active Firm Number and Active Firm Type or the Search Firm Number and Search Firm Type. 14 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide o If the user is inactive, a CBRS user must populate the Contra Firm Number and Contra Firm Type fields with the Active Firm Number and Active Firm Type. CBRS system rejects records sent to the Search Firm Number and Search Firm Type in this scenario. Active/Inactive functionality The CBRS User Master File’s active/inactive functionality helps to reduce the manual processing that occurs when a user becomes ineligible for CBRS when its CBRS account closes as the result of events such as a merger or bankruptcy. When a user becomes ineligible for CBRS and another user assumes the ineligible user’s accounts, the active/inactive functionality allows an active CBRS user to indicate that it should receive CBRS records on behalf of an inactive user. This functionality works in the case where one user assumes responsibility for all of another user’s accounts: it does not work in the case where one user’s business goes to two or more other users. A CBRS user can use the Search Firm Number/Type combination as the first place to look for the number of a CBRS contra party. Once a user locates the contra party’s number, that user looks to the Active/Inactive indicator. If the contra party is active, a user can send the CBRS record either to the Search Firm Number and Type combination, or to the Active Firm Number/Type combination. If the contra party is inactive, the user must send the CBRS record to the Active Firm Number/Type. For an active CBRS user, the value in the CBRS Account Effective Date field corresponds to the date the account becomes eligible for processing in the production environment. For an inactive CBRS user, the value in the CBRS Account Effective Date field corresponds to the first date that the inactive record is valid. Examples For example, Firm A goes out of business, and Firm B assumes all of Firm A’s accounts. Because Firm A has gone out of business, it is removed from the CBRS User Master File. Once this new functionality is in place, Firm A can become an “Inactive” record, and Firm B is the associated “Active” record. For each inactive record, a contra party should send CBRS records to the active user. The following examples illustrate the different scenarios that can occur in the new version of the Master File. In these examples, as for all CBRS users, type AGTNBR = Transfer Agent (TA), type DTCPRT = DTC participant, type NSCPRT = NSCC participant, and type CBRACT indicates a CBRS user who does not have a DTC, NSCCPRT, or TA number (i.e. a “CBRS-only user”). 15 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide CBRS User Account Number 000ZZZZ1 000ZZZZ2 000ZZZZ3 000ZZZZ4 000ZZZZ4 000ZZZZ5 000ZZZZ5 000ZZZZ6 000ZZZZ6 000ZZZZ7 000ZZZZ7 000ZZZZ8 000ZZZZ8 000ZZZZ9 000ZZZZ9 000ZZZZ9 CBRS Account Name Example 1 Example 2 Example 3 Example 4 Example 4 Example 5 Example 5 Example 6 Example 6 Example 7 Example 7 Example 8 Example 8 Example 9 Example 9 Example 9 Active Firm Number AAA BBBB CCCCC DDDD DDDD FFFF FFFF ZZZZ6 ZZZZ6 ZZZZ7 ZZZZ7 HHHHH HHHHH LLL LLL LLL Active Firm Type DTCPRT NSCPRT AGTNBR DTCPRT DTCPRT NSCPRT NSCPRT CBRACT CBRACT CBRACT CBRACT AGTNBR AGTNBR NSCPRT NSCPRT NSCPRT CBRS Account Effective Date 1/1/2011 1/2/2011 1/3/2011 1/4/2011 8/1/2012 1/5/2011 8/5/2012 1/6/2011 8/6/2012 1/7/2011 8/7/2012 1/8/2011 8/8/2012 1/9/2011 8/9/2012 8/10/2012 Exempt Search Search Recipient Firm Firm Accounts Number Type N AAA DTCPRT Y BBBB NSCPRT N CCCCC AGTNBR N DDDD DTCPRT N EEE DTCPRT Y FFFF NSCPRT Y YYYY1 CBRACT N ZZZZ6 CBRACT N XXXX2 CBRACT N ZZZZ7 CBRACT N GGG NSCPRT N HHHHH AGTNBR N JJJ AGTNBR N LLL NSCPRT N MMM NSCPRT N NNN NSCPRT Active/ Inactive A A A A I A I A I A I A I A I I Examples 1 - 3 are CBRS users who do not have a relationship with an inactive Firm Number. They are Active records only with no corresponding inactive records. The expectation is that most CBRS users will only have Active records. Example 4 is a CBRS user who is a DTC participant, DDDD, who has assumed the cost basis responsibility for a retired CBRS user who is a DTC participant, number EEE. DDDD is the active user, and ‘EEE’ is the inactive user. All CBRS records intended for EEE should be sent to DDDD. Example 5 is a CBRS user who is an NSCC participant, FFFF, who has assumed the cost basis responsibility for a retired user who is a CBRS-only user, YYYY1. FFFF is the active user, and YYYY1 is the inactive user. All CBRS records intended for YYYY1 should be sent to FFFF. Example 6 is a CBRS-only user, ZZZZ6, who has assumed the cost basis responsibility for a retired user who is a CBRS-only user, XXXX2. ZZZZ6 is the active user, and XXXX2 is the inactive user. All CBRS records intended for XXXX2 should be sent to ZZZZ6. Example 7 is a CBRS-only user, ZZZZ7, who has assumed the cost basis responsibility for a retired user who is a NSCC participant, GGG. ZZZZ7 is the active user, and GGG is the inactive user. All CBRS records intended for GGG should be sent to ZZZZ7. Example 8 is a CBRS user who is a Transfer Agent, HHHHH, who has assumed the cost basis responsibility for a retired user who is a Transfer Agent, JJJ. HHHHH is the active user, and JJJ is the inactive user. All CBRS records intended for JJJ should be sent to HHHHH. 16 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide Example 9 is a CBRS user who is an NSCC Participant, LLL, who has assumed the cost basis responsibility for two NSCC participants—MMM and NNN. LLL is the active user, and MMM and NNN are the inactive users. All CBRS records intended for MMM or NNN should be sent to LLL. To set up an inactive record: The user who is the active member must instruct DTCC to set up a new inactive record (a.k.a. Alternative Account). The active user must submit the DTCC Alternative Account Instruction using the template provided on the DTCC.com website. By default, an inactive record expires 18 months after it is set up, unless the member specifies an end date . In its instructions to DTCC, an active user can request the inactive record to remain on the Master File for a longer amount of time, if necessary. Note: The Account Numbers on the User Master File output have leading zeroes. ? If a fund has a ‘Y’ in the Exempt Recipient Accounts Indicator (meaning the fund does not want to receive basis for retirement accounts), but a firm sends a record with basis for a retirement account to the fund, does CBRS pass system reject the record back to the firm? CBRS does not reject a record in this scenario. CBRS does not have any system edits based on the Exempt Recipient Accounts Indicator. In the case described in this question, CBRS passes the record to the fund. ? If I send a CBRS record to an inactive user, what will happen? CBRS system rejects a record sent to a user designated as Inactive on the CBRS User Master File. What System Reject Reason does CBRS use in this case? On the Transaction Machine Readable Output (MRO), CBRS populates the System Reject Reason field with the value 01 = Invalid Field, and populates the AO Contra Firm Number Status field with the value 2 = Error. The combination of these values indicates that the submitter has populated a field with an invalid value, and the status field indicates which field contains the invalid value (in this case, the Contra Firm Number on the Asset record). ? Is it possible for a CBRS only user to be the active user for an inactive NSCC, DTC, or TA number? The CBRS User Master File has been designed to allow an active CBRS only user (type CBRACT) to have corresponding inactive records that are NSCC participants, DTC participants, or Transfer Agents (types NSCPRT, DTCPRT, and AGTNBR, respectively). Please note that the type CBRACT is a receiver on a limited number of Transaction Types, so a CBRS only user may not be able to receive a record sent to it on behalf of the inactive DTC, NSCC, or TA number. ? I only know the OCC number of my contra. How do I find the CBRS active user number? The CBRS User Master File has been designed to allow an active CBRS user to have corresponding inactive record user identifiers for their OCC account numbers. Use the Search Firm Type DTCOCC to find the active CBRS user number. 17 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide ? I only know the FED number and short name combination of my contra. How do I find the CBRS active user number? The CBRS User Master File has been designed to allow an active CBRS user to have corresponding inactive record user identifiers for their FED account number and associated short names. Use the Search Firm Type: DTCFED to find the active CBRS user number. ? I’m looking for a CBRS user who was on the CBRS User Master File last week, but is not there today. What happened? How can I send cost basis to this user? If a user is no longer on the CBRS User Master File, it has become ineligible to send and receive records via CBRS. A variety of things could have happened; maybe the firm went out of business, or merged with another firm. If the contra firm or fund is not on the CBRS User Master File, you cannot send CBRS records to them: you need to send cost basis through an alternate, manual method. Receiving and Submitting Firm Numbers If a firm has a DTC Participant Number, NSCC Participant Number, or a Transfer Agent Number, that number is the number to use in the Submitting or Contra Firm Number field in CBRS. If a firm has none of the numbers above, the CBRS User Account Number is the number to use in the Submitting or Contra Firm Number field. Each firm that participates in CBRS is assigned a CBRS User Account Number. As mentioned above, for most users the CBRS User Account Number is not the primary number used to identify the firm in CBRS data input and output. As applicable, the CBRS User Account Number is related to an existing DTC Participant Number, NSCC Participant Number, or Transfer Agent Number based on the logic below. This relationship allows users to identify themselves and other firms using numbers with which they are already familiar. The Contra and Submitting Firm Number must follow the following logic: • A user who is a DTC Participant uses its DTC Participant Number • A user who is an NSCC Participant uses its NSCC Participant Number • A user who is both a DTC Participant and NSCC Participant uses its DTC Participant Number • An equity transfer agent/issuer who has a Transfer Agent Number uses this number • All other firms use their CBRS User Account Number While the CBRS User Account Number will not often be the number used to identify the firm as a submitter and receiver of CBRS records, users are advised to make a note of their CBRS User Account Number for use in communicating with DTCC about system and billing inquiries. ? If a user has a DTC number or Transfer Agent number, can I send records to it using its CBRS number? No. For users who have DTC or Transfer Agent (TA) numbers, you must send basis to the DTC or TA number and the appropriate firm type. 18 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide ? Some transfer agents (TAs) have multiple TA numbers. If I am sending a CBRS record to a TA, does the TA number have to be the specific TA number assigned to that ISIN Security Issue ID (CUSIP)? No. For CBRS records to or from a transfer agent, CBRS does not check that the Submitting or Contra Firm Number is the correct TA number for the CUSIP on the record. While CBRS does not perform an edit between the TA number and the CUSIP number, it does on some occasions populate the TA number in the Contra Firm Number field based on the CUSIP. For Original and Corrected records where a TA is the receiver (Transaction Types 36 = DWAC Withdrawal and 37 = Withdrawal by Transfer (WT)), and Firm Reject and Request records where a TA is the receiver (Transaction Types 26 = DWAC Deposit, 27 = Certificate Deposit, and 28 = DRS Profile/DO), CBRS automatically populates the Contra Firm Number field with the number for the transfer agent who corresponds to the ISIN Security Issue ID (CUSIP) number on the record. If this transfer agent number is eligible for CBRS, CBRS passes the record to the agent (assuming the record passes all other system rules and edits). If the transfer agent number is not eligible for CBRS, CBRS populates the number on the output back to the submitting broker-dealer, so the broker knows where to send the cost basis using some other method. ? I work at a broker-dealer, and have had some rejects in CBRS records that I’ve sent to a transfer agent (TA) who I know is eligible for CBRS. Why are these rejects happening? Some TAs have multiple TA numbers. There are some cases where not all TA numbers for a given TA are eligible for CBRS. For Example, a TA has three numbers: 12345, 23456, and 34567. The TA has made numbers 12345 and 23456 eligible for CBRS, but not 34567. A broker-dealer sends a request record for cost basis on a deposit on CUSIP 123456789. The broker-dealer populates the ISIN Security Issue ID (CUSIP) field with 123456789, which happens to correspond to TA number 34567. CBRS automatically populates the Contra Firm Number field with TA number 34567, and then rejects the record because 34567 is not eligible for CBRS—even though the same TA has two other numbers that are CBRS eligible. Best Practices suggest that TAs should make all their TA numbers eligible for CBRS, to prevent this system reject. 3.2 Asset Eligibility All assets are eligible for the submission of cost basis information. 3.2.1 Both Covered and Noncovered Securities are Eligible CBRS supports the passage of cost basis on both covered and noncovered securities. The Tax Lot Input record includes a Noncovered/Pending Indicator field that the submitter can use to indicate that a lot is noncovered. If the Noncovered/Pending Indicator is left blank, the lot is considered covered. 19 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 4 Application Input and Output 4.1 • • Input and Output timing Input: for today’s processing date, firms can submit CBRS records between 8 PM ET yesterday (the previous processing day) and 4 PM ET today. o Files submitted between 8 PM ET yesterday and 4 PM ET today should have today’s date in the header o Files with today’s header date, submitted between 4 PM and 8 PM today, are processed with tomorrow’s processing date o Files with tomorrow’s header date, submitted between 4 PM and 8 PM today, are rejected by CDTS Output: for today’s processing date, CBRS transaction output and the Daily Deposit File for Transfer Agents is available by 9 PM ET today. The Cost Basis User Master File is available by 11 PM ET today This schedule applies to input and output through both the automated computer to computer connection, and via WebDirect 4.2 General Record Layout Information The CBRS record layouts, both input and output, can be found on the CBRS documentation section of DTCC Learning website: https://dtcclearning.com/learning/clearance/topics/cbrs/documentation.html The column headings for the record layouts are: Column Name Field Name Length Start End Type Opt/Req/Cond Comments Definition The name of the field The length of the field, in bytes The position where the field starts The position where the field ends The type of the field: A/N = Alphanumeric NUM = Numeric Indicator that specifies whether the field is optional, required, or conditionally required: OPT = optional field REQ = required field COND = conditionally required, depending upon values in other fields A brief field description, possibly including format, valid values, conditional requirements, general use rules, and/or best practices Notes on the record layouts: 20 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 1. All input fields must contain printable and allowed characters; otherwise CBRS will overlay the input with asterisks, ‘*’, and reject the record. The CBRS printable and allowed characters are all lower/upper case letters and numbers, and certain symbols. 2. Alphanumeric fields may contain any character in the EBCDIC computer character set except for unprintable characters such as Low-Value, High-Value, COMP-3 fields, etc. See Appendix B for the list of valid characters for CBRS. 3. Numeric fields may include digits (0-9) only. 4. When a field is required: a. If a list of values is provided, the field must contain a value from that list b. An alphanumeric field without a specified list of possible values may have any alphanumeric value, except spaces c. A numeric field without a specified list of possible values may contain any digit except zero (0) 5. When a field is optional: a. An alphanumeric field with a specific list of possible values must have one of those values or blank b. An alphanumeric without a specific list of possible values may have any value including spaces c. A numeric field without a specific list of possible values may contain numeric digits (0-9) or spaces 6. All dates in the layouts have the format CCYYMMDD (except where otherwise indicated), where: a. CC = Century b. YY = Year c. MM = Month d. DD = Day For example, December 31, 2011 is 20111231 in CBRS format. The Quantity fields support up to four decimal places. Decimals greater than four places in the quantity fields are truncated. Please note that the position of the decimal point can float. The record layouts state: "Position of decimal denoted by a ',' (comma). Up to four decimal places will be supported before truncation occurs." The following list shows examples of how the share quantity fields can look on the CBRS output file: • • • • 000000000001234,5 00000000001234,56 0000000001234,567 000000001234,5678 The Cost fields support up to two decimal places. Decimals greater than two places in the cost fields are truncated. 21 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 4.2.1 Filler fields Filler fields are required because the filler tells the system the position of the fields in the record. Also, when fields are marked as “optional,” this means that the value in the field is optional, but the submitter is required to provide spaces in place of the value to keep the position of the other fields in the correct place. The filler at the end of the record is required as well: the filler at the end of the record layout extends the length of the record to the required 1,000 bytes. A submitted record that is more or less than 1,000 bytes in length will be system rejected. ? When DTCC removes a field from the CBRS record layouts and turn it into filler, what happens if a submitter populates this field? Once a field has been removed from the record layouts, and turned into a filler field, the CBRS application does not look at this field. The data populated in this field by the submitter is not included in the CBRS output. DTCC recommends that the submitter space out these bytes: a submitter who does not space out these bytes may encounter a problem in the future if the bytes are reused for a different field. 4.3 Using CBRS for cost basis information in non-US Currency All cost fields in CBRS are denominated in US Dollars only. However, on the Tax Lot level, there are two fields—ISO Currency Code and Exchange Rate—that allow a submitter to tell the receiver that the submitter held the cost basis on its system in a different currency, and converted the cost basis to US Dollars to transfer it. When transferring basis for a lot purchased in a foreign currency, please note the following: • For lots whose acquisition date has been adjusted as the result of a wash sale, the exchange rate should be the rate as of the date in the “Original Acquisition Date for Wash Sale Adjustment” field. • The exchange rate is the rate that the delivering firm captured on the date the security was purchased. The currency that the trade settled in is the currency that the cost basis should be recorded in. • The deliverer provides the exchange rate so that the receiver can calculate the gain/loss in the currency separately from the gain/loss in the security. 4.4 Input General Information 4.4.1 Transfer Control Number Users must enter a Transfer Control Number for each CBRS transaction submitted to the system. This Transfer Control Number should be the same as the control number used to identify the asset transfer that triggered the need to pass cost basis. All cost basis output includes this Transfer Control Number for reference. CBRS rejects any cost basis record that does not have a Transfer Control Number. 22 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide In the Asset Input and Tax Lot Input records, the value in the Transfer Control Number field should be left justified. ? If the transfer control number has less than 30 bytes, does the submitter have to follow the transfer control number with spaces or zeros? CBRS accepts either one. ? For some CBRS transaction types, I should use the IMS TID number as the Transfer Control Number. I know this number is available on the DTFPART file, but is there a way to manually look up the IMS TID number? You can look up a DTC transaction’s IMS TID number through the ART function in PBS. Begin by selecting a transaction. After you click on the transaction, you see the screen below. The IMS TID is located at the bottom of the ‘Activity Details’ section of the screen. The IMS TID is not available in PTS. ? For Transaction Type 01 = ACATS, the Transfer Control Number should be populated with the 14-byte ACATS control number from the original transfer. However, the ACATS Control Number that we receive in positions 683-702 on the Fund/SERV 018 record (an ACATS Transfer) is 20 bytes. Should I truncate the field down to 14 bytes? How do I know what the ACATS Control Number is? The first fourteen bytes of the ACATS Control Number on the Fund/SERV record are the ACATS Control Number. The last six bytes are the ACATS Asset Sequence Number (which is used to identify that particular mutual fund asset in the ACATS transfer). Notes about populating the Transfer Control Number for Transfer Agent Transactions: • For deposit Transaction Type 27 = Certificate Deposit, a Transfer Agent can choose to receive the CBRS Daily Deposit File. The Transfer Control Number is the Reference ID, ARF, or CID number that was submitted on the original deposit. 23 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide • • • For deposit Transaction Type 26 = DWAC Deposit, use the 26 byte Reference ID that you see on CDWC as the CBRS Transfer Control Number. For Transaction Type 37 = Withdrawal by Transfer (WT), use the first 30 bytes of the 37 byte reference number on the RSATFX file (for FAST) or on the upper right had corner of the Transfer Assignment Control Form (TACF) (for non-FAST). For Transaction Type 28 = DRS Profile/DO, use the first 30 characters of the customer account number received via the DRSPRO file. 4.4.2 Firm Reject Record A firm sends a “firm reject” record when, for various reasons, the firm cannot apply the received cost basis to its books. This situation is different from a “system reject.” A system reject occurs when the CBRS system rejects a record because it does not comply with the system’s rules, such as when a date field has a value of 1/35/2012, which is not a valid calendar date. Information flow for a “firm reject” record: 1. A user receives a CBRS record that it cannot apply to its books. 2. This user submits an asset record, with the value 03 = Firm reject record in the Record Content Indicator field. At this point the receiver of the firm reject record decides whether to respond. CBRS does not require a response to a firm reject. If the receiver of the reject chooses to respond, the information flow continues with step 3. 3. To correct the error, the receiver of the reject responds with an asset record with the value 02 = Corrected asset record in the Record Content Indicator field, and its corresponding tax lots. At least one of these tax lots must also be corrected (value 02 = Corrected tax lot record in the Record Content Indicator field). 4.4.3 Firm Number and Type vs. Customer Account Number fields The Submitting Firm Number and Submitting Firm Type should always correspond to the user sending the CBRS record. The Receiving Firm Number and Receiving Firm Type should always correspond to the user receiving the CBRS record. The Deliverer Customer Account Number should always correspond to the user who delivered the asset transfer, and the Receiver Customer Account Number should always correspond to the user who received the asset transfer. Another way to think of it is the Deliverer Customer Account Number corresponds to the user who is delivering the cost basis, and the Receiver Customer Account Number corresponds to the user who is receiving the cost basis. Note for the transfer of a short position: the Deliverer Customer Account Number is the account from which the short position is being transferred. The Receiver Customer Account Number is the account that is adding the short position to its books and is thus receiving the Proceeds as required by the regulations. Therefore, in this context, the fields 24 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide ‘deliverer’ and ‘receiver’ account numbers correspond to the account delivering and receiving the short position, not the account delivering or receiving the long shares. Examples This example shows how an original record is sent after the transfer of a long position. Scenario: customer’s long position is transferred from Firm A to Firm B. 1. Firm A delivers shares to Firm B. 2. Firm B establishes the customer’s long position on its books. 3. Firm A sends cost basis to firm B (Original asset and tax lot(s) records). This example shows how a request record, followed by an original record, are sent after the transfer of a short position. Scenario: customer’s short position is transferred from Firm A to Firm B. 1. Firm B delivers shares to Firm A. 2. Firm B establishes the customer’s short position on its books. 3. Firm A accepts the shares. 4. Firm B sends Firm A a borrow Request record (a Request asset record with the value of B = Borrowed in the Position Code field). 5. In response to the borrow request record, Firm A should send the proceeds to Firm B (Original asset and tax lot(s) records). There are four types of records that may be sent through CBRS. The following describes how each should be used: • Original record – used to initially send cost basis to the contra-firm • Corrected record – used to send corrected basis when previously sent basis is deemed to be incorrect • Firm Reject record – used in cases where the contra-firm receives basis for which it cannot match to a received asset • Request record – used to request basis if it was not received on an asset transfer within 15 days or as a borrow request for long shares delivered to cover the transfer of a short position The table below shows how these fields should be filled out for each record type. This table applies to both long and short positions. Record Type Submitting Submitting Contra Firm Firm Type Firm Number Number Contra Firm Type Original Corrected Firm Reject Request Firm A Firm A Firm B Firm B Firm B Firm B Firm A Firm A Firm A Firm A Firm B Firm B Firm B Firm B Firm A Firm A Deliverer Customer Account Number Firm A Firm A Firm A Firm A Receiver Customer Account Number Firm B Firm B Firm B Firm B 25 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 4.4.4 Contra Firm Number For Original and Corrected records where an Issuer/Equity Transfer Agent (TA) is the receiver (Transaction Types 36 = DWAC Withdrawal and 37 = Withdrawal by Transfer (WT)), and Firm Reject and Request records where a TA is the receiver (Transaction Types 26 = DWAC Deposit, 27 = Certificate Deposit, and 28 = DRS Profile/DO), CBRS automatically populates the Contra Firm Number field with the number for the transfer agent who corresponds to the ISIN Security Issue ID (CUSIP) number on the record. If this transfer agent number is eligible for CBRS, CBRS passes the record to the agent (assuming the record passes all other system rules and edits). If the transfer agent number is not eligible for CBRS, CBRS populates the number on the output back to the submitting broker-dealer, so the broker knows where to send the cost basis using some other method. ? If a broker-dealer has received a deposit from a transfer agent, does CBRS automatically solicit the cost basis information from the transfer agent? No, CBRS does not automatically solicit the cost basis information. Instead, when the broker-dealer sends the transfer agent a request asset record for the cost basis on the deposit, CBRS follows the process described above. 4.4.5 Contra Firm Type CBRS needs the Submitting and Contra Firm Type fields because of the occasional overlap between DTC, NSCC, and Transfer Agent numbers. In order for firms to use their existing participant numbers, and not a CBRS Account Number, as an identifier in CBRS input and output records, the CBRS application needs the Firm Type to be able to properly identify the submitting and contra users where an overlap exists. Please see the tables below to clarify the relationship between the Contra Firm Type and the various Transaction Types (these rules are in the input record layouts). For the Original and Corrected Records If the Transaction Type is: 01 = ACATS 02 = Free DTC Deliver Order (non-ACATS) 03 = Valued DTC Deliver Order 04 = Conversion 05 = Mutual Fund Transfer (non-ACATS) [change of broker-dealer] 06 = FED 07 = Physical Movement Settlement 08 = OCC Transfer (non-ACATS) 09 = Non-Domestic Depository (Foreign) 10 = Other 26 = DWAC Deposit 27 = Certificate Deposit 28 = DRS Profile/DO 36 = DWAC Withdrawal Contra Firm Type must be: DTCPRT; NSCPRT DTCPRT DTCPRT DTCPRT; NSCPRT; CBRACT DTCPRT; NSCPRT; CBRACT DTCPRT; NSCPRT; CBRACT DTCPRT; NSCPRT; CBRACT DTCPRT; NSCPRT; CBRACT DTCPRT; NSCPRT; CBRACT DTCPRT; NSCPRT; CBRACT DTCPRT DTCPRT DTCPRT AGTNBR 26 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 37 = Withdrawal by Transfer (WT) 41 = Direct Presentation 46 = Fund to Firm Mutual Fund Transfer 51 = Firm to Fund Mutual Fund Transfer 56 = Networking Transaction 57 = Manual Mutual Fund Transfer AGTNBR AGTNBR; CBRACT; DTCPRT DTCPRT; NSCPRT DTCPRT; NSCPRT DTCPRT; NSCPRT CBRACT; DTCPRT; NSCPRT For the Firm Reject and Request Records If the Transaction Type is: 01 = ACATS 02 = Free DTC Deliver Order (non-ACATS) 03 = Valued DTC Deliver Order 04 = Conversion 05 = Mutual Fund Transfer (non-ACATS) [change of broker-dealer] 06 = FED (non-ACATS) 07 = Physical Movement Settlement 08 = OCC Transfer (non-ACATS) 09 = Non-Domestic Depository (Foreign) 10 = Other 26 = DWAC Deposit 27 = Certificate Deposit 28 = DRS Profile/DO 36 = DWAC Withdrawal 37 = Withdrawal by Transfer (WT) 41 = Direct Presentation 46 = Fund to Firm Mutual Fund Transfer 51 = Firm to Fund Mutual Fund Transfer 56 = Networking Transaction 57 = Manual Mutual Fund Transfer Contra Firm Type must be: DTCPRT; NSCPRT DTCPRT DTCPRT DTCPRT; NSCPRT; CBRACT DTCPRT; NSCPRT; CBRACT DTCPRT; NSCPRT; CBRACT DTCPRT; NSCPRT; CBRACT DTCPRT; NSCPRT; CBRACT DTCPRT; NSCPRT; CBRACT DTCPRT; NSCPRT; CBRACT AGTNBR AGTNBR AGTNBR DTCPRT DTCPRT AGTNBR; CBRACT; DTCPRT DTCPRT; NSCPRT DTCPRT; NSCPRT DTCPRT; NSCPRT CBRACT; DTCPRT; NSCPRT The comments in the record layouts explain the roles of the submitter and contra firms by dividing the transaction types into the following categories: • Firm to Firm: 01 = ACATS 02 = Free DTC Deliver Order (Non-ACATS) 03 = Valued DTC Deliver Order 04 = Conversion 05 = Mutual Fund Transfer (Non-ACATS) [change of broker-dealer] 06 = FED (Non-ACATS) 07 = Physical Movement Settlement (Non-ACATS) 08 = OCC Transfer (non-ACATS) 09 = Non-Domestic Depository (Foreign) 10 = Other 27 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide • Firm & Transfer Agent: o Agent submits/firm receives CBRS original/corrected record: 26 = DWAC Deposit 27 = Certificate Deposit 28 = DRS Profile/DO o Firm submits/agent receives CBRS original/corrected record: 36 = DWAC Withdrawal 37 = Withdrawal by Transfer (WT) o Either Agent submits/firm receives or Firm submits/agent receives CBRS original/corrected record: 41 = Direct Presentation • Firm & Fund (In-kind Mutual Fund Transfers): o Fund submits/firm receives CBRS original/corrected record: 46 = Fund to Firm Mutual Fund Transfer [via ACATS Fund/SERV interface; also known as PTF, Position Transfer Fund ACATS transfer type] o Firm submits/fund receives CBRS original/corrected record: 51 = Firm to Fund Mutual Fund Transfer [via ACATS Fund/SERV interface; also known as PTF, Position Transfer Fund ACATS transfer type] o Either fund submits/firm receives or firm submits/fund receives CBRS original/corrected record: 56 = Networking Transaction ? In the case when an equity transfer agent/issuer is either the submitter or receiver of CBRS records, does the system verify that Submitting or Contra Firm Type and Number is the right transfer agent for that CUSIP, or just verify that the firm is an eligible CBRS User? CBRS checks that the transfer agent is an eligible CBRS user; it does not confirm that the Firm Number is the correct number for the CUSIP in that record. However, CBRS does populate the Contra Firm Number in most cases when a transfer agent is the receiver. Please see the Asset and Tax Lot Input record layouts for the rules for when CBRS populates the Contra Firm Number. 4.4.6 Numeric fields ? In numeric fields, do I have to zero fill all the bytes before the actual number? For example, in the Total Position Quantity field, if I send an asset record for 45.53 shares should I send ‘00000000000045,53’ or can I send spaces instead of zeroes? You can send either one. You can send 45,53 and CBRS adds leading zeroes; or you can send 00000000000045,53. 28 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 4.4.7 Asset Category field ? Should the value in the Asset Category field be left justified with a space to the right if it is a three letter code? In other words, the field is four bytes long, but for Asset Category EQU, should the EQU be left justified with a space after the value or right justified with a space before the value? The 3-letter value should be left justified, otherwise CBRS rejects the record. So, for EQU, the submitter should populate the Asset Category field with ‘EQU_’ where the underscore represents a space. 4.4.8 Sum of the tax lot quantities must match the asset quantity As discussed in an earlier section, an Asset record and its corresponding Tax Lot record(s) are a package. The sum of the tax lot quantities must equal the quantity of the corresponding asset record, or CBRS rejects the package. CBRS sums the tax lot quantities and compares this sum to the value in the Total Position Quantity field in the associated asset record. When calculating the total tax lot quantity, CBRS adds the quantity of each long tax lot (value L = Long in the Position Code field), and subtracts the quantity of each short tax lot (value S = Short in the Position Code field). The number in the Total Position Quantity field on the asset record is considered to be positive when the value in the asset record’s Position Code field is L = Long. The number in the Total Position Quantity field on the asset record is considered to be negative when the value in the asset record’s Position Code field is S = Short . CBRS compares the Total Position Quantity on the asset record to the sum of the values in the Tax Lot Quantity fields for the corresponding tax lot records, and rejects the record if the quantities do not match. 4.4.9 Optional fields ? If an optional field is not filled in on the asset or tax lot input, what will be in that field on the transaction output? The quantity and price fields will have zeros in them, other fields will be blank. 4.4.10 Borrowed Position Code The value “Borrowed” is only valid for a request record (Record Content Indicator = 04). This is a rare situation that can occur when a short position is delivered outside of a standard ACATS transfer. Figure 3 shows the steps for when a Borrowed value would be used. 29 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide Figure 3. Information flow with a Borrowed position code In step 4, when the Blue firm sends the proceeds of the short to the Yellow firm, he/she can use either the Tax Lot Current Cost field or the Tax Lot Original Cost field, depending on the type of asset. The Tax Lot Input record layout lists the rules for which cost field should be used for which Asset Category type. 30 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 4.4.11 ACATS Asset Sequence Number CBRS includes the ACATS Asset Sequence Number on the Asset Input record layout as a result of industry discussions about how to match cost basis to an asset transferred through ACATS which is identified by a User CUSIP. A submitter and receiver may use a different User CUSIP to identify a particular asset, such as a restricted security. The ACATS Asset Sequence Number is another data element to help the receiver match an asset transferred through ACATS to the cost basis received via CBRS. The date 07/26/2012 in the rule in this field is based on the day before this field was added to the CBRS code in the Production environment. The ACATS Asset Sequence Number is not required for ACATS transfers whose ‘Date Transfer was Initiated’ or ‘Settlement Date of Transfer’ occurred before the field was available in Production because some CBRS users may not have stored this number in the past. ? What happens if I populate the “ACATS Asset Sequence Number” field for a transfer whose settlement date is before 7/26/2012? If you populate the ACATS Asset Sequence Number for a transfer whose settlement date is before 7/26/2012, CBRS validates that the field is a 6-byte numeric field. If the value in the field passes that validation (and there are no other problems with the record), CBRS passes the record to the receiver. If the value in the field does not pass the validation, CBRS system rejects the record. ? What should I populate in the ACATS Asset Sequence Number field for transaction types other than 01 = ACATS? For transaction types other than 01 = ACATS, the submitter should leave this field blank. If you populate this field for a transaction type other than 01 = ACATS, CBRS will space out the field and pass the record. 4.5 Output General Information Firms receive a variable length Transaction Machine Readable Output (MRO) file via CDTS (Output Product ID #02400264). A download of CBRS MRO files is available through WebDirect. Firms using the WebDirect CBRS Inquiry function can download the CBRS transaction output file to Excel (Output Product ID #02401663). Firms can download a daily end-of-day CBRS transaction output file that will be available on WebDirect (Output Product ID #02401664). The Cost Basis Transaction MRO output record layout is 1,500 bytes, which is 500 bytes longer than the Asset and Tax Lot input record layouts. The output is longer because of a number of fields that CBRS adds to the output after it processes the input. Further details about these additional fields follow below. CBRS sends all accepted cost basis data to eligible recipients. CBRS validates each field to ensure that it meets the established validation rules. CBRS passes the cost basis data to the receiving firms and does not verify the accuracy of the data submitted. The Cost Basis Transaction MRO has three main components. The first component is a set of CBRS system-generated output fields. The second component is a set of status fields for the Asset and Tax Lot records received from the input file. The third component is the actual Asset and Tax 31 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide Lot data fields that contain the cost basis information validated by the CBRS system. CBRS returns the Asset and Tax Lot records to firms in the same sequence it received them: Asset record first, and then all of the associated Tax Lot records. The CBRS output includes both the records that a user submits, and the records that it receives from other users. In the output, users can also see the submitted records that CBRS rejected. Each record in the Cost Basis Transaction MRO file has a System Action field that labels the record as Accepted, Modified, or Rejected. ? What are the primary keys for the Transaction MRO file? There is no primary key on the file. The Cost Basis Control Number uniquely identifies a CBRS transfer which consists from 1 to many records (1 Asset record plus zero to many Tax Lot records that correspond to the asset). To create uniqueness in your database you need to add a column, such as a sequence number. The combination of these two columns creates a unique key within the table. If you store the information in more than one table you need to identify your self-created keys in a manner consistent with your database structure. 4.5.1 Distribution Side The Distribution Side field on the MRO file corresponds to whom CBRS is sending the file. For system rejected records, this field has a value of S = Submitting Participant, because only the submitter receives system rejected records. For records successfully processed through CBRS, this field has a value of B = Both Receiving and Submitting Participant, because CBRS sends successfully processed records to both the submitting and receiving firm. The Cost Basis Transaction MRO file also has a Distribution Firm Number and Distribution Firm Type. These fields have the firm number and type for the user receiving the file. 4.5.2 Cost Basis Control Number CBRS assigns a Cost Basis Control Number that uniquely identifies each Asset and associated Tax Lot record(s). This number appears only on the Cost Basis Output sent to each firm. The Cost Basis Control Number format is CCYYDDDCBNNNNNNNN (date + CB + eight digit number). CBRS assigns the Cost Basis Control Number to each submitted asset. All Tax Lot records associated with a particular Asset have the same Cost Basis Control Number as that Asset. The only exception is when a firm submits Tax Lot record(s) without a corresponding Asset record. In this case CBRS assigns a separate Cost Basis Control Number to each Tax Lot record, and then rejects it. Also, CBRS assigns a unique Cost Basis Control Number to rejected Cost Basis records (Asset and their associated Tax Lot records) for identification purposes. 4.5.3 System Rejects CBRS validates each field to ensure that it meets the established validation rules. If a record does not pass these rules, CBRS rejects the record. CBRS returns rejected transactions, both asset and 32 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide tax lot records, only to the submitting firm. The intended receiver of the cost basis information does not know the submitter attempted to deliver the information if the transaction is system rejected. If CBRS rejects an Asset record, it also rejects all corresponding Tax Lot records. If CBRS rejects one Tax Lot record, it also rejects all of the Tax Lot records and the associated Asset record. CBRS uses two fields to identify the error on a record: the System Action Code field and the System Reject Reason field. For more information, please read the field descriptions below. 4.5.4 System Action field The System Action field is in the beginning section of the output record of both the Asset or Tax Lot record. The System Action field indicates if each record on the input file was accepted, rejected, or modified. The values for the field are: • • • 1 = System Accepted - Transaction submitted correctly 2 = System Modified - Transaction submitted correctly and modified by CBRS 3 = System Rejected - Transaction submitted incorrectly Successfully passed records have a value of either 1 = System Accepted or 2 = System Modified in the System Action field. System Modified means CBRS has changed a field in the record. For more detail, see the bullet below on the System Changed value in the Status field. 4.5.5 System Reject Reason field The System Reject Reason field specifies the reason that CBRS rejected the record(s). If the System Action code is a ‘3’, the System Reject Reason field indicates the applicable reason. The System Reject Reasons and their explanations are listed below. • • • • • • • 01 = Invalid Field – one or more fields in the record has violated system rules 02 = Associated Record is Invalid – on an Asset record, this code indicates that one or more of the associated tax lot records has violated system rules; on a Tax Lot record, this code indicates that the associated asset record has violated system rules 03 = Invalid Length Record – the record does not conform to the 1,000 byte length required by the record layout 04 = Invalid Physical Sequence – asset record not present – the Tax Lot record does not have an associated Asset record 05 = Invalid Physical Sequence – tax lot record(s) not present – the Asset record does not have an accompanying Tax Lot record 07 = Invalid Accumulated Quantity – the sum of the Tax Lot Quantity fields does not equal the Total Position Quantity field on the associated Asset record 09 = No Corrected Tax Lot present for corrected Asset Input – an Asset Record with the value ‘02 = Corrected asset record’ in the Record Content Indicator field does not have at 33 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide • • least one associated Tax Lot record with the value ’02 = Corrected tax lot record’ in its Record Content Indicator field 10 = Invalid Physical Sequence – Tax Lot invalid with Asset Input reject or request – an Asset record with either ‘03 = Firm reject record’ or ’04 = Request record’ in the Record Content Indicator field has an associated Tax Lot record Space = Not rejected – CBRS has not rejected the record Note: numbers ‘06’ and ‘08’ are not currently in use. 4.5.6 Status Fields On the output, each submitted field has a corresponding status field. This field indicates if the value in the submitted field is valid, system changed, or error. A space is also a possible value for this field: the space occurs if the field is an optional field, the submitter does not populate the field, and the field does not have a default value. CBRS populates the status fields for all records on the Transaction MRO file. For the records where you are the contra party, the status is 0 = Valid, 1 = System Changed, or [space] which indicates that this field was not populated by the submitter. If a submitted field does not pass CBRS system rules, the status for that field is populated with a value of 2 = Error. When you are the contra party, you do not receive a status field which has a value of 2 = Error, because CBRS rejects a record that has an error in it and returns it to the submitter. CBRS does not pass a system rejected record to the contra party. ? What if a submitter sends a corrected tax lot with an original asset record—what is the system reject reason in this case? The System Reject Reason is 01 = Invalid Field, and the TO Record Content Indicator Status value is 2 = Error. 4.5.7 Example of System Changed System Changed appears in a Status field when CBRS changes a submitted value in a field. For example, on the Tax Lot Input record, there is a Certificate Number field. This field is allowed for only two transactions: 27 = Certificate Deposit and 41 = Direct Presentation. If a submitter populates this field for any other transaction type, CBRS replaces the submitted value with spaces and continues to process the record. In this case, the TO Certificate Number Status field has a value of 1 = System Changed. You can refer to the record layouts to see the various occasions where CBRS might modify submitted data. 4.5.8 Example of System Rejected When an asset or tax lot record is rejected, CBRS rejects the asset record and all its accompanying tax lots. CBRS treats an asset record and its tax lots as a package: when one piece is rejected, the entire package is rejected. 34 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide The example below illustrates what the MRO can contain when an asset record is rejected, but the tax lot record conforms to system rules: • • • In this example, the CBRS “package” has one asset record and one accompanying tax lot record. The asset record is rejected because the submitting firm populated the Settlement Date of Transfer field with 20110135 (20110135 is the CBRS format for January 35, 2011). CBRS rejects the record because January 35, 2011 is not a valid calendar date. The tax lot record passes system rules and edits with no errors. On the Cost Basis Transaction MRO file for the asset record, the System Action field has a value of 3 = System Rejected. The System Reject Reason field has a value of 01 = Invalid Field. The AO Settlement Date of Transfer Status has a value of 2 = Error. This combination of fields tells the submitter that the record is rejected, and why. (Other fields on the MRO are populated as well, this example highlights fields related to the reject.) On the Cost Basis Transaction MRO file for the accompanying tax lot record, the System Action field has a value of 3 = System Rejected. The System Reject Reason field has a value of 02 = Associated Record is Invalid. There are no 2 = Error values for the tax lot record Status fields because it passes system rules and edits. This combination of fields tells the submitter that record is rejected because of a problem with the associated record. (Other fields on the MRO are populated as well, this example highlights fields related to the reject.) 4.5.9 Output Dropped Records CBRS drops a transaction in the rare occasion when a submitter enters their firm number incorrectly, and CBRS does not recognize the submitter. In this case, CBRS rejects the record because the submitter is invalid. However, CBRS cannot return the record to the submitter because the incorrect submitter number does not match the submitter’s actual number, so CBRS does not know where to return the record. 4.5.10 LPA Number and LPA Type A Transfer Agent uses its LPA number as the deliverer of the DRS DO, and its Transfer Agent number as the Submitting Firm Number on the CBRS record. Broker-dealers and banks who receive cost basis from a transfer agent for Transaction Type 28 = DRS Profile/DO benefit from having the LPA number on the transaction output because they can use the LPA number to more easily match the DRS Profile/DO asset transfer to the CBRS record for that transfer. On the MRO file, CBRS provides the Limited Participant Account (LPA) number for cost basis passed on Direct Registration System (DRS) Profile/Deliver Order (DO) transactions. There are two fields on the Transaction MRO file, LPA Number and LPA Type. ‘LPA Type’ is always ‘DTCPRT’. The LPA Number is the LPA number that a transfer agent uses to send DRS DO transactions through DTC. CBRS populates these two fields only for original and corrected asset and tax lot records, for Transaction Type 28 = DRS Profile/DO. Otherwise, both fields will contain spaces. In order for CBRS to populate the LPA Number in this field, DTCC’s Account Administration department sets up a relationship between a transfer agent’s Transfer Agent (TA) number that is 35 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide currently eligible for CBRS, and it’s LPA Number. This functionality applies only to Transfer Agents who are eligible for CBRS and have a Limited Participant Account number. Transfer Agents who would like to opt out of this functionality should contact the Client Account Representative Team at [email protected]. 36 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 5 Best Practices This section contains Best Practices for CBRS as defined by various industry groups. These Best Practices are not enforced by system rules, but instead are guidance to the users of CBRS on how to handle certain situations and populate certain fields. While CBRS cannot enforce these Best Practices with system rules, these guidelines help all CBRS users process the submitted and received data in a consistent way. 5.1 Resolve issues with the contra party If a firm has received cost basis data from a submitting firm that it cannot apply or did not expect, the firm should contact the contra party directly. Similarly, if a firm does not receive cost basis information that it is expecting, the firm should contact the contra party directly. DTCC is not able to access firm data to respond to inquiries. 5.2 Firms should both submit and receive records If a firm is a CBRS user, the firm should submit cost basis information, not just receive cost basis information. CBRS users are expected to participate on both sides and for all transaction types. While CBRS users are expected to participate on both sides, some firms may have limitations on which transaction types they can submit. Firms with these limitations are expected to receive all transaction types supported by CBRS, either through an automated computer to computer connection or via WebDirect. 5.3 When should a firm send the CBRS record? Send an Original record on the day after the item settles. If it is not possible to send the CBRS record(s) the day after settlement, send them as soon as possible after settlement. Send a Corrected record within fifteen days of knowing that the record needs to be corrected. Send a Firm Reject record within two business days, except for a certificate deposit. For a certificate deposit, if a firm receives partial shares from the Transfer Agent, wait to send the reject. A receiver of an asset should wait at least fifteen days after the asset has been received before sending a Request record to the deliverer of the asset. 5.4 Corrected Record From the submitter’s point of view, the first time it sends basis, the submitter should send an original record. If the basis on a particular lot changes after the original record is sent, the submitter should send a corrected record. From the receiver’s point of view, if a contra party receives corrected basis but has not first received original basis for the lot, it should treat the basis as original 37 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide and apply the basis appropriately (i.e. a contra party should not firm reject a corrected record that does not have a corresponding original record). ? Which fields, when changed, should prompt the submitter to send a corrected record? Any field that has been changed should be sent as a correction. If the data element is important enough to be changed, it is important enough to re-send. If you replay the basis on your books, and everything stays the same, do not send a corrected record to the receiver. If you replay the basis on your books and anything is different, send a corrected record to the receiver. 5.4.1 Some scenarios about corrected records ? For example, a fund sends a CBRS record that is system rejected by CBRS. When the fund resubmits the record, marked as corrected, does CBRS accept the record? In other words does CBRS have any edits in place to check that an original record passed through successfully before a corrected record can be sent? No. CBRS does not confirm that a corrected record has a corresponding preceding original record. In that case, would a firm reject a corrected record back to the fund because it hasn’t received an original record? Best Practices suggest that a receiver should not firm reject a corrected record that does not have a corresponding original record(s). A receiver should be prepared to accept either an original or corrected record. ? What about this scenario: a fund sends a CBRS record, it passes CBRS edits and is sent to the receiving firm, and then the firm responds with a firm reject record. When the fund responds with a corrected record, would the firm accept the corrected record, even though they did not accept the original record? Yes. The receiving firm should accept the corrected record. These Best Practices hold true regardless of what type of CBRS user is the submitter or receiver: these same Best Practices apply to broker-dealers, funds, banks, and equity transfer agents/issuers. 5.5 Firm Reject and Request Records The scenarios below describe the Best Practices for the different Record Content types. In each example, Firm A has transferred an asset to Firm B, and now needs to pass the cost basis for that transferred asset. • • • Firm A sends an original record to Firm B. Some of the data is incorrect, so Firm B sends a firm reject record to Firm A. Firm A responds with a corrected record. Firm B has not received cost basis from Firm A. Firm B sends a request record to Firm A. Firm A responds with an original record. Firm A sends an original record to Firm C. Firm C is not the correct receiving firm for this record, so it sends a firm reject record to Firm A. Firm A responds by sending an original record to Firm B. 38 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide Note that in the last example above, while CBRS does not require Firm C to send a Firm Reject, it would be helpful for Firm C to Firm Reject the record so Firm A knows there is a problem. CBRS does not reject the record if it passes all of the system rules and edits, so the only way Firm A knows there is a problem with the record is if Firm C rejects it. A user can also firm reject corrected records. Let’s look at an example, using the same Firm A, Firm B, and Firm C as above: • Firm A sends a corrected record to Firm C. Firm C is not the correct receiving firm for this record, so it sends a firm reject record to Firm A. Firm A responds by sending a corrected record to Firm B. A firm reject is not an appropriate response to a firm reject record or a request record. Best Practices recommend that a firm disregard a firm reject or request record that it has received in error. ? Can a CBRS user send a corrected record without first sending an original record? CBRS does not reject a corrected record that was not preceded by an original record, but the contra party may not accept the corrected record in this scenario. Best Practices say do not send a corrected record unless you have first sent an original record. The following Best Practices apply to many of the fields in the Firm Reject and Request record content types (full list below): If Record content indicator is 03 = Firm reject record, then the fields below should be populated with the value on the Original asset record or Corrected asset record received. If Record content indicator is 04 = Request record, then the fields below should be populated with the value on the original transfer that triggered the need to pass cost basis. List of fields where these two Best Practices apply: • • • • • • • • • • • • • Receiver Customer Account Number Deliverer Customer Account Number ISIN Country Code ISIN Security Issue ID (CUSIP number) ISIN Security Check Digit Put - Call Indicator Option Symbol Option Expiration Date Option Strike Price Integer Option Strike Price Decimal Asset Description Asset Category Total Position Quantity 39 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide • • • • 5.6 Date Transfer was Initiated Settlement Date of Transfer Position Code Shares to Cover Short Indicator Do not request basis for lots received with unknown basis A receiving firm should not request basis from a submitting firm if the receiver receives lots that have unknown basis. Here are two examples: • • 5.7 Firm A sends cost basis to Firm B on a transfer of 300 shares of XYZ. Firm A sends an asset record for 300 shares, and two tax lots, one for 100 shares and one for 200 shares. The tax lot for 100 shares has a cost amount associated with it, but the 200 share lot has an unknown cost amount. The records pass CBRS processing, so Firm B receives all of this information. o Best Practices say that Firm B should not request information on the 200 share lot that has unknown cost. A firm should use a request record only when it has not received any information at all. Firm A sends an ACATS transfer to Firm B that contains 10 assets. Firm A sends CBRS records to Firm B, but only for 9 assets. o In this case, Firm B should send a request record for the one asset for which it did not receive a CBRS record. Submitting and receiving noncovered accounts and noncovered security types Below are the Best Practices about submitting and receiving data for noncovered accounts and noncovered security types: • • 5.8 From the submitter’s perspective: 1. If you have cost basis, send it 2. If you do not have cost basis, do not send anything (e.g., do not send a record that says the lot is noncovered and has unknown cost basis) From the contra party’s perspective: 1. Do not send a request record for an noncovered account or an noncovered security type 2. If you receive basis for an account that is noncovered, do not reject it 3. If you receive basis for a security that you think is noncovered, do not reject it Covered fixed income assets that were transferred in 2014 The regulations for the transfer of fixed income assets became effective on January 1, 2015. However, a CBRS user may receive basis on a fixed income asset in 2014 which the submitter has marked as covered. When a CBRS user receives cost basis for fixed income assets in 2014 which are marked as covered, the receiver needs to determine whether to consider those assets covered. 40 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 5.9 The CBRS quantity should equal the original asset transfer quantity, i.e. avoid fractional shares In the previous version of CBRS, some firms sent an asset transfer for a round lot, and then follow up in CBRS with a quantity that includes fractional shares. To avoid this discrepancy, the quantity transferred through CBRS should equal the quantity of the original asset transfer that triggered the need to pass cost basis. If the original asset transfer did not have fractional shares, neither should the CBRS record. ? If there is a corporate action during an ACATS transfer, what happens in CBRS? Scenario: 100 shares of an asset are transferred via ACATS. During the ACATS transfer, there is a stock dividend for 2 shares. In ACATS, the deliverer should send a residual balance of 2 shares. In CBRS, the deliverer should send a CBRS record for 100 shares, and then another CBRS record for 2 shares. This answer follows the best practice that the CBRS quantity should always equal the quantity of the asset transfer. 5.10 Populating CBRS records for ACATS reclaim or fail reversal transactions Follow these steps for populating the Submitting Firm, Contra Firm, Deliverer Customer Account Number, and Receiver Customer Account Number fields for ACATS reclaim (RCL) or fail reversal (FRV) transactions: The Submitting Firm is the firm submitting the CBRS record (and is the delivering firm of the asset in ACATS). The Contra Firm is the firm receiving the CBRS record (and is the receiving firm of the asset in ACATS). The Deliverer Customer Account Number is the account number at the firm delivering assets in the "original" ACATS transfer, and the Receiver Customer Account Number is the account number at the firm receiving assets in the "original" ACATS transfer. Both customer account number fields do not correspond to the "new" Deliverer/Receiver Customer Account Number for the FRV or RCL. For example, Firm 789 submits a TIF for a full transfer to Firm 123. Firm 123 delivers the assets to Firm 789. (For the purpose of this example, the transfer contains only long assets.) Later, Firm 123 submits a fail reversal or a reclaim to Firm 789. Firm 789 sends the asset to 123 in response. The customer account number at Firm 123 is 10203, and the customer account number at Firm 789 is 70809. The following table illustrates how CBRS records should be populated for the full transfer, and the fail reversal or reclaim. 41 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide ACATS CBRS Deliverer Customer Account Number Receiver Customer Account Number Record Type Submitting Firm Contra Firm Deliverer Cust. Account Number Receiver Cust. Account Number 789 10203 70809 Original 123 789 10203 70809 123 789 10203 70809 Corrected 123 789 10203 70809 789 123 789 10203 70809 Firm Reject 789 123 10203 70809 FUL 789 123 789 10203 70809 Request 789 123 10203 70809 FRV/ RCL 123 789 123 10203 70809 Original 789 123 10203 70809 FRV/ RCL 123 789 123 10203 70809 Corrected 789 123 10203 70809 FRV/ RCL 123 789 123 10203 70809 Firm Reject 123 789 10203 70809 FRV/ RCL 123 789 123 10203 70809 Request 123 789 10203 70809 Transfer Type TIF Submitter Asset Asset Deliver Receiver FUL 789 123 FUL 789 FUL 5.11 Sending a CBRS record for an asset held in multiple currencies ? Do I send multiple asset records for the same security if I hold the security in different currencies? Remember that the quantity of the asset record should correspond to the quantity of the original transfer that triggered the need to pass cost basis. You can indicate at the tax lot level which lots are held in a currency other than US Dollars. 5.12 Sending cost basis for an invalid certificate ? If a transfer agent receives a deposit for 100 shares consisting of two 50 shares certificates, and only one certificate can be processed at this time (e.g., one of the certificates is invalid), how should cost basis be returned? Best Practices suggest that, since in this case a transfer agent can only re-register 50 shares, it would only pass basis on the 50 shares that are reregistered. 5.13 Field Specific Best Practices After each field name below: (A) indicates a field on the Asset Input; (T), a field on the Tax Lot Input; and (A/T), a field on both the Asset and Tax Lot Input. 42 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 5.13.1 Transaction Type (A/T) CBRS users should not firm reject a record based solely on a mismatched Transaction Type. If a user receives a record with a Transaction Type it does not recognize, the user should examine other criteria in the record to match an asset transfer Transaction type 05 = Mutual Fund Transfer (non-ACATS) [change of broker-dealer] is for brokerto-broker transfers, and requests for this transaction type should not be sent to a fund. 5.13.2 Transfer Control Number (A/T) If transaction type is 02 = Free DTC Deliver Order (Non-ACATS), or 03 = Valued DTC Deliver Order; this field should be the IMS Transaction ID number (16 bytes) as specified on the original transaction processed at DTC. If transaction type is 26 = DWAC Deposit, 27 = Certificate Deposit, 28 = DRS Profile/DO, 36 = DWAC Withdrawal, 37 = Withdrawal by Transfer (WT); this field contains a reference ID number whose values and number of bytes changes depending on the original transaction processed at DTC. The CBRS Transfer Control Number should equal the reference ID for DAMP Deposits at DTC. If transaction type is 41 = Direct Presentation; this field should be 26 characters: Julian Date (3 bytes: DDD) + Participant Number (5 bytes) + Customer Account Number (18 bytes) If transaction type is 46 = Fund to Firm Mutual Fund Transfer or 51 = Firm to Fund Mutual Fund Transfer; this field is the FundSERV control number. Firms should use the Fund/SERV Control # from the ACATS Fund/SERV Statistics File, and add the letters ‘CATS’ to the front of it, in order to match the number that Funds should provide in this field. If transaction type is 56 = Networking Transaction, then the control number is the Networking control number For all other transaction types, 04 = Conversion, 05 = Mutual Fund Transfer (Non-ACATS), 06 = FED (non-ACATS), 07 = Physical Movement Settlement, 08 = OCC transfer, 09 = Non-Domestic Depository, 10 = Other, 57 = Manual Mutual Fund Transfer; this field is the control number agreed upon by the contraparties involved in the original securities transaction. 5.13.3 Alternate Control Number (A/T) For Transaction Types 46 = Fund to Firm Mutual Fund Transfer or 51 = Firm to Fund Mutual Fund Transfer, populate this field with the ACATS Control Number. 5.13.4 Asset Description (A/T) Populate this field for all records. 43 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 5.13.5 Asset Category (A) Take care to populate this field accurately. This value should correspond to the asset category for the transferred security. This is an important field that drives validation rules for the rest of the record. 5.13.6 Transferring basis on rights or warrants A deliverer should only pass basis for warrants or rights that were purchased for cash. Cost Basis allocated under rule 305 or 307 should not be transferred; instead, it should be re-allocated back to the underlying security. 5.13.7 Receiver Customer Account Number (A/T) If a firm does not have a receiver customer account number, Best Practices suggest entering the words “not provided” in this field. For ACATS items this Best Practice does not apply—a submitting firm does have a receiver customer account number for assets transferred through ACATS. 5.13.8 Deliverer Customer Account Number (A/T) The submitter should populate this field for Transaction Type 04 = Conversion. 5.13.9 Total Position Quantity/Tax Lot Quantity (A/T) ? How do I populate the quantity fields for fixed income and options? For example, if I transfer 10 option contracts at 100 shares per contract, should I populate the quantity field with 10 or 100? For an option, the submitter should populate the quantity field with the number of contracts. So, in this example, the submitter should populate the quantity field with ‘10’. For fixed income, if I transfer 10 bonds with a total face value of 10,000, should I populate the quantity field with 10 or 10,000? For a fixed income asset, the submitter should populate the quantity field with the asset’s face value. In this example, the submitter should populate the quantity field with 10,000. 5.13.10 Date Transfer was Initiated and Settlement Date of Transfer (A) Best Practices define the Settlement Date of Transfer, in general, as the day the position leaves the submitter’s books. For options transferred through ACATS, the submitter should populate the Settlement Date of Transfer with the ACATS settlement date. For options transferred at the Options Clearing Corporation (OCC) outside of ACATS, the submitter should populate the Settlement Date of Transfer with the date the option settled at the OCC. 44 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide For covered fixed income transferred through the Federal Reserve, the submitter should use the date the transfer settled at the Fed to populate the Settlement Date of Transfer. While the Date Transfer was Initiated may not be known for the underlying transfer, the Settlement Date of Transfer should be known. One or the other of these dates is required. Best Practices suggest that the Settlement Date of Transfer will be used for most records. 5.13.11 Disposition Method Used (A) The field has a limited list of values of potential disposition methods. As it states in the record layouts, the list of values for this field are not exhaustive—there are other methods that firms use. The field is also Optional, and not all firms use it. For firms who do use it, the field could provide value-added information for the underlying customer. Best Practices suggest that firms should try to use the field on a best-efforts basis. 5.13.12 Shares to Cover Short Indicator (A) This field is used in the following example: A customer moves to Firm A, and requests that Firm A delivers shares to Firm B to cover a short at Firm B. When Firm A sends the cost basis, populating the Shares to Cover Short Indicator with the Y value tells Firm B that the intent is to close out the short. Sometimes in this situation, Firm B establishes a new position, has both a short account and a long position on its books, and awaits customer instructions. This field eliminates this last step. 5.13.13 Noncovered/Pending Indicator (T) If field is left blank, the receiver will consider the lot covered if the Position Code is L = Long. If the Position Code is S = Short, the covered status of the position is not determined until the shares are acquired. Examples of when a submitter would use the Noncovered account value or the Pending value: • Noncovered account: an Noncovered account can be either an account belonging to an exempt recipient (such as a C Corporation) or an exempt account (such as a retirement account) • Pending: an account can be pending because the asset is a part of an Employee Stock Plan, or because the submitter is waiting for cost basis information from a prior firm • Certificate in Customer Name: this field should be used to indicate that a certain tax lot is restricted or physical. These shares are always noncovered from the broker-dealer’s perspective: the Transfer Agent has responsibility for the cost basis. The broker may have the basis on its books, but if so, it has been provided by the customer. 45 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide For example, a broker-dealer receives a transfer of 1,000 shares of ABC, 300 restricted shares 700 cash shares. The broker-dealer segregates the restricted shares from the cash shares. When the contra party sends cost basis to the broker-dealer through CBRS, it uses this new indicator to mark the 300 shares as noncovered using the “Certificate in Customer name” value. When the broker-dealer receives the cost basis, it knows to apply the basis for these 300 shares to the 300 restricted shares in the transfer. Without this indicator, the receiver would not know what basis to apply to the restricted shares. Please note that the submitter should not use the 01 = Noncovered lot value in this situation. Shares may be noncovered for other reasons. If the shares are noncovered because they are restricted or physical, the submitter needs to use the value “Certificate in Customer Name”. ? What are some examples of when different values in the “Noncovered/Pending Indicator” would be used? o “Noncovered lot.” A noncovered lot could occur in this scenario: a customer transfers 300 shares of equity XYZ, containing two tax lots, one lot of 100 shares, purchased on 05/29/2009, and one lot of 200 shares purchased on 06/01/2011. The lot of 100 shares was purchased before the IRS regulations came into effect for equities so this lot is uncovered. The lot of 200 shares was purchased after the IRS regulations came into effect for equities, so this lot is covered. When passing cost basis on this customer transfer, the record for the lot of 100 shares would have a value of “Noncovered lot” in the “Noncovered/Pending Indicator”. o “Noncovered account.” An example of a Noncovered account is a retirement account. o “Pending.” “Pending” could occur in this scenario: A customer transfers an asset from Firm A to Firm B. A month later, the same customer transfers an asset from Firm B to Firm C. Firm B is obligated to send cost basis to Firm C, but has not yet received the basis from Firm A. Firm B sends the lots to Firm C, marked as “Pending.” Firm B sends corrected records to Firm C once it has received the cost basis from Firm A. ? Scenario: I send a CBRS transaction to a contra party that includes a lot that is pending (i.e. has a 03 = Pending value in the Noncovered/Pending Indicator) because I am waiting for basis from the prior firm. When I received that basis, and then send it on to the contra party, do I send an original record or a corrected record? In this scenario, you should send a corrected record. 5.13.14 Taxes Reported by Issuer/Transfer Agent (T) In some cases the issuer/transfer agent does the 1099-B reporting. This field allows the issuer/transfer agent to tell the broker-dealer that it has already done the 1099-B reporting for a given tax lot, in order to avoid both parties reporting the information. ? Does the Taxes Reported by Issuer/Transfer Agent field apply only to the current year’s tax reporting? No. There can be circumstances where the reorg event affects multiple years. 46 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 5.13.15 Gifted or Inherited Indicator (T) The gifted and/or inherited information in CBRS cannot be cross-referenced with the value in the Gift/Donation Indicator in ACATS. The gifted and/or inherited information in CBRS is used to establish the value of the tax lot. The gift indicator in ACATS is used to tell the receiver that the deliverer is sending a transfer where the account titles do not match, and the deliverer or requestor is aware of this discrepancy. It is always recommended to deliver gifted or inherited securities and not request them through ACATS. However, if you do not abide by this rule and request an inherited or gifted security, it is the obligation of the receiver to step up the basis. ? What is the significance of the 03 = Inherited, then Gifted value in the Gifted or Inherited Indicator on the Tax Lot Input record layout? This value exists because of its impact on the holding period for the lot. Gifted shares have a short term holding period, inherited shares have a long term holding period. If an investor gifts inherited shares, the lot should keep its long term holding period. For example, an investor inherits shares. The same investor then gives these shares to his daughter. In this case, populate the Gifted or Inherited Indicator field with the value 03 = Inherited, the Gifted, in order to inform the receiver of the CBRS record that the lot should keep its long term holding period. ? Where on CBRS can I indicate the date of inheritance? The submitter does not enter the date of inheritance, as in the date the shares were inherited. Instead, the submitter should enter the date of death of the decedent in the Acquisition Date of Tax Lot field. 5.13.16 Fair Market Value as of Date of Gift (T) The submitter should populate this field if the value is known for a gifted security. For bonds, should be unadjusted for amortization or accretion. Basis adjustments should be made for all other security types 5.13.17 Position Code (T) In this field, transfer agents and mutual funds should default to L = Long position. 5.13.18 Position Code for options (T) ? When I am submitting a record to CBRS, how do I differentiate between writing the call and buying the call? You can indicate whether you bought the call or wrote the call using the ‘Position Code’ field to label the tax lot as either Long or Short. 5.13.19 Populating Acquisition Date of Tax Lot field when date is unknown (T) 47 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide How a submitter populates the Acquisition Date of Tax Lot field varies depending on the scenario. Below are the two scenarios: A. When the acquisition date and the cost basis are both unknown 1. Populate the Noncovered/Pending Indicator field with the appropriate value for the lot. Populating this field tells the receiver that the lot is noncovered or pending. 2. Do not populate any date or cost fields 3. Populate the Zero Basis Indicator with the value 02 = Unknown B. When the acquisition date is unknown and the cost basis is known 1. Populate the Noncovered/Pending Indicator field with the appropriate value for the lot. Populating this field will tell the receiver that the lot is noncovered or pending. 2. Best Practices suggest you can a date of 01/01/1901* (19010101 in CBRS record layout format) to signify an unknown date. 3. Populate the cost field(s) as applicable *Note—the date 01/01/1901 can mean different things: • If the lot is noncovered, 01/01/1901 can mean various dates or unknown date • If the lot is covered, 01/01/1901 means various dates ? When can 01/01/1901 mean various? Best practices suggest that IRS regulations allow the grouping of lots (covered lots into one group, noncovered lots into another group) for lots older than five years for mutual funds and shares in a DRP plan. So in this context, when lots are grouped together, the 01/01/1901 date can mean various. 5.13.20 Original Acquisition Date for Wash Sale Adjustment (T) The submitter should populate this field if the tax lot is the result of a wash sale. If the Original Acquisition Date for Wash Sale Adjustment is submitted, then the Wash Sale Adjustment Amount must also be populated. 5.13.21 Wash Sale Adjustment Amount (T) The Wash Sale Adjustment Amount is commonly referred to as the Disallowance Amount. The Wash Sale Adjustment Amount represents the disallowed loss from a wash sale, which has been added to the Tax Lot Current Cost. In the event that the Wash Sale equals zero for a fixed income security, then the Wash Sale Adjustment Amount field must be populated with zero, blanks are not accepted in this scenario. Neither the Tax Lot Original Cost, nor Tax Lot Current Cost basis of a fixed income security should be adjusted for the disallowed loss resulting from a wash sale. The Wash Sale Adjustment Amount should be applied to the Tax Lot Original Cost, and Tax Lot Current Cost basis for the disallowed amount when assets are not fixed income. 5.13.22 Exchange Rate (T) 48 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide This field should be the spot exchange rate used for converting the Tax Lot Current Cost as of the acquisition date of the tax lot. The rate is the amount of local currency equal to one dollar. For example, if ISO Currency Code = JPY, the value in this field is 86,4428 for acquisition date 12/01/2009. 5.13.23 Tax Lot Original Cost (T) In this field, the submitter should include total original cost for asset backed securities. In the event of a wash sale for an equity security, the Tax Lot Original Cost should be adjusted for the Wash Sale Adjustment Amount. For covered fixed income securities, do not adjust the Tax Lot Original Cost for corporate actions. The Tax Lot Original Cost should be populated for asset backed securities. If you are not amortizing or accreting a bond, the original cost and current cost for that bond could be the same. 5.13.24 Tax Lot Current Cost (T) If Position Code is S = Short and the security is covered by the legislation, this field should equal the gross proceeds of the short position. For lots using average cost, populate this field with the pro-rata average cost. This field includes this Best Practice: “For a noncovered average cost mutual fund position with at least one lot with unknown basis, populate this field with the actual current cost for each lot with known basis.” This means that the submitter should populate this field with the actual current cost for the lot without consideration for averaging. For example, a submitter has three lots. The submitter should populate the Tax Lot Current cost fields for the lots as follows: Tax lot quantity Tax lot cost 100 $700 200 $2,000 50 unknown Value in the Tax Lot Current Cost field $700 $2,000 $0, with a value of 02 = Unknown in the Zero Basis Indicator field 49 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide The submitter should not average all three lots together, and then populate the Tax Lot Current Cost field for each lot with its corresponding portion of the average. Best Practices indicate that a submitter should send the cost of the individual lot. However, sometimes the average cost is the only value that is known. In that case the submitter should send the average cost value in the Tax Lot Current Cost field. If neither the individual cost of the lot nor the average cost of the lot is known, the submitter should send the lot with unknown cost. ? How do I indicate a negative value in the Tax Lot Current Cost field? CBRS does not accept negative numbers. If you are not amortizing or accreting a bond, the original cost and current cost for that bond could be the same. Adjust the Tax Lot Current Cost field for fixed income securities in the event of wash sales, corporate actions, return of principal, OID, accretion, amortization as of the settlement date of the transfer. 5.13.25 Zero Basis Indicator (T) ? When would a firm use the value 01 = True Zero? A submitter could use the value 01 = True Zero in dealing with rights, or the return of capital. 5.13.26 Tax Lot Original Unit Price (T) Populate for a mortgage-backed security, if known. 5.13.27 Employee Plan Shares Indicator (T) If this field is populated, a third party—not the submitter—should provide the cost basis for the tax lot. 5.13.28 Fields for fixed income elections (T) The table below describes how a submitter should fill out the five fields related to fixed income elections, if the submitter is following the defaults outlined in the IRS regulations. Please note that ‘default’ refers to the regulations, and not to a CBRS system default. CBRS does not automatically populate any of these fields. Election Default per IRS regulations 50 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide Election to Accrue Market Discount using a constant yield N Election to Include Market Discount in Income currently N Election to treat all Interest as OID N Election to Amortize Premium Y Spot Rate election for interest accruals with respect to a covered debt instrument denominated in a currency other than the U.S. dollar N 5.13.29 Purchase/ Dividend Reinvestment Indicator (T) The IRS default value for the Purchase / Dividend Reinvestment Indicator is P= purchase. 5.13.30 Market Discount (T) Market Discount information if applicable, should be included in the cost basis submissions for only CD’s, Commercial Paper, Corporates, Foreign Debt, Governments, Mortgage Backed Securities, Municipals and Zeroes. Below is a summary of Best Practices applicable to populating the Market Discount field. Market Discount Situation Election to include market discount in income currently is not made Include Market Discount in Income Election No Market Discount Amount should be 0.00 Market Discount is deferred. Current Cost Note: Should not include wash sale adjustments or disallowed carryover amount Current Cost should not include any accretion of Market Discount 51 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide No Amount should reflect the accreted Market Discount from acquisition date to settlement date of transfer. Amount should reflect the accreted Market Discount from the settlement date of acquisition to the date of revocation Yes or No Because current inclusion is presumed with the Al Income as OID election, the election may be populated with either Y or N. Amount should reflect the Market Discount accreted through the settlement date of the transfer Current Cost should include the amount of accreted Market Discount from settlement date of acquisition to the settlement date of transfer Revocation of All OID Election - Does not allow for revocation of current inclusion Yes Amount should reflect the accreted Market Discount through the settlement date of the transfer Current Cost should only reflect the amount accreted through the settlement date of transfer Default of debt instrument purchased at a market discount Current Inclusion election is not made No Amount should be 0.00 Current Cost should not include any accretion of Market Discount Yes Amount should reflect the accreted Market Discount through the settlement date of the transfer Current cost should reflect the Market Discount amount accreted through the settlement date of the transfer Election to include market discount in income currently is made Election to include market discount in income currently is revoked Treat All Interest as OID Election is Made (Election to include market discount in income currently is presumed) ** Default of debt instrument purchased at a market discount Current Inclusion election is made Yes Current Cost should include the amount of accreted Market Discount from acquisition date to the settlement date of transfer Current Cost should include the accreted Market Discount from settlement date of acquisition to the date of revocation 52 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide Default of debt instrument purchased at a market discount All OID election is made Yes or No Because current inclusion is presumed with the Al Income as OID election, the election may be populated with either Y or N. Amount should reflect the accreted Market Discount through the settlement date of the transfer Current cost should reflect the Market Discount amount accreted through the settlement date of the transfer ** If the election to include income currently is not made, there is no additional impact if the All Income as OID election is made 5.13.31 Bond Premium (T) Bond Premium information if applicable, should be included in the cost basis submissions for only CD’s, Commercial Paper, Corporates, Foreign Debt, Governments, Mortgage Backed Securities, Municipals and Zeroes. Below is a summary of Best Practices applicable to populating the Bond Premium field. Bond Premium Situation Broker Default to Amortize Amortize Bond Premium Election Yes Bond Premium Amount should reflect amortized Bond Premium from acquisition date to the date of the last interest payment (last interest payment date since amortization is only allocable to interest payments) Current Cost Note: Should not include wash sale adjustments or disallowed carryover amount Current Cost adjusted for the amount of amortized Bond Premium from acquisition date to the date of last interest payment (i.e. last interest payment date since amortization is only allocable to interest payments) 53 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide Client Notification to not amortize No Revocation of notification to not amortize Yes Interest as OID election = Y ** Yes Default of debt purchased at a Bond Premium with the default to amortize Yes 5.13.32 For bonds purchased in the year the election is made or thereafter, this amount should be 0.00. For bonds purchased in the year the election is made or thereafter, Current Cost should be unadjusted for any Bond Premium For bonds purchased in a year prior to the election, this amount should be the amount of amortized Bond Premium from the settlement date of acquisition to the date of the notification to not amortize For bonds purchased in a year prior to the election, Current Cost should be adjusted by the amount of amortized premium from the date of acquisition to the date of the notification to not amortize Amount of amortization from the date of revocation to the settlement date of transfer Amortization amount through the settlement date of the transfer (Because All income as OID is on an accrual basis, amortization is done daily, not based on interest payment dates) Current Cost adjusted for the amount of Bond Premium amortized from the date of revocation to the settlement date of transfer Amount of amortized Bond Premium from settlement date of acquisition to the date of the last interest payment received Cost adjusted for the amount of amortized Bond Premium from date of acquisition to the date of the last interest payment received Current Cost includes amortization amount through the settlement date of the transfer (Because All income as OID is on an accrual basis, amortization is done daily, not based on interest payment dates) Acquisition Premium (T) Acquisition Premium information if applicable, should be included in the cost basis submissions for only CD’s, Commercial Paper, Corporates, Foreign Debt, Governments, Mortgage Backed Securities, Municipals and Zeroes. Below is a summary of Best Practices applicable to populating the Acquisition Premium field. 54 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide Acquisition Premium Situation No Applicable Election Default of debt purchased at an acquisition premium 5.13.33 Acquisition Premium Current Cost Note: Should not include wash sale adjustments or disallowed carryover amount Amount of acquisition premium accreted from the settlement date of acquisition through the settlement date of transfer Cost adjusted for the amount of acquisition premium accreted from the settlement date of acquisition through the settlement date of transfer For OID bonds purchased at par or at a bond premium, this amount should be 0.00 or equal to the amount of accrued OID For OID bonds purchased at par or at a bond premium, this amount should be 0.00 or equal to the amount of accrued OID Amount of acquisition premium accreted from the settlement date of acquisition through the settlement date of transfer Cost adjusted for the amount of acquisition premium accreted from the settlement date of acquisition through the settlement date of transfer Accrued OID (T) Accrued OID information if applicable, should be included in the cost basis submissions for only CD’s, Commercial Paper, Corporates, Foreign Debt, Governments, Mortgage Backed Securities, Municipals and Zeroes. Below is a summary of Best Practices applicable to populating the Accrued OID field. 55 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide Accrued Original Issue Discount (OID) Situation Election to treat all income as OID is not made Interest as OID Election No Accrued OID Amount of OID accreted from the settlement date of acquisition through the settlement date of transfer For OID Bonds purchased at par or at a bond premium, this amount should either be 0.00 or equal to the amount of acquisition premium Election to treat all income as OID is made Yes Amount of OID accreted from the settlement date of acquisition through the settlement date of transfer Current Cost Note: Should not include wash sale adjustments or disallowed carryover amount Current Cost adjusted for amount of OID accreted from the settlement date of acquisition through the settlement date of transfer For OID Bonds purchased at par or at a bond premium, there is no basis adjustment for OID (OID = Acquisition premium so they offset each other) Current Cost should be adjusted by the amount of accreted OID The amount should not include interest payments, accretion of Market Discount, Bond Amortization or amortization of Acquisition Premium Default of debt issued at an Original Issue Discount Amount of OID accreted from the settlement date of acquisition through the settlement date of transfer Amount of OID accreted from the settlement date of acquisition through the settlement date of transfer 56 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 5.13.34 Last Adjustment Date (T) The Last Adjustment Date occurs when the last basis adjustment was made to account for Bond Premium, Acquisition premium, Market Discount or OID For OID bonds purchased at a premium, this date should be the last date as of which the bond premium was amortized (Acquisition premium and OID nets to 0.00 so the relevant date is the last interest payment date used for amortization of bond premium) For OID bonds purchased at a market discount where market discount is deferred, this date should be the settlement date of the transfer as this is the last date as of which OID was accreted In the instance where the current inclusion election was revoked, this date should reflect the date of revocation (i.e. when accretion of Market Discount stopped). In all other instances, this should be the settlement date of the transfer. 5.13.35 Carryover Offset Future Use(T) This field will not be used. If Carryover Offset this field is populated, it will be overlaid with zeroes and passed. 5.13.36 Disallowed Carryover Offset (T) The amount of Amortized Bond Premium to be carried over to the date of disposition (The Current Cost basis should NOT be adjusted by this amount). The Carryover Offset amount must be carried over until the disposition of the asset. This occurs in the instance where debt purchased at a Bond premium is not amortized and then in a later year, the client revokes the decision. For example; if a client elects to not amortize in year 1, then subsequently changes their election to amortize going forward, the year 1 amortization would be placed in the Carryover Offset field. The Carryover Offset is sometimes also called “Excess Bond Premium.” 57 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 6 File Input and Output via Common Data Transfer Service (CDTS) 6.1 General Information The Common Data Transfer Service, or CDTS, is DTCC's proprietary file input and output management system. It enables DTCC and its participants to securely and reliably automate the exchange of files over a network link. Once a secure network connection is configured, minimal set-up is required to automate inbound and outbound file transfers. Two industry standard file transfer protocols are supported, FTP and Connect:Direct (NDM). DTCC operations staff actively monitors these systems and addresses any failed transmissions. Both systems are available in the test and production environments. o Input: The transaction input has a CDTS input header and CDTS input trailer. o Output: The transaction output has a CDTS output header, and a CBRS application output header, and a CBRS application output trailer. There is no CDTS output trailer. o The table below shows the order of the header, transaction records, and trailer in the file: Input Output CDTS input header CDTS output header CBRS records CBRS application header CDTS input trailer CBRS records CBRS application trailer For questions about CDTS, please call the Customer Support Hotline at 888-382-2721, option 6, then option 7, then option 2. 6.2 File Input CBRS uses only variable length input files. There are no fixed length input files. The CBRS input cut-off time is 4:00 PM ET. The Input SYSID for CBRS input files is 36708. A CDTS input header record is required. It is the first record in any file transmitted. The CDTS input trailer record is also required, and is the last record in any file transmitted. The record layouts for the CDTS input header and trailer records (named Datatrak Header and Trailer in the layout) can be found on the dtcc.com website at: http://dtcc.com/clearing-services/equities-clearing-services/cbrs/client-center/public-documents.aspx ? The asset and tax lot input records are always 1,000 bytes. The transaction output is always 1,500. Why are these records “variable?” While it may not be apparent in the current record layouts, the records have variable functionality built into them for future 58 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide expansion. For now, the asset and tax lot input records are always 1,000 bytes long, and the transaction output record is always 1,500 bytes long. In the future, the record layouts can be expanded to as large as 4,000 bytes. We have left this extra room to allow for more fields, in case they become necessary in future versions of the system. This possible expansion gives the records the “variable” designation. We do not make the records 4,000 bytes today because we do not want to take up disk space that we do not need. NSCC’s Automated Customer Account Transfer Service, or ACATS, uses this functionality, so we’ll look at ACATS as an example. Here’s what the Record Length field looks like in the variable ACATS Asset Input record layout: Field Name Length Start End Type Record Length 6 NUM 4 3 Opt/Req/ Comments Cond REQ Asset Type Option Mutual Fund Insurance Foreign All Others Record Length 497 550 1700 831 431 These different lengths illustrate the use of a variable record. The length of the record varies based on the type of asset in the record. CBRS is not currently using this functionality, but has the option to use it in the future if the need arises. ? Can a firm send multiple files to CBRS during the day? Yes. You can send multiple files each day, through both the computer to computer connection and WebDirect. CBRS combines all the input and processes it at the end of the day, and sends the output in one file. ? If my firm does not have any CBRS transactions to submit to DTCC on a given day, can I send an empty file? Yes, you can send an empty file with only a CDTS header. You can also not send any file at all. 6.3 File Output: Transaction MRO A CBRS application header record is the first record in the CBRS transaction MRO file. See below for the CBRS application header and trailer record layouts. The Output Product ID for the CBRS Transaction MRO is 02400264. The record layout for the CDTS output header record (named the Autoroute Header in the layout) can be found on the dtcc.com website at: http://dtcc.com/clearing-services/equities-clearing-services/cbrs/client-center/public-documents.aspx ? If my firm does not have any CBRS transaction output for a given day (meaning my firm is not the submitter or receiver of any CBRS records), will I receive a transaction output 59 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide file? The answer is yes if you are set up to receive an empty file. When you set up your access to CBRS, you can ask to receive an empty CBRS transaction output file in this situation. The file will contain only a CDTS header. 6.4 File Output: Cost Basis User Master File MRO The Cost Basis User Master File MRO does not have an application header. The file has a CDTS header. The record layout for the CDTS output header record (named the Autoroute Header in the layout) can be found on the dtcc.com website at: http://dtcc.com/clearing-services/equities-clearing-services/cbrs/client-center/publicdocuments.aspx The Output Product ID for the Cost Basis User Master File MRO is 02561666. 6.5 Limits on when output files and data are available Files are stored in WebDirect for four business days. DTCC can retransmit files for fourteen calendar days. Data is available for viewing on WebDirect screens, using the Cost Basis Inquiry screen, and downloading to an Excel spreadsheet, for twenty-five business days. After the twenty-five business day window has passed, DTCC will not be able to provide CBRS data to users. Users are responsible for storing their data on a long-term basis. 6.6 • • Input and Output timing Input: for today’s processing date, firms can submit CBRS records between 8 PM ET yesterday and 4 PM ET today. o Files submitted between 8 PM ET yesterday and 4 PM ET today should have today’s date in the header o Files with today’s header date, submitted between 4 PM and 8 PM today, are processed with tomorrow’s processing date o Files with tomorrow’s header date, submitted between 4 PM and 8 PM today, are rejected by CDTS Output: for today’s processing date, CBRS transaction output and the Daily Deposit File for Transfer Agents is available by 9 PM ET today. The Cost Basis User Master File is available by 11 PM ET today. This schedule applies to input and output through both the automated computer to computer connection, and via WebDirect. 60 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 6.7 CBRS Application Output Header A CBRS application header record is the first record in any CBRS MRO file transmitted. The following is the layout of this application header: CBRS APPLICATION OUTPUT HEADER Description Length Start End Record Type 1 1 1 Record Length 4 2 5 AutoRoute Product ID 8 6 13 File Description 30 14 43 Distribution Side 4 44 47 Processing Date Multi-Cycle Indicator Multi-Cycle Nbr. Variable-Length Record Indicator Future Use 6.8 Type A/N A/N A/N A/N A/N 8 1 4 1 48 56 57 61 55 56 60 61 A/N A/N A/N A/N 19 62 80 A/N Comments ‘H’ ‘61’ – Variable Length 02400264 Cost Basis Transaction MRO Last four digits of the distribution firm’s CBRS Account ID number CCYYMMDD Single Cycle = [space] Zeroes Variable Length = ‘*’ Spaces End of Record CBRS Application Output Trailer A CBRS application trailer record is the last record in any CBRS MRO file transmitted. The following is the layout of this application trailer: CBRS APPLICATION OUTPUT TRAILER Description Length Start End Record Type 1 1 1 Record Length 4 2 5 AutoRoute Product ID 8 6 13 File Description 30 14 43 Distribution Side 4 44 47 Type A/N A/N A/N A/N A/N Processing Date Multi-Cycle Indicator Multi-Cycle Nbr. Variable-Length Record Indicator Item Count 8 1 4 1 48 56 57 61 55 56 60 61 A/N A/N A/N A/N 9 62 70 A/N Future Use 10 71 80 A/N Comments ‘T’ ‘70’ – Variable Length 02400264 Cost Basis Transaction MRO Last four digits of the distribution firm’s CBRS Account ID number CCYYMMDD Single Cycle = [space] Zeroes Variable Length = ‘*’ Transmission count (includes Header and Trailer) Spaces End of Record 61 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 7 CBRS and WebDirect 7.1 WebDirect Workflow To use CBRS via WebDirect, the secure Internet portal, you must follow a series of steps. At the most basic level, these steps are: 1. Create transactions. 2. Submit transactions to a batch. Note: Please be aware that transactions submitted to a batch have not yet been sent to DTCC. 3. Send your batches of transactions to DTCC. 4. Download files. In addition to the steps above, your workflow may involve steps such as editing data, searching or deleting transactions, or uploading a spreadsheet. This guide contains information on these steps, as well as all CBRS functionality available on WebDirect. 7.2 Logging on to the system To access the screen to log into CBRS over the internet through WebDirect, go to: https://portal.dtcc.com After you have logged in: To use CBRS in the production environment, click on under the “Available Production Products” section. To use CBRS in the testing environment, click on under the “Available PSE, PSE2, and PTE Products” section. If you have trouble logging on to the system, contact DTCC Customer Support, 1-888-382-2721. 7.3 Creating Transactions You can create either an asset or a tax lot record. An asset record can be one of the four possible record content types: original, corrected, firm reject, or request. A tax lot record can be either an original record or a corrected record. 62 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide A transaction refers to all assets that have the same transfer control number. Some transfer types, such as an ACATS transfer, can have multiple assets per transfer control number. Other transfer types, such as a free deliver order, have one asset per transfer control number. Each asset can include one or more tax lots. Assets are required for all transactions. Tax lots are required for transactions with a record content type of either original or corrected. Note: When you submit transactions in CBRS (after creating new transactions or modifying existing transactions), you are creating or modifying pending transactions that must then be sent to DTCC. For more information, see Sending a Batch to DTCC. Note: You can also create transactions via spreadsheet upload. For more information, see The Spreadsheet Upload Process. 63 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 1. On the CBRS home page, under Transaction Inputs, click Cost Basis Input. 64 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide The Cost Basis Reporting Service page appears. The Transfer Information section of this page is pictured below. 2. Enter all the information you have regarding the transaction. Note: Required fields are identified with a red asterisk (*). 3. In the Asset Information section, enter information for the first asset for this transaction. 65 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 4. Enter information for the first tax lot for this asset. Note: The tax lot input screen automatically appears when, in the Asset Record Content Indicator field, you choose 01 = Original asset record or 02 = Corrected asset record. If you choose 03 = Firm reject record or 04 = Request record, the tax lot input screen will not appear. There are no tax lots associated with the Firm reject or Request record types. 5. If you have more than one tax lot for this asset, click the More Tax Lots radio button and click Submit. The transaction page reappears, with the transaction and the asset information already populated. 6. Enter the additional tax lot information. Repeat steps 5 and 6 for each tax lot associated with this asset. 7. If you have more than one asset for this transaction, finish entering the tax lot information. Then click the More Assets radio button and click Submit. The transaction page reappears, with the transaction information already populated. 8. Enter the additional asset information. 9. Enter the tax lot information as described in steps 4 through 6 for the next asset. 10 Repeat steps 7 through 9 as needed until you have entered all the asset and tax lot information . for this transaction. Notes: • You must finish entering all the asset and tax lot information associated with the transaction before clicking Submit the final time. • You cannot add additional asset or tax lot information for a transaction by editing an existing Cost Basis record. For details on adding additional asset or tax lot information to a transaction, see Adding More Assets to a Transaction or Adding More Tax Lots to a Transaction. 11 Click Submit. . The "Previous transaction was processed successfully" message appears on the Cost Basis Reporting Service screen. 66 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide After you submit the transaction, CBRS adds it to the previously submitted transactions (if any exist). After you are finished entering all transactions, follow the steps to send the batch to DTCC. For more information, see Sending a Batch to DTCC. CBRS processes all the files at the same time at the end of the day. 7.4 Working with Pending Transactions 7.4.1 Adding More Assets to a Transaction If you have already entered a transaction and need to enter another asset, follow the steps shown below. Note: When you submit transactions in CBRS (after creating new transactions or modifying existing transactions), you are creating or modifying pending transactions that must then be sent to DTCC. For more information, see Sending a Batch to DTCC. 67 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 1. On the CBRS home page, under Transaction Inputs, click Cost Basis Input. 68 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide The Cost Basis Reporting Service page appears. 2. Enter the same information you already entered about this transaction. Note: Required fields are identified with a red asterisk (*). 3. Enter information for the additional asset for this transaction. 4. Enter information for the first tax lot for this asset. Note: The tax lot input screen automatically appears when, in the Asset Record Content Indicator field, you choose 01 = Original asset record or 02 = Corrected asset record. If you choose 03 = Firm reject record or 04 = Request record, the tax lot input screen will not appear. There are no tax lots associated with the Firm reject or Request record types. 69 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 5. If you have more than one tax lot for this asset, click the More Tax Lots radio button and click Submit. The transaction page reappears, with the transaction and the asset information already populated. 6. Enter the additional tax lot information. Repeat steps 5 and 6 for each tax lot associated with this asset. 7. If you have more than one asset to add to this transaction, finish entering the tax lot information. Then click the More Assets radio button and click Submit. The transaction page reappears, with the transaction information already populated. 8. Enter the additional asset information. 9. Enter the tax lot information as described in steps 4 through 6 for the next asset. 10. Repeat steps 7 through 9 as needed until you have entered all the additional asset and tax lot information for this transaction. Note: You must finish entering all the asset and tax lot information associated with the transaction before clicking Submit the final time. 11. Click Submit. The "Previous transaction was processed successfully" message appears on the Cost Basis Reporting Service page. After you submit the transaction, CBRS adds it to the previously submitted transactions. After you are finished entering all transactions, follow the steps to send the batch to DTCC. For more information, see Sending a Batch to DTCC. CBRS processes all the files at the same time at the end of the day. 70 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 7.4.2 Adding More Tax Lots to a Transaction If you have already entered a transaction and need to enter another tax lot, follow these steps: 1. On the CBRS home page, under Transaction Inputs, click Cost Basis Input. The Cost Basis Reporting Service page appears. 71 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 2. Enter the same Transfer Information you already entered about this transaction. Note: Required fields are identified with a red asterisk (*). 3. Enter the Asset Information that you already entered for this asset. 4. Enter the additional tax lot information for this asset. Note: The tax lot input screen automatically appears when, in the Asset Record Content Indicator field, you choose 01 = Original asset record or 02 = Corrected asset record. If you choose 03 = Firm reject record or 04 = Request record, the tax lot input screen will not appear. There are no tax lots associated with the Firm reject or Request record types. 72 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 5. If you have more than one additional tax lot for this asset, click the More Tax Lots radio button and click Submit. The transaction page reappears, with the transaction and the asset information already populated. 6. Enter the additional tax lot information. Repeat steps 5 and 6 for each tax lot associated with this asset. Note: You must finish entering all the asset and tax lot information associated with the transaction before clicking Submit the final time. 7. Click Submit. The "Previous transaction was processed successfully." message appears on the Cost Basis Reporting Service page. After you submit the transaction, CBRS adds it to the previously submitted transactions. After you are finished entering all transactions, follow the steps to send the batch to DTCC. For more information, see Sending a Batch to DTCC . CBRS processes all the files at the same time at the end of the day. 73 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 7.4.3 Listing and Searching Pending Transactions You can display transactions that you have submitted but have not yet sent to DTCC. You can either list all existing transactions, or you can use search criteria to display specific transactions. After displaying a set of transactions, you can view, update, or delete transfer information, assets, and tax lots for those transactions. To list all pending transactions 1. From the CBRS home page, under Data Review/Send, click Summary. 74 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide The Summary page appears. 2. Click List. The Transfer List page appears, displaying all current pending transactions. 75 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide To search pending transactions 1. From the CBRS home page, under Data Review/Send, click Summary. 2. The Summary page appears. 3. Click Search. 76 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide The Cost Basis Search page appears. 4. Using the fields provided, type and select your search criteria. 5. Click either Search button. The Transfer List page appears, displaying the transactions that match your selection criteria. Notes: To view, update, and delete transfer information for transactions displayed on the Transfer List page click the corresponding link in the Item Number column. For more information, see Viewing and Updating Transfer Information. To view, update, and delete asset and tax lot information for transactions displayed on the Transfer List page click the corresponding link in the Number Of Assets column. For more information, see Viewing and Updating Assets and Viewing and Updating Tax Lots. 77 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 7.5 Deleting Transactions You can delete transactions from the Transfer List page or the Transfer Information Update page. 7.5.1 Deleting transactions from the Transfer List 1. Display the transactions you want to work with. You can use the search function to search for specific pending transactions or the list function to list all pending transactions. If you choose List, skip to step 3. If you use Search, continue on to the next step. For more information, see Listing and Searching Pending Transactions. The Cost Basis Search page appears. 2. Using the fields provided, type and select your search criteria and then click either Search button. 78 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide The Transfer List page appears. 3. Click the check box next to one or more transactions. To select all transactions, click the Select All checkbox. 4. Click Delete. Note: When you click Delete, the transfer information and all associated assets and tax lots are deleted. 7.5.2 Deleting transactions from the Transfer Information Update page 1. Display the transactions you want to work with. You can use the search function to search for specific pending transactions or the list function to list all pending transactions. If you choose List, skip to step 3. If you use Search, continue on to the next step. For more information, see Listing and Searching Pending Transactions. 79 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide The Cost Basis Search page appears. 2. Using the fields provided, type and select your search criteria and then click either Search button. The Transfer List page appears. 3. Click the Item Number link for the transaction you want delete. 80 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide The Cost Basis Transfer Information Update page appears. 4. Click either Delete button. Note: When you click Delete, the transfer information and all associated assets and tax lots are deleted. 7.6 Editing Transfer Information, Asset Records, and Tax Lot Records 7.6.1 Viewing and Updating Transfer Information You can view and update the transfer information for transactions you have submitted but have not yet sent to DTCC. Note: When you submit transactions in CBRS (after creating new transactions or modifying existing transactions), you are creating or modifying pending transactions that must then be sent to DTCC. For more information, see Sending a Batch to DTCC. 1. Display the transaction you want to work with. You can use the list function to list all pending transactions, or you can use the search function to search for specific pending transactions. For more information, see Listing and Searching Pending Transactions. If you choose List, skip to step 3. If you use Search, continue on to the next step. 81 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide The Cost Basis Search page appears. 2. Using the fields provided, type and select your search criteria and then click either Search button. The Transfer List page appears. 3. Click the Item Number link for the transaction you want to work with. 82 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 4. The Cost Basis Transfer Information Update page appears. 5. To update the transfer information, modify the appropriate information displayed and click Submit. Note: You cannot modify the following fields on the Transfer Information Update page: • Submitting Firm • Contra Firm Type • Asset Record Content Indicator • Transaction Type 83 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 7.6.2 Viewing and Updating Assets For transactions that you have submitted but have not yet sent to DTCC, you can view and update the assets assigned to those transactions. Note: When you submit transactions in CBRS (after creating new transactions or modifying existing transactions), you are creating or modifying pending transactions that must then be sent to DTCC. For more information, see Sending a Batch to DTCC. 1. Display the transaction you want to work with. You can use the list function to list all pending transactions, or you can use the search function to search for specific pending transactions. For more information, see Listing and Searching Pending Transactions. If you choose List, skip to step 3. If you use Search, continue on to the next step. The Cost Basis Search page appears. 2. Using the fields provided, type and select your search criteria and then click either Search button. 84 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide The Transfer List page appears. 3. Click the link in the Number Of Assets column for the transaction you want to work with. The Assets List page appears. 4. On the Assets List page, click the Asset Number for the asset that you want to modify. 85 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide The Cost Basis Asset page appears. 5. Modify the asset details as needed, and click Submit. 7.6.3 Deleting Assets You can delete assets via the Assets List page or via the Update Asset page. Notes: • • • When you delete an asset, any tax lots associated with that asset are also deleted. You cannot delete the last asset for a transaction. When you submit transactions in CBRS (after creating new transactions or modifying existing transactions), you are creating or modifying pending transactions that you must then send to DTCC. For more information, see Sending a Batch to DTCC. 86 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide To delete assets via the Assets List page 1. Display the transaction you want to work with. You can use the list function to list all pending transactions, or you can use the search function to search for specific pending transactions. For more information, see Listing and Searching Pending Transactions. If you choose List, skip to step 3. If you use Search, continue on to the next step. The Cost Basis Search page appears. 2. Using the fields provided, type and select your search criteria and then click either Search button. 87 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide The Transfer List page appears. 3. Click the link in the Number Of Assets column for the transaction you want to work with. The Assets List page appears. 4. Click the check box next to one or more assets. To select all assets, click the Select All checkbox. 5. Click Delete. 88 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide To delete assets from the Update Asset page 1. Display the transaction you want to work with. You can use the list function to list all pending transactions, or you can use the search function to search for specific pending transactions. For more information, see Listing and Searching Pending Transactions. If you choose List, skip to step 3. If you use Search, continue on to the next step. The Cost Basis Search page appears. 2. Using the fields provided, type and select your search criteria and then click either Search button. 89 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide The Transfer List page appears. 3. Click the link in the Number Of Assets column for the transaction you want to work with. The Assets List page appears. 4. Click the link in the Asset Number column for the transaction you want to work with. 90 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide The Cost Basis Asset page appears. 5. Click Delete. Note: When you click Delete, the transfer information and all associated assets and tax lots are deleted. 91 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 7.6.4 Viewing and Updating Tax Lots For transactions that you have submitted but have not yet sent to DTCC, you can view and update the tax lots assigned to assets for those transactions. Note: When you submit transactions in CBRS (after creating new transactions or modifying existing transactions), you are creating or modifying pending transactions that must then be sent to DTCC. For more information, see Sending a Batch to DTCC. 1. Display the transaction you want to work with. You can use the list function to list all pending transactions, or you can use the search function to search for specific pending transactions. For more information, see Listing and Searching Pending Transactions. If you choose List, skip to step 3. If you use Search, continue on to the next step. The Cost Basis Search page appears. 2. Using the fields provided, type and select your search criteria and then click either Search button. 92 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide The Transfer List page appears. 3. Click the link in the Number Of Assets column for the transaction you want to work with. The Assets List page appears. 4. On the Assets List page, click the link in the Number of Tax Lots column for the asset that you want to modify. 93 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide The Tax Lot List page appears. 5. Click the link in the Tax Lot Number column for the tax lot that you want to work with. The Cost Basis Tax Lot page appears. 6. Modify the tax lot details as needed, and click Submit. 94 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 7.6.5 Deleting Tax Lots For transactions that you have created but have not yet sent to DTCC, you can delete the tax lots assigned to assets for those transactions. You can delete tax lots via the Tax Lot List page or via the Cost Basis Tax Lot page. You cannot delete the last tax lot for a transaction. Note: When you submit transactions in CBRS (after creating new transactions or modifying existing transactions), you are creating or modifying pending transactions that must then be sent to DTCC. For more information, see Sending a Batch to DTCC. To delete tax lots via the Tax Lot List page 1. Display the transaction you want to work with. You can use the list function to list all pending transactions, or you can use the search function to search for specific pending transactions. For more information, see Listing and Searching Pending Transactions. If you choose List, skip to step 3. If you use Search, continue on to the next step. 95 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide The Cost Basis Search page appears. 2. Using the fields provided, type and select your search criteria and then click either Search button. The Transfer List page appears. 3. Click the link in the Number Of Assets column for the transaction you want to work with. 96 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide The Assets List page appears. 4. On the Assets List page, click the link in the Number of Tax Lots column for the asset that you want to modify. The Tax Lot List page appears. 5. Click the checkbox next to one or more tax lots. To select all tax lots, click the Select All checkbox. 6. Click Delete. 97 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide To delete tax lots via the Cost Basis Tax Lot page 1. Display the transaction you want to work with. You can use the list function to list all pending transactions, or you can use the search function to search for specific pending transactions. For more information, see Listing and Searching Pending Transactions. If you choose List, skip to step 3. If you use Search, continue on to the next step. The Cost Basis Search page appears. 2. Using the fields provided, type and select your search criteria and then click either Search button. 98 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide The Transfer List page appears. 3. Click the link in the Number Of Assets column for the transaction you want to work with. The Assets List page appears. 4. On the Assets List page, click the link in the Number of Tax Lots column for the asset that you want to modify. 99 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide The Tax Lot List page appears. 5. Click the link in the Tax Lot Number column for the tax lot that you want to work with. The Cost Basis Tax Lot page appears. 6. Click Delete. 100 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 7.7 Working With Batches 7.7.1 Sending a Batch to DTCC When you submit transactions in CBRS (after creating new transactions or modifying existing transactions), you are creating pending transactions that must then be sent to DTCC. You can send your pending transactions to DTCC as a single batch. 1. On the CBRS home page, under Data Review/Send, click Send. 101 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide The Send page appears. 2. Click the check box in the Select column next to the product that you want to send. Note: To display a list of transactions in a batch, click the Cost Basis link in the Product column. 3. Click Submit. 4. Wait for the message informing you that the batch was sent to Datatrak. If you do not receive this message, resend the batch. For more information, see Resending a Batch. 102 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 7.7.2 Viewing a Sent Batch You can view the transfer information, asset, and tax lot details for transactions you have sent to DTCC. 1. On the CBRS home page, under Data Review/Send, click Sent Batches. 103 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide The Sent Batches page appears. 2. Click the link in the Batch Number column for the batch you want to view. The Sent Batch page appears with a list of products that were sent in that batch. 3. Click a product to view (in this case, Cost Basis). The Cost Basis List page appears, displaying the basic information about the transactions. 4. Click the link in the Item Number column for the Cost Basis Transfer Information page that you want to view. or Click the link in the Number Of Assets column for the Cost Basis Search List Assets page that you want to view. 104 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 7.8 Verifying That Your File Was Sent Successfully (Using the Confirms Utility) After sending data to DTCC, you can use the Confirms utility to verify that the file was sent successfully. 1. After sending your data, make a note of the batch number displayed on the page. For more information on sending batches, see: Sending a Batch to DTCC Uploading the Spreadsheet 2. Return to the portal page (that is, the page that displays the production products that are available to you). 3. Under Available Production Products, click Utilities. 105 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide The File and Report Utilities page appears. 4. Click Confirms. You should see a link displaying the batch you have submitted. This tells you your batch was submitted. 5. To see if your batch was accepted, click the link. The Confirm Display page appears, providing details about your data submission. CBRS displays either ACCEPTED or REJECTED in the lower-left corner. 106 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 7.9 Resending a Batch 1. On the CBRS home page, under Data Review/Send, click Sent Batches. 107 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide The Sent Batches page appears. 2. Find the correct batch number to resend. 3. Click the appropriate check box in the Re-Send column. 4. Click Re-send. The Sent Batches page appears with a "Batch Number: xxxxxxxxx was resent" message. 7.10 Uploading Records to CBRS As an alternative to using the Transaction Input pages of the CBRS web interface (see Creating Transactions), you can submit your cost basis records to CBRS by: 1) entering your asset and tax lot records into an MS Excel spreadsheet, and then 2) uploading that spreadsheet to CBRS via the web interface. Notes: • Your spreadsheet cannot exceed 1000 rows. • CBRS supports MS Excel 2007 or later (.xlsx). Spreadsheets created with earlier versions may not work. 7.10.1 Overview of the Upload process Start by downloading the most recent version of the spreadsheet template. 108 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide For more information, see Start With the Most Recent Spreadsheet Template. 1. Enter your new assets and tax lots. For more details, see Preparing the Upload Spreadsheet and Example Spreadsheets. 109 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 2. Save the spreadsheet as an Excel Workbook file. 3. On the CBRS Upload page, submit the upload spreadsheet you have created. For more information, see Uploading the Spreadsheet. 110 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 4. If the system rejects your spreadsheet, investigate and correct the errors, and submit the spreadsheet again. For more information, see Reviewing and Correcting Upload Errors. 5. If the system accepts your spreadsheet, the Batch Confirm page appears. For the purpose of future inquiries, make a note of the batch number assigned to your upload. For more information, see Verifying That Your File Was Sent Successfully (Using the Confirms Utility). . 111 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 7.10.2 Start With the Most Recent Spreadsheet Template To prepare spreadsheets for upload, make sure you have the latest version of the spreadsheet template. 1. From the Cost Basis Reporting Service home page, under CBRS Upload, click CBRS Upload Tool. The CBRS Upload page appears. 2. In the Spreadsheet Template section, click the Click to download Spreadsheet Template link. Your computer's response depends on which browser software you are using and how that browser is configured. In the most typical setup, you are prompted to either open or save the file. 112 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 3. To open the file, click Open. 4. To save the file, click Save. After you have downloaded and saved the spreadsheet template (see Start With the Most Recent Spreadsheet Template), you are ready to create new spreadsheets containing new asset and tax lot records. 7.10.3 For earlier versions of MS Excel Note: CBRS supports MS Excel 2007 or later (.xlsx). Spreadsheets created with earlier versions may not work. If you are using a pre-2007 version of MS Excel to create your spreadsheet, you may see a message regarding MS Excel versions when you open the template. If you see this message, click OK to continue opening the template. When you save your spreadsheet, save it in compatibility mode (Click Save As, then choose the compatibility mode option). 113 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 7.10.4 Spreadsheet Template column headers After you open the spreadsheet template, you will notice that it is color-coded. The table below shows what each color signifies. Headings for asset record fields have a blue background. Headings for required asset record fields have a blue background with red text. Headings for tax lot record fields have a beige background. To display hints for a column, move your mouse over any column heading with a red triangle in the upper-right corner. 114 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 7.10.5 The Spreadsheet at a Glance Here are the key points you need to understand when setting up your spreadsheet: • Enter asset details on the left side of the spreadsheet, under the blue column headings. Enter tax lot details on the right side of the spreadsheet, under the beige column headings. • Enter an asset and the first tax lot for an asset on the same row. 115 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide • Use the rows below an asset to add any additional tax lots for that asset. 116 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide • Add additional assets and tax lots as needed. 7.10.6 Tips • Do not insert rows above row 3 (the column headings). • Do not modify the order of the columns. • Do not modify the format of the columns. • Your spreadsheet can have a maximum of 1000 rows. • Use the drop-down menus where available. • For date fields, the required format is MM/DD/YYYY. For example, enter January 3, 2011, as "01/03/2011" (without the quotes). • For participant ID fields, leading zeros are not required. For example, you can enter 000000123 as simply 123. • Not all fields are required. • Some fields are conditional; that is, data from one field may influence whether another field is required. Please consult the CBRS Record Layouts and the CBRS User Guide on the DTCC Learning website for more information about required and conditional fields. 117 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 7.10.7 Adding an Asset With One Tax Lot In this case, you'll enter both the asset and tax lot details on the first row. The asset information appears under the blue headings on the left half of the spreadsheet; the tax lot information appears under the beige headings on the right half of the spreadsheet. 1. In the CBRS Record Type column of the first row, use the drop-down menu to select A (for Asset). 2. Type all of the applicable asset information in the asset columns, identified by the column headings with a blue background. 3. In the same row, scroll to the right and under the beige column headings, type the tax lot details. 118 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 7.10.8 Adding an Asset With Multiple Tax Lots When you are entering an asset with more than one tax lot, you will enter the additional tax lot information below the first tax lot. 1. Type the first asset and tax lot in the first row. See Adding an Asset With One Tax Lot above for more details. 2. For each additional tax lot, do the following: a. In the CBRS Record Type column, use the drop-down menu to select T (for additional tax lots). Note: Please note that the asset fields in this row now appear in blue. Because the asset fields for the additional tax lots are the same as the original asset, you should not retype this information. b. Scroll to the right side of the spreadsheet, and under the beige columns, type the information for the next tax lot. 119 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide c. Repeat steps a and b for each additional tax lot. 7.10.9 Adding Multiple Asset Records You may have a number of assets to upload, some with just one tax lot, some with multiple tax lots. 1. Type the first asset and tax lot in the first row. See Adding an Asset With One Tax Lot above for more details. 2. For each additional asset, do the following: a. In the CBRS Record Type column, use the drop-down menu to select A (for Asset). b. Type all of the asset information in the asset columns, identified by the column headings with a blue background. c. In the same row, scroll to the right side of the spreadsheet, and under the beige column headings, type the information for the first tax lot. 3. For each additional tax lot within a specific asset, do the following: a. In the CBRS Record Type column, use the drop-down menu to select T (for additional Tax lots). Note: Please note that the asset fields in this row now appear in blue. Because the asset fields for the additional tax lots are the same as the original asset, you should not retype this information. b. Scroll to the right side of the spreadsheet, and under the beige columns, type the information for the next tax lot. c. Repeat these steps for each additional tax lot. 120 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 121 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 7.10.10 Adding an Asset Without a Tax Lot (Firm Reject and Request Records Only) If you are submitting firm reject or request records, you can add an asset record on the spreadsheet without a tax lot. For more details, see the CBRS User Guide and Record Layouts. 1. Enter the first asset record and tax lot in the first available row: a. In the CBRS Record Type column, use the drop-down menu to select A (for Asset). b. Type all of the asset information in the asset columns, identified by the column headings with a blue background. 122 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 7.10.11 Example Spreadsheets The examples below demonstrate completed spreadsheets for various scenarios. 7.10.11.1 Example One: An Asset With One Tax Lot The asset information and tax lot information all appear on the same row. The blue headings indicate asset fields; the beige headings indicate tax lot fields. This is the left side of the spreadsheet, with one asset entered: This is the right side of the same spreadsheet, with the one tax lot entered: 123 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 7.10.11.2 Example Two: An Asset With Multiple Tax Lots The asset and the first tax lot appear on one row, followed by the additional tax lots on subsequent rows. For the additional tax lots, the asset fields are filled with blue, indicating this information is the same as the first asset record and should not be retyped. This is the left side of the spreadsheet, with one asset entered and multiple tax lots added: Below is the right side of the same spreadsheet, showing the tax lot details added under the beige column headings. Note that the first tax lot appears on the same row as the asset; each additional tax lot appears on the rows below. 124 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 7.10.11.3 Example Three: Multiple Asset Records Each new asset includes one tax lot record on the same row. Additional tax lot records appear on subsequent rows. Here is the asset side of a spreadsheet with multiple assets: 125 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide Here is the tax lot side of a spreadsheet with multiple assets: 126 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 7.10.12 Uploading the Spreadsheet After you have prepared your spreadsheet (see Preparing the Upload Spreadsheet), you can upload it via the CBRS web interface. CBRS processes the records you upload at the end of the day. 1. From the Cost Basis Reporting Service home page, under CBRS Upload, click CBRS Upload Tool. The CBRS Upload page appears. 2. Click Browse. 3. Locate the spreadsheet on your computer and select it. 127 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 4. Click Submit. CBRS validates your spreadsheet for the following: 1) File type (must be .xls or .xlsx) 2) Number of rows (must be less than 1000) 3) CBRS Record Type (must be A, for asset, or T, for tax lot) 4) Submitting Firm Number and Submitting Firm Type (must match your firm) If all of the records on your spreadsheet do not pass the validation described above, CBRS rejects your spreadsheet and displays a rejection error message. 128 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide If the system accepts your spreadsheet, the Batch Confirm page appears. For the purpose of future inquiries, make a note of the batch number assigned to your upload. When your records reach CBRS, it performs additional validations and produces output to you at the end of the day. Note: After CBRS produces this output, you can use the Cost Basis Inquiry feature that evening or the next business day to view your records. You can also use this feature to research any errors that may have resulted from the validations performed at the end of the day. After you successfully submit your spreadsheet, you cannot view your records until the end-of-day processing has been completed. For more information, see Reviewing and Correcting Upload Errors. 129 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 7.10.13 Displaying Records Uploaded via Spreadsheet After end-of-day processing, CBRS produces its transaction output to various files, such as the Transaction End of Day (EOD) Download file. You can use this file to see the records you submitted, as well as the records you received. You can also use the Cost Basis Inquiry search function to verify that the records you submit via spreadsheet upload have made it to the CBRS database. For example, you can create a search using "System Rejected" or "System Accepted" as selection criteria, as shown in the image below. For detailed instructions on how to search your records on the CBRS database, see Searching CBRS Transactions. Note: When you submit CBRS transactions via spreadsheet upload, those records go directly to the CBRS mainframe database. You cannot view or modify these records in pending status as you can with transactions that you enter via manual data entry on the Cost Basis Input page. 7.10.14 Modifying Uploaded Information To modify details for any records that you have already uploaded, simply resubmit those records on a new spreadsheet. You cannot use the Transaction Input pages of CBRS web interface to edit the records you have uploaded via spreadsheet. For more details, see Preparing the Upload Spreadsheet. Note: Because these records have already been submitted to the CBRS mainframe database, you should resubmit your records using the code for corrected records ("02") in the Record Content Indicator column. 130 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 7.10.15 Verifying That Your File Was Sent Successfully (Using the Confirms Utility) After sending data to DTCC, you can use the Confirms utility to verify that the file was sent successfully. 1. After sending your data, make a note of the batch number displayed on the page. For more information on sending batches, see: Sending a Batch to DTCC Uploading the Spreadsheet 2. Return to the portal page (that is, the page that displays the production products that are available to you). 3. Under Available Production Products, click Utilities. The File and Report Utilities page appears. 131 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 4. Click Confirms. You should see a link displaying the batch you have submitted. This tells you your batch was submitted. 5. To see if your batch was accepted, click the link. The Confirm Display page appears, providing details about your data submission. CBRS displays either ACCEPTED or REJECTED in the lower-left corner. 132 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 7.10.16 Reviewing and Correcting Spreadsheet Errors 7.10.16.1 Errors You Will See Immediately Upon Submission When you upload transactions via spreadsheet, CBRS immediately checks for the following: 1) File type (must be .xls or .xlsx) 2) Number of rows (must be less than 1000) 3) CBRS Record Type (must be A, for asset, or T, for tax lot) 4) Submitting Firm Number and Submitting Firm Type (must match your firm) When the errors shown above are found, CBRS displays an error message on the web interface. To correct the errors, modify the information as needed on your spreadsheet and repeat the upload process. Note: Because these records have not yet been submitted to the CBRS mainframe database, you should resubmit your records using the code for original records ("01") in the Record Content Indicator column. 7.10.16.2 Errors You Will See After End-of-Day Processing For transactions on spreadsheets that pass the initial validation, CBRS performs additional validations at the end of the day. During end-of-day processing, CBRS checks for badly formatted data, incorrect or missing data, etc. To see any errors generated by end-of-day processing, you can look at the Transaction End of Day (EOD) download file. You can use this file to see the records you submitted as well as the records you received. 133 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide You can also use the Cost Basis Inquiry search to display errors generated by end-of-day processing. For example, to display all of your transactions that were system rejected, you can create a search that specifies a System Status of "System Rejected" (see the image below). When you display the CBRS Asset Detail or the CBRS Tax Lot Detail pages, CBRS provides details about the error condition that you need to correct. Here is an example of the CBRS Asset Detail page for an asset record with errors: 134 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide Here is an example of the CBRS Tax Lot Detail page for a tax lot record with errors: For more information on how to use the Cost Basis Inquiry, see Searching CBRS Transactions. For more information on System Reject Reason and Status codes, please see the CBRS User Guide and the CBRS Record Layouts on the DTCC Learning website. To correct the errors, upload a spreadsheet containing the corrected records. You can upload only the transactions you want to correct, or you can upload all of your transactions. Note: Because these records have already been submitted to CBRS, you should resubmit your records using the code for corrected records ("02") in the Record Content Indicator column. 7.11 Searching CBRS Transactions You can search the Cost Basis Reporting System database in two ways: • Quick Search: Specify a CBRS control number • Advanced Search: Enter a combination of search criteria You can display only those transactions for which your firm is either the submitter or receiver. The transactions that match your search criteria appear on the bottom half of the page. When a transaction has more than one asset, CBRS displays each asset on a separate row. After displaying your search results, you can display details for specific assets and for the tax lots associated with those assets. Cost Basis Inquiry screens, including the download function, may not be available when the application is processing records. This processing occurs four times per day, at approximately 9:15 AM, 11:15 AM, 1:15 PM, and 4:15 PM eastern time. At these times you may not be able to use the inquiry or inquiry download functions. The screens automatically become available again when 135 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide processing is complete. If you encounter an error at approximately these times, please wait and try your inquiry again at a later time. 7.11.1 Quick search 1. On the CBRS home page, under Transaction Inquiry, click Cost Basis Transaction Inquiry. 136 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide The Cost Basis Transaction Inquiry page appears. 2. In the Quick Search section, type the CBRS Control Number. 3. Click Search. The Cost Basis Transaction Inquiry page updates to display your search results, one row for each asset found for the transaction(s) that match your search criteria. 4. To download data associated with the transaction displayed, click the selection box(es) for specific assets and then click Download Selected Items. Your data will become available for download via the Data Files page. For more information, see Viewing Cost Basis Files. 137 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 5. To view the data associated with a displayed transaction, click the CBRS Control Number link next to that transaction. The CBRS Asset page appears. 6. From the CBRS asset page, you can view either the detailed asset record or the associated tax lot(s). To view the detailed asset record, click Asset Details. To view the associated tax lot(s), click a link in the Tax Lot Sequence Number column. When you click Asset Details, the CBRS Asset Detail page appears. To export this data to Excel, click Export to Excel. When you click a link in the Tax Lot Sequence Number column, the CBRS Tax Lot Detail page appears. To export this data to Excel, click Export to Excel. 138 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 139 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 7.11.2 Advanced search 1. On the CBRS home page, under Transaction Inquiry, click Cost Basis Transaction Inquiry. 140 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide The Cost Basis Transaction Inquiry page appears. 2. Using the fields provided in the Advanced Search section, enter your search selection criteria. 3. Click Search. 141 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide CBRS displays your search results in the lower portion of the page. CBRS displays one row for each asset found for the transactions that match your search criteria. 4. To download data associated with the transaction displayed, click the selection box(es) for specific assets and then click Download Selected Items. Your data will become available for download via the Data Files page. It takes approximately 15 to 60 minutes to create the file, depending on the amount of data in the request. For more information, see Downloading Cost Basis Files. 7.11.3 Displaying asset and tax lot details 1. Complete either a quick search or an advanced search. See above for details. Note that CBRS displays one row for each asset found for the transactions that match your search criteria. 142 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 2. On the Cost Basis Transaction Inquiry page, in the search results section, in the row for the asset that you are interested in, click the CBRS Control Number. The CBRS Asset page appears. The CBRS Asset page displays information for the asset you chose, along with a list of tax lots submitted for that asset. 3. To download data associated with the tax lots displayed, click the selection box(es) for specific tax lots and then click Download Selected Items. Your data will become available for download via the Data Files page. It takes approximately 15 to 60 minutes to create the file, depending on the amount of data in the request. For more information, see Downloading Cost Basis Files. 4. From the CBRS Asset page, you can display additional asset details or tax lot details: • • To display additional asset details, click Asset Details. The CBRS Asset Detail page appears, displaying additional asset details, including the edit status for each field. Note: To open an Excel spreadsheet displaying the information on the Asset Details page, click Export to Excel. To display tax lot details, in the Tax Lot List section, click the link in the Tax Lot Sequence Number column for the tax lot that you are interested in. The CBRS Tax Lot Detail page appears, displaying additional tax lot details, including the edit status for each field. Note: To open an Excel spreadsheet displaying the information on the CBRS Tax Lot Detail page, click Export to Excel. 143 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 7.12 Searching for a CBRS User 7.12.1 Searching for an Active CBRS Account 1. On the CBRS home page, under Data Inquiry, click Cost Basis User Inquiry. The Cost Basis User Inquiry page appears. 2. You must type the Firm Number and select the Firm Type. 144 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 3. Click Search. The Cost Basis User Inquiry page updates to display your search results. The results display the Active Firm that matches your search criteria. 145 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 7.12.2 Searching for an Inactive CBRS Account 1. On the CBRS home page, under Data Inquiry, click Cost Basis User Inquiry. When the Firm Number is not known, then populate the Firm Number with the Inactive account number known and select the appropriate Firm Type. 2. If the inactive account is a FED number and short name combination being used to find the active CBRS Account number, then populated the Account number with the Fed number and select one of the associated Fed Short Names from the pull down menu. 146 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 3. The results returned will display the CBRS Account number 147 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 7.13 Downloading Cost Basis Files You can view and download reports. You can also download data sets that you have requested via the Cost Basis Inquiry page. For more information, see Searching CBRS Transactions. If your firm subscribes to AutoRoute products for direct delivery of machine readable output (MRO) files, then you cannot take the Web MRO. 1. On the CBRS home page, under CBRS Output, click Cost Basis Output Files. 148 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide The Data Files page appears. 2. In the drop-down menu provided, select the firm number and firm type. 3. Click Submit. CBRS displays the following reports, depending on which files you have subscribed to receive: • Transaction Request WebDirect Download: Firms can use the transaction inquiry function to search and view specific transactions using various criteria, such as ISIN, transfer control number, or Transaction Type. They can then download these requested transactions to Excel. This file contains these specifically requested transactions in Excel format. • Transaction End of Day (EOD) Download: This file contains all transactions for the current processing day in Excel format. It contains the same information provided in the Transaction Machine Readable Output (MRO) report for that day. 149 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide • Cost Basis User Master File WebDirect Download: This file provides a listing of the firms that are active users of CBRS in tilde-delimited format for converting to Excel. • Daily Deposit File for Equity Transfer Agents: For equity transfer agents only. This file contains the deposits for that Transfer Agent for that day, so they know for which deposits they can expect to send cost basis. The file is available through WebDirect or on the mainframe for retrieval via the Data Transmission Facility (DTF) function DPCBRS. • Daily Reorg Deposit File for Equity Transfer Agents: For equity transfer agents only. This file contains the reorg deposits for that transfer agent for that day, so they know for which reorg deposits they can expect to send cost basis. The file is available through WebDirect or on the mainframe for retrieval via the Data Transmission Facility (DTF) function DRCBRS. Note: The Transaction Request Download file contains the data you downloaded using the quick search or advanced search functions (see Searching CBRS Transactions). After you request the download, it takes approximately 15 to 60 minutes to create the file, depending on the amount of data in the request. 9. Click the File Name of the file or report that you want to download. 150 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide Internet Explorer prompts you to either open or save the file. 4. Click Save. 151 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide The Internet Explorer Save As dialog window appears. 5. Use the navigation tools to select a location on your system for the file. 6. In the Save As window, perform these steps: a. Using the navigation tools provided, choose a location on your system to store the file. For example, you can choose to save the file on your desktop. b. In the File name field, you can leave the existing file name or enter a new one. c, In the Save as type field, leave the type set to ".mro." d. Click Save. 152 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 7. To open the file in MS Excel, follow these steps: a. Launch MS Excel. b. Under the Office button, click Open, and then navigate to the location on your system where you have saved the file. Note: In the Open window, in the Files of type: field, select "All Files(*.*)." c. After locating your file, select it and then click Open. 153 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide The MS Excel Text Import Wizard - Step 1 of 3 window appears. 8. To finish importing the file, follow these steps: a. In the Original data type section, choose Delimited and click Next. 154 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide The MS Excel Text Import Wizard - Step 2 of 3 window appears. b. In the Delimiters section, de-select Tab, then select Other, and type a ~ (tilde) in the space provided. c. Click Finish. The downloaded file opens in MS Excel. 9. If you wish, save and name the file on your system. 7.14 Size Limit for Transaction Download Files CBRS will produce the Transaction Request and Transaction EOD (end of day) Download files only when the number of records (combined asset and tax lot records both received and submitted) per file is less than 3,000. If a file exceeds this size, CBRS will not create it. Note: Firms that expect to exceed this maximum need to be able to take in the Transaction Machine Readable Output (MRO) file (Autoroute #02400264 in Production and #02980264 in Test). 155 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 7.15 Time Frames for Files and Data Availability Files are stored in WebDirect for four days. Data is available for viewing on WebDirect screens, using the Cost Basis Inquiry screen, and downloading to an Excel spreadsheet, for twenty-five business days. After the twenty-five business day window has passed, DTCC will not be able to provide CBRS data to users. Users are responsible for storing their data on a long-term basis. 7.16 WebDirect data entry on weekends and holidays Data entered on a weekend or holiday is processed by CBRS on the next valid processing date. For example, a user submits CBRS records via WebDirect on Memorial Day, Monday, May 28. CBRS holds these submitted records, and processes them on Tuesday, May 29. The records submitted on Monday are a part of the output produced on Tuesday. 156 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 8 Joining the Service All financial intermediaries are eligible to apply to use CBRS, including firms who are not currently members of any DTCC subsidiary. Instructions on how to open a CBRS Account, and the necessary forms, are available on DTCC’s website at: http://www.dtcc.com/clearing-services/equities-clearing-services/cbrs/client-center/publicdocuments.aspx http://www.dtcc.com/clearing-services/equities-clearing-services/cbrs/client-center/publicdocuments.aspx The forms required to become an eligible user of CBRS depends on a firm’s existing relationship with DTCC. The instructions specify the forms that are required in each situation (DTC Participant, DTC Limited Participant utilizing the Direct Registration Service, NSCC Participant, or no relationship to any DTCC subsidiary). ? What date should I put as the effective date in the Service Add letter? The effective date in the Service Add letter is the date your firm will be ready to use CBRS in the production environment. This is not the date when your firm will start testing. After you complete the new account process, you will hear back from DTCC that you are eligible to use CBRS. As soon as you are eligible and have set up your access to the system, you can start testing. You can test any time up to when you start in Production, and also past that date as well. There is no end date for testing. As of the effective date, the user will be on the CBRS Master File in Production. Counterparties expect that if you are on that Master File, at a minimum you are able to accept the records sent to you. ? I am a Transfer Agent and would like to make my LPA number eligible for CBRS. How do I do that? You need to follow the CBRS New Account process to make the LPA number eligible for CBRS, even if you have one or more Transfer Agent numbers that are already eligible for CBRS. Please see the CBRS User Documentation webpage for the New Account Instructions and forms: http://www.dtcc.com/clearing-services/equities-clearing-services/cbrs/client-center/publicdocuments.aspx 8.1 Multiple Output File Set-up If your company has both a broker-dealer side and a mutual fund company side, with different participant numbers, you can receive separate output files for the different numbers. The standard set-up is to receive one file, but if you prefer to receive two files please contact your relationship manager and DTCC will adjust the set-up accordingly. 8.2 CBRS Billing Fees for CBRS records are charged per Asset record. There is no charge for Tax Lot records. 157 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide Because CBRS is a service offering of DTCC Solutions LLC, the CBRS invoice is issued separately from an NSCC or DTC invoice. System users receive one invoice per CBRS account. If a firm has multiple CBRS accounts, it receive multiple CBRS invoices; for example, if a firm has three CBRS accounts, it receives three CBRS invoices. DTCC distributed CBRS invoices on the 7th business day of the month. Invoices are available via email and through DTCC’s online billing system. Please contact your Relationship Manager for questions about your CBRS bill. ? How do I pay for CBRS? A company that has a settlement account uses its settlement account to pay the balance on its CBRS invoice. A company that does not have a settlement account pays by wire: wire instructions are on the invoice. 158 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 9 User Testing Users must complete the CBRS new account forms to become eligible for the service in both testing and production. To be an eligible CBRS user, a firm needs to complete all the required CBRS new account forms and return them to DTCC. The CBRS new account instructions and forms are located at the following link: http://www.dtcc.com/clearing-services/equities-clearing-services/cbrs/client-center/publicdocuments.aspx DTC Participants can expect to receive their new CBRS account in approximately three to five business days after DTCC has received the forms. All other firms are subject to additional compliance screening which extends the amount of time to establish a new account. In these cases, DTCC’s Account Administration group will contact each firm as it moves through the approval process. Once a user establishes its CBRS account and connectivity to the system (either via computer to computer connection, WebDirect, or both), there are multiple resources available to test data input and output to CBRS. ? How do I know which CBRS users are eligible to test? The version of the CBRS master file (whose technical name is the “Cost Basis User Master File”) that is available in the test environment lists all CBRS users who are eligible to test. The master file has a column named “CBRS Account Start Date.” This date corresponds to the date the CBRS user is eligible to use the service in the production environment. All CBRS users who are on the master file in the testing environment are eligible to test. 9.1 Testing data input A user can test data input by using three different counterparties: itself; test accounts, or a testing partner. To test with itself, a firm uses its Firm Account Number from the Cost Basis User Master File (or CBRS User Account Number if it does not have a Firm Account Number) as both the Submitting Firm Number and Type and Receiving Firm Number and Type in the CBRS input record layouts (both Asset and Tax Lot records). Some Transaction Types have requirements for Submitting Firm Type and Contra Firm Type, so if you test with yourself, you will only be able to test the Transaction Types that permit your Firm Type. To test with a test account, a firm uses its Firm Account Number from the Cost Basis User Master File (or CBRS User Account Number if it does not have a Firm Account Number) as the Submitting Firm Number and a test account number as the Receiving Firm Number in the CBRS input record layouts (both Asset and Tax Lot records). 159 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide The CBRS test accounts are: • • • • • DTC Participant: 00008608 DTCPRT DTC Participant: 00008610 DTCPRT NSCC Participant: 00000122 NSCPRT NSCC Participant: 00000123 NSCPRT Transfer Agent: 00036165 AGTNBR o The test Transfer Agent account has two CUSIPs associated with it: 99999X037 and 99999Z024 To test with a testing partner, a user can locate a partner on the list of eligible CBRS users on the Cost Basis User Master File. Once a user has found a testing partner, it uses its Firm Account Number from the Cost Basis User Master File (or CBRS User Account Number if it does not have a Firm Account Number) as the Submitting Firm Number, and uses the testing partner’s Firm Account Number (or CBRS User Account Number if it does not have a Firm Account Number) as the Contra Firm Number in the CBRS input record layouts (both Asset and Tax Lot records). Firms can test the following DTC transactions in the testing environment (the “U region”): • Deposits • Branch Deposits • DWAC (to test a DWAC, a broker-dealer should coordinate the test with a transfer agent, so the agent can approve the test transactions) It is not possible to test DRS or Withdrawal by Transfer (NWT1 or RWT1) transactions in the U region. 9.2 Testing data output CBRS transaction output and the Daily Deposit File for Transfer Agents are available by 9 PM ET. The Cost Basis User Master File is available by 11 PM ET. On the CBRS transaction output, a firm receives the records it submitted, and the records it received from a testing partner, if applicable. 1 9.2.1 Details about testing the Daily Deposit File for Transfer Agents When a Transfer Agent joins CBRS, it can request to receive the Daily Deposit File for Transfer Agents through DTF, by having signed on to the DPCBRS function using their M or N sign-on. Transfer agents will also be able to download this file through WebDirect. DTCC will create two different versions of the Daily Deposit File in the testing environment. On Mondays, the contents of the file will be the data submitted to Production on the previous Friday. On Tuesday through Friday, the contents of the file will be the deposit transactions submitted 1 There is one situation when a firm does not receive a submitted record on the transaction output file. CBRS drops a transaction on the rare occasion when a submitter enters their firm number incorrectly, and CBRS does not recognize the submitter. In this case, CBRS rejects the record because the submitter is invalid. However, CBRS cannot return the record to the submitter because the incorrect submitter number does not match the submitter’s actual number, so CBRS does not know where to return the record. 160 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide through the testing environment over the course of the previous week, if any. Please note that in order for a deposit to appear on the file on Tuesday through Friday, a DTC participant must enter a deposit through the testing environment. A transfer agent should arrange to have a DTC participant testing partner enter deposits into the testing environment for a CUSIP or CUSIPs specific to that agent. The following table illustrates the timing of the contents of the Daily Deposit file for testing: For Production Data: Week 1 Week 2 Monday Tuesday Wednesday Thursday Friday DTC Participants enter deposits into Production Deposits from the previous Friday (not the other four days in Week 1) are in the file DTC Participants enter deposits into Production No production data in file DTC Participants enter deposits into Production No production data in file DTC Participants enter deposits into Production No production data in file DTC Participants enter deposits into Production No production data in file Monday Tuesday Wednesday Thursday Friday DTC Participants enter transactions into Test No test data in file DTC Participants enter transactions into Test File contains test data from all five days in Week 1 DTC Participants enter transactions into Test File contains test data from all five days in Week 1 DTC Participants enter transactions into Test File contains test data from all five days in Week 1 DTC Participants enter transactions into Test File contains test data from all five days in Week 1 For Test Data: Week 1 Week 2 9.2.2 Canned transaction output file Four versions of a canned transaction output file are available in the testing environment. A canned file contains static data that firms can use for testing. The canned output file serves as a sample of what CBRS transaction output looks like. The four versions correspond to the kind of firm receiving the file: there is one file for a broker-dealer, one for a transfer agent, one for a bank, and one for a mutual fund company. The contents of the different versions, such as the Transaction Types, vary based on the kind of receiver. When requesting the canned file, please indicate the number that corresponds to your user type: • • • • 02991797 for a bank 02991798 for a broker-dealer 02991119 for a mutual fund 02991796 for a transfer agent . 161 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 10 Appendix A: List and description of file identification numbers 10.1 CBRS input SYS ID numbers The input SYS ID numbers for CBRS are # 36708 for Production, and # 46708 for the Participant Services Environment (PSE) for testing. 10.2 List of CBRS output file identification numbers The table below contains a list of the various CBRS and CBRS-related files, and their file identification numbers, a/k/a product numbers. File Transaction Machine Readable Output (MRO) Transaction Request Download Transaction End of Day (EOD) Download Cost Basis User Master File Machine Readable Output (MRO) Cost Basis User Master File WebDirect Download Daily Deposit File for Transfer Agents WebDirect Download Daily Reorg Deposit File for Transfer Agents WebDirect Download Test Number 02980264 02981663 02981664 02981666 02981667 02981649 N/A Production Number 02400264 02401663 02401664 02561666 02561667 02401649 02401912 The canned file for testing has different numbers depending on what type of user is receiving the file. When requesting the canned file, please indicate the number that corresponds to your user type: • • • • 02991797 for a bank 02991798 for a broker-dealer 02991119 for a mutual fund 02991796 for a transfer agent 10.3 Description of the CBRS output files Transaction Machine Readable Output (MRO). For computer to computer connection users. This file contains all CBRS transaction output for the firm for the current processing date. (While this file is intended for computer to computer connection users, it is also available for WebDirect users to download using the CBRS Output Files function.) Transaction Request WebDirect Download. For WebDirect users. Firms can use the “transaction inquiry” function to search and view specific transactions using various criteria, such 162 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide as ISIN, Transfer Control Number, or Transaction Type. They can then download these requested transactions to Excel. This file contains these specifically requested transactions in Excel format. Transaction End of Day (EOD) Download. For WebDirect users. This file contains all transactions for the current processing day in Excel format. It contains the same information provided in Transaction Machine Readable Output (MRO) for that day. Cost Basis User Master File Machine Readable Output (MRO). For computer to computer connection users. This file provides a listing of the firms that are active users of CBRS in MRO format. (While this file is intended for computer to computer connection users, it is also available for WebDirect users to download using the CBRS Output Files function.) Cost Basis User Master File WebDirect Download. For WebDirect users. This file provides a listing of the firms that are active users of CBRS in tilde-delimited format for converting to Excel. Daily Deposit File for Equity Transfer Agents. For Equity Transfer Agents only. This file contains the deposits for that Transfer Agent for that day, so they know for which deposits they can expect to send cost basis. The file is available through WebDirect, or on the mainframe for retrieval via Data Transmission Facility (DTF) function DPCBRS. Daily Reorg Deposit File for Equity Transfer Agents. For Equity Transfer Agents only. This file contains the reorg deposits for that Transfer Agent for that day, so they know for which reorg deposits they can expect to send cost basis. The file is available through WebDirect, or on the mainframe for retrieval via Data Transmission Facility (DTF) function DRCBRS. 163 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 11 Appendix B: List of valid characters for CBRS 'A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z', 'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j', 'k', 'l', 'm', 'n', 'o', 'p', 'q', 'r', 's', 't', 'u', 'v', 'w', 'x', 'y', 'z', '1', '2', '3', '4', '5', '6', '7', '8', '9', '0', '!', '@', '#', '$', '%', '&', '*', '(', ')', '-', '_', '+', '=', '~', '{', '}', '¢', '\', ':', ';', '"', '<', '>', ',', '.', '?', '/', ' ', "'", '`'. 164 DTCC non-Confidential Green Version 4.1 , dated March 2015 CBRS User Guide 12 Disclaimer and Copyright Notice The primary purpose of this User Guide is to familiarize members with the Cost Basis Reporting Service product offered by DTCC. This guide is not intended to serve as a legal document. No statement in this guide should be construed as a legally binding rule or regulation, or as creating an obligation on the part of DTCC or any person. In addition, any time schedules or time requirements set forth herein are subject to change without notice. This service is governed by applicable Rules, Procedures, and Service Guides for the Cost Basis Reporting Service, which contain the full terms, conditions, and limitations applicable to this service. Copyright © 2012 165 DTCC non-Confidential Green Version 4.1 , dated March 2015
© Copyright 2024