Rating Data Map Table
Element | Required Inbound Acct Validation | Required Inbound Data Mgt | Value Type | Star Tag | SP Parameter | Eagle DB | DB Table | DB Field | Data Type | XPath |
---|---|---|---|---|---|---|---|---|---|---|
objectType | Required | ObjectTypeEnum | not stored in DB | EagleML/referenceTransaction/rating/objectType | ||||||
objectId | ObjectId | not stored in DB | EagleML/referenceTransaction/rating/objectId | |||||||
objectDescription | FeedTypeEnum | not stored in DB | EagleML/referenceTransaction/rating/objectDescription | |||||||
updateTimestamp | dateTime | SECURITYDBO | RATINGS | UPDATE_DATE | EagleML/referenceTransaction/rating/updateTimestamp | |||||
customElements | Not recommended | CustomElements - Complex type - reserved for customizations | EagleML/referenceTransaction/rating/customElements | |||||||
sourceName | Required | string | 1102 | PACE_MASTERDBO | INTERFACES | SHORT_DESC | CHAR(15) | EagleML/referenceTransaction/rating/sourceName | ||
updateSource | string | 944 | in_update_source | SECURITYDBO | RATINGS | UPDATE_SOURCE | VARCHAR2(255) | EagleML/referenceTransaction/rating/updateSource | ||
effectiveDate | Required | date | 1109 | in_effective_date | SECURITYDBO | RATINGS | EFFECTIVE_DATE | DATE | EagleML/referenceTransaction/rating/effectiveDate | |
languageId | integer | not stored in DB | EagleML/referenceTransaction/rating/languageId | |||||||
tagNochangecase | string | not stored in DB | EagleML/referenceTransaction/rating/tagNochangecase | |||||||
preserveNull | string | not stored in DB | EagleML/referenceTransaction/rating/preserveNull | |||||||
noLoadValidationFlag | YesNoOptionEnum | not stored in DB | EagleML/referenceTransaction/rating/noLoadValidationFlag | |||||||
Asset Identifiers Model | EagleML/referenceTransaction/rating/ | |||||||||
ratingDataModel | RatingDataModel - Complex type (see the table below) | EagleML/referenceTransaction/rating/ratingDataModel/ | ||||||||
The above section of the EagleML is around asset resolution, which is necessary for resolving the security but is not actually stored in the database when working with Ratings. Only the ratings model below is actually stored in the database RatingDataModel Table | ||||||||||
alphaRating | Required | string | 1671 | in_alpha_rating | SECURITYDBO | RATINGS | ALPHA_RATING | CHAR(8) | EagleML/referenceTransaction/rating/ratingDataModel/alphaRating | |
numericalRating | decimal | 1672 | in_numerical_rating | SECURITYDBO | RATINGS | NUMERICAL_RATING | NUMBER(28,12) | EagleML/referenceTransaction/rating/ratingDataModel/numericalRating | ||
analystCode | string | 1673 | in_analyst_code | SECURITYDBO | RATINGS | ANALYST_CODE | CHAR(8) | EagleML/referenceTransaction/rating/ratingDataModel/analystCode | ||
reason | string | 1674 | in_reason | SECURITYDBO | RATINGS | REASON | VARCHAR2(255), | EagleML/referenceTransaction/rating/ratingDataModel/reason | ||
approvedBy | string | 1675 | in_approved_by | SECURITYDBO | RATINGS | APPROVED_BY | CHAR(255) | EagleML/referenceTransaction/rating/ratingDataModel/approvedBy | ||
submittedBy | string | 1676 | in_submitted_by | SECURITYDBO | RATINGS | SUBMITTED_BY | CHAR(255) | EagleML/referenceTransaction/rating/ratingDataModel/submittedBy | ||
ratingComments | string | 1677 | in_rating_comments | SECURITYDBO | RATINGS | RATING_COMMENTS | VARCHAR2(255) | EagleML/referenceTransaction/rating/ratingDataModel/ratingComments | ||
approvalComments | string | 1678 | in_approval_comments | SECURITYDBO | RATINGS | APPROVAL_COMMENTS | VARCHAR2(255) | EagleML/referenceTransaction/rating/ratingDataModel/approvalComments | ||
submittedDate | string | 1679 | in_submitted_date | SECURITYDBO | RATINGS | SUBMITTED_DATE | DATE | EagleML/referenceTransaction/rating/ratingDataModel/submittedDate | ||
ipoFlag | integer | 1680 | in_ipo_flag | SECURITYDBO | RATINGS | IPO_FLAG | NUMBER | EagleML/referenceTransaction/rating/ratingDataModel/ipoFlag | ||
offeringPrice | decimal | 1681 | in_offering_price | SECURITYDBO | RATINGS | OFFERING_PRICE | NUMBER(28,12) | EagleML/referenceTransaction/rating/ratingDataModel/offeringPrice | ||
ipoVerifyFlag | integer | 1682 | in_ipo_verify_flag | SECURITYDBO | RATINGS | IPO_VERIFY_FLAG | NUMBER | EagleML/referenceTransaction/rating/ratingDataModel/ipoVerifyFlag | ||
provider | string | 1683 | in_provider | SECURITYDBO | RATINGS | PROVIDER | CHAR(12) | EagleML/referenceTransaction/rating/ratingDataModel/provider | ||
ratingCode | Required - Defaulted to "Source Name" by Panel | string | 1165, 3639 | in_rating_code | SECURITYDBO | RATINGS | RATING_CODE | VARCHAR2(12) | EagleML/referenceTransaction/rating/ratingDataModel/ratingCode | |
ratingTypeIndicator | string | 3640 | in_rating_type_indicator | SECURITYDBO | RATINGS | RATING_TYPE_INDICATOR | VARCHAR2(20) | EagleML/referenceTransaction/rating/ratingDataModel/ratingTypeIndicator | ||
program | string | 3641 | in_program | SECURITYDBO | RATINGS | PROGRAM | VARCHAR2(20) | EagleML/referenceTransaction/rating/ratingDataModel/program | ||
ratingEnhanc | string | 3642 | in_rating_enhanc | SECURITYDBO | RATINGS | RATING_ENHANC | VARCHAR2(12) | EagleML/referenceTransaction/rating/ratingDataModel/ratingEnhanc | ||
auditAlphaRating | string | 3637 | in_audit_alpha_rating | SECURITYDBO | RATINGS | AUDIT_ALPHA_RATING | VARCHAR2(8) | EagleML/referenceTransaction/rating/ratingDataModel/auditAlphaRating | ||
auditDate | string | 3638 | in_audit_date | SECURITYDBO | RATINGS | AUDIT_DATE | DATE | EagleML/referenceTransaction/rating/ratingDataModel/auditDate | ||
ratingChar1 | string | 3649 | in_rating_char1 | SECURITYDBO | RATINGS | RATING_CHAR1 | VARCHAR2(60) | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar1 | ||
ratingChar2 | string | 3650 | in_rating_char2 | SECURITYDBO | RATINGS | RATING_CHAR2 | VARCHAR2(60) | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar2 | ||
ratingChar3 | string | 3651 | in_rating_char3 | SECURITYDBO | RATINGS | RATING_CHAR3 | VARCHAR2(60) | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar3 | ||
ratingChar4 | string | 3652 | in_rating_char4 | SECURITYDBO | RATINGS | RATING_CHAR4 | VARCHAR2(60) | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar4 | ||
ratingChar5 | string | 3653 | in_rating_char5 | SECURITYDBO | RATINGS | RATING_CHAR5 | VARCHAR2(60) | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar5 | ||
ratingChar6 | string | 3654 | in_rating_char6 | SECURITYDBO | RATINGS | RATING_CHAR6 | VARCHAR2(60) | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar6 | ||
ratingChar7 | string | 3655 | in_rating_char7 | SECURITYDBO | RATINGS | RATING_CHAR7 | VARCHAR2(60) | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar7 | ||
ratingChar8 | string | 3656 | in_rating_char8 | SECURITYDBO | RATINGS | RATING_CHAR8 | VARCHAR2(60) | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar8 | ||
ratingChar9 | string | 3657 | in_rating_char9 | SECURITYDBO | RATINGS | RATING_CHAR9 | VARCHAR2(60) | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar9 | ||
ratingChar10 | string | 3658 | in_rating_char10 | SECURITYDBO | RATINGS | RATING_CHAR10 | VARCHAR2(60) | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar10 | ||
ratingChar11 | string | 3823 | in_rating_char11 | SECURITYDBO | RATINGS | RATING_CHAR11 | VARCHAR2(60) | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar11 | ||
ratingChar12 | string | 3824 | in_rating_char12 | SECURITYDBO | RATINGS | RATING_CHAR12 | VARCHAR2(60) | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar12 | ||
ratingChar13 | string | 3825 | in_rating_char13 | SECURITYDBO | RATINGS | RATING_CHAR13 | VARCHAR2(60) | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar13 | ||
ratingChar14 | string | 3826 | in_rating_char14 | SECURITYDBO | RATINGS | RATING_CHAR14 | VARCHAR2(60) | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar14 | ||
ratingChar15 | string | 3827 | in_rating_char15 | SECURITYDBO | RATINGS | RATING_CHAR15 | VARCHAR2(60) | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar15 | ||
ratingChar16 | string | 3828 | in_rating_char16 | SECURITYDBO | RATINGS | RATING_CHAR16 | VARCHAR2(60) | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar16 | ||
ratingChar17 | string | 3829 | in_rating_char17 | SECURITYDBO | RATINGS | RATING_CHAR17 | VARCHAR2(60) | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar17 | ||
ratingChar18 | string | 3830 | in_rating_char18 | SECURITYDBO | RATINGS | RATING_CHAR18 | VARCHAR2(60) | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar18 | ||
ratingChar19 | string | 3831 | in_rating_char19 | SECURITYDBO | RATINGS | RATING_CHAR19 | VARCHAR2(60) | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar19 | ||
ratingChar20 | string | 3832 | in_rating_char20 | SECURITYDBO | RATINGS | RATING_CHAR20 | VARCHAR2(60) | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar20 | ||
ratingDate1 | string | 3643 | in_rating_date1 | SECURITYDBO | RATINGS | RATING_DATE1 | DATE | EagleML/referenceTransaction/rating/ratingDataModel/ratingDate1 | ||
ratingDate2 | string | 3644 | in_rating_date2 | SECURITYDBO | RATINGS | RATING_DATE2 | DATE | EagleML/referenceTransaction/rating/ratingDataModel/ratingDate2 | ||
ratingDate3 | string | 3645 | in_rating_date3 | SECURITYDBO | RATINGS | RATING_DATE3 | DATE | EagleML/referenceTransaction/rating/ratingDataModel/ratingDate3 | ||
ratingFloat1 | decimal | 3646 | in_rating_float1 | SECURITYDBO | RATINGS | RATING_FLOAT1 | NUMBER(28,12) | EagleML/referenceTransaction/rating/ratingDataModel/ratingFloat1 | ||
ratingFloat2 | decimal | 3647 | in_rating_float2 | SECURITYDBO | RATINGS | RATING_FLOAT2 | NUMBER(28,12) | EagleML/referenceTransaction/rating/ratingDataModel/ratingFloat2 | ||
ratingFloat3 | decimal | 3648 | in_rating_float3 | SECURITYDBO | RATINGS | RATING_FLOAT3 | NUMBER(28,12) | EagleML/referenceTransaction/rating/ratingDataModel/ratingFloat3 | ||
securityAlias | integer | 10 | in_security_alias | SECURITYDBO | RATINGS | SECURITY_ALIAS | NUMBER | EagleML/referenceTransaction/rating/ratingDataModel/securityAlias | ||
ratingSrc | string | 1102 | in_rating_src | PACE_MASTERDBO | INTERFACES | SHORT_DESC | CHAR(15) | EagleML/referenceTransaction/rating/ratingDataModel/ratingSrc | ||
sourceDescription | extract only | string | PACE_MASTERDBO | INTERFACES | LONG_DESC | CHAR(50) | EagleML/referenceTransaction/rating/ratingDataModel/sourceDescription |