Date filters without Held Mode: There is no "EffectiveDate" field in the composite SMF table (SECURITY_MASTER). This means that the "EffectiveDate" filter will be ignored if you extract the SMF from the composite table. If you extract the SMF from the history table (historyonlyflag parameter is set to Y), the "EffectiveDate" filter will be used in the following way: Code Block |
---|
SECMASTER_HISTORY.EFFECTIVE_DATE >= TO_DATE([effective date filter value], 'YYYY-MM-DD') |
This means that all SMF records from the history table with EFFECTIVE_DATE value greater than or equal to the effective date filter value will be extracted. The "updatedate" filter can be used to extract SMF records from the composite or history tables in the following way: Code Block |
---|
[Composite or History table].UPDATE_DATE >= TO_DATE([update date filter value], 'YYYY-MM-DD') |
This means that all SMF records from the composite or history table with the UPDATE_DATE value greater than or equal to the update date filter value will be extracted. Date filters with Held Mode: Effective Date, which will be used as a restriction in the search for SMFs from Position and Cash Activity Sources, the value for Held mode is set by the following steps: If parameter "ProcessCenter" is used (entityselectiontype=ProcessCenter, entityselectionvalue=[Process Center filter value]), then the value of "effectivedate" filter will be found from the RULESDBO.PROCESS_CENTER table, for example: Code Block |
---|
select to_char(pc.curr_dt,'yyyy-mm-dd') EFFECTIVE_DATE
from RULESDBO.PROCESS_CENTER pc
where pc.process_center = [Process Center filter value] |
To use two Entity filters, the following parameters are available:
entityselectiontype / entityselectionvalue entityselectiontype2 / entityselectionvalue2 If we want to use ProcessCenter and EntityList filters together, we can use following structure: Code Block |
---|
| <taskParameter>
<name>entityselectiontype</name>
<dataType>S</dataType>
<value>EntityList</value>
</taskParameter>
<taskParameter>
<name>entityselectionvalue</name>
<dataType>S</dataType>
<value>SCPAREN3</value>
</taskParameter>
<taskParameter>
<name>entityselectiontype2</name>
<dataType>S</dataType>
<value>ProcessCenter</value>
</taskParameter>
<taskParameter>
<name>entityselectionvalue2</name>
<dataType>S</dataType>
<value>US</value>
</taskParameter> |
Order of filters is not important. "entityselectiontype2" parameter can be used for both, ProcessCenter or EntityList as follows:
|