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 may be missing since this field is calculated and gets either PRIMARY or SECONDARY value.