In this page:
...
Custom Benchmark involves custom index logic which is dependent on certain component values stored on underlying (assigned) constituent entities. These values and assignments are stored in the RULESDBO.CUSTOM_INDEX_ATTRIBUTES table. The table keeps track of any changes to each custom entity by the EFFECTIVE_DATE field.
...
- If there is no match, it fails the record (batch) with an error message: “Entity and Security Relation not found”
- If there is a match, it populates Security_alias in the Custom_index_attr_detail table with the security_alias value obtained above.
Batch and Next Instance
The batch is a unique combination of the following fields:
- customBenchmark/effectiveDate = Effective_date in custom_index_attributes
- customBenchmark/entityId = Entity_ID in custom_index_attributes
- customBenchmark/entityDetail/entityId = Entity_Detail_Id in custom_index_attributes
As for example, a valid batch key would be:
Code Block | ||
---|---|---|
| ||
<batchKey>2016-12-12^BT153545^TB153545</batchKey> |
If there is a match, the interface looks to the value in PROCESS TYPE on the incoming record and:
- If PROCESS TYPE tag = ‘D’ or ‘DELETE’, the interface will delete all records in the database for the batch combination.
- If the PROCESS TYPE = 'IU' or ‘INSERT’ or ‘UPDATE’, and records exist for the same batch, the interface will remove records in the database and will re-process with the incoming records for the same batch combination
- If the PROCESS TYPE = 'IU' or ‘INSERT’ or ‘UPDATE’, and no records exist for the same batch, the interface will insert the records into the custom_index_attributes table.