LOC Issuer Data Map Table

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/locIssuer/objectType

objectId

 

ObjectId

not stored in DB

 

EagleML/referenceTransaction/locIssuer/objectId

objectDescription

 

FeedTypeEnum

not stored in DB

 

EagleML/referenceTransaction/locIssuer/objectDescription

updateTimestamp

Required

dateTime

SECURITYDBO

LOC_ISSUER_RELATIONSHIP

UPDATE_DATE

DATE

EagleML/referenceTransaction/locIssuer/updateTimestamp

customElements

Not recommended

CustomElements - Complex type

 

EagleML/referenceTransaction/locIssuer/customElements/

sourceName

 

string 

 

 

 

 

EagleML/referenceTransaction/locIssuer/sourceName

updateSource

Required

string

SECURITYDBO

LOC_ISSUER_RELATIONSHIP

UPDATE_SOURCE

 

EagleML/referenceTransaction/locIssuer/updateSource

effectiveDate

 

date

not stored in DB

 

EagleML/referenceTransaction/locIssuer/effectiveDate

languageId

 

integer

not stored in DB

 

EagleML/referenceTransaction/locIssuer/languageId

tagNochangecase

 

string

not stored in DB

 

EagleML/referenceTransaction/locIssuer/tagNochangecase

preserveNull

 

string

not stored in DB

 

EagleML/referenceTransaction/locIssuer/preserveNull

noLoadValidationFlag

 

YesNoOptionEnum

not stored in DB

 

EagleML/referenceTransaction/locIssuer/noLoadValidationFlag

accountingValidationFlag

 

YesNoOptionEnum

not stored in DB

 

EagleML/referenceTransaction/locIssuer/accountingValidationFlag

facilityId

Required

string

SECURITYDBO

LOC_ISSUER_RELATIONSHIP

FACILITY_ID

VARCHAR2(255)

EagleML/referenceTransaction/locIssuer/facilityId

facilityType

 

string

not stored in DB

 

EagleML/referenceTransaction/locIssuer/facilityType

facilityName

 

string

not stored in DB

 

EagleML/referenceTransaction/locIssuer/facilityName

Issuer Identifiers Model

EagleML/referenceTransaction/locIssuer/

relationshipType

Required

string

SECURITYDBO

LOC_ISSUER_RELATIONSHIP

RELATIONSHIP_TYPE

VARCHAR2(255)

EagleML/referenceTransaction/locIssuer/relationshipType

startDate

Required

date

SECURITYDBO

LOC_ISSUER_RELATIONSHIP

START_DATE

DATE

EagleML/referenceTransaction/locIssuer/startDate

endDate

 

date

SECURITYDBO

LOC_ISSUER_RELATIONSHIP

END_DATE

DATE

EagleML/referenceTransaction/locIssuer/endDate

amount

 

decimal

SECURITYDBO

LOC_ISSUER_RELATIONSHIP

AMOUNT

NUMBER(38,12)

EagleML/referenceTransaction/locIssuer/amount

Â