When tag 1081 is not supplied (or NULL), the Eagle Accounting validations are applied via the core security panels as described in the data maps following in this Section for each security type. When tag 1081 is NONE, you can load SMF data without satisfying core edits and you can include the additional fields shown below. When tag 1237 is HISTORY_ONLY, you can restrict updates to only the security history tables.
Note
For change processing which bypasses the Eagle Accounting core validations, such as records loaded for use with Performance Measurement, you must add tag 1081 to the record with the value NONE. The following fields are the only required fields when using this option:
- Validation level (tag 1081) as NONE
- Source Name (tag 1102)
- Effective Date (tag 1109)
- Processing Security Type (tag 3931)
- Primary Asset ID (tag 14)
- Primary Asset ID Type (tag 1432)
- Issue Name (tag 961)
The following table describes the optional data fields for SMF related information.
Tag # – Tag Name | Required/ Optional | Data Type | Field Name | Table Name |
|---|---|---|---|---|
2504 – Aggregate bond – 1st level | Optional | VARCHAR2(60) | AGG_BOND_L1 | SECMASTER_DETAIL_EXT |
2505 – Aggregate bond – 2nd level | Optional | CHAR | AGG_BOND_L2 | SECMASTER_DETAIL_EXT |
2506 – Aggregate bond – 3rd level | Optional | CHAR | AGG_BOND_L3 | SECMASTER_DETAIL_EXT |
2507 – Aggregate bond – 4th level | Optional | CHAR | AGG_BOND_L4 | SECMASTER_DETAIL_EXT |
12374 – Industry Classification Benchmark (ICB) sector – 3rd level | Optional | VARCHAR2 (12) | ICB_SECTOR | SECMASTER_DETAIL_EXT |
12376 – ICB subsector – lowest level | Optional | VARCHAR2 (12) | ICB_SUBSECTOR | SECMASTER_DETAIL_EXT |
12378 – ICB supersector – 2nd level | Optional | VARCHAR2 (12) | ICB_SUPERSECTOR | SECMASTER_DETAIL_EXT |
12380 – ICB industry – highest level | Optional | CHAR | ICB_INDUSTRY | SECMASTER_DETAIL_EXT |
1896 – User-defined field | Optional | VARCHAR2 (25) | USER_GROUP_SECTOR1 | SECURITY_MASTER |
1433 – User-defined field | Optional | VARCHAR2 (25) | USER_GROUP_SECTOR2 | SECURITY_MASTER |
1804 – User-defined field | Optional | VARCHAR2 (25) | USER_GROUP_SECTOR3 | SECURITY_MASTER |
1427 – User-defined field | Optional | VARCHAR2 (25) | USER_GROUP_SECTOR4 | SECURITY_MASTER |
1429 – User-defined field | Optional | VARCHAR2 (25) | USER_GROUP_SECTOR5 | SECURITY_MASTER |
1805 – User-defined field | Optional | VARCHAR2 (25) | USER_GROUP_SECTOR6 | SECURITY_MASTER |
1434 – User-defined field | Optional | VARCHAR2 (25) | USER_GROUP_SECTOR7 | SECURITY_MASTER |
1430 – User-defined field | Optional | VARCHAR2 (25) | USER_GROUP_SECTOR8 | SECURITY_MASTER |
1431 – User-defined field | Optional | VARCHAR2 (25) | USER_GROUP_SECTOR9 | SECURITY_MASTER |
1435 – User-defined field | Optional | VARCHAR2 (25) | USER_GROUP_SECTOR10 | SECURITY_MASTER |
1436 – User-defined field | Optional | VARCHAR2 (25) | USER_GROUP_SECTOR11 | SECURITY_MASTER |
1437 – User-defined field | Optional | VARCHAR2 (25) | USER_GROUP_SECTOR12 | SECURITY_MASTER |
1438 – User-defined field | Optional | VARCHAR2 (25) | USER_GROUP_SECTOR13 | SECURITY_MASTER |
1424 – User-defined field | Optional | VARCHAR2 (25) | USER_GROUP_SECTOR14 | SECURITY_MASTER |
1425 – User-defined field | Optional | VARCHAR2 (25) | USER_GROUP_SECTOR15 | SECURITY_MASTER |
1505 – User-defined field | Optional | VARCHAR2 (60) | USER_GROUP_CHAR1 | SECURITY_MASTER_DETAIL |
1506 – User-defined field | Optional | VARCHAR2 (60) | USER_GROUP_CHAR2 | SECURITY_MASTER_DETAIL |
1507 – User-defined field | Optional | VARCHAR2 (60) | USER_GROUP_CHAR3 | SECURITY_MASTER_DETAIL |
1508 – User-defined field | Optional | VARCHAR2 (60) | USER_GROUP_CHAR4 | SECURITY_MASTER_DETAIL |
1509 – User-defined field | Optional | VARCHAR2 (60) | USER_GROUP_CHAR5 | SECURITY_MASTER_DETAIL |
1510 – User-defined field | Optional | VARCHAR2 (60) | USER_GROUP_CHAR6 | SECURITY_MASTER_DETAIL |
1511 – User-defined field | Optional | VARCHAR2 (60) | USER_GROUP_CHAR7 | SECURITY_MASTER_DETAIL |
1512 – User-defined field | Optional | VARCHAR2 (60) | USER_GROUP_CHAR8 | SECURITY_MASTER_DETAIL |
1513 – User-defined field | Optional | VARCHAR2 (60) | USER_GROUP_CHAR9 | SECURITY_MASTER_DETAIL |
1514 – User-defined field | Optional | VARCHAR2 (60) | USER_GROUP_CHAR10 | SECURITY_MASTER_DETAIL |
1824 – User-defined field | Optional | VARCHAR2 (60) | USER_GROUP_CHAR11 | SECURITY_MASTER_DETAIL |
3462 – User-defined field | Optional | VARCHAR2 (60) | USER_GROUP_CHAR12 | SECURITY_MASTER_DETAIL |
3463 – User-defined field | Optional | VARCHAR2 (60) | USER_GROUP_CHAR13 | SECURITY_MASTER_DETAIL |
3464 – User-defined field | Optional | VARCHAR2 (60) | USER_GROUP_CHAR14 | SECURITY_MASTER_DETAIL |
3465 – User-defined field | Optional | VARCHAR2 (60) | USER_GROUP_CHAR15 | SECURITY_MASTER_DETAIL |
3466 – User-defined field | Optional | VARCHAR2 (60) | USER_GROUP_CHAR16 | SECURITY_MASTER_DETAIL |
3467 – User-defined field | Optional | VARCHAR2 (60) | USER_GROUP_CHAR17 | SECURITY_MASTER_DETAIL |
3468 – User-defined field | Optional | VARCHAR2 (60) | USER_GROUP_CHAR18 | SECURITY_MASTER_DETAIL |
3469 – User-defined field | Optional | VARCHAR2 (60) | USER_GROUP_CHAR19 | SECURITY_MASTER_DETAIL |
3470 – User-defined field | Optional | VARCHAR2 (60) | USER_GROUP_CHAR20 | SECURITY_MASTER_DETAIL |
3471 – User-defined field | Optional | VARCHAR2 (60) | USER_GROUP_CHAR21 | SECURITY_MASTER_DETAIL |
3472 – User-defined field | Optional | VARCHAR2 (60) | USER_GROUP_CHAR22 | SECURITY_MASTER_DETAIL |
3473 – User-defined field | Optional | VARCHAR2 (60) | USER_GROUP_CHAR23 | SECURITY_MASTER_DETAIL |
3474 – User-defined field | Optional | VARCHAR2 (60) | USER_GROUP_CHAR24 | SECURITY_MASTER_DETAIL |
| 1250 – Ex-interest Schedule | CHAR | SCHEDULE_SUB_TYPE | ||
| 3669 – Ex-interest Date | DATE (99) | Ex-interest date. | ||
| 16311 – Ex-Interest Coupon Recognition Date | CHAR | EX_INTEREST_COUPON_RECOGNITION_DATE | ||
| 3941 – Misc. | INTEGER | EX_DAYS | ||
| 12875 – Non-Deliverable Forward Indicator | CHAR | NDF_INDICATOR | ||
| 16726 - Variable Rate Source | MONEYL (2) | MINIMUM_BALANCE | ||
| 16727 - Variable Rate Flag | CHAR | FLOATING_PRICE_INSTRUMENT |
Add Comment