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

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)	+ (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	+	+		+					+	+
Warehouse Open Lot	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>

Date Filter

Date Filters Reference Table

Entity

Rule

SMF

Reference

Security related

Issuer

Warehouse

Corporate Action

Client

Accounting

Other

Example: Date Filter