Page Comparison

...

border	true

...

width	75%

The Control Message file contains filter parameters. All these parameters are located in Task parameters section. Apart from the parameters you can set in the Control Message for a particular extract, there is an option to define global parameters influencing all processes in an environment, including extracts.

Filter parameters define a range of data which is going to be extracted from the Database tables for each object. The list of objects and corresponding filter parameters are

...

width	25%

In this page:

Table of Contents

maxLevel	3
printable	false

...

described below.

Eagle also maintains a list of available EagleML filters.

For example, the value of parameter “updatedate” :follows.

Code Block

language	xml

<taskParameter>
      <name>updatedate</name>
      <dataType>S</dataType>
      <value>2013-06-25 15-00-00</value>
</taskParameter>

Note

Info
title

All parameter names are case-sensitive.

Cross-Reference of Objects and Filters

All filters can be divided into groups: Common, Date, Entity, Held, Smf, Sources, Delta Based, Issuer and Own filters. “Own” filters are implemented within the rules of an object and are usually specific for the object. All other filters are implemented in the include files located in the folder /eagle_ml-2-0_cm and are shared between several EagleML objects:, as follows.

Filter	Include Filename
Common	extract_filter_common.inc
Date	extract_filter_date extract_date_sql.inc
Entity	extract_filter_entity.inc
Held	extract_filter_held.inc
Smf	extract_filter_smf.inc
Sources	extract_filter_sources.inc
Delta Based	extract_delta_based.inc
Issuer	extract_filter_iif.inc

See the following table to learn which filters are supported for the EagleML object the EagleML object you are going to extract:.

Object Name	Feed Type	Common	Date	Entity	Held	SMF	History Only	Sources	Delta Based	Own	CM Parameters
Entity
Composite Entity List	ENTITYCOMPOSITELISTEXTRACT	+	+	+			+				IncludeEntityInfo, RemoveEntityDuplicates
Entity Manager Relationship	ENTITYMANAGERRELEXTRACT	+	+	+						entitytype, maxeffectivedate (only in history mode)	RemoveEntityDuplicates
Entity Share Class	ENTITYSHARECLASSEXTRACT	+	+	+		+	+	+			IncludeAssetProperties, IncludeEntityInfo, RemoveEntityDuplicates
Entity Accounting Basis	ENTITYACCBASISEXTRACT	+	+	+							IncludeEntityInfo, RemoveEntityDuplicates, UseAllAcctBasis
Entity Analytic	ENTITYANALYTICEXTRACT	+	+	+				+			IncludeEntityInfo, RemoveEntityDuplicates
Entity Bank Relationship	ENTITYBANKRELEXTRACT	+	+	+							IncludeEntityInfo, RemoveEntityDuplicates
Entity Liquidity	ENTITYLIQUIDITYEXTRACT	+	+	+			+				IncludeEntityInfo, RemoveEntityDuplicates
Entity Manager	ENTITYMANAGEREXTRACT	+	+	+							RemoveEntityDuplicates
Entity XREF	ENTITYXREFEXTRACT	+	+	+						entitytype	RemoveEntityDuplicates
Entity List	ENTITYLISTEXTRACT	+	+	+							IncludeEntityInfo, RemoveEntityDuplicates
Entities In List	STATICENTITYLISTEXTRACT	+	+	+							IncludeEntityInfo, RemoveEntityDuplicates
Entities In List	DYNAMICENTITYLISTEXTRACT	+	+	+ (EntityList filter is required)							IncludeEntityInfo, RemoveEntityDuplicates
Generic Entity	ENTITYEXTRACT	+	+	+			+	+		entitytype, activeStatus	IncludeEntityInfo, RemoveEntityDuplicates
Entity Accounting Periods	ENTITYACCPERIODSEXTRACT	+	+	+					+	accountingBasis	IncludeEntityInfo, RemoveEntityDuplicates
Entity Peer Group Ranking	ENTITYPEERGROUPRANKINGEXTRACT	+	+	+				+			IncludeEntityInfo, RemoveEntityDuplicates
Entity Regulatory	ENTITYREGULATORYEXTRACT	+	+	+			+				IncludeEntityInfo, RemoveEntityDuplicates
Entity Security Lending	ENTITYSECLENDINGEXTRACT	+	+	+				+	+		IncludeEntityInfo, RemoveEntityDuplicates
Entity Statistic	ENTITYSTATISTICEXTRACT	+	+	+				+			IncludeEntityInfo, RemoveEntityDuplicates
Rule
Primary Mixed Cost Basis Rule	RULEPRIMCOSTBASISEXTRACT	+	+	+							RemoveEntityDuplicates
Contract Cash Rule	RULECONTRACTCASHEXTRACT	+	+	+							RemoveEntityDuplicates
Contractual Cash Settlement Rule	RULECCSETTLEMENTEXTRACT	+	+	+							RemoveEntityDuplicates
Earn Thru Rule	RULEEARNTHRUEXTRACT	+	+	+							RemoveEntityDuplicates
Basis Processing Rule	RULEBASISPROCEXTRACT	+	+	+							RemoveEntityDuplicates
Backup Withholding Rule	RULEBUWITHHOLDINGEXTRACT	+	+	+							RemoveEntityDuplicates
Month End Date Rule	RULEMONTHENDDATEEXTRACT	+	+	+							RemoveEntityDuplicates
Amortization Schedule Rule	RULEAMORTSCHDLEXTRACT	+	+	+							RemoveEntityDuplicates
Accounting Rule	RULEACCOUNTINGEXTRACT	+	+	+							RemoveEntityDuplicates
SMF
Generic SMF	SMFEXTRACT	+	+		+	+	+	+	+	securitysubtype, maxeffectivedate (only in history mode)	IncludeAssetProperties
Reference
Calendar	REFCALENDAREXTRACT	+	+
Calendar Business Dates	CALBUSINESSDATESEXTRACT									OnlyBusinessCalendar, CalendarType, CalendarBusinessName, DateTypeMacro, ProcessCenterName

