| Element | Optional/Required | 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/ | ||||||
| extendedRatingModel Data Map Table | |||||||||
| Element | Optional/Required | 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 | Optional | date | SECURITYDBO | RATINGS | EFFECTIVE_DATE | DATE | /extendedRatingsModel/extendedRatingModel/ratingEffectiveDate | ||
| ISSUER_RATINGS | DATE | ||||||||
| ratingSourceName | Optional | /extendedRatingsModel/extendedRatingModel/ratingSourceName | |||||||
| Element | Optional/Required | 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/ | ||||||
extendedRatingModel Data Map Table | |||||||||
| Element | Optional/Required | 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 | Optional | date | SECURITYDBO | RATINGS | EFFECTIVE_DATE | DATE | /extendedRatingsModel/extendedRatingModel/ratingEffectiveDate | ||
| ISSUER_RATINGS | DATE | ||||||||
| ratingSourceName | Optional | /extendedRatingsModel/extendedRatingModel/ratingSourceName | |||||||