Versions Compared

Key

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


ElementRequired Inbound Acct ValidationRequired Inbound Data MgtValue TypeStar TagSP ParameterEagle DBDB TableDB FieldData TypeXPath
objectTypeRequired
ObjectTypeEnum

not stored in DB
EagleML/referenceTransaction/rating/objectType
objectId

ObjectId

not stored in DB
EagleML/referenceTransaction/rating/objectId
objectDescription

FeedTypeEnum

not stored in DB
EagleML/referenceTransaction/rating/objectDescription
updateTimestamp

dateTime

SECURITYDBORATINGSUPDATE_DATE
EagleML/referenceTransaction/rating/updateTimestamp
customElementsNot recommendedCustomElements - Complex type - reserved for customizations



EagleML/referenceTransaction/rating/customElements
sourceNameRequired
string1102
PACE_MASTERDBOINTERFACESSHORT_DESCCHAR(15)EagleML/referenceTransaction/rating/sourceName
updateSource

string944in_update_sourceSECURITYDBORATINGSUPDATE_SOURCEVARCHAR2(255)EagleML/referenceTransaction/rating/updateSource
effectiveDateRequired
date1109in_effective_dateSECURITYDBORATINGSEFFECTIVE_DATEDATEEagleML/referenceTransaction/rating/effectiveDate
languageId

integer

not stored in DB
EagleML/referenceTransaction/rating/languageId
tagNochangecase

string

not stored in DB
EagleML/referenceTransaction/rating/tagNochangecase
preserveNull

string

not stored in DB
EagleML/referenceTransaction/rating/preserveNull
noLoadValidationFlag

YesNoOptionEnum

not stored in DB
EagleML/referenceTransaction/rating/noLoadValidationFlag
Asset Identifiers Model        EagleML/referenceTransaction/rating/
ratingDataModelRatingDataModel - Complex type (see the table below)     EagleML/referenceTransaction/rating/ratingDataModel/
The above section of the EagleML is around asset resolution, which is necessary for resolving the security but is not actually stored in the database when working with Ratings. Only the ratings model below is actually stored in the database.
RatingDataModel Table








alphaRatingRequired
string1671in_alpha_ratingSECURITYDBORATINGSALPHA_RATINGCHAR(8)EagleML/referenceTransaction/rating/ratingDataModel/alphaRating
numericalRating

decimal1672in_numerical_ratingSECURITYDBORATINGSNUMERICAL_RATINGNUMBER(28,12)EagleML/referenceTransaction/rating/ratingDataModel/numericalRating
analystCode

string1673in_analyst_codeSECURITYDBORATINGSANALYST_CODECHAR(8)EagleML/referenceTransaction/rating/ratingDataModel/analystCode
reason

string1674in_reasonSECURITYDBORATINGSREASONVARCHAR2(255),EagleML/referenceTransaction/rating/ratingDataModel/reason
approvedBy

string1675in_approved_bySECURITYDBORATINGSAPPROVED_BYCHAR(255)EagleML/referenceTransaction/rating/ratingDataModel/approvedBy
submittedBy

string1676in_submitted_bySECURITYDBORATINGSSUBMITTED_BYCHAR(255)EagleML/referenceTransaction/rating/ratingDataModel/submittedBy
ratingComments

string1677in_rating_commentsSECURITYDBORATINGSRATING_COMMENTSVARCHAR2(255)EagleML/referenceTransaction/rating/ratingDataModel/ratingComments
approvalComments

string1678in_approval_commentsSECURITYDBORATINGSAPPROVAL_COMMENTSVARCHAR2(255)EagleML/referenceTransaction/rating/ratingDataModel/approvalComments
submittedDate

string1679in_submitted_dateSECURITYDBORATINGSSUBMITTED_DATEDATEEagleML/referenceTransaction/rating/ratingDataModel/submittedDate
ipoFlag

integer1680in_ipo_flagSECURITYDBORATINGSIPO_FLAGNUMBEREagleML/referenceTransaction/rating/ratingDataModel/ipoFlag
offeringPrice

