Issuer Rating Data Map Table

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