| Required Inbound Acct Validation | Required Inbound Data Mgt | | | | | | | | | |
---|
primaryAssetId | Required | Required | InstrumentId | 14 | in_primary_asset_id | S | SECURITYDBO | SECURITY_MASTER | PRIMARY_ASSET_ID | CHAR(100) | ../primaryAssetId |
primaryAssetType | Required | Required | InstrumentId | 1432 | in_primary_asset_id_type | S | SECURITYDBO | SECURITY_MASTER | PRIMARY_ASSET_ID_TYPE | CHAR(30) | ../primaryAssetType |
altAssetIdAndType |
|
| AssetIdAndAssetIdType Complex Group | ../altAssetIdAndType/ |
issueName |
|
| string | 961 | in_issue_name | S | SECURITYDBO | SECURITY_MASTER | ISSUE_NAME | VARCHAR2(255) | ../issueName |
unicodeIssueName |
|
| string | - |
|
| not stored in DB | ../unicodeIssueName |
issueDescription |
|
| Description | 962 | in_issue_description | S | SECURITYDBO | SECURITY_MASTER | ISSUE_DESCRIPTION | VARCHAR2(255) | ../issueDescription |
ticker | Conditionally Required (at least one of these identifiers should be provided for security alias resolution) |
| InstrumentId | 13 | in_ticker | S | SECURITYDBO | SECURITY_MASTER | TICKER | CHAR(100) | ../ticker |
Depending on Batting Order can be mapped to any of: 1952, 1955, 1958, 1961, 1964, 1967, 1970, 1973, 1976, 1979 | in_x_id_1, | S | SECURITYDBO | XREFERENCE | XREF_SECURITY_ID | CHAR(100) |
cusip |
| InstrumentId | in_x_id_2, | S | SECURITYDBO | XREFERENCE | XREF_SECURITY_ID | CHAR(100) | ../cusip |
cusipPay |
| InstrumentId | in_x_id_3, | S | SECURITYDBO | XREFERENCE | XREF_SECURITY_ID | CHAR(100) | ../cusipPay |
cusipReceive |
| InstrumentId | in_x_id_4, | S | SECURITYDBO | XREFERENCE | XREF_SECURITY_ID | CHAR(100) | ../cusipReceive |
isin |
| InstrumentId | in_x_id_5, | S | SECURITYDBO | XREFERENCE | XREF_SECURITY_ID | CHAR(100) | ../isin |
sedol |
| InstrumentId | in_x_id_6, | S | SECURITYDBO | XREFERENCE | XREF_SECURITY_ID | CHAR(100) | ../sedol |
reuters |
| InstrumentId | in_x_id_7, | S | SECURITYDBO | XREFERENCE | XREF_SECURITY_ID | CHAR(100) | ../reuters |
bloombergId |
| InstrumentId | in_x_id_8, | S | SECURITYDBO | XREFERENCE | XREF_SECURITY_ID | CHAR(100) | ../bloombergId |
sicovmId |
| InstrumentId | in_x_id_9, | S | SECURITYDBO | XREFERENCE | XREF_SECURITY_ID | CHAR(100) | ../sicovmId |
valorenId |
| InstrumentId | in_x_id_10 | S | SECURITYDBO | XREFERENCE | XREF_SECURITY_ID | CHAR(100) | ../valorenId |
cedel |
| InstrumentId |
| S | SECURITYDBO | XREFERENCE | XREF_SECURITY_ID | CHAR(100) | ../cedel |
internalId |
| InstrumentId |
| S | SECURITYDBO | XREFERENCE | XREF_SECURITY_ID | CHAR(100) | ../internalId |
cinsId |
| InstrumentId |
| S | SECURITYDBO | XREFERENCE | XREF_SECURITY_ID | CHAR(100) | ../cinsId |
xrefIdentifiers |
| SMFXrefIdentifiers Complex Group | ../xrefIdentifiers/ |
primaryExchange |
|
| string | 10396 | in_primary_exchange | S | SECURITYDBO | EQUITY_DETAIL | PRIMARY_EXCHANGE | VARCHAR2(30) | ../primaryExchange |
primaryExchangeCode | Required |
| ExchangeCode | 17 | in_sm_exchange | S | SECURITYDBO | SECURITY_MASTER | EXCHANGE | CHAR(8) | ../primaryExchangeCode |
securityAlias |
|
| integer | 10 | inout_security_alias | N | SECURITYDBO | SECURITY_MASTER | SECURITY_ALIAS | NUMBER | ../securityAlias |
assetCurrency | Required | Required | CurrencyCode | 85 | in_currency_code | S | SECURITYDBO | SECURITY_MASTER | CURRENCY_CODE | CHAR(30) | ../assetCurrency |
assetResolutionOption |
|
| normalizedString | - |
|
| not stored in DB; involved in security resolution logic | ../assetResolutionOption |
battingOrder |
|
| normalizedString | - |
|
| not stored in DB; involved in security resolution logic | ../battingOrder |
AssetIdAndAssetIdType Data Map |
|
Element | Required Inbound Acct Validation | Required Inbound Data Mgt | Value Type | Star Tag | SP Parameter | SP Type | Eagle DB | DB Table | DB Field | DB Field Type | Xpath |
---|
instrumentId | Required |
| InstrumentId | 1795 | in_alt_asset_id | S | SECURITYDBO | SECURITY_MASTER | ALT_ASSET_ID | CHAR(100) | ../altAssetIdAndType/instrumentId |
instrumentIdType |
|
| InstrumentIdType | 5501 | in_alt_asset_id_type | S | SECURITYDBO | SECURITY_MASTER | ALT_ASSET_ID_TYPE | CHAR(30) | ../altAssetIdAndType/instrumentIdType |
SMFXrefIdentifiers Data Map |
|
Element | Required Inbound Acct Validation | Required Inbound Data Mgt | Value Type | Star Tag | SP Parameter | SP Type | Eagle DB | DB Table | DB Field | DB Field Type | Xpath |
---|
Set of 10 elements with names |
xId1 | Required |
| SMFXrefIdentifier Complex Group | ../xrefIdentifiers/xId1/ |
xId2 |
|
| SMFXrefIdentifier Complex Group | ../xrefIdentifiers/xId2/ |
xId3 |
|
| SMFXrefIdentifier Complex Group | ../xrefIdentifiers/xId3/ |
xId4 |
|
| SMFXrefIdentifier Complex Group | ../xrefIdentifiers/xId4/ |
xId5 |
|
| SMFXrefIdentifier Complex Group | ../xrefIdentifiers/xId5/ |
xId6 |
|
| SMFXrefIdentifier Complex Group | ../xrefIdentifiers/xId6/ |
xId7 |
|
| SMFXrefIdentifier Complex Group | ../xrefIdentifiers/xId7/ |
xId8 |
|
| SMFXrefIdentifier Complex Group | ../xrefIdentifiers/xId8/ |
xId9 |
|
| SMFXrefIdentifier Complex Group | ../xrefIdentifiers/xId9/ |
xId10 |
|
| SMFXrefIdentifier Complex Group | ../xrefIdentifiers/xId10/ |
or set of unbounded number elements with the same name xId |
xId | Required |
| SMFXrefIdentifier Complex Group | ../xrefIdentifiers/xId/ |
SMFXrefIdentifier Data Map |
|
Element | Required Inbound Acct Validation | Required Inbound Data Mgt | Value Type | Star Tag | SP Parameter | SP Type | Eagle DB | DB Table | DB Field | DB Field Type | Xpath |
---|
xId | Required |
| string | 1952 | in_x_id_1 | S | SECURITYDBO | XREFERENCE | XREF_SECURITY_ID | CHAR(100) | ../../../xId |
1955 | in_x_id_2 | S |
1958 | in_x_id_3 | S |
1961 | in_x_id_4 | S |
1964 | in_x_id_5 | S |
1967 | in_x_id_6 | S |
1970 | in_x_id_7 | S |
1973 | in_x_id_8 | S |
1976 | in_x_id_9 | S |
1979 | in_x_id_10 | S |
xIdType | Required |
| InstrumentIdType | 1953 | in_x_id_type_1 | S | SECURITYDBO | XREFERENCE | XREF_TYPE | CHAR(30) | ../../../xIdType |
1956 | in_x_id_type_2 | S |
1959 | in_x_id_type_3 | S |
1962 | in_x_id_type_4 | S |
1965 | in_x_id_type_5 | S |
1968 | in_x_id_type_6 | S |
1971 | in_x_id_type_7 | S |
1974 | in_x_id_type_8 | S |
1977 | in_x_id_type_9 | S |
1980 | in_x_id_type_10 | S |
xExchangeCode |
|
| ExchangeCode | 1981 | in_xref_exchange | S | SECURITYDBO | XREFERENCE | EXCHANGE | VARCHAR2 | ../../../xExchangeCode |
primaryXrefSecAlias |
|
| integer | - |
|
| SECURITYDBO | XREFERENCE_HIST | PRIMARY_XREF_SEC_ALIAS | NUMBER | ../../../primaryXrefSecAlias |
cancelInd |
|
| string | - |
|
| SECURITYDBO | XREFERENCE_HIST | CANCEL_IND | VARCHAR2(1) | ../../../cancelInd |
endDate |
|
| date | - |
|
| SECURITYDBO | XREFERENCE_HIST | END_DATE | DATE | ../../../endDate |
xUpdateTimestamp |
|
| dateTime | - |
|
| SECURITYDBO | XREFERENCE | UPDATE_DATE | DATE | ../../../xUpdateTimestamp |
xUpdateSource |
|
| string | - |
|
| SECURITYDBO | XREFERENCE_HIST | UPDATE_SOURCE | VARCHAR2(255) | ../../../xUpdateSource |
xBkupUpdateSource |
|
| string | - |
|
| SECURITYDBO | XREFERENCE | BKUP_UPDATE_SOURCE | CHAR(8) | ../../../xBkupUpdateSource |
xOrigSecurityAlias |
|
| integer | - |
|
| SECURITYDBO | XREFERENCE | ORIG_SECURITY_ALIAS | NUMBER | ../../../xOrigSecurityAlias |
xSecurityAlias |
|
| integer | 1951 | in_x_alias_1 | N | SECURITYDBO | XREFERENCE | XREF_SECURITY_ALIAS | NUMBER | ../../../xSecurityAlias |
1954 | in_x_alias_2 | N |
1957 | in_x_alias_3 | N |
1960 | in_x_alias_4 | N |
1963 | in_x_alias_5 | N |
1966 | in_x_alias_6 | N |
1969 | in_x_alias_7 | N |
1972 | in_x_alias_8 | N |
1975 | in_x_alias_9 | N |
1978 | in_x_alias_10 | N |
xShortDesc | extract-only | string | - |
|
| SECURITYDBO | XREFERENCE | SHORT_DESC | VARCHAR2(255) | ../../../xShortDesc |