For Security Default EagleML object:
Child pages (Children Display)
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.