Own Filters

Own filters are implemented in the Q-rules (rules of Q-streams) of some Objects. Parameters of Own filters are located in the “Task parameters” section of Control Message file like others filter parameters.

The table below shows the list of parameters for Own filters.

Object Name

Feed Type

Filter Name

Parameter Name

Example of Value

Comments

Corporate Action Objects

Generic CA

GENCORPACTIONSEXTRACT

Max Sweep Date

maxsweepdate

2018-08-01

Filter by SWEEP_DATE

Click to see more details:

(select * from TRADESDBO.CORP_ACT_HIST r where r.rowid in
(select x.rid from
(select r.rowid rid,
row_number() over (partition by r.SRC_INTFC_INST, r.SECURITY_ALIAS order by r.SWEEP_DATE desc) rn_total
from TRADESDBO.CORP_ACT_HIST r
where r.SWEEP_DATE <= TO_DATE('2018-08-01', 'YYYY-MM-DD')
) x
where x.rn_total = 1
) ) CORP_ACT_HIST

Records of GenericCA are grouped by keys 'Source+SecurityAlias' in descending order by field 'SWEEP_DATE'.
The records closest to the specified maxsweepdate = '2018-08-01' will be extacted.
Example of SweepDate for Source=Source1 and Security=Security1:
Source1 / Security1 / 2018-07-10
Source1 / Security1 / 2018-07-20
Source1 / Security1 / 2018-07-30
After grouping, only one record with SweepDate = 2018-07-30 will be extracted.

Max Sweep Date Rule

maxsweepdaterule

Use Trans Type Grouping

UseTransTypeGrouping

Y

Avalable values are: Y or N.
If UseTransTypeGrouping=Y, additional key 'TransType' is used to group records.

Click for more details:

row_number() over (partition by r.SRC_INTFC_INST, r.SECURITY_ALIAS, r.TRANS_TYPE order by r.EFFECTIVE_DATE desc) rn_total

Example of data:
Source1 / Security1 / 2018-07-10 / CASHDIV
Source1 / Security1 / 2018-07-20 / CASHDIV
Source1 / Security1 / 2018-07-30 / CASHDIV
Source1 / Security1 / 2018-07-10 / FACTOR
Source1 / Security1 / 2018-07-20 / FACTOR

Extracted records:
if UseTransTypeGrouping=N or missing: 1 record
Source1 / Security1 / 2018-07-30 / CASHDIV
if UseTransTypeGrouping=Y: 2 records
Source1 / Security1 / 2018-07-30 / CASHDIV
Source1 / Security1 / 2018-07-20 / FACTOR

Trans Type

transType

CASHDIV

Filter by TRANS_TYPE field

CP Reason

cpReason

CASHDIV

Filter by CP_REASON field

CP Status

cpStatus

RD

Filter by CP_STATUS field

Client Specific CA Id

clientSpecificCAId

CASHDIV_1001

Filter by CP_COUNTER_PARTY field

Entity Objects

Entity Manager Relationship

ENTITYMANAGERRELEXTRACT

Entity Type

entitytype

PORT

rulesdbo.entity.entity_type

Entity XREF

ENTITYXREFEXTRACT

Generic Entity

ENTITYEXTRACT

Generic Entity

ENTITYEXTRACT

Remove Entity Duplicates

RemoveEntityDuplicates

Y

If you are experiencing issues with duplicate entities being extracted, setting up the RemoveEntityDuplicates filter on the RTR or W_REMOVE_ENTITY_DUPLICATES global parameter in w_config_custom.inc to 'Y' can help solve it.

Max Effective Date

maxeffectivedate

2013-01-01

Available only in history mode. See an example of use on this page.

Active Status

activeStatus

Y or N

Filter by RULESDBO.ENTITY.ACTIVE_STATUS field

Inlude Entity Detail History

includeEntityDetailHistory

Y or N

