Name
|
Code
|
Type
|
M
|
|---|---|---|---|
Product ID
|
product_id
|
char(20)
|
Yes
|
CUSIP
|
cusip
|
varchar(9)
|
No
|
Ticker
|
ticker
|
varchar(20)
|
No
|
State
|
state
|
varchar(2)
|
No
|
Description 1
|
description_1
|
varchar(40)
|
Yes
|
Description 2
|
description_2
|
varchar(40)
|
No
|
Responsible Trader
|
responsible_trader
|
char(4)
|
No
|
Underwriting Cusip
|
underwriting_cusip
|
varchar(9)
|
No
|
MBS Pool Number
|
mbs_pool_number
|
varchar(9)
|
No
|
Issue Number
|
issue_number
|
char(6)
|
No
|
Liquidity Support
|
liquidity_support
|
char(6)
|
No
|
IPD Holiday Rule
|
ipd_holiday_rule
|
char(6)
|
No
|
Accrues Holiday Rule
|
accrues_holiday_rule
|
char(6)
|
No
|
Record Holiday Rule
|
record_holiday_rule
|
char(6)
|
No
|
Frequency Months
|
frequency_months
|
char(6)
|
No
|
Bill Frequency
|
bill_frequency
|
char(6)
|
No
|
Bill Months
|
bill_months
|
char(6)
|
No
|
Bill Method
|
bill_method
|
char(6)
|
No
|
Bill Calc Method
|
bill_calc_method
|
char(6)
|
No
|
Price Months
|
price_months
|
char(6)
|
No
|
Var Rate Reset Date
|
var_rate_reset_date
|
datetime
|
No
|
Contract Expiration Date
|
contract_exp_date
|
datetime
|
No
|
First Notice Date
|
first_notice_date
|
datetime
|
No
|
First Delivery Date
|
first_delivery_date
|
datetime
|
No
|
Last Delivery Date
|
last_delivery_date
|
datetime
|
No
|
Is Incomplete
|
is_incomplete
|
tinyint
|
No
|
Is After Market
|
is_after_market
|
tinyint
|
No
|
Is Back Office Pending
|
is_bop
|
tinyint
|
No
|
Is Edit Active
|
is_edit_active
|
tinyint
|
No
|
MBS Agency
|
mbs_agency
|
char(6)
|
No
|
MBS Prepay Model
|
mbs_prepay_model
|
char(6)
|
No
|
Redemption Feature
|
redemption_feature
|
char(6)
|
No
|
insurance
|
insurance
|
char(6)
|
No
|
Exchange
|
exchange
|
char(6)
|
No
|
Calculation Code
|
calc_code
|
char(6)
|
No
|
Instrument Family
|
instrument_family
|
char(6)
|
No
|
Instrument Class
|
instrument_class
|
char(6)
|
No
|
Instrument Type
|
instrument_type
|
char(6)
|
No
|
Interest Frequency
|
interest_frequency
|
char(6)
|
No
|
Principal Frequency
|
principal_frequency
|
char(6)
|
No
|
Price Rounding
|
price_rounding
|
char(6)
|
No
|
Day Count Method
|
day_count_method
|
char(6)
|
No
|
Call Notification
|
call_notification
|
char(6)
|
No
|
Is DTC Eligible
|
is_dtc_eligible
|
tinyint
|
No
|
Possession Form
|
possession_form
|
char(6)
|
No
|
Settlement Currency
|
settlement_currency
|
char(3)
|
No
|
Trade Currency
|
trade_currency
|
char(3)
|
No
|
Is Tax Exempt
|
is_tax_exempt
|
tinyint
|
No
|
Is Private
|
is_private
|
tinyint
|
No
|
Is Flat Interest
|
is_flat_interest
|
tinyint
|
No
|
Is Subject To AMT
|
is_subject_to_amt
|
tinyint
|
No
|
Is Exchangeable
|
is_exchangeable
|
tinyint
|
No
|
Is PIK
|
is_pik
|
tinyint
|
No
|
Is Uploaded
|
is_uploaded
|
tinyint
|
No
|
Is Sink Any Int Date
|
is_sink_any_int_date
|
tinyint
|
No
|
Is Cumulative
|
is_cumulative
|
tinyint
|
No
|
Is Sink Open Market
|
is_sink_open_market
|
tinyint
|
No
|
Is When Issued
|
is_when_issued
|
tinyint
|
No
|
Sink Type
|
sink_type
|
char(6)
|
No
|
Sink Method
|
sink_method
|
char(6)
|
No
|
Sink Frequency
|
sink_frequency
|
char(6)
|
No
|
Variable Rate Frequency
|
var_rate_frequency
|
char(6)
|
No
|
Cycle Month
|
cycle_month
|
char(6)
|
No
|
Var Rate Index
|
var_rate_index
|
char(6)
|
No
|
Guarantors
|
guarantors
|
varchar(96)
|
No
|
Trustee
|
trustee
|
char(6)
|
No
|
Underwriter
|
underwriter
|
char(6)
|
No
|
Country
|
country
|
char(6)
|
No
|
Restrict Code
|
restrict_code
|
char(2)
|
No
|
Parent Codes & Percents
|
parents
|
varchar(96)
|
No
|
Maturity Date
|
maturity_date
|
datetime
|
No
|
Issue Date
|
issue_date
|
datetime
|
No
|
First Coupon Date
|
first_coupon_date
|
datetime
|
No
|
Call Date
|
call_date
|
datetime
|
No
|
Par Call Date
|
par_call_date
|
datetime
|
No
|
Put Date
|
put_date
|
datetime
|
No
|
PIK Date
|
pik_date
|
datetime
|
No
|
Sink Date
|
sink_date
|
datetime
|
No
|
Stepup Date
|
stepup_date
|
datetime
|
No
|
Restrict Date
|
restrict_date
|
datetime
|
No
|
MBS Principal Date
|
mbs_principal_date
|
datetime
|
No
|
MBS First Principal Date
|
mbs_first_principal_date
|
datetime
|
No
|
MBS Last Principal Date
|
mbs_last_principal_date
|
datetime
|
No
|
Ex Dividend Date
|
ex_dividend_date
|
datetime
|
No
|
Cycle Day
|
cycle_day
|
smallint
|
No
|
Variable Rate Reset Day
|
var_rate_reset_day
|
char(6)
|
No
|
Minimum Denomination
|
min_denom
|
smallint
|
No
|
Denomination Increment
|
denom_increment
|
smallint
|
No
|
Reprice BP
|
reprice_bp
|
smallint
|
No
|
Put Window Last
|
put_window_last
|
smallint
|
No
|
Put Window First
|
put_window_first
|
smallint
|
No
|
MBS Stated Delay
|
mbs_stated_delay
|
smallint
|
No
|
MBS WAM
|
mbs_wam
|
smallint
|
No
|
Fee Per Bond
|
fee_per_bond
|
float
|
No
|
Remarket Fee
|
remarket_fee
|
float
|
No
|
Stepup Rate
|
stepup_rate
|
float
|
No
|
Max Fees
|
max_fees
|
float
|
No
|
Variable Rate Margin
|
var_rate_margin
|
float
|
No
|
Variable Rate Floor
|
var_rate_floor
|
float
|
No
|
Variable Rate Cap
|
var_rate_cap
|
float
|
No
|
Variable Rate Maximum Reset
|
var_rate_max_reset
|
float
|
No
|
Restrict Rate
|
restrict_rate
|
float
|
No
|
Outstanding
|
outstanding
|
float
|
No
|
Original Size
|
original_size
|
float
|
No
|
OID Price
|
oid_price
|
float
|
No
|
OID Yield
|
oid_yield
|
float
|
No
|
Conversion
|
conversion
|
float
|
No
|
Sink Price
|
sink_price
|
float
|
No
|
Commission
|
commission
|
float
|
No
|
MBS Prepay Assumption
|
mbs_prepay_assumption
|
float
|
No
|
MBS Servicing Fee
|
mbs_servicing_fee
|
float
|
No
|
MBS WAC
|
mbs_wac
|
float
|
No
|
Coupon
|
coupon
|
float
|
No
|
Call Price
|
call_price
|
float
|
No
|
Par Call Price
|
par_call_price
|
float
|
No
|
Put Price
|
put_price
|
float
|
No
|
Principal Scalar
|
principal_scalar
|
float
|
No
|
MBS Principal Factor
|
mbs_principal_factor
|
float
|
No
|
Par Value
|
par_value
|
float
|
No
|
Last Update ID
|
last_update_id
|
char(4)
|
No
|
Last Update
|
last_update
|
datetime
|
No
|
Industry
|
industry
|
char(6)
|
No
|
Lock ID
|
lock_id
|
char(4)
|
No
|
Issuer ID
|
issuer_id
|
char(20)
|
No
|
Comments
|
comments
|
varchar(255)
|
No
|
Industry Class
|
industry_class
|
char(6)
|
No
|
Program Type
|
program_type
|
char(6)
|
No
|
SandP Level
|
sandp_level
|
char(6)
|
No
|
MBS Average Life
|
mbs_average_life
|
float
|
No
|
LOC Symbols
|
loc_symbols
|
varchar(96)
|
No
|
Put Reset Frequency
|
put_reset_frequency
|
char(6)
|
No
|
Put Reset Day
|
put_reset_day
|
char(6)
|
No
|
Var Rate Lookback Days
|
var_rate_lookback_days
|
smallint
|
No
|
Is Illiquid
|
is_illiquid
|
tinyint
|
No
|
Is Foreign
|
is_foreign
|
tinyint
|
No
|
Is_Bank_Qualified
|
is_bank_qualified
|
tinyint
|
No
|
Product ID Underlying
|
product_id_underlying
|
varchar(20)
|
No
|
Conversion Ratio
|
conversion_ratio
|
float
|
No
|
Use Stated Maturity
|
use_stated_maturity
|
tinyint
|
No
|
Is Var Reset Business Day
|
is_var_reset_business_day
|
tinyint
|
No
|
Roll Convention
|
roll_convention
|
char(6)
|
No
|
Is Adjust Reset Period
|
is_adjust_reset_period
|
tinyint
|
No
|
FIPS Level
|
fips_level
|
varchar(6)
|
No
|
Index Code
|
P
|
F
|
A
|
U
|
C
|
Sort
|
|---|---|---|---|---|---|---|
pk_product
|
Yes
|
No
|
No
|
Yes
|
No
|
ASC
|
index_product_maturity_date
|
No
|
No
|
No
|
No
|
No
|
ASC
|
index_product_issuer_id
|
No
|
Yes
|
No
|
No
|
No
|
ASC
|
index_product_description_1
|
No
|
No
|
No
|
No
|
No
|
ASC
|
index_product_product_id_under
|
No
|
No
|
No
|
No
|
No
|
ASC
|
Referenced by
|
Primary Key
|
Foreign Key
|
|---|---|---|
account
|
product_id
|
cash_proxy
|
aprvdprd
|
product_id
|
product_id
|
prodcalc
|
product_id
|
product_id
|
prodfeat
|
product_id
|
product_id
|
prodrat
|
product_id
|
product_id
|
prodsink
|
product_id
|
product_id
|
prodvrat
|
product_id
|
product_id
|
tckdtl
|
product_id
|
product_id
|
tckmast
|
product_id
|
product_id
|