Calendar HolidayREFCALENDARHOLIDAYEXTRACT

Calendar Holiday

REFCALENDARHOLIDAYEXTRACT

+

calendarname, fromcalendardate, calendardate, tocalendardate

Classification Matrix

CLASSIFICATIONMATRIXEXTRACT

+

calendarname

ExcludeClassMatrixId,

fromcalendardate

pendingOnly,

calendardate, tocalendardate

ClassificationMatrixName

Code Translation

CODETRANEXTRACT

+

fromsourcecode,fromcodecategory, fromcodecategoryname, fromcodevalue, fromcodevaluename, tosourcecode, tocodecategory, tocodecategoryname, tocodevalue, tocodevaluename

Code Value

CODEVALEXTRACT

+

sourcename, codecategory, codecategoryname, codevalue, codevaluename

Code Category

CODEEXTRACT

+

codecategoryname, codecategory

Сompliance 2A-7 Pricing Report

COMPLIANCE2A7PRICINGEXTRACT

+

accountingBasis, selectView, reportType, reportPeriod, 2A7PricingSource, reportFilters, advancedReportOptions, selectSector, sectorId, sector, filterSecurityBy, issuename, summaryMain, holdingsByTierLevel, holdingsByInvestmentType, holdingsByIssuer, securityRatings. Read more..

Demand List

DEMANDLIST

Entity Entitlement List

ENTITYENTITLEMENTLISTEXTRACT

+

usergroups (required)

RemoveEntityDuplicates

Error Definition

EXCEPTIONDEFEXTRACT

+

v.13+

ErrorCode

Ledger Notes

LEDGERNOTESEXTRACT

+

Line of Credit

LINEOFCREDITEXTRACT

+

facilityid

RemoveEntityDuplicates

NAIC Designation

NAICDESIGNATIONEXTRACT

+

naicresolutiontype, naicassetid, naicclientid

PACE Calendar

PACECALENDAREXTRACT

+

PACE System

PACESYSEXTRACT

+

sysitem

Pricing System Setting

PRICINGSYSSETTINGEXTRACT

+

code

Process Center

PROCESSCENTEREXTRACT

+

ProcessCenterName, CalendarBusinessName

Rating

RATINGSEXTRACT

+

maxeffectivedate

IncludeAssetProperties

Report Dictionary

DICTIONARYEXTRACT

+