Joins RULESDBO.ENTITY_DETAIL_HISTORY table instead of RULESDBO.ENTITY_DETAIL. So all historical records are included (even the records which doesn't tied to a record in the RULESDBO.ENTITY_HISTORY table). Effective date filter is available for this option.

SMF Objects

Generic SMF

SMFEXTRACT

Max Effective Date

maxeffectivedate

2013-01-01

Available only in history mode. See an example of use on this page.

SecuritySubType

securitysubtype

VALUE

securitydbo.security_master_detail_hist.alt_security_type or securitydbo.security_master_detail.alt_security_type

Reference Objects

Calendar Holiday

REFCALENDARHOLIDAYEXTRACT

Calendar Name

calendarname

Calendar Date

fromcalendardate

2013-01-01

calendardate

tocalendardate

Classification Matrix

CLASSIFICATIONMATRIXEXTRACT

Exclude Class Matrix Id

ExcludeClassMatrixId

Y or N (default)

Pending Only

pendingOnly

Y or N (default)

If no value is entered, all records are returned

Classification Matrix Name

ClassificationMatrixName

Filter on DB name EGL_CLASS_MATRIX.CLASS_MATRIX_DESC

Code Translation

CODETRANEXTRACT

FromSourceCode

fromsourcecode

EAGLE PACE

pace_masterdbo.interfaces.short_desc

FromCodeCategory

fromcodecategory

TEST

pace_masterdbo.codes.short_desc

FromCodeCategoryName

fromcodecategoryname

TEST

pace_masterdbo.codes.long_desc

FromCodeValue

fromcodevalue

CAD

pace_masterdbo.code_values.short_desc

FromCodeValueName

fromcodevaluename

CanadianDollar

pace_masterdbo.code_values.long_desc

ToSourceCode

tosourcecode

EAGLE PACE

pace_masterdbo.interfaces.short_desc

ToCodeCategory

tocodecategory

TEST

pace_masterdbo.codes.short_desc

ToCodeCategoryName

tocodecategoryname

TEST

pace_masterdbo.codes.long_desc

ToCodeValue

tocodevalue

CAD

pace_masterdbo.code_values.short_desc

ToCodeValueName

tocodevaluename

CanadianDollar

pace_masterdbo.code_values.long_desc

Updatedate

updatedate

2013-05-10

pace_masterdbo.code_translation.upd_datetime

Code Value

CODEVALEXTRACT

SourceName

sourcename

EAGLE PACE

pace_masterdbo.interfaces.short_desc

CodeCategory

codecategory

TEST

pace_masterdbo.codes.short_desc

CodeCategoryName

codecategoryname

TEST

pace_masterdbo.codes.long_desc

CodeValue

codevalue

CAD

pace_masterdbo.code_values.short_desc or

pace_masterdbo.code_values_hist.short_desc

CodeValueName

codevaluename

CanadianDollar

pace_masterdbo.code_values.long_desc or

pace_masterdbo.code_values_hist.long_desc

Code Category

CODEEXTRACT

CodeCategoryName

codecategoryname

CAD

pace_masterdbo.codes.long_desc

CodeCategory

codecategory

CanadianDollar

pace_masterdbo.codes.short_desc

Calendar Business Dates

CALBUSINESSDATESEXTRACT

Calendar type

CalendarType

STAR

required

should have a value ‘STAR’ or ‘PACE’

Calendar Name/source

CalendarBusinessName

TEST

required

pace_masterdbo.estar_calendar.name or

pace_masterdbo.interfaces.short_desc

Date type macro

DateTypeMacro

CCD

required

values: 'CME', 'PME', 'CBM', 'PBM', 'CCD', 'PCD', 'CYE', 'PYE', 'CQE', 'PQE'

Process Center Name

ProcessCenterName

1A

rulesdbo.process_center.process_center

Error Definition

EXCEPTIONDEFEXTRACT

Error Code

ErrorCode

ERR001

Filter by error code string

Entity Entitlement List

ENTITYENTITLEMENTLISTEXTRACT

User Groups

usergroups

EQCSCS,DBFIFI

Defines the user group(s) to be extracted.
Value can be set in one of the following formats
- EQCSCS,DBFIFI - include values (EQCSCS,DBFIFI)
- I(EQCSCS,DBFIFI) - include values (EQCSCS,DBFIFI)
- E(EQCSCS,DBFIFI) - exclude values (EQCSCS,DBFIFI)
- L(%EQ%) - include values LIKE (%EQ%)

Line of Credit

LINEOFCREDITEXTRACT

Facility Id

facilityid

test_id

Filters by SECURITYDBO.LINE_OF_CREDIT.FACILITY_ID field

PACE System

PACESYSEXTRACT

System Item

sysitem

Filters by PACE_MASTERDBO.PACE_SYSTEM.SYS_ITEM field

Pricing System Setting

PRICINGSYSSETTINGEXTRACT

Code

code

Filters by RULESDBO.PRICING_SYSTEM_SETTINGS.CODE field

Process Center

PROCESSCENTEREXTRACT

Process Center Name

ProcessCenterName

HY,CR,H3,RC

Calendar Business Name

CalendarBusinessName

BILL2,US,CA,CALENDAR1

Report Dictionary

DICTIONARYEXTRACT

Dictionary Name

dictionaryname

Security Classification

Exclude Security Links Flag

excludesecuritylinksflag

Y

Y or N (Default value is "N"). See more details about Report Dictionary outbound interface logic on this page.

Linked Asset Only Delta

linkedassetonlydelta

Y

If this parameter is set to Y, then whenever we do a delta based dictionary extract, we should only look at SECURITY_DICTIONARY_LINK.SECURITY_DATE to determine the linked assets (and their corresponding dict detail) records to extract. There is no need to check dict detail update_date for delta based dictionary extracts in the selection criteria if that flag is set to Y. Available as a global parameter for w_config_custom.inc - W_LINKED_ASSET_ONLY_DELTA

Source

SOURCEEXTRACT

Source Instance

sourceinstance

EAGLE PACE,EAGLE ANALYTICS

Source Name

sourcename

-1,4,5

Yield Curve

YIELDCURVEEXTRACT

Yield Curve Code

yieldcurvecode

AU

Filters by SECURITYDBO.YIELD_CURVE_YIELD_CURVE_CODE field

Security Related Objects

SMF Identifiers

XREFEXTRACT

SecurityAlias

securityalias

22510398,22510399

securitydbo.xreference_hist.security_alias or

securitydbo.xreference.security_alias

XrefType

xreftype

ISIN

securitydbo.xreference_hist.xref_type or

securitydbo.xreference.xref_type

SecuritySubType

securitysubtype

VALUE

securitydbo.security_master_detail.alt_security_type or

securitydbo.security_master_detail_hist.alt_security_type

Schedule

SCHEDULEEXTRACT

SecuritySubType

securitysubtype

VALUE

securitydbo.security_master_detail.alt_security_type

Rating

RATINGSEXTRACT

Max Effective Date

maxeffectivedate

2016-09-30

If this parameter is specified, for every (Source Name + Security Alias) pair only one record will be returned. The value of Effective Date will be maximum for each pair, but not greater than Max Effective Date.

GIPS Disclosure

REFGIPSDISCLOSUREEXTRACT

Disclosure Name

DisclosureName

NAME

RULESDBO.DISCLOSURE.NAME

Disclosure Type

DisclosureType

TYPE

RULESDBO.DISCLOSURE.TYPE

Issuer Objects

(Generic) Issuer,
Issuer Relationship,
Issuer Role,
Issuer Organization,
Issuer Regulatory

GENISSUEREXTRACT
ISSUERRELEXTRACT
ISSUERROLEEXTRACT
ISSUERORGEXTRACT
ISSUERREGULATORYEXTRACT

IssuerId

issuerid

134131

securitydbo.{Related DB TABLE}.issuer_id

IssuerName

issuername

TEST CORP

securitydbo.{Related DB TABLE}.issuer_name

IssuerAlias

issueralias

134

securitydbo.{Related DB TABLE}.from_issuer_alias

Issuer Rating

ISSUERRATINGEXTRACT

IssuerAlias

issueralias

134

SECURITYDBO.ISSUER_RATINGS.ISSUER_ALIAS

Issuer Role

ISSUERROLEEXTRACT

MinEndDate

minenddate

2016-09-30

If this parameter is specified, for every (Issuer Alias + Security Alias) pair only one record will be returned. The value of End Date will be minimum for each pair, but not less than Min End Date.

(Generic) Issuer,
Issuer Organization,
Issuer Rating

GENISSUEREXTRACT
ISSUERORGEXTRACT
ISSUERRATINGEXTRACT

MaxEffectiveDate

maxeffectivedate

2016-09-30

Available only in history mode. See an example of use on this page.

Warehouse Objects

Warehouse

WRHSOPENLOTEXTRACT
WRHSCLOSELOTEXTRACT
WRHSPOSITIONEXTRACT
WRHSTRADEEXTRACT
WRHSCASHACTIVITYEXTRACT
WRHSPERFORMANCEEXTRACT
WRHSGLDETAILPOSTINGEXTRACT
WRHSNAVEXTRACT
WRHSNAVMULTIEXTRACT
WRHSOPENLOTBROKERROLLUPEXTRACT
WRHSWASHSALETRADEEXTRACT

Batch Mode

BatchMode

Y or N (default)

If this parameter is set to Y then, the data will be grouped by BatchKey (EntityID + Effective Date + Source Name). All elements with the same BatchKey values will be collected in a single node warehouseTransaction And element(<batchKey> EntityID^EffectiveDate ^SourceName </ batchKey>) will added to the group: warehouseTransaction/header For Example:<batchKey>ENT123^20140608^SRC123</batchKey>

WRHSPOSITIONEXTRACT
WRHSOPENLOTEXTRACT
WRHSOPENLOTBROKERROLLUPEXTRACT

Extract Level

extractLevel

A

Uses UPDATE_DATE from the POSITION database table for updatedate filter instead of POSITION_DETAIL or LOT_LEVEL_POSITION, thus extracting full batch of records instead of only updated ones (in case some of the records in the batch were updated in Single Row mode).

WRHSPOSITIONEXTRACT

Extract Level

extractLevel

PA

PDB

Set PA to extract data only from the POSITION table.

When set to PDB (position Detail Batch), extract will pull all the records from POSITION_DETAIL table tied to one position, if at least one of them was updated since previous extract.

Warehouse Broker Trade Quote

WRHSBROKTRDQUOTEEXTRACT

Master Ticket Number

masterTicketNumber

MTN_20160202_101_101

Filters by Master Ticket Number

Warehouse Trade

WRHSTRADEEXTRACT

Transaction Code

transactioncode

E(CONVERSION,CONVERSIONCANCEL)

Works with TRADESDBO.TRADE.TRANS_CODE field
Supports the following expressions:
I(CONVERSION,CONVERSIONCANCEL) - include values (CONVERSION,CONVERSIONCANCEL)
E(CONVERSION,CONVERSIONCANCEL) - exclude values (CONVERSION,CONVERSIONCANCEL)
CONVERSION,CONVERSIONCANCEL - include values (CONVERSION,CONVERSIONCANCEL)
L(%CONVERSION%) - include values LIKE (%CONVERSION%)

S2P Remapping

EnableS2PReMappingFlag

Y or N (default)

If set to Y, the following fields are remapped:
'secFee' is mapped into 'otherFee'
'secFeesBase' is mapped into 'otherFeeBase'
'exchangeFee' is mapped into 'secFee'
'exchangeFeeBase' is mapped into 'secFeeBase'
'otherFee' is mapped into 'exchangeFee'
'otherFeeBase' is mapped into 'exchangeFeeBase'.

Warehouse GL Balances

WRHSGLDETAILPOSTINGEXTRACT

GL Basic

GLBasic

TEST4

ledgerdbo.gl_detail_posting.acct_basis

Include MEMO Accounts

IncludeMEMOAccounts

N

Default value is 'Y'. Setting to ‘N’ adds the following condition to the WHERE section of the query to exclude MEMO accounts: GL_DETAIL_POSTING.GLDP_ASSET_LIAB_DESC != ‘MEMO’

Include Only Acct Base Currency

IncludeOnlyAcctBaseCurrency

Y

Default value is 'N'. Setting to ‘Y’ adds the following condition to the WHERE section of the query to extract only those Base Currency Ledger Balances that match Account Currency RULESDBO.ENTITY_ACCT_BASIS.BASE_CURRENCY

Warehouse Open Lot

WRHSOPENLOTBROKERROLLUPEXTRACT

Group by

GroupBy

See example of RTR

Not a filter, but a specific task parameter for WRHSOPENLOTBROKERROLLUPEXTRACT

Warehouse Wash Sale Trade

WRHSWASHSALETRADEEXTRACT

Original Accounting Date

origaccountingdate
fromorigaccountingdate
toorigaccountingdate

date value

Filters by ORIG_ACCT_DATE field

Insurance Valuation Lot

INSURANCEVALUATIONLOTEXTRACT

Client Id

clientid

Lot Id

lotid

NAIC Designation

NAICDESIGNATIONEXTRACT

NAIC Resolution Type

naicresolutiontype

NAIC Asset Id

naicassetid

NAIC Client Id

naicclientid

Client Objects

Client

CLIENTEXTRACT

ClientID

selectiontype

ClientID

selectionvalue

ABC

Instance

selectiontype

Instance

selectionvalue

123

Client Communication

CLIENTCOMMEXTRACT

Communication Type

selectiontype

CommunicationType

Old format of filters, supported for backward compatibility along with new ones:

selectionvalue

PHONE

Instance

selectiontype

Instance

selectionvalue

123

Communication Type

CommunicationType

PHONE

Client Id

ClientId

TestValue

Accounting Objects

Cash Projections

CASHPROJECTIONSEXTRACT

Cash Projection Report Type

CashProjectionReportType

FI;DIV;FW;OTH;UT

Filter results by ESTAR.ESTAR_CASH_PROJECTION.REPORT_TYPE. The options for Report type are:

UserView - Cash Projection Viewer	DB_Value - EagleML Parameter Value
Fixed Income	FI
Dividends	DIV
Forwards	FW
Others Buys/Sells/Spots etc	OTH
Unsettled	UT
All	FI;DIV;FW;OTH;UT
Any Combination of Above	Any Combination of Above

Parameter can contain any combination of available values divided by the "|" char.
For example:
Fixed Income|Dividends - DB value is: FI;DIV.
Forwards|Fixed Income - DB value is: FW;FI.
This means using of one DB value in the filter: ESTAR_CASH_PROJECTION.REPORT_TYPE = "FI;DIV".
etc.

The parameter can also contain several strings divided by the "," char.
For example:
Fixed Income|Dividends,Fixed Income|Dividends - DB value is: FI;DIV or DIV;FI.
This means using multiple DB values with "OR" condition:
( ESTAR_CASH_PROJECTION.REPORT_TYPE = "FI;DIV" or
ESTAR_CASH_PROJECTION.REPORT_TYPE = "DIV;FI" ).

Cash Projection Report Name

CashProjectionReportName

Filter results by ESTAR.ESTAR_CASH_PROJECTION.REPORT_NAME field

Cash Projection Position Switch

CashProjectionPositionSwitch

Filter results by ESTAR.ESTAR_CASH_PROJECTION.POSITION_SWITCH field.

Cash Projection Instance and Type

CashProjectionInstance
CashProjectionInstanceType

Pair parameters CashProjectionInstanceType/CashProjectionInstance filters by
ESTAR.ESTAR_CASH_PROJECTION.CP_INSTANCE field

1) Specific values of Instance:

