...
| Element | Optional/Required | Value Type | Star Tag | SP Parameter | Eagle DB | DB Table | DB Field | DB Field Type | Xpath | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| extendedRatingModel | extendedRatingModel - see extra table below | ../extendedRatingsModel/extendedRatingModel/ | |||||||||||||
| |||||||||||||||
| Element | Optional/Required | 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 | ../extendedRatingsModel/extendedRatingModel/ratingSourceName | ||||||||||||||
...