Entity Share Class Model Data Map Table

This is an extract-only model, added to the extract by includeEntityShareClass=Y task parameter in the RTR. Currently available for a limited number of feedtypes. 

Element

Value Type

Eagle DB

DB Table

DB Field

DB Field Type

Xpath

Element

Value Type

Eagle DB

DB Table

DB Field

DB Field Type

Xpath

classCode

string

RULESDBO

ENTITY_SHARE_CLASS

CLASS_CODE

VARCHAR2(10)

../classCode

className

string

RULESDBO

ENTITY_SHARE_CLASS

CLASS_NAME

VARCHAR2(60)

../className

classStatus

string

RULESDBO

ENTITY_SHARE_CLASS

CLASS_STATUS

VARCHAR2(15)

../classStatus

sharesCount

integer

not stored in DB

 

../sharesCount

heldAsset

Asset Identifiers Model

../heldAsset/

transferAgency

string

RULESDBO

ENTITY_SHARE_CLASS

TRANSFER_AGENCY

VARCHAR2(60)

../transferAgency

taCode

string

RULESDBO

ENTITY_SHARE_CLASS

TA_CODE

VARCHAR2(15)

../taCode

shareClassNasdaqSymbol

string

RULESDBO

ENTITY_SHARE_CLASS

NASDAQ_SYMBOL

CHAR(100)

../shareClassNasdaqSymbol

classTerminationDt

date

RULESDBO

ENTITY_SHARE_CLASS

CLASS_TERMINATION_DT

DATE

../classTerminationDt

classTicker

string

RULESDBO

ENTITY_SHARE_CLASS

TICKER

VARCHAR2(100)

../classTicker

classCusip

string

RULESDBO

ENTITY_SHARE_CLASS

CUSIP

VARCHAR2(100)

../classCusip

classIsin

string

RULESDBO

ENTITY_SHARE_CLASS

ISIN

VARCHAR2(100)

../classIsin

dailyFixedDistRate

decimal

RULESDBO

ENTITY_SHARE_CLASS

DAILY_FIXED_DIST_RATE

NUMBER(32,12)

../dailyFixedDistRate

monthlyDistRate

decimal

RULESDBO

ENTITY_SHARE_CLASS

MONTHLY_DIST_RATE

NUMBER(32,12)

../monthlyDistRate

inceptionNav

decimal

RULESDBO

ENTITY_SHARE_CLASS

INCEPTION_NAV

NUMBER(32,12)

../inceptionNav

securityIdentifier

string

RULESDBO

ENTITY_SHARE_CLASS

SECURITY_IDENTIFIER

CHAR(100)

../securityIdentifier

nasdaqListingStartDate

date

RULESDBO

ENTITY_SHARE_CLASS

NASDAQ_LISTING_START_DATE

DATE

../nasdaqListingStartDate

nasdaqListingEndDate

date

RULESDBO

ENTITY_SHARE_CLASS

NASDAQ_LISTING_END_DATE

DATE

../nasdaqListingEndDate

loadCharge

decimal

RULESDBO

ENTITY_SHARE_CLASS

LOAD_CHARGE

NUMBER(28,12)

../loadCharge

loadEffectiveDate

date

RULESDBO

ENTITY_SHARE_CLASS

LOAD_EFFECTIVE_DATE

DATE

../loadEffectiveDate

userChar1

string

RULESDBO

ENTITY_SHARE_CLASS

USER_CHAR1

VARCHAR2(10)

../userChar1

userChar2

string

RULESDBO

ENTITY_SHARE_CLASS

USER_CHAR2

VARCHAR2(10)

../userChar2

ind12b1

string

RULESDBO

ENTITY_SHARE_CLASS

IND_12B1

VARCHAR2(3)

../ind12b1

navCurrency

string

RULESDBO

ENTITY_SHARE_CLASS

NAV_CURRENCY

CHAR(3)

../navCurrency

exchange

string

RULESDBO

ENTITY_SHARE_CLASS

EXCHANGE

VARCHAR2(8)

../exchange

classInceptionDate

date

RULESDBO

ENTITY_SHARE_CLASS

CLASS_INCEPTION_DATE

DATE

../classInceptionDate

heldAsSecurity

string

RULESDBO

ENTITY_SHARE_CLASS

HELD_AS_SECURITY

VARCHAR2(1)

../heldAsSecurity

navPricePrecision

integer

RULESDBO

ENTITY_SHARE_CLASS

NAV_PRICE_PRECISION

NUMBER

../navPricePrecision

bidSpreadFactor

decimal

RULESDBO

ENTITY_SHARE_CLASS

BID_SPREAD_FACTOR

NUMBER(38,6)

../bidSpreadFactor

bidFormula

string

RULESDBO

ENTITY_SHARE_CLASS

BID_FORMULA

VARCHAR2(20)

../bidFormula

offerSpreadFactor

decimal

RULESDBO

ENTITY_SHARE_CLASS

OFFER_SPREAD_FACTOR

NUMBER(38,6)

../offerSpreadFactor

offerFormula

string

RULESDBO

ENTITY_SHARE_CLASS

OFFER_FORMULA

VARCHAR2(20)

../offerFormula

euroEqualMethod

string

RULESDBO

ENTITY_SHARE_CLASS

EURO_EQUAL_METHOD

VARCHAR2(15)

../euroEqualMethod

baseClass

string

RULESDBO

ENTITY_SHARE_CLASS

BASE_CLASS

VARCHAR2(1)

../baseClass

contractualExpRatio

decimal

RULESDBO

ENTITY_SHARE_CLASS

CONTRACTUAL_EXP_RATIO

NUMBER(38,6)

../contractualExpRatio

shareClassId

string

RULESDBO

ENTITY_SHARE_CLASS

SHARE_CLASS_ID

CHAR(8)

../shareClassId

minimumYield

decimal

RULESDBO

ENTITY_SHARE_CLASS

MINIMUM_YIELD

NUMBER(38,12)

../minimumYield

niiDistributionMethod

string

RULESDBO

ENTITY_SHARE_CLASS

NII_DISTRIBUTION_METHOD

VARCHAR2(25)

../niiDistributionMethod

classHedging

string

RULESDBO

ENTITY_SHARE_CLASS

CLASS_HEDGING

VARCHAR2(1)

../classHedging

hedgingMethod

string

RULESDBO

ENTITY_SHARE_CLASS

HEDGING_METHOD

VARCHAR2(1)

../hedgingMethod