CashProjectionInstanceType = Specific
CashProjectionInstance = list of Instance values (one or more).
Filter is : ESTAR_CASH_PROJECTION.CP_INSTANCE in (instance1,instance2,...)

2) Max or Min values of Instance:

CashProjectionInstanceType = Max or Min
CashProjectionInstance is not used.
Filter is (example given for "Max"):
ESTAR_CASH_PROJECTION.CP_INSTANCE IN
(SELECT MAX(CP_INSTANCE)
FROM ESTAR.ESTAR_CASH_PROJECTION
GROUP BY PORTFOLIO_acct, START_DATE, END_DATE)

Accounting Basis

accountingBasis

Filter results by ESTAR.ESTAR_CASH_PROJECTION.ACCOUNTING_BASIS field.

Custom Ledger Account

CUSTLEDGERACCTEXTRACT

GLSelectionType

Switch

GL Selection Type

Switch

Both filter names are valid, GLSelectionType and Switch

GLSelectionType	DB Table	DB Field	Used GL-parameter	Filter value
CUSTACCT	CUST_CHART	CUST_ACCOUNT	GLCustomAccount	like (:ParamValue:+'%')
STARACCT	CUST_CHART	GL_ACCOUNT	GLAccount	like (:ParamValue:+'%')
ACCTDESC	CUST_CHART	CUST_ACCOUNT_DESC	GLCustomAccountDescription	like (:ParamValue:+'%')
ACCTDESC_EXACT	CUST_CHART	CUST_ACCOUNT_DESC	GLCustomAccountDescription	= :ParamValue:
EXPACCT	CUST_CHART	CUST_ACCOUNT_DESC	GLCustomAccountDescription	like (:ParamValue:+'%')
EXPACCT	CHART_OF_ACCTS	GL_POST_TYPE	GLPostType	= :ParamValue:

