Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

...

...

...

Element

Required Inbound Acct Validation

Required Inbound Data Mgt

Value Type

Star Tag

SP Parameter

Eagle DB

DB Table

DB Field

DB Field Type

XPath

issuerId

Required

string

1413,
1144

in_issuer_id

SECURITYDBO

related table

ISSUER_ID

CHAR(20)

../issuerId

issuerName

Required

string

1173

in_issuer_name

SECURITYDBO

related table

ISSUER_NAME

VARCHAR2(255)

../issuerName

issuerAlias

integer

1147,
8289, 8290

in_issuer_alias
in_from_issuer_alias; in_to_issuer_alias

SECURITYDBO

related table

ISSUER_ALIAS,
FROM_ISSUER_ALIAS; TO_ISSUER_ALIAS

NUMBER,
NUMBER,
NUMBER

../issuerAlias

issuerXrefIdentifiers

IssuerXrefIdentifiers Model Data Map - Complex type (see extra table below)

../issuerXrefIdentifiers/

issuerResolutionOption

normalizedString

not stored in DB, used for resolution logic

../issuerResolutionOption

issuerBattingOrder

normalizedString

not stored in DB, used for resolution logic

../issuerBattingOrder

Anchor
IssuerXrefIdentifiers
IssuerXrefIdentifiers
IssuerXrefIdentifiers Data Map Table 

Element

Required Inbound Acct Validation

Optional/

Required Inbound Data Mgt

Value Type

XPath

xId1

Required

IssuerXrefIdentifier Model Data Map - Complex type (see extra table below) -  is used to

resolve  

resolve  in_x_id_1

../issuerXrefIdentifiers/xId1/

xId2

IssuerXrefIdentifier Model Data Map  - Complex type (see extra table below) -  is used to

resolve 

resolve in_x_id_2

../issuerXrefIdentifiers/xId2/

xId3

IssuerXrefIdentifier Model Data Map  - Complex type (see extra table below) - is used to

resolve 

resolve in_x_id_3

../issuerXrefIdentifiers/xId3/

xId4

IssuerXrefIdentifier Model Data Map  - Complex type (see extra table below) - is used to

resolve 

resolve in_x_id_4

../issuerXrefIdentifiers/xId4/

xId5

IssuerXrefIdentifier Model Data Map  - Complex type (see extra table below) - is used to

resolve 

resolve in_x_id_5

../issuerXrefIdentifiers/xId5/

xId6

IssuerXrefIdentifier Model Data Map  - Complex type (see extra table below) - is used to

resolve 

resolve in_x_id_6

../issuerXrefIdentifiers/xId6/

xId7

IssuerXrefIdentifier Model Data Map  - Complex type (see extra table below) - is used to

resolve 

resolve in_x_id_7

../issuerXrefIdentifiers/xId7/

xId8

IssuerXrefIdentifier Model Data Map  - Complex type (see extra table below) - is used to resolve

 in

 in_x_id_8

../issuerXrefIdentifiers/xId8/

xId9

IssuerXrefIdentifier Model Data Map  - Complex type (see extra table below) - is used to resolve

 in

 in_x_id_9

../issuerXrefIdentifiers/xId9/

xId10

IssuerXrefIdentifier Model Data Map  - Complex type (see extra table below) - is used to resolve in_x_id_10

../issuerXrefIdentifiers/xId10/

Anchor
IssuerXrefIdentifier
IssuerXrefIdentifier
IssuerXrefIdentifier Data Map Table

Element

Optional/

Required Inbound Acct Validation

Required Inbound Data Mgt

Value Type

Star Tag

SP Parameter

Eagle DB

DB Table

DB Field

XPath

xId

Required

string

3459

IN_SUB_ISSUER_ID

SECURITYDBO

ISSUER_XREF

SUB_ISSUER_ID

../issuerXrefIdentifiers/xId[1to10]/xId

xIdType

Required

InstrumentIdType

10454

IN_SUB_ISSUER_ID_TYPE

SECURITYDBO

ISSUER_XREF

SUB_ISSUER_ID_TYPE

../issuerXrefIdentifiers/xId[1to10]/xIdType

bondDummy

string

SECURITYDBO

ISSUER_XREF

BOND_DUMMY

../issuerXrefIdentifiers/xId[1to10]/bondDummy

equityDummy

integer

SECURITYDBO

ISSUER_XREF

EQUITY_DUMMY

../issuerXrefIdentifiers/xId[1to10]/equityDummy