US Municipal New Issues (TE)  
   
   
   
Description Code Definition
----------- ----
501(C)3 status FIVE01C3 Section 501(c)(3) of the Internal Revenue Code: To be tax-exempt as an organization described in section 501(c)(3) of the tax code, an organization must be organized and operated exclusively for one or more of the purposes set forth in the 501(c)(3) and none of the earnings of the organization may inure to any private shareholder or individual. The most common exempt organizations include, charitable, religious, educational, scientific, and literary organizations. 
8 digit CUSIP (Cusip search only) CUSIP8 8-digit CUSIP: 8-digit CUSIP representing an individual maturity of an issue. Number identifying registered bonds, using the Committee on Uniform Securities Identification Procedures (CUSIP). The CUSIP system makes it easier to settle and clear trades.
9 digit CUSIP (Cusip search only) CUSIP9 9-digit CUSIP: 9-digit CUSIP representing an individual maturity of an issue. Number identifying registered bonds, using the Committee on Uniform Securities Identification Procedures (CUSIP). The CUSIP system makes it easier to settle and clear trades.
All managers MANAGERS_NOACQ Managers: List of members of the underwriters' management syndicate starting with the lead manager. 
All managers MGR_ALL Managers: List of members of the underwriters' management syndicate starting with the lead manager.
All Use of Proceeds - Bond Buyer (Code) BB_UOP_CODE_MANY
All Use of Proceeds - SDC (Number) MUNI_UOPNUMBER The code number corresponding to the use of proceeds for the issue as defined by Securities Data Company. 
Amount at Maturity (Thomson Researched) MATURAMOUNT The par amount plus the compounded interest in a Zero-Coupon issuance.
Amount of Final Maturity (US$ mil) FINAMT Final Maturity Amount: Amount of final term maturity or final range of serial maturities. ($ Mils)
Amount of Maturity (US$ mil) AMTMATY Maturity Amount: The amount of any term maturity or range of serial maturities. ($ Mils)
Amount per Each Use of Proceeds MUNI_UOPAMT The specific amount allocated to each use of proceeds for a particular issue. ($ Mils)
Anticipation Type ANTIC Anticipation Security Type: Short term securities issued by a state or municipality funded by the anticipation of expected revenues and or tax receipts. A= BANs, B= RANs, C= TANs, D= TRANs, E= Other Anticipation.
Asset-Backed Indicator Flag (Y/N) ABS_FLAG Asset Backed Security Flag: Asset-backed securities, called ABS, are bonds or notes backed by financial assets. Typically these assets consist of receivables such as credit card receivables, auto loans, manufactured-housing contracts, and home-equity loans.
Auction Rate Flag AUCTIONRATE Auction Rate Flag: A flag indicating that the variable rate issuance's interest rate is to be determined by an auction.
Average life AVLF Average Life: The number of years from the dated date when half of the issue will have been redeemed through amortization or sinking fund payments. Computed as sum of the years to maturity of each bond divided by the total number of bonds.
Bank Eligible BANKEL Bank Eligible: A Yes/No flag identifying issues which may be underwritten by commercial banks according to the Glass-Stegall Act of 1933. Under this act, commercial banks were prohibited from investment banking activities, such as underwriting municipal revenue bonds or corporate securities.
Bank Qualified BANKQ Bank Qualified: A Yes/No flag indicating when banks may deduct 80% of the cost of purchasing and holding a bond because the issuer intends to sell no more than $10 million in bonds annually.
Beginning Serial /Term Coupon BCPN Beginning serial coupon: The coupon rate of the first serial maturity or term bond(s).
Beginning Serial /Term Maturity Date BMAT Beginning serial maturity date: The maturity date of first serial maturity or term bond maturities(s).  A # indicates additional serial maturities.
Beginning Serial /Term Yield BPYLD Beginning serial/term yield: The Price/Yield of first serial maturity or term bond.
Beneficiary's Counsel COCNSL_ALL Counsel to the Beneficiary: The full name of the legal counsel retained by the corporate beneficiary.
Bid Type BID Type of Bid: A proposal to purchase an issue of bonds offered for sale either in a competitive offering (C), negotiated basis (N) or a private placement (P).
Bond Buyer general obligation index BBGO Bond Buyer General Obligation Index: Weekly Index reflecting the yield on a general obligation bond with 20-year maturity. This index is based on estimates from dealers and is derived from the bonds of 20 actual issuers with an average rating equivalent to Moody's Aa3 and S&P's AA.
Bond Buyer revenue index BBREV Bond Buyer Revenue Index: Weekly index reflecting the yield on a 30-year revenue bond. This index is based on bonds from 25 issuers covering a variety of purposes. The average rating on these issues is equivalent to Moody's A1 and Standard and Poor's A+.
Bond Counsel BC_ALL Bond Counsel: The law firm(s) retained by the issuer to prepare a legal opinion on the issue.  The firm typically makes a judgement on the issue's tax exemption and confirms that the issuer has met all legal requirements for issuance.
Book entry BKENTRY Book Entry: A Yes/No flag identifying a security which is not available to purchasers in physical form but rather registered through electronic computerized entries in participants accounts; no certificates change hands.
Callable Issue CALLFLAG Callable: A Yes/No flag indicating optional redemption by the issuer. The issuer has the option to buy back the bond prior to the stated maturity date at a specified price. 
Co-managers COMANAGERS_NOACQ Co Managers: Queryable only data item for finding members of the management group excluding the lead manager.
College saver SPECISS Special Issue: College Saver program issue.
Commercial Bank Managed BANKMGD Bank Managed: A Yes/No flag identifying issues lead or co-managed by commercial banks.
Commercial paper CP Commercial Paper: A Yes/No flag indicating very short term, unsecured promissory notes maturing in less than 270 days. At maturity, the commercial paper can be paid off or rolled over into a new commercial paper issue. Bank letter of credit or some other liquidity provision typically backs commercial paper. Most Commercial paper issues have an average maturity of 30-45 days and are issued in large denominations, typically in multiples of $100,000.
Composite Amount COMP Composite Amount: Sum of par amounts of related issues considered a single issue by the issuer. ($ Mils)
Conversion Date CONVDATE_ALL Conversion Date: Date on which appreciator/zero coupon bond converts to a fixed rate bond.
Corporate/Non-Corporate CNC CNC: Indicates whether a beneficiary is a Corporate (C), Limited Liability (L), or Non-Corporate Entity (N). To select corporate-backed issues, select Corporate and Limited Liability types. 
County COUNTY_UPPER County: County of the Issuer.
Coupon at Maturity (Thomson Researched) COUPONMATY Coupon of each individual maturity.
Coupon of Any Term Maturity or First Serial Maturity CPNMATY Coupon: Coupon of any term maturity or first serial maturities in ranges of serial maturities.
Coupon of Final Maturity of Issue FINCPN Final Maturity Coupon: Coupon of final term maturity or final serial maturity in final range of serial maturities.
Coupon Type COUPONTYPE_ALL Coupon Type: Type of Interest Rate/Coupon. This can be either A = Auction Rate Securities, F = Fixed, V= Variable, VS= Variable Rate Short, VL= Variable Rate Long, Z= Zero Coupon, L= Linked Rate, or C= Convertible.
Credit Enhancement Type CETYPE_ALL Credit Enhancement Type: Refers to the type of enhancement guaranteeing the repayment of principal and/or credit of certain deals.  Credit Enhancement Types include Bond Insurance, Certificate of Deposit, Collateralized, Guaranteed, Guaranteed Investment Contract, Investment Agreement, Letter of Credit: Foreign Bank; Letter of Credit: Domestic Bank, Mortgage Backed, Private Mortgage Insurance, Surety Bond.
Credit enhancer CE_NOACQ Credit Enhancer: Queryable TFSD code for the firm offering credit enhancement.
Date Deal was Added ADDATE Add Date: The date when a deal was added to the TFSD database.
Date Deal was Last Updated in SDC Database UPDATE_STAMP Update Stamp: Date of last update on an issue by a TFSD analyst.
Dated Date DATDATE_ALL Dated Date: Date from which interest accrues on the issue.
Dates of All Maturities BOTHMAT_MATY Dates of all maturities: The maturity dates of first serial maturities and all term bonds of an issue. This data item is valid only for issues which sold prior to 10/14/1999.
Days to Delivery Calculator DELCALC Days to Delivery Calculator: Calculates the difference between the sale date and the delivery date.
Deals with Profors/Obligors (Y/N) CORPORATE_BACKED Deals with Profors/Obligors (Y/N): Indicates that the municipal issue has a beneficiary that is liable for generating the revenue that has been pledged to repay the bonds. Profors can be corporate, non-corporate or LLC entities
Delivery Date DELDATE Delivery Date: Date on which the securities are delivered in exchange for payment of the principal amount.
Denomination DENOMIN Denomination: Par value represented by a particular securities certificate.
Derivative Type DERIV Derivative: Product that derives its value from another security, asset or index. (For example, IF= Indexed Floaters, DT= Detachable Call Options, LF= Linkable/Auction Floaters, LI= Linkable Inverse Floaters, IC= Indexed Caps, FS= Forward Swaps, IS= Interest Rate Swaps.) NOTE: TFSD will only include derivative features of primary market new issues.
Disclosure Counsel DISCL_COUNSEL Disclosure Counsel: The law firm on a deal hired to ensure that accurate and complete information on a securities transaction has been made available to potential investors.
Double Barreled Flag (Y/N) DOUBLE_BARRELED Double Barreled Flag: Indicates that both a revenue source and the full faith and credit of an issuer have secured the deal.
DTC eligible DTC Depository Trust Company: A Yes/No flag indicating eligibility for registration with the Depository Trust Company as clearing agency. The DTC acts as a central securities repository where bond certificates are exchanged. Most of the exchanges now take place electronically, and few paper certificates actually change hands. The DTC is a member of the Federal Reserve System.
Education Type EDTYPE Education Type: Type of College or University acting as beneficiary, such as: Public or Private.
Electronic Bidding Flag (Y/N) E_BID Electronic Bidding:  Indicates that bidders have the option to bid on the competitive deal through an electronic systems.
Electronic Bidding System E_BID_SYSTEM Electronic Bidding System:  Indicates the type of electronic bidding system used in the bidding process:  Bloomberg (B), MuniAuction (MA), Non-Exclusive (NE), or Parity (T).
Ending Serial Coupon ECPN Ending Serial Coupon: Coupon of ending serial maturities in ranges of serial maturities.
Ending Serial Yield EPYLD_ALL Ending Serial Yield: The yield or the price of ending serial maturities in ranges of serial maturities.
Expenses EXP Expenses (Gross Spread Component): Expenses are costs incurred by the issuer paid to the underwriter during the development of the financing package and the actual sale of the bonds. The expense portion represents the physical costs of running the syndicate including travel, printing costs, and the underwriter's legal fees.
Extraordinary Redemption EXDATE Extraordinary Redemption: Yes/No flag indicating option of issuer to call or redeem an issue upon the occurrence of certain events. For example, a mortgage revenue bond may be subject to an extraordinary call if the issuer is unable to originate mortgages to homeowners because mortgage rates have dropped sharply, making the issuer's normally below-market mortgage interest rate suddenly higher than market rates.
Final Maturity Date FINMATY Final Maturity Date: Maturity date of final term maturity or final serial maturity in final range of serial maturities.
Final Maturity Year FINMAT Final Maturity Year: Maturity year of final term maturity or final serial maturity in final range of serial maturities.
Financial Advisor FA_NOACQ Financial Advisor: Consultant who advises the issuer on matters related to the issue such as deal structure, timing, marketing, pricing and bond ratings.
First Call Date CALLDATE_ALL Call Date: First optional redemption date on which a bond may be repaid before maturity.
First Interest Payment Date CPNDATE_ALL Coupon Date: First interest payment date.
Fitch Long Term Rating FITCHCODE Fitch Investors Service Long Term Rating: Fitch's evaluation of the credit quality of a bond.
Fitch Short Term Rating FITCHSHORTCODE Fitch Investors Service Short Term Rating: Fitch's evaluation of the credit quality of a note. 
Fitch's Underlying Long Term Rating FITCH_U_CODE Fitch Investors Service Underlying Long Term Rating: Fitch's evaluation of the credit quality of a bond without the benefit of a credit enhancer.
Fitch's Underlying Short Term Rating FITCH_U_SHORTCODE Fitch Investors Service Short Term Rating: Fitch's evaluation of the credit quality of a note without the benefit of a credit enhancer.
Geographic Region-Bond Buyer BB_REGION Geographic Region-Bond Buyer: Issuer's geographic region as defined by The Bond Buyer. FW= Far West (AK, CA, HI, ID, MT, NV, OR, WA, WY), MW= Midwest (IA, IL, IN, MI, MN, MO, ND, NE, OH, SD, WI) NE= Northeast (CT, DC, DE, MA, MD, ME, NH, NJ, NY, PA, PR, RI, VT), SE= Southeast (VA, AL, FL, GA, KY, LA, MS, NC, SC, TN, WV) SW= Southwest (NM, TX, UT, AR, AZ, CO, KS, OK).
Geographic Region-SDC SDC_REGION Geographic Region-TFSD: Issuer's geographic region as defined by Thomson Financial Securities Data. ME= Mideast (IL, IN, MI, OH, WV, WI) MW= Midwest (IA, KS, MN, MO, NE, ND, SD) NE= Northeast (CT, DC, DE, ME, MD, MA, NH, NJ, NY, PA, RI, VT) SE= Southeast (AL, AR, FL, GA, KY, MS, NC, SC, TN, VA) SW= Southwest (AZ, LA, NM, OK, TX), WE= West (AK, CA, CO, HI, ID, MT, NV, OR, UT, WA, WY)
Gross Spread ($ per thousand) COMB_GS Combined Gross Spread: The combined gross spread field displays a deal's calculated gross spread, if available, or an estimated spread.  The combined gross spread is the difference between an underwriter's purchase and resale bond price expressed as dollars per one thousand.
Highest Coupon Maturity Date HIGHMATY Highest Coupon Maturity Date: Allows users to screen for deals whose highest coupon falls into the designated range.
Highest Coupon of Issue HIGHCPN Highest Coupon: Coupon of the term or serial maturity with the highest coupon rate.
Hospital Type HOSP Hospital Type: TFSD code describing the type of hospital, A= Affiliated Hospital, C= Counsel of Teaching Hospitals, T= Technical Program.
Industry Type ICOD Industry Code: Industry of corporate beneficiary. J: Joint Action; I: Investor Owned; C: Co-Operatives; M: Manufacturing; N: Natural Resources; R: Retailing; V: Service; B: Banks, Saving & Loan; F: Insurance; P: Financial Partnerships.
Initial Put Date PUTD Put Date: Initial date when the interest rate of a variable rate security first changes.
Initial value of appreciator ACCAMT Accumulating Amount: The initial value of the appreciator/zero coupon portion of a bond before it accumulates in value over its life when it is repaid at maturity. Only applies to zero coupon bonds.
Insured Amount (US$ mil) INSAMT Insured Amount: Total par amount insured. ($ Mils). If there are multiple bond insurers, the insured amount is the total par amount of the insured tranches. The insured amount does not show the exact amount insured per bond insurer. in the bond insurer rankings by insured amount. In the bond insurer rankings, if the insured amount is selected as the allocation method, the total insured amount will be given to each bond insurer. For example if Insurer A insured $10 MM and Insurer B insured $20 MM, the insured amount will be $30 MM and in the insurer rankings by insured amount, both insurer A and B will be allocated $30 MM each.
Issue Description ISSUE_UPPER Issue: Issue description as written on official statement cover.
Issuer Type ISSUERTYPE Issuer Type: Type of issuer. TFSD codes are as follows: 10=State, 11=County, 12= City/Town/Village, 13= University, 14= District/Board of Education, 15= State Authority/Agency, 16= Local Authority/Agency, 17= Indian Tribe, 18= Cooperative/not for profit, 19= Nation, 20= National Authority, 21= Direct Issuer. NOTE: **Direct Issuers are other not for profit issuers issuing in the municipal market place. These include hospitals, schools etc., which bring the issue directly to the market instead of using a conduit issuer. Cooperative Utility/Not for Profit - are power cooperatives who issue bonds in the municipal market place. 
Issuer's Counsel ISSCNSL_ALL Issuer's Counsel: TF code for the law firm or Attorney serving as legal counsel to the issuer.
Issuer's CUSIP (Cusip search only) ISSCUSIP Issuer's CUSIP: Six-digit issuer's CUSIP.
Issuer's Website ISSUER_WEBSITE Issuer Website: The URL, or website of the municipal entity issuing the debt.
Joint action JOINT Joint Action: A Yes/No flag identifying issuers representing multiple governmental bodies in issuing public power bonds.
Lead Manager LEADMANAGER_NOACQ Lead Manager: Managing Underwriter—a firm, serving as head of the underwriters' management syndicate and responsible for the purchase and distribution of the security as well as running the books.
LeaseType LEASE1 Lease Backed: Indicates security provided for the bond by lease payments, certificates of participation or loans to lenders.
Letter of Credit Expiration Date LOCEXP_ALL Letter of Credit Expiration Date: Date on which the Letter of Credit expires as a source of additional security.
Main Use of Proceeds - Bond Buyer (Code) BB_UOP Use of Proceeds-Bond Buyer: Code of the proceeds category describing the purpose of the issue as defined by The Bond Buyer. The Bond Buyer code of DV (Development) corresponds to the following TFSD codes: I70, Y73, and I74. The Bond Buyer code of ED (Education) corresponds to the following TFSD codes: E1, E2, L3, and E9. The Bond Buyer Code of EF (Environmental Facilities) corresponds to the following TFSD Codes: P71, W72, and W75. The Bond Buyer code of EP (Electric Power) corresponds to the following TFSD code U50. The Bond Buyer code of GP (General Purpose) corresponds to the following TFSD codes Z43, Z81, and Z80. The Bond Buyer code of HC (Healthcare) corresponds to the following TFSD codes: H11, H14, J15, J15, J17, H13, and H12. The Bond Buyer code HS (Housing) corresponds to the following TFSD codes: M20, N21. The Bond Buyer code PF (Public Facilities) corresponds to the following TFSD codes: E4, Z42, Z60, Z62, Z69, Z63, Z61, Z44, Z41, and Z40. The Bond Buyer code of TR (Transportation) corresponds to the following TFSD codes: T32, A30, S31, T39, T36, T35, T34, and T33. The Bond Buyer code of UT (Utilities) corresponds to the following TFSD codes: C56, V51, V52, Z53, W54, and V55.
Main Use of Proceeds - SDC (Number) SPECIFIC_ALL The main use of proceeds code as defined by Securities Data Company.  In cases where there is more than one use of proceeds for a particular issue, the use of proceeds with the largest dollar allocation is considered the main use of proceeds.
Management fee MFEE Management Fee (Gross Spread Component): The amount paid to the lead manager for handling the affairs of the underwriters' management syndicate. Expressed in dollars per thousand face value of the issued obligation.
Marketplace (Euro, International, etc.) MARKETPLACE_CODE Marketplace:  The geographic location where a deal is sold.
Maturity Date (Thomson Researched) MATURDATE Coupon of each individual maturity within a user defined maturity range.
Minority Firm as Bond Counsel MINORITY_BOND Minority Bond Counsel: A Yes/No flag indicating minority status of one or more bond counsels. A minority firm must be 51% owned by a minority, i.e. female owned firms are considered minority firms
Minority firm as Co-Mgr Only MINORCO Minority Co-Manager: A Yes/No flag indicating minority status of one or more co-managers. A minority firm must be 51% owned by a minority, i.e. female owned firms are considered minority firms.
Minority Firm as Disclosure Counsel MINORITY_DISCLOSURE
Minority firm as Lead Mgr Only MINORLEAD Minority Lead Manager: Yes/No flag indicating minority status of lead manager. A minority firm must be 51% owned by a minority, i.e. female owned firms are considered minority firms.
Minority firm as Lead or Co-Mgr MINORITY Minority Lead or Co-Mgr.: Yes/No flag indicating minority status of the lead manager or one of the co-managers. A minority firm must be 51% owned by a minority, i.e. female owned firms are considered minority firms.
Minority Firm as Special Tax Cousel MINORITY_TAX
Minority Firm as Underwriters' Counsel Flag (Y/N) MINORITY_UNDERWRITER
Miscellaneous notes NOTES Miscellaneous Notes: Provide additional deal information on a deal's guarantee, refunding status or use of proceeds. 
Moody's Long Term Rating MDCODE_ALL Moody's Investors Service Long Term Rating: Moody's evaluation of the credit quality of a long-term bond with a maturity of 13 months or longer.
Moody's Short Term Rating MDSHORTCODE_ALL Moody's Investors Service Short Term Rating: Moody's evaluation of the credit quality of a short-term note, maturing within 13 months.
Moody's Underlying Long Term Rating MD_U_CODE_ALL
Moody's Underlying Short Term Rating MD_U_SHORTCODE_ALL
Mortgage loan rate MLR Mortgage Loan Rate: Interest rate charged on loans provided by mortgagor for either a single family mortgage loan program or a multifamily housing project.
Multi-Hospital System MHS Multi-Hospital System: Yes/No flag identifying individual hospitals that are part of a multi-hospital system and are not freestanding.
Name of corporate /institutional beneficiary PROFORID Corporate/Institutional Beneficiary: TFSD's unique identifier assigned to specific profors (beneficiaries).
Name of Issuer ISSUERID Issuer ID: TFSD's unique identifier for issuer.
Nation Code of Issuer NATION_CODE Nation Code of Issuer: Indicates the country in which the issuer of the deal is found.
Nation of LOC provider CENATION Credit Enhancer Nation: The country in which the credit enhancer is located.
Net interest cost After Offering NIC Net Interest Cost: The average annual interest rate that a municipal bond entity will pay when issuing a bond obligation. 
Net proceeds (amt - oid) NETP Net Proceeds: Net proceeds received by issuer. Calculated as par amount minus original issue discount. ($ Mils)
Number of Co-Managers NUMCOMUNI
Number of deal ISSNO Issue Number: TFSD's unique identifier for a specific deal.
Number of Lead Managers NUMMUNILEAD
Number of managers included as underwriters MANNO Manager Number: Number of managers included as underwriters. . e.g., You may use manno to search for deals with one underwriter by inserting a one, "1" in the "lo" and "hi" fields in the search window.
Offering Type OFFTYPE Offering Type: Offer may be negotiated (public), negotiated (limited), competitive, or private placement.
Official statement status OSSTAT Official Statement Status: Field used to indicate if TFSD has the official statement on file. F=Filed, R= Received, O= Official Statement not received, N= Official Statement not available, P= Preliminary official statement received, or LF= official statement labeled and filed.
Other interest cost OIC Other Interest Cost: Any interest cost other than the NIC or TIC.
Other Interest Cost Type OICTYPE Other Interest Cost Type: Any method other than the NIC or TIC method of computing the interest expense to the issuer.
Par Amount (US$ mil) AMT Amount: The par amount of a bond issue. ($ Mils)
Par Amount per Book Runner (US$ mil) BOOKAMOUNT_RUNNER
Par call date CALLPAR_ALL
Parent Paying Agent PYGAGENT_NOACQ_P
Paying Agent PYGAGENT_NOACQ Paying Agent: Firm responsible for transmitting payments of interest and principal from an issuer to the security holders.
Pension Flag (Y/N) PENSION_FLAG Pension: A Yes/No flag identifying all new issues being used for pension funding.  Includes all pension obligation and pension system bonds. 
Pooled POOL Pooled: Yes/No flag identifying issues where pools of issuers combine to sell debt under the authority of a single issuer. An issue is also considered pooled if the proceeds are shared between a number of beneficiaries.
Preliminary Issue Flag PRELIM Preliminary Issue Flag: A flag indicating that the competitive issue has not yet sold, or a bond purchase agreement has not been signed for the negotiated or private placement issue.
Price at first call date CALLPR Price at First Call: Price of the bond on the first call date, usually par or at a slight premium to par.
Price/Yield of Term or First Serial Maturity PYLDMATY Price/Yield: The Price or Yield of any term maturity or the first serial maturities in ranges of serial maturities.
Project PROJECT_ALL Project: Name of the project financed from the proceeds of the security.
Provisional or Conditional Rating PROVCOND Provisional or Conditional Rating: Indicates the rating that is expected subject to a construction or interim period.
Put frequency PUTFREQ_ALL Put Frequency: Interval at which the interest rate of a variable rate security changes.
Qualified Zone Academy Bonds (Y/N Flag) QZAB Qualified Zone Academy Bonds: Indicates deals done on behalf of Qualified Zone academies.  Qualified zone academies are schools, or programs within a school, which are located in economically distressed areas and whose curriculum is designed through school/business partnerships. The program provides an incentive in the form of federal tax credits to qualified lenders who purchase bonds from issuing public school districts.
Rated Deal Flag (Y/N) RATED Rated Deal Flag: Select or exclude all deals rated by one or more of the following agencies: Standard and Poor's, Moody's and Fitch.
Rating Agency RATING_AGENCY
Refunded Issue REFUNDED Refunded: A Yes/No flag identifying issues that have already been entirely refunded.
Refunding Amount (US$ mil) REFAMT_ALL Refunding Amount: Total par amount used to refund a previous issue ($ mils).
Refunding status REF_ALL REFUNDING - long-term; (REFTYPE = A or B) when bonds are issued to pay off the debt service (principal, interest, call premiums) on previously outstanding bonds prior to stated maturity. That is, old bonds are 'called' and paid for using proceeds from new bonds. REFINANCING - short-term; (REFTYPE = C or D) a bond issued to pay off a bond as it matures, i.e. rolling over debt. (I.e. RANS, TRANS, TANS. Example: in May 1996, 1 year Bond Anticipation Notes (BANs are issued). However, when May 1997 comes around, market conditions are not right (e.g. high long term rates) to issue the long term bonds, so a new set of 1 year BANs is issued. The hope is that when the new BANs mature in 1998 long term rates will be lower. On or about the day the 1996 BANs mature, new BANs are issued and the proceeds of the new BANs are used to pay the principal and interest on the old BANs. The new BANs would be coded as a refinancing (REFTYPE = C or D). NEW MONEY/FINANCING - A bond will be issued to refund an outstanding note. If in the example above the long term bonds were actually issued on or about the day that the 1996 BANs matured, TFSD would code the new bonds as New Money (REFTYPE = N). There really is not a refunding of outstanding notes, instead the proceeds from the bonds are used to pay the final principal and interest due on the short term notes and to permanently finance the project.
When Anticipation Notes mature and their final principal and interest is paid for with new issued Anticipation Notes -- it is a Refinancing (REFTYPE = C or D). When Anticipation Notes mature and their final principal and interest is paid for with newly issued long term bonds -- it is New Money (REFTYPE = N). When bonds are called prior to maturity and their final principal, interest, and call premium is paid for with newly issued bonds -- it is Refunding (REFTYPE = A or B)
To screen for Refunding, Refinancing, or New Money:
For REFUNDINGS, choose REFTYPE A & B
For REFINANCINGS, choose REFTYPE C & D
For NEW MONEY, choose REFTYPE B, D, & N **** New Money can also be called New Financing****
Refunding Type REFTYPE Refunding Type: Specifies when refunding proceeds will be used to refund prior issues. A= Advanced Refunding: The sale of new bonds in advance (usually greater than 90 days) of the first call date of the old bonds. The refunding issue should normally have a lower rate than the issue being refunded. C= Current Refunding: The sale of new bonds before (usually less than 90 days) of the first call date of the old bonds. F= Forward Refunding: The sale of new bonds "today" (to lock in a lower current rate in anticipation of maturing higher rate issues) that will be delivered sometime in the future. U= Unknown, N= Not Applicable. 
Regional manager REGMGR Regional Manager: Refers to the location of the firm acting as lead manager. Firms will have one of the following region designations: New York based firm, non-New York based firm, or regional office of a New York based firm.
Remarketing Agent RA_NOACQ Remarketing Agent: The full name of the firm that solicits purchases from investors in the event of an optional or mandatory tender of variable rate securities.
Reported Gross Spread ($ per thousand) GS Gross Spread: The gross spread is the difference between the price an underwriter pays the issuer for the bonds and the price the underwriter receives from the resale of those bonds to investors. The gross spread is composed of the management fee, underwriting fee, takedown, and expenses. ($/1000)
Revolving Fund Flag (Y/N) REV_FDEALS State Revolving Fund: A Yes/No flag identifying issues that are part of revolving loan programs.  Revolving Loan programs are a means for state governments to provide financial assistance to local governments, small businesses, or other entities.  The programs are initially established with a contribution of equity, e.g., federal grants or state appropriations, and may be leveraged through the issuance of state bonds.  As loans are repaid, the funds are used to make loans to other entities. 
Role of firm (any capacity) ROLEMANAGER_QUERY Role of Firm (Any Capacity): A query item that selects all instances where a given firm has acted in the capacity of manager, financial adviser, trustee or paying agent. 
Role of Law Firm (Any Capacity) ROLECNSL_QUERY Role of Law Firm (Any Capacity): A query item that selects all instances where a given law firm has acted in the capacity of bond counsel, underwriter's counsel, issuer's counsel, beneficiary's counsel, disclosure counsel or special tax counsel.
Rule 144A Flag (Y/N) FLAG_144A
S&P's Long Term Rating SPCODE_ALL Standard & Poors' Corporation Long Term Rating: S&P's evaluation of the credit risk of a bond.
S&P's Short Term Rating SPSHORTCODE_ALL Standard & Poors' Corporation Short Term Rating: S&P's evaluation of the credit quality of a short term issue. Ratings are intended to measure the probability of the timely repayment of principal of and interest on municipal securities.
S&P's Underlying Long Term Rating SP_U_CODE_ALL
S&P's Underlying Short Term Rating SP_U_SHORTCODE_ALL
Sale Date SALE Sale Date: Date on which the issuer and the lead underwriter sign the bond purchase agreement.
SDC Deal Number NO
SDC Deal Type MASTER_DEAL_TYPE
SDC Rank-Eligible Flag (Y/N) RANK_ELIGIBLE Rank Eligible: Standard Rank Eligible-The rank eligible flag includes or excludes deals based on their SDC standard rank eligibility. The flag will screen-out deals that are short term, private placements, preliminary or issued by co-op utilities.
Security SECURITY_ALL Security: General security source of the issue. (Revenue or General obligation)
Serial / Term Maturity SERIAL Serial/Term: Code that distinguishes the first maturity in a range of serial maturities from a term maturity.
Series of Issue SERIES_UPPER Series: Description used to distinguish between multiple issues by a single issuer. (E.g. Series 1998A-C)
Sinking Fund Date SINKDATE Sinking Fund Date: Date of the first deposit to be made to the sinking fund by the issuer.
Sinking fund flag SINK Sinking Fund: A Yes/No flag indicating existence of a sinking fund into which the issuer makes periodic deposits to assure timely availability of sufficient moneys for the payment of debt service requirements.
Source Date SRCDAT Source: The date and the source from which the issue was added to the TFSD database (i.e. 960101B - a deal entered on 01/01/96 from the Bond Buyer). Possible sources of information include the following: B= The Bond Buyer results section, b= The Bond Buyer forward calendar, d= Dalnet, F= Munifax, P= Official statement, S= Survey, X= Fax, V= Muniview, W= Worksheets. 
Special Revenue Type SPECREV_ALL Special Revenue: Specific security source for special revenue bonds. S= Sales tax, F= Motor fuel tax, A= Assessment district, M= Mello Roos, T= Tax allocation/Increment, or O= Other.
Special Tax Counsel STCNSL_ALL Special Tax Counsel: Legal counsel hired to examine sophisticated tax laws that may apply to certain revenue bonds.
Split Rating SPLIT_ALL Split Rated: Identifies issues rated significantly different by Moody's and S&P. For example, an issue rated AA by S&P and A2 by Moody's would qualify as split rated. Covers deals issued since 1/1/95.
State Appropriation Flag (Y/N) STATE_APP State Appropriation Bonds: A Yes/No flag identifying bond issues that are state appropriated.  The debt is NOT a direct or general obligation of the State nor is it necessarily paid directly from revenues the projects generate.  Instead the funds must be annually appropriated by the State Legislature.  No voter approval is needed.  Commonly issued for medical, educational, and correctional facilities or transportation and housing projects.  Applies to issues such as, MTA, MAC, NYS Dorm Authority, LGAC, UDC.
State of beneficiary COSTATE Corporate State: Two-letter abbreviation of the state location of the corporate beneficiary.
State of Issuer STATECODE State: A two-letter abbreviation of the state in which the issuer is located.
Syndicate SYND Syndicate: A Yes/No flag indicating the existence of a group of underwriters formed to purchase a new issue of municipal securities from the issuer and offer it for resale to the general public. The syndicate is organized for the purposes of sharing the risks of underwriting the issue, obtaining sufficient capital to purchase an issuer and for broader distribution of the issue to the investing public.
Takedown TAKE Takedown (Gross Spread Component): The income derived from the sale of the securities similar to a commission. The takedown is typically the largest component of the spread. Expressed in dollars per thousand.
Tax Status TAXABLE_ALL Taxable: Code describing the tax status of the security. E=Tax-Exempt from federal tax, A=Subject to AMT (Alternative Minimum Tax), T=Taxable.
Teaching Hospital TH Teaching Hospital: A Yes/No flag identifying hospitals as teaching hospitals, e.g. a hospital that is associated with a university system such as Yale New Haven Hospital.
Tender Agent TNDRAGENT_NOACQ Tender Agent: Firm who makes 'best effort' to create a market for variable rate bonds tendered through an optional or mandatory redemption.
Tobacco Settlement Flag (Y/N) TOBACCO_SETTLEMENT Tobacco Settlement Flag: Select or exclude bonds that are backed by tobacco settlement money: These type of bonds are issued in order to securitize monies received from a 1998 multi-billion dollar tobacco settlement suit brought by a coalition of states against major American tobacco companies.  Securitization allows the state to receive tobacco-settlement monies in a lump sum up front, by selling their right to receive annual payments.  Generally, special-purpose corporations are established to issue the bonds, take in the payments, and pay the bondholders
Total Amount of Principle Payable During Life of Bond MATAMT Maturity Amount: Maturity amount of issue including the maturity value of zero coupon maturities.
True interest cost TIC True Interest Cost: A method of computing issuer's interest cost considering the time value of money. Under this method of computing the issuer's cost, interest cost is defined as the rate, compounded semi-annually, necessary to discount the amounts payable on the respective principal and interest payment dates to the purchase price received for the new issue securities.
Trustee TRUSTEE_NOACQ Trustee: A financial institution with fiduciary responsibility to enforce the terms of the bond contract.
Trustee Parent Code TRUSTEE_PARENT
Underwriters' Counsel UC_ALL Underwriters' Counsel: TFSD code for the attorney or law firm retained to represent the interest of the underwriters in connection with the purchase of a new issue of municipal securities. The duties of the underwriter's counsel may include review of the issuer's bond resolution or ordinance and documentation on behalf of the underwriter; review of the official statement to determine the adequacy of disclosure; negotiation of the agreement among underwriters; and preparation of the due diligence opinion.
Underwriters' fee UFEE Underwriters' Fee (Gross Spread Component): The profit left in the syndicate account after meeting all other expenses or deductions paid to each underwriter according to the number of bonds each dealer has committed to sell. Expressed in dollars per thousand.
Variable Rate Amount VRDNAMT1 Variable Rate Demand Note Amount: The total par amount that is subject to a variable interest rate with a short term put ($ mils).
Years to Maturity YTM Years to Maturity: Number of years from the earliest dated date to the final maturity date of the security. In the instances where no dated date is available, the sale date is used instead.  Partial years are expressed as percentages. Bonds are defined as any security with years to maturity greater than or equal to thirteen months or 1.083 years (1.083 to HI).  Notes are defined as any security with years to maturity less than thirteen months or 1.083 years (LO to 1.082).
Yield/Price at Maturity (Thomson Researched) YIELDAMOUNT