Extract and Load Solution Implementation

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