Index SMF Data Map Table
- Natalie Gesin (Deactivated)
- Kinga Huszno
- Dmitry Donosiyan (Unlicensed)
Ā
Element | Required Inbound Acct Validation | Required Inbound Data Mgt | Value Type | Star Tag | SP Parameter | SP Type | Include File Name | Eagle DB | DB Table | DB Field | DB Field Type | Xpath |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
objectType | Required | Ā | ObjectTypeEnum | - | Ā | Ā | Ā | not stored in DB | Ā | EagleML/referenceTransaction/genericSMF/objectType | ||
objectId | Ā | Ā | ObjectId | - | Ā | Ā | Ā | not stored in DB | Ā | EagleML/referenceTransaction/genericSMF/objectId | ||
objectDescription | Ā | Ā | FeedTypeEnum | - | Ā | Ā | Ā | not stored in DB | Ā | EagleML/referenceTransaction/genericSMF/objectDescription | ||
updateTimestamp | Ā | Ā | dateTime | - | Ā | Ā | Ā | not stored in DB | Ā | EagleML/referenceTransaction/genericSMF/updateTimestamp | ||
sourceName | Required | Required | string | 1102 | in_short_desc | S | referenceobject.inc | PACE_MASTERDBO | INTERFACES | SHORT_DESC | CHAR(15) | EagleML/referenceTransaction/genericSMF/sourceName |
updateSource | Required | Ā | string | 944 | in_update_source | S | referenceobject.inc | SECURITYDBO | SECURITY_MASTER | UPDATE_SOURCE | CHAR(255) | EagleML/referenceTransaction/genericSMF/updateSource |
effectiveDate | Required | Required | date | 1109 | in_effective_date | S | referenceobject.inc | SECURITYDBO | All history (_HIST) tables | EFFECTIVE_DATE | DATE | EagleML/referenceTransaction/genericSMF/effectiveDate |
accountingValidationFlag | Required | Ā | YesNoOptionEnum | Ā | Ā | Ā | Ā | not stored in DB, used to manage the download logic | Ā | EagleML/referenceTransaction/genericSMF/accountingValidationFlag | ||
EagleML/referenceTransaction/genericSMF/ | ||||||||||||
historyOnlyFlag | Ā | Ā | YesNoOptionEnum | 1257 | in_trans_type | S | smfflags_model.inc | not stored in DB, used for resolution logic | Ā | EagleML/referenceTransaction/genericSMF/historyOnlyFlag | ||
spokeCheckFlag | Ā | Ā | integer | 7250 | in_hub_tag | I | smfflags_model.inc | not stored in DB, used for resolution logic | Ā | EagleML/referenceTransaction/genericSMF/spokeCheckFlag | ||
inactiveFlag | Ā | Ā | YesNoOptionEnum | 11043 | in_inactive_flag | S | smfflags_model.inc | SECURITYDBO | SECURITY_MASTER | INACTIVE_FLAG | VARCHAR2(3) | EagleML/referenceTransaction/genericSMF/inactiveFlag |
vendorModeFlag | Ā | Ā | VendorModeFlagEnum | 1085 | Ā | Ā | smfflags_model.inc | not stored in DB, used for resolution logic | Ā | EagleML/referenceTransaction/genericSMF/vendorModeFlag | ||
updateMasterTablesFlag | Ā | Ā | string | 990 | in_tag_list | S | smfflags_model.inc | not stored in DB, used for resolution logic | Ā | EagleML/referenceTransaction/genericSMF/updateMasterTablesFlag | ||
journalizingFlag | Ā | Ā | JournalizingFlagFlagEnum | 1293 | in_journal_flag | S | smfflags_model.inc | not stored in DB, used for resolution logic | Ā | EagleML/referenceTransaction/genericSMF/journalizingFlag | ||
fieldCompareFlag | Ā | Ā | YesNoOptionEnum | 989 | in_989_flag | S | smfflags_model.inc | not stored in DB, used for resolution logic | Ā | EagleML/referenceTransaction/genericSMF/fieldCompareFlag | ||
investmentType | Required | Ā | StringWithCodeScheme | 11 | in_investment_type | S | smfobject.inc | SECURITYDBO | SECURITY_MASTER | INVESTMENT_TYPE | CHAR(4) | EagleML/referenceTransaction/genericSMF/investmentType |
processingSecurityType | Required | Required | StringWithCodeScheme | 3931 | in_process_sec_type | S | smfobject.inc | SECURITYDBO | SECURITY_MASTER | PROCESS_SEC_TYPE | VARCHAR2(15) | EagleML/referenceTransaction/genericSMF/processingSecurityType |
securityType | Ā | Ā | string | 82 | in_security_type | S | generic_smf_base_model.inc | SECURITYDBO | SECURITY_MASTER | SECURITY_TYPE | CHAR(15) | EagleML/referenceTransaction/genericSMF/securityType |
securitySubType | Ā | Ā | string | 1464 | in_alt_security_type | S | smfobject.inc | SECURITYDBO | SECURITY_MASTER_DETAIL | ALT_SECURITY_TYPE | CHAR(15) | EagleML/referenceTransaction/genericSMF/securitySubType |
quantityType | Required - Defaulted to "PAR" by panel | Ā | StringWithCodeScheme | 12 | in_quantity_type | S | generic_smf_base_model.inc | SECURITYDBO | SECURITY_MASTER | QUANTITY_TYPE | CHAR(12) | EagleML/referenceTransaction/genericSMF/quantityType |
priceMultiplier | Required - Defaulted to "0.0100" by panel | Ā | decimal | 18 | in_price_multiplier | F | smfobject.inc | SECURITYDBO | SECURITY_MASTER | PRICE_MULTIPLIER | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/priceMultiplier |
quantityScale | Required - Defaulted to "1.00" by panel | Ā | decimal | 19 | in_sm_trading_unit | F | smfobject.inc | SECURITYDBO | SECURITY_MASTER | TRADING_UNIT | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/quantityScale |
countryOfRiskCode | Ā | Ā | CountryCode | 10536 | in_country_of_risk | S | generic_smf_base_model.inc | SECURITYDBO | SECURITY_MASTER_DETAIL | COUNTRY_OF_RISK | VARCHAR2(20) | EagleML/referenceTransaction/genericSMF/countryOfRiskCode |
FixedIncomeModel | Ā | Ā | FixedIncomeModel | EagleML/referenceTransaction/genericSMF/FixedIncomeModel | ||||||||
IndexModel | Ā | Ā | IndexModel | Index Model - accounting specific model, is under construction (see extra table) | EagleML/referenceTransaction/genericSMF/IndexModel | |||||||
Ā