Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 14 Next »

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 futures and option contracts, the creation of the synthetic security is suppressed when tag 1081 is NONE.

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
CHARSCHEDULE_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 
  • No labels