decimal1681in_offering_priceSECURITYDBORATINGSOFFERING_PRICENUMBER(28,12)EagleML/referenceTransaction/rating/ratingDataModel/offeringPrice
ipoVerifyFlag

integer1682in_ipo_verify_flagSECURITYDBORATINGSIPO_VERIFY_FLAGNUMBEREagleML/referenceTransaction/rating/ratingDataModel/ipoVerifyFlag
provider

string1683in_providerSECURITYDBORATINGSPROVIDERCHAR(12)EagleML/referenceTransaction/rating/ratingDataModel/provider
ratingCodeRequired - Defaulted to "Source Name" by Panel
string1165, 3639in_rating_codeSECURITYDBORATINGSRATING_CODEVARCHAR2(12)EagleML/referenceTransaction/rating/ratingDataModel/ratingCode
ratingTypeIndicator

string3640in_rating_type_indicatorSECURITYDBORATINGSRATING_TYPE_INDICATORVARCHAR2(20)EagleML/referenceTransaction/rating/ratingDataModel/ratingTypeIndicator
program

string3641in_programSECURITYDBORATINGSPROGRAMVARCHAR2(20)EagleML/referenceTransaction/rating/ratingDataModel/program
ratingEnhanc

string3642in_rating_enhancSECURITYDBORATINGSRATING_ENHANCVARCHAR2(12)EagleML/referenceTransaction/rating/ratingDataModel/ratingEnhanc
auditAlphaRating

string3637in_audit_alpha_ratingSECURITYDBORATINGSAUDIT_ALPHA_RATINGVARCHAR2(8)EagleML/referenceTransaction/rating/ratingDataModel/auditAlphaRating
auditDate

string3638in_audit_dateSECURITYDBORATINGSAUDIT_DATEDATEEagleML/referenceTransaction/rating/ratingDataModel/auditDate
ratingChar1

string3649in_rating_char1SECURITYDBORATINGSRATING_CHAR1VARCHAR2(60)EagleML/referenceTransaction/rating/ratingDataModel/ratingChar1
ratingChar2

string3650in_rating_char2SECURITYDBORATINGSRATING_CHAR2VARCHAR2(60)EagleML/referenceTransaction/rating/ratingDataModel/ratingChar2
ratingChar3

string3651in_rating_char3SECURITYDBORATINGSRATING_CHAR3VARCHAR2(60)EagleML/referenceTransaction/rating/ratingDataModel/ratingChar3
ratingChar4

string3652in_rating_char4SECURITYDBORATINGSRATING_CHAR4VARCHAR2(60)EagleML/referenceTransaction/rating/ratingDataModel/ratingChar4
ratingChar5

string3653in_rating_char5SECURITYDBORATINGSRATING_CHAR5VARCHAR2(60)EagleML/referenceTransaction/rating/ratingDataModel/ratingChar5
ratingChar6

string3654in_rating_char6SECURITYDBORATINGSRATING_CHAR6VARCHAR2(60)EagleML/referenceTransaction/rating/ratingDataModel/ratingChar6
ratingChar7

string3655in_rating_char7SECURITYDBORATINGSRATING_CHAR7VARCHAR2(60)EagleML/referenceTransaction/rating/ratingDataModel/ratingChar7
ratingChar8

string3656in_rating_char8SECURITYDBORATINGSRATING_CHAR8VARCHAR2(60)EagleML/referenceTransaction/rating/ratingDataModel/ratingChar8
ratingChar9

string3657in_rating_char9SECURITYDBORATINGSRATING_CHAR9VARCHAR2(60)EagleML/referenceTransaction/rating/ratingDataModel/ratingChar9
ratingChar10

string3658in_rating_char10SECURITYDBORATINGSRATING_CHAR10VARCHAR2(60)EagleML/referenceTransaction/rating/ratingDataModel/ratingChar10
ratingChar11

string3823in_rating_char11SECURITYDBORATINGSRATING_CHAR11VARCHAR2(60)EagleML/referenceTransaction/rating/ratingDataModel/ratingChar11
ratingChar12

