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 |
---|---|---|---|---|---|---|
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 | ../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 |