Page Comparison

In this page:

...

Date filter is a combination of several date filters within one include file. The following formatting should be used when you define a parameter:

yyyy-mm-dd or yyyy-mm-dd hh24-mi-ss, for example 2013-01-01 or 2013-01-01 15-00-00

Info

title	Note

These filters have sense only if the EagleML object you want to extract contains the corresponding database field.

...

Object Name	Feed Type	Update	Effective	Release	Accounting	Month End (Acct)	Post	Valuation	Ledger Effective	Trade	Settlement	Start	End	Sweep
Entity
Composite Entity List	ENTITYCOMPOSITELISTEXTRACT	+
Entity Accounting Basis	ENTITYACCBASISEXTRACT	+
Entity Accounting Periods	ENTITYACCPERIODSEXTRACT	+										+	+
Entity Analytics	ENTITYANALYTICEXTRACT	+	+
Entity Bank Relationship	ENTITYBANKRELEXTRACT	+
Entity List	ENTITYLISTEXTRACT	+
Entities In List	STATICENTITYLISTEXTRACT	+
Entities In List	DYNAMICENTITYLISTEXTRACT	+
Entity Liquidity	ENTITYLIQUIDITYEXTRACT	+	+
Entity Manager	ENTITYMANAGEREXTRACT	+
Entity Manager Relationship	ENTITYMANAGERRELEXTRACT	+
Entity Peer Group Ranking	ENTITYPEERGROUPRANKINGEXTRACT	+	+
Entity Regulatory	ENTITYREGULATORYEXTRACT		+
Entity Security Lending	ENTITYSECLENDINGEXTRACT		+
Entity Share Class	ENTITYSHARECLASSEXTRACT	+	+
Entity XREF	ENTITYXREFEXTRACT	+
Generic Entity	ENTITYEXTRACT	+	+
Object Name	Feed Type	Update	Effective	Release	Accounting	Month End (Acct)	Post	Valuation	Ledger Effective	Trade	Settlement	Start	End	Sweep
Rule
		Update	Effective
