Page Comparison

SEC_SHELL_RECORD_ONLY

W_SEC_SHELL_RECORD_ONLY

GenericSMF

By default, during initial load the tag 1257 (HISTORY ONLY) is not sent to the Stored Procedure even when it is populated in incoming file. As a result, the data is loaded into the master table fully.

The option allows load initial security in History mode, as a result only specific list of tags will be inserted into master table.

BATCH_BY_SCHEDULE_TYPE

-

GenericSMF (SMF MI)

By default, Schedule records are deleted by the key SRC_INTFC_INST + SECURITY_ALIAS via scripts DELETE_SCH_BATCH and DELETE_CPA_BATCH.

This option includes the scheduleType element into the key for the delete process from two tables: SECURITYDBO.SCHEDULE and TRADESDBO.CORP_ACT_HIST. It also maintains previously loaded records with different scheduleType types in the database.

The additional Key supported for delete is SRC_INTFC_INST + SECURITY_ALIAS + scheduleType

ISSUER_ROLE_GROUPING

-

GenericSMF (SMF MI)

Enables batch mode (also enables ISSUE_ROLE_UPSERT_MODE, USE_LATEST_START_DATE by default) .

ISSUE_ROLE_UPSERT_MODE

-

GenericSMF (SMF MI)

Prevents delete of existing records that preserves history about previous ownership

USE_LATEST_START_DATE

-

GenericSMF (SMF MI)

Finds the latest start date in the incoming message and uses it for each incoming record as the start date.

DIRECT_ISSUER_ROLE_OPTIONS

-

GenericSMF (SMF MI)

Counter-flag for ISSUER_ROLE_GROUPING, allows to set options directly.

ISSUER_ROLE_PROCESSING_TYPE

-

GenericSMF (SMF MI)

Set as ISSUER_ROLE_PROCESSING_TYPE_I()__PROCESSING_TYPE where in I() you should set Issuer Role types which you want to be loaded in certain mode.

APPLY_DIRECT_MAPPING

-

GenericSMF

This option allows to not replace empty value in one model by not empty value from another model. Only for SP mode. (accountingValidationFlag = 'N')

For now, this option works with:

• FixedIncomeModel/delayDays and MBSModel/delayDays

DISABLE_HOLDINGS_EDITCHECK

W_SEC_DISABLE_HOLDINGS_EDITCHECK

GenericSMF

If the PACE Holding exists for the Security record, then the fields: Asset Currency/tag85, Quantity Type/tag12, Price Multiplier/tag18 and Quantity Scale/tag19 may not be updated for this Security and the Error is shown.

This option allows to turn off Error and show Warning instead in case of existing PACE Holdings