excludesecuritylinksflag, dictionaryname

IncludeAssetProperties, linkedassetonlydelta

Run Time Stamps

RPTTIMESTAMPS

Source

SOURCEEXTRACT

+

sourceinstance, sourcename

Security related

SMF Identifiers

XREFEXTRACT

+

xrefidtype, securitysubtype, securityalias

SMF Identifier Config

XREFCONFIGEXTRACT

+

Exchange Price

ISSUEEXCHANGEPRICEEXTRACT

+

IncludeAssetProperties, RemoveEntityDuplicates

Issue Variable Rate

ISSUEVARRATEEXTRACT

+

IncludeAssetProperties

Issue Fx Rate

ISSUEFXRATEEXTRACT

+

Issue Fx Rate Demand

ISSUEFXRATEDEMANDEXTRACT

+

Issue Price

ISSUEPRICEEXTRACT

+

IncludeAssetProperties, RemoveEntityDuplicates

Issue Fx Pc Rate

ISSUEFXPCRATEEXTRACT

+

Generic Issue Analytic

GENISSUEANALYTICEXTRACT

+

IncludeAssetProperties

Schedule

SCHEDULEEXTRACT

+

securitysubtype

IncludeAssetProperties

GIPS Composite

REFGIPSCOMPOSITEEXTRACT

+

RemoveEntityDuplicates

GIPS Disclosure

REFGIPSDISCLOSUREEXTRACT

+

DisclosureName, DisclosureType

Time Series

REFTIMESERIESEXTRACT

+

Trade Quote

REFTRADEQUOTESEXTRACT

+

RemoveEntityDuplicates

Yield Curve

YIELDCURVEEXTRACT

+

Forward Points

FORWARDPOINTSEXTRACT

+

IncludeAssetProperties

Factor

FACTOREXTRACT

+

IncludeAssetProperties

Security Default

SECURITYDEFAULTEXTRACT

+

Security Notes

SECURITYNOTESEXTRACT

+

Security Overrides

SECURITYOVERRIDESEXTRACT

+

IncludeAssetProperties

Earnings Time Period

EARNINGSTIMEPERIODEXTRACT

+

Issuer

GENISSUEREXTRACT

+

maxeffectivedate (only in history mode)

Issuer ESG

ISSUERESGEXTRACT

+

maxeffectivedate (only in history mode)

Issuer Entity Relationship

ISSUERENTRELEXTRACT

+

Issuer Rating

ISSUERRATINGEXTRACT

+

maxeffectivedate

Issuer Organization

ISSUERORGEXTRACT

+

maxeffectivedate (only in history mode)

Issuer Regulatory

ISSUERREGULATORYEXTRACT

+

Issuer Relationship

ISSUERRELEXTRACT

+

Issuer Role

ISSUERROLEEXTRACT

+

minenddate

Warehouse

Warehouse Pending Trade

WRHSPENDINGTRADESEXTRACT

+

IncludeAssetProperties, IncludeEntityInfo, RemoveEntityDuplicates, excludezero

Warehouse Custody Activity

WRHSCSTDACTIVITYEXTRACT

+

IncludeAssetProperties, IncludeEntityInfo, RemoveEntityDuplicates, excludezero

Warehouse Custody Balance

WRHSCSTDBALANCEEXTRACT

+

IncludeAssetProperties, IncludeEntityInfo, RemoveEntityDuplicates, excludezero

Warehouse Cash Activity

WRHSCASHACTIVITYEXTRACT

+

BatchMode

IncludeAssetProperties, IncludeEntityInfo, RemoveEntityDuplicates,excludezero

Warehouse Performance

WRHSPERFORMANCEEXTRACT

+

BatchMode

IncludeAssetProperties, IncludeEntityInfo, RemoveEntityDuplicates, IncludeCurveAnalytics, excludezero

Warehouse Close Lot

WRHSCLOSELOTEXTRACT

+

BatchMode

IncludeAssetProperties, IncludeExtendedDetails, IncludeEntityInfo, RemoveEntityDuplicates, excludezero

Warehouse Position

WRHSPOSITIONEXTRACT

+

BatchMode, extractLevel