Primary Mixed Cost Basis Rule	RULEPRIMCOSTBASISEXTRACT	+
Contract Cash Rule	RULECONTRACTCASHEXTRACT	+
Contractual Cash Settlement Rule	RULECCSETTLEMENTEXTRACT	+
Earn Thru Rule	RULEEARNTHRUEXTRACT	+
Basis Processing Rule	RULEBASISPROCEXTRACT	+
Backup Withholding Rule	RULEBUWITHHOLDINGEXTRACT	+
Month End Date Rule	RULEMONTHENDDATEEXTRACT
Amortization Schedule Rule	RULEAMORTSCHDLEXTRACT	+
Accounting Rule	RULEACCOUNTINGEXTRACT	+
Object Name	Feed Type	Update	Effective	Release	Accounting	Month End (Acct)	Post	Valuation	Ledger Effective	Trade	Settlement	Start	End	Sweep
SMF
Generic SMF	SMFEXTRACT	+ (see more details)	+ (see more details)	+
Object Name	Feed Type	Update	Effective	Release	Accounting	Month End (Acct)	Post	Valuation	Ledger Effective	Trade	Settlement	Start	End	Sweep
Reference
Classification Matrix	CLASSIFICATIONMATRIXEXTRACT	+	+									+	+
Code Translation	CODETRANEXTRACT	+
Code Value	CODEVALEXTRACT	+
Code Category	CODEEXTRACT	+
Cash Projections	CASHPROJECTIONSEXTRACT	+	+									+	+
Error Definition	EXCEPTIONDEFEXTRACT	+
Demand List	DEMANDLIST		+
Calendar Business Dates	CALBUSINESSDATESEXTRACT
Calendar	REFCALENDAREXTRACT	+
Calendar Holiday	REFCALENDARHOLIDAYEXTRACT	+
Run Time Stamps	RPTTIMESTAMPS
Rating	RATINGSEXTRACT	+	+
Entity Entitlement List	ENTITYENTITLEMENTLISTEXTRACT	+
Ledger Notes	LEDGERNOTESEXTRACT	+
Report Dictionary	DICTIONARYEXTRACT		+
NAIC Designation	NAICDESIGNATIONEXTRACT	+	+
Object Name	Feed Type	Update	Effective	Release	Accounting	Month End (Acct)	Post	Valuation	Ledger Effective	Trade	Settlement	Start	End	Sweep
Security related
SMF Identifiers	XREFEXTRACT	+
Exchange Price	ISSUEEXCHANGEPRICEEXTRACT	+	+
Issue Variable Rate	ISSUEVARRATEEXTRACT	+	+
Issue Fx Rate	ISSUEFXRATEEXTRACT	+	+
Issue Price	ISSUEPRICEEXTRACT	+	+
Issue Fx Pc Rate	ISSUEFXPCRATEEXTRACT	+	+
Generic Issue Analytic	GENISSUEANALYTICEXTRACT	+	+
Schedule	SCHEDULEEXTRACT	+	+
GIPS Composite	REFGIPSCOMPOSITEEXTRACT	+
GIPS Disclosure	REFGIPSDISCLOSUREEXTRACT	+
Time Series	REFTIMESERIESEXTRACT	+
Trade Quote	REFTRADEQUOTESEXTRACT	+	+
Yield Curve	YIELDCURVEEXTRACT	+	+
Forward Points	FORWARDPOINTSEXTRACT	+	+
Factor	FACTOREXTRACT	+	+
Security Default	SECURITYDEFAULTEXTRACT	+										+	+
Security Overrides	SECURITYOVERRIDESEXTRACT	+	+
Earnings Time Period	EARNINGSTIMEPERIODEXTRACT	+										+	+
Issuer
Issuer	GENISSUEREXTRACT	+
Issuer Rating	ISSUERRATINGEXTRACT	+	+
Issuer Organization	ISSUERORGEXTRACT	+
Issuer Relationship	ISSUERRELEXTRACT	+	+
Issuer Role	ISSUERROLEEXTRACT	+	+										+
Object Name	Feed Type	Update	Effective	Release	Accounting	Month End (Acct)	Post	Valuation	Ledger Effective	Trade	Settlement	Start	End	Sweep
Warehouse
Warehouse Pending Trade	WRHSPENDINGTRADESEXTRACT	+	+
Warehouse Custody Activity	WRHSCSTDACTIVITYEXTRACT	+	+
Warehouse Custody Balance	WRHSCSTDBALANCEEXTRACT	+	+
Warehouse Cash Activity	WRHSCASHACTIVITYEXTRACT	+	+		+	+	+			+	+
Warehouse Performance	WRHSPERFORMANCEEXTRACT	+	+
Warehouse Close Lot	WRHSCLOSELOTEXTRACT	+	+		+	+	+		+	+	+
Warehouse Position	WRHSPOSITIONEXTRACT	+	+
Warehouse Open Lot	WRHSOPENLOTEXTRACT	+	+		+					+	+
Warehouse Open Lot	WRHSOPENLOTBROKERROLLUPEXTRACT	+	+		+					+	+
Warehouse Trade	WRHSTRADEEXTRACT	+	+		+	+	+	+	+	+	+
Warehouse Trade Charges	WRHSTRADECHARGESEXTRACT	+	+		+	+	+		+	+	+
Warehouse NAV Multi	WRHSNAVMULTIEXTRACT	+						+
Warehouse NAV	WRHSNAVEXTRACT	+	+
Warehouse NAV Monthend	WRHSNAVMONTHENDEXTRACT	+						+
Warehouse General Ledger Balances	WRHSGLDETAILPOSTINGEXTRACT	+	+		+	+	+
Warehouse Broker Trade Quote	WRHSBROKTRDQUOTEEXTRACT	+
Warehouse Cash Flow Projection	WRHSCASHFLOWPROJEXTRACT	+	+
Insurance Valuation Lot	INSURANCEVALUATIONLOTEXTRACT	+	+			+
Warehouse Disclosure Status	WRHSDISCLOSURESTATUSEXTRACT	+	+
Warehouse Wash Sale Trade	WRHSWASHSALETRADEEXTRACT	+	+				+			+
Object Name	Feed Type	Update	Effective	Release	Accounting	Month End (Acct)	Post	Valuation	Ledger Effective	Trade	Settlement	Start	End	Sweep
Corporate Action
Generic Corporate Actions	GENCORPACTIONSEXTRACT	+	+											+
Voluntary CA Election	VOLCAELECTIONEXTRACT	+	+
Object Name	Feed Type	Update	Effective	Release	Accounting	Month End (Acct)	Post	Valuation	Ledger Effective	Trade	Settlement	Start	End	Sweep
Client
Client	CLIENTEXTRACT	+
Client Communication	CLIENTCOMMEXTRACT	+
Object Name	Feed Type	Update	Effective	Release	Accounting	Month End (Acct)	Post	Valuation	Ledger Effective	Trade	Settlement	Start	End	Sweep
Accounting
Accounting Trade	ACCOUNTINGTRADEEXTRACT	+	+
Financial Event	FINANCIALEVENTEXTRACT	+	+
Traded Cash Activity	TRADEDCAEXTRACT	+	+		+	+	+				+
Settled Cash Activity	SETTLEDCAEXTRACT	+	+		+	+	+			+	+
Accounting GL Activity	GLACTIVITYEXTRACT	+			+	+	+
Accrued Income	ACCRUEDINCOMEEXTRACT	+	+		+		+			+	+
Subscribe Redeem	SUBSCRIBEREEDEMEXTRACT	+	+		+	+	+				+
Daily Yield Mill Rate	DAILYYIELDMILLRATEEXTRACT	+	+					+
Cash Journal	CASHJOURNALEXTRACT	+			+	+	+			+	+
Unsettled Transactions	UNSETTLEDTRANSACTIONSEXTRACT	+	+		+	+	+			+	+
Realized Gain Loss	REALIZEDGAINLOSSEXTRACT	+				+	+			+	+
Consearned Income	CONSEARNEDINCOMEEXTRACT	+			+	+
Distribution Activity	DISTRIBUTIONACTEXTRACT	+	+					+
Custom Ledger Account	CUSTLEDGERACCTEXTRACT	+
Open Rec Pay Multi	OPENRECPAYMULTIEXTRACT	+									+
Unapproved Variation Margin	UNAPPROVEDVARMARGINEXTRACT	+
Trial Balance	TRIALBALANCEEXTRACT	+			+	+
Fair Value Comparison	FAIRVALUECOMPARISONEXTRACT		+
Accounting Intraday NAV	INTRADAYNAVEXTRACT	+	+					+
Accounting NAV for NASDAQ	NAVFORNASDAQEXTRACT	+	+					+
Accounting Rejection	REJECTIONEXTRACT	+	+
Object Name	Feed Type	Update	Effective	Release	Accounting	Month End (Acct)	Post	Valuation	Ledger Effective	Trade	Settlement	Start	End	Sweep
User Administration
User	USEREXTRACT
Group	USERGROUPEXTRACT
Entitlement	USERENTITLEMENTEXTRACT
Eagle Administration Settings	EAGLEADMINISTRATIONSETTINGSEXTRACT
Object Name	Feed Type	Update	Effective	Release	Accounting	Month End (Acct)	Post	Valuation	Ledger Effective	Trade	Settlement	Start	End	Sweep
Internal
Control Center Event Log	CONTROLCENTEREVENTLOGEXTRACT
Object Name	Feed Type	Update	Effective	Release	Accounting	Month End (Acct)	Post	Valuation	Ledger Effective	Trade	Settlement	Start	End	Sweep
S2P Reporting
Spd Delta Trigger Log	SPDDELTATRIGGERLOGEXTRACT	+			+	+	+			+	+
Object Name	Feed Type	Update	Effective	Release	Accounting	Month End (Acct)	Post	Valuation	Ledger Effective	Trade	Settlement	Start	End	Sweep
Other
Calculate Date	CALCULATEDATE	+

...

Versions Compared

Old Version 40

New Version Current

Key

Entity

Rule

SMF

Reference

Security related

Issuer

Warehouse

Corporate Action

Client

Accounting

User Administration

Internal

S2P Reporting

Other