Security Notes Data Map Table
- Natalie Gesin (Deactivated)
- Kinga Huszno
- Dmitry Donosiyan (Unlicensed)
Element | Optional/Required | Value Type | Star Tag | SP Parameter | Eagle DB | DB Table | DB Field | DB Field Type | Xpath |
|---|---|---|---|---|---|---|---|---|---|
objectType | Â | ObjectTypeEnum | Â | Â | not stored in DB | Â | EagleML/referenceTransaction/securityNotes/objectType | ||
objectId | Â | ObjectId | Â | Â | not stored in DB | Â | EagleML/referenceTransaction/securityNotes/objectId | ||
objectDescription | Â | FeedTypeEnum | Â | Â | not stored in DB | Â | EagleML/referenceTransaction/securityNotes/objectDescription | ||
updateTimestamp | Â | dateTime | Â | Â | PACE_MASTERDBO | SEC_NOTES | UPDDATE | DATE | EagleML/referenceTransaction/securityNotes/updateTimestamp |
customElements | Not recommended | CustomElements - Complex type |  |  | reserved for customizations |  | EagleML/referenceTransaction/securityNotes/customElements | ||
sourceName |  | string - used in resolution logic |  |  | PACE_MASTERDBO | INTERFACES | SHORT_DESC | CHAR(15) | EagleML/referenceTransaction/securityNotes/sourceName |
updateSource | Â | string | 944 | in_update_user | PACE_MASTERDBO | SEC_NOTES | UPDUSER | VARCHAR2(100) | EagleML/referenceTransaction/securityNotes/updateSource |
effectiveDate | Â | date | 1109 | Â | Â | Â | Â | DATE | EagleML/referenceTransaction/securityNotes/effectiveDate |
languageId | Â | integer | Â | Â | not stored in DB | Â | EagleML/referenceTransaction/securityNotes/languageId | ||
tagNochangecase | Â | string | Â | Â | not stored in DB | Â | EagleML/referenceTransaction/securityNotes/tagNochangecase | ||
preserveNull | Â | string | Â | Â | not stored in DB | Â | EagleML/referenceTransaction/securityNotes/preserveNull | ||
noLoadValidationFlag | Â | YesNoOptionEnum | Â | Â | not stored in DB | Â | EagleML/referenceTransaction/securityNotes/noLoadValidationFlag | ||
accountingValidationFlag | Â | YesNoOptionEnum | Â | Â | not stored in DB | Â | EagleML/referenceTransaction/securityNotes/accountingValidationFlag | ||
skipIfExistFlag | Â | YesNoOptionEnum | Â | Â | not stored in DB | Â | EagleML/referenceTransaction/securityNotes/skipIfExistFlag | ||
Asset Identifiers Model (see extra table) | EagleML/referenceTransaction/securityNotes/ | ||||||||
NoteModel | NoteModel - Complex type (see extra table below) | EagleML/referenceTransaction/securityNotes/NoteModel/ | |||||||
NoteModel Data Map Table | |||||||||
updateDate | Required | date | 1452 | in_upddate | PACE_MASTERDBO | SEC_NOTES | UPDDATE | DATE | EagleML/referenceTransaction/securityNotes/NoteModel/updateDate |
notes | Â | string | 3461 | in_notes | PACE_MASTERDBO | SEC_NOTES | NOTES | VARCHAR2(1000) | EagleML/referenceTransaction/securityNotes/NoteModel/notes |
noteType | Â | string | 2097 | in_note_type | PACE_MASTERDBO | SEC_NOTES | NOTE_TYPE | VARCHAR2(25) | EagleML/referenceTransaction/securityNotes/NoteModel/noteType |
updateUser | Required | string | 944 | in_update_user | PACE_MASTERDBO | SEC_NOTES | UPDUSER | VARCHAR2(100) | EagleML/referenceTransaction/securityNotes/NoteModel/updateUser |
noteIndicator | Â | string | 2095 | in_note_indicator | PACE_MASTERDBO | SEC_NOTES | NOTE_INDICATOR | CHAR(2) | EagleML/referenceTransaction/securityNotes/NoteModel/noteIndicator |
noteCharKey | Â | string | 3462 | in_note_char_key | PACE_MASTERDBO | SEC_NOTES | NOTE_CHAR_KEY | CHAR(12) | EagleML/referenceTransaction/securityNotes/NoteModel/noteCharKey |
shareProperty | Â | string | 1147 | in_share_property | PACE_MASTERDBO | SEC_NOTES | SHARE_PROPERTY | NUMBER | EagleML/referenceTransaction/securityNotes/NoteModel/shareProperty |
privateNote | Â | string | 1256 | in_private_note | PACE_MASTERDBO | SEC_NOTES | PRIVATE_NOTE | CHAR(1) | EagleML/referenceTransaction/securityNotes/NoteModel/privateNote |
Â