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 Name | Available Parameters | DB Field |
Update Date | updatedate todate fromdate | UPDATE_DATE |
Effective Date | effectivedate fromeffectivedate toeffectivedate | EFFECTIVE_DATE |
Release Date | releasedate fromreleasedate toreleasedate | RELEASE_DATE |
Accounting Date | accountingdate fromaccountingdate toaccountingdate | ACCOUNTING_DATE |
Month End (Accounting) Date | monthendaccountingdate frommonthendaccountingdate tomonthendaccountingdate | MONTH_END_ACCOUNTING_DATE MONTH_END_DATE GLDP_ACCOUNTING_DATE |
Post Date | postdate frompostdate topostdate | POST_DATE |
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 |
Start Date | startdate fromstartdate tostartdate | START_DT |
End Date | enddate fromenddate toenddate | END_DT |
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Entity | |||||||||||||
Composite Entity List | ENTITYCOMPOSITELISTEXTRACT | + | |||||||||||
Entity Manager Relationship | ENTITYMANAGERRELEXTRACT | + | |||||||||||
Entity Share Class | ENTITYSHARECLASSEXTRACT | + | + | ||||||||||
Entity Accounting Basis | ENTITYACCBASISEXTRACT | + | |||||||||||
Entity Bank Relationship | ENTITYBANKRELEXTRACT | + | |||||||||||
Entity Manager | ENTITYMANAGEREXTRACT | + | |||||||||||
Entity XREF | ENTITYXREFEXTRACT | + | |||||||||||
Entity List | ENTITYLISTEXTRACT | + | |||||||||||
Entities In List | ENTITYLISTLISTEXTRACT | + | |||||||||||
Generic Entity | ENTITYEXTRACT | + | + | ||||||||||
Entity Accounting Periods | ENTITYACCPERIODSEXTRACT | + | + | + | |||||||||
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) | + | |||||||||
Reference | |||||||||||||
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 | + | + | + | + | + | |||||||
WRHSOPENLOTBROKERROLLUPEXTRACT | |||||||||||||
Warehouse Trade | WRHSTRADEEXTRACT | + | + | + | + | + | + | + | + | + | |||
Warehouse NAV Multi | WRHSNAVMULTIEXTRACT | + | + | ||||||||||
Warehouse NAV | WRHSNAVEXTRACT | + | + | ||||||||||
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 | + | + | + | |||||||||
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>