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 | UPDATE_DATEÂ | Â |
Effective Date | effectivedate | EFFECTIVE_DATEÂ | EFFECTIVE_DT |
Release Date | releasedate | RELEASE_DATE | Â |
Accounting Date | accountingdate | ACCOUNTING_DATE | ACCOUNT_DT |
Month End (Accounting) Date | monthendaccountingdate | MONTH_END_ACCOUNTING_DATE | MONTH_END_ACCT_DT |
Post Date | postdate | POST_DATE | PROCESS_DT |
Valuation Date | valuationdate | VALUATION_DATE | Â |
Ledger Effective Date | ledgereffdate | LEDGER_EFFECTIVE_DATE | Â |
Trade Date | tradedate | TRADE_DATE | Â |
Settlement Date | settlementdate | SETTLEMENT_DATE | SETTLE_DATE |
Start Date | startdate | START_DT | START_DATE |
End Date | enddate | END_DT | END_DATE |
Sweep Date | sweepdate | 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | + | + | + | Â | Â | Â | Â | Â | Â | Â | Â | Â | Â |
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>
Â
Â