IncludeAssetProperties, IncludeExtendedDetails, IncludeEntityInfo, RemoveEntityDuplicates, TakeBaseCurrencyFromWRHSPosDet, includeZeroPositions, IncludeCurveAnalytics, IncludePortfolioValuation, excludezero

Warehouse Open Lot

WRHSOPENLOTEXTRACT

+

BatchMode, extractLevel

IncludeAssetProperties, IncludeExtendedDetails, IncludeEntityInfo, RemoveEntityDuplicates, includeZeroPositions, IncludePortfolioValuation, IncludeWashSales, excludezero

Warehouse Open Lot

WRHSOPENLOTBROKERROLLUPEXTRACT

+

BatchMode, extractLevel

IncludeAssetProperties, IncludeExtendedDetails, IncludeEntityInfo, RemoveEntityDuplicates, includeZeroPositions, IncludePortfolioValuation, IncludeWashSales, GroupBy, excludezero

Warehouse Trade

WRHSTRADEEXTRACT

+

BatchMode, transactioncode

IncludeAssetProperties, IncludeExtendedDetails, IncludeEntityInfo, RemoveEntityDuplicates, EnableSignageLogic, excludezero, EnhanceCalcTransactionId

Warehouse Trade Charges

WRHSTRADECHARGESEXTRACT

+

BatchMode

Warehouse Trade Xref Identifier

WRHSTRADEXREFEXTRACT

+

Warehouse NAV Multi

WRHSNAVMULTIEXTRACT

+

BatchMode

IncludeAssetProperties, IncludeExtendedDetails, includeEntityShareClass, includeReportDetails, includeCustomReportDetails, IncludeAverageNetAssets, IncludeEntityInfo, RemoveEntityDuplicates, excludezero

Warehouse NAV

WRHSNAVEXTRACT

+

BatchMode

IncludeEntityInfo, RemoveEntityDuplicates, excludezero

Warehouse NAV Month End

WRHSNAVMONTHENDEXTRACT

+

IncludeAssetProperties, IncludeExtendedDetails, includeEntityShareClass, UseFundsOfFunds, IncludeEntityInfo, excludezero

Warehouse General Ledger Balances

WRHSGLDETAILPOSTINGEXTRACT

+

BatchMode, GLBasic, IncludeMEMOAccounts, IncludeOnlyAcctBaseCurrency

IncludeAssetProperties, IncludeExtendedDetails, IncludeEntityInfo, RemoveEntityDuplicates, excludezero

Warehouse Broker Trade Quote

WRHSBROKTRDQUOTEEXTRACT

+

masterTicketNumber

RemoveEntityDuplicates, excludezero

Warehouse Cash Flow Projection

WRHSCASHFLOWPROJEXTRACT

+

IncludeEntityInfo, RemoveEntityDuplicates, excludezero

Insurance Valuation Lot

WRHSCASHFLOWPROJEXTRACT

+

clientID, Lot_id

IncludeAssetProperties, IncludeEntityInfo, RemoveEntityDuplicates, excludezero

Warehouse Disclosure Status

WRHSDISCLOSURESTATUSEXTRACT

+

IncludeAssetProperties, IncludeEntityInfo, RemoveEntityDuplicates, excludezero

Warehouse Wash Sale Trade

WRHSWASHSALETRADEEXTRACT

+

BatchMode, origaccountingdate, fromorigaccountingdate, toorigaccountingdate

IncludeAssetProperties, IncludeEntityInfo, RemoveEntityDuplicates, excludezero

Corporate Action

Generic Corporate Actions

GENCORPACTIONSEXTRACT

+

maxsweepdate, maxsweepdaterule, UseTransTypeGrouping, transType, cpReason, cpStatus, clientSpecificCAId

IncludeAssetProperties

Voluntary CA Election

VOLCAELECTIONEXTRACT

+

Client

CLIENTEXTRACT

+

ClientID, Instance

RemoveEntityDuplicates

Client Communication

CLIENTCOMMEXTRACT

+

ClientID, CommunicationType, Instance

Accounting

Accounting Trade

ACCOUNTINGTRADEEXTRACT

+

IncludeEntityInfo, RemoveEntityDuplicates

Financial Event

FINANCIALEVENTEXTRACT
(a specific extract for Accounting Trade, tagvalue-only, no EagleML interpretation)

