SVOCodes Data Map Table
- Vitali Kostyrenko
- Kinga Huszno
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 |
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 |
Â