Page Comparison

Element	Required Inbound Acct Validation	Required Inbound Data Mgt	Value Type	Star Tag	SP Parameter	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

1102

PACE_MASTERDBO

INTERFACES

SHORT_DESC

1102

	CHAR(15)	EagleML/referenceTransaction/rating/sourceName
updateSource			string	944	in_update_source	SECURITYDBO	RATINGS	UPDATE_SOURCE

944

VARCHAR2(255)

in_update_source

	EagleML/referenceTransaction/rating/updateSource
effectiveDate	Required		date	1109	in_effective_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

...

title	Note

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

alphaRating

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

1671

in_alpha_rating

SECURITYDBO

RATINGS

ALPHA_RATING

1671

CHAR(8)

in_alpha_rating

EagleML/referenceTransaction/rating/ratingDataModel/alphaRating
numericalRating			decimal	1672	in_numerical_rating	SECURITYDBO	RATINGS	NUMERICAL_RATING

1672

NUMBER(28,12)

in_numerical_rating

	EagleML/referenceTransaction/rating/ratingDataModel/numericalRating
analystCode			string	1673	in_analyst_code	SECURITYDBO	RATINGS	ANALYST_CODE

1673

CHAR(8)

in_analyst_code

EagleML/referenceTransaction/rating/ratingDataModel/analystCode
reason			string	1674	in_reason	SECURITYDBO	RATINGS	REASON

1674

VARCHAR2(255),

in_reason

EagleML/referenceTransaction/rating/ratingDataModel/reason
approvedBy			string	1675	in_approved_by	SECURITYDBO	RATINGS	APPROVED_BY

1675

CHAR(255)

in_approved_by

	EagleML/referenceTransaction/rating/ratingDataModel/approvedBy
submittedBy			string	1676	in_submitted_by	SECURITYDBO	RATINGS	SUBMITTED_BY

1676

CHAR(255)

in_submitted_by

	EagleML/referenceTransaction/rating/ratingDataModel/submittedBy
ratingComments			string	1677	in_rating_comments	SECURITYDBO	RATINGS	RATING_COMMENTS

1677

VARCHAR2(255)

in_rating_comments

	EagleML/referenceTransaction/rating/ratingDataModel/ratingComments
approvalComments			string	1678	in_approval_comments	SECURITYDBO	RATINGS	APPROVAL_COMMENTS

1678

VARCHAR2(255)

in_approval_comments

EagleML/referenceTransaction/rating/ratingDataModel/approvalComments
submittedDate			string	1679	in_submitted_date	SECURITYDBO	RATINGS	SUBMITTED_DATE

1679

DATE

in_submitted_date

	EagleML/referenceTransaction/rating/ratingDataModel/submittedDate
ipoFlag			integer	1680	in_ipo_flag	SECURITYDBO	RATINGS	IPO_FLAG

1680

NUMBER

in_ipo_flag

EagleML/referenceTransaction/rating/ratingDataModel/ipoFlag
offeringPrice			decimal	1681	in_offering_price	SECURITYDBO	RATINGS	OFFERING_PRICE

1681

NUMBER(28,12)

in_offering_price

EagleML/referenceTransaction/rating/ratingDataModel/offeringPrice
ipoVerifyFlag			integer	1682	in_ipo_verify_flag	SECURITYDBO	RATINGS	IPO_VERIFY_FLAG

1682

NUMBER

in_ipo_verify_flag

	EagleML/referenceTransaction/rating/ratingDataModel/ipoVerifyFlag
provider			string	1683	in_provider	SECURITYDBO	RATINGS	PROVIDER

1683

CHAR(12)

in_provider

	EagleML/referenceTransaction/rating/ratingDataModel/provider
ratingCode	Required - Defaulted to "Source Name" by Panel		string	1165, 3639	in_rating_code	SECURITYDBO	RATINGS	RATING_CODE

1165, 3639

VARCHAR2(12)

in_rating_code

EagleML/referenceTransaction/rating/ratingDataModel/ratingCode
ratingTypeIndicator			string	3640	in_rating_type_indicator	SECURITYDBO	RATINGS	RATING_TYPE_INDICATOR

3640

VARCHAR2(20)

in_rating_type_indicator

	EagleML/referenceTransaction/rating/ratingDataModel/ratingTypeIndicator
