Page Comparison

Section

border	true

Column

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 described below.
Eagle also maintains a list of available EagleML filters.

Column

width	25%

In this page:

Table of Contents

maxLevel	3
printable	false

xreftype

...

Object Name	Feed Type	Common	Date	Entity	Held	SMF	History Only	Sources	Delta Based	Issuer	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	+	+	+					+			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 Holiday	REFCALENDARHOLIDAYEXTRACT	+	+								calendarname, fromcalendardate, calendardate, tocalendardate
Classification Matrix	CLASSIFICATIONMATRIXEXTRACT	+	+								ExcludeClassMatrixId, pendingOnly, 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
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 Notes	SECURITYNOTESEXTRACT	+	+			+
Security Overrides	SECURITYOVERRIDESEXTRACT	+	+			+		+	+			IncludeAssetProperties
Issuer
Issuer	GENISSUEREXTRACT	+	+		+	+	+		+	+	maxeffectivedate (only in history mode)
Issuer ESG	ISSUERESGEXTRACT	+	+				+		+	+	maxeffectivedate (only in history mode)
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	IncludeAssetProperties, IncludeExtendedDetails, IncludeEntityInfo, RemoveEntityDuplicates, EnableSignageLogic, excludezero, EnhanceCalcTransactionId
Warehouse Trade Charges	WRHSTRADECHARGESEXTRACT	+	+	+		+		+			BatchMode
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
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, 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, 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
S2P Reporting
Spd Delta Trigger Log	SPDDELTATRIGGERLOGEXTRACT	+	+	+		+		+	+		eventId, messageSubType, updateSource, localCurrency, accountingBasis
Other
Calculate Date	CALCULATEDATE

...

Versions Compared

Old Version 96

New Version 97

Key

Entity

Rule

SMF

Reference

Security related

Issuer

Warehouse

Corporate Action

Client

Accounting

User Administration

Internal

S2P Reporting

Other