Element | Optional/Required | Value Type | Star Tag | SP Parameter | Eagle DB | DB Table | DB Field | DB Field Type | Xpath |
---|
extendedRatingModel |
Optional | 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 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 | Anchor |
---|
| extendedRatingModel |
---|
| 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 |
|
|
|