Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


 
ElementRequired Inbound Acct ValidationRequired Inbound Data MgtValue Type Star TagEagle DBDB TableDB FieldData TypeXpath
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

 

 

 

 

 
SECURITYDBOISSUER_RATINGSUPDATE_DATEDATEEagleML/referenceTransaction/issuerRating/updateTimestamp
customElementsNot recommendedCustomElements - Complex typereserved for customizations
EagleML/referenceTransaction/issuerRating/customElements/updateTimestamp
sourceNameRequiredRequiredstring
 SECURITYDBO

 

 

 

 

ISSUER_RATINGSSRC_INTFC_INSTNUMBEREagleML/referenceTransaction/issuerRating/sourceName
updateSource

string 944 SECURITYDBO

 

 

 ISSUER_RATINGSUPDATE_SOURCEVARCHAR2(255)EagleML/referenceTransaction/issuerRating/updateSource
effectiveDate
Requireddate
 SECURITYDBO

 

 

 

 

ISSUER_RATINGSEFFECTIVE_DATEDATEEagleML/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
alphaRatingRequiredRequiredStringWithCodeScheme3349SECURITYDBOISSUER_RATINGSALPHA_RATING CHAR(8)EagleML/referenceTransaction/issuerRating/alphaRating
numericalRatingRequired
decimal3350SECURITYDBOISSUER_RATINGSNUMERICAL_RATING NUMBER(28,12)EagleML/referenceTransaction/issuerRating/numericalRating
analystCode

string3407SECURITYDBOISSUER_RATINGSANALYST_CODE CHAR(8)EagleML/referenceTransaction/issuerRating/analystCode
reason

string3408SECURITYDBOISSUER_RATINGSREASON VARCHAR2(255)EagleML/referenceTransaction/issuerRating/reason
approvedBy

string3409SECURITYDBOISSUER_RATINGSAPPROVED_BY CHAR(255)EagleML/referenceTransaction/issuerRating/approvedBy
submittedBy

string3410SECURITYDBOISSUER_RATINGSSUBMITTED_BY CHAR(255)EagleML/referenceTransaction/issuerRating/submittedBy
ratingComments

string3411SECURITYDBOISSUER_RATINGSRATING_COMMENTS VARCHAR2(255)EagleML/referenceTransaction/issuerRating/ratingComments
approvalComments

string3412SECURITYDBOISSUER_RATINGSAPPROVAL_COMMENTS VARCHAR2(255)EagleML/referenceTransaction/issuerRating/approvalComments
submittedDate

string3413SECURITYDBOISSUER_RATINGSSUBMITTED_DATE DATEEagleML/referenceTransaction/issuerRating/submittedDate
provider

string3414SECURITYDBOISSUER_RATINGSPROVIDER CHAR(12)EagleML/referenceTransaction/issuerRating/provider
ratingCodeRequired, mapped to tag 1165
string3446SECURITYDBOISSUER_RATINGSRATING_CODE VARCHAR2(12)EagleML/referenceTransaction/issuerRating/ratingCode
ratingTypeIndicator

string3445SECURITYDBOISSUER_RATINGSRATING_TYPE_INDICATOR VARCHAR2(20)EagleML/referenceTransaction/issuerRating/ratingTypeIndicator
program

string3444SECURITYDBOISSUER_RATINGSPROGRAM VARCHAR2(20)EagleML/referenceTransaction/issuerRating/program
ratingChar1

string3448SECURITYDBOISSUER_RATINGSIR_CHAR1 VARCHAR2(60)EagleML/referenceTransaction/issuerRating/ratingChar1
ratingChar2

string3449SECURITYDBOISSUER_RATINGSIR_CHAR2 VARCHAR2(60)EagleML/referenceTransaction/issuerRating/ratingChar2
ratingChar3

string3450SECURITYDBOISSUER_RATINGSIR_CHAR3 VARCHAR2(60)EagleML/referenceTransaction/issuerRating/ratingChar3
ratingChar4

string3415SECURITYDBOISSUER_RATINGSIR_CHAR4 VARCHAR2(60)EagleML/referenceTransaction/issuerRating/ratingChar4
ratingChar5

string3416SECURITYDBOISSUER_RATINGSIR_CHAR5 VARCHAR2(60)EagleML/referenceTransaction/issuerRating/ratingChar5
ratingChar6

string3417SECURITYDBOISSUER_RATINGSIR_CHAR6 VARCHAR2(60)EagleML/referenceTransaction/issuerRating/ratingChar6
ratingChar7

string3440SECURITYDBOISSUER_RATINGSIR_CHAR7 VARCHAR2(60)EagleML/referenceTransaction/issuerRating/ratingChar7
ratingChar8

string3441SECURITYDBOISSUER_RATINGSIR_CHAR8 VARCHAR2(60)EagleML/referenceTransaction/issuerRating/ratingChar8
ratingChar9

string3442SECURITYDBOISSUER_RATINGSIR_CHAR9 VARCHAR2(60)EagleML/referenceTransaction/issuerRating/ratingChar9
ratingChar10

string3457SECURITYDBOISSUER_RATINGSIR_CHAR10 VARCHAR2(60)EagleML/referenceTransaction/issuerRating/ratingChar10
ratingDate1

string3451SECURITYDBOISSUER_RATINGSIR_DATE1 DATEEagleML/referenceTransaction/issuerRating/ratingDate1
ratingDate2

date3452SECURITYDBOISSUER_RATINGSIR_DATE2 DATEEagleML/referenceTransaction/issuerRating/ratingDate2
ratingDate3

date3453SECURITYDBOISSUER_RATINGSIR_DATE3 DATEEagleML/referenceTransaction/issuerRating/ratingDate3
ratingFloat1

decimal3454SECURITYDBOISSUER_RATINGSIR_FLOAT1 NUMBER(28,12)EagleML/referenceTransaction/issuerRating/ratingFloat1
ratingFloat2

decimal3455SECURITYDBOISSUER_RATINGSIR_FLOAT2 NUMBER(28,12)EagleML/referenceTransaction/issuerRating/ratingFloat2
ratingFloat3

decimal3456SECURITYDBOISSUER_RATINGSIR_FLOAT3 NUMBER(28,12)EagleML/referenceTransaction/issuerRating/ratingFloat3
bkupUpdateSource

string

 


SECURITYDBOISSUER_RATINGSBKUP_UPDATE_SOURCE CHAR(8)EagleML/referenceTransaction/issuerRating/bkupUpdateSource
sourceDate

date

 


SECURITYDBOISSUER_RATINGSSOURCE_DATE DATEEagleML/referenceTransaction/issuerRating/sourceDate
releaseStatus


normalizedString614SECURITYDBOISSUER_RATINGSRELEASE_STATUSCHAR(1)EagleML/referenceTransaction/issuerRating/releaseStatus
sourceDescription


string1103PACE_MASTERDBOINTERFACESLONG_DESCCHAR(50)EagleML/referenceTransaction/issuerRating/sourceDescription