| 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 | Required | 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 Table - see extra table for load. Only issuerAlias element is extracted. | EagleML/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 | |||
Manage space
Manage content
Integrations