Description:
Provides detailed information available on new issues, M&A and syndicated loans.
Data Source:
SDC deals database
Update Schedule:
Daily
Request Syntax:
CUSIP=XXXXXX TYPE=XXXXX Examples: **CUSIP=459200 TYPE=LOANS **CUSIP=459200 TYPE=NEWISSUES **CUSIP=459200 TYPE=MERGERS Note: use the 6 digit CUSIP only.
Field Listing:
Loan Reports:
Mergers and New Issues::
SDC Deals
Field
Description
Report Asset
i.e: loan
Company_no
Deal_no
CIDGEN
Company ID
Market
i.e.: United States Loan, Asian Loan
UPCIDGEN
Company's parent ID
Manager
Type
i.e: revolving credit, term loan
Amount
Issuer
i.e.: Citibank, JPM, Sumito-Mitsui
Announce_date
IPCIDGEN
Parent company's CUSIP
CUSIP
Dealtype
Field
Description
Report Type
i.e.: mergers or new issues
Company_no
ACIDGEN
acquiror ID
Status
i.e.: completed
Effective_date
Deal type
TCUSIP
Target Cusip
Announce_date
Acquiror
AUPCIDGEN
Acquiring ultimate parent company identifier) Amount
ACusip
Acquiror Cusip)
AIPCIDGEN
Acquiring company ultimate parent CUSIP
Aadvisor
Acquiror Advisor
AIPCusip
Acquiring company CUSIP
Target
Company being acquired
TUPCusip
Target ultimate parent's CUSIP
Deal_no
AUPCusip
Acquiring company's parent CUSIP
TCIDGEN
Target company ID
Tadvisor
Target advisor
TUPCidgen
Target company's ultimate parent identifier
TIPCusip
Target company's parent CUSIP
TIPCIDGEN
Target company's parent ID