+

Traded Cash Activity

TRADEDCAEXTRACT

+

accountingBasis, UsePrimaryBasisOnly

IncludeAssetProperties, IncludeExtendedDetails, EnableSignageLogic, IncludeEntityInfo, RemoveEntityDuplicates, EnhanceCalcTransactionId

Settled Cash Activity

SETTLEDCAEXTRACT

+

accountingBasis, UsePrimaryBasisOnly

IncludeExtendedDetails, EnableSignageLogic, IncludeEntityInfo, RemoveEntityDuplicates, EnhanceCalcTransactionId

Accounting GL Activity

GLACTIVITYEXTRACT

+

FromGLAccount, GLBasic, GLClass, GLDateType, GLFromDate, GLToDate, GLSector, ToGLAccount, IncludeALLOCATEEvents,

IncludeMEMOAccounts, NetRollbackReplayEntries

IncludeAssetProperties, IncludeEntityInfo

Accrued Income

ACCRUEDINCOMEEXTRACT

+

IncludeAssetProperties, IncludeEntityInfo

Subscribe Redeem

SUBSCRIBEREEDEMEXTRACT

+

IncludeAssetProperties, IncludeExtendedDetails, includeEntityShareClass, IncludeSubscribeReedemCalcFields,

IncludeEntityInfo, RemoveEntityDuplicates

Daily Yield Mill Rate

DAILYYIELDMILLRATEEXTRACT

+

IncludeEntityInfo, RemoveEntityDuplicates

Cash Journal

CASHJOURNALEXTRACT

+

reportView, selectView, reportType, reportPeriod, includeCancels, displayZero, nraTaxCountry, localCurrency, longShortIndicator, eventType, baseCurrency, processCodeTranslation, codeMapName
All filters are case-insensitive

Cash Projections

CASHPROJECTIONSEXTRACT

+

CashProjectionReportType, CashProjectionReportName, CashProjectionPositionSwitch, CashProjectionInstanceType, CashProjectionInstance, accountingBasis

IncludeAssetProperties, IncludeEntityInfo, RemoveEntityDuplicates, IncludeExtendedDetails

Unsettled Transactions

UNSETTLEDTRANSACTIONSEXTRACT

+

reportType, reportDate, baseCurrency, accountingBasis, longShortIndicator, cashCategory, eventReason, cashEventType, shareClass, localCurrency, includeCorpAction, includeFwdTransactions

accountingValidationFlag (required in case you set a range of dates)

Realized Gain Loss

REALIZEDGAINLOSSEXTRACT

+

reportType, reportPeriod, reportTypeSource, includeCancels, displayZero, accountingBasis, reportFilters, filterSecurityBy, assetCurrency or localCurrency, longShortIndicator, eventType, issuename, nraTaxCountry, lotPosSwitch (SP mode only), displayUDF (panel mode for v2017 or higher, SP mode only for other)
All filters are case-insensitive

accountingValidationFlag, IncludeEntityInfo, RemoveEntityDuplicates

Consolidated Earned Income

CONSEARNEDINCOMEEXTRACT

+

reportPeriod, reportType, reportStartDate,

reportEndDate

reportEndDate, accountingBasis, baseCurrency or localCurrency, taxableIndicator, nraTaxCountry, longShortIndicator, governmentIndicator, issuename,

rollupIndicator (SP mode only), processCenter (SP mode only), conversionStatus (SP mode only), urglRecpayIndicator (SP mode only)
All filters are case-insensitive

accountingValidationFlag, selectView, selectSector, sectorID, detailSelection

Distribution Activity

DISTRIBUTIONACTEXTRACT

+

IncludeAssetProperties, IncludeExtendedDetails, IncludeEntityInfo, RemoveEntityDuplicates

Custom Ledger Account

CUSTLEDGERACCTEXTRACT

+

GLSelectionType, GLChartOfAccountName, GLAccount, GLCustomAccount, GLCustomAccountDescription, GLPostType

Open Rec Pay Multi

OPENRECPAYMULTIEXTRACT

+

settleCurrency, brokerName, brokerCode, targerEventId, eventType, tradeTicketNumber, category,

entityName

entityName, issuename
All filters are case-insensitive