string3824in_rating_char12SECURITYDBORATINGSRATING_CHAR12VARCHAR2(60)EagleML/referenceTransaction/rating/ratingDataModel/ratingChar12
ratingChar13

string3825in_rating_char13SECURITYDBORATINGSRATING_CHAR13VARCHAR2(60)EagleML/referenceTransaction/rating/ratingDataModel/ratingChar13
ratingChar14

string3826in_rating_char14SECURITYDBORATINGSRATING_CHAR14VARCHAR2(60)EagleML/referenceTransaction/rating/ratingDataModel/ratingChar14
ratingChar15

string3827in_rating_char15SECURITYDBORATINGSRATING_CHAR15VARCHAR2(60)EagleML/referenceTransaction/rating/ratingDataModel/ratingChar15
ratingChar16

string3828in_rating_char16SECURITYDBORATINGSRATING_CHAR16VARCHAR2(60)EagleML/referenceTransaction/rating/ratingDataModel/ratingChar16
ratingChar17

string3829in_rating_char17SECURITYDBORATINGSRATING_CHAR17VARCHAR2(60)EagleML/referenceTransaction/rating/ratingDataModel/ratingChar17
ratingChar18

string3830in_rating_char18SECURITYDBORATINGSRATING_CHAR18VARCHAR2(60)EagleML/referenceTransaction/rating/ratingDataModel/ratingChar18
ratingChar19

string3831in_rating_char19SECURITYDBORATINGSRATING_CHAR19VARCHAR2(60)EagleML/referenceTransaction/rating/ratingDataModel/ratingChar19
ratingChar20

string3832in_rating_char20SECURITYDBORATINGSRATING_CHAR20VARCHAR2(60)EagleML/referenceTransaction/rating/ratingDataModel/ratingChar20
ratingDate1

string3643in_rating_date1SECURITYDBORATINGSRATING_DATE1DATEEagleML/referenceTransaction/rating/ratingDataModel/ratingDate1
ratingDate2

string3644in_rating_date2SECURITYDBORATINGSRATING_DATE2DATEEagleML/referenceTransaction/rating/ratingDataModel/ratingDate2
ratingDate3

string3645in_rating_date3SECURITYDBORATINGSRATING_DATE3DATEEagleML/referenceTransaction/rating/ratingDataModel/ratingDate3
ratingFloat1

decimal3646in_rating_float1SECURITYDBORATINGSRATING_FLOAT1NUMBER(28,12)EagleML/referenceTransaction/rating/ratingDataModel/ratingFloat1
ratingFloat2

decimal3647in_rating_float2SECURITYDBORATINGSRATING_FLOAT2NUMBER(28,12)EagleML/referenceTransaction/rating/ratingDataModel/ratingFloat2
ratingFloat3

decimal3648in_rating_float3SECURITYDBORATINGSRATING_FLOAT3NUMBER(28,12)EagleML/referenceTransaction/rating/ratingDataModel/ratingFloat3
securityAlias

integer10in_security_aliasSECURITYDBORATINGSSECURITY_ALIASNUMBEREagleML/referenceTransaction/rating/ratingDataModel/securityAlias
ratingSrc

string1102in_rating_srcPACE_MASTERDBOINTERFACESSHORT_DESCCHAR(15)EagleML/referenceTransaction/rating/ratingDataModel/ratingSrc
sourceDescriptionextract onlystring

PACE_MASTERDBOINTERFACESLONG_DESCCHAR(50)EagleML/referenceTransaction/rating/ratingDataModel/sourceDescription


Element

Required Inbound Acct ValidationRequired Inbound Data Mgt

Value Type

Eagle DB

DB Table

DB Field

Star Tag

Data Type

SP Parameter

XPath

objectType

Required

ObjectTypeEnum

not stored in DB




EagleML/referenceTransaction/rating/objectType

objectId



ObjectId

not stored in DB




EagleML/referenceTransaction/rating/objectId

objectDescription



FeedTypeEnum

not stored in DB




EagleML/referenceTransaction/rating/objectDescription

updateTimestamp



dateTime

SECURITYDBO

RATINGS

