...
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 | ||||
| 3669 – Ex-interest Date | ||||
| 16311 – Ex-interest Processing Flag | ||||
| 3941 – Misc. Tag | ||||
| 12875 – Non-Deliverable Forward Indicator |