IncludeEntityInfo, RemoveEntityDuplicates

Unapproved Variation Margin

UNAPPROVEDVARMARGINEXTRACT

+

accountingBasis, baseCurrency, longShortIndicator, reportType

IncludeAssetProperties, IncludeEntityInfo, RemoveEntityDuplicates

Trial Balance

TRIALBALANCEEXTRACT

+

selectView, ledgerProfile, reportType, generalLedgerCurrency, accountingBasis, showMEMOAccounts, showAssetLevelDetails, reportFilters, selectSector, sectorID, sector, selectShareClass, shareClass, detailedClassView, reportDate, filterSecurityBy, issuename
All filters are case-insensitive

IncludeEntityInfo, RemoveEntityDuplicates

Fair Value Comparison

FAIRVALUECOMPARISONEXTRACT

+

accountingBasis, reportType, nextDayOpenSourceName, nextBusinessDay, nextDayOpenPriceType, nextOpenPricingExchange, reportFilters, showMEMOAccounts, showAssetLevelDetails, filterSecurityBy, issuename, longShort, assetCurrency, issueCountry

IncludeEntityInfo, RemoveEntityDuplicates

Accounting Intraday NAV

INTRADAYNAVEXTRACT

+

IncludeEntityInfo, RemoveEntityDuplicates, includeEntityShareClass

Accounting NAV for NASDAQ

NAVFORNASDAQEXTRACT

+

IncludeEntityInfo, RemoveEntityDuplicates

Working Trial Balance

WORKINGTRIALBALANCEEXTRACT

+

accountingBasis, generalLedgerCurrency, selectView, selectSector, sectorID, Sector, selectShareClass, shareClass, detailedClassView, reportType, ledgerProfile, reportFilters, showMEMOAccounts, showAssetLevelDetails, filterSecurityBy, xrefid, xrefidtype, primaryassetid, issuename, includeExcludeCloseoutEntries

IncludeEntityInfo, RemoveEntityDuplicates

Monthly Portfolio Valuation

MONTHLYPORTFOLIOVALUATIONEXTRACT

+

RemoveEntityDuplicates

Portfolio Valuation

PORTFOLIOVALUATIONEXTRACT

+

RemoveEntityDuplicates

Accounting Rejection

REJECTIONEXTRACT

+

eventType, eventId, updateSource

IncludeExtendedDetails, IncludeAssetProperties

Accounting Position As Of

POSITIONASOFEXTRACT

Preferred Share

PREFERREDSHAREEXTRACT

Master Feeder Relationship

MASTERFEEDERRELATIONEXTRACT

Bank Cash Settlement

BANKCASHSETTLEMENTEXTRACT

Weighted Average

WEIGHTEDAVERAGEEXTRACT

Expense Activity

EXPENSEACTIVITYEXTRACT

Pricing Report

PRICINGREPORTEXTRACT

+

usergroups

User Administration

User

USEREXTRACT

+

userid, businessgroupname, usergroupname, applicationgroupname, centerrolename, accountstate, SetProcessingOptionsValue

IncludeInstanceIds

Group

USERGROUPEXTRACT

+

userid, businessgroupname, usergroupname, applicationgroupname, centerrolename, accountstate, SetProcessingOptionsValue

IncludeInstanceIds

Entitlement

USERENTITLEMENTEXTRACT

+

PropertyName

Eagle Administration Settings

EAGLEADMINISTRATIONSETTINGSEXTRACT

Internal

Control Center Event Log

CONTROLCENTEREVENTLOGEXTRACT

+

eventgroupname, eventtaskid, activeflag, completedflag, coregroup, statisticcategory, statisticname, statistictype, businessprocessinggroup

S2P Reporting

Spd Delta Trigger Log

SPDDELTATRIGGERLOGEXTRACT

+

eventId, messageSubType, updateSource, localCurrency, accountingBasis, minAccountingDateFlag

Other

Calculate Date

CALCULATEDATE

Versions Compared

Old Version 95

New Version Current

Key

Cross-Reference of Objects and Filters

Entity

Rule

SMF

Reference

Security related

Issuer

Warehouse

Corporate Action

Client

Accounting

User Administration

Internal

S2P Reporting

Other