Versions Compared

Old Version 8

changes.mady.by.user Dmitry Donosiyan (Unlicensed)

Saved on

compared with

New Version Current

changes.mady.by.user Kinga Huszno

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

yyyy-mm-dd or yyyy-mm-dd hh24-mi-ss​, for example 2013-01-01 or 2013-01-01 15-00-00

Info
titleNote
​These filters have sense only if the EagleML object you want to extract contains the corresponding database field. 

...

startdate

fromstartdate

tostartdate

...

enddate

fromenddate

toenddate

...

The following table contains a more detailed listing of date filters available for each feed type.

...

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

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

START_DATE

End Date

enddate
fromenddate
toenddate

END_DT

END_DATE

Sweep Date

sweepdate
fromsweepdate
tosweepdate

SWEEP_DATE

On this page

Table of Contents

Anchor
Date_Filters_Reference_Table
Date_Filters_Reference_Table
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

+
(see
 more details)

+
(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
SMF_updatedate_note
SMF_updatedate_note

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
languagexml
       <taskParameter>
              <name>updatedate</name>
              <dataType>S</dataType>
              <value>2013-06-25 15-00-00</value>
       </taskParameter>