GL Chart of Account Name

GLChartOfAccountName

Filter by RULESDBO.CUST_CHART.CUST_COA_NAME field.

GL Account

GLAccount

Filter by RULESDBO.CUST_CHART.GL_ACCOUNT field.

GL Custom Account

GLCustomAccount

Filter by RULESDBO.CUST_CHART.CUST_ACCOUNT field.

GL Custom Account Description

GLCustomAccountDescription

Filter by RULESDBO.CUST_CHART.CUST_ACCOUNT_DESC field.

GL Post Type

GLPostType

Filter by RULESDBO.CHART_OF_ACCTS.GL_POST_TYPE field.

Realized Gain Loss

REALIZEDGAINLOSSEXTRACT

Report Type

reportType

ACCTGDT

ACCTGDT (default) - Accounting Date;
MONTHDT - Month End Date;
POSTDT - Post Date;
SETTLEDT - Settlement Date;
TRADEDT - Trade Date;

Report Period

reportPeriod

DR

DA (default) - Daily Activity
DR - Date Range
FYTD - Fiscal Year to Date
LTD - Life to Date
CYTD - Calendar Year to Date
ITD - Inception to Date
MTD - Month to Date

Report Type Source

reportTypeSource

ACCTGDT

ACCTGDT (default) - Accounting Date Source;
POSTDT - Post Date Source;

Accounting Basis

accountingBasis

USTAX

Accounting Basis for Portfolio

Report Filters

reportFilters

Y

Y,N(default). If this filter set to Y, it allows to use additional filter described below.

Filter Security By

filterSecurityBy

XREF

'XREF' (default), 'NAME', 'PRIMARY'

Issue Name

issuename

TEST_ISSUE_NAME

Available if filterSecurityBy = 'NAME'

Primary Asset Id

primaryassetid

KFRK83092

Available if filterSecurityBy = 'PRIMARY'

Xreference Id

xrefid

KFRK83092

Available if filterSecurityBy = 'XREF'

Xreference Id Type

xrefidtype

CUSIP

Available if filterSecurityBy = 'XREF'

Asset Currency

localCurrency or assetCurrency

EUR

Currency filter
Available if Security Alias is not resolved by specified Security filters

Processing Security Type

processingsecuritytype

DERV

Security Type

securitytype

F5E

Investment Type

investmenttype

FWD

Issue Country

nraTaxCountry

TEST1

Available if Security Alias is not resolved by specified Security filters

Include Cancels

includeCancels

Y

Y,N(default)

Long Short Indicator

longShortIndicator

L

L - long
S - short

eventType

BUY

Lot-Position Switch

lotPosSwitch

LOT

POS,LOT(default) - SP mode only

Display UDF

displayUDF

Y

Y,N(default) - panel mode for v2017 or higher, SP mode only for other

Display Zero

displayZero

Y

Y,N(default)

Include Writedowns

includewritedowns

Y

Y(default),N

Trial Balance

TRIALBALANCEEXTRACT

Select View

selectView

SECTOR_VIEW

SECTOR_VIEW or CLASS_VIEW or COMPLETE_VIEW

Profile

ledgerProfile

DEFAULT_TRIAL_BALANCE_TF

DEFAULT_TRIAL_BALANCE_TF - use with selectView = 'TotalFund' or 'Complete'
DEFAULT_TRIAL_BALANCE_SECTOR - use with selectView = 'Sector'
DEFAULT_TRIAL_BALANCE_CLASS - use with selectView = 'Class' and detailedClassView = 'N'
DEFAULT_TB_CLASS_DETAIL - use with selectView = 'Class' and detailedClassView = 'Y'

Report Type

reportType

MONTHDT

MONTHDT - MonthEndDate
ACCTGDT (default) - Accounting Date

General Ledger Currency

generalLedgerCurrency

USD

uses baseCurrency value if empty

Accounting Basis

accountingBasis

USTAX

Show MEMO Accounts

