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 13 Current »

Entity filters are used to define an entity (portfolio, fund). You need two task parameters to configure such a filter:

The following two parameters take a limited set of values:

entityselectiontype - defines the mode for the filter

Note

Only one mode can be selected at a time, so you cannot define several values for entityselectiontype

  • entityselectionvalue - defines the value for the filter

All parameters are formatted as “string” (<dataType>S</dataType>).

Filter Mode

Parameter Name

Example of Value

Comments

ProcessCenterentityselectiontypeProcessCenterConstant value
entityselectionvalueABC“PROCESS_CENTER” field value from “RULESDBO.ENTITY_STAR_PROCESSING” DB table
EntityListentityselectiontypeEntityList

Constant value

Default Entity List mode. Stored procedure will be used to resolve Entity list (both for dynamic and static).

Dynamic entity lists are defined with tables with names different from ‘‘ENTITY*’.
For example: RULESDBO.FUND, RULESDBO.COMPOSITE_ENTITY etc.

entityselectionvalueIQ71048

“ENTITY_ID” field value from “RULESDBO.ENTITY_LIST” DB table

DynamicPortfolioListentityselectiontypeDynamicPortfolioList

Constant value

Enhanced Entity List mode. Dynamic query will be used to resolve a dynamic Entity list. Static Entity list in this mode will be resolved by the Stored procedure (as in default mode).

entityselectionvalueIQ71048“ENTITY_ID” field value
EntityIDentityselectiontypeEntityIDConstant value
entityselectionvalueIQ71048,DM89202“ENTITY_ID” field value from “RULESDBO.ENTITY” DB table
EntityCompositeentityselectiontypeEntityCompositeConstant value
entityselectionvalueIQ71048,DM89202“ENTITY_ID” field value from “RULESDBO.ENTITY_DETAIL” DB table
EntityXrefIdentityselectiontypeEntityXrefIdConstant value
entityselectionvalueIQ71048,DM89202“XREF_ACCOUNT_ID” field value from “RULESDBO.ENTITY_XREFERENCE” DB table
EntityXrefTypeEntityXrefTypeOTHER,COPER“XREF_ACCOUNT_ID_TYPE” field value from “RULESDBO.ENTITY_XREFERENCE” DB table
Note: Works only with EntityXrefId filter
User GroupsusergroupsEQCSCS,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%)


DynamicExpressionentityselectiontypeDynamicExpressionConstant value
entityselectionvaluex.ENTITY_ID like &apos;SOLME%&apos;It will be added into ‘WHERE’ section with ‘AND’ connector.
CashEntityIDentityselectiontypeCashEntityIDConstant value
entityselectionvalueIQ71048,DM89202“PORTFOLIO_ACCT” field value from “ESTAR.ESTAR_CASH_PROJECTION” DB table
CashEntityNameentityselectiontypeCashEntityNameConstant value
entityselectionvalueIQ71048,DM89202“ENTITY_NAME” field value from “ESTAR.ESTAR_CASH_PROJECTION_DETAILS” DB table
CashEntityTypeentityselectiontypeCashEntityTypeConstant value
entityselectionvaluePORT“ENTITY_TYPE” field value from “ESTAR.ESTAR_CASH_PROJECTION_DETAILS” DB table

There is an additional parameter available for EntityID, EntityComposite, EntityList, ProcessCenter, EntityXrefId filters - TraverseHierarchy flag. It enables additional logic to perform a deeper search thru the hierarchy of entities. See the Entity Filter with TraverseHierarchy Parameter page for more details.

Accounting SP Based Extract Filter Logic Specifics for Entity Filter

Read more on Accounting SP Based Extracts Filter Logic Specifics

Example: Entity List Filter

<taskParameter>
    <name>entityselectiontype</name>
    <dataType>S</dataType>
    <value>EntityList</value>
</taskParameter>
<taskParameter>
    <name>entityselectionvalue</name>
    <dataType>S</dataType>
    <value>FUNDS001</value>
</taskParameter>
  • No labels