/
Warehouse Open Lot - Extended Ratings Model Data Map Table

Warehouse Open Lot - Extended Ratings Model Data Map Table

Owned by Natalie Gesin (Deactivated)
Last updated: Nov 07, 2024 by Kinga Huszno
1 min read

Element

Comment

Value Type

Star Tag

SP Parameter

Eagle DB

DB Table

DB Field

DB Field Type

Xpath

Element

Comment

Value Type

Star Tag

SP Parameter

Eagle DB

DB Table

DB Field

DB Field Type

Xpath

extendedRatingModel

 

extendedRatingModel - see extra table below

../extendedRatingsModel/extendedRatingModel/

extendedRatingModel Data Map Table

Element

Comment

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