Extract and Load Solution Implementation

You can extract and load data via the following Eagle-provided sample IWS workflow solutions:

The following table summarizes the status of the currently supported EagleML types and the associated load and extract process names.

NOTE: The Extract/Load File Name Pattern column contains patterns that must be used in names of files to be loaded via the generic_load. The same pattern is applied to extract file names. For example, if you perform an Entity List extract, a file with the name GEN_EXTRACT_150901110525_ENTITYLIST_246.xml is created. At the same time, to load an Entity List file to the database correctly, the file name must contain the _ENTITYLIST_ pattern.

Sub Group	Supported EagleML Type	Extract/Load File Name Pattern	Load Process Name	Extract Process Name	Comments/Status
SMF	Generic SMF	_GENERICSMF_	load_generic_smf	extract_generic_smf
	Generic SMF MI	_GENERICSMFMI_	load_generic_smf_mi		Only load object
	Multiple Leg SMF	_MULTILEGSMF_	load_generic_multi_leg_smf		Only load object
ENTITY	Entity List	_ENTITYLIST_	load_entity_list	extract_entity_list
	Entity To List	_ENTITYTOLIST_	load_entity_to_list		Only load object
	Entities In List	_ENTITIESINLIST_	load_entities_in_list	extract_entities_in_list	In development/modification
	Entity Composite	_ENTITYCOMPOSITE_	load_entity_composite	extract_entity_composite
	Entity To Composite	_ENTITYTOCOMPOSITE_	load_entity_to_composite		Only load object
	Composite Entity List	_COMPOSITEENTITYLIST_	load_entities_in_composite	extract_entities_in_composite	In development/modification
	Entity Bank Relationship	_ENTITYBANKRELATIONSHIP_	load_entity_bank_relationship	extract_entity_bank_relationship
	Entity Accounting Basis	_ENTITYACCOUNTINGBASIS_	load_entity_accounting_basis	extract_entity_accounting_basis
	Entity XREF	_ENTITYXREF_	load_entity_xref
	Generic Entity	_GENERICENTITY_	load_generic_entity	extract_generic_entity
	Entity Manager	_ENTITYMANAGER_	load_entity_manager	extract_entity_manager
	Entity Manager Relationship	_ENTITYMANAGERRELATIONSHIP_	load_entity_manager_relationship	extract_entity_manager_relationship
	Entity Identifiers	_ENTITYIDENTIFIERS_	load_entity_identifiers	extract_entity_identifiers	In development/modification
	Entity Accounting Periods	_ENTITYACCOUNTINGPERIODS_	load_entity_accounting_periods	extract_entity_accounting_periods
	GIPS Composite	_GIPSCOMPOSITE_	load_gips_composite	extract_gips_composite
	Entity Benchmark Assignment	_BENCHMARKASSIGNMENT_	load_entity_benchmark_assignment		Only load object
	Entity Entitlement List	_ENTITYENTITLEMENTLIST_		extract_entity_entitlement_list	Only extract object
	Entity Share Class	_ENTITYSHARECLASS_		extract_entity_share_class	Only extract object
RULE	Month End Date Rule	_MONTHENDDATERULE_	load_rule_month_end_date	extract_rule_month_end_date
	Earn Thru Rule	_EARNTHRURULE_	load_rule_earn_thru	extract_rule_earn_thru
	Contractual Cash Settlement Rule	_CONTRACTUALCASHSETTLEMENTRULE_	load_rule_contractual_cash_settlement	extract_rule_contractual_cash_settlement
	Contract Cash Rule	_CONTRACTCASHRULE_	load_rule_contract_cash	extract_rule_contract_cash
	Basis Processing Rule	_BASISPROCESSINGRULE_	load_rule_basis_processing	extract_rule_basis_processing
	Backup Withholding Rule	_BACKUPWITHHOLDINGRULE_	load_rule_backup_withholding	extract_rule_backup_withholding
	Amortization Schedule Rule	_AMORTIZATIONSCHEDULERULE_	load_rule_amortization_schedule	extract_rule_amortization_schedule
	Accounting Rule	_ACCOUNTINGRULE_	load_rule_accounting	extract_rule_accounting
	Primary Mixed Cost Basis Rule	_PRIMARYMIXEDCOSTBASISRULE_	load_rule_primary_mixed_cost_basis	extract_rule_primary_mixed_cost_basis
