Issuer Identifiers Model Data Map Table

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

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

IssuerXrefIdentifiers Data Map Table 

Element

Required Inbound Acct Validation

Required Inbound Data Mgt

Value Type

XPath

Element

Required Inbound Acct Validation

Required Inbound Data Mgt

Value Type

XPath

xId1

Required

 

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

../issuerXrefIdentifiers/xId1/

xId2

 

 

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

../issuerXrefIdentifiers/xId2/

xId3

 

 

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

../issuerXrefIdentifiers/xId3/

xId4

 

 

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

../issuerXrefIdentifiers/xId4/

xId5

 

 

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

../issuerXrefIdentifiers/xId5/

xId6

 

 

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

../issuerXrefIdentifiers/xId6/

xId7

 

 

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

../issuerXrefIdentifiers/xId7/

xId8

 

 

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

../issuerXrefIdentifiers/xId8/

xId9

 

 

IssuerXrefIdentifier Model Data Map  - Complex type (see extra table below) - is used to resolve 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/

IssuerXrefIdentifier Data Map Table

Element

Required Inbound Acct Validation

Required Inbound Data Mgt

Value Type

Star Tag

SP Parameter

Eagle DB

DB Table

DB Field

XPath

Element

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