UPDATE_DATE




EagleML/referenceTransaction/rating/updateTimestamp

customElements

Not recommended

CustomElements - Complex type - reserved for customizations

EagleML/referenceTransaction/rating/customElements

sourceName

Required

string - needed for resolution logics

PACE_MASTERDBO

INTERFACES

SHORT_DESC

1102

CHAR(15)


EagleML/referenceTransaction/rating/sourceName

updateSource



string

SECURITYDBO

RATINGS

UPDATE_SOURCE

944

VARCHAR2(255)

in_update_source

EagleML/referenceTransaction/rating/updateSource

effectiveDate

Required

date

SECURITYDBO

RATINGS

EFFECTIVE_DATE

1109

DATE

in_effective_date

EagleML/referenceTransaction/rating/effectiveDate

languageId



integer

not stored in DB




EagleML/referenceTransaction/rating/languageId

tagNochangecase



string

not stored in DB




EagleML/referenceTransaction/rating/tagNochangecase

preserveNull



string

not stored in DB




EagleML/referenceTransaction/rating/preserveNull

noLoadValidationFlag



YesNoOptionEnum

not stored in DB




EagleML/referenceTransaction/rating/noLoadValidationFlag

Asset Identifiers Model

EagleML/referenceTransaction/rating/

ratingDataModel

RatingDataModel - Complex type (see the table below)

EagleML/referenceTransaction/rating/ratingDataModel/


Info
titleNote
The above section of the EagleML is around asset resolution, which is necessary for resolving the security but is not actually stored in the database when working with Ratings. Only the ratings model below is actually stored in the database.

Anchor
RatingDataModel
RatingDataModel
RatingDataModel Table

Element

Required Inbound Acct ValidationRequired Inbound Data Mgt

Value Type

Eagle Database

Database Table

Database Field

Star Tag

Database Data Type

SP_Parameter

XPath

alphaRating

Required

string

SECURITYDBO

RATINGS

ALPHA_RATING

1671

CHAR(8)

in_alpha_rating

EagleML/referenceTransaction/rating/ratingDataModel/alphaRating

numericalRating



decimal

SECURITYDBO

RATINGS

NUMERICAL_RATING

1672

NUMBER(28,12)

in_numerical_rating

EagleML/referenceTransaction/rating/ratingDataModel/numericalRating

analystCode



string

SECURITYDBO

RATINGS

ANALYST_CODE

1673

CHAR(8)

in_analyst_code

EagleML/referenceTransaction/rating/ratingDataModel/analystCode

reason



string

SECURITYDBO

RATINGS

REASON

1674

VARCHAR2(255),

in_reason

EagleML/referenceTransaction/rating/ratingDataModel/reason

approvedBy



string

SECURITYDBO

RATINGS

APPROVED_BY

1675

CHAR(255)

in_approved_by

EagleML/referenceTransaction/rating/ratingDataModel/approvedBy

submittedBy



string

SECURITYDBO

RATINGS

SUBMITTED_BY

1676

CHAR(255)

in_submitted_by

EagleML/referenceTransaction/rating/ratingDataModel/submittedBy

ratingComments



string

SECURITYDBO

RATINGS

RATING_COMMENTS

1677

VARCHAR2(255)

in_rating_comments

EagleML/referenceTransaction/rating/ratingDataModel/ratingComments

approvalComments



string

SECURITYDBO

RATINGS

APPROVAL_COMMENTS

1678

VARCHAR2(255)

in_approval_comments

EagleML/referenceTransaction/rating/ratingDataModel/approvalComments

submittedDate



string

SECURITYDBO

RATINGS

SUBMITTED_DATE

1679

DATE

in_submitted_date

EagleML/referenceTransaction/rating/ratingDataModel/submittedDate

ipoFlag



integer

SECURITYDBO

RATINGS

IPO_FLAG

1680

NUMBER

in_ipo_flag

EagleML/referenceTransaction/rating/ratingDataModel/ipoFlag

offeringPrice



decimal

SECURITYDBO

RATINGS

OFFERING_PRICE

1681

NUMBER(28,12)

