Page Comparison

Asset Properties Model

../

issuerId

string

1413

in_issuer_id

SECURITYDBO

SECURITY_MASTER

ISSUER_ID

CHAR(20)

../issuerId

priceMultiplier

decimal

18

in_price_multiplier

SECURITYDBO

SECURITY_MASTER

PRICE_MULTIPLIER

NUMBER(28,12)

../priceMultiplier

quantityScale

decimal

19

in_sm_trading_unit

SECURITYDBO

SECURITY_MASTER

TRADING_UNIT

NUMBER(28,12)

../quantityScale

redemptionCurrency

string

1530

in_redemption_currency

SECURITYDBO

SECURITY_MASTER

REDEMPTION_CURRENCY

CHAR(3)

../redemptionCurrency

contractSize

decimal

1483

in_contractsize

SECURITYDBO

SECURITY_MASTER_DETAIL

CONTRACTSIZE

NUMBER(28,12)

../contractSize

strikePrice

decimal

67

in_strike_price

SECURITYDBO

DERIVATIVES

STRIKE_PRICE

NUMBER(28,12)

../strikePrice

underlyingSecurity

string

1141

in_underlying_security

SECURITYDBO

DERIVATIVES

UNDERLYING_SECURITY

VARCHAR2(255)

../underlyingSecurity

underlyingSecAlias

integer

1347

in_underlying_sec_alias

SECURITYDBO

DERIVATIVES

UNDERLYING_SEC_ALIAS

NUMBER

../underlyingSecAlias

underlyingType

string

916

in_underlying_type

SECURITYDBO

UNDERLYING_SECURITY

UNDERLYING_TYPE

VARCHAR2(100)

../underlyingType

nextCouponDate

date

1189

in_next_coupon_date

SECURITYDBO

FIXED_INCOME

NEXT_COUPON_DATE

DATE

../nextCouponDate

paymentFrequency

string

1544

in_payment_freq

SECURITYDBO

FIXED_INCOME

PAYMENT_FREQ

CHAR(6)

../paymentFrequency

investmentDescription

Description

10174

in_security_description

SECURITYDBO

SECMASTER_DETAIL_EXT

SECURITY_DESCRIPTION

VARCHAR2(60)

../investmentDescription

issuePrice

decimal

69

SECURITYDBO

FIXED_INCOME

ISSUE_PRICE

NUMBER(28,12)

../issuePrice

issueCountry

string

2290 

SECURITYDBO

EQUITY

ISSUE_COUNTRY

CHAR(3)

../issueCountry

offset

decimal

215

SECURITYDBO

DERIVATIVES

OFFSET

NUMBER

../offset

optiondescr

string

1364

SECURITYDBO

DERIVATIVES

OPTIONDESCR

VARCHAR2(10)

../optiondescr

premiumType

string

3302 

SECURITYDBO

DERIVATIVES

PREMIUM_TYPE

CHAR(2)

../premiumType

putCallFlag

string

1350 

SECURITYDBO

DERIVATIVES

PUT_CALL_FLAG 

CHAR(4)

../putCallFlag

annualDividend

decimal

3233

SECURITYDBO

EQUITY

ANNUAL_DIVIDEND 

NUMBER(28,12)

../annualDividend

drdFlag

string

2907 

SECURITYDBO

EQUITY

DRD_FLAG 

VARCHAR2 (1)

../drdFlag

qdiEligibleFlag

string

2905 

SECURITYDBO

EQUITY

QDI_ELIGIBLE_FLAG 

VARCHAR2 (1)

../qdiEligibleFlag

sharesOutstanding

decimal

3244 

SECURITYDBO

EQUITY

SHARES_OUTSTANDING 

NUMBER(28,12)

../sharesOutstanding

sicCode

string

10401 

SECURITYDBO

EQUITY_DETAIL

SIC_NAME

VARCHAR2(60)

../sicCode

interestPaymentTiming

string

1523 

SECURITYDBO

FIXED_INCOME

ACCRUAL_METHOD

CHAR(4)

../interestPaymentTiming

callIndicator

string

1182 

SECURITYDBO

FIXED_INCOME

CALLABLE 

CHAR(2)

../callIndicator

putIndicator

string

1546 

SECURITYDBO

FIXED_INCOME

PUTTABLE 

CHAR(2)

../putIndicator

datedDate

date

1183

SECURITYDBO

FIXED_INCOME

DATED_DATE

DATE

../datedDate

demandFeature

string

10555

SECURITYDBO

FIXED_INCOME

DEMAND_FEATURE 

VARCHAR2(3)

../demandFeature

uSFederalTaxIndicator

string

1545

SECURITYDBO

FIXED_INCOME

FEDERAL_TAX_INDICATOR 

CHAR(2)

../uSFederalTaxIndicator

businessDayConvention

string

1536 

SECURITYDBO

FIXED_INCOME

INTEREST_METHOD_CODE 

CHAR(10)

../businessDayConvention

minimumPiece

decimal

1540

SECURITYDBO

FIXED_INCOME

MINIMUM_PIECE 

NUMBER(28,12)

../minimumPiece

sinkFundIndicator

string

1780

SECURITYDBO

FIXED_INCOME

SINK_FUND

CHAR(2)

../sinkFundIndicator

varRateFreqCode

string

1788 

SECURITYDBO

FIXED_INCOME

VAR_RATE_FREQ_CODE 

CHAR(4)

../varRateFreqCode

marketIssue

string

10347 

SECURITYDBO

FIXED_INCOME_DETAIL_EXT

MARKET_ISSUE

VARCHAR2(30)

../marketIssue

