LOC Entity Data Map Table

Owned by Dmitry Donosiyan (Unlicensed)
Last updated: Oct 30, 2024 by Kinga Huszno
1 min read

Element

Required/Optional

Value Type

Eagle DB

DB Table

DB Field

Data_Type

Xpath

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

Entity Common Id Model

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

Â