Element | Required Inbound Acct Validation | Required Inbound Data Mgt | Value Type | Star Tag | Eagle DB | DB Table | DB Field | Data Type | Xpath | |||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
objectType | ObjectTypeEnum |
| Hardcoded to IssuerRating | not stored in DB | EagleML/referenceTransaction/issuerRating/objectType | |||||||||
objectId | ObjectId |
| Hardcoded to IssuerRating |
| not stored in DB | EagleML/referenceTransaction/issuerRating/objectId | ||||||||
objectDescription | FeedTypeEnum |
| Hardcoded to REFERENCE |
| 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/updateTimestamp | ||||||||||
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 | |||
issuerAliasaccountingValidationFlag | integer |
|
|
|
| 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/issuerAlias | |||||||||||||
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 | |||||||
releaseStatus | normalizedString | 614 | SECURITYDBO | ISSUER_RATINGS | RELEASE_STATUS | CHAR(1) | EagleML/referenceTransaction/issuerRating/releaseStatus | |||||||
sourceDescription | string | 1103 | PACE_MASTERDBO | INTERFACES | LONG_DESC | CHAR(50) | EagleML/referenceTransaction/issuerRating/sourceDescription |
Page Comparison
Manage space
Manage content
Integrations