gicsIndustry

string

10185 

SECURITYDBO

SECMASTER_DETAIL_EXT

GICS_INDUSTRY

VARCHAR2(60)

../gicsIndustry

gicsIndustryGroup

string

10183 

SECURITYDBO

SECMASTER_DETAIL_EXT

GICS_INDUSTRY_GROUP 

VARCHAR2(60)

../gicsIndustryGroup

gicsIndustryGroupName

string

10184

SECURITYDBO

SECMASTER_DETAIL_EXT

GICS_INDUSTRY_GROUP_NAME 

VARCHAR2(60)

../gicsIndustryGroupName

gicsIndustryName

string

10186

SECURITYDBO

SECMASTER_DETAIL_EXT

GICS_INDUSTRY_NAME 

VARCHAR2(60)

../gicsIndustryName

gicsName

string

10182 

SECURITYDBO

SECMASTER_DETAIL_EXT

GICS_NAME 

VARCHAR2(60)

../gicsName

gicsOverrideIndustry

string

10197

SECURITYDBO

SECMASTER_DETAIL_EXT

GICS_OVERRIDE_INDUSTRY 

VARCHAR2(60)

../gicsOverrideIndustry

gicsOverrideIndustryGrp

string

10198

SECURITYDBO

SECMASTER_DETAIL_EXT

GICS_OVERRIDE_INDUSTRY_GROUP 

VARCHAR2(60)

../gicsOverrideIndustryGrp

gicsOverrideSector

string

10199 

SECURITYDBO

SECMASTER_DETAIL_EXT

GICS_OVERRIDE_SECTOR 

VARCHAR2(60)

../gicsOverrideSector

gicsOverrideSubIndustry

string

10196 

SECURITYDBO

SECMASTER_DETAIL_EXT

GICS_OVERRIDE_SUB_INDUSTRY 

VARCHAR2 (60)

../gicsOverrideSubIndustry

gicsSector

string

10181

SECURITYDBO

SECMASTER_DETAIL_EXT

GICS_SECTOR 

VARCHAR2(60)

../gicsSector

gicsSubIndustry

string

10187 

SECURITYDBO

SECMASTER_DETAIL_EXT

GICS_SUB_INDUSTRY 

VARCHAR2(60)

../gicsSubIndustry

gicsSubIndustryName

string

10188 

SECURITYDBO

SECMASTER_DETAIL_EXT

GICS_SUB_INDUSTRY_NAME 

VARCHAR2(60)

../gicsSubIndustryName

marketSectorDescription

string

10173 

SECURITYDBO

SECMASTER_DETAIL_EXT

MARKET_SECTOR_DESCRIPTION

VARCHAR2(8)

../marketSectorDescription

couponDayOfMonth

decimal

1799 

SECURITYDBO

SECURITY_MASTER

COUPON_DAY_OF_MONTH 

NUMBER 

../couponDayOfMonth

paymentFrequencyCode

string

472 

SECURITYDBO

SECURITY_MASTER

COUPON_FREQ_CODE

CHAR(8)

../paymentFrequencyCode

dayCountBasis

string

471

SECURITYDBO

SECURITY_MASTER

DAY_CNT

CHAR(20)

../dayCountBasis

restrictedIndicator

string

1139 

SECURITYDBO

SECURITY_MASTER

LIQUID_FLAG

CHAR(2)

../restrictedIndicator

oIDIndicator

string

218 

SECURITYDBO

SECURITY_MASTER

OID_BOND

CHAR(2)

../oIDIndicator

quantityType

string

12 

SECURITYDBO

SECURITY_MASTER

QUANTITY_TYPE

CHAR(12)

../quantityType

_144AEligibleIndicator

string

1301 

SECURITYDBO

SECURITY_MASTER

SEC_144A_FLAG

CHAR(2)

../_144AEligibleIndicator

securityMinorType

string

1440 

SECURITYDBO

SECURITY_MASTER

SECURITY_MINOR_TYPE

CHAR(4)

../securityMinorType

businessCalendarName

string

1480 

SECURITYDBO

SECURITY_MASTER_DETAIL

BUSINESSDAY

VARCHAR2(10)

../businessCalendarName

countryOfRiskCode

string

10536 

SECURITYDBO

SECURITY_MASTER_DETAIL

COUNTRY_OF_RISK

VARCHAR2(20)

../countryOfRiskCode

region

string

5423 

SECURITYDBO

SECURITY_MASTER_DETAIL

REGION

VARCHAR2(50)

../region

riskClassificationType

string

11584 

SECURITYDBO

SECURITY_MASTER_DETAIL

RISK_CLASSIFICATION_TYPE

CHAR

../riskClassificationType

userGroupChar1

string

1505 

SECURITYDBO

SECURITY_MASTER_DETAIL

USER_GROUP_CHAR1

VARCHAR2(60)

../userGroupChar1

notionalResetType

string

4409 

SECURITYDBO

SWAPS

NOTIONAL_RESET_TYPE

VARCHAR2(10)

../notionalResetType

payRecIndicator

string

4590 

SECURITYDBO

SWAPS

PAY_RECEIVE_IND

VARCHAR2(10)

../payRecIndicator

smStateCode

string

1343 

SECURITYDBO

FIXED_INCOME

STATE_CODE 

CHAR(2)

../smStateCode

smDefaultIndicator

string

1551

SECURITYDBO

SECURITY_MASTER

DEFAULT_FLAG

CHAR(2)

../smDefaultIndicator

smPoolNumber

string

1439

SECURITYDBO

SECURITY_MASTER

POOL_NUMBER

CHAR(12)

../smPoolNumber