Warehouse	Warehouse Open Lot	_WAREHOUSEOPENLOT_	load_warehouse_openlot
	Warehouse Open Lot XMLDBAPI	_WAREHOUSEOPENLOTXMLDBAPI_	load_warehouse_openlot_xmldbapi	extract_warehouse_openlot
	Warehouse Close Lot	_WAREHOUSECLOSELOT_	load_warehouse_closelot	extract_warehouse_closelot
	Warehouse Position	_WAREHOUSEPOSITION_	load_warehouse_position
	Warehouse Position XMLDBAPI	_WAREHOUSEPOSITIONXMLDBAPI_	load_warehouse_position_xmldbapi	extract_warehouse_position
	Warehouse Trade	_WAREHOUSETRADE_	load_warehouse_trade	extract_warehouse_trade
	Warehouse Trade Charges	_WAREHOUSETRADECHARGES_	load_warehouse_trade_charges		Only load object
	Warehouse Cash Activity	_WAREHOUSECASHACTIVITY_	load_warehouse_cash_activity	extract_warehouse_cash_activity
	Warehouse Performance	_WAREHOUSEPERFORMANCE_	load_warehouse_performance	extract_warehouse_performance
	Warehouse GL Balances	_WAREHOUSEGLBALANCES_	load_warehouse_glbalances	extract_warehouse_glbalances
	Warehouse NAV	_WAREHOUSENAV_	load_warehouse_nav	extract_warehouse_nav
	Warehouse NAV Multi	_WAREHOUSENAVMULTI_	load_warehouse_nav_multi	extract_warehouse_nav_multi
	Warehouse Pending Trade	_WAREHOUSEPENDINGTRADE_	load_warehouse_pending_trade	extract_warehouse_pending_trade
	Warehouse Broker Trade Quote	_WAREHOUSEBROKERTRADEQUOTE_	load_warehouse_broker_trade_quote	extract_warehouse_broker_trade_quote
	Warehouse Cash Flow Projection	_WAREHOUSECASHFLOWPROJECTION_	load_warehouse_cash_flow_projection	extract_warehouse_cash_flow_projection
	Trade Quotes	_TRADEQUOTES_	load_trade_quotes	extract_trade_quotes
	Warehouse Trade XREF	_WAREHOUSETRADEXREFERENCE_	load_warehouse_trade_xreference		Only load object
	Custody Restriction Activity	_CUSTODYRESTRICTIONACTIVITY_		extract_custody_restriction_activity	Only extract object
	Custody Restriction Balance	_CUSTODYRESTRICTIONBALANCE_		extract_custody_restriction_balance	Only extract object
	Warehouse Insurance Valuation Lot	_INSURANCEVALUATIONLOT_		extract_warehouse_istarlot	Only extract object
	Warehouse Disclosure Status	_WAREHOUSEDISCLOSURESTATUS_	load_warehouse_disclosure_status	extract_warehouse_disclosure_status	MAY2017
ISSUER	Issuer MI	_ISSUERMI_	load_issuer_mi		Only load object
	Issuer	_ISSUER_	load_issuer	extract_issuer
	Issuer Organization	_ISSUERORGANIZATION_	load_issuer_organization	extract_issuer_organization
	Issuer Role	_ISSUERROLE_	load_issuer_role	extract_issuer_role
	Issuer Entity Relationship	_ISSUERENTITYRELATIONSHIP_	load_issuer_entity_relationship	extract_issuer_entity_relationship	MAY2017
	Issuer Relationship	_ISSUERRELATIONSHIP_	load_issuer_relationship	extract_issuer_relationship
	Issuer Rating	_ISSUERRATING_		extract_issuer_rating
	Role Model	_ROLEMODEL_	load_issuer_role_model		Only load object
	Issuer Xref	_ISSUERXREF_	load_issuer_xref		Only load object
System	Code Value	_CODEVALUE_	load_code_value	extract_code_value
	Code Category	_CODECATEGORY_	load_code_category	extract_code_category
	Code Translation	_CODETRANSLATION_	load_code_translation	extract_code_translation
	Calendar	_CALENDAR_	load_calendar	extract_calendar
	Calendar Holiday	_CALENDARHOLIDAY_	load_calendar_holiday	extract_calendar_holiday
	Calendar Business Dates	_CALENDARBUSINESSDATES_		extract_calendar_business_dates	Only extract object
	Error Definition	_ERRORDEFINITION_	load_error_definition	extract_error_definition
	Yield Curve	_YIELDCURVE_	load_yield_curve	extract_yield_curve
	Run Time Stamps	_RUNTIMESTAMPS_		extract_run_time_stamps	Only extract object
	Ledger Notes	_LEDGERNOTES_	load_ledger_notes	extract_ledger_notes
	GIPS Disclosures	_GIPSDISCLOSURES_	load_gips_disclosures	extract_gips_disclosures