in_offering_price

EagleML/referenceTransaction/rating/ratingDataModel/offeringPrice

ipoVerifyFlag



integer

SECURITYDBO

RATINGS

IPO_VERIFY_FLAG

1682

NUMBER

in_ipo_verify_flag

EagleML/referenceTransaction/rating/ratingDataModel/ipoVerifyFlag

provider



string

SECURITYDBO

RATINGS

PROVIDER

1683

CHAR(12)

in_provider

EagleML/referenceTransaction/rating/ratingDataModel/provider

ratingCode

Required - Defaulted to "Source Name" by Panel

string

SECURITYDBO

RATINGS

RATING_CODE

1165, 3639

VARCHAR2(12)

in_rating_code

EagleML/referenceTransaction/rating/ratingDataModel/ratingCode

ratingTypeIndicator



string

SECURITYDBO

RATINGS

RATING_TYPE_INDICATOR

3640

VARCHAR2(20)

in_rating_type_indicator

EagleML/referenceTransaction/rating/ratingDataModel/ratingTypeIndicator

program



string

SECURITYDBO

RATINGS

PROGRAM

3641

VARCHAR2(20)

in_program

EagleML/referenceTransaction/rating/ratingDataModel/program

ratingEnhanc



string

SECURITYDBO

RATINGS

RATING_ENHANC

3642

VARCHAR2(12)

in_rating_enhanc

EagleML/referenceTransaction/rating/ratingDataModel/ratingEnhanc

auditAlphaRating



string

SECURITYDBO

RATINGS

AUDIT_ALPHA_RATING

3637

VARCHAR2(8)

in_audit_alpha_rating

EagleML/referenceTransaction/rating/ratingDataModel/auditAlphaRating

auditDate



string

SECURITYDBO

RATINGS

AUDIT_DATE

3638

DATE

in_audit_date

EagleML/referenceTransaction/rating/ratingDataModel/auditDate

ratingChar1



string

SECURITYDBO

RATINGS

RATING_CHAR1

3649

VARCHAR2(60)

in_rating_char1

EagleML/referenceTransaction/rating/ratingDataModel/ratingChar1

ratingChar2



string

SECURITYDBO

RATINGS

RATING_CHAR2

3650

VARCHAR2(60)

in_rating_char2

EagleML/referenceTransaction/rating/ratingDataModel/ratingChar2

ratingChar3



string

SECURITYDBO

RATINGS

RATING_CHAR3

3651

VARCHAR2(60)

in_rating_char3

EagleML/referenceTransaction/rating/ratingDataModel/ratingChar3

ratingChar4



string

SECURITYDBO

RATINGS

RATING_CHAR4

3652

VARCHAR2(60)

in_rating_char4

EagleML/referenceTransaction/rating/ratingDataModel/ratingChar4

ratingChar5



string

SECURITYDBO

RATINGS

RATING_CHAR5

3653

VARCHAR2(60)

in_rating_char5

EagleML/referenceTransaction/rating/ratingDataModel/ratingChar5

ratingChar6



string

SECURITYDBO

RATINGS

RATING_CHAR6

3654

VARCHAR2(60)

in_rating_char6

EagleML/referenceTransaction/rating/ratingDataModel/ratingChar6

ratingChar7



string

SECURITYDBO

RATINGS

RATING_CHAR7

3655

VARCHAR2(60)

in_rating_char7

EagleML/referenceTransaction/rating/ratingDataModel/ratingChar7

ratingChar8



string

SECURITYDBO

RATINGS

RATING_CHAR8

3656

VARCHAR2(60)

in_rating_char8

EagleML/referenceTransaction/rating/ratingDataModel/ratingChar8

ratingChar9



string

SECURITYDBO

RATINGS

RATING_CHAR9

3657

VARCHAR2(60)

in_rating_char9

EagleML/referenceTransaction/rating/ratingDataModel/ratingChar9

ratingChar10



string

SECURITYDBO

RATINGS

RATING_CHAR10

3658

VARCHAR2(60)

in_rating_char10

EagleML/referenceTransaction/rating/ratingDataModel/ratingChar10

