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.