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 |
---|---|---|---|---|---|---|---|---|---|---|
issuerId | Required |
| string | 1413, | 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, | in_issuer_alias | SECURITYDBO | related table | ISSUER_ALIAS, | 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 |
---|---|---|---|---|
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 |
---|---|---|---|---|---|---|---|---|---|
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 |