Name
|
Code
|
Type
|
M
|
|---|---|---|---|
Issuer ID
|
issuer_id
|
char(20)
|
Yes
|
Cusip 1 Non Interest Bearing
|
cp_cusip_base_1
|
char(6)
|
No
|
Cusip 2 Non Interest Bearing
|
cp_cusip_base_2
|
char(6)
|
No
|
Description 1
|
description_1
|
varchar(40)
|
No
|
Description 2
|
description_2
|
varchar(40)
|
No
|
Cusip Interest Bearing
|
cd_cusip_base
|
char(6)
|
No
|
Default Broker Code
|
default_broker_code
|
char(12)
|
No
|
State
|
state
|
varchar(2)
|
No
|
Country
|
country
|
char(6)
|
No
|
Parent Codes & Percents
|
parents
|
varchar(96)
|
No
|
Guarantors
|
guarantors
|
varchar(96)
|
No
|
Industry
|
industry
|
char(6)
|
No
|
Illiquid
|
illiquid
|
tinyint
|
No
|
Unseasoned
|
unseasoned
|
tinyint
|
No
|
Is Tax Exempt
|
is_tax_exempt
|
tinyint
|
No
|
Approved Date
|
approved_date
|
datetime
|
No
|
LOC Date
|
loc_date
|
datetime
|
No
|
Limit Total Assets
|
limit_total_assets
|
float
|
No
|
Limit System Max
|
limit_system_max
|
float
|
No
|
Limit Days Max
|
limit_days_max
|
int
|
No
|
Outstanding Types & Sizes
|
outstandings
|
varchar(128)
|
No
|
Total Non Voting Size
|
total_non_voting_size
|
float
|
No
|
Private Placements Size
|
private_placements_size
|
float
|
No
|
Comments
|
comments
|
varchar(255)
|
No
|
Is Edit Active
|
is_edit_active
|
tinyint
|
No
|
Last Update ID
|
last_update_id
|
char(4)
|
No
|
Last Update
|
last_update
|
datetime
|
No
|
Lock ID
|
lock_id
|
char(4)
|
No
|
Default Instrument Type
|
default_instrument_type
|
char(6)
|
No
|
Last Internal Review Date
|
last_int_review_date
|
datetime
|
No
|
Program Type
|
program_type
|
char(6)
|
No
|
S&P Level
|
sandp_level
|
char(6)
|
No
|
Liquidity Support
|
liquidity_support
|
char(6)
|
No
|
Is Active
|
is_active
|
tinyint
|
No
|
Address Line 1
|
address_line_1
|
varchar(40)
|
No
|
Address Line 2
|
address_line_2
|
varchar(40)
|
No
|
Address Line 3
|
address_line_3
|
varchar(40)
|
No
|
Attention
|
attention
|
varchar(40)
|
No
|
City
|
city
|
varchar(20)
|
No
|
Zip Code
|
zip_code
|
varchar(10)
|
No
|
Sales Quality
|
sales_quality
|
char(6)
|
No
|
Commission
|
commission
|
float
|
No
|
Is Financial
|
is_financial
|
tinyint
|
No
|
Is Structured
|
is_structured
|
tinyint
|
No
|
Is Guaranteed
|
is_guaranteed
|
tinyint
|
No
|
Is Jap Loc
|
is_jap_loc
|
tinyint
|
No
|
Program Start Date
|
program_start_date
|
datetime
|
No
|
Legal Vehicle 1
|
legal_vehicle_1
|
tinyint
|
No
|
Legal Vehicle 2
|
legal_vehicle_2
|
tinyint
|
No
|
Legal Vehicle 3
|
legal_vehicle_3
|
tinyint
|
No
|
Legal Vehicle 4
|
legal_vehicle_4
|
tinyint
|
No
|
As Agent Only
|
as_agent_only
|
tinyint
|
No
|
Discount Primary Port
|
discount_primary_port
|
char(12)
|
No
|
Discount Secondary Port
|
discount_second_port
|
char(12)
|
No
|
Int Bear Primary Port
|
int_bear_primary_port
|
char(12)
|
No
|
Int Bear Secondary Port
|
int_bear_second_port
|
char(12)
|
No
|
Limit Position Max
|
limit_position_max
|
float
|
No
|
Limit Same Day Maturty
|
limit_same_day_mat
|
float
|
No
|
Limit Min Note
|
limit_min_note
|
float
|
No
|
Limit Max Note
|
limit_max_note
|
float
|
No
|
Reg Way Settle Days
|
reg_way_settle_days
|
smallint
|
No
|
Holiday Calendar
|
holiday_calendar
|
char(6)
|
No
|
IPA Name
|
ipa_name
|
char(6)
|
No
|
IPA DTC
|
ipa_dtc
|
varchar(5)
|
No
|
Trader
|
trader
|
char(4)
|
No
|
Loc Symbols
|
loc_symbols
|
varchar(96)
|
No
|
Fed Rate Type
|
fed_rate_type
|
char(6)
|
No
|
Is First Tier
|
is_first_tier
|
tinyint
|
No
|
Is Foreign
|
is_foreign
|
tinyint
|
No
|
Index Code
|
P
|
F
|
A
|
U
|
C
|
Sort
|
|---|---|---|---|---|---|---|
pk_issuer
|
Yes
|
No
|
No
|
Yes
|
No
|
ASC
|
index_issuer_parents
|
No
|
No
|
No
|
No
|
No
|
ASC
|
index_issuer_cp_cusip_base_1
|
No
|
No
|
No
|
No
|
No
|
ASC
|
index_issuer_cp_cusip_base_2
|
No
|
No
|
No
|
No
|
No
|
ASC
|
Primary Key
|
Reference to
|
Foreign Key
|
|---|---|---|
code
|
fedrttyp
|
fed_rate_type
|
code
|
loc
|
loc_symbols
|
code
|
country
|
country
|
code
|
guarant
|
guarantors
|
code
|
industry
|
industry
|
code
|
insttype
|
default_instrument_type
|
code
|
ipa
|
ipa_name
|
code
|
liquidity
|
liquidity_support
|
other_party_code
|
opmast
|
default_broker_code
|
code
|
progtype
|
program_type
|
code
|
splevel
|
sandp_level
|
code
|
saleqlty
|
sales_quality
|
Referenced by
|
Primary Key
|
Foreign Key
|
|---|---|---|
aprvdisr
|
issuer_id
|
issuer_id
|
isrcodlr
|
issuer_id
|
issuer_id
|
issrrat
|
issuer_id
|
issuer_id
|
opaprisr
|
issuer_id
|
issuer_id
|