showMEMOAccounts

Y

Y,N(default)

Show Asset Level Details

showAssetLevelDetails

Y

Y,N(default)

Report Filters

reportFilters

Y

Y,N(default). If this filter set to Y, it allows to use additional filter described below.

Select Sector

selectSector

IND

IND (Individual) or ALL (default)
Available if selectView = 'SECTOR_VIEW'

Sector ID

sectorID

TEST1

Available if selectView = 'SECTOR_VIEW' and selectSector = 'IND'

Sector

sector

TEST2

Available if selectView = 'SECTOR_VIEW' and selectSector = 'IND'

Select Share Class

selectShareClass

IND

IND, ALL (default)
Available if selectView = 'CLASS_VIEW'

Share Class

shareClass

A

Available if selectView = “CLASS_VIEW and selectShareClass = 'IND'

Detailed Class View

detailedClassView

Y

Available if selectView = 'CLASS_VIEW'

Report Date

reportDate

2016-01-01

Available if reportType = 'ACCTGDT' or missing

Month End Date

monthEndDate

2016-01-02

Available if reportType = 'MONTHDT'

Filter Security By

filterSecurityBy

XREF

'XREF' (default Xref ID and Type) or 'NAME' (Issue Name) or 'PRIMARY' (Primary Asset ID)

Issue Name

issuename

TEST_ISSUE_NAME

Available if filterSecurityBy = 'NAME'

Xref ID

xrefid

TestXrefID

Available if filterSecurityBy = ‘XREF’

Xref ID Type

xrefidtype

TestXrefType

Available if filterSecurityBy = ‘XREF’

Primary Asset ID

primaryassetid

999658921

Available if filterSecurityBy = ‘PRIMARY’

Fair Value Comparison

FAIRVALUECOMPARISONEXTRACT

Accounting Basis

accountingBasis

USTAX

Uses primary basis if empty

Report Type

reportType

MONTHDT

Month End Date – MONTHDT

Accounting Date - ACCTGDT

Next Day Open Source Name

nextDayOpenSourceName

IDC

Sources lookup

Next Business Day

nextBusinessDay

02.01.2016

Next Day Open Price Type

nextDayOpenPriceType

Px Ask

Price Field Descriptions lookup

Next Day Open Pricing Exchange

nextOpenPricingExchange

Nasdaq Stock Market

List Exchanges lookup

Report Filters

reportFilters

Y

Y or N

Show MEMO Accounts

showMEMOAccounts

Y

Y or N

Show Asset Level Details

showAssetLevelDetails

Y

Y or N

Filter Security By

filterSecurityBy

XREF

Security Cross Reference – XREF - enables xrefid and xrefidtype filters

Issue Name – NAME - enables issuename filter

Primary Asset ID - PRIMARY - enables primaryassetid filter

Issue Name

issuename

Issue Name Test

Available if filterSecurityBy = Issue Name

Long Short

longShort

L

L or S

Asset Currency

assetCurrency

USD

Currency Code Short Name, “Code Value” lookup

Issue Country

issueCountry

US

Country Code Short Name, “Code Value” lookup

GL Activity

GLACTIVITYEXTRACT

From GL Account

FromGLAccount

TEST1

estar.estar_ledger_account.ledger_acct

GL Basic

GLBasic

TEST2

estar.estar_ledger_account.acct_basis

GL Class

GLClass

TEST3

estar.estar_ledger_account.class

GL Date Type

GLDateType

ACCTGDT

‘POSTDT’ or ‘ACCTGDT’ or ‘MONTHDT’

GL From Date

GLFromDate

2015-05-10

if GLDateType=‘POSTDT’ then (ESTAR.ESTAR_LEDGER_POST.POST_DT)
if GLDateType=‘ACCTGDT’ then (ESTAR.ESTAR_LEDGER_POST.ACCT_DT)
if GLDateType=‘MONTHDT’ then (ESTAR.ESTAR_LEDGER_POST.MONTH_END_DATE)

GL To Date

GLToDate

2015-05-11

GL Sector

GLSector

TEST6

Include ALLOCATE Events

IncludeALLOCATEEvents

N

Filter for the db field ESTAR.ESTAR_LEDGER_POST.MESSAGE_TYPE = or <> 'ALLOCATE'
Possible values:
- 'N' - will be included only records with ESTAR.ESTAR_LEDGER_POST.MESSAGE_TYPE <> 'ALLOCATE')
- 'Y' - default, all values of MESSAGE_TYPE will be included

Include MEMO Accounts

IncludeMEMOAccounts

N

Filter for the db field RULESDBO.CHART_OF_ACCTS.GL_SUB_ACCOUNT = or <> '6(MEMO)'.
Possible values:
- 'N' - will be included only records with RULESDBO.CHART_OF_ACCTS.GL_SUB_ACCOUNT <> '6(MEMO)'
- 'Y' - default, all values of GL_SUB_ACCOUNT will be included

Net Rollback Replay Entries

NetRollbackReplayEntries

Y

If set to 'Y', the records of ESTAR_LEGDER_LOG table will be grouped. The values of AMOUNT field in the records will be summarized with the grouping
by set of fields: POST_ID + ACCOUNT_ID + DEBIT_CREDIT + ACCT_DT.
Possible values:
- 'N' - default, grouping is not used
- 'Y' - grouping is used

To GL Account

ToGLAccount

TEST7

estar.estar_ledger_account.ledger_acct

Open Rec Pay Multi

OPENRECPAYMULTIEXTRACT

Settle Currency

settlecurrency

USD

Currency filter

Broker Name

brokerName

TEST1

Broker Code

brokerCode

TEST2

Target Event Id

targetEventId

TEST3

Issue Name

issuename

TEST_ISSUE_NAME

Event Type

eventType

Buy

'Buy', 'Sell', 'Spot', 'Coupon', 'Cashdiv'

Trade Ticket Number

tradeTicketNumber

TEST4

category

TRADE

'B' (default), 'INCOME', 'TRADE'

Unapproved Variation Margin

UNAPPROVEDVARMARGINEXTRACT

Accounting Basis

accountingBasis

USTAX

Base Currency

baseCurrency

USD

Currency filter

Long Short Indicator

longShortIndicator

L

'L', 'S'

Report Type

reportType

ACCTGDT

'ACCTGDT' (default), 'MONTHDT'

Consolidated Earned Income

