...
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/securityOverridessvoCodes/objectType | ||||||||||||||||||
objectId | Optional | ObjectId | not stored in DB |
|
|
| EagleML/referenceTransaction/securityOverridessvoCodes/objectId | ||||||||||||||||||
objectDescription | Optional | FeedTypeEnum | not stored in DB |
|
| EagleML/referenceTransaction/securityOverridessvoCodes/objectDescription | |||||||||||||||||||
updateTimestamp | Optional | dateTime | SECURITYDBO | SECURITY_OVERRIDESNAIC | UPDATE_DATE |
| DATE |
| EagleML/referenceTransaction/securityOverridessvoCodes/updateTimestamp | customElements | Not recommended | CustomElements - Complex type | reserved for customizations |
|
|
| EagleML/referenceTransaction/securityOverrides/customElements | ||||||||
sourceName | Optional | string - used for resolution logics | PACE_MASTERDBO | INTERFACES | SHORT_DESC | 1102 | CHAR(15) | in_short_desc | EagleML/referenceTransaction/securityOverrides/sourceName | ||||||||||||||||
updateSource | Optional | string | SECURITYDBO | SECURITY_OVERRIDESNAIC | UPDATE_SOURCE | 944 | VARCHAR2(255) | in_update_user | EagleML/referenceTransaction/securityOverridessvoCodes/updateSource | ||||||||||||||||
effectiveDate | Optional | date | SECURITYDBO | SECURITYNAIC_OVERRIDESHIST | UPDATEEFFECTIVE_DATE | 1109 | DATE | in_effective_date | EagleML/referenceTransaction/securityOverrides/effectiveDate | ||||||||||||||||
languageId | Optional | integer | not stored in DB |
|
|
| EagleML/referenceTransaction/securityOverrides/languageId | ||||||||||||||||||
tagNochangecase | Optional | string | not stored in DB |
|
|
| EagleML/referenceTransaction/securityOverrides/tagNochangecase | ||||||||||||||||||
preserveNull | Optional | string | not stored in DB |
|
|
| EagleML/referenceTransaction/securityOverrides/preserveNull | ||||||||||||||||||
noLoadValidationFlag | Optional | YesNoOptionEnum | not stored in DB |
|
|
| EagleML/referenceTransaction/securityOverrides/noLoadValidationFlag | ||||||||||||||||||
accountingValidationFlag | Optional | YesNoOptionEnum | not stored in DB |
|
|
| EagleML/referenceTransaction/securityOverrides/accountingValidationFlag | ||||||||||||||||||
svoCodes/effectiveDate | |||||||||||||||||||||||||
Asset Identifiers Model | EagleML/referenceTransaction/securityOverridessvoCodes/ | ||||||||||||||||||||||||
tableNamenaicDate | Optional | stringdate | PACE_MASTERDBO | PACE_INV_TABLES | TABLE_NAME | 1768 | CHAR(50) |
| SECURITYDBO | NAIC | NAIC_DATE | 5890 | DATE | EagleML/referenceTransaction/securityOverridessvoCodes/tableNamenaicDatefieldName | |||||||||||
naicSymbol | Optional | string | PACE_MASTERDBO | PACE_INV_FIELDS | FIELD_NAME | 1769SECURITYDBO | NAIC | NAIC_SYMBOL | 5891 | CHAR( | 10015) |
| EagleML/referenceTransaction/ | securityOverridessvoCodes/ | fieldNamenaicSymbol | ||||||||||
naicSymbol2 | Optional | integerstring | SECURITYDBO | SECURITY_OVERRIDESNAIC | FIELDNAIC_ | IDSYMBOL2 | 4870 | NUMBER | in_field_id | EagleML/referenceTransaction/securityOverrides/fieldId | starTag | Optional | integer | PACE_MASTERDBO | PACE_INV_FIELDS | STAR_TAG | 3251 | VARCHAR2(25) | in_tag5892 | CHAR(15) | EagleML/referenceTransaction/ | securityOverridessvoCodes/ | starTagnaicSymbol2 | ||
naicSymbol3 | Optional | string | SECURITYDBO | SECURITY_OVERRIDESNAIC | VALUENAIC_ | CHARSYMBOL3 | 17715893 | VARCHAR2CHAR( | 25515) | in_value_char | EagleML/referenceTransaction/ | securityOverridessvoCodes/ | valueCharnaicSymbol3 | ||||||||||||
naicMarketCode | Optional | date | SECURITYDBO | SECURITY_OVERRIDESBEGIN_DATE | 71 | DATE | in_begin_date | EagleML/referenceTransaction/securityOverrides/startDate | |||||||||||||||||
endDate | Optional | date | SECURITYDBO | SECURITY_OVERRIDES | END_DATE | 73 | DATE | in_end_date | EagleML/referenceTransaction/securityOverrides/endDate | ||||||||||||||||
comments | Optional | string | SECURITYDBO | SECURITY_OVERRIDES | COMMENTS | 10498 | VARCHAR2(500) | in_comments | EagleML/referenceTransaction/securityOverrides/comments | reasonCode | Optional | string | SECURITYDBO | SECURITY_OVERRIDES | REASON_CODE | 10497 | VARCHAR2(20) | in_reason_codeNAIC | NAIC_MARKET_CODE | 5856 | CHAR(40) | EagleML/referenceTransaction/ | securityOverridessvoCodes/ | reasonCodenaicMarketCode | |
naicRate | Optional | YesNoOptionEnumdecimal | SECURITYDBO | SECURITY_OVERRIDESNAIC | TEMPNAIC_ | OVERLAYRATE | 58655894 | VARCHAR2NUMBER( | 228,12) | in_temp_overlay | EagleML/referenceTransaction/ | securityOverridessvoCodes/ | tempOverlaynaicRate | ||||||||||||
groupCode | Optional | string | SECURITYDBO | SECURITY_OVERRIDESNAIC | ORIGGROUP_ | VALUE
| VARCHAR2(255) |
| EagleML/referenceTransaction/securityOverrides/originalValue | sourceSrcIntfcName | Optional | string | PACE_MASTERDBO | INTERFACES | SHORT_DESC |
| CHAR(15) |
| CODE | 5858 | CHAR(4) | EagleML/referenceTransaction/ | securityOverridessvoCodes/ | sourceSrcIntfcNamegroupCode | |
naicCapStructureCode | Optional | string | SECURITYDBO | SECURITY_OVERRIDESNAIC | SOURCENAIC_ | SRCCAP_ | INTFCSTRUCTURE_ | INSTCODE | 16565 | NUMBERVARCHAR2( | 382) |
| EagleML/referenceTransaction/ | securityOverrides/sourceSrcIntfcInstinstance | Optional | integer | SECURITYDBO | SECURITY_OVERRIDES | INSTANCE |
| NUMBER |
| EagleML/referenceTransaction/securityOverrides/instancesvoCodes/naicCapStructureCode |