...
- Start preprocessing only if Significant Cash Flow Processing is enabled.
- Check underlying Field Rule for commit mapping in Modified Dietz and Internal Rate of Return fields.
Write the details to the Significant Cash Flow Processing log. If the required fields do not have commit mappings set:
- End preprocessing.
- Update Commit Journal. - Check underlying Modified Dietz and Internal Rate of Return fields to ensure they use the same weighting method as the profile.
Write the details to Significant Cash Flow Processing log. If the required fields do not have the same weighting method:
- End preprocessing.
- Update Commit Journal. - Retrieve holding data for the report begin date.
- Check underlying grouping rule to ensure that grouping level selected in the profile still exists.
Write the details to Significant Cash Flow Processing log. If the required field is present in the underlying Grouping Rule, aggregate the market values and cash flows by effective date and selected grouping field. This includes fields above the selected field in the Grouping Rule.
For example, suppose the underlying Grouping Rule is ENTITY ID, INVESTMENT TYPE, and COUNTRY. If you select INVESTMENT TYPE as the Significant Cash Flow group, the cash flows and market values are summed by EFFECTIVE DATE, ENTITY ID, and INVESTMENT TYPE.
If the required field is not in underlying Grouping Rule:
- End preprocessing.
- Update Commit Journal. - Calculate threshold level by multiplying the threshold market value field by the threshold percentage level.
Write the details to Significant Cash Flow Processing log. - Compare each aggregated cash flow to the threshold level.
- If the cash flow exceeds the threshold, break the period. Note the prior period end date:
- If the Beginning of Day or Middle of Day assumption is used and the prior day is a weekend, set Sunday as period end date and use Friday as the valuation date.
- If the Beginning of Day or Middle of Day assumption is used and the prior day is a monthendmonth end, do not create a sub-period.
- If the Beginning of Day or Middle of Day assumption is used and the prior day is a Sunday, and Saturday is a month-end, set Sunday as period end date and use Saturday as valuation date. Note the new period begin date and write the details to Significant Cash Flow Processing log.
- Retrieve holding data for required date. If holding data does not exist, write the details to Significant Cash Flow Processing log and advance to next cash flow without recalculating the threshold level. If holding data exists, write the details to Significant Cash Flow Processing log, recalculate threshold level unless the option Use static threshold is enabled, and advance to the next cash flow.
- If the cash flow does not exceed the threshold, write the details to Significant Cash Flow Processing log. - End the preprocessing.
If all required valuations are present, start stage 2, sub-period calculation and commit. If all required valuations are not present, end report execution, but do not fail the report, give access to the Significant Cash Flow Processing log through the report Diagnostics tab, and update the Commit Journal.
...