Page Comparison

...

You can reinsert underlying records in batch mode (delete all the previously existing records before load with the following key: sec alias + underlying type)

Behavior

A) Reinsert Mode

If the incoming record contains a batch key:

1. Underlying records with sec_alias and underlying type related to the corresponding batchKey will be deleted
2. Underlying records from the incoming transaction will be loaded one by one (same order as they are positioned in the file)

In this case key for deletion is MAIN SEC ALIAS + UNDELYING TYPE
Second SMF alias is not used in the process of deletion.

B) If incoming Upsert Mode

To use this mode make sure the record contains batch key and processingOptions element contains is set to UNDERLYING_UPSERT_MODE:

1. Underlying records from the incoming transaction will be loaded one by one (same order as they are positioned in the file)

...

Required Structure of Data for Load

...

<referenceTransaction>
     <header>
          <batchKey>PRIMARY_ASSET_ID^PRIMARY_ASSET_ID_TYPE^UNDERLYING_TYPE</batchKey>
<processingOptions>batchUnderlyingReinsertMode</processingOptions>
          <objectType>UnderlyingSMF</objectType>
     </header>
     <underlyingSMF>
          …
          <beginDate>2018-07-10</beginDate>
          <endDate>2018-07-12</endDate>
     </underlyingSMF>
     <underlyingSMF>
          …
          <beginDate>2019-07-11</beginDate>
          <endDate>2019-07-13</endDate>
     </underlyingSMF>
<referenceTransaction>

Underlying SMF records inside each referenceTransaction should be sorted by the timeline, first going with the earliest begindate/enddate, last - with the latest begindate/enddate. Date logic will remain the same as in usual underlying upload and will not allow time periods overlapping.

Since we have several ways to resolve security, batch Batch key can be set in various ways based on the final design. Suggested structures for batch key:

...

as XREF_ID^XREF_TYPE^UNDERLYING_TYPE

...

 , where XREF_ID and XREF_TYPE are identifiers that should be used for resolution

Batch key identifiers will be used to define records for DELETE during batchUnderlyingReinsertMode.

Batch Mode Load Process

...

batch underlying reinsert mode.