Control Message Parameters
Required Parameters
The following table lists required parameters for the Control Message. You must define these parameters for each Control Message used to start the IWS workflow.
Parameter names are case-sensitive.
On this page
Parameter | Example of Value | Comments |
---|---|---|
ActionType | EXTRACT | Constant value for all extracts. |
StreamName | eagle_ml-2-0_default_cm_execwkfl | Constant value for all extracts.The name of the message stream to which data is sent from the Control Message stream. This stream runs the workflow. |
WorkflowName | eagle_wrf_generic_extract |
|
FeedType | SMF,FINANCIALEVENT | Defines the list of object to be extracted.
You can also select only specific extract types from a group, such as: ENTITYLISTLISTEXTRACT, WRHSCLOSELOTEXTRACT, WRHSNAVEXTRACT |
Y (default) | Y – Default method ZIP (.zip extension) NOTE: If delivery method is JMS, all archive will be automatically base64-encoded
|
Archive Parameters
In the Control Message, archive parameters specify how results of the data extract are archived.
Use forward slash (/) as folder delimiter.
The following table lists parameters for archiving the data extract results.
Parameter | Example of Value | Default Value | Comments |
---|---|---|---|
ExtractDeliveryMethod | JMS,FTP,SFTP,FILE | FILE | Chooses the way the extract to be delivered. This setting can affect the set of available parameters you can apply to your extract. |
DeliveryStreamName |
| default value is taken from W_JMS_DEF_EXTRACT_STREAM global parameter in w_config_custom.inc | You use this parameter is case of ExtractDeliveryMethod = JMS to use a custom stream |
FromFolder | ../../../cmw/extracts/ | ../../../cmw/extracts/ | Folder containing files to be archived. |
ToFolder | ../../../cmw/extracts/ | ../../../cmw/extracts/ | Folder in which the archives should be created. NOTE: You must create this destination folder if it does not exist. Especially useful when you use FTP/SFTP/JMS delivery method, but want to save archive locally in the path different from default |
test_new_name_002 |
| Archive name. Only ZIP format compression is available.
| |
test_new_name_001 |
| If this parameter is specified, the archive name will be generated as: OutputZipNamePattern:+ :CorrID: so each archive name will be unique. test_new_name_001_1M6EX27SPOQZKMUN
| |
tst_DateTimeStamp_my2_@feedtype.zip |
| Custom name pattern for the output file. List of valid expressions:
| |
FilesAddToZip | *.XML | ProcessCorrId.* | Template files that will be added to the archive. |
SendDataToFTP | Y or N | N | NOTE: Before you use FTP/SFTP delivery, please make sure it is properly configured for your environment. See Configure Delivery Method Options page of EagleML and EJM wiki space. If this parameter is set to Y, archive data will be loaded to FTP into the CMW\extracts folder. This is an equivalent of ExtractDeliveryMethod = FTP and means that result file will be sent to FTP, even if you choose another ExtractDeliveryMethod option. <COL TAG="W_EAGLE_EXTRACTOR_ZIP_TO_FTP" EXPRESSION="'Y'" USERDESCRIPTION="Move resulting ZIP file to FTP Y or N"/> or its obsolete variation (described to support backward compatibility):
<COL TAG="EAGLE_EXTRACTOR_ZIP_TO_FTP" EXPRESSION="'1'" USERDESCRIPTION="Move result ZIP file to FTP yes(1) or no(0)"/>
ToFTPFolder is also supported, but this is an obsolete parameter, we highly recommend using CustomExtractLocation. |
../../../cmw/custom_extract/ | cmw/extracts/ | Defines a custom folder on FTP/SFTP or on server into which the archive is loaded. Consequently, you cannot set an absolute path to a folder – and this behavior is different from the case of CustomExtractLocation for common extracts (you can set absolute folder paths there). Resulting path for defferent delivery methods is made up like this: For Delivery Method = FILE: For Delivery Method = FTP: For Delivery Method = SFTP:
:STREAMDIR: = /envPath/estar/tpe/data/msgcenter/out/TAGVALUE/eagle_ml-2-0_default_cm_packer/ | |
CustomFTPFolder | CMW/custom_extract/ | CMW/extracts/ | Defines a custom FTP folder into which the archive is loaded. NOTE: To use this option, the ExtractDeliveryMethod parameter must be set to FTP or SendDataToFTP=Y.
|
ExtractSendNotification | 1 or 0 | 1 | The same logic is used for SendNotification, but this option can only be applied to extracts within the workflow. |
Optional Parameters
Optional parameters include:
Pass to Extract parameters. These parameters are passed from the Control Message. If any of these parameters are not supported, they will not be passed along in the Control Messages for the individual extracts.
Supported by Extract parameters. These parameters are passed from the Control Messages for individual extracts.
The following table lists Pass to Extract parameters for the ENTITY extract.
Parameter names are case-sensitive.
Subprocess name | Common | Date | Entity | Held | SMF | History Only | Source | Delta Based | Own |
---|---|---|---|---|---|---|---|---|---|
eagle_generic_extract_entity_and_rule_objects | + | + | + |
|
|
|
|
| entitytype, historyonlyflag |
--eagle_generic_extract_entity_objects | + | + | + |
|
|
|
|
| entitytype, historyonlyflag |
----extract_entity_manager | + | + | + |
|
|
|
|
|
|
----extract_entity_manager_relationship | + | + | + |
|
|
|
|
| entitytype |
----extract_entity_accounting_periods | + | + | + |
|
|
|
|
|
|
----extract_entity_accounting_basis | + | + | + |
|
|
|
|
|
|
---- extract_entity_analytics | + | + | + |
|
|
| + |
|
|
----extract_entity_identifiers | + | + | + |
|
|
|
|
| entitytype |
----extract_generic_entity | + | + | + |
|
|
|
|
| entitytype, historyonlyflag |
----extract_entity_bank_relationship | + | + | + |
|
|
|
|
|
|
----extract_entity_composite | + | + | + |
|
|
|
|
|
|
----extract_entity_list | + | + | + |
|
|
|
|
|
|
----extract_entities_in_composite | + | + | + |
|
|
|
|
|
|
----extract_entities_in_list | + | + | + |
|
|
|
|
|
|
----extract_gips_disclosures | + | + | + |
|
|
|
|
|
|
----extract_gips_composite | + | + | + |
|
|
|
|
|
|
----extract_entity_entitlement_list | + | + | + |
|
|
|
|
| usergroups |
----extract_entity_share_class | + | + | + |
|
|
|
|
|
|
----extract_entity_peer_group_rankings | + | + | + |
|
|
| + |
|
|
----extract_entity_regulatory | + |
| + |
|
|
|
|
|
|
----extract_entity_security_lending | + |
| + |
|
|
|
|
|
|
--eagle_generic_extract_rule_objects | + | + | + |
|
|
|
|
|
|
----extract_rule_contract_cash | + | + | + |
|
|
|
|
|
|
----extract_rule_contractual_cash_settlement | + | + | + |
|
|
|
|
|
|
----extract_rule_earn_thru | + | + | + |
|
|
|
|
|
|
----extract_rule_basis_processing | + | + | + |
|
|
|
|
|
|
----extract_rule_backup_withholding | + | + | + |
|
|
|
|
|
|
----extract_rule_month_end_date | + | + | + |
|
|
|
|
|
|
----extract_rule_primary_mixed_cost_basis | + | + | + |
|
|
|
|
|
|
----extract_rule_amortization_schedule | + | + | + |
|
|
|
|
|
|
----extract_rule_accounting | + | + | + |
|
|
|
|
|
|
The following table lists Pass to Extract parameters for the REFERENCE extract. |
|
|
|
|
|
|
|
|
|
eagle_generic_extract_reference_objects | + | + | + | + | + |
| + |
| selectiontype, selectionvalue, includeissuerxref, securitysubtype, xreftype, issueralias, issuerid, issuername, codecategory, codecategoryname, codevalue, codevaluename, fromcodecategory, fromcodecategoryname, CalendarBusinessName, CalendarType, DateTypeMacro, OnlyBusinessCalendar, ProcessCenterNamefromcodevalue, fromcodevaluename, fromsourcecode, tocodecategory, tocodecategoryname, tocodevalue, tocodevaluename, tosourcecode |
--eagle_generic_extract_issuer_objects | + | + | + |
| + |
|
|
| includeissuerxref, issueralias, issuerid, issuername |
--extract_issuer_entity_relationship | + | + | + |
| + |
|
|
| includeissuerxref, issueralias, issuerid, issuername |
----extract_issuer_relationship | + | + |
|
|
|
|
|
| issueralias, issuerid, issuername |
----extract_issuer_role | + | + |
|
| + |
|
|
| issueralias, issuerid, issuername |
----extract_issuer_organization | + | + |
|
|
|
|
|
| issueralias, issuerid, issuername |
----extract_issuer_rating | + | + |
|
|
|
|
|
| issueralias, issuerid, issuername |
----extract_issuer | + | + |
|
|
|
|
|
| includeissuerxref, issueralias, issuerid, issuername |
--eagle_generic_extract_security_related_objects | + | + |
| + | + |
| + |
| selectiontype, selectionvalue, securitysubtype |
----extract_issue_fx_rate | + | + |
| + | + |
| + |
|
|
----extract_issue_fx_pc_rate | + | + |
| + | + |
| + |
|
|
----extract_issue_price | + | + |
| + | + |
| + |
|
|
----extract_issue_exchange_price | + | + |
| + | + |
| + |
|
|
----extract_smfidentifiers | + | + |
| + | + |
| + |
| securitysubtype, xreftype |
----extract_schedule | + | + |
| + | + |
| + |
| securitysubtype |
----extract_time_series | + | + |
| + | + |
| + |
|
|
----extract_generic_issue_analytic | + | + |
| + | + |
| + |
|
|
----extract_issue_variable_rate | + | + |
| + | + |
| + |
|
|
----extract_rating | + | + |
| + | + |
| + |
| securitysubtype |
----extract_cancelsmfidentifiers | + | + |
| + | + |
| + |
|
|
----extract_forward_points | + | + |
| + | + |
| + |
|
|
----extract_factor | + | + |
| + | + |
| + |
|
|
----extract_securityoverrides | + | + |
|
| + |
| + |
|
|
----extract_naic_designation | + | + |
| + | + |
| + |
|
|
--eagle_generic_extract_system_objects | + | + |
|
|
|
| + |
| jobname, codecategory, codecategoryname, codevalue, codevaluename, fromcodecategory, fromcodecategoryname, fromcodevalue, fromcodevaluename, fromsourcecode, tocodecategory, tocodecategoryname, tocodevalue, tocodevaluename, tosourcecode, CalendarBusinessName, CalendarType, DateTypeMacro, OnlyBusinessCalendar, ProcessCenterName |
----extract_dictionary | + | + |
|
| + |
| + |
| excludesecuritylinksflag, dictionaryname |
----extract_code_translation | + | + |
|
|
|
|
|
| fromcodecategory, fromcodecategoryname, fromcodevalue, fromcodevaluename, fromsourcecode, tocodecategory, tocodecategoryname, tocodevalue, tocodevaluename, tosourcecode |
----extract_code_category | + | + |
|
|
|
|
|
| codecategory, codecategoryname |
----extract_code_value | + | + |
|
|
|
| + |
| codecategory, codecategoryname, codevalue, codevaluename |
----extract_calendar | + | + |
|
|
|
|
|
|
|
----extract_calendar_holiday | + | + |
|
|
|
|
|
| calendarname, calendardate, fromcalendardate, tocalendardate |
----extract_calendar_business_dates | + | + |
|
|
|
|
|
| CalendarBusinessName, CalendarType, DateTypeMacro, OnlyBusinessCalendar, ProcessCenterName |
----extract_error_definition | + | + |
|
|
|
|
|
|
|
----extract_yield_curve | + | + |
|
|
|
|
|
|
|
----extract_run_time_stamps | + | + |
|
|
|
|
|
| jobname |
----extract_ledger_notes | + | + |
|
|
|
|
|
|
|
--eagle_generic_extract_client_objects | + | + |
|
|
|
|
|
| selectiontype, selectionvalue |
----extract_client | + | + |
|
|
|
|
|
| selectiontype, selectionvalue |
----extract_client_communication | + | + |
|
|
|
|
|
| selectiontype, selectionvalue |
The following table lists Pass to Extract parameters for the WAREHOUSE extract |
|
|
|
|
|
|
|
|
|
eagle_generic_extract_warehouse_objects | + | + | + |
| + |
| + |
| BatchMode, ExcludeCurrentDay, accountingdate, fromaccountingdate, frommonthendaccountingdate, GLBasic, monthendaccountingdate, toaccountingdate, tomonthendaccountingdate, fromvaluationdate, tovaluationdate, valuationdate |
--extract_warehouse_cash_activity | + | + | + |
| + |
| + |
| BatchMode, ExcludeCurrentDay |
--extract_warehouse_closelot | + | + | + |
| + |
| + |
| BatchMode, ExcludeCurrentDay |
--extract_warehouse_openlot | + | + | + |
| + |
| + |
| BatchMode, ExcludeCurrentDay |
--extract_warehouse_performance | + | + | + |
| + |
| + |
| BatchMode, ExcludeCurrentDay |
--extract_warehouse_position | + | + | + |
| + |
| + |
| BatchMode, ExcludeCurrentDay |
--extract_warehouse_trade | + | + | + |
| + |
| + |
| BatchMode, ExcludeCurrentDay |
--extract_warehouse_nav | + | + | + |
| + |
| + |
| BatchMode, ExcludeCurrentDay |
--extract_warehouse_custody_activity | + | + | + |
| + |
| + |
| BatchMode, ExcludeCurrentDay |
--extract_warehouse_custody_balance | + | + | + |
| + |
| + |
| BatchMode, ExcludeCurrentDay |
--extract_warehouse_pending_trade | + | + | + |
| + |
| + |
| BatchMode, ExcludeCurrentDay |
--extract_warehouse_glbalances | + | + | + |
| + |
| + |
| BatchMode, ExcludeCurrentDay, accountingdate, fromaccountingdate, frommonthendaccountingdate, GLBasic, monthendaccountingdate, toaccountingdate, tomonthendaccountingdate |
--extract_warehouse_nav_multi | + | + | + |
| + |
| + |
| BatchMode, ExcludeCurrentDay, fromvaluationdate, tovaluationdate, valuationdate |
--extract_warehouse_broker_trade_quote | + | + | + |
| + |
| + |
| BatchMode, ExcludeCurrentDay |
--extract_trade_quotes | + | + | + |
| + |
|
|
|
|
--extract_warehouse_cash_flow_projection | + | + | + |
| + |
| + |
|
|
--extract_warehouse_istarlot | + | + | + |
| + |
| + |
|
|
--extract_warehouse_disclosure_status | + | + | + |
| + |
| + |
|
|
The following table lists Pass to Extract parameters for the SMF, FINANCIALEVENT, CORPORATEACTIONS, and ACCOUNTING extracts and the extract archiving eagle_ml20_default_cm_packer message stream. |
|
|
|
|
|
|
|
|
|
eagle_generic_extract_smf_objects | + | + |
| + | + |
| + |
| asofeffectivedate, securitysubtype |
--extract_generic_smf | + | + |
| + | + |
| + |
| asofeffectivedate, securitysubtype |
eagle_generic_extract_financial_event | + | + | + |
| + |
|
|
|
|
--extract_financial_event | + | + | + |
| + |
|
|
|
|
eagle_generic_extract_corp_actions_objects | + | + |
| + | + |
| + |
|
|
--extract_generic_ca | + | + |
| + | + |
| + |
|
|
--extract_voluntary_ca_election | + | + |
| + | + |
| + |
|
|
eagle_generic_extract_accounting_objects | + | + | + | + | + |
| + |
|
|
--extract_accounting_trade | + | + | + |
| + |
|
|
|
|
--extract_accounting_gl_activity | + | + | + |
| + |
|
|
| FromGLAccount, GLBasic, GLClass, GLDateType, GLFromDate, GLSector, GLToDate, ToGLAccount |
--extract_accounting_traded_cash_activity | + | + | + |
| + |
|
|
|
|
--extract_accounting_cash_projections | + | + | + | + | + |
| + |
|
|
--extract_accounting_accrued_income | + | + | + | + | + |
| + |
|
|
--extract_accounting_subscribe_reedem | + | + | + | + | + |
| + |
|
|
--extract_accounting_daily_mill_rate | + | + | + | + | + |
| + |
|
|
--extract_accounting_unsettled_trans | + | + | + | + | + |
| + |
| reportType, reportDate, baseCurrency, accountingBasis, longShortIndicator, cashCategory, eventReason, cashEventType, shareClass, localCurrency, includeCorpAction, includeFwdTransactions |
--extract_accounting_cash_journal | + | + | + | + | + |
| + |
| reportView, selectView, reportType |
--extract_accounting_realized_gl | + | + | + | + | + |
| + |
| reportType, reportTypeSource, includeCancels, displayZero, displayUDF |
--extract_accounting_settled_ca | + | + | + | + | + |
| + |
|
|
--extract_accounting_cons_earned_income | + | + | + | + | + |
| + |
| reportType, reportPeriod, startDate, endDate, longShortIndicator, rollupIndicator, accountingBasis, baseCurrency, localCurrency, taxableIndicator, nraTaxCountry, governmentIndicator, processCenter, conversionStatus, urglRecpayIndicator |
--extract_accounting_distribution_activity | + | + | + | + | + |
| + |
|
|
--extract_accounting_custom_ledger_acct | + | + | + | + | + |
| + |
| Switch, ChartOfAccountName, GLAccount, CustomAccount, CustomAccountDescription, GLPostType |
--extract_accounting_open_rec_pay_multi | + | + | + | + | + |
| + |
| issuename, settlecurrency, brokerName, brokerCode, targerEventId, eventType, tradeTicketNumber, category |
--extract_accounting_unapproved_var_margin | + | + | + |
| + |
|
|
| accountingBasis, baseCurrency, longShortIndicator, reportType |
--extract_accounting_trial_balance | + | + | + |
|
|
|
|
| selectView, ledgerProfile, reportType, generalLedgerCurrency, accountingBasis, showMEMOAccounts, showAssetLevelDetails, reportFilters, selectSector, sectorID, sector, selectShareClass, shareClass, detailedClassView, reportDate, monthEndDate, filterSecurityBy, issuename |
--extract_accounting_intraday_nav | + | + | + |
|
|
|
|
|
|
--extract_accounting_nav_for_nasdaq | + | + | + |
|
|
|
|
|
|
--extract_accounting_fair_value_comparison | + | + | + |
|
|
|
|
|
|
eagle_ml20_default_cm_packer |
|
|
|
|
|
|
|
| CustomExtractLocation, ExtractDeliveryMethod, FromFolder, ToFolder, OutputZipFileName, OutputZipFileNamePattern, SendDataToFTP |
S2P Reporting |
|
|
|
|
|
|
|
|
|
eagle_generic_extract_ref_independent_objects | + | + |
|
|
|
|
| + |
|
--eagle_generic_extract_system_objects | + | + |
|
|
|
|
| + |
|
----extract_control_center_event_log | + | + |
|
|
|
|
| + | eventgroupname, eventtaskid, activeflag, completedflag, coregroup, statisticcategory, statisticname, statistictype, businessprocessinggroup |