RSSD-DealScan Database Linking Table

• Content: 44,224 links between RSSD lender identifier-years from FDIC (Federal Deposit Insurance Corporation) or FED/NIC (Federal Reserve Bank/National Information Center) databases and companyid lender identifier-years from the Thomson Reuters DealScan Facilities file. Files can be linked with this table using the variables RSSD (the FDIC and FED identifier), companyid or ultimateparentid (the DealScan identifiers), plus the year variable for all files involved.

• Coverage: 93% or 652,772 of 701,435 of all lender-facility observations in which DealScan loans were issued by U.S. non-FIRE companies between 1987 and 2016.

• Referencing: Augmentations to the DealScan-Compustat Link are obtained from Jan Keil's website; first presented in "Jan Keil, Do Relationship Lenders Manage Loans Differently?, Working Paper, 2018" [BibTeX].

• Download: CSV files linking DealScan lenders and ultimate parents. Files contain only companyid, rssd and FDIC/FED flag variables. Lender names, information on lenders and loans must be obtained from the FDIC, the FED, and DealScan. The latter requires a paid subscription.