Security Related	Issue Analytic	_ISSUEANALYTIC_	load_issue_analytic		Only load object
	Issue Fx Rate	_ISSUEFXRATE_	load_issue_fx_rate	extract_issue_fx_rate
	Issue Pc Price	_ISSUEPCPRICE_	load_issue_pc_price		Only load object
	Issue Price	_ISSUEPRICE_	load_issue_price	extract_issue_price
	Issue Variable Rate	_ISSUEVARIABLERATE_	load_issue_variable_rate	extract_issue_variable_rate
	Issue Fx Pc Rate	_ISSUEFXPCRATE_	load_issue_fx_pc_rate	extract_issue_fx_pc_rate
	Generic Issue Analytic	_GENERICISSUEANALYTIC_	load_generic_issue_analytic	extract_generic_issue_analytic
	Exchange Price	_EXCHANGEPRICE_	load_exchange_price	extract_issue_exchange_price
	Schedule	_SCHEDULE_	load_schedule	extract_schedule
	Rating	_RATING_	load_rating	extract_rating
	Vendor Cash Flow	_VENDORCASHFLOW_	load_vendor_cash_flow		Only load object
	Security Notes	_SECURITYNOTES_	load_security_notes		Only load object
	Factor	_FACTOR_	load_factor	extract_factor
	Model Price	_MODELPRICE_	load_model_price		Only load object
	SMF Identifiers	_SMFIDENTIFIERS_	load_smfidentifiers	extract_smfidentifiers	In development/modification
	Time Series	_TIMESERIES_	load_time_series	extract_time_series
	SMF Identifier	_SMFIDENTIFIER_	load_smf_identifier
	Underlying SMF	_UNDERLYINGSMF_	load_underlying_smf		Only load object
	Recovery Rate	_RECOVERYRATE_	load_recovery_rate		Only load object
	Earnings Time Period Model	_EARNINGSTIMEPERIODMODEL_	load_earnings_time_period_model		Only load object
	Forward Points	_FORWARDPOINTS_		extract_forward_points	Only extract object
	Security Overrides	_SECURITYOVERRIDES_		extract_security_overrides	Only extract object
	NAIC Designation	_NAICDESIGNATION_		extract_naic_designation	Only extract object
Client	Client	_CLIENT_	load_client	extract_client
Client	Client Communication	_CLIENTCOMMUNICATION_	load_client_communication	extract_client_communication
Corporate Action	GenericCA	_GENERICCA_	load_generic_ca	extract_generic_ca
	VoluntaryCAElection	_VOLUNTARYCAELECTION_	load_voluntary_ca_election	extract_voluntary_ca_election
	MandatoryCAExclusion	_MANDATORYCAEXCLUSION_	load_mandatory_ca_exclusion		Only load object
Financial Event	Financial Event	_FINANCIALEVENT_		extract_financial_event	Only extract object
Accounting	Cost Basis Adjustment	_COSTBASISADJUSTMENT_	load_accounting_cost_basis_adjustment		Only load object
	Accounting Trade	_ACCOUNTINGTRADE_	load_accounting_trade	extract_accounting_trade
	Accounting Cash	_ACCOUNTINGCASH_	load_accounting_cash		Only load object
	Accounting Asset Cash	_ACCOUNTINGASSETCASH_	load_accounting_asset_cash		Only load object
	Accounting Reclaim Cash	_ACCOUNTINGRECLAIMCASH_	load_accounting_reclaim_cash		Only load object
	Multiple Leg Accounting Trade	_MULTIPLELEGACCOUNTINGTRADE_	load_accounting_trade_multi_leg		Only load object
	Impairments	_IMPAIRMENTS_	load_accounting_impairments		Only load object
	Impairments	_IMPAIRMENTS_	load_accounting_impairments		(available in NOV2015 release)
	Accrued Income	_ACCRUEDINCOME_		extract_accounting_accrued_income	Only extract object
	Subscribe Reedem	_SUBSCRIBEREEDEM_		extract_accounting_subscribe_reedem	Only extract object
	Daily Yield Mill Rate	_DAILYYIELDMILLRATE_		extract_accounting_daily_mill_rate	Only extract object
	Unsettled Transactions	_UNSETTLEDTRANSACTIONS_		extract_accounting_unsettled_trans	Only extract object
	Cash Journal	_CASHJOURNAL_		extract_accounting_cash_journal	Only extract object
	Realized Gain Loss	_REALIZEDGAINLOSS_		extract_accounting_realized_gl	Only extract object
	Settled Cash Activity	_SETTLEDCA_		extract_accounting_settled_ca	Only extract object
	Consolidated Earned Income	_CONSEARNEDINCOME_		extract_accounting_cons_earned_income	Only extract object
	General Ledger Activity	_GENERALLEDGERACTIVITY_		extract_accounting_gl_activity	Only extract object
	Traded Cash Activity	_TRADEDCASHACTIVITY_		extract_accounting_traded_cash_activity	Only extract object
	Distribution Activity	_DISTRIBUTIONACT_		extract_accounting_distribution_activity	Only extract object
	Cash Projections	_CASHPROJECTIONS_		extract_cash_projections	Only extract object
	Custom Ledger Account	_CUSTLEDGERACCT_		extract_accounting_custom_ledger_acct	Only extract object
	Open Rec Pay Multi	_OPENRECPAYMULTI_		extract_accounting_open_rec_pay_multi	Only extract object
	Unapproved Variation Margin	_UNAPPROVEDVARMARGIN_		extract_accounting_unapproved_var_margin	Only extract object
	Trial Balance	_TRIALBALANCEEXTRACT_		extract_accounting_trial_balance	Only extract object
	Accounting Intraday NAV	_INTRADAYNAV_		extract_accounting_intraday_nav	Only extract object
	Accounting NAV for NASDAQ	_NAVFORNASDAQ_		extract_accounting_nav_for_nasdaq	Only extract object
	Accounting Fair Value Comparison	_FAIRVALUECOMPARISON_		extract_accounting_fair_value_comparison	Only extract object