About the Extract and Load IWS Solutions
name is
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 |
Inbound-only | ||
Multiple Leg SMF | _MULTILEGSMF_ | load_generic_multi_leg_smf |
Inbound-only | ||||
ENTITY | Entity List | _ENTITYLIST_ | load_entity_list | extract_entity_list |
Entity To List | _ENTITYTOLIST_ | load_entity_to_list |
Inbound-only | ||||
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 |
Inbound-only | ||||
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 |
Inbound-only | |
Entity Entitlement List | _ENTITYENTITLEMENTLIST_ |
extract_entity_entitlement_list |
Extract-only | |
Entity Share Class | _ENTITYSHARECLASS_ |
extract_entity_share_class |
Extract-only | ||
Entity Sec Lending | _ENTITYSECLENDING_ | load_ |
entity_seclending | extract_ |
entity_seclending | ||
Entity Statistics | _ENTITYSTATISTICS_ | load_ |
entity_ |
statistics | extract_ |
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
entity_statistics | |||||
Entity Analytics | _ENTITYANALYTIC_ | load_entity_analytics | extract_entity_analytics | ||
Entity Collateral Summ | _ENTITYCOLLATERALSUMM_ | load_entity_collateral_summ | extract_entity_collateral_summ | ||
Entity Regulatory | _ENTITYREGULATORY_ | load_entity_regulatory | extract_entity_regulatory | ||
Entity Peer Group Rankings | _ENTITYPEERGROUPRANKINGS_ | load_entity_peer_group_rantings | extract_entity_peer_group_rantings | ||
Entity Ratings | _ENTITYRATINGS_ | load_entity_ratings | extract_entity_ratings | ||
Custom Benchmark | _CUSTOMBENCHMARK_ | load_custom_benchmark | Inbound-only | ||
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 |
Inbound-only | ||||
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 |
Inbound-only | |||
Custody Restriction Activity | _CUSTODYRESTRICTIONACTIVITY_ | extract_custody_restriction_activity |
Extract-only | |||
Custody Restriction Balance | _CUSTODYRESTRICTIONBALANCE_ | extract_custody_restriction_balance |
Extract-only | |||
Warehouse Insurance Valuation Lot | _INSURANCEVALUATIONLOT_ | extract_warehouse_istarlot |
Extract-only | ||||
Warehouse Disclosure Status | _WAREHOUSEDISCLOSURESTATUS_ | load_warehouse_disclosure_status | extract_warehouse_disclosure_status | MAY2017 |
Warehouse SPD Delta Log | _WRHSSPDDELTALOGEXTRACT_ | load_warehouse_spd_delta_log | extract_spd_delta_log | |
ISSUER | Issuer MI | _ISSUERMI_ | load_issuer_mi |
Inbound-only | ||||
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 | Inbound-only | |
Issuer Xref | _ISSUERXREF_ | load_issuer_xref | Inbound-only | |
Issuer Regulatory | _ISSUERREGULATORY_ | load_issuer_regulatory | extract_issuer_regulatory | |
Issuer ESG | _ISSUERESG_ | load_issuer_ |
isg | extract_issuer_esg | ||||
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 |
Extract-only | ||||
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 |
Extract-only | ||||
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 |
Inbound-only | ||||
Issue Fx Rate | _ISSUEFXRATE_ | load_issue_fx_rate | extract_issue_fx_rate | |
Issue Pc Price | _ISSUEPCPRICE_ | load_issue_pc_price |
Inbound-only | ||||
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 |
Inbound-only | ||
Security Notes | _SECURITYNOTES_ | load_security_notes |
Inbound-only | ||||
Factor | _FACTOR_ | load_factor | extract_factor | |
Model Price | _MODELPRICE_ | load_model_price |
Inbound-only | ||||
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 |
Inbound-only | ||
Recovery Rate | _RECOVERYRATE_ | load_recovery_rate |
Inbound-only | ||
Earnings Time Period Model | _EARNINGSTIMEPERIODMODEL_ | load_earnings_time_period_model |
Inbound-only, load for the SMF model | |||
Forward Points | _FORWARDPOINTS_ | extract_forward_points |
Extract-only | |||
Security Overrides | _SECURITYOVERRIDES_ | extract_security_overrides |
Extract-only | |||
NAIC Designation | _NAICDESIGNATION_ | extract_naic_designation |
Extract-only | |||||
Earnings Time Period | _EARNINGSTIMEPERIOD_ | load_earnings_time_period | extract_earnings_time_period | Load/Extract for Earnings Time Period 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 |
Inbound-only | ||||
Financial Event | Financial Event | _FINANCIALEVENT_ | extract_financial_event |
Extract-only | |||
Accounting | Cost Basis Adjustment | _COSTBASISADJUSTMENT_ | load_accounting_cost_basis_adjustment |
Inbound-only | ||||
Accounting Trade | _ACCOUNTINGTRADE_ | load_accounting_trade | extract_accounting_trade | |
Accounting Cash | _ACCOUNTINGCASH_ | load_accounting_cash |
Inbound-only | ||
Accounting Asset Cash | _ACCOUNTINGASSETCASH_ | load_accounting_asset_cash |
Inbound-only | ||
Accounting Reclaim Cash | _ACCOUNTINGRECLAIMCASH_ | load_accounting_reclaim_cash |
Inbound-only | ||
Multiple Leg Accounting Trade | _MULTIPLELEGACCOUNTINGTRADE_ | load_accounting_trade_multi_leg |
Inbound-only | ||
Impairments | _IMPAIRMENTS_ | load_accounting_impairments |
Inbound-only (available |
since NOV2015 release) | |||
Accrued Income | _ACCRUEDINCOME_ | extract_accounting_accrued_income |
Extract-only | |||
Subscribe Reedem | _SUBSCRIBEREEDEM_ | extract_accounting_subscribe_reedem |
Extract-only | |||
Daily Yield Mill Rate | _DAILYYIELDMILLRATE_ | extract_accounting_daily_mill_rate |
Extract-only | |||
Unsettled Transactions | _UNSETTLEDTRANSACTIONS_ | extract_accounting_unsettled_trans |
Extract-only | |||
Cash Journal | _CASHJOURNAL_ | extract_accounting_cash_journal |
Extract-only | |||
Realized Gain Loss | _REALIZEDGAINLOSS_ | extract_accounting_realized_gl |
Extract-only | |||
Settled Cash Activity | _SETTLEDCA_ | extract_accounting_settled_ca |
Extract-only | |||
Consolidated Earned Income | _CONSEARNEDINCOME_ | extract_accounting_cons_earned_income |
Extract-only | |||
General Ledger Activity | _GENERALLEDGERACTIVITY_ | extract_accounting_gl_activity |
Extract-only | |||
Traded Cash Activity | _TRADEDCASHACTIVITY_ | extract_accounting_traded_cash_activity |
Extract-only | |||
Distribution Activity | _DISTRIBUTIONACT_ | extract_accounting_distribution_activity |
Extract-only | |||
Cash Projections | _CASHPROJECTIONS_ | extract_cash_projections |
Extract-only | |||
Custom Ledger Account | _CUSTLEDGERACCT_ | extract_accounting_custom_ledger_acct |
Extract-only | |||
Open Rec Pay Multi | _OPENRECPAYMULTI_ | extract_accounting_open_rec_pay_multi |
Extract-only | |||
Unapproved Variation Margin | _UNAPPROVEDVARMARGIN_ | extract_accounting_unapproved_var_margin |
Extract-only | |||
Trial Balance | _TRIALBALANCEEXTRACT_ | extract_accounting_trial_balance |
Extract-only | |||
Accounting Intraday NAV | _INTRADAYNAV_ | extract_accounting_intraday_nav |
Extract-only | |||
Accounting NAV for NASDAQ | _NAVFORNASDAQ_ | extract_accounting_nav_for_nasdaq |
Extract-only | |||
Accounting Fair Value Comparison | _FAIRVALUECOMPARISON_ | extract_accounting_fair_value_comparison |
Extract-only |