Entity Share Class Data Map Table
- Natalie Gesin (Deactivated)
- Vitali Kostyrenko
- Dmitry Donosiyan (Unlicensed)
Element | Required Inbound Acct Validation | Required Inbound Data Mgt | Value Type | Eagle DB | DB Table | DB Field | DB Field Type | DB Required | Xpath |
|---|---|---|---|---|---|---|---|---|---|
objectType | Required | Required | objectTypeEnum | not stored in DB | EagleML/entityTransaction/entityShareClass/objectType | ||||
objectId | objectId | not stored in DB | EagleML/entityTransaction/entityShareClass/objectId | ||||||
objectDescription | FeedTypeEnum | not stored in DB | EagleML/entityTransaction/entityShareClass/objectDescription | ||||||
updateTimestamp | Required - Defaulted to "Current Date" by panel | dateTime | RULESDBO | ENTITY_SHARE_CLASS | UPDATE_DATE | DATE | N | EagleML/entityTransaction/entityShareClass/updateTimestamp | |
customElements | not recommended | CustomElements | CustomElements reserved for customizations | EagleML/entityTransaction/entityShareClass/customElements | |||||
updateSource | Required - Defaulted to "User ID" by panel | string | RULESDBO | ENTITY_SHARE_CLASS | UPDATE_SOURCE | CHAR(30) | N | EagleML/entityTransaction/entityShareClass/updateSource | |
accountingValidationFlag | YesNoOptionEnum | not stored in DB, manages logic for the load | EagleML/entityTransaction/entityShareClass/accountingValidationFlag | ||||||
entityShareClass | EntityCommonIdModel | EagleML/entityTransaction/entityShareClass/ | |||||||
effectiveDate | Required | date | RULESDBO | ENTITY_SHARE_CLASS | EFFECTIVE_DATE | DATE | N | EagleML/entityTransaction/entityShareClass/effectiveDate | |
classCode | Required | Required | string | RULESDBO | ENTITY_SHARE_CLASS | CLASS_CODE | VARCHAR2(10) | Y | EagleML/entityTransaction/entityShareClass/classCode |
className | Required - Defaulted to "Class Code" value by panel | string | RULESDBO | ENTITY_SHARE_CLASS | CLASS_NAME | VARCHAR2(60) | N | EagleML/entityTransaction/entityShareClass/className | |
classStatus | string | RULESDBO | ENTITY_SHARE_CLASS | CLASS_STATUS | VARCHAR2(15) | N | EagleML/entityTransaction/entityShareClass/classStatus | ||
sharesCount | integer | not stored in DB | EagleML/entityTransaction/entityShareClass/sharesCount | ||||||
heldAsset | EagleML/entityTransaction/entityShareClass/heldAsset/ | ||||||||
transferAgency | string | RULESDBO | ENTITY_SHARE_CLASS | TRANSFER_AGENCY | VARCHAR2(60) | N | EagleML/entityTransaction/entityShareClass/transferAgency | ||
taCode | string | RULESDBO | ENTITY_SHARE_CLASS | TA_CODE | VARCHAR2(15) | N | EagleML/entityTransaction/entityShareClass/taCode | ||
nasdaqSymbol | string | RULESDBO | ENTITY_SHARE_CLASS | NASDAQ_SYMBOL | CHAR(100) | N | EagleML/entityTransaction/entityShareClass/nasdaqSymbol | ||
classTerminationDt | date | RULESDBO | ENTITY_SHARE_CLASS | CLASS_TERMINATION_DT | DATE | N | EagleML/entityTransaction/entityShareClass/classTerminationDt | ||
| classTicker | string | RULESDBO | ENTITY_SHARE_CLASS | TICKER | VARCHAR2(100) | N | EagleML/entityTransaction/entityShareClass/classTicker | ||
| classCusip | string | RULESDBO | ENTITY_SHARE_CLASS | CUSIP | VARCHAR2(100) | N | EagleML/entityTransaction/entityShareClass/classCusip | ||
| classIsin | string | RULESDBO | ENTITY_SHARE_CLASS | ISIN | VARCHAR2(100) | N | EagleML/entityTransaction/entityShareClass/classIsin | ||
dailyFixedDistRate | decimal | RULESDBO | ENTITY_SHARE_CLASS | DAILY_FIXED_DIST_RATE | NUMBER(32,12) | N | EagleML/entityTransaction/entityShareClass/dailyFixedDistRate | ||
monthlyDistRate | decimal | RULESDBO | ENTITY_SHARE_CLASS | MONTHLY_DIST_RATE | NUMBER(32,12) | N | EagleML/entityTransaction/entityShareClass/monthlyDistRate | ||
inceptionNav | Required | decimal | RULESDBO | ENTITY_SHARE_CLASS | INCEPTION_NAV | NUMBER(32,12) | N | EagleML/entityTransaction/entityShareClass/inceptionNav | |
securityIdentifier | Required - Defaulted to "1" by panel | string | RULESDBO | ENTITY_SHARE_CLASS | SECURITY_IDENTIFIER | CHAR(100) | N | EagleML/entityTransaction/entityShareClass/securityIdentifier | |
nasdaqListingStartDate | date | RULESDBO | ENTITY_SHARE_CLASS | NASDAQ_LISTING_START_DATE | DATE | N | EagleML/entityTransaction/entityShareClass/nasdaqListingStartDate | ||
nasdaqListingEndDate | date | RULESDBO | ENTITY_SHARE_CLASS | NASDAQ_LISTING_END_DATE | DATE | N | EagleML/entityTransaction/entityShareClass/nasdaqListingEndDate | ||
loadCharge | decimal | RULESDBO | ENTITY_SHARE_CLASS | LOAD_CHARGE | NUMBER(28,12) | N | EagleML/entityTransaction/entityShareClass/loadCharge | ||
loadEffectiveDate | date | RULESDBO | ENTITY_SHARE_CLASS | LOAD_EFFECTIVE_DATE | DATE | N | EagleML/entityTransaction/entityShareClass/loadEffectiveDate | ||
userChar1 | string | RULESDBO | ENTITY_SHARE_CLASS | USER_CHAR1 | VARCHAR2(10) | N | EagleML/entityTransaction/entityShareClass/userChar1 | ||
userChar2 | string | RULESDBO | ENTITY_SHARE_CLASS | USER_CHAR2 | VARCHAR2(10) | N | EagleML/entityTransaction/entityShareClass/userChar2 | ||
ind12b1 | string | RULESDBO | ENTITY_SHARE_CLASS | IND_12B1 | VARCHAR2(3) | N | EagleML/entityTransaction/entityShareClass/ind12b1 | ||
navCurrency | string | RULESDBO | ENTITY_SHARE_CLASS | NAV_CURRENCY | CHAR(3) | N | EagleML/entityTransaction/entityShareClass/navCurrency | ||
exchange | string | RULESDBO | ENTITY_SHARE_CLASS | EXCHANGE | VARCHAR2(8) | N | EagleML/entityTransaction/entityShareClass/exchange | ||
classInceptionDate | Required - Defaulted to "Inception Date of the Entity" by panel | date | RULESDBO | ENTITY_SHARE_CLASS | CLASS_INCEPTION_DATE | DATE | N | EagleML/entityTransaction/entityShareClass/classInceptionDate | |
heldAsSecurity | string | RULESDBO | ENTITY_SHARE_CLASS | HELD_AS_SECURITY | VARCHAR2(1) | N | EagleML/entityTransaction/entityShareClass/heldAsSecurity | ||
navPricePrecision | integer | RULESDBO | ENTITY_SHARE_CLASS | NAV_PRICE_PRECISION | NUMBER | N | EagleML/entityTransaction/entityShareClass/navPricePrecision | ||
bidSpreadFactor | decimal | RULESDBO | ENTITY_SHARE_CLASS | BID_SPREAD_FACTOR | NUMBER(38,6) | N | EagleML/entityTransaction/entityShareClass/bidSpreadFactor | ||
bidFormula | string | RULESDBO | ENTITY_SHARE_CLASS | BID_FORMULA | VARCHAR2(20) | N | EagleML/entityTransaction/entityShareClass/bidFormula | ||
offerSpreadFactor | decimal | RULESDBO | ENTITY_SHARE_CLASS | OFFER_SPREAD_FACTOR | NUMBER(38,6) | N | EagleML/entityTransaction/entityShareClass/offerSpreadFactor | ||
offerFormula | string | RULESDBO | ENTITY_SHARE_CLASS | OFFER_FORMULA | VARCHAR2(20) | N | EagleML/entityTransaction/entityShareClass/offerFormula | ||
euroEqualMethod | string | RULESDBO | ENTITY_SHARE_CLASS | EURO_EQUAL_METHOD | VARCHAR2(15) | N | EagleML/entityTransaction/entityShareClass/euroEqualMethod | ||
baseClass | string | RULESDBO | ENTITY_SHARE_CLASS | BASE_CLASS | VARCHAR2(1) | N | EagleML/entityTransaction/entityShareClass/baseClass | ||
contractualExpRatio | decimal | RULESDBO | ENTITY_SHARE_CLASS | CONTRACTUAL_EXP_RATIO | NUMBER(38,6) | N | EagleML/entityTransaction/entityShareClass/contractualExpRatio | ||
shareClassId | string | RULESDBO | ENTITY_SHARE_CLASS | SHARE_CLASS_ID | CHAR(8) | N | EagleML/entityTransaction/entityShareClass/shareClassId | ||
minimumYield | decimal | RULESDBO | ENTITY_SHARE_CLASS | MINIMUM_YIELD | NUMBER(38,12) | N | EagleML/entityTransaction/entityShareClass/minimumYield | ||
niiDistributionMethod | string | RULESDBO | ENTITY_SHARE_CLASS | NII_DISTRIBUTION_METHOD | VARCHAR2(25) | N | EagleML/entityTransaction/entityShareClass/niiDistributionMethod | ||
| classHedging | string | RULESDBO | ENTITY_SHARE_CLASS | CLASS_HEDGING | VARCHAR2(1) | N | EagleML/entityTransaction/entityShareClass/classHedging | ||
| hedgingMethod | string | RULESDBO | ENTITY_SHARE_CLASS | HEDGING_METHOD | VARCHAR2(1) | N | EagleML/entityTransaction/entityShareClass/hedgingMethod | ||