| Element | 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 | EagleML/referenceTransaction/issuerRating/updateTimestamp | |||||
| customElements | CustomElements - Complex type | reserved for customizations | EagleML/referenceTransaction/issuerRating/customElements/ | ||||
| sourceName | string | 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 table | EagleML/referenceTransaction/issuerRating/ | ||||||
| alphaRating | StringWithCodeScheme | 3349 | SECURITYDBO | ISSUER_RATINGS | ALPHA_RATING | CHAR(8) | EagleML/referenceTransaction/issuerRating/alphaRating |
| numericalRating | 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 | 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 | |
...