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 | |||
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