Versions Compared

Old Version 4

changes.mady.by.user Dmitry Donosiyan (Unlicensed)

Saved on

compared with

New Version Current

changes.mady.by.user Kinga Huszno

Saved on

Key

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

Element

Optional/Required

Comment

Value Type

Star Tag

SP Parameter

Eagle DB

DB Table

DB Field

DB Field Type

Xpath

extendedRatingModel

Optional

extendedRatingModel - see extra table below

../extendedRatingsModel/extendedRatingModel/

Anchor
extendedRatingModel
extendedRatingModel
extendedRatingModel Data Map Table

Element

Optional/Required

Comment

Value Type

Star Tag

SP Parameter

Eagle DB

DB Table

DB Field

DB Field Type

Xpath

alphaRating

Optional

StringWithCodeScheme

1671

in_alpha_rating

SECURITYDBO

RATINGS

ALPHA_RATING

CHAR(20)

../extendedRatingsModel/extendedRatingModel/alphaRating

3349

ISSUER_RATINGS

CHAR(8)

numericalRating

Optional

decimal

1672

in_numerical_rating

SECURITYDBO

RATINGS

NUMERICAL_RATING

NUMBER(28,12)

../extendedRatingsModel/extendedRatingModel/numericalRating

3350

ISSUER_RATINGS

NUMBER(28,12)

ratingEffectiveDate

OptionalElementOptional/RequiredValue TypeStar TagSP ParameterEagle DBDB TableDB FieldDB Field TypeXpathextendedRatingModelOptionalextendedRatingModel - see extra table below/extendedRatingsModel/extendedRatingModel/

extendedRatingModel Data Map Table

ElementOptional/RequiredValue TypeStar TagSP ParameterEagle DBDB TableDB FieldDB Field TypeXpathalphaRatingOptionalStringWithCodeScheme1671in_alpha_rating

date

SECURITYDBO

RATINGS

EFFECTIVE_DATE

DATE

../extendedRatingsModel/extendedRatingModel/ratingEffectiveDate

ISSUER_RATINGS

DATE

ratingSourceName

Optional/extendedRatingsModel/extendedRatingModel/ratingSourceName

numericalRatingOptionaldecimal1672in_numerical_ratingSECURITYDBORATINGSNUMERICAL_RATINGNUMBER(28,12)

string

SECURITYDBO

RATINGS

ALPHA_RATINGCHAR(20)/extendedRatingsModel/extendedRatingModel/alphaRating3349ISSUER_RATINGSCHAR(8)

SRC_INTFC_INST

../extendedRatingsModel/extendedRatingModel/

numericalRating3350

ratingSourceName

ISSUER_RATINGS

NUMBER(28,12)ratingEffectiveDateOptionaldateSECURITYDBORATINGSEFFECTIVE_DATEDATE/extendedRatingsModel/extendedRatingModel/ratingEffectiveDateISSUER_RATINGSDATEratingSourceNameOptional/extendedRatingsModel/extendedRatingModel/ratingSourceName