Element | Required Inbound Acct Validation | Required Inbound Data Mgt | Value Type | Star Tag | Eagle DB | DB Table | DB Field | Data Type | Xpath | |||||||||
objectType | ObjectTypeEnum | not stored in DB | EagleML/referenceTransaction/issuerRating/objectType | |||||||||||||||
objectId | ObjectId | not stored in DB | EagleML/referenceTransaction/issuerRating/objectId | |||||||||||||||
objectDescription | FeedTypeEnum | not stored in DB | EagleML/referenceTransaction/issuerRating/objectDescription | |||||||||||||||
updateTimestamp | dateTime | SECURITYDBO | ISSUER_RATINGS | UPDATE_DATE | DATE | EagleML/referenceTransaction/issuerRating/updateTimestamp | ||||||||||||
customElements | Not recommended | CustomElements - Complex type | reserved for customizations | EagleML/referenceTransaction/issuerRating/customElements/ | ||||||||||||||
sourceName | Required | Required | string | SECURITYDBO | ISSUER_RATINGS | SRC_INTFC_INST | NUMBER | EagleML/referenceTransaction/issuerRating/sourceName | ||||||||||
updateSource | string | 944 | SECURITYDBO | ISSUER_RATINGS | UPDATE_SOURCE | VARCHAR2(255) | EagleML/referenceTransaction/issuerRating/updateSource | |||||||||||
effectiveDate | date | SECURITYDBO | ISSUER_RATINGS | EFFECTIVE_DATE | DATE | EagleML/referenceTransaction/issuerRating/effectiveDate | ||||||||||||
accountingValidationFlag | YesNoOptionEnum | not stored in DB | EagleML/referenceTransaction/issuerRating/accountingValidationFlag | |||||||||||||||
Issuer Identifiers Model Data Map | - see extra tableEagleML/referenceTransaction/issuerRating/ | |||||||||||||||||
alphaRating | Required | Required | StringWithCodeScheme | 3349 | SECURITYDBO | ISSUER_RATINGS | ALPHA_RATING | CHAR(8) | EagleML/referenceTransaction/issuerRating/alphaRating | |||||||||
numericalRating | Required | decimal | 3350 | SECURITYDBO | ISSUER_RATINGS | NUMERICAL_RATING | NUMBER(28,12) | EagleML/referenceTransaction/issuerRating/numericalRating | ||||||||||
analystCode | string | 3407 | SECURITYDBO | ISSUER_RATINGS | ANALYST_CODE | CHAR(8) | EagleML/referenceTransaction/issuerRating/analystCode | |||||||||||
reason | string | 3408 | SECURITYDBO | ISSUER_RATINGS | REASON | VARCHAR2(255) | EagleML/referenceTransaction/issuerRating/reason | |||||||||||
approvedBy | string | 3409 | SECURITYDBO | ISSUER_RATINGS | APPROVED_BY | CHAR(255) | EagleML/referenceTransaction/issuerRating/approvedBy | |||||||||||
submittedBy | string | 3410 | SECURITYDBO | ISSUER_RATINGS | SUBMITTED_BY | CHAR(255) | EagleML/referenceTransaction/issuerRating/submittedBy | |||||||||||
ratingComments | string | 3411 | SECURITYDBO | ISSUER_RATINGS | RATING_COMMENTS | VARCHAR2(255) | EagleML/referenceTransaction/issuerRating/ratingComments | |||||||||||
approvalComments | string | 3412 | SECURITYDBO | ISSUER_RATINGS | APPROVAL_COMMENTS | VARCHAR2(255) | EagleML/referenceTransaction/issuerRating/approvalComments | |||||||||||
submittedDate | string | 3413 | SECURITYDBO | ISSUER_RATINGS | SUBMITTED_DATE | DATE | EagleML/referenceTransaction/issuerRating/submittedDate | |||||||||||
provider | string | 3414 | SECURITYDBO | ISSUER_RATINGS | PROVIDER | CHAR(12) | EagleML/referenceTransaction/issuerRating/provider | |||||||||||
ratingCode | Required, mapped to tag 1165 | string | 3446 | SECURITYDBO | ISSUER_RATINGS | RATING_CODE | VARCHAR2(12) | EagleML/referenceTransaction/issuerRating/ratingCode | ||||||||||
ratingTypeIndicator | string | 3445 | SECURITYDBO | ISSUER_RATINGS | RATING_TYPE_INDICATOR | VARCHAR2(20) | EagleML/referenceTransaction/issuerRating/ratingTypeIndicator | |||||||||||
program | string | 3444 | SECURITYDBO | ISSUER_RATINGS | PROGRAM | VARCHAR2(20) | EagleML/referenceTransaction/issuerRating/program | |||||||||||
ratingChar1 | string | 3448 | SECURITYDBO | ISSUER_RATINGS | IR_CHAR1 | VARCHAR2(60) | EagleML/referenceTransaction/issuerRating/ratingChar1 | |||||||||||
ratingChar2 | string | 3449 | SECURITYDBO | ISSUER_RATINGS | IR_CHAR2 | VARCHAR2(60) | EagleML/referenceTransaction/issuerRating/ratingChar2 | |||||||||||
ratingChar3 | string | 3450 | SECURITYDBO | ISSUER_RATINGS | IR_CHAR3 | VARCHAR2(60) | EagleML/referenceTransaction/issuerRating/ratingChar3 | |||||||||||
ratingChar4 | string | 3415 | SECURITYDBO | ISSUER_RATINGS | IR_CHAR4 | VARCHAR2(60) | EagleML/referenceTransaction/issuerRating/ratingChar4 | |||||||||||
ratingChar5 | string | 3416 | SECURITYDBO | ISSUER_RATINGS | IR_CHAR5 | VARCHAR2(60) | EagleML/referenceTransaction/issuerRating/ratingChar5 | |||||||||||
ratingChar6 | string | 3417 | SECURITYDBO | ISSUER_RATINGS | IR_CHAR6 | VARCHAR2(60) | EagleML/referenceTransaction/issuerRating/ratingChar6 | |||||||||||
ratingChar7 | string | 3440 | SECURITYDBO | ISSUER_RATINGS | IR_CHAR7 | VARCHAR2(60) | EagleML/referenceTransaction/issuerRating/ratingChar7 | |||||||||||
ratingChar8 | string | 3441 | SECURITYDBO | ISSUER_RATINGS | IR_CHAR8 | VARCHAR2(60) | EagleML/referenceTransaction/issuerRating/ratingChar8 | |||||||||||
ratingChar9 | string | 3442 | SECURITYDBO | ISSUER_RATINGS | IR_CHAR9 | VARCHAR2(60) | EagleML/referenceTransaction/issuerRating/ratingChar9 | |||||||||||
ratingChar10 | string | 3457 | SECURITYDBO | ISSUER_RATINGS | IR_CHAR10 | VARCHAR2(60) | EagleML/referenceTransaction/issuerRating/ratingChar10 | |||||||||||
ratingDate1 | string | 3451 | SECURITYDBO | ISSUER_RATINGS | IR_DATE1 | DATE | EagleML/referenceTransaction/issuerRating/ratingDate1 | |||||||||||
ratingDate2 | date | 3452 | SECURITYDBO | ISSUER_RATINGS | IR_DATE2 | DATE | EagleML/referenceTransaction/issuerRating/ratingDate2 | |||||||||||
ratingDate3 | date | 3453 | SECURITYDBO | ISSUER_RATINGS | IR_DATE3 | DATE | EagleML/referenceTransaction/issuerRating/ratingDate3 | |||||||||||
ratingFloat1 | decimal | 3454 | SECURITYDBO | ISSUER_RATINGS | IR_FLOAT1 | NUMBER(28,12) | EagleML/referenceTransaction/issuerRating/ratingFloat1 | |||||||||||
ratingFloat2 | decimal | 3455 | SECURITYDBO | ISSUER_RATINGS | IR_FLOAT2 | NUMBER(28,12) | EagleML/referenceTransaction/issuerRating/ratingFloat2 | |||||||||||
ratingFloat3 | decimal | 3456 | SECURITYDBO | ISSUER_RATINGS | IR_FLOAT3 | NUMBER(28,12) | EagleML/referenceTransaction/issuerRating/ratingFloat3 | |||||||||||
bkupUpdateSource | string | SECURITYDBO | ISSUER_RATINGS | BKUP_UPDATE_SOURCE | CHAR(8) | EagleML/referenceTransaction/issuerRating/bkupUpdateSource | ||||||||||||
sourceDate | date | SECURITYDBO | ISSUER_RATINGS | SOURCE_DATE | DATE | EagleML/referenceTransaction/issuerRating/sourceDate |
...