Security Overrides Data Map Table
Element | Optional/Required | Value Type | Eagle DB | DB Table | DB Field | Star Tag | DB Field Type | SP Parameter | Xpath |
---|---|---|---|---|---|---|---|---|---|
objectType | Optional | ObjectTypeEnum | not stored in DB | Â | Â | Â | EagleML/referenceTransaction/securityOverrides/objectType | ||
objectId | Optional | ObjectId | not stored in DB | Â | Â | Â | EagleML/referenceTransaction/securityOverrides/objectId | ||
objectDescription | Optional | FeedTypeEnum | not stored in DB | Â | Â | Â | EagleML/referenceTransaction/securityOverrides/objectDescription | ||
updateTimestamp | Optional | dateTime | SECURITYDBO | SECURITY_OVERRIDES | UPDATE_DATE | Â | DATE | Â | EagleML/referenceTransaction/securityOverrides/updateTimestamp |
customElements | Not recommended | CustomElements - Complex type | reserved for customizations | Â | Â | Â | EagleML/referenceTransaction/securityOverrides/customElements | ||
sourceName | Optional | string - used for resolution logics | PACE_MASTERDBO | INTERFACES | SHORT_DESC | 1102 | CHAR(15) | in_short_desc | EagleML/referenceTransaction/securityOverrides/sourceName |
updateSource | Optional | string | SECURITYDBO | SECURITY_OVERRIDES | UPDATE_SOURCE | 944 | VARCHAR2(255) | in_update_user | EagleML/referenceTransaction/securityOverrides/updateSource |
effectiveDate | Optional | date | SECURITYDBO | SECURITY_OVERRIDES | UPDATE_DATE | 1109 | DATE | Â | EagleML/referenceTransaction/securityOverrides/effectiveDate |
languageId | Optional | integer | not stored in DB | Â | Â | Â | EagleML/referenceTransaction/securityOverrides/languageId | ||
tagNochangecase | Optional | string | not stored in DB | Â | Â | Â | EagleML/referenceTransaction/securityOverrides/tagNochangecase | ||
preserveNull | Optional | string | not stored in DB | Â | Â | Â | EagleML/referenceTransaction/securityOverrides/preserveNull | ||
noLoadValidationFlag | Optional | YesNoOptionEnum | not stored in DB | Â | Â | Â | EagleML/referenceTransaction/securityOverrides/noLoadValidationFlag | ||
accountingValidationFlag | Optional | YesNoOptionEnum | not stored in DB | Â | Â | Â | EagleML/referenceTransaction/securityOverrides/accountingValidationFlag | ||
 | EagleML/referenceTransaction/securityOverrides/ | ||||||||
tableName | Optional | string | PACE_MASTERDBO | PACE_INV_TABLES | TABLE_NAME | 1768 | CHAR(50) | Â | EagleML/referenceTransaction/securityOverrides/tableName |
fieldName | Optional | string | PACE_MASTERDBO | PACE_INV_FIELDS | FIELD_NAME | 1769 | CHAR(100) | Â | EagleML/referenceTransaction/securityOverrides/fieldName |
fieldId | Optional | integer | SECURITYDBO | SECURITY_OVERRIDES | FIELD_ID | 4870 | NUMBER | in_field_id | EagleML/referenceTransaction/securityOverrides/fieldId |
starTag | Optional | integer | PACE_MASTERDBO | PACE_INV_FIELDS | STAR_TAG | 3251 | VARCHAR2(25) | in_tag | EagleML/referenceTransaction/securityOverrides/starTag |
valueChar | Optional | string | SECURITYDBO | SECURITY_OVERRIDES | VALUE_CHAR | 1771 | VARCHAR2(255) | in_value_char | EagleML/referenceTransaction/securityOverrides/valueChar |
startDate | Optional | date | SECURITYDBO | SECURITY_OVERRIDES | BEGIN_DATE | 71 | DATE | in_begin_date | EagleML/referenceTransaction/securityOverrides/startDate |
endDate | Optional | date | SECURITYDBO | SECURITY_OVERRIDES | END_DATE | 73 | DATE | in_end_date | EagleML/referenceTransaction/securityOverrides/endDate |
comments | Optional | string | SECURITYDBO | SECURITY_OVERRIDES | COMMENTS | 10498 | VARCHAR2(500) | in_comments | EagleML/referenceTransaction/securityOverrides/comments |
reasonCode | Optional | string | SECURITYDBO | SECURITY_OVERRIDES | REASON_CODE | 10497 | VARCHAR2(20) | in_reason_code | EagleML/referenceTransaction/securityOverrides/reasonCode |
tempOverlay | Optional | YesNoOptionEnum | SECURITYDBO | SECURITY_OVERRIDES | TEMP_OVERLAY | 5865 | VARCHAR2(2) | in_temp_overlay | EagleML/referenceTransaction/securityOverrides/tempOverlay |
originalValue | Optional | string | SECURITYDBO | SECURITY_OVERRIDES | ORIG_VALUE | Â | VARCHAR2(255) | Â | EagleML/referenceTransaction/securityOverrides/originalValue |
sourceSrcIntfcName | Optional | string | PACE_MASTERDBO | INTERFACES | SHORT_DESC | Â | CHAR(15) | Â | EagleML/referenceTransaction/securityOverrides/sourceSrcIntfcName |
sourceSrcIntfcInst | Optional | string | SECURITYDBO | SECURITY_OVERRIDES | SOURCE_SRC_INTFC_INST | Â | NUMBER(38) | Â | EagleML/referenceTransaction/securityOverrides/sourceSrcIntfcInst |
instance | Optional | integer | SECURITYDBO | SECURITY_OVERRIDES | INSTANCE | Â | NUMBER | Â | EagleML/referenceTransaction/securityOverrides/instance |
Â