Please review/provide values for cells with ??NG (in red)
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.
...
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 | ??NG | |||
3669 – Ex-interest Date | DATE (99) | RESERVED3669. linked to schedule 'schedule_date1'. ??NG | Ex-interest date. | ??NG | ||
16311 – Ex-interest Processing Flag | CHAR | EX_INTEREST_PROCESSING_FLAG | ??NG | |||
3941 – Misc. | INTEGER | EX_DAYS | ??NG | |||
12875 – Non-Deliverable Forward Indicator | CHAR | NDF_INDICATOR | ??NG | |||
16726 - Variable Rate Source | MONEYL (2) | MINIMUM_BALANCE | ??NG | |||
16727 - Variable Rate Flag | CHAR | FLOATING_PRICE_INSTRUMENT | ??NG |