Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 4 Next »


Element

Optional/Required

Value Type

Eagle DB

DB Table

DB Field

Star Tag

DB Field Type

SP Parameter

Xpath

objectTypeOptionalObjectTypeEnumnot store in DB   EagleML/referenceTransaction/securityNotes/objectType
objectIdOptionalObjectIdnot store in DB   EagleML/referenceTransaction/securityNotes/objectId
objectDescriptionOptionalFeedTypeEnumnot store in DB   EagleML/referenceTransaction/securityNotes/objectDescription
updateTimestampOptionaldateTimepace_masterdbosec_notesupddate DATE EagleML/referenceTransaction/securityNotes/updateTimestamp
customElementsNot recommendedCustomElements - Complex typereserved for customizations   EagleML/referenceTransaction/securityNotes/customElements
sourceNameOptionalstring - used in resolution logicPACE_MASTERDBOINTERFACESshort_desc CHAR(15) EagleML/referenceTransaction/securityNotes/sourceName
updateSourceOptionalstringpace_masterdbosec_notesupduser944VARCHAR2(100)in_update_userEagleML/referenceTransaction/securityNotes/updateSource
effectiveDateOptionaldate   1109DATE EagleML/referenceTransaction/securityNotes/effectiveDate
languageIdOptionalintegernot store in DB   EagleML/referenceTransaction/securityNotes/languageId
tagNochangecaseOptionalstringnot store in DB   EagleML/referenceTransaction/securityNotes/tagNochangecase
preserveNullOptionalstringnot store in DB   EagleML/referenceTransaction/securityNotes/preserveNull
noLoadValidationFlagOptionalYesNoOptionEnumnot store in DB   EagleML/referenceTransaction/securityNotes/noLoadValidationFlag
Asset Identifiers ModelEagleML/referenceTransaction/securityNotes/
NoteModelNoteModel - Complex type (see extra table below)EagleML/referenceTransaction/securityNotes/NoteModel/

NoteModel Data Map Table

updateDateOptionaldatepace_masterdbosec_notesupddate1452DATEin_upddateEagleML/referenceTransaction/securityNotes/NoteModel/updateDate
notesOptionalstringpace_masterdbosec_notesnotes3461VARCHAR2(1000)in_notesEagleML/referenceTransaction/securityNotes/NoteModel/notes
noteTypeOptionalstringpace_masterdbosec_notesnote_type2097VARCHAR2(25)in_note_typeEagleML/referenceTransaction/securityNotes/NoteModel/noteType
updateUserRequiredstringpace_masterdbosec_notesupduser944VARCHAR2(100)in_update_userEagleML/referenceTransaction/securityNotes/NoteModel/updateUser
noteIndicatorOptionalstringpace_masterdbosec_notesnote_indicator2095CHAR(2)in_note_indicatorEagleML/referenceTransaction/securityNotes/NoteModel/noteIndicator
  • No labels