CONSEARNEDINCOMEEXTRACT

Report Type

reportType

ACCTGDT

'ACCTGDT' (default), 'MONTHDT'

Report Period

reportPeriod

DR

'DA' (default) - Daily Activity
'DR' - Date Range
'FYTD' - FiscalYearToDate
'CYTD' - CalendarYearToDate
'MTD' - MonthToDate

Report Start Date

reportStartDate

2015-10-01

If reportPeriod = 'DR', default value: Today - 365 (1 year ago)

Report End Date

reportEndDate

2016-03-01

Default value: Today

Accounting Basis

accountingBasis

USTAX

Available if resolved value of Accounting Basis by Entity table is null

Portfolio currency

baseCurrency

USD

Currency filter
Available if Security Alias is not resolved by specified Security filters

Report Filters

reportFilters

Y

Y,N(default). If this filter set to Y, it allows to use additional filter described below.

Filter Security By

filterSecurityBy

XREF

'XREF' (default), 'NAME', 'PRIMARY'

Issue Name

issuename

TEST_ISSUE_NAME

Available if filterSecurityBy = 'NAME'

Primary Asset Id

primaryassetid

KFRK83092

Available if filterSecurityBy = 'PRIMARY'

Xreference Id

xrefid

KFRK83092

Available if filterSecurityBy = 'XREF'

Xreference Id Type

xrefidtype

CUSIP

Available if filterSecurityBy = 'XREF'

Asset Currency

localCurrency or assetCurrency

EUR

Currency filter
Available if Security Alias is not resolved by specified Security filters

Processing Security Type

processingsecuritytype

DERV

Security Type

securitytype

F5E

Investment Type

investmenttype

FWD

Issue Country

nraTaxCountry

US

Available if Security Alias is not resolved by specified Security filters

Long Short

longShortIndicator

L

'L', 'S'

Process Center

processCenter

MO

Roll-up Indicator

rollupIndicator

Y

'Y' - Roll-up Positions for Composite
'N' - Display Positions for Entities

Federal Taxable Indicator

taxableIndicator

Y

'Y', 'N'
Available if Security Alias is not resolved by specified Security filters

Government/Non-Government Indicator

governmentIndicator

Govt

'Govt', 'N'

Conversion Status

conversionStatus

TEST3

Unrealized Gain/Loss on Recpay

urglRecpayIndicator

N

'Y', 'N'

Unsettled Transactions

UNSETTLEDTRANSACTIONSEXTRACT

Report Type

reportType

MONTHDT

'ACCTGDT' (default) - Accounting Date
'MONTHDT' - Month End Date
'POSTDT' - Process Date
'SETTLEDT' - Settle Date
'TRADEDT' - Trade Date

Report Date

toaccountingdate
tomonthendate
topostdate
totradedate
tosettlementdate

2020-01-01

End Date. Value should correspond with the reportType Value parameter. Default: '2098-12-31'

Portfolio Currency

baseCurrency

USD

Currency filter

Accounting Basis

accountingBasis

USTAX

Long Short

longShortIndicator

L

'L', 'S'

Cash Category

cashCategory

TEST1

Event Reason

eventReason

TEST2

Cash Event Type

cashEventType

DISB

'RECPT' - Receipt
'DISB' - Disbursement

Share Class

shareClass

A

Asset Currency

localCurrency

USD

Currency filter

Include/Exclude Shareholder Activity

includeCorpAction

N

'Y' (default) - Include
'N' - Exclude

Include/Exclude Forward Transactions

includeFwdTransactions

N

'Y' (default) - Include
'N' - Exclude

Accounting Cash Journal

CASHJOURNALEXTRACT

Report View

reportView

TRADED

'SETTLED' or 'S'(default)
'TRADED' or 'T'

Select View

selectView

SECTOR

'TOTAL FUND' (default)
'SECTOR'

Report Type

reportType

Accounting Date

'ACCTGDT' or 'Accounting Date' (default)
'MONTHDT' or 'Month End Date'
'POSTDT' or 'Post Date'
'SETTLEDT' or 'Settlement Date'
'TRADEDT' or 'Trade Date'

Report Period

reportPeriod

Accounting Date

'Daily Activity' or 'DA' (default)
'Date Range' or 'DR'
'Fiscal Year to Date' or 'FYTD'
'Life to Date' or 'LTD'
'Calendar Year to Date' or 'CYTD'
'Inception to Date' or 'ITD'
'Month to Date' or 'MTD'

Report Start Date

fromdate

2016-01-02

Report End Date

todate

2016-01-03

Portfolio Currency

baseCurrency

USD

Currency filter

Report Filters

reportFilters

Y

Y,N(default). If this filter set to Y, it allows to use additional filter described below.

Filter Security By

filterSecurityBy

XREF

'XREF' (default), 'NAME', 'PRIMARY'

Issue Name

issuename

TEST_ISSUE_NAME

Available if filterSecurityBy = 'NAME'

Primary Asset Id

primaryassetid

KFRK83092

Available if filterSecurityBy = 'PRIMARY'

Xreference Id

xrefid

KFRK83092

Available if filterSecurityBy = 'XREF'

Xreference Id Type

xrefidtype

CUSIP

Available if filterSecurityBy = 'XREF'

Asset Currency

localCurrency

USD

Currency filter

Processing Security Type

processingsecuritytype

DERV

Security Type

securitytype

F5E

Investment Type

investmenttype

FWD

Issue Country

nraTaxCountry

TEST1

Available if Security Alias is not resolved by specified Security filters

Long Short Indicator

longShortIndicator

L

'L', 'S'

Include Cancels

includeCancels

Y

'Y','N' (default)

Display Zero

displayZero

Y

'Y' (default),'N'

Event Type

eventType

TAXSPINR

Process Code Translation

processCodeTranslation

Y

'Y' (default),'N'

Code Map Name

codeMapName

STAR REPORT

‘STAR REPORT’ (default), N

Working Trial Balance

WORKINGTRIALBALANCEEXTRACT

Accounting Basis

accountingBasis

USTAX

Use primary basis if empty

General Ledger Currency

generalLedgerCurrency

USD

Defaults to base Currency if null/empty

Select View

selectView

Total Fund

Valid Values:

Sector – SECTOR_VIEW

Class – CLASS_VIEW

Total Fund – COMPLETE_VIEW

Select Sector

selectSector

Individual