program			string	3641	in_program	SECURITYDBO	RATINGS	PROGRAM

3641

VARCHAR2(20)

in_program

	EagleML/referenceTransaction/rating/ratingDataModel/program
ratingEnhanc			string	3642	in_rating_enhanc	SECURITYDBO	RATINGS	RATING_ENHANC

3642

VARCHAR2(12)

in_rating_enhanc

	EagleML/referenceTransaction/rating/ratingDataModel/ratingEnhanc
auditAlphaRating			string	3637	in_audit_alpha_rating	SECURITYDBO	RATINGS	AUDIT_ALPHA_RATING

3637

VARCHAR2(8)

in_audit_alpha_rating

	EagleML/referenceTransaction/rating/ratingDataModel/auditAlphaRating
auditDate			string	3638	in_audit_date	SECURITYDBO	RATINGS	AUDIT_DATE

3638

DATE

in_audit_date

	EagleML/referenceTransaction/rating/ratingDataModel/auditDate
ratingChar1			string	3649	in_rating_char1	SECURITYDBO	RATINGS	RATING_CHAR1

3649

VARCHAR2(60)

in_rating_char1

	EagleML/referenceTransaction/rating/ratingDataModel/ratingChar1
ratingChar2			string	3650	in_rating_char2	SECURITYDBO	RATINGS	RATING_CHAR2

3650

VARCHAR2(60)

in_rating_char2

EagleML/referenceTransaction/rating/ratingDataModel/ratingChar2
ratingChar3			string	3651	in_rating_char3	SECURITYDBO	RATINGS	RATING_CHAR3

3651

VARCHAR2(60)

in_rating_char3

	EagleML/referenceTransaction/rating/ratingDataModel/ratingChar3
ratingChar4			string	3652	in_rating_char4	SECURITYDBO	RATINGS	RATING_CHAR4

3652

VARCHAR2(60)

in_rating_char4

	EagleML/referenceTransaction/rating/ratingDataModel/ratingChar4
ratingChar5			string	3653	in_rating_char5	SECURITYDBO	RATINGS	RATING_CHAR5

3653

VARCHAR2(60)

in_rating_char5

	EagleML/referenceTransaction/rating/ratingDataModel/ratingChar5
ratingChar6			string	3654	in_rating_char6	SECURITYDBO	RATINGS	RATING_CHAR6

3654

VARCHAR2(60)

in_rating_char6

EagleML/referenceTransaction/rating/ratingDataModel/ratingChar6
ratingChar7			string	3655	in_rating_char7	SECURITYDBO	RATINGS	RATING_CHAR7

3655

VARCHAR2(60)

in_rating_char7

EagleML/referenceTransaction/rating/ratingDataModel/ratingChar7
ratingChar8			string	3656	in_rating_char8	SECURITYDBO	RATINGS	RATING_CHAR8

3656

VARCHAR2(60)

in_rating_char8

	EagleML/referenceTransaction/rating/ratingDataModel/ratingChar8
ratingChar9			string	3657	in_rating_char9	SECURITYDBO	RATINGS	RATING_CHAR9

3657

VARCHAR2(60)

in_rating_char9

EagleML/referenceTransaction/rating/ratingDataModel/ratingChar9
ratingChar10			string	3658	in_rating_char10	SECURITYDBO	RATINGS	RATING_CHAR10

3658

VARCHAR2(60)

in_rating_char10

EagleML/referenceTransaction/rating/ratingDataModel/ratingChar10
ratingChar11			string	3823	in_rating_char11	SECURITYDBO	RATINGS	RATING_CHAR11

3823

VARCHAR2(60)

in_rating_char11

EagleML/referenceTransaction/rating/ratingDataModel/ratingChar11
ratingChar12			string	3824	in_rating_char12	SECURITYDBO	RATINGS	RATING_CHAR12

3824

VARCHAR2(60)

in_rating_char12

EagleML/referenceTransaction/rating/ratingDataModel/ratingChar12
ratingChar13			string	3825	in_rating_char13	SECURITYDBO	RATINGS	RATING_CHAR13

3825

VARCHAR2(60)

in_rating_char13

EagleML/referenceTransaction/rating/ratingDataModel/ratingChar13
ratingChar14			string	3826	in_rating_char14	SECURITYDBO	RATINGS	RATING_CHAR14