ratingChar11



string

SECURITYDBO

RATINGS

RATING_CHAR11

3823

VARCHAR2(60)

in_rating_char11

EagleML/referenceTransaction/rating/ratingDataModel/ratingChar11

ratingChar12



string

SECURITYDBO

RATINGS

RATING_CHAR12

3824

VARCHAR2(60)

in_rating_char12

EagleML/referenceTransaction/rating/ratingDataModel/ratingChar12

ratingChar13



string

SECURITYDBO

RATINGS

RATING_CHAR13

3825

VARCHAR2(60)

in_rating_char13

EagleML/referenceTransaction/rating/ratingDataModel/ratingChar13

ratingChar14



string

SECURITYDBO

RATINGS

RATING_CHAR14

3826

VARCHAR2(60)

in_rating_char14

EagleML/referenceTransaction/rating/ratingDataModel/ratingChar14

ratingChar15



string

SECURITYDBO

RATINGS

RATING_CHAR15

3827

VARCHAR2(60)

in_rating_char15

EagleML/referenceTransaction/rating/ratingDataModel/ratingChar15

ratingChar16



string

SECURITYDBO

RATINGS

RATING_CHAR16

3828

VARCHAR2(60)

in_rating_char16

EagleML/referenceTransaction/rating/ratingDataModel/ratingChar16

ratingChar17



string

SECURITYDBO

RATINGS

RATING_CHAR17

3829

VARCHAR2(60)

in_rating_char17

EagleML/referenceTransaction/rating/ratingDataModel/ratingChar17

ratingChar18



string

SECURITYDBO

RATINGS

RATING_CHAR18

3830

VARCHAR2(60)

in_rating_char18

EagleML/referenceTransaction/rating/ratingDataModel/ratingChar18

ratingChar19



string

SECURITYDBO

RATINGS

RATING_CHAR19

3831

VARCHAR2(60)

in_rating_char19

EagleML/referenceTransaction/rating/ratingDataModel/ratingChar19

ratingChar20



string

SECURITYDBO

RATINGS

RATING_CHAR20

3832

VARCHAR2(60)

in_rating_char20

EagleML/referenceTransaction/rating/ratingDataModel/ratingChar20

ratingDate1



string

SECURITYDBO

RATINGS

RATING_DATE1

3643

DATE

in_rating_date1

EagleML/referenceTransaction/rating/ratingDataModel/ratingDate1

ratingDate2



string

SECURITYDBO

RATINGS

RATING_DATE2

3644

DATE

in_rating_date2

EagleML/referenceTransaction/rating/ratingDataModel/ratingDate2

ratingDate3



string

SECURITYDBO

RATINGS

RATING_DATE3

3645

DATE

in_rating_date3

EagleML/referenceTransaction/rating/ratingDataModel/ratingDate3

ratingFloat1



decimal

SECURITYDBO

RATINGS

RATING_FLOAT1

3646

NUMBER(28,12)

in_rating_float1

EagleML/referenceTransaction/rating/ratingDataModel/ratingFloat1

ratingFloat2



decimal

SECURITYDBO

RATINGS

RATING_FLOAT2

3647

NUMBER(28,12)

in_rating_float2

EagleML/referenceTransaction/rating/ratingDataModel/ratingFloat2

ratingFloat3



decimal

SECURITYDBO

RATINGS

RATING_FLOAT3

3648

NUMBER(28,12)

in_rating_float3

EagleML/referenceTransaction/rating/ratingDataModel/ratingFloat3

securityAlias



integer

SECURITYDBO

RATINGS

SECURITY_ALIAS

10

NUMBER

in_security_alias

EagleML/referenceTransaction/rating/ratingDataModel/securityAlias

ratingSrc



string

SECURITYDBO

RATINGS

SRC_INTFC_INST

1102

NUMBER

in_rating_src

EagleML/referenceTransaction/rating/ratingDataModel/ratingSrc

sourceDescription

stringSECURITYDBORATINGS



EagleML/referenceTransaction/rating/ratingDataModel/sourceDescription

...