...
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/securityOverrides/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/sourceNamesvoCodes/updateTimestamp | ||||||||||||||||||||||||||
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/accountingValidationFlagsvoCodes/effectiveDate | ||||||||||||||||||||||||||||
Asset Identifiers Model | EagleML/referenceTransaction/securityOverridessvoCodes/ | ||||||||||||||||||||||||||||||||||
tableNamenaicDate | Optional | string | PACE_MASTERDBO | PACE_INV_TABLES | TABLE_NAME | 1768 | CHAR(50) |
| EagleML/referenceTransaction/securityOverrides/tableName | ||||||||||||||||||||||||||
fieldName | Optional | string | PACE_MASTERDBO | PACE_INV_FIELDS | FIELD_NAME | 1769 | CHAR(100) |
| EagleML/referenceTransaction/securityOverrides/fieldName | ||||||||||||||||||||||||||
fieldId | Optional | integer | SECURITYDBO | SECURITY_OVERRIDES | FIELD_ID | 4870 | NUMBER | in_field_iddate | SECURITYDBO | NAIC | NAIC_DATE | 5890 | DATE | in_naic_date | EagleML/referenceTransaction/securityOverridessvoCodes/fieldIdnaicDatestarTag | ||||||||||||||||||||
naicSymbol | Optional | integerstring | PACE_MASTERDBO | PACE_INV_FIELDS | STAR_TAG | 3251 | VARCHAR2(25SECURITYDBO | NAIC | NAIC_SYMBOL | 5891 | CHAR(15) | in_ | tagnaic_symbol | EagleML/referenceTransaction/ | securityOverridessvoCodes/ | starTagnaicSymbol | |||||||||||||||||||
naicSymbol2 | Optional | string | SECURITYDBO | SECURITY_OVERRIDESNAIC | VALUENAIC_ | CHARSYMBOL2 | 17715892 | VARCHAR2CHAR( | 25515) | in_ | valuenaic_ | charsymbol2 | EagleML/referenceTransaction/ | securityOverridessvoCodes/ | valueCharnaicSymbol2 | ||||||||||||||||||||
naicSymbol3 | Optional | datestring | SECURITYDBO | SECURITY_OVERRIDESNAIC | BEGINNAIC_ | DATESYMBOL3 | 71 | DATE5893 | CHAR(15) | in_ | beginnaic_ | datesymbol3 | EagleML/referenceTransaction/ | securityOverridessvoCodes/ | startDatenaicSymbol3 | ||||||||||||||||||||
naicMarketCode | Optional | date | SECURITYDBO | SECURITY_OVERRIDESEND_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_reasonNAIC | NAIC_MARKET_CODE | 5856 | CHAR(40) | in_naic_market_code | EagleML/referenceTransaction/ | securityOverridessvoCodes/ | reasonCodenaicMarketCode | |
naicRate | Optional | YesNoOptionEnumdecimal | SECURITYDBO | SECURITY_OVERRIDESNAIC | TEMPNAIC_ | OVERLAYRATE | 58655894 | VARCHAR2NUMBER( | 228,12) | in_ | tempnaic_ | overlayrate | EagleML/referenceTransaction/ | securityOverridessvoCodes/ | tempOverlaynaicRate | ||||||||||||||||||||
groupCode | Optional | string | SECURITYDBO | SECURITY_OVERRIDESNAIC | ORIGGROUP_ | VALUECODE | 5858 | VARCHAR2CHAR( | 2554) |
| EagleML/referenceTransaction/securityOverrides/originalValue | sourceSrcIntfcName | Optional | string | PACE_MASTERDBO | INTERFACES | SHORT_DESC |
| CHAR(15) |
| in_group_code | EagleML/referenceTransaction/ | securityOverridessvoCodes/ | sourceSrcIntfcNamegroupCode | |||||||||||
naicCapStructureCode | Optional | string | SECURITYDBO | SECURITY_OVERRIDESNAIC | SOURCENAIC_ | SRCCAP_ | INTFCSTRUCTURE_ | INSTCODE | 16565 | NUMBERVARCHAR2( | 38)
| EagleML/referenceTransaction/securityOverrides/sourceSrcIntfcInst | instance | Optional | integer | SECURITYDBO | SECURITY_OVERRIDES | INSTANCE |
| NUMBER | 2) | in_naic_cap_structure_code | EagleML/referenceTransaction/ | securityOverridessvoCodes/ | instancenaicCapStructureCode |