SDC Deals

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:

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

Mergers and New Issues::

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