Security Default Object

For Security Default EagleML object:

Processing Details

Security Default interface allows to load and extract data from 

  • SECURITYDBO.SECURITY_DEFAULT table

The SP for load is

  • ESTAR .PKG_RATES .INS_UPD_SEC_DEFAULT

This SP is available for both insert and update based on in_event_type:

  • ADD_SEC_DEFAULT

  • CHG_SEC_DEFAULT

In order to load into security default table the following panels can be used:

  • eagle/star/reference/pan-adefaulttype.htm – to add records

  • eagle/star/reference/pan-cgdefaulttype.htm – to update records

  • eagle/star/reference/pan-deldefaulttype.htm – to delete records

To delete a record, full key is expected:

SECURITY + SECURITY_TYPE (based on what is presented) + COSTING_RULE + ACCT_BASIS + BEGIN_DATE

If the incoming file does not contain the full set of required fields, deleting is not performed and a warning is thrown. Only COSTING_RULE is not required as this field is calculated and gets either PRIMARY or SECONDARY value.