Available if selectView = ‘Sector’

Valid Values:

All (default) - ALL

Individual - IND

Sector ID

sectorID

TEST1

Available if selectView = ‘Sector’ and selectSector = ‘Individual’

SectorID lookup

Sector

TEST1 Name

Available if selectView = ‘Sector’ and selectSecor = ‘Individual’

Sector Name lookup

Select Share Class

selectShareClass

Individual

Available if selectView = ‘Class’

Valid Values:

Individual - IND

All (default) - ALL

Share Class

shareClass

D

Available if selectView = ‘Class’ and shareClassView = ‘Individual’

Share Class lookup

Detailed Share Class

detailedClassView

Y

Available if selectView – ‘Class’ and selectShareClass = ‘Individual’

Valid Values:

Y – Yes

N – No

Report Type

reportType

Accounting Date

Valid Values

Month End Date – MONTHDT (enables month end date filter for this extract) Accounting Date - ACCTGDT (enables accounting date filter for this extract)

Profile

ledgerProfile

DEFAULT_TRIAL_BALANCE_TF

User Defined Profiles are available. Core Profiles are:

DEFAULT_TRIAL_BALANCE_TF - use with selectView = 'Total Fund' or ‘Complete’
DEFAULT_TRIAL_BALANCE_SECTOR - use with selectView = 'Sector'
DEFAULT_TRIAL_BALANCE_CLASS - use with selectView = 'Class' and detailedClassView = 'N'
DEFAULT_TB_CLASS_DETAIL - use with selectView = 'Class' and detailedClassView = 'Y'

Any client specific profile – can be at the Total Fund, Class or Sector

Report Filters

reportFilters

Y

Valid Values

Y - Yes

N – No

Show MEMO Accounts

showMEMOAccounts

Y

Valid Values

Y - Yes

N – No

Show Asset Level Details

showAssetLevelDetails

Y

Valid Values

Y - Yes

N – No

Filter Security By

filterSecurityBy

Security Cross Reference

Valid Values:

Security Cross Reference – XREF

Issue Name – NAME

Primary Asset ID - PRIMARY

Xref ID

xrefid

Test Xref ID

Available if filterSecurityBy = Security Cross Reference

Xref ID Type

xrefidtype

Test Xref ID_Type_Type

Available if filterSecurityBy = Security Cross Reference

Primary Asset ID

primaryassetid

Primary Asset Id Test

Available if filterSecurityBy = Primary Asset ID

Issue Name

issuename

Issue Name Test

Available if filterSecurityBy = Issue Name

Include/Exclude Closeout Entries

includeExcludeCloseoutEntries

Y

Valid Values:

Y - Yes

N - No

Traded Cash Activity

TRADEDCAEXTRACT

Accounting Basis

accountingBasis

GAAP

Filters by ACCT_BASIS field.
Values can be set in one of the following formats
- GAAP,USTAX - include values (GAAP,USTAX)
- I(GAAP,USTAX ) - include values (GAAP,USTAX)
- E(GAAP,USTAX ) - exclude values (GAAP,USTAX)
- L(%GAAP%) - include values LIKE (%GAAP%)

Use Primary Basis Only

UsePrimaryBasisOnly

Y

When set to Y, performs an additional join for the Accounting Basis DB table:

inner join RULESDBO.ENTITY_ACCT_BASIS on
(RULESDBO.ENTITY_ACCT_BASIS.PORTFOLIO_ACCT = ESTAR_TRADED_CASH_ACTIVITY.PORTFOLIO_ACCT
and RULESDBO.ENTITY_ACCT_BASIS.ACCT_BASIS = ESTAR_TRADED_CASH_ACTIVITY.ACCT_BASIS
and RULESDBO.ENTITY_ACCT_BASIS.PRIMARY_BASIS_INDICATOR = 'Y')

Settled Cash Activity

SETTLEDCAEXTRACT

Accounting Basis

accountingBasis

GAAP

Filters by ACCT_BASIS field.
Values can be set in one of the following formats
- GAAP,USTAX - include values (GAAP,USTAX)
- I(GAAP,USTAX ) - include values (GAAP,USTAX)
- E(GAAP,USTAX ) - exclude values (GAAP,USTAX)
- L(%GAAP%) - include values LIKE (%GAAP%)

Use Primary Basis Only

UsePrimaryBasisOnly

Y

When set to Y, performs an additional join for the Accounting Basis DB table:

inner join RULESDBO.ENTITY_ACCT_BASIS on
(RULESDBO.ENTITY_ACCT_BASIS.PORTFOLIO_ACCT = ESTAR_SETTLED_CASH_ACTIVITY.PORTFOLIO_ACCT
and RULESDBO.ENTITY_ACCT_BASIS.ACCT_BASIS = ESTAR_SETTLED_CASH_ACTIVITY.ACCT_BASIS
and RULESDBO.ENTITY_ACCT_BASIS.PRIMARY_BASIS_INDICATOR = 'Y')

Pricing Report

PRICINGREPORTEXTRACT

Include Zero Balances

IncludeZeroBalances

N

‘Y’ (default) - no filter for Cash records
‘N’ - filters out the security types that are not priced

Zero Balance Switch

ZeroBalanceSwitch

Cash

Switches the Zero Balance filter between:

1) Cash (default value)
Filter is used in the full form:
NOT (SECURITYDBO.SECURITY_MASTER.INVESTMENT_TYPE = 'CASH'
AND HOLDINGDBO.POSITION_DETAIL.SHARE_PAR_VALUE = 0
AND HOLDINGDBO.POSITION_DETAIL.BOOK_VALUE = 0)

2) ParBookValue
NOT (HOLDINGDBO.POSITION_DETAIL.SHARE_PAR_VALUE = 0
AND HOLDINGDBO.POSITION_DETAIL.BOOK_VALUE = 0)

3) ShareParValue
NOT (HOLDINGDBO.POSITION_DETAIL.SHARE_PAR_VALUE = 0)

Utilize Price Exchange Market Date Source

UsePriceExchangeMarketDateSource

Y

Provides the ability to retrieve the Market Date from a secondary table and calculate the Market Days Stale via RTR when the UsePriceExchangeMarketDateSource is set to Y.

When set to Y, supports when copying over prices from a prior day and manual entries that do not composite the market date on the main pricing table when the key is unchanged.