3826

VARCHAR2(60)

in_rating_char14

	EagleML/referenceTransaction/rating/ratingDataModel/ratingChar14
ratingChar15			string	3827	in_rating_char15	SECURITYDBO	RATINGS	RATING_CHAR15

3827

VARCHAR2(60)

in_rating_char15

	EagleML/referenceTransaction/rating/ratingDataModel/ratingChar15
ratingChar16			string	3828	in_rating_char16	SECURITYDBO	RATINGS	RATING_CHAR16

3828

VARCHAR2(60)

in_rating_char16

EagleML/referenceTransaction/rating/ratingDataModel/ratingChar16
ratingChar17			string	3829	in_rating_char17	SECURITYDBO	RATINGS	RATING_CHAR17

3829

VARCHAR2(60)

in_rating_char17

	EagleML/referenceTransaction/rating/ratingDataModel/ratingChar17
ratingChar18			string	3830	in_rating_char18	SECURITYDBO	RATINGS	RATING_CHAR18

3830

VARCHAR2(60)

in_rating_char18

EagleML/referenceTransaction/rating/ratingDataModel/ratingChar18
ratingChar19			string	3831	in_rating_char19	SECURITYDBO	RATINGS	RATING_CHAR19

3831

VARCHAR2(60)

in_rating_char19

EagleML/referenceTransaction/rating/ratingDataModel/ratingChar19
ratingChar20			string	3832	in_rating_char20	SECURITYDBO	RATINGS	RATING_CHAR20

3832

VARCHAR2(60)

in_rating_char20

	EagleML/referenceTransaction/rating/ratingDataModel/ratingChar20
ratingDate1			string	3643	in_rating_date1	SECURITYDBO	RATINGS	RATING_DATE1

3643

DATE

in_rating_date1

	EagleML/referenceTransaction/rating/ratingDataModel/ratingDate1
ratingDate2			string	3644	in_rating_date2	SECURITYDBO	RATINGS	RATING_DATE2

3644

DATE

in_rating_date2

	EagleML/referenceTransaction/rating/ratingDataModel/ratingDate2
ratingDate3			string	3645	in_rating_date3	SECURITYDBO	RATINGS	RATING_DATE3

3645

DATE

in_rating_date3

	EagleML/referenceTransaction/rating/ratingDataModel/ratingDate3
ratingFloat1			decimal	3646	in_rating_float1	SECURITYDBO	RATINGS	RATING_FLOAT1

3646

NUMBER(28,12)

in_rating_float1

	EagleML/referenceTransaction/rating/ratingDataModel/ratingFloat1
ratingFloat2			decimal	3647	in_rating_float2	SECURITYDBO	RATINGS	RATING_FLOAT2

3647

NUMBER(28,12)

in_rating_float2

EagleML/referenceTransaction/rating/ratingDataModel/ratingFloat2
ratingFloat3			decimal	3648	in_rating_float3	SECURITYDBO	RATINGS	RATING_FLOAT3

3648

NUMBER(28,12)

in_rating_float3

EagleML/referenceTransaction/rating/ratingDataModel/ratingFloat3
securityAlias			integer	10	in_security_alias	SECURITYDBO	RATINGS	SECURITY_ALIAS

10

NUMBER

in_security_alias

	EagleML/referenceTransaction/rating/ratingDataModel/securityAlias
ratingSrc			string

SECURITYDBO

1102

RATINGS

SRC

in_

INTFC

rating_

INST

src

1102

PACE_MASTERDBO

NUMBER

INTERFACES

in_rating_srcRATINGS

SHORT_DESC	CHAR(15)	EagleML/referenceTransaction/rating/ratingDataModel/ratingSrc
sourceDescription	extract only		string

SECURITYDBO

PACE_MASTERDBO

INTERFACES

LONG_DESC

CHAR(50)

EagleML/referenceTransaction/rating/ratingDataModel/sourceDescription

Versions Compared

Old Version 7

New Version Current

Key

Anchor

ratingDataModel

ratingDataModel
RatingDataModel Table

Page Comparison

Versions Compared

Old Version 7

New Version Current

Key

Anchor

ratingDataModel

ratingDataModelRatingDataModel Table

ratingDataModel
RatingDataModel Table