About the Extract and Load IWS Solutions
You can extract and load data via the following Eagle-provided sample IWS workflow solutions:
| Child pages (Children Display) |
|---|
- The generic data extract IWS workflow solution
- The generic data load IWS workflow solution
The following table summarizes the status of the currently supported EagleML types and the associated load and extract process names.
...
| 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 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 | ||
| (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_ |
...
...
1
...
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 Disclosures
...
_GIPSDISCLOSURES_
...
load_gips_disclosures
...
extract_gips_disclosures
...
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
...
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 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
...
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 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
...
(available in NOV 2015 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
2
You can extract and load data via the following Eagle-provided sample IWS workflow solutions:
| Child pages (Children Display) |
|---|
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.
The following table summarizes the status of the currently supported EagleML types and the associated load and extract process names.
1
...
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 Disclosures
...
_GIPSDISCLOSURES_
...
load_gips_disclosures
...
extract_gips_disclosures
...
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
...
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 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
...
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 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
...
(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
2
...
| extract_accounting_fair_value_comparison | Only extract object |