Date Filter

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

Note

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
End Date	enddate fromenddate toenddate	END_DT
Sweep Date	sweepdate fromsweepdate tosweepdate	SWEEP_DATE

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
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	+	+
Rule
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	+
SMF
Generic SMF	SMFEXTRACT	+ (see more details)	+ (see more details)	+
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	+	+
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 Overrides	SECURITYOVERRIDESEXTRACT	+	+
Issuer
Issuer	GENISSUEREXTRACT	+
Issuer Rating	ISSUERRATINGEXTRACT	+	+
Issuer Organization	ISSUERORGEXTRACT	+
Issuer Relationship	ISSUERRELEXTRACT	+	+
Issuer Role	ISSUERROLEEXTRACT	+	+										+
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	+	+				+			+
Corporate Action
Generic Corporate Actions	GENCORPACTIONSEXTRACT	+	+											+
Voluntary CA Election	VOLCAELECTIONEXTRACT	+	+
Client
Client	CLIENTEXTRACT	+
Client Communication	CLIENTCOMMEXTRACT	+
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	+	+
User Administration
User	USEREXTRACT
Group	USERGROUPEXTRACT
Entitlement	USERENTITLEMENTEXTRACT
Eagle Administration Settings	EAGLEADMINISTRATIONSETTINGSEXTRACT
Internal
Control Center Event Log	CONTROLCENTEREVENTLOGEXTRACT
S2P Reporting
Spd Delta Trigger Log	SPDDELTATRIGGERLOGEXTRACT	+			+	+	+			+	+
Other
Calculate Date	CALCULATEDATE	+

Note

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.

Note

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