Constituent Insertion

Eagle only stores one set of security return records per batch (ENTITY+DATE+FREQUENCY CODE+SOURCE). As a result, security level returns will always be posted to a PERF_SUMMARY record where DICTIONARY_ID = 0. This is because no matter how the security returns are rolled up, they should not change.

All Constituent records (SECURITY_ALIAS != "0") are loaded to the PERFORM.PERF_SUMMARY and PERFORM.PERF_SEC_RETURNS tables with the following values:

  • PERF_SUMMARY.DICTIONARY_ID = "NULL"

  • PERF_SUMMARY.PERF_SUMMARY_TYPE = "S"

  • PERF_SEC_RETURNS.PERF_ROLLUP_RETURNS_ID = "0"

The procedure will then proceed to the Perf Sec Rollup Relation section.