| Element | Optional/RequiredComment | Value Type | Star Tag | SP Parameter | Eagle DB | DB Table | DB Field | DB Field Type | Xpath |
|---|
| extendedRatingModel |
| extendedRatingModel - see extra table below | ../extendedRatingsModel/extendedRatingModel/ |
| Anchor |
|---|
| extendedRatingModel |
|---|
| extendedRatingModel |
|---|
|
extendedRatingModel Data Map Table |
| Element | Optional/RequiredComment | Value Type | Star Tag | SP Parameter | Eagle DB | DB Table | DB Field | DB Field Type | Xpath |
|---|
| alphaRating |
| StringWithCodeScheme | 1671 | in_alpha_rating | SECURITYDBO | RATINGS | ALPHA_RATING | CHAR(20) | ../extendedRatingsModel/extendedRatingModel/alphaRating |
| 3349 | ISSUER_RATINGS | CHAR(8) |
| numericalRating |
| decimal | 1672 | in_numerical_rating | SECURITYDBO | RATINGS | NUMERICAL_RATING | NUMBER(28,12) | ../extendedRatingsModel/extendedRatingModel/numericalRating |
| 3350 | ISSUER_RATINGS | NUMBER(28,12) |
| ratingEffectiveDate |
| date |
|
| SECURITYDBO | RATINGS | EFFECTIVE_DATE | DATE | ../extendedRatingsModel/extendedRatingModel/ratingEffectiveDate |
| ISSUER_RATINGS | DATE |
| ratingSourceName |
| string |
|
| SECURITYDBO | RATINGS | SRC_INTFC_INST |
| ../extendedRatingsModel/extendedRatingModel/ratingSourceName |
| ISSUER_RATINGS |
|