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/


Info

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

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.

...

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

sourceDescriptionstringSECURITYDBORATINGS
EagleML/referenceTransaction/rating/ratingDataModel/sourceDescription