Date Filter

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

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

Filter Fields and Parameters

Filter Name	Available Parameters	DB Field	Alternative DB Field
Update Date	updatedate todate fromdate	UPDATE_DATE
Effective Date	effectivedate fromeffectivedate toeffectivedate	EFFECTIVE_DATE	EFFECTIVE_DT
Release Date	releasedate fromreleasedate toreleasedate	RELEASE_DATE
Accounting Date	accountingdate fromaccountingdate toaccountingdate	ACCOUNTING_DATE	ACCOUNT_DT ACCTG_DATE
Month End (Accounting) Date	monthendaccountingdate frommonthendaccountingdate tomonthendaccountingdate	MONTH_END_ACCOUNTING_DATE MONTH_END_DATE GLDP_ACCOUNTING_DATE	MONTH_END_ACCT_DT
Post Date	postdate frompostdate topostdate	POST_DATE	PROCESS_DT
Valuation Date	valuationdate fromvaluationdate tovaluationdate	VALUATION_DATE
Ledger Effective Date	ledgereffdate fromledgereffdate toledgereffdate	LEDGER_EFFECTIVE_DATE
Trade Date	tradedate fromtradedate totradedate	TRADE_DATE
Settlement Date	settlementdate fromsettlementdate tosettlementdate	SETTLEMENT_DATE	SETTLE_DATE
Start Date	startdate fromstartdate tostartdate	START_DT	START_DATE
End Date	enddate fromenddate toenddate	END_DT	END_DATE
Sweep Date	sweepdate fromsweepdate tosweepdate	SWEEP_DATE

On this page

1 Filter Fields and Parameters
2 Date Filters Reference Table
- 2.1 Entity
- 2.2 Rule
- 2.3 SMF
- 2.4 Reference
- 2.5 Security related
- 2.6 Issuer
- 2.7 Warehouse
- 2.8 Corporate Action
- 2.9 Client
- 2.10 Accounting
- 2.11 User Administration
- 2.12 Internal
- 2.13 S2P Reporting
- 2.14 Other
3 Example: Date Filter

Date Filters Reference Table

The following table contains a more detailed listing of date filters available for each feed type.

Object Name	Feed Type	Update	Effective	Release	Accounting	Month End (Acct)	Post	Valuation	Ledger Effective	Trade	Settlement	Start	End	Sweep

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	+

There is no EFFECTIVE_DATE field in the SECURITY_MASTER table. To extract the SMF with Effective Date filter you have to extract the SMF in history mode (task parameter historyOnlyFlag=Y) from SECMASTER_HISTORY table.

The Update Date filter applied to the composite table performs the search in UPDATE_DATE and RELEASE_DATE fields of the SECURITY_MASTER table and in UPDATE_DATE fields of XREFERENCE and XREFERENCE_HIST tables. The same filter applied in history mode performs the search only in UPDATE_DATE fields of SECMASTER_HISTORY table.

Example: Date Filter

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

Date Filter

Filter Fields and Parameters

Date Filters Reference Table

Entity

Rule

SMF

Reference

Security related

Issuer

Warehouse

Corporate Action

Client

Accounting

User Administration

Internal

S2P Reporting

Other

Example: Date Filter