In this page:
Table of Contents |
---|
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 | ||
---|---|---|
| ||
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 Name | Alternative DB Field Names |
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 |
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 |
...
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 Manager RelationshipAccounting Basis | ENTITYMANAGERRELEXTRACTENTITYACCBASISEXTRACT | + | ||||||||||||||
Entity | Share ClassENTITYSHARECLASSEXTRACTAccounting Periods | ENTITYACCPERIODSEXTRACT | + | + | + | |||||||||||
Entity | Accounting BasisENTITYACCBASISEXTRACTAnalytics | 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 | XREFENTITYXREFEXTRACTPeer Group Ranking | ENTITYPEERGROUPRANKINGEXTRACT | + | + | ||||||||||||
Entity | ListRegulatory | ENTITYLISTEXTRACTENTITYREGULATORYEXTRACT | + | Entities In List | ||||||||||||
Entity Security Lending | ENTITYSECLENDINGEXTRACT | + | Generic||||||||||||||
Entity Share Class | ENTITYEXTRACTENTITYSHARECLASSEXTRACT | + | + | |||||||||||||
Entity Accounting PeriodsXREF | ENTITYACCPERIODSEXTRACT 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) | + | ||||||||||||
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 | + |
Info | ||
---|---|---|
| ||
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. |
Anchor | ||||
---|---|---|---|---|
|
Info | ||
---|---|---|
| ||
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
Code Block | ||
---|---|---|
| ||
<taskParameter> <name>updatedate</name> <dataType>S</dataType> <value>2013-06-25 15-00-00</value> </taskParameter> |
...