Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 22 Next »

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 NameAvailable ParametersDB Field
Update Dateupdatedate
todate
fromdate
UPDATE_DATE 
Effective Dateeffectivedate
fromeffectivedate
toeffectivedate
EFFECTIVE_DATE 
Release Datereleasedate
fromreleasedate
toreleasedate
RELEASE_DATE
Accounting Dateaccountingdate
fromaccountingdate
toaccountingdate
ACCOUNTING_DATE
Month End (Accounting) Datemonthendaccountingdate
frommonthendaccountingdate
tomonthendaccountingdate
MONTH_END_ACCOUNTING_DATE
MONTH_END_DATE
GLDP_ACCOUNTING_DATE
Post Datepostdate
frompostdate
topostdate
POST_DATE
Valuation Datevaluationdate
fromvaluationdate
tovaluationdate
VALUATION_DATE
Ledger Effective Dateledgereffdate
fromledgereffdate
toledgereffdate
LEDGER_EFFECTIVE_DATE
Trade Datetradedate
fromtradedate
totradedate
TRADE_DATE
Settlement Datesettlementdate
fromsettlementdate
tosettlementdate
SETTLEMENT_DATE
Start Datestartdate
fromstartdate
tostartdate
START_DT
End Dateenddate
fromenddate
toenddate
END_DT
Sweep Datesweepdate
fromsweepdate
tosweepdate
SWEEP_DATE


Date Filters Reference Table

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

Object NameFeed TypeUpdateEffectiveReleaseAccountingMonth End (Acct)PostValuationLedger EffectiveTradeSettlementStartEndSweep

Entity















Composite Entity ListENTITYCOMPOSITELISTEXTRACT+











Entity Manager RelationshipENTITYMANAGERRELEXTRACT+











Entity Share ClassENTITYSHARECLASSEXTRACT      ++










Entity Accounting BasisENTITYACCBASISEXTRACT+











Entity Bank RelationshipENTITYBANKRELEXTRACT         +











Entity ManagerENTITYMANAGEREXTRACT         +











Entity XREFENTITYXREFEXTRACT+











Entity ListENTITYLISTEXTRACT+











Entities In ListENTITYLISTLISTEXTRACT+











Generic EntityENTITYEXTRACT                ++










Entity Accounting PeriodsENTITYACCPERIODSEXTRACT      +








++

Rule















Primary Mixed Cost Basis RuleRULEPRIMCOSTBASISEXTRACT      +











Contract Cash RuleRULECONTRACTCASHEXTRACT+











Contractual Cash Settlement RuleRULECCSETTLEMENTEXTRACT+











Earn Thru RuleRULEEARNTHRUEXTRACT           +











Basis Processing RuleRULEBASISPROCEXTRACT+











Backup Withholding RuleRULEBUWITHHOLDINGEXTRACT+











Month End Date RuleRULEMONTHENDDATEEXTRACT












Amortization Schedule RuleRULEAMORTSCHDLEXTRACT+











Accounting RuleRULEACCOUNTINGEXTRACT+











SMF















Generic SMFSMFEXTRACT

+
(see
 more details)

+
(see
 more details)
+









Reference















Code TranslationCODETRANEXTRACT+











Code ValueCODEVALEXTRACT+











Code CategoryCODEEXTRACT+











Cash ProjectionsCASHPROJECTIONSEXTRACT           ++







++
Error DefinitionEXCEPTIONDEFEXTRACT+











Demand ListDEMANDLIST
+










Calendar Business DatesCALBUSINESSDATESEXTRACT          












CalendarREFCALENDAREXTRACT+











Calendar HolidayREFCALENDARHOLIDAYEXTRACT+











Run Time StampsRPTTIMESTAMPS                    












RatingRATINGSEXTRACT                   ++










Entity Entitlement ListENTITYENTITLEMENTLISTEXTRACT     +











Ledger NotesLEDGERNOTESEXTRACT               +











Report DictionaryDICTIONARYEXTRACT
+










NAIC DesignationNAICDESIGNATIONEXTRACT++










Security related















SMF IdentifiersXREFEXTRACT                  +











Exchange PriceISSUEEXCHANGEPRICEEXTRACT    ++










Issue Variable RateISSUEVARRATEEXTRACT          ++










Issue Fx RateISSUEFXRATEEXTRACT           ++










Issue PriceISSUEPRICEEXTRACT            ++










Issue Fx Pc RateISSUEFXPCRATEEXTRACT         ++










Generic Issue AnalyticGENISSUEANALYTICEXTRACT      ++










ScheduleSCHEDULEEXTRACT              ++










GIPS CompositeREFGIPSCOMPOSITEEXTRACT+











