LOC Entity Data Map Table
Element | Required/Optional | Value Type | Eagle DB | DB Table | DB Field | Data_Type | Xpath |
---|---|---|---|---|---|---|---|
objectType |
| ObjectTypeEnum | not stored in DB |
| EagleML/referenceTransaction/locEntity/objectType | ||
objectId |
| ObjectId | not stored in DB |
| EagleML/referenceTransaction/locEntity/objectId | ||
objectDescription |
| FeedTypeEnum | not stored in DB |
| EagleML/referenceTransaction/locEntity/objectDescription | ||
updateTimestamp | Required | dateTime | SECURITYDBO | LOC_ENTITY_RELATIONSHIP | UPDATE_DATE | DATE | EagleML/referenceTransaction/locEntity/updateTimestamp |
customElements | Not recommended | CustomElements - Complex type |
| EagleML/referenceTransaction/locEntity/customElements/ | |||
sourceName |
| string |
|
|
|
| EagleML/referenceTransaction/locEntity/sourceName |
updateSource | Required | string | SECURITYDBO | LOC_ENTITY_RELATIONSHIP | UPDATE_SOURCE | VARCHAR2(255) | EagleML/referenceTransaction/locEntity/updateSource |
effectiveDate |
| date | not stored in DB |
| EagleML/referenceTransaction/locEntity/effectiveDate | ||
languageId |
| integer | not stored in DB |
| EagleML/referenceTransaction/locEntity/languageId | ||
tagNochangecase |
| string | not stored in DB |
| EagleML/referenceTransaction/locEntity/tagNochangecase | ||
preserveNull |
| string | not stored in DB |
| EagleML/referenceTransaction/locEntity/preserveNull | ||
noLoadValidationFlag |
| YesNoOptionEnum | not stored in DB |
| EagleML/referenceTransaction/locEntity/noLoadValidationFlag | ||
accountingValidationFlag |
| YesNoOptionEnum | not stored in DB |
| EagleML/referenceTransaction/locEntity/accountingValidationFlag | ||
facilityId | Required | string | SECURITYDBO | LOC_ENTITY_RELATIONSHIP | FACILITY_ID | VARCHAR2(255) | EagleML/referenceTransaction/locEntity/facilityId |
facilityType |
| string | not stored in DB |
| EagleML/referenceTransaction/locEntity/facilityType | ||
facilityName |
| string | not stored in DB |
| EagleML/referenceTransaction/locEntity/facilityName | ||
EagleML/referenceTransaction/locEntity/ | |||||||
startDate | Required | date | SECURITYDBO | LOC_ENTITY_RELATIONSHIP | START_DATE | DATE | EagleML/referenceTransaction/locEntity/startDate |
endDate |
| date | SECURITYDBO | LOC_ENTITY_RELATIONSHIP | END_DATE | DATE | EagleML/referenceTransaction/locEntity/endDate |
withdrawalIndicator |
| normalizedString | SECURITYDBO | LOC_ENTITY_RELATIONSHIP | WITHDRAWAL_INDICATOR | VARCHAR2(1) | EagleML/referenceTransaction/locEntity/withdrawalIndicator |
locAverageOutstanding |
| decimal | SECURITYDBO | LOC_ENTITY_RELATIONSHIP | LOC_AVG_OUSTANDING | NUMBER(38,12) | EagleML/referenceTransaction/locEntity/locAverageOutstanding |
locDaysInUse |
| decimal | SECURITYDBO | LOC_ENTITY_RELATIONSHIP | LOC_DAYS_IN_USE | NUMBER(38,12) | EagleML/referenceTransaction/locEntity/locDaysInUse |