SVOCodes Data Map Table
- Vitali Kostyrenko
Element | Optional/Required | Value Type | Eagle DB | DB Table | DB Field | Star Tag | DB Field Type | SP Parameter | Xpath |
|---|---|---|---|---|---|---|---|---|---|
objectType | Optional | ObjectTypeEnum | not stored in DB | EagleML/referenceTransaction/svoCodes/objectType | |||||
objectId | Optional | ObjectId | not stored in DB | EagleML/referenceTransaction/svoCodes/objectId | |||||
objectDescription | Optional | FeedTypeEnum | not stored in DB | EagleML/referenceTransaction/svoCodes/objectDescription | |||||
updateTimestamp | Optional | dateTime | SECURITYDBO | NAIC | UPDATE_DATE | DATE | EagleML/referenceTransaction/svoCodes/updateTimestamp | ||
updateSource | Optional | string | SECURITYDBO | NAIC | UPDATE_SOURCE | 944 | VARCHAR2(255) | in_update_user | EagleML/referenceTransaction/svoCodes/updateSource |
effectiveDate | Optional | date | SECURITYDBO | NAIC_HIST | EFFECTIVE_DATE | 1109 | DATE | Â in_effective_date | EagleML/referenceTransaction/svoCodes/effectiveDate |
| Asset Identifiers Model | EagleML/referenceTransaction/svoCodes/ | ||||||||
naicDate | Optional | date | SECURITYDBO | NAIC | NAIC_DATE | 5890 | DATE | in_naic_date | EagleML/referenceTransaction/svoCodes/naicDate |
| naicSymbol | Optional | string | SECURITYDBO | NAIC | NAIC_SYMBOL | 5891 | CHAR(15) | in_naic_symbol | EagleML/referenceTransaction/svoCodes/naicSymbol |
| naicSymbol2 | Optional | string | SECURITYDBO | NAIC | NAIC_SYMBOL2 | 5892 | CHAR(15) | in_naic_symbol2 | EagleML/referenceTransaction/svoCodes/naicSymbol2 |
| naicSymbol3 | Optional | string | SECURITYDBO | NAIC | NAIC_SYMBOL3 | 5893 | CHAR(15) | in_naic_symbol3 | EagleML/referenceTransaction/svoCodes/naicSymbol3 |
| naicMarketCode | Optional | string | SECURITYDBO | NAIC | NAIC_MARKET_CODE | 5856 | CHAR(40) | in_naic_market_code | EagleML/referenceTransaction/svoCodes/naicMarketCode |
| naicRate | Optional | decimal | SECURITYDBO | NAIC | NAIC_RATE | 5894 | NUMBER(28,12) | in_naic_rate | EagleML/referenceTransaction/svoCodes/naicRate |
| groupCode | Optional | string | SECURITYDBO | NAIC | GROUP_CODE | 5858 | CHAR(4) | in_group_code | EagleML/referenceTransaction/svoCodes/groupCode |
| naicCapStructureCode | Optional | string | SECURITYDBO | NAIC | NAIC_CAP_STRUCTURE_CODE | 16565 | VARCHAR2(2) | in_naic_cap_structure_code | EagleML/referenceTransaction/svoCodes/naicCapStructureCode |