Page Comparison

This is also true for for Held Cash Activity Source. If Held Cash Activity Source is empty, then the Held Cash Activity SQL query will not be executed. If Held Cash Activity Source parameter is set (for example: heldcashsources = CASHTEST), then all cash activities with source = CASHTEST will be extracted.

Held Corporate Action Source is not used.

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:

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:

[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
  language xml
  <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:

• • If the value of ProcessCenter parameter is incorrect, then the value of "effectivedate" filter will be set as null.

  • If ProcessCenter parameter is not used and "heldeffectivedate" filter value exists in RTR, then "heldeffectivedate" filter value will be used for filtering by EFFECTIVE_DATE field, for example:

    Panel
    HOLDINGDBO.POSITION.EFFECTIVE_DATE = to_date([held effective date filter value],'yyyy-mm-dd') – for positions CASHDBO.CASH_ACTIVITY.ACCOUNTING_DATE >= to_date('2015-11-25','yyyy-mm-dd') – for cash activity

    
    

  • If ProcessCenter parameter is not used and "heldeffectivedate" filter value does not exist in RTR, then the value of "effectivedate" filter will be found as MAX of EFFECTIVE_DATE in the POSITION table. Conditions used in this query are: Date filter for UpdateDate, HeldPositionSource, and Entitylist.

• If we set only "effectivedate" filter value, then following SQL restriction will be added:
  

  
  

  Code Block
  SECMASTER_HISTORY.EFFECTIVE_DATE = TO_DATE([effective date filter value], 'YYYY-MM-DD')

  
  

• If we set only "fromeffectivedate" filter value, then following SQL restriction will be added:
  

  
  

  Code Block
  SECMASTER_HISTORY.EFFECTIVE_DATE >= TO_DATE([from effective date filter value], 'YYYY-MM-DD')

  
  

• If we set only "toeffectivedate" filter value, then following SQL restriction will be added:
  

  
  

  Code Block
  SECMASTER_HISTORY.EFFECTIVE_DATE <= TO_DATE([to effective date filter value], 'YYYY-MM-DD')

  
  

• If we set "fromeffectivedate" and "toeffectivedate" filter values, then  following SQL restriction will be added:
  

  
  

  Code Block
  SECMASTER_HISTORY.EFFECTIVE_DATE >= TO_DATE([from effective date filter value], 'YYYY-MM-DD')

  
  

  AND
  

  Code Block
  SECMASTER_HISTORY.EFFECTIVE_DATE <= TO_DATE([to effective date filter value], 'YYYY-MM-DD')