GIPS DisclosureREFGIPSDISCLOSUREEXTRACT+











Time SeriesREFTIMESERIESEXTRACT         +











Trade QuoteREFTRADEQUOTESEXTRACT        ++










Yield CurveYIELDCURVEEXTRACT++










Forward PointsFORWARDPOINTSEXTRACT         ++










FactorFACTOREXTRACT                ++










Security OverridesSECURITYOVERRIDESEXTRACT++










Issuer















IssuerGENISSUEREXTRACT         +











Issuer RatingISSUERRATINGEXTRACT      ++










Issuer OrganizationISSUERORGEXTRACT         +











Issuer RelationshipISSUERRELEXTRACT         ++










Issuer RoleISSUERROLEEXTRACT        ++








+

Warehouse















Warehouse Pending TradeWRHSPENDINGTRADESEXTRACT       ++










Warehouse Custody ActivityWRHSCSTDACTIVITYEXTRACT        ++










Warehouse Custody BalanceWRHSCSTDBALANCEEXTRACT         ++










Warehouse Cash ActivityWRHSCASHACTIVITYEXTRACT        ++
+++

++


Warehouse PerformanceWRHSPERFORMANCEEXTRACT         ++










Warehouse Close LotWRHSCLOSELOTEXTRACT            ++
+++
+++


Warehouse PositionWRHSPOSITIONEXTRACT            ++










Warehouse Open LotWRHSOPENLOTEXTRACT             ++
+



++


Warehouse Open LotWRHSOPENLOTBROKERROLLUPEXTRACT++
+



++


Warehouse TradeWRHSTRADEEXTRACT               ++
+++++++


Warehouse NAV MultiWRHSNAVMULTIEXTRACT            +




+





Warehouse NAVWRHSNAVEXTRACT                 ++










Warehouse NAV MonthendWRHSNAVMONTHENDEXTRACT+




+





Warehouse General Ledger BalancesWRHSGLDETAILPOSTINGEXTRACT     ++
+++






Warehouse Broker Trade QuoteWRHSBROKTRDQUOTEEXTRACT        +











Warehouse Cash Flow ProjectionWRHSCASHFLOWPROJEXTRACT        ++










Insurance Valuation LotINSURANCEVALUATIONLOTEXTRACT++

+







Warehouse Disclosure StatusWRHSDISCLOSURESTATUSEXTRACT++










Warehouse Wash Sale TradeWRHSWASHSALETRADEEXTRACT++


+

+



Corporate Action















Generic Corporate ActionsGENCORPACTIONSEXTRACT   ++









+
Voluntary CA ElectionVOLCAELECTIONEXTRACT    ++










Client















ClientCLIENTEXTRACT      +











Client CommunicationCLIENTCOMMEXTRACT  +











Accounting















Accounting TradeACCOUNTINGTRADEEXTRACT++










Financial EventFINANCIALEVENTEXTRACT++










Traded Cash ActivityTRADEDCAEXTRACT                  ++
+++


+


Settled Cash ActivitySETTLEDCAEXTRACT                 ++
+++

++


Accounting GL ActivityGLACTIVITYEXTRACT                +

+++






Accrued IncomeACCRUEDINCOMEEXTRACT             ++
+
+

++


Subscribe RedeemSUBSCRIBEREEDEMEXTRACT           ++
+++


+


Daily Yield Mill RateDAILYYIELDMILLRATEEXTRACT        ++



+





Cash JournalCASHJOURNALEXTRACT               +

+++

++


Unsettled TransactionsUNSETTLEDTRANSACTIONSEXTRACT++
+++

++


Realized Gain LossREALIZEDGAINLOSSEXTRACT+


++

++


Consearned IncomeCONSEARNEDINCOMEEXTRACT          +

++







Distribution ActivityDISTRIBUTIONACTEXTRACT           ++



+





Custom Ledger AccountCUSTLEDGERACCTEXTRACT+











Open Rec Pay MultiOPENRECPAYMULTIEXTRACT+







+


Unapproved Variation MarginUNAPPROVEDVARMARGINEXTRACT+











Trial BalanceTRIALBALANCEEXTRACT+

++







Fair Value ComparisonFAIRVALUECOMPARISONEXTRACT
+










Accounting Intraday NAVINTRADAYNAVEXTRACT++



+





Accounting NAV for NASDAQNAVFORNASDAQEXTRACT++



+





Accounting RejectionREJECTIONEXTRACT++










User Administration















UserUSEREXTRACT












GroupUSERGROUPEXTRACT












EntitlementUSERENTITLEMENTEXTRACT












Eagle Administration SettingsEAGLEADMINISTRATIONSETTINGSEXTRACT












Other















Calculate DateCALCULATEDATE+











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>


  • No labels