When set to Y, the Market Date logic is based upon the PRIOR_BEST_INDICATOR. When the PRIOR_BEST_INDICATOR has a value of Y in the PRICE_RULE_SECURITIES table or when the PRIOR_BEST_INDICATOR is null and the PRICE_EXCHANGE.MARKET_DATE is null, then the PRICE_RULE_SECURITIES.MARKET_DATE value and the Market Days Stale is retrieved from the PRICE_RULE_SECURITIES.MARKET_DAYS_STALE as well. If the PRICE_EXCHANGE.MARKET_DATE is populated, then it is used to reflect the Market Date value and the Market Days Stale is also calculated using the PRICE_EXCHANGE.MARKET_DATE.

The calculated Market Days Stale uses the revised Market Date excluding weekend days.

Valuation Source

ValuationSource

DAILY

Allows to choose pricing table to extract from. When set to MONTHLY, query will select from ESTAR.MONTHLY_PORTFOLIO_VALUATION table. By default it set to DAILY, and extract will be done from ESTAR.ESTAR_PORTFOLIO_VALUATION table. Available as a global parameter for w_config_custom.inc - W_PRICINGREPORTEXTRACT_VALUATION_SRC

RDC Pricing Report

PRICINGRDCREPORTEXTRACT

Include Zero Balances

IncludeZeroBalances

N

‘Y’ (default) - no filter for Cash records
‘N’ - filters out the security types that are not priced

Zero Balance Switch

ZeroBalanceSwitch

Cash

Switches the Zero Balance filter between:

1) Cash (default value)
Filter is used in the full form:
NOT (SECURITYDBO.SECURITY_MASTER.INVESTMENT_TYPE = 'CASH'
AND HOLDINGDBO.POSITION_DETAIL.SHARE_PAR_VALUE = 0
AND HOLDINGDBO.POSITION_DETAIL.BOOK_VALUE = 0)

2) ParBookValue
NOT (HOLDINGDBO.POSITION_DETAIL.SHARE_PAR_VALUE = 0
AND HOLDINGDBO.POSITION_DETAIL.BOOK_VALUE = 0)

3) ShareParValue
NOT (HOLDINGDBO.POSITION_DETAIL.SHARE_PAR_VALUE = 0)

Utilize Price Exchange Market Date Source

UsePriceExchangeMarketDateSource

Y

Provides the ability to retrieve the Market Date from a secondary table and calculate the Market Days Stale via RTR when the UsePriceExchangeMarketDateSource is set to Y.

When set to Y, supports when copying over prices from a prior day and manual entries that do not composite the market date on the main pricing table when the key is unchanged.

When set to Y, the Market Date logic is based upon the PRIOR_BEST_INDICATOR. When the PRIOR_BEST_INDICATOR has a value of Y in the PRICE_RULE_SECURITIES table or when the PRIOR_BEST_INDICATOR is null and the PRICE_EXCHANGE.MARKET_DATE is null, then the PRICE_RULE_SECURITIES.MARKET_DATE value and the Market Days Stale is retrieved from the PRICE_RULE_SECURITIES.MARKET_DAYS_STALE as well. If the PRICE_EXCHANGE.MARKET_DATE is populated, then it is used to reflect the Market Date value and the Market Days Stale is also calculated using the PRICE_EXCHANGE.MARKET_DATE.

The calculated Market Days Stale uses the revised Market Date excluding weekend days.

User Administration Objects

User
User Group

USEREXTRACT
USERGROUPEXTRACT

User Id

userid

USER NAME

Filter for the db field PACE_USERS.USERNAME

Business Group Name

businessgroupname

BUS GROUP NAME

Filter for the db field PACE_USER_GROUPS.GROUP_NAME

User Group Name

usergroupname

USER GROUP NAME

Filter for the db field STARSEC_USER_GROUP.STAR_GROUP_NAME

Application Group Name

applicationgroupname

APP GROUP NAME

Center Role Name

centerrolename

CENTER ROLE NAME

Filter for the db field EGL_CENTER_ROLE.CENTER_ROLE_NAME

Account State

accountstate

U, D or L

Filter for the db field PACE_USERS.ACCOUNT_STATE

Set Processing Options Value

SetProcessingOptionsValue

APPLY_NO_RULE_password

Set this value to get processingOptions element in extracted data

		<taskParameter>
            <name>SetProcessingOptionsValue</name>
            <dataType>S</dataType>
            <value>APPLY_NO_RULE_password</value>
        </taskParameter>

Entitlement

USERENTITLEMENTEXTRACT

Property Name

PropertyName

Available values of PROPERTY_NAME:

CLOSEIEONLOGOFF (Close Client Browser on Log Off)
SHOWINACCESSIBLEACTIONS (Show Inaccessible Actions)
USERSESSIONSDEFAULTACCESS (Show “User Sessions”)
OPENMENUINNEWWINDOW (Open Menu in a New Window)
SHOW_SERVER_IP_IN_TITLE (Show Web Server in the Window Title)
SHOW_SERVER_STATUS (Show Web Server in the Windows Title)
MAXATTEMPTS (Maximum Unsuccessful Attempts Count)
IDLETIME (Idle Period (in Minutes))
MINUSERNAMELENGTH (Minimum User Name Length)

Several names can be selected by specifying comma-separated values:

MINUSERNAMELENGTH,SHOW_SERVER_IP_IN_TITLE,SHOW_SERVER_STATUS

Internal Objects

Control Center Event Log

CONTROLCENTEREVENTLOGEXTRACT

Event Group Name

eventgroupname

CC-ME-S2P-BATCH-POSITION

Event Task Id

eventtaskid

35

Active Flag

activeflag

'1' = YES; '0' = NO

Completed Flag

completedflag

Y or N

Core Group

coregroup

Y or N

Statistics Category

statisticcategory

GLOBAL

Statistics Name

statisticname

ME OVERNIGHT PROCESSES

Statistics Type

statistictype

STATUS

Business Processing Group

businessprocessinggroup

OLEH1

S2P Reporting Objects

Spd Delta Trigger Log

SPDDELTATRIGGERLOGEXTRACT

Min Accounting Date Flag

minAccountingDateFlag

Y, P or N

if the minAccountingDateFlag is set to P, the minAccountingDateFlag filter selects the minimum accounting date from the post_date value. The valid values are P for Post Date and Y for Accounting